Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “defraying” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

160 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
defraying173585(None) 
affraying1943102affraying
betraying1537712betraying
bewraying1834872bewraying
decaying15239452de_caying
decrying15237412decr_ying
deejaying2142752deejaying
defacing15238682def_acing
defaming15238462def_aming
defeating142311972defeating
deflating142610712deflating
defoaming1645652defoaming
defragging1742822defragging
defrauding1642922defrauding
defying15328822def__ying
degrading13137372degrading
delaying133210972de_laying
depraving1635972depraving
derating103222282de_rating
draying123813842d__raying
fraying143413432__fraying
reframing1538622reframing
refrying15278902refr_ying
aerating92821003ae_rating
arraying1238753_arraying
bedraping1535383bedraping
belaying143110603be_laying
bendaying1634953bendaying
beraking153612973be_raking
berating113220763be_rating
berrying14137383be_rrying
braying134416313__braying
dairying1336353dair_ying
deaerating12311563deaerating
dealing94323233de__aling
deaning94020473de__aning
deaving123814753de__aving
debarking1735383debarking
debarring1335713debarring
debasing12238063de_basing
debating123213733de_bating
debeaking1735923debeaking
debriding1446483debriding
deceasing1338403deceasing
declaring1339573declaring
declawing1636213declawing
decorating14312073decorating
decoying15208763de_coying
decreasing1446513decreasing
decreeing1335523decreeing
defang1137753def_a__ng
defanging1535333defanging
defatting1436103defatting
defecating17237783defecating
defecting162510223defecting
defencing16226693defencing
defending15298353defending
defensing14217003defensing
deferring1436143deferring
defilading1643643defilading
defiling132812463def_iling
defining133711803def_ining
defleaing1444743defleaing
defogging1653863defogging
deforcing1636063deforcing
deforming1636703deforming
defrag1136463defra___g
defray1337643defray___
defrayal1542613defray_al
defrayals1642283defrayals
defrayed1635403defray_ed
defrayer1534933defray_er
defrayers1644173defrayers
defrays1436113defray__s
defrocking2143153defrocking
defrosting1544493defrosting
defueling14255093defueling
defunding15216123defunding
defusing13227933def_using
defuzing22195253def_uzing
deglazing2135133deglazing
degreasing1345423degreasing
deifying1637633de_ifying
delating103119603de_lating
deleading1237773deleading
deleaving1436263deleaving
demarking1736773demarking
demeaning1337243demeaning
denying123711293de__nying
departing1349513departing
deplaning1338053deplaning
deploying1636153deploying
depriving1636403depriving
depurating1438643depurating
deraign936573de_ra_ign
derailing112011313de_railing
deranging1238063de_ranging
deratting1139513de_ratting
deriding112512933de_riding
deriving132510743de_riving
descrying1635103descrying
destroying1564903destroying
detracting1438713detracting
detrain8412253detra_in_
detraining1267673detraining
detrains9411763detra_ins
detruding1245193detruding
deviating14311083deviating
dewaxing20215293de_waxing
dirtying1336093d_irtying
dismaying1656823dismaying
disrating11714553disrating
draping114213353d__raping
drawing123812053d__rawing
drying113411603d__r_ying
effacing1744463_effacing
embaying1635263_embaying
enframing1546113enframing
enraging1049573_enraging
erasing8317963_e_rasing
essaying1235033_essaying
estraying1338293estraying
faying134521073__f_aying
ferrying15146253fe_rrying
flaying143914463__flaying
foraying1537433_foraying
framing133014793__framing
frayings15325993__frayings
frying134511403__fr_ying
graying124115883__graying
herrying15147033he_rrying
hooraying1644783hooraying
hurraying1654323hurraying
praying133717323__praying
raying105027193___raying
recrating121318793recrating
redrawing1437213redrawing
redrying13209023redr_ying
refacing142512813ref_acing
reflating132514713reflating
reflying15268173ref_lying
refracting1638733refracting
refrain10310043refra_in_
refraining1437263refraining
refrains1139593refra_ins
regrading121210203regrading
regrating111316213regrating
relaying122515153re_laying
repaying142712393re_paying
replaying15259603replaying
resaying122512453re_saying
respraying1636093respraying
retracing12313293retracing
retrying122410453retr_ying
serrating10513213serrating
serrying12167703se_rrying
spraying14299883_spraying
straying122912693_straying
terracing1237703terracing
wearying1546703wear_ying

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.423422437.4
2DLD Change Limit1486411606.70322175.3
3Display Results1601600.0762105.3
 (SQL Overall)1786911607.20224811.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.