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

306 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
swatches1616996(None) 
slatches131511521slatches
snatches131410711snatches
swathes134115511swat_hes
switches16159131switches
watches153017371_watches
batches144019612_batches
catches144320762_catches
cratches153012542cratches
hatches153420272_hatches
klatches17157132klatches
latches123320122_latches
matches143219782_matches
patches143320382_patches
ratches123620462_ratches
satchel123310302s_atchel
satchels13328162s_atchels
scathes124515712scat_hes
scotches15179472scotches
scratches1647312scratches
scutches15168882scutches
searches132112902searches
sketches1746822sketches
smutches15177272smutches
snatched14157632snatched
snatcher13167752snatcher
snatchers14146302snatchers
snathes104816492snat_hes
snitches13148982snitches
spathes125116532spat_hes
stanches132312792stanches
starches131912912starches
stitches131410592stitches
swashes134714402swa_shes
swatch14549282swatch__
swathe125514112swat_he_
swathed144611932swat_hed
swather134213592swat_her
swathers144512072swat_hers
swaths125312642swat_h_s
switched17157132switched
switcher16177682switcher
switchers17146632switchers
thatches1637512thatches
twitches16156372twitches
watched163012822_watched
watcher153113402_watcher
watchers163511792_watchers
witches152715792_witches
aches106132293__a_ches
aitches123014363_aitches
apaches143411833apa_ches
arches114822043__arches
attaches13137723attaches
baches135426943_ba_ches
batched154114243_batched
batcher144414853_batcher
batchers153613273_batchers
bathes116524833_bat_hes
beaches144120653bea_ches
bewitches1943823bewitches
bitches144117063_bitches
blanches153311603blanches
blotches1537433blotches
botches143716023_botches
braches144621223bra_ches
branches153613803branches
britches15278683britches
butches144315363_butches
bycatches2142683bycatches
caches137926913_ca_ches
catcher143115823_catcher
catchers153114053_catchers
chatchkes23174743chatchkes
clutches15307913clutches
coaches144018693coa_ches
cranches153114543cranches
crotches153411293crotches
crutches15359583crutches
cultches15316533cultches
cutches143216453_cutches
datchas1347423_datchas
despatches1874043despatches
detaches1439653detaches
dispatches1874583dispatches
ditches133215713_ditches
dogwatches2042213dogwatches
enswathes1543433enswat_hes
etches114217763__etches
fetches153413893_fetches
fitches153516193_fitches
fletches16308853fletches
flitches16388463flitches
glitches14296653glitches
grutches14285853grutches
hatched163414463_hatched
hatchel153510753_hatchel
hatchels16368673_hatchels
hatcher153314723_hatcher
hatchers163113173_hatchers
hatchet153317563_hatchet
hatchets163310383_hatchets
hitches153616273_hitches
hootches1656973hootches
hotches153814363_hotches
hutches153613523_hutches
inarches1358043inarches
inswathes1543953inswat_hes
itches114916213__itches
ketches164012193_ketches
klatsches1842223klatsches
kvetches2053583kvetches
kwachas1943063kwa_chas
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
midwatches2141803midwatches
mismatches1953753mismatches
mispatches1974103mispatches
mutches143314283_mutches
naches114622413_na_ches
nautches1336073nautches
notches123513653_notches
oraches124216473ora_ches
outwatches1843473outwatches
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
sashes94728483s_a_shes
sates54949323s_at__es
satires72617573s_atires
sauces84919503s_auc_es
sauchs115112233s_auch_s
scathe114414993scat_he_
scathed134012643scat_hed
schatchen1943853schatchen
schatchens2042683schatchens
scooches15188413scooches
scootches1635003scootches
scorches15189143scorches
scotched16187933scotched
scratched1735383scratched
scratcher1635433scratcher
scratchers1744283scratchers
sculches15176273sculches
scultches1664293scultches
scutched16186893scutched
scutcher15176963scutcher
scutchers16175643scutchers
scythes15356523scyt_hes
seances93015343seanc_es
searched14209253searched
searcher13209103searcher
searchers14197353searchers
seethes103613743seet_hes
seiches12513813s_eiches
seviches1635803seviches
sheathes14610183sheat_hes
skates104219393skat__es
skatoles1236143skatoles
sketched1835393sketched
sketcher1735433sketcher
sketchers1834513sketchers
slashes103619103sla_shes
slatch114510533slatch__
slates64934063slat__es
slather103816063slat_her
slathers113914773slat_hers
slouches13208073slouches
smashes123914613sma_shes
smirches1535993smirches
smooches15217263smooches
smutched16165923smutched
snashes105214753sna_shes
snatch114310603snatch__
snatchier1455353snatchier
snatchiest1545143snatchiest
snatchy15355293snatch_y
snathe94415113snat_he_
snaths95112913snat_h_s
snitched14166863snitched
snitcher13157373snitcher
snitchers14166043snitchers
soothes103917103soot_hes
soroches1338803soroches
soutaches1446443soutaches
spaces104722633spa_c_es
spates85028173spat__es
spathe115115693spat_he_
spathed134013183spat_hed
spatzles1935303spatzles
speeches1537413speeches
splotches1643913splotches
stactes91914633sta_ctes
staithes1138953staithes
stances93715963stanc_es
stanched14208903stanched
stancher13198803stancher
stanchers14206803stanchers
stanchest14218213stanchest
starched14199313starched
stashes103916163sta_shes
states64337083stat__es
statices102712343statices
statives112710793statives
statues74614903stat_ues
statures83711113statures
statuses8409533statuses
statutes8368893statutes
staunches1444603staunches
stenches132110293stenches
stitched14148203stitched
stitcher13168383stitcher
stitchers14146993stitchers
stopwatches2151603stopwatches
stretches1438283stretches
swabbies15115713swabbies
swacked173110523swa_cked
swaddles13296453swaddles
swages104417073swa__ges
swaggies13136693swaggies
swales93920763swa__les
swamies123712063swa_mies
swarajes1843743swarajes
swarths13537323swarth_s
swashed144311363swa_shed
swasher134011503swa_sher
swashers14389523swa_shers
swath115920383swat_h__
swats85726863swat___s
swatted114110693swat_ted
swatter104113323swat_ter
swatters113911793swatters
swishes133411373sw_ishes
switch14458913switch__
switchmen1962423switchmen
swithe124010683swit_he_
swither133710993swit_her
swithers144310533swit_hers
swooshes14185123swooshes
taches114224173_ta_ches
teaches122718353tea_ches
thatched1735433thatched
thatcher1635653thatcher
thatchers1744573thatchers
tranches132915513tranches
twattles1154383twattles
twitched17155033twitched
twitcher16135343twitcher
twitchers17134533twitchers
unlatches1444293unlatches
unswathes1544213unswat_hes
unwatched1844083unwatched
vetches153411263_vetches
wackes154717713_wa_ckes
washes124425493_wa_shes
watapes12228383_watapes
watch135617063_watch__
watcheye19104273_watcheye
watcheyes20103743_watcheyes
watchmen1844753_watchmen
wattles103814073_wattles
wauchts15285283_wauchts
welches153710313_welches
wenches152914133_wenches
wiches144418753_w_iches
winches154714373_winches
witched163012193_witched
withes124620843_wit_hes
wretches16257283wretches
wyches17387913_w_yches

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.1731032896.0
2DLD Change Limit1461623067.56319325.9
3Display Results3063060.1232487.8
 (SQL Overall)1786913067.85922737.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.