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

316 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
stanches13231279(None) 
stances93715961stanc_es
stanched14208901stanched
stancher13198801stancher
stanchers14206801stanchers
stanchest14218211stanchest
starches131912911starches
staunches1444601staunches
stenches132110291stenches
blanches153311602blanches
branches153613802branches
cranches153114542cranches
manches143818622_manches
planches153111862planches
ranches123620112_ranches
seances93015342seanc_es
searches132112902searches
slatches131511522slatches
snatches131410712snatches
stactes91914632sta_ctes
staithes1138952staithes
stance84316912stanc_e_
stanch113812372stanch__
stanchly1644442stanchly
standees93310142standees
stanes64933402stan__es
stanines85115662stanines
starched14199312starched
stashes103916162sta_shes
staunched1553472staunched
stauncher1443502stauncher
staunchest1543122staunchest
stitches131410592stitches
swatches16169962swatches
taches114224172_ta_ches
tenches123515522_tenches
tranches132915512tranches
aches106132293__a_ches
anchos114214893__anchos
apaches143411833apa_ches
arches114822043__arches
attaches13137723attaches
baches135426943_ba_ches
batches144019613_batches
beaches144120653bea_ches
benches143918603_benches
blanched16308603blanched
blancher15338633blancher
blanchers16307433blanchers
blenches153310763blenches
braches144621223bra_ches
branched163210453branched
brunches153710453brunches
bunches144116033_bunches
caches137926913_ca_ches
canchas143212403_canchas
catches144320763_catches
chances145218093chanc_es
chancres15429363chancres
chinches18369363chinches
cinches144215773_cinches
clenches152910953clenches
clinches153910363clinches
coaches144018693coa_ches
conches144019813_conches
cranched163210413cranched
cratches153012543cratches
craunches1655723craunches
crunches153711353crunches
dances95120653_danc_es
detaches1439653deta_ches
distances12311653distanc_es
drenches14309803drenches
dunches133312583_dunches
estancias1145003estancias
etches114217763et__ches
fancies124018783_fancies
fiancees1335103fiancees
fiances12310673fianc_es
finches153914193_finches
flenches163410533flenches
flinches16358953flinches
frenches163311633frenches
ganaches1437413_ganaches
glances104113143glanc_es
glunches1436263glunches
grinches1436943grinches
hances115621283_hanc_es
hatches153420273_hatches
haunches1656963haunches
hunches153913463_hunches
inarches1358043inarches
inches114419673__inches
instances1148743instanc_es
instancies1246613instancies
itches114916213it__ches
kenches163912273_kenches
klatches17157133klatches
laches116528343_la_ches
lances84824103_lanc_es
larches124416443_larches
latches123320123_latches
launches1387903launches
leaches123319343lea_ches
loaches123613983loa_ches
lunches124115443_lunches
lynches15378873_lynches
maches134827233_ma_ches
manche133515103_manche_
manchet143317773_manchet
manchets15269573_manchets
marches143921173_marches
matches143219783_matches
munches144215793_munches
mustaches16166053musta_ches
naches114622413_na_ches
nances83618643_nanc_es
nancies93516843_nancies
nuances938523nuanc_es
oraches124216473ora_ches
ostriches1446633ostriches
painches1588913painches
panaches15310283_panaches
panoches1548123_panoches
parches143720003_parches
patches143320383_patches
paunches1568173paunches
peaches144120053pea_ches
pinches144117933_pinches
pistaches1646673pista_ches
planche14299753planche_
planchet152511963planchet
planchets16236743planchets
plenches153110623plenches
poaches144416943poa_ches
prances113618773pranc_es
punches144816133_punches
quaiches2235343quaiches
quenches2236013quenches
rances84625443_ranc_es
ranched133113603_ranched
rancher123013633_rancher
ranchers133311793_ranchers
ranchos123911393_ranchos
ratches123620463_ratches
raunches1368053raunches
reaches123423203rea_ches
revanches1746253revanches
roaches123616213roa_ches
sachem134012223s_a_chem
sachems14348903s_a_chems
sachet114725773s_a_chet
sachets123914103s_a_chets
sadhes104715373s_a_dhes
saices84221803s_aic_es
sandhis1139993s_andhis
sanes55649073s_an__es
sanghs105312063s_angh_s
sanicles10149943s_anicles
sanies63031953s_an_ies
sashes94728483s_a_shes
satchel123310303s_atchel
satchels13328163s_atchels
sauces84919503s_auc_es
sauchs115112233s_auch_s
scanties103215413scanties
scathes124515713sca_thes
sconces113811453sconc_es
scooches15188413scooches
scorches15189143scorches
scotches15179473scotches
scratches1647313scratches
scrunches1635403scrunches
sculches15176273sculches
scutches15168883scutches
seance83716683seanc_e_
searched14209253searched
searcher13209103searcher
searchers14197353searchers
seiches12513813s_eiches
seviches1635803seviches
shanachies1844263shanachies
shandies122714103shandies
shannies113411253shannies
shanties113116573shanties
sketches1746823sketches
slashes103619103sla_shes
slouches13208073slouches
smashes123914613sma_shes
smirches1535993smirches
smooches15217263smooches
smutches15177273smutches
snashes105214753sna_shes
snatched14157633snatched
snatcher13167753snatcher
snatchers14146303snatchers
snathes104816493sna_thes
snitches13148983snitches
sonances10310263sonanc_es
soroches1338803soroches
soutaches1446443souta_ches
spaces104722633spa_c_es
spancel1147363spanc_el
spancels1245273spancels
spangles1138893spangles
spathes125116533spa_thes
speeches1537413speeches
spences113413923spenc_es
spinaches1645273spinaches
squinches2344253squinches
stabiles10311403stabiles
stables93219073sta_bles
stacked143416123sta_cked
stacker134416263sta_cker
stackers143413563sta_ckers
stacks124317263sta_c_ks
stacte82113913sta_cte_
staddles10258693staddles
stades74626243sta__des
stages75629493sta__ges
staggies101210323staggies
stagnates1046733stagnates
staithe1037723staithe_
stakes103927293sta__kes
stales65538293sta__les
stanching1538083stanching
stanchion1444643stanchion
stanchions1543663stanchions
standbys1443203standbys
standee83514513stan_dee
stander84316163stan_der
standers93514303standers
standishes1445713standishes
stands75118053stan__ds
standups1143963standups
stane55933003stan__e_
staned74824643stan__ed
stanged94113843stan_ged
stangs75018163stan__gs
stanhopes1444453stanhopes
stanine73417073stanine_
stanks104917703stan__ks
stannites947013stannites
stannous846443stannous
stannums1043803stannums
stanols739733stan_ols
stanzaed1843873stanzaed
stanzas1636363stan_zas
stapedes11197753stapedes
stapes85028733sta__pes
staphs114411033sta_ph_s
staples93617213sta_ples
starch113013203starch__
starchier1436643starchier
starchiest1547183starchiest
starchy15286743starch_y
stares66038753sta__res
starnoses9157143starnoses
startles82111963startles
starves104614553sta_rves
stases64225563sta__ses
stashed113812483sta_shed
states64337083sta__tes
statices102712343statices
statives112710793statives
statues74614903sta_tues
statures83711113statures
statuses8409533statuses
statutes8368893statutes
staunch1244273staunch__
staunchly1742033staunchly
staunchness1651693staunchness
staves94525193sta__ves
stench114111163stench__
stenchier1445333stenchier
stenchiest1545083stenchiest
stenchy15256213stench_y
stencils1046403stencils
stenoses8310443stenoses
stichs114511653st_ich_s
stitched14148203stitched
stitcher13168383stitcher
stitchers14146993stitchers
stones65130033ston__es
stonishes1247363stonishes
stranges94516763stran_ges
strangles103011553strangles
stretches1438283stretches
strophes13310593strophes
stuccoes1254273stuccoes
subniches1665143subniches
swashes134714403swa_shes
swathes134115513swa_thes
switches16159133switches
synched16277213s_ynched
synchs14408453s_ynch_s
taces76237803_ta_c_es
tache106222373_ta_che_
tachs105820933_ta_ch_s
takahes1436173_takahes
tangles83920043_tangles
tansies74521243_tansies
teaches122718353_teaches
thatches1637513thatches
torches123715433_torches
touches125118343_touches
trances93919643tranc_es
tranche123312223tranche_
trenches133512603trenches
troches123715343_troches
tusches1237903_tusches
usances967373usanc_es
watches153017373_watches
wenches152914133_wenches
winches154714373_winches
wrenches163210233wrenches

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.203880251.2
2DLD Change Limit1461623166.78321548.3
3Display Results3163160.1232569.1
 (SQL Overall)1786913167.10925135.9
 
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.