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

249 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
smooch1326680(None) 
mooch125313611_mooch
scooch13228121scooch
smoochy17223861smoochy
smoosh11236731smoosh
smooth11259201smooth
brooch13368442brooch
cooch124916832_cooch
hooch135813702_hooch
moloch1356482_moloch
mouch124715802_mouch
pooch124815302_pooch
scootch1434462scootch
scorch13198092scorch
scotch13207522scotch
scrooch1444962scrooch
slouch11438522slouch
smirch1356462smirch
smock135311672sm_ock
smooched16185982smooched
smoocher15205502smoocher
smooches15217262smooches
smooths12216322smooths
smoothy15205082smoothy
smutch13205842smutch
sooth85924062s_ooth
swoosh12195212swoosh
avouch1434833avouch
besmooth1543353besmooth
blotch13197143blotch
booth105522013_booth
botch126717453_botch
broach133611113broach
caroch13911763caroch
coach125919453_coach
conch124620073_conch
couch125320113_couch
crotch133410083crotch
crouch133910203crouch
epoch1248203_epoch
grouch12318473grouch
hootch14386413hootch
hotch136214733_hotch
loach105116363_loach
loch95527133__loch
mach116134483_m_ach
march125622893_march
match125621103_match
merch125417963_merch
milch124413373_milch
moc77845083_m_oc_
mocha1249923_m_ocha
mock126429443_m_ock
mocs85834903_m_ocs
molochs1435223_molochs
month104818423_month
moo58460513_moo__
mooched153910533_mooched
moocher143610673_moocher
mooches143714453_mooches
mood76332063_moo_d
moods85224623_moods
moody115017493_moody
mooed85123983_mooed
mool67533863_moo_l
moola75117033_moola
moolah11409193_moolah
mools76027173_mools
moon67140813_moo_n
moons75331003_moons
moony104818273_moony
moor66628553_moo_r
moors74923143_moors
moory105115793_moory
moos66051303_moo_s
moose76327193_moose
moot67653623_moo_t
moots75831663_moots
morph121712513_morph
mosh95227603_m_osh
moth96731333_m_oth
mouth105420293_mouth
much115224033_m_uch
mulch124012973_mulch
munch124917103_munch
mutch125016173_mutch
notch105613323_notch
ooh67637093__oo_h
ouch95724633__ouch
poach124917863_poach
pooh96027383_poo_h
porch125918623_porch
pouch124617083_pouch
resmooth1343633resmooth
roach105717003_roach
rotch105815933_rotch
samech13277033samech
sauch104918773s_auch
sconce104711723sconce
scooched16206683scooched
scooches15188413scooches
scoop95617163scoo_p
scoops105414363scoops
scoot75729153scoo_t
scoots85315943scoots
scouth115011153scouth
scrootch1542813scrootch
sculch13226213sculch
scutch13247083scutch
search113312423search
sheuch14267043sheuch
shlock15378193shlock
shmooze21255263shmooze
shock144917033s_hock
shoo75929893shoo__
shooed103916083shooed
shook124920163shoo_k
shooks134515633shooks
shool84523153shoo_l
shools94919013shools
shoon84022013shoo_n
shoos84226363shoo_s
shoot84235913shoo_t
shoots94619363shoots
simoom1037503simoo_m
simooms1135573simooms
simoon858063simoo_n
simoons937943simoons
sketch1535363sketch
skosh12407273s_kosh
slatch114510533slatch
sloop76118913sloo_p
sloops85513623sloops
slosh84514483s_losh
sloth85019453s_loth
slouchy15454843slouchy
slough10539233slough
smack134615453sm_ack
smash104814433sm_ash
smith107818053sm_ith
smocks145710013smocks
smog76317413sm_o_g
smoggy1354283smoggy
smogs85112163sm_ogs
smoke115015823sm_oke
smoked134311723smoked
smoker124311693smoker
smokes124814343smokes
smokey15398653smokey
smoky14388683sm_oky
smolt74824163sm_olt
smolts84411883smolts
smoochers16184833smoochers
smooching1734883smooching
smooshed14185993smooshed
smooshes13206863smooshes
smoothed14236473smoothed
smoothen13204963smoothen
smoother13196673smoother
smoothes13218543smoothes
smoothie1344893smoothie
smoothly16203643smoothly
smote75820283sm_ote
smush104410583sm_ush
smutchy17193153smutchy
snatch114310603snatch
snitch11357943snitch
snood64616163snoo_d
snoods74312453snoods
snook95115573snoo_k
snooks104412833snooks
snool55118643snoo_l
snools65715883snools
snoop75317173snoo_p
snoops84314173snoops
snoopy11449473snoopy
snoot55030143snoo_t
snoots64216683snoots
snooty94211513snooty
snooze15439993snooze
snoozy18517233snoozy
soca66330053s__oca
sock105233213s__ock
somoni8310743somoni
sooey84522433s_ooey
sook84933393s_oo_k
sooks94425453s_ooks
soon46240503s_oo_n
soot45761063s_oo_t
soothe94214853s_oothe
sooths95715593s_ooths
soots55536213s_oots
sooty84924843s_ooty
soph97024203s__oph
soroche1237183soroche
soth75932523s__oth
sough95320463s_ough
south85223573s_outh
speech1347563speech
splosh1186543splosh
splotch1442853splotch
spoof105019013spoo_f
spoofs114011813spoofs
spoofy14498553spoofy
spook115416043spoo_k
spooks124312933spooks
spooky15418093spooky
spool75219043spoo_l
spools85115913spools
spoon74719443spoo_n
spoons84116023spoons
spoony114111793spoony
spoor75016353spoo_r
spoors84014033spoors
squoosh1962843squoosh
stanch113812373stanch
starch113013203starch
stench114111163stench
stich104117923s_tich
stitch11419103stitch
stock114417563s_tock
stoic7317253stoic_
stoics8311113stoics
stomach1436033stomach
stood65517713stoo_d
stooge73811663stooge
stook95218213stoo_k
stooks105115373stooks
stool55619893stoo_l
stools65117023stools
stoop75821543stoo_p
stoops85917893stoops
such96424813s__uch
sumach135310113sumach
swatch14549283swatch
switch14458913switch
swoon85014783swoo_n
swoons94511143swoons
swoony12408263swoony
swoop105213433swoo_p
swoops114910923swoops
swoopy14487283swoopy
synch135011793s_ynch
tooth88020183_tooth
torch107420933_torch
touch106519393_touch
vouch134611903_vouch
whoosh15244353whoosh
woosh113710733_woosh

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.390458182.1
2DLD Change Limit1127162495.51620434.4
3Display Results2492490.0763276.3
 (SQL Overall)1786912495.98229871.4
 
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.