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

218 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
donjons153673(None) 
donjon1436461donjon_
bonbons1139332bonbons
conjoins1738132conjoins
doblons1037042doblons
dobsons1036202dobsons
dojos135111792do_jo_s
donors75115792don_ors
onions64016432_onions
pontons93315552pontons
ronions73313342ronions
ronyons10258432ronyons
wontons103310532wontons
amnions93710913amnions
anions64123033_anions
anyons94513503_anyons
banjoes16317313banjoes
banjos15378893banjo_s
bolsons969483bolsons
bonbon10310073bonbon_
bongoes104314113bongoes
bongos95316653bongo_s
boons75031913bo__ons
borons85520543bo_rons
bosons85016653bo_sons
bostons9312903bostons
boutons9310783boutons
bunions92210473bunions
cannons94412883cannons
canons85522063can_ons
cantons95221203cantons
canyons124511593canyons
cocoons11310563cocoons
codons96119463co_dons
cogons96818113co_gons
cojoins1638993co_joins
cojones163512103co_jones
colons86028683co_lons
commons13311043commons
condoes104319203condoes
condoms124214083condoms
condone102616293condone
condones112817393condones
condors104018573condors
condos94322333condo_s
congoes103617303congoes
congos94219883congo_s
congous103615083congous
conins84327233con_ins
conjoin1638203conjoin
conjoint17410373conjoint
conns75024233con__ns
consols92914073consols
contos84923233conto_s
convoys15267023convoys
coons76737283co__ons
cordons104415763cordons
cottons9312193cottons
coupons112710563coupons
dacrons103211033dacrons
daemons10269233daemons
dahoons1137753dahoons
daikons12186693daikons
daimons10249323daimons
daltons8310403daltons
damsons1038013damsons
danios7314603danio_s
deacons10310393deacons
demons94917723d_emons
dendrons1047393dendrons
dentins83419223dentins
devons104512253d_evons
dingoes94114833dingoes
dinos65428063din_o_s
disjoins1647623disjoins
diurons838823diurons
djins1368453d__jins
dobbins12379533dobbins
doblon938013doblon_
doblones1136763doblones
dobros93910233dobro_s
dobson936593dobson_
doctors1039993doctors
dodoes85716103do_does
dodos75819393do_do_s
dogdoms1295423dogdoms
doggone1035683doggone
doggones1135713doggones
dojo126016143do_jo__
dollops10287963dollops
dolmans10479683dolmans
dolmens10388693dolmens
dolors75115313do_lors
domains10510873domains
dominions12126553dominions
dominos103210193dominos
donas65926473don__as
donates83217223donates
donations101112353donations
donators9310403donators
donees74519493don_ees
dongas84914613don_gas
dongles93212873dongles
dongola945473dongola
dongolas1045343dongolas
dongs76525813don__gs
donkeys15426663donkeys
donna66215033don__na
donnas75511323don_nas
donne65520463don__ne
donnees84210363donnees
donning93512763donning
donor64418193don_o_r
dons56048703d___ons
donuts7410583don_uts
donzels1735393donzels
doodoos9107623doodoos
dooms85321343do__oms
doors65022133do__ors
doowops1363943doowops
dormins10311273dormins
dovens104413903do_vens
downbows1783693downbows
downs94918573do__wns
downtowns1642933downtowns
downzone21134273downzone
downzones22123843downzones
doyens104810223do_yens
dozens164612463do_zens
dragons938383dragons
dromons1038193dromons
drongos935493drongo_s
dungeons10124623dungeons
dunlins849553dunlins
durions839963durions
dyneins1134213dyneins
enjoins1457333_enjoins
enjoys1644603_enjoys
fanions103713073fanions
fanons96115213fan_ons
foisons1047613foisons
frontons1136503frontons
gnomons1035753gnomons
godsons966663godsons
gonion73612833gonion_
gonofs10459863gon_ofs
goons65326773go__ons
gorgons938853gorgons
honans94814503hon_ans
honors94816793hon_ors
idoneous944573idoneous
inions64417003_inions
ionone6313443ion_one
ionones7313883ion_ones
johnsons1842383johnsons
logions86211293logions
logons79818173lo_gons
longans84510813longans
loons55731723lo__ons
lotions74614763lotions
minions93314623minions
mojoes15399523mo_joes
mojos145314463mo_jo_s
monaxons1744813monaxons
mondos95217333mondo_s
mongoes103415713mongoes
mongols103310823mongols
mongos94318623mongo_s
monos75930863mon_o_s
monsoons1047343monsoons
monurons1037093monurons
moons75331003mo__ons
morions94014643morions
morons84919543mo_rons
motions94215003motions
moutons9410313moutons
neons55818683__neons
ninons64913773nin_ons
nonagons947223nonagons
noncoms1139203noncoms
nonfans1037533nonfans
noons54125283__noons
notions74014483notions
odeons739023_odeons
onion54320973_onion_
oniony9369703_oniony
onos46229003_on_o_s
orlons6411013_orlons
pennons939713pennons
phonons123310253phon_ons
pinions93413603pinions
pinons86019943pin_ons
pinyons12299003pinyons
poisons9310353poisons
pompons1338553pompons
ponton83217643ponton_
pontoons10279313pontoons
poons75430973po__ons
potions93417423potions
rondos74616733rondo_s
ronion63315643ronion_
ronyon9309133ronyon_
solions7513753solions
solons65120023so_lons
sponsons1045813sponsons
tendons8311473tendons
tenons62916603ten_ons
tondos75115923tondo_s
toons55027533to__ons
toyons95512133to_yons
unions64216753_unions
voudons1135323voudons
wanions104011373wanions
wantons103713013wantons
wonton93410963wonton_
xenons132710483xen_ons
youpons12265983youpons
zoons144919693zo__ons

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit1340272186.06322105.7
3Display Results2182180.0802725.0
 (SQL Overall)1786912186.54627297.7
 
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.