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

454 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
mouton841085(None) 
bouton8311531bouton
moutons9410311moutons
muton73817001m_uton
boston8513042boston
boutons9310782boutons
cotton8312992cotton
coupon102810992coupon
crouton947132crouton
futon83113772_futon
melton8311552melton
molten83311812molten
molto75619602molto_
monuron937462monuron
moon67140812mo__on
morion86217732morion
moron76925422mo_ron
motion85217552motion
motor75317292mo_tor
motto76119512motto_
mottos84615242mottos
mouflon12104082mouflon
moulin8313282moulin
mourn77215012mou_rn
mouth105420292mout_h
mouths115214532mouths
mouthy14409062mouthy
muon65722732m_u_on
mutons84314362m_utons
mutton8510452mutton
pluton838852pluton
ponton83217642ponton
puton73617912_puton
voudon1035872voudon
wonton93410962wonton
youpon11366002youpon
amotion9710473amotion
auto47432083_auto_
autos56523323_autos
baton75822423_baton
beton76022063_beton
blouson974893blouson
bolson8410683bolson
bonbon10310073bonbon
boon67142173bo__on
boron76727143bo_ron
boson76019733bo_son
bostons9312893bostons
bottom1048713bottom
boubou1038423boubou
boudin9412373boudin
bourbon1135813bourbon
bourdon1036423bourdon
bourn75518483bou_rn
bout66353293bout__
bouts75131313bout_s
burton8311273burton
button8310273button
canton85722993canton
carton84522663carton
caution93013513caution
chiton112612393chiton
cocoon10312263cocoon
codon86522853co_don
cogon89120903co_gon
coition9314313coition
colon78630193co_lon
common12310803common
conto76027173conto_
contos84923233contos
coon67248943co__on
cordon95017293cordon
cortin82423143cortin
cotan71521783co_tan
cottons9312193cottons
cottony1237253cottony
coupons112710553coupons
cousin8517153cousin
couter84930203couter
couth106122483cout_h
couths115715393couths
craton84517193craton
croton84415453croton
croutons1036723croutons
cutin75022773_cutin
cyton101511463_cyton
dalton7311273dalton
diuron738573diuron
doblon938003doblon
dobson936593dobson
doctor938993doctor
donjon1436463donjon
duotone836893duotone
elution72913823elution
emotion9711303emotion
foetor939563foetor
foison948933foison
fourgon1134863fourgon
fronton1037203fronton
futons93911513_futons
gluon6311223glu_on
gluten74210753gluten
glutton844893glutton
godson857383godson
gonion73612833gonion
goon57236173go__on
gorgon8310243gorgon
gotten73410113gotten
gout56646003gout__
gouts64826173gout_s
gouty95217363gout_y
jeton124815403_jeton
jetton1338033jetton
jomon14610083jo_mon
journo13135293journo
jupon14479193_jupon
koto86323463ko_to_
kotos95717693ko_tos
kotow12528703ko_tow
kouroi1036513kouroi
kouros1039183kouros
kowtow1643463kowtow
lepton82510793lepton
leukon1036143leukon
locution10227663locution
logion76013723logion
logon615922313lo_gon
loon47344793lo__on
lotion65716523lotion
lotos54724633lo_tos
lotto55217573lotto_
lottos64613103lottos
louden73711793louden
loupen84510293loupen
lout45952143lout__
louted74920693louted
louting83719383louting
louts56330273lout_s
macon94519953m_acon
macron103615673macron
madtom1138023madtom
maltol8310843maltol
mammon939643mammon
maroon83118203maroon
marron83717543marron
marten84518263marten
martin84122523martin
mascon103612743mascon
mason74820183m_ason
matin75132853m_atin
matron83918313matron
mattin84416633mattin
maun65727203mau__n
maut65448443maut__
mauts75927193maut_s
megaton10269843megaton
melon73922083m_elon
meltons9410923meltons
mention9314373mention
mentor8414363mentor
merlon83012353merlon
meson74118313m_eson
metol75917813m_etol
micron103714283micron
midtown1343673midtown
mignon937953mignon
mikron12318503mikron
minion83416233minion
mitten83914093mitten
moan65832013mo__an
moat66352033moat__
moated94819003moated
moating104218153moating
moats75827643moat_s
modern939523modern
modulo9256973modulo_
moisten93110143moisten
mojo136917223mo_jo_
mojos145314463mo_jos
molt66356163molt__
molted94217473molted
molter84119423molter
molting103517163molting
molts76032093molt_s
mon57561573m___on
monaxon1644913monaxon
mondo85721233mondo_
mondos95217333mondos
mongo810122413mongo_
mongoe94214983mongoe
mongol94912533mongol
mongos94318623mongos
monition10311723monition
monitor9310723monitor
mono66036713mo_no_
monos75930863mo_nos
monotone10310153monotone
monotony1347073monotony
monsoon938493monsoon
montane91313623montane
monte75829773mont_e
montes84226933montes
month104818423mont_h
months113812933months
monurons1037093monurons
moo58460513mo__o_
mood76332063mo__od
mool67533863mo__ol
moons75331003mo__ons
moony104818273mo__ony
moor66628553mo__or
moos66051303mo__os
moot67653623mo__ot
mooted94120373mooted
mooter83921093mooter
mooting103019343mooting
moots75831663moot_s
moreen8313343moreen
morgan9311373morgan
morgen9312203morgen
morions94014633morions
morn66237563mo__rn
morons84919543mo_rons
morrion959003morrion
morro73216953morro_
morros83714673morros
morrow113510093morrow
mort66758833mort__
mortal84616853mortal
mortar83812043mortar
morts75533563mort_s
mosso74715183mosso_
most66554203most__
moste75925083most_e
mostly113110943mostly
mosts76028543most_s
mot57279423mo_t__
mote67048083mo_t_e
motel76623243mo_tel
motes75944003mo_tes
motet75641193mo_tet
motey105922953mo_tey
moth96731333mo_t_h
moths106021553mo_ths
mothy136214553mo_thy
motif10519663mo_tif
motions94215003motions
motmot10311073motmot
motors84616593mo_tors
mots66853163mo_t_s
mott66648443mo_t_t
motte75526973mo_tte
mottes85523693mottes
mottle84116053mottle
mottoes93412193mottoes
motts76527003mo_tts
mouch124715803mou_ch
moue65835573mou__e
moues75732843mou_es
moufflon1641773moufflon
mouflons13133653mouflons
moujik1962883moujik
mould86015753mou_ld
moulds94910993moulds
mouldy12437413mouldy
moulins9312693moulins
moult74728723mou_lt
moulted103310313moulted
moulter93812423moulter
moulting112710303moulting
moults84713703moults
mound83918313mou_nd
mounds93915133mounds
mount74128063mou_nt
mountain1046113mountain
mounted103611533mounted
mounter93713173mounter
mounting112711813mounting
mounts84115073mounts
mourns84111013mourns
mouse77133003mou_se
moused94423303moused
mouser85822443mouser
mouses85531423mouses
mousey115216193mousey
mousing103816273mousing
mousse84813033mousse
mousy106716943mou_sy
mouthed133811043mouthed
mouther123812813mouther
mouthing142810243mouthing
moutonnee1153353moutonnee
mown95424443mo__wn
mozo157719743mo_zo_
mozos165516333mo_zos
mucin93116823m_ucin
mucor94011943m_ucor
mun56143853m_u__n
muntin82915183muntin
muons75816173m_u_ons
mut58357183m_ut__
mutant8317693m_utant
mutch125016173m_utch
mute65136873m_ut_e
muted85023383m_uted
muter74525543m_uter
mutes75033783m_utes
mutine84420373m_utine
muting93921523m_uting
mutiny113612683m_utiny
muts64839983m_ut_s
mutt65739403m_ut_t
muttons949283muttons
muttony1235323muttony
mutts75120253m_utts
nekton1036583nekton
neuron6310373neuron
neuston736083neuston
neutron737763neutron
newton936983newton
niton55418283_niton
noon47134623no__on
nostoc868183nostoc
notion64516583notion
noun45724183nou__n
oaten55222403_oaten
octan71313483_octan
odeon6411483_odeon
often84611413_often
onion54320973_onion
onto46127663_onto_
option83612713_option
orlon5415003_orlon
otto45220643_otto_
ottos54714323_ottos
out38072153_out__
outbox1537453_outbox
outby10411533_outby
outdo6312703_outdo
outdone8311643_outdone
outed65429063_outed
outer55633303_outer
outfox1636133_outfox
outgo6312093_outgo
outgone8311463_outgone
outgun7349643_outgun
outing74128153_outing
outman83115033_outman
outran63218883_outran
outre53922193_outre
outrow9311173_outrow
outrun63213293_outrun
outs45746963_out_s
outsin63617553_outsin
outworn101610753_outworn
ouzo133516933_ouzo_
ouzos143210413_ouzos
parton84720993parton
photon1111514823photon
phyton143610253phyton
piston83515923piston
piton76121583_piton
plutons938343plutons
poison8312223poison
pompon1238943pompon
pontons93315543pontons
pontoon93010703pontoon
poon67341263po__on
portion9615493portion
postin83521033postin
postop10511943postop
potion84519573potion
potto75320943potto_
pottos84615873pottos
pout65752553pout__
pouted94021393pouted
pouter83923983pouter
poutine93316823poutine
pouting103519943pouting
pouts75530323pout_s
pouty107018813pout_y
proton84318893proton
prutot8311823prutot
putons83515153_putons
ratton64116123ratton
rhyton12356113rhyton
ronion63315643ronion
ronyon9309133ronyon
roto45935053ro_to_
rotor55519733ro_tor
rotos56027883ro_tos
rotten64115433rotten
rouen54920903rou_en
rout46153283rout__
route55132073rout_e
routed75624333routed
router65025843router
routes66129313routes
routh86423073rout_h
rouths95416823rouths
routine72615903routine
routing83821093routing
routs57133413rout_s
rutin55421343_rutin
seton55223543_seton
sexton133610793sexton
soften9429493soften
solion6616383solion
soliton7410233soliton
solon55026133so_lon
solution889593solution
soon46240503so__on
sotol54917643so_tol
soudan73210353soudan
soupcon1144163soupcon
soutane7312063soutane
souter64225923souter
south85223573sout_h
southron1145493southron
souths95216603souths
stouten7307333stouten
tauon54816583tau_on
tauten64311893tauten
tautog765713tautog
teston6313303teston
ton310265103___ton
toon47740633to__on
torten65314353torten
tortoni738033tortoni
toucan838193toucan
tout46753823tout__
touted74419743touted
touter63821033touter
touting84118453touting
touts54830393tout_s
toyon86715673to_yon
triton63914893triton
tutor5712493_tutor
udon56017743__udon
upon65817583__upon
volutin1098093volutin
volution1198603volution
voudons1135313voudons
voudoun1143593voudoun
wanton94413813wanton
wontons103310533wontons
yaupon11345493yaupon
youpons12265983youpons
yourn87512773you_rn
youth115315043yout_h
youthen1336153youthen
youths124510043youths
yupon10469483_yupon
zoon137326983zo__on

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164545.76619548.4
3Display Results4544540.1403242.9
 (SQL Overall)1786914546.04629555.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.