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 “deforest” 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.

118 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
deforest123879(None) 
deforests1344371deforests
reforest1139961reforest
afforest1446342afforest
dearest83618672de_arest
deferent122712872deferent
deffest14308812def_fest
deforces14248402deforces_
deforested1543852deforested
deforms1337802deforms_
defrost1139552def_rost
deftest112611712def_test
demurest1137452demurest
forest94926742__forest
reforests1245532reforests
afforests1543733afforests
before11410153before__
befret11315963bef_re_t
befrets1237613bef_rets
daffiest1537853daffiest
daftest11248943daf_test
deadest93014883de_adest
deafest112911513de_afest
debones103315113debones_
decares102818533decares_
decodes113914983decodes_
decongest1345633decongest
decors94017773decor_s_
deediest102912253deediest
deepest10310443de_epest
defaces133213403defaces_
defames132812253defames_
defeat103817163def__eat
defect124816173def__ect
deferents13269393deferents
deferment151210303deferment
defers105116943defer_s_
defiers113913993defiers_
defies104624053def_ies_
defiles114016843defiles_
defines114118683defines_
deflect13399973def_lect
defoams1336193defoams_
defocus1335283defocus_
defogs1156683defo_gs_
deforce13267243defor_ce
deforced15247373deforced
deforcer14246903deforcer
deforcers15265503deforcers
deforesting1654793deforesting
deform1259633defor__m
deformed15248263deformed
deformer14247943deformer
deformers15266533deformers
deformity1843043deformity
defrosts1244833def_rosts
deftness1236303deftness
defuses114814593defuses_
defuzes20398303defuzes_
dehorns11428363dehorns_
dehort104618103dehor__t
dehorts11379773dehorts_
dekares122710873dekares_
demoness1138053demoness
demonist11413473demonist
demoses103815833demoses_
demotes104717673demotes_
demotist11311843demotist
denotes83817003denotes_
densest83112473de_nsest
deorbit1048173de_orbit
deplores1139533deplores_
deponent11410553deponent
depones103717093depones_
deport94922393depor__t
deports105012883deports_
deposes103117213deposes_
depress10239873de_press
desires81316133desires_
desorbs10437713desorbs_
detest74122843de__test
detoxes1538803detoxes_
devest104418703de__vest
devotes113713753devotes_
devoutest1343643devoutest
dewiest11312343de_wiest
deworms1338033deworms_
direst75024243d__irest
doest65829523d__o_est
dourest8312943d_ourest
drest65530343d___rest
fores85847103__fores_
forests104114953__forests
headrest122910203headrest
heftiest1439183heftiest
leftest10269463lef_test
merest84725113me__rest
nearest73415843ne_arest
poorest9312773_poorest
reafforest1652833reafforest
rearrest8311603rearrest
rebores95319163rebores_
referent112813423referent
refires104820313refires_
reforested1445393reforested
reforges12249333reforges_
reformat1357653reformat
reformist1445913reformist
reforms1239823reforms_
refresh1335453ref_resh
remotest103310723remotest
searest73322023se_arest
securest1058583securest
senores73218113senores_
serest64831613se__rest
severest11310323severest
sorest65028003__sorest
tenorist8413023tenorist

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621187.53319402.9
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.99922339.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.