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 “snatches” 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
snatches13141071(None) 
slatches131511521slatches
snatched14157631snatched
snatcher13167761snatcher
snatchers14146311snatchers
snathes104816491snat_hes
snitches13148981snitches
swatches16169961swatches
batches144019612_batches
catches144320772_catches
cratches153012542cratches
hatches153420272_hatches
inarches1358042inarches
klatches17157132klatches
latches123320122_latches
matches143219782_matches
naches114622412_na_ches
nautches1336082_nautches
notches123513652_notches
patches143320382_patches
ratches123620462_ratches
satchel123310302s_atchel
satchels13328162s_atchels
scathes124515712scat_hes
scotches15179472scotches
scratches1647322scratches
scutches15168882scutches
searches132112902searches
sketches1746822sketches
smutches15177272smutches
snashes105214752sna_shes
snatch114310602snatch__
snatchier1455352snatchier
snatchiest1545162snatchiest
snatchy15355292snatch_y
snathe94415112snat_he_
snaths95112912snat_h_s
snitched14166862snitched
snitcher13157372snitcher
snitchers14166042snitchers
spathes125116532spat_hes
stanches132312792stanches
starches131912912starches
stitches131410592stitches
swathes134115512swat_hes
switches16159132switches
thatches1637512thatches
unlatches1444292unlatches
watches153017372_watches
aches106132293__a_ches
aitches123014363_aitches
anarchies1448183anarchies
anarchs1237093anarch_s
anatases839793anatases
apaches143411833apa_ches
arches114822043__arches
attaches13137723attaches
baches135426943_ba_ches
batched154114243_batched
batcher144414853_batcher
batchers153613273_batchers
bathes116524833_bat_hes
beaches144120653bea_ches
bitches144117063_bitches
blanches153311603blanches
blotches1537433blotches
botches143716023_botches
braches144621223bra_ches
branches153613803branches
britches15278683britches
butches144315363_butches
bycatches2142683bycatches
caches137926913_ca_ches
catcher143115823_catcher
catchers153114063_catchers
chatchkes23174743chatchkes
clutches15307923clutches
coaches144018693coa_ches
cranches153114543cranches
crotches153411303crotches
crutches15359593crutches
cultches15316533cultches
cutches143216463_cutches
datchas1347423_datchas
despatches1874043despatches
detaches1439653detaches
dispatches1874583dispatches
ditches133215713_ditches
enates64026433enat__es
enriches1337263enriches
etches114217763__etches
fetches153413893_fetches
fitches153516193_fitches
fletches16308853fletches
flitches16388463flitches
ganaches1437423ganaches
glitches14296653glitches
gnashes11419573gna_shes
grutches14285853grutches
hatched163414463_hatched
hatchel153510753_hatchel
hatchels16368673_hatchels
hatcher153314723_hatcher
hatchers163113173_hatchers
hatchet153317563_hatchet
hatchets163310383_hatchets
hitches153616273_hitches
hootches1656973hootches
hotches153814363_hotches
hutches153613523_hutches
inarched1486113inarched
inches114419673in__ches
itches114916213__itches
ketches164012193_ketches
klatsches1842223klatsches
kvetches2053583kvetches
laches116528343_la_ches
larches124416443_larches
latched133914063_latched
latchet123117903_latchet
latchets133410013_latchets
lathes95127493_lat_hes
leaches123319343lea_ches
letches124015483_letches
loaches123613983loa_ches
loathes103513243loat_hes
maches134827233_ma_ches
manches143818623_manches
marches143921173_marches
matched153513963_matched
matcher143214283_matcher
matchers153012433_matchers
menarches1646683menarches
mismatches1953753mismatches
mispatches1974103mispatches
mutches143314283_mutches
nachas114914193_na_chas
nachos115014183_na_chos
nacres85614453_na_cres
nances83618643_nanc_es
nancies93516843_nancies
natch105018223_natch__
nates55238333_nat__es
natives10310823_natives
natures7311963_natures
niches114419143_n_iches
nitchies1339073_nitchies
notched134210303_notched
notcher123610933_notcher
notchers13279423_notchers
oraches124216473ora_ches
panaches15310283panaches
panoches1548123panoches
parches143720003_parches
patched153514623_patched
patcher143515143_patcher
patchers153413303_patchers
peaches144120053pea_ches
pitches143617753_pitches
planches153111863planches
poaches144416943poa_ches
quaiches2235343quaiches
quitches2236193quitches
ranches123620113_ranches
ratchet124218333_ratchet
ratchets133110263_ratchets
reaches123423203rea_ches
rematches1636653rematches
repatches1636713repatches
retches123318513_retches
roaches123616213roa_ches
rotches123515703_rotches
sachem134012223s_a_chem
sachems14348903s_a_chems
sachet114725773s_a_chet
sachets123914103s_a_chets
sadhes104715373s_a_dhes
saices84221803s_aic_es
sanicles10149943sanicles
sashes94728483s_a_shes
sates54949323s_at__es
satires72617573s_atires
sauces84919503s_auc_es
sauchs115112233s_auch_s
scathe114414993scat_he_
scathed134012643scat_hed
schatchen1943853schatchen
schatchens2042683schatchens
scooches15188413scooches
scootches1635003scootches
scorches15189143scorches
scotched16187933scotched
scratched1735393scratched
scratcher1635443scratcher
scratchers1744293scratchers
sculches15176273sculches
scultches1664293scultches
scutched16186893scutched
scutcher15176963scutcher
scutchers16175643scutchers
scythes15356523scyt_hes
seances93015343seanc_es
searched14209253searched
searcher13209103searcher
searchers14197353searchers
seethes103613743seet_hes
seiches12513813s_eiches
senates73322613senat__es
seviches1635803seviches
sheathes14610193sheat_hes
skates104219403skat__es
skatoles1236143skatoles
sketched1835393sketched
sketcher1735433sketcher
sketchers1834513sketchers
slashes103619113sla_shes
slatch114510533slatch__
slates64934063slat__es
slather103816073slat_her
slathers113914783slat_hers
slouches13208073slouches
smashes123914613sma_shes
smirches1535993smirches
smooches15217263smooches
smutched16165923smutched
snacked144013113sna_cked
snacker133112603sna_cker
snackers143010223sna_ckers
snacks124514553sna_c_ks
snaffles14246043snaffles
snakes103919603sna__kes
snares65329033sna__res
snatching1536363snatching
snath86419803snat_h__
sneeshes1136513sneeshes
snitch11357943snitch__
sonances10310263sonanc_es
soothes103917113soot_hes
soroches1338803soroches
soutaches1446443soutaches
spaces104722633spa_c_es
spates85028173spat__es
spathe115115693spat_he_
spathed134013183spat_hed
spatzles1935303spatzles
speeches1537413speeches
spinaches1645273spina_ches
splotches1643913splotches
stactes91914633sta_ctes
staithes1138953staithes
stances93715963stanc_es
stanched14208903stanched
stancher13198813stancher
stanchers14206813stanchers
stanchest14218213stanchest
starched14199313starched
stashes103916173sta_shes
states64337083stat__es
statices102712343statices
statives112710793statives
statues74614903stat_ues
statures83711113statures
statuses8409543statuses
statutes8368893statutes
staunches1444603staunches
stenches132110293stenches
stitched14148203stitched
stitcher13168393stitcher
stitchers14147013stitchers
stretches1438293stretches
sunbathes1444113sunbat_hes
swashes134714403swa_shes
swatch14549283swatch__
swathe125514113swat_he_
swathed144611933swat_hed
swather134213603swat_her
swathers144512083swat_hers
swaths125312643swat_h_s
switched17157133switched
switcher16177683switcher
switchers17146633switchers
taches114224173_ta_ches
teaches122718353tea_ches
thatched1735433thatched
thatcher1635663thatcher
thatchers1744583thatchers
tranches132915513tranches
twitches16156373twitches
unarched14128553unarched
unhatched1844133unhatched
unhitches1743073unhitches
unlatched1544213unlatched
unmatched1744203unmatched
unpatched1744053unpatched
unwatched1844083unwatched
vetches153411263_vetches
watched163012823_watched
watcher153113403_watcher
watchers163511793_watchers
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.440406115.9
2DLD Change Limit1461623017.37319824.0
3Display Results3013010.1102736.4
 (SQL Overall)1786913017.92322553.5
 
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.