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

185 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
stanchers1420681(None) 
stancher13198811stancher_
stanches132312791stanche_s
blanchers16307432blanchers
ranchers133311792_ranchers
searchers14197352searchers
snatchers14146312snatchers
stackers143413562sta_ckers
stances93715962stanc_e_s
stanched14208902stanche_d
stanchest14218212stanchest
standers93514302stan_ders
starches131912912starche_s
stauncher1443512stauncher_
staunches1444602staunche_s
stenches132110292stenche_s
stitchers14147012stitchers
anchors123912953__anchors
anthers103715203__anthers
archers124414573__archers
attachers14134883attachers
batchers153613273_batchers
benchers153611013_benchers
blancher15338633blancher_
blanches153311603blanche_s
blenchers16356723blenchers
branches153613803branche_s
brunchers16296253brunchers
cancers114018583_canc_ers
catchers153114063_catchers
chancers154313493chanc_ers
clenchers16276553clenchers
clinchers16336263clinchers
coachers154312303coa_chers
coanchors1645733coanchors
cranches153114543cranche_s
crunchers16316243crunchers
dancers103413093_danc_ers
detachers1536483deta_chers
drenchers15296103drenchers
etchers123411293et__chers
fanciers13358083_fanciers
flinchers17295473flinchers
glancers11408003glanc_ers
hatchers163113173_hatchers
inchers123912523__inchers
lancers93616643_lanc_ers
lanciers10308543_lanciers
launchers1454333launchers
leachers133712813lea_chers
lunchers13349563_lunchers
lynchers16285453_lynchers
manches143818623_manche_s
manchets15269573_manchets
marchers153710813_marchers
matchers153012433_matchers
munchers15318773_munchers
panthers13510783_panthers
patchers153413303_patchers
peachers153213843pea_chers
pinchers153510613_pinchers
planches153111863planche_s
planchets16236743planchets
poachers152910763poa_chers
prancers123210333pranc_ers
punchers152610073_punchers
quenchers2343173quenchers
rancher123013633_rancher_
ranchero13277423_ranchero
rancheros14255793_rancheros
ranches123620113_ranche_s
reachers133515723rea_chers
sachems14348903s_a_chems
sachets123914103s_a_chets
sackers133820223s_a_ckers
sanders84025943s_an_ders
sangers84421943s_an_gers
satchels13328163s_atchels
saucers93712133s_auc_ers
sauciers1076733s_auciers
scanners10379703scan_ners
scorchers16145513scorchers
scratchers1744293scratchers
scutchers16175643scutchers
seances93015343seanc_e_s
searcher13209103searcher_
searches132112903searche_s
skankers11316483skan_kers
sketchers1834513sketchers
slackers143812743sla_ckers
slanders94014013slan_ders
slashers113313613sla_shers
slatches131511523slatche_s
slathers113914783sla_thers
slouchers14185623slouchers
smackers16318713sma_ckers
smashers13339593sma_shers
smoochers16184833smoochers
snackers143010223sna_ckers
snatcher13167763snatcher_
snatches131410713snatche_s
snitchers14166043snitchers
spacers113813873spa_c_ers
spancels1245273spanc_els
spankers14369863span_kers
spanners103710773span_ners
spencers12269193spenc_ers
stabbers12268733sta_bbers
stablers103611153sta_blers
stacker134416263sta_cker_
stactes91914633sta_cte_s
staffers14247083sta_ffers
stagers84116673sta__gers
staggers10379843sta_ggers
stainers83212173sta_iners
staithes1138953staithe_s
stalkers12369853sta_lkers
stammers123611523sta_mmers
stampers124211603sta_mpers
stance84316913stanc_e__
stanch113812373stanch___
stanching1538083stanching
stanchion1444643stanchion
stanchions1543663stanchions
stanchly1644443stanch_ly
standees93310143stan_dees
stander84316163stan_der_
stanes64933403stan__e_s
stanines85115673stanine_s
staplers103111203sta_plers
starched14199313starche_d
starchier1436643starchier_
starers74522313sta__rers
starkers123712393sta_rkers
starters83714773sta_rters
startlers9236743startlers
starvers11459643sta_rvers
stashes103916173sta_she_s
staters73922343sta__ters
staunched1553473staunche_d
staunchest1543123staunchest
staunchness1651693staunchness
stayers103813633sta__yers
stenchier1445333stenchier_
stencilers1243003stencilers
stickers142913033st_ickers
stingers94012743stin_gers
stinkers123111133stin_kers
stinters83312753stin_ters
stitcher13168393stitcher_
stitchery17174073stitchery
stitches131410593stitche_s
stockers143411073st_ockers
stomachers1783893stomachers
stoners74817953ston__ers
stranders10389933stran_ders
strangers104112163stran_gers
stranglers11396823stranglers
stretchers1545173stretchers
stuccoers1342563stuccoers
stunners8277923stun_ners
swanherd1533483swan_herd
swanherds1642543swan_herds
swashers14389533swa_shers
swatches16169963swatche_s
swathers144512083swa_thers
switchers17146633switchers
taches114224173_ta_che_s
tackers134319623_ta_ckers
tanagers9259003_tanagers
tanglers92911973_tanglers
tankers113416913_tan_kers
tanners74018393_tan_ners
teachers133212393_teachers
tenches123515523_tenche_s
thatchers1744583thatchers
tochers123413093_t_ochers
touchers133611213_touchers
tranches132915513tranche_s
trenchers14288073trenchers
unanchors1442613unanchors
watchers163511793_watchers
wenchers16319213_wenchers
winchers16319223_winchers
wrenchers17256333wrenchers

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411856.56322648.3
3Display Results1851850.0802312.5
 (SQL Overall)1786911857.06325299.6
 
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.