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

233 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
snatcher1316776(None) 
snatched14157631snatched
snatchers14146311snatchers
snatches131410711snatches
snatchier1455351snatchier
snitcher13157371snitcher
batcher144414852_batcher
catcher143115822_catcher
hatcher153314722_hatcher
matcher143214282_matcher
notcher123610932_notcher
patcher143515142_patcher
satchel123310302s_atchel
scratcher1635442scratcher
scutcher15176962scutcher
searcher13209102searcher
sketcher1735432sketcher
slatches131511532slatches
slather103816082slat_her
snacker133112602sna_cker
snatch114310602snatch__
snatchy15355292snatch_y
snathe94415112snat_he_
snathes104816492snat_hes
snitched14166862snitched
snitchers14166042snitchers
snitches13148982snitches
stancher13198812stancher
stitcher13168392stitcher
swatches16169962swatches
swather134213602swat_her
switcher16177682switcher
thatcher1635662thatcher
watcher153113402_watcher
another10289153anot_her
anther93715063an_t_her
archer115016243__archer
attacher13125713attacher
batched154114243_batched
batchers153613273_batchers
batches144019613_batches
bather115322513_bat_her
blancher15338633blancher
blather125314213blat_her
botcher143613223_botcher
butcher143411163_butcher
catchers153114063_catchers
catches144320773_catches
catchier15329863_catchier
coacher143714123coa_cher
cratches153012543cratches
detacher1437543detacher
dispatcher1853263dispatcher
ditcher134012003_ditcher
enricher1345003enricher
etcher113912943__etcher
father125116713_fat_her
feather133613503feat_her
fetcher153510393_fetcher
fletcher16306663fletcher
gather104115863_gat_her
gaucher1337243_gaucher
gnattier934263gnattier
hatched163414463_hatched
hatchel153510753_hatchel
hatchers163113173_hatchers
hatchery19326383_hatchery
hatches153420273_hatches
hatchet153317563_hatchet
heather133914853heat_her
hitcher153712003_hitcher
inarched1486113inarched
inarches1358043inarches
incher114114033in__cher
ingather1244783ingat_her
klatches17157143klatches
knacker12307913kna_cker
kvetcher2052813kvetcher
latched133914073_latched
latches123320133_latches
latchet123117913_latchet
lather95124363_lat_her
leacher124014843lea_cher
leather103815783leat_her
loather103711003loat_her
marcher143912973_marcher
matched153513963_matched
matchers153012433_matchers
matches143219783_matches
naches114622413_na_ches
natch105018223_natch__
natter64420743_nat_ter
nattier73614623_nattier
nautches1336083_nautches
nether94014163_net_her
notched134210303_notched
notchers13279423_notchers
notches123513653_notches
nother93815963_not_her
panther12611443pant_her
patched153514623_patched
patchers153413303_patchers
patches143320383_patches
patchier15319663_patchier
peacher144216073pea_cher
pitcher143813713_pitcher
poacher143912323poa_cher
rancher123013633_rancher
ratches123620463_ratches
ratchet124218333_ratchet
rather94319743_rat_her
reacher123718293rea_cher
sachem134012223s_a_chem
sachet114725773s_a_chet
sacker125124843s_a_cker
satchels13328163s_atchels
saucer84314103s_auc_er
saucier9810283s_aucier
scarcer113911373scarc_er
scathe114414993scat_he_
scathed134012643scat_hed
scathes124515713scat_hes
scatter93815173scat_ter
scattier10267583scattier
schatchen1943853schatchen
scorcher15196793scorcher
scotched16187933scotched
scotches15179473scotches
scratched1735393scratched
scratchers1744293scratchers
scratches1647323scratches
scratchier1744343scratchier
scutched16186893scutched
scutchers16175643scutchers
scutches15168883scutches
searched14209253searched
searchers14197353searchers
searches132112903searches
seater64534163seat__er
shatter103615703shat_ter
sheather1458233sheat_her
skater105015493skat__er
sketched1835393sketched
sketchers1834513sketchers
sketches1746823sketches
sketchier1853413sketchier
slacker133915293sla_cker
slasher104515333sla_sher
slatch114510533slatch__
slater64429183slat__er
slathers113914783slat_hers
slatier74016813slat_ier
slither104112983slit_her
sloucher13206813sloucher
smacker153410583sma_cker
smasher123911023sma_sher
smatter93613333smat_ter
smoocher15205503smoocher
smother123510213smot_her
smutched16165923smutched
smutches15177273smutches
smutchier1643503smutchier
snacked144013113sna_cked
snackers143010223sna_ckers
snaggier10136303snaggier
snakier112810003sna_kier
snapper113512073sna_pper
snappier1266223snappier
snarer64620843sna__rer
snarkier12336513snarkier
snarler73610633sna_rler
snarlier8278183snarlier
snashes105214753sna_shes
snatchiest1545163snatchiest
snatching1536363snatching
snath86419803snat_h__
snaths95112913snat_h_s
snazzier1642483snazzier
snicker133012673sn_icker
snitch11357943snitch__
snottier8217383snottier
soother104215043soot_her
souther104116303sout_her
spacer104917793spa_c_er
spacier114011633spa_cier
spathe115115693spat_he_
spathed134013183spat_hed
spathes125116533spat_hes
spatter94016523spat_ter
stacker134416263sta_cker
stanched14208903stanched
stanchers14206813stanchers
stanches132312793stanches
starched14199313starched
starches131912913starches
starchier1436643starchier
stater64427563stat__er
stauncher1443513stauncher
stitched14148203stitched
stitchers14147013stitchers
stitchery17174073stitchery
stitches131410593stitches
stretcher1446293stretcher
sunbather1443023sunbat_her
swasher134011513swa_sher
swatch14549283swatch__
swathe125514113swat_he_
swathed144611933swat_hed
swathers144512083swat_hers
swathes134115513swat_hes
swatter104113323swat_ter
switched17157133switched
switchers17146633switchers
switches16159133switches
swither133710993swit_her
teacher123714833tea_cher
thatched1735433thatched
thatchers1744583thatchers
thatches1637513thatches
thatchier1743983thatchier
twitcher16135343twitcher
unanchor1343093unanchor
unarched14128553unarched
unhatched1844133unhatched
unlatched1544223unlatched
unlatches1444303unlatches
unmatched1744203unmatched
unpatched1744053unpatched
unwatched1844083unwatched
watched163012823_watched
watchers163511793_watchers
watches153017373_watches
weather133513223weat_her

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.420425454.8
2DLD Change Limit1461622337.25320151.9
3Display Results2332330.0932505.4
 (SQL Overall)1786912337.76623009.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.