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

244 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
donjon143646(None) 
donjons1536731donjons
bonbon10310072bonbon
conjoin1638202conjoin
doblon938012doblon
dobson936592dobson
dojo126016142do_jo_
dojos135111792do_jos
donor64418192don_or
gonion73612832gonion
onion54320972_onion
ponton83217642ponton
ronion63315642ronion
ronyon9309132ronyon
wonton93410962wonton
amnion84812053amnion
ancon75718233_ancon
anion55028813_anion
anon46134853_an_on
anyon85615223_anyon
banjo143812443banjo_
banjos15378893banjos
bolson8410683bolson
bonbons1139333bonbons
bongo85720943bongo_
bongos95316653bongos
boon67142173bo__on
boron76727143bo_ron
boson76019733bo_son
boston8513043boston
bouton8311533bouton
bunion83111313bunion
cajon144513903_cajon
cannon84514443cannon
canon74725303can_on
canton85722993canton
canyon114512033canyon
cocoon10312263cocoon
codon86522853co_don
cogon89120903co_gon
cojoin1539503co_join
colon78630193co_lon
common12310803common
condo85322593condo_
condom114215363condom
condone102616293condone
condor94616973condor
condos94322333condos
congo85623133congo_
congos94219883congos
congou94313243congou
conin76232723con_in
conjoins1738133conjoins
conjoint17410373conjoint
conn66229133con__n
consol82614113consol
conto76027173conto_
contos84923233contos
convoy14348543convoy
coon67248943co__on
cordon95017293cordon
cotton8312993cotton
coupon102810993coupon
dacron94310693dacron
daemon9279593daemon
dahoon1039053dahoon
daikon11217243daikon
daimon9259713daimon
dalton7311273dalton
damson938063damson
danio6319783danio_
danios7314603danios
deacon9510423deacon
demon86520313d_emon
dendron947653dendron
dentin73919573dentin
devon95113683d_evon
dingo74720793dingo_
dino56036753din_o_
dinos65428063din_os
disjoin1547643disjoin
diuron738573diuron
djin12911633d__jin
dobbin11339523dobbin
doblons1037043doblons
dobro84412213dobro_
dobros93910233dobros
dobsons1036203dobsons
doctor938993doctor
dodo66024913do_do_
dodos75819393do_dos
dogdom1186363dogdom
doggo84410703doggo_
doggone1035683doggone
dollop9259363dollop
dolman95312403dolman
dolmen93911373dolmen
dolor67617963do_lor
domain9511323domain
dominion11147033dominion
domino92611493domino
don46757653d___on
dona55529633don__a
donas65926473don_as
donate73619503donate
donation91513783donation
donator8310263donator
done55747913don__e
donee66931013don_ee
donees74519493donees
dong66031653don__g
donga76718423don_ga
dongas84914613dongas
dongle83612493dongle
dongola945473dongola
dongs76525813don_gs
donkey14449733donkey
donna66215033don_na
donnas75511323donnas
donne65520463don_ne
donned85015743donned
donnee74317063donnee
donning93512763donning
donors75115793donors
dons56048703don__s
donsie7613643donsie
donsy96414683don_sy
donut6324513don_ut
donuts7410583donuts
donzel1636313donzel
doodoo8108893doodoo
doom76430073do__om
door56928513do__or
doowop1283853doowop
dormin9312313dormin
doven94718553do_ven
down86427493do__wn
downbow1653393downbow
downtown1543293downtown
downzone21134273downzone
doyen95014413do_yen
dozen155017473do_zen
dragon838843dragon
dromon939363dromon
drongo836793drongo_
drongos935493drongos
dungeon9134553dungeon
dunlin739723dunlin
durion7510963durion
dynein1035563dynein
enjoin1357833_enjoin
enjoy1545963_enjoy
eonian6311833eonian
fanion94514323fanion
fanon84619013fan_on
foison948933foison
fronton1037203fronton
gnomon936183gnomon
godson857383godson
gonof95218653gon_of
gonzo15310243gonzo_
goon57236173go__on
gorgon8310243gorgon
honan85319773hon_an
honor85718623hon_or
inion54620183_inion
ionone6313443ion_one
johnson1742333johnson
jomon14610083jo_mon
logion76013723logion
logon615922313lo_gon
longan75612363longan
loon47344793lo__on
lotion65716523lotion
minion83416243minion
mojo136917223mo_jo_
mojos145314463mo_jos
monaxon1644913monaxon
mondo85721233mondo_
mondos95217333mondos
mongo810122413mongo_
mongoe94214983mongoe
mongol94912533mongol
mongos94318623mongos
mono66036723mon_o_
monos75930863mon_os
monsoon938493monsoon
monuron937463monuron
moon67140813mo__on
morion86217733morion
moron76925423mo_ron
motion85217553motion
mouton8410853mouton
neon47026423__neon
ninon55517383nin_on
nonagon847313nonagon
noncom1039683noncom
nonfan948293nonfan
noniron738373noniron
nonman8412363nonman
nonmen8412833nonmen
noon47134623__noon
notion64516583notion
odeon6411483_odeon
onions64016433_onions
oniony9369703_oniony
ono36838033_on_o_
onos46229003_on_os
onto46127663_onto_
orlon5415003_orlon
pennon8310643pennon
phonon114012033phon_on
pinion83815893pinion
pinon76024533pin_on
pinyon11459763pinyon
poison8312223poison
pompon1238943pompon
pontons93315553pontons
pontoon93010703pontoon
poon67341263po__on
potion84519573potion
rondo65218373rondo_
rondos74616733rondos
ronions73313343ronions
ronyons10258433ronyons
solion6616383solion
solon55026133so_lon
soon46240503so__on
sponson935383sponson
tendon7312033tendon
tenon53320513ten_on
tondo69718683tondo_
tondos75115923tondos
toon47740633to__on
toyon86715673to_yon
union54519793_union
unwon84512343_unwon
voudon1035873voudon
wanion93213063wanion
wanton94413813wanton
wontons103310533wontons
xenon122612453xen_on
youpon11366003youpon
zoon137326983zo__on

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162448.28013613.0
3Display Results2442440.1431706.3
 (SQL Overall)1786912448.56320867.8
 
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.