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

255 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
scotches1517947(None) 
scooches15188411scooches
scootches1635001scootches
scorches15189141scorches
scotched16187931scotched
scutches15168881scutches
blotches1537432blotches
botches143716022_botches
catches144320772_catches
coaches144018692_coaches
conches144019812_conches
cooches143515832_cooches
couches144020472_couches
crotches153411302crotches
cutches143216462_cutches
hootches1656972hootches
hotches153814362_hotches
notches123513652_notches
rotches123515702_rotches
scathes124515712scat_hes
sconces113811452sconc_es
scooched16206682scooched
scootched1763962scootched
scorched16187192scorched
scorcher15196782scorcher
scorchers16145512scorchers
scotch13207512scotch__
scotties1039742scotties
scratches1647322scratches
scrooches1645702scrooches
scrootches1743322scrootches
sculches15176272sculches
scultches1664292scultches
scutched16186892scutched
scutcher15176962scutcher
scutchers16175642scutchers
scythes15356522scyt_hes
sketches1746822sketches
slatches131511522slatches
slouches13208072slouches
smooches15217262smooches
smutches15177272smutches
snatches131410712snatches
snitches13148982snitches
soothes103917102soot_hes
splotches1643912splotches
stitches131410592stitches
swatches16169962swatches
switches16159132switches
aitches123014363_aitches
avouches1634823avouches
batches144019613_batches
bescorches1942743bescorches
bitches144117063_bitches
blotched1635653blotched
boches134618523_bo_ches
botched153611903_botched
botcher143613223_botcher
botchers153511543_botchers
britches15278683britches
broaches153211623broaches
brooches15288193brooches
butches144315363_butches
bycatches2142683bycatches
caches137926913_c_aches
catcher143115823_catcher
catchers153114063_catchers
cinches144215773_cinches
cliches144213743_cliches
cloches144113713_cloches
clothes124513813clot_hes
clutches15307923clutches
coached153313843_coached
coacher143714123_coacher
coachers154312303_coachers
conchas144013313_conchas
conchies153214853_conchies
conchos144313963_conchos
conchs134714903_conch_s
coshes115022783_co_shes
cotes76347843_cot__es
cotypes1437943_cotypes
couched154115793_couched
coucher144515853_coucher
couchers153513863_couchers
cratches153012543cratches
creches14313093_creches
crotched16428593crotched
crotchet152711993crotchet
crotchets16396303crotchets
crouches153711293crouches
crutches15359593crutches
culches143710743_culches
cultches15316533cultches
curches143512743_curches
ditches133215713_ditches
douches134315233_douches
ecotages1136973ecotages
ecotones1039493ecotones
ecotypes1545053ecotypes
etches114217763__etches
fetches153413893_fetches
fitches153516193_fitches
fletches16308853fletches
flitches16388463flitches
glitches14296653glitches
gotchas1334613_gotchas
grouches14328213grouches
grutches14285853grutches
hatches153420273_hatches
hitches153616273_hitches
hooches153812523_hooches
hopscotches2351463hopscotches
hotched163610923_hotched
hutches153613523_hutches
itches114916213__itches
ketches164012193_ketches
klatches17157133klatches
kvetches2053583kvetches
latches123320123_latches
letches124015483_letches
loaches123613983_loaches
matches143219783_matches
mooches143714453_mooches
mouches143815963_mouches
mutches143314283_mutches
nautches1336083nautches
notched134210303_notched
notcher123610933_notcher
notchers13279423_notchers
ouches114322183__ouches
patches143320383_patches
pitches143617753_pitches
poaches144416943_poaches
pooches143214163_pooches
porches143815673_porches
potiches1539203_potiches
pouches144116743_pouches
quitches2236193quitches
ratches123620463_ratches
retches123318513_retches
roaches123616213_roaches
rotche114311983_rotche_
rouches124217893_rouches
satchel123310303s_atchel
satchels13328163s_atchels
scathe114414993scat_he_
scathed134012643scat_hed
schatchen1943853schatchen
schatchens2042683schatchens
scoleces1237073scoleces
scolices1238733scolices
sconce104711723sconc_e_
sconced12359173sconc_ed
sconcheon1642373sconcheon
sconcheons1742093sconcheons
scones84521303sco__nes
scooch13228123scooch__
scootch1434453scootch__
scopes104719593sco__pes
scorch13198093scorch__
scores84725923sco__res
scotching1735653scotching
scoter83815473scot__er
scoters93313803scot_ers
scotias939743scot_ias
scotomas1256263scotomas
scots74025903scot___s
scottie937453scottie_
scourges1136533scourges
scouses93313243sco_uses
scouther1356943scouther
scouthers1445993scouthers
scouths12527893scouth_s
scratched1735393scratched
scratcher1635443scratcher
scratchers1744293scratchers
screeches1695643screeches
scrooched1763843scrooched
scrootched1842333scrootched
scrunches1635403scrunches
scutages1136503scutages
scutch13247083scutch__
scutcheon1642273scutcheon
scutcheons1752093scutcheons
scutes85219193scut__es
scuttles1056503scuttles
scythe14466013scyt_he_
scythed16385303scyt_hed
searches132112903searches
seethes103613743seet_hes
seiches12513813s_eiches
seviches1635803seviches
shotes95321903shot__es
sketched1835393sketched
sketcher1735433sketcher
sketchers1834513sketchers
skoshes14246243sko_shes
sloshes103811803slo_shes
sloths94911883slot_h_s
slouched14206743slouched
sloucher13206813sloucher
slouchers14185623slouchers
smirches1535993smirches
smooched16185983smooched
smoocher15205503smoocher
smoochers16184833smoochers
smooshes13206863smooshes
smoothes13218533smoothes
smother123510203smot_her
smothers13349933smot_hers
smutched16165923smutched
snatched14157633snatched
snatcher13167763snatcher
snatchers14146313snatchers
snathes104816493snat_hes
snitched14166863snitched
snitcher13157373snitcher
snitchers14166043snitchers
socles8418453s_o_cles
soothe94214843soot_he_
soothed113712733soot_hed
soother104215033soot_her
soothers113913433soot_hers
soothest113312243soot_hest
sooths95715583soot_h_s
soroches1338803soroches
soths86218623s_ot_h_s
soutaches1446443soutaches
spathes125116533spat_hes
speeches1537413speeches
splotched1742823splotched
stanches132312793stanches
starches131912913starches
stenches132110293stenches
stitched14148203stitched
stitcher13168393stitcher
stitchers14147013stitchers
stretches1438293stretches
swathes134115513swat_hes
switched17157133switched
switcher16177683switcher
switchers17146633switchers
swooshes14185123swooshes
tchotchkes2451363tchotchkes
thatches1637513thatches
torches123715433_torches
touches125118343_touches
troches123715343tro_ches
twitches16156373twitches
vetches153411263_vetches
vouches153914113_vouches
watches153017373_watches
witches152715793_witches
wretches16257283wretches

Search took 8 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 Filter1786911461620.250714764.0
2DLD Change Limit1461622557.00020880.3
3Display Results2552550.1102318.2
 (SQL Overall)1786912557.36024278.7
 
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.