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

346 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
smoosh1123673(None) 
smooch13266801smooch
smooth11259191smooth
swoosh12195211swoosh
mooch125313612_mooch
moos66051302_moos_
moose76327192_moose
mosh95227602_m_osh
scooch13228122scooch
shoos84226352shoos_
skosh12407262s_kosh
slosh84514482s_losh
smash104814432sm_ash
smogs85112162smogs_
smoochy17223862smoochy
smooshed14185992smooshed
smooshes13206862smooshes
smooths12216312smooths
smoothy15205072smoothy
smush104410582sm_ush
sooth85924052s_ooth
splosh1186542splosh
squoosh1962842squoosh
whoosh15244352whoosh
woosh113710732_woosh
ambos95321243ambos_
ambush1336103ambush
ammos94815823ammos_
amoks11413553amoks_
amoroso946093amoroso
aslosh966233aslosh
besmooth1543353besmooth
boos67955033_boos_
boost75132473_boost
booth105522013_booth
bosh96328973__bosh
brooch13368443brooch
broos75126413broos_
choose115116143choose
choosy14459103choosy
choush14549063choush
cohosh14517123cohosh
comose105016843comose
cooch124916833_cooch
coos67456493_coos_
cosh96127623__cosh
embosk1464853embosk
emboss1087373emboss
emdash12244113emdash
floosy12368153floosy
frosh115713403_frosh
galosh1038553galosh
golosh1036463golosh
goos57644913_goos_
goose65925903_goose
goosy96018883_goosy
gosh86123423__gosh
homos105921783homos_
hooch135813703_hooch
immesh1334103immesh
impish13499173impish
impose103113043impose
impost103011773impost
josh145117613__josh
kibosh1534263kibosh
kybosh1842713kybosh
loos49051123_loos_
loose56627683_loose
marsh105320853_marsh
mash96039393_m_ash
mensh105413553_mensh
mesh96823003_m_esh
mhos95517773_mhos_
moas65545343_moas_
mobs85737363_mobs_
mocs85834903_mocs_
modish123813543_modish
mods77945053_mods_
mogs75439333_mogs_
moist76033573_moist
mojos145314463_mojos_
moloch1356483_moloch
mols65948573_mols_
moms86539483_moms_
monish114217593_monish
monos75930863_monos_
mons68152253_mons_
month104818423_month
moo58460513_moo__
mood76332063_moo_d
moods85224623_moods
moody115017493_moody
mooed85123983_mooed
mool67533863_moo_l
moola75117033_moola
moolah11409193_moolah
mools76027173_mools
moon67140813_moo_n
moonish123311043_moonish
moons75331003_moons
moony104818273_moony
moor66628553_moo_r
moorish123311783_moorish
moors74923143_moors
moory105115793_moory
moot67653623_moo_t
moots75831663_moots
mopish134311593_mopish
mops85940133_mops_
morose85116243_morose
morph121712513_morph
mors65950063_mors_
morse76032703_morse
mos57067123_m_os_
mosk105622443_m_osk
moss67641033_m_oss
mosso74715183_mosso
mossy105217063_mossy
most66554203_m_ost
moth96731333_m_oth
moths106021553_moths
mots66853163_mots_
mouch124715803_mouch
mouse77133003_mouse
mousy106716943_mousy
mouth105420293_mouth
mows96340833_mows_
mozos165516333_mozos_
mush94929123_m_ush
nomos75919743nomos_
noose55624063_noose
nosh76223543__nosh
ooh67637093__oo_h
oohs75220693__oohs
osmols8137313osmols_
osmose8108003osm_ose
osmous8138173osmous_
pomos95321573pomos_
pooch124815303_pooch
pooh96027383_poo_h
poohs103915713_poohs
poos65949113_poos_
posh95427323__posh
resmooth1343633resmooth
roose56127093_roose
roost55730933_roost
sagos66123873sagos_
sambos104315193sambos_
samosa8510203samosa
saros55238063saros_
sash77235303s__ash
schmoos14347513schmoos_
schmoose15295973schmoose
scoop95617163scoo_p
scoops105414363scoops
scoot75729143scoo_t
scootch1434453scootch
scoots85315933scoots
scops95820193scops_
scorch13198093scorch
scotch13207513scotch
scots74025903scots_
scouse84113633scouse
scouth115011153scouth
scows106617803scows_
scrooch1444953scrooch
segos64919483segos_
serosa6313023serosa
setose65114773setose
sheesh1237813sheesh
shmoes114612093shmoes_
shmooze21255243shmooze
shoes85429653shoes_
shogs95319703shogs_
shoo75929883shoo__
shooed103916073shooed
shook124920153shoo_k
shooks134515623shooks
shool84523143shoo_l
shools94919003shools
shoon84022003shoo_n
shoot84235893shoo_t
shoots94619343shoots
shops104222893shops_
shots84730833shots_
shows115324573shows_
shush113812543s_hush
silos56029423silos_
simoom1037493simoo_m
simooms1135573simooms
simoon858063simoo_n
simoons937933simoons
slash84719683s_lash
slobs74419873slobs_
sloes54728873sloes_
slogs64521843slogs_
sloop76118913sloo_p
sloops85513623sloops
slops75026013slops_
sloshy12366623s_loshy
sloth85019443s_loth
sloths94911883sloths
slots54830523slots_
slouch11438523slouch
slough10539233slough
slowish1337633slowish
slows85323463slows_
slush85316573s_lush
smews104612293smews_
smirch1356463smirch
smith107818043sm_ith
smiths114711023smiths
smock135311673sm_ock
smocks145710013smocks
smog76317413sm_o_g
smoggy1354283smoggy
smoke115015823sm_oke
smoked134311723smoked
smoker124311693smoker
smokes124814343smokes
smokey15398653smokey
smoky14388683sm_oky
smolt74824163sm_olt
smolts84411883smolts
smooched16185983smooched
smoocher15205503smoocher
smooches15217263smooches
smooshing1534793smooshing
smoothed14236463smoothed
smoothen13204953smoothen
smoother13196663smoother
smoothes13218533smoothes
smoothie1344873smoothie
smoothly16203633smoothly
smote75820273sm_ote
smutch13205843smutch
smuts75415713smuts_
snash84815673s_nash
sneesh945893sneesh
snobs74716153snobs_
snogs66017493snogs_
snood64616163snoo_d
snoods74312443snoods
snook95115573snoo_k
snooks104412823snooks
snool55118643snoo_l
snools65715873snools
snoop75317173snoo_p
snoops84314163snoops
snoopy11449473snoopy
snoot55030133snoo_t
snoots64216663snoots
snooty94211503snooty
snooze15439983snooze
snoozy18517223snoozy
snots55225103snots_
snows84719883snows_
sobs64941753s_obs_
sods54940213s_ods_
solos54830793solos_
sols45448163s_ols_
somas76030373somas_
somoni8310733somoni
soms66239373s_oms_
sons46049553s_ons_
sonsy86416373s_onsy
sooey84522433s_ooey
sook84933393s_oo_k
sooks94425453s_ooks
soon46240503s_oo_n
soot45761053s_oo_t
soothe94214843s_oothe
sooths95715583s_ooths
soots55536203s_oots
sooty84924833s_ooty
soph97024203s__oph
sophs104916023s_ophs
sops65244563s_ops_
sos37761603s__os_
soth75932513s__oth
soths86218623s_oths
sots45552443s_ots_
sough95320463s_ough
sous46947213s_ous_
souse56530773s_ouse
south85223573s_outh
sows75342493s_ows_
soys75233933s_oys_
splash1168823splash
spoof105019013spoo_f
spoofs114011813spoofs
spoofy14498553spoofy
spook115416043spoo_k
spookish1744643spookish
spooks124312933spooks
spooky15418093spooky
spool75219043spoo_l
spools85115913spools
spoon74719443spoo_n
spoons84116013spoons
spoony114111793spoony
spoor75016353spoo_r
spoors84014023spoors
spots74424103spots_
spouse84112513spouse
squash1846833squash
squish1838573squish
squooshy2381273squooshy
squush1833993squush
stash84916973s_tash
stoas55126023stoas_
stobs75718233stobs_
stonish10410653stonish
stood65517713stoo_d
stooge73811663stooge
stook95218213stoo_k
stooks105115373stooks
stool55619893stoo_l
stools65117023stools
stoop75821543stoo_p
stoops85917893stoops
stops74827283stops_
stoss54316343s_toss
stots54828543stots_
stows86622703stows_
sumoist9311613sumoist
sumos75720093sumos_
swash116316753s_wash
swish115114823s_wish
swobs104910893swobs_
swoon85014783swoo_n
swoons94511143swoons
swoony12408263swoony
swoop105213433swoo_p
swoops114910923swoops
swoopy14487283swoopy
swooshed15174273swooshed
swooshes14185123swooshes
swops105913973swops_
swots85518423swots_
tooth88020183_tooth
tosh74826813__tosh
umbos94613063umbos_
vamoose1235863vamoose
woos76238803_woos_
zoos135828803_zoos_

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.1561145455.1
2DLD Change Limit1127163465.98318839.4
3Display Results3463460.1103145.5
 (SQL Overall)1786913466.24928595.1
 
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.