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

234 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
stancher1319881(None) 
stanched14208901stanched
stanchers14206811stanchers
stanches132312791stanches
stauncher1443511stauncher
blancher15338632blancher
rancher123013632_rancher
searcher13209102searcher
snatcher13167762snatcher
stacker134416262sta_cker
stance84316912stanc_e_
stances93715962stanc_es
stanch113812372stanch__
stanchest14218212stanchest
stanchly1644442stanchly
stander84316162stan_der
starched14199312starched
starches131912912starches
starchier1436642starchier
staunched1553472staunched
staunches1444602staunches
stenches132110292stenches
stenchier1445332stenchier
stitcher13168392stitcher
anchor113911973__anchor
anther93715063__anther
archer115016243__archer
attacher13125713attacher
batcher144414853_batcher
bencher144113483_bencher
blanched16308603blanched
blanchers16307433blanchers
blanches153311603blanches
blencher15308393blencher
branched163210453branched
branches153613803branches
branchier1637133branchier
bruncher15347783bruncher
cancer104220923_canc_er
catcher143115823_catcher
chancer144215633chanc_er
chancier1538823chancier
clencher15277973clencher
clincher15347663clincher
coacher143714123coa_cher
coanchor1545253coanchor
cranched163210413cranched
cranches153114543cranches
cruncher15338073cruncher
dancer94817613_danc_er
detacher1437543deta_cher
drencher14257213drencher
etcher113912943et__cher
fancier123412063_fancier
flincher16256583flincher
gaucher1337233_gaucher
glancer103710073glanc_er
hatcher153314723_hatcher
incher114114033__incher
lancer84319973_lanc_er
launcher1365563launcher
leacher124014843lea_cher
luncher123111413_luncher
lyncher15366553_lyncher
manche133515103_manche_
manches143818623_manches
manchet143317773_manchet
marcher143912973_marcher
matcher143214283_matcher
muncher143610373_muncher
panther12611443_panther
patcher143515143_patcher
peacher144216073pea_cher
pincher143812713_pincher
planche14299753planche_
planches153111863planches
planchet152511963planchet
poacher143912323poa_cher
prancer113613383pranc_er
puncher143311673_puncher
quencher2234123quencher
ranched133113603_ranched
ranchero13277423_ranchero
ranchers133311793_ranchers
ranches123620113_ranches
reacher123718293rea_cher
sachem134012223s_a_chem
sachet114725773s_a_chet
sacker125124843s_a_cker
sander74828533s_an_der
sandier84017843s_andier
saner54334323s_an__er
sanger74524563s_an_ger
satchel123310303s_atchel
saucer84314103s_auc_er
saucier9810283s_aucier
scanner94411813scan_ner
scanter94215183scan_ter
scantier10309983scantier
scarcer113911373scarc_er
scorcher15196783scorcher
scratcher1635443scratcher
scutcher15176963scutcher
seance83716683seanc_e_
seances93015343seanc_es
searched14209253searched
searchers14197353searchers
searches132112903searches
skanker10268483skan_ker
skankier11184883skankier
sketcher1735433sketcher
slacker133915293sla_cker
slander84015443slan_der
slangier9117933slangier
slasher104515333sla_sher
slatches131511523slatches
slather103816073sla_ther
sloucher13206813sloucher
smacker153410583sma_cker
smasher123911023sma_sher
smoocher15205503smoocher
snacker133112603sna_cker
snatched14157633snatched
snatchers14146313snatchers
snatches131410713snatches
snatchier1455353snatchier
snitcher13157373snitcher
spacer104917793spa_c_er
spacier114011633spa_cier
spancel1147363spanc_el
spanker133612353span_ker
spanner94312563span_ner
spencer113610973spenc_er
stabber113610153sta_bber
stabler94014933sta_bler
stacked143416123sta_cked
stackers143413563sta_ckers
stacte82113913sta_cte_
stactes91914633sta_ctes
staffer13299093sta_ffer
stager74821343sta__ger
stagger94212393sta_gger
staggier10167513staggier
stagier83513443sta_gier
staider83912613sta_ider
stainer73614923sta_iner
staithe1037723staithe_
staithes1138953staithes
staler64025823sta__ler
stalker113912253sta_lker
stalkier1257073stalkier
stammer116013343sta_mmer
stamper113714403sta_mper
stanching1538083stanching
stanchion1444643stanchion
standee83514513stan_dee
standees93310143standees
standers93514303stan_ders
stane55933003stan__e_
staned74824643stan__ed
stanes64933403stan__es
stanged94113843stan_ged
stanine73417073stanine_
stanines85115673stanines
stanzaed1843873stanzaed
stapler93913633sta_pler
starch113013203starch__
starchy15286743starch_y
starer64027363sta__rer
starker114114693sta_rker
starrier8279463starrier
starter73817883sta_rter
startler8248793startler
starver104611993sta_rver
stashed113812493sta_shed
stashes103916173sta_shes
stater64427563sta__ter
staunch1244273staunch__
staunchest1543123staunchest
staunchly1742033staunchly
stayer94516483sta__yer
stench114111163stench__
stenchy15256213stench_y
stenciler1143783stenciler
sticker133515883st_icker
stinger84314683stin_ger
stingier9279123stingier
stinker113313313stin_ker
stinkier12278543stinkier
stinter73614513stin_ter
stitched14148203stitched
stitchers14147013stitchers
stitchery17174073stitchery
stitches131410593stitches
stocker133713083st_ocker
stomacher1694273stomacher
stoner65823203ston__er
stonier72013793ston_ier
strander97112063stran_der
stranger94715103stran_ger
strangler10369473strangler
stretcher1446293stretcher
stricter1039423stricter
stuccoer1252803stuccoer
stunner7349193stun_ner
swanherd1533483swan_herd
swanker14369483swan_ker
swankier15225503swankier
swasher134011513swa_sher
swatches16169963swatches
swather134213603swa_ther
switcher16177683switcher
synched16277213s_ynched
tache106222373_ta_che_
taches114224173_ta_ches
tacker124224503_ta_cker
tanager83010943_tanager
tangier83013903_tangier
tangler83515073_tangler
tanker104521123_tan_ker
tanner63722283_tan_ner
teacher123714833_teacher
tenches123515523_tenches
thatcher1635663thatcher
tocher114014913_t_ocher
toucher124814353_toucher
tranche123312223tranche_
tranches132915513tranches
trencher13279313trencher
unanchor1343093unanchor
watcher153113403_watcher
wencher153811133_wencher
wincher153410653_wincher
wrencher16287783wrencher

Search took 10 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.830215290.4
2DLD Change Limit1461622348.25017716.6
3Display Results2342340.0932516.1
 (SQL Overall)1786912349.17319480.1
 
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.