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

301 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
scooch1322812(None) 
cooch124916831_cooch
scootch1434461scootch
scorch13198091scorch
scotch13207521scotch
scrooch1444961scrooch
smooch13266801smooch
brooch13368442brooch
coach125919452_coach
conch124620072_conch
couch125320112_couch
hooch135813702_hooch
mooch125313612_mooch
pooch124815302_pooch
sconce104711722sconce
scooched16206682scooched
scooches15188412scooches
scoop95617162scoo_p
scoops105414362scoops
scoot75729152scoo_t
scoots85315942scoots
scouth115011152scouth
scrootch1542812scrootch
sculch13226212sculch
scutch13247082scutch
slouch11438522slouch
smoochy17223862smoochy
smoosh11236732smoosh
smooth11259202smooth
sooth85924062s_ooth
swoosh12195212swoosh
acock132110213ac_ock
avouch1434833avouch
bescorch1742583bescorch
blotch13197143blotch
booth105522013_booth
botch126717453_botch
broach133611113broach
caroch13911763caroch
catch125120373_catch
chock164316613_chock
cinch124516243_cinch
clach124617823_clach
cloche134312373_cloche
clock134917983_clock
cloth105817543_cloth
coact96130583_coact
coca88030643_c_oca
cocci82812673_cocci
cock126332903_c_ock
coco87330603_c_oco
cocoa98517883_cocoa
cocos95624693_cocos
cohosh14517123_cohosh
concha134213283_concha
concho134414263_concho
conchs134714903_conchs
conchy163710223_conchy
coo59566363_coo__
cooches143515833_cooches
coocoo1069693_coocoo
cooed84534343_cooed
cooee74531023_cooee
cooer74831013_cooer
cooey105828223_cooey
coof96643273_coo_f
coofs105924713_coofs
cook107236933_coo_k
cooks115429143_cooks
cooky145321363_cooky
cool66940493_coo_l
cools75632633_cools
coolth1139513_coolth
cooly105525423_cooly
coomb115615703_coomb
coon67248943_coo_n
coons76737283_coons
coop87238653_coo_p
coops96229643_coops
coopt95929853_coopt
coos67456493_coo_s
coot67860383_coo_t
coots75636843_coots
cosh96127623_c_osh
cough115819643_cough
couth106122493_couth
croc85723733_croc_
croci95818133_croci
crock135921993_crock
crocs95722433_crocs
crotch133410083crotch
crouch133910203crouch
culch124512833_culch
curch124415413_curch
cutch125116193_cutch
epoch1248203_epoch
grouch12318473grouch
hootch14386413hootch
hotch136214733_hotch
loach105116363_loach
loch95527133__loch
moloch1356483moloch
mouch124715803_mouch
notch105613323_notch
ooh67637093__oo_h
ouch95724633__ouch
poach124917863_poach
pooh96027383_poo_h
porch125918623_porch
pouch124617083_pouch
roach105717003_roach
rococo1036813rococo
rotch105815933_rotch
samech13277033samech
sauch104918773s_auch
scarce104013633scarce
scarph13429603scarph
schlock18235873schlock
school11410723school
schools1249113schools
schorl1179813schorl
scion72214993scio_n
scions82612243scions
scoff134413343sc_off
scoffs14347503scoffs
scold85414863sc_old
scolds95011233scolds
scolex1538243scolex
sconced12359173sconced
sconces113811453sconces
scone74621833sc_one
scones84521303scones
scooching1735073scooching
scooped124611743scooped
scooper113812033scooper
scootched1763963scootched
scootches1635003scootches
scooted103612283scooted
scooter93312873scooter
scop85925523sc_o_p
scope94821483sc_ope
scoped115116653scoped
scopes104719593scopes
scops95820193sc_ops
scorched16187203scorched
scorcher15196793scorcher
scorches15189153scorches
score75526743sc_ore
scored94621133scored
scorer84818263scorer
scores84725923scores
scoria8513503scoria
scorn75817453sc_orn
scorns85713023scorns
scot66242613sc_o_t
scotched16187933scotched
scotches15179473scotches
scoter83815483scoter
scotia8310803scotia
scotoma1155963scotoma
scots74025913sc_ots
scour75315533sc_our
scours84913593scours
scouse84113633scouse
scout75031453sc_out
scouths12527893scouths
scouts84817943scouts
scow96021423sc_o_w
scowed124413833scowed
scowl1012012973sc_owl
scowls11549593scowls
scows106617803sc_ows
scraich1436763scraich
scratch1446013scratch
screech1435223screech
scrod85115073scro_d
scrods94111613scrods
scroll8310173scroll
scrooched1763843scrooched
scrooches1645703scrooches
scrooge1037183scrooge
scroop10299783scroop
scroops11288253scroops
scrota8310203scrota
scrunch1444033scrunch
scultch1483543scultch
search113312423search
sheuch14267043sheuch
shlock15378193shlock
shock144917033s_hock
shoo75929893shoo__
shooed103916083shooed
shook124920163shoo_k
shooks134515633shooks
shool84523153shoo_l
shools94919013shools
shoon84022013shoo_n
shoos84226363shoo_s
shoot84235913shoo_t
shoots94619363shoots
sketch1535363sketch
skosh12407273s_kosh
slatch114510533slatch
sloop76118913sloo_p
sloops85513623sloops
slosh84514483s_losh
sloth85019453s_loth
slouchy15454843slouchy
slough10539233slough
smirch1356463smirch
smock135311673s_mock
smooched16185983smooched
smoocher15205503smoocher
smooches15217263smooches
smooths12216323smooths
smoothy15205083smoothy
smutch13205843smutch
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
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
succoth1445093succoth
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 6 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.373479064.3
2DLD Change Limit1127163015.09622118.5
3Display Results3013010.0933236.6
 (SQL Overall)1786913015.56232127.1
 
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.