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

260 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
stenches13211029(None) 
stanches132312791stanches
tenches123515521_tenches
benches143918602_benches
blenches153310762blenches
clenches152910952clenches
drenches14309802drenches
flenches163410532flenches
frenches163311632frenches
kenches163912272_kenches
plenches153110622plenches
quenches2236012quenches
seiches12513812s_eiches
sketches1746822sketches
speeches1537412speeches
spences113413922spenc_es
stances93715962stanc_es
stanched14208902stanched
stancher13198812stancher
stanchers14206812stanchers
stanchest14218212stanchest
starches131912912starches
staunches1444602staunches
stench114111162stench__
stenchier1445332stenchier
stenchiest1545082stenchiest
stenchy15256212stench_y
stencils1046402stencils
stenoses8310442stenoses
stitches131410592stitches
stretches1438292stretches
teaches122718352_teaches
trenches133512602trenches
wenches152914132_wenches
wrenches163210232wrenches
agencies1138743agencies
attaches13137723attaches
beaches144120653_beaches
beeches143413883_beeches
belches143514343_belches
benched154713943_benched
bencher144113483_bencher
benchers153611013_benchers
blanches153311603blanches
bleaches153410673bleaches
blenched16358053blenched
blencher15308393blencher
blenchers16356723blenchers
branches153613803branches
breaches153714123breaches
breeches15258673breeches
brunches153710453brunches
bunches144116033_bunches
chinches18369373chinches
cinches144215773_cinches
clenched16257763clenched
clencher15277973clencher
clenchers16276553clenchers
clinches153910363clinches
conches144019813_conches
cranches153114543cranches
creches14313093cre_ches
crunches153711353crunches
detaches1439653detaches
drenched15247913drenched
drencher14257213drencher
drenchers15296103drenchers
dunches133312583_dunches
eches106322163__e_ches
elenchus1343643elenchus
entrenches1545213entrenches
essences1047563essenc_es
etches114217763__etches
fences114617113_fenc_es
fetches153413893_fetches
fetiches1636953fetiches
finches153914193_finches
fleches153411443fle_ches
fleeches16287083fleeches
flenched17267963flenched
fletches16308853fletches
flinches16358953flinches
frenched17299433frenched
glunches1436263glunches
grinches1436953grinches
haunches1656963haunches
hunches153913463_hunches
inches114419673__inches
intrenches1545813intrenches
itches114916213it__ches
ketches164012193_ketches
kvetches2053583kvetches
latencies1147773latencies
launches1387903launches
leaches123319343_leaches
leches115421313_le_ches
leeches123911933_leeches
letches124015483_letches
lunches124115443_lunches
lynches15378873_lynches
manches143818623_manches
mensches1536303_mensches
menshes12310453_menshes
merches144013763_merches
misteaches1744993misteaches
munches144215793_munches
ostriches1446633ostriches
painches1588923painches
patencies1349183patencies
paunches1568173paunches
peaches144120053_peaches
penoches1538933_penoches
penuches1536943_penuches
perches143717953_perches
pinches144117933_pinches
planches153111863planches
pleaches153210433pleaches
potences12710693potenc_es
potencies1369303potencies
preaches153214893preaches
punches144816133_punches
quenched2334103quenched
quencher2234123quencher
quenchers2343173quenchers
ranches123620113_ranches
raunches1368053raunches
reaches123423203_reaches
retches123318513_retches
reteaches1437123reteaches
retrenches1545913retrenches
scenes84520353scen__es
sciences1238783scienc_es
sconces113811453sconc_es
scooches15188413scooches
scorches15189153scorches
scotches15179473scotches
screeches1695653screeches
scrunches1635403scrunches
sculches15176273sculches
scutches15168883scutches
seances93015343seanc_es
searches132112903searches
seethes103613743s_eethes
seiche11811833s_eiche_
senates73322613s_enates
seniles72618023s_eniles
senores73218113s_enores
senses63923943s_en_ses
sentences11610303sentenc_es
seviches1635803seviches
sheathes14610193sheathes
sheuchs15234933sheuch_s
sienites8311913sienites
silences10310083silenc_es
skenes104616633sken__es
sketched1835393sketched
sketcher1735433sketcher
sketchers1834513sketchers
slatches131511533slatches
slouches13208073slouches
smirches1535993smirches
smooches15217263smooches
smutches15177273smutches
snatches131410713snatches
sneeshes1136513sneeshes
snitches13148983snitches
soroches1338803soroches
species11314133spe_cies
spence103813793spenc_e_
spencer113610973spenc_er
spencers12269193spencers
spenses92913573spen_ses
spinaches1645273spinaches
squelches2343363squelches
squinches2344253squinches
stactes91914633st_actes
staithes1138953staithes
stance84316913stanc_e_
stanch113812373stanch__
stanchly1644443stanchly
standees93310143standees
stanes64933403stan__es
stanines85115673stanines
starched14199313starched
stashes103916173st_ashes
staunched1553473staunched
stauncher1443513stauncher
staunchest1543123staunchest
steadies9311123steadies
steelies8312553steelies
steeples1038013steeples
steeves103410903ste_eves
steles63725663ste__les
stenchful1751953stenchful
stencil946893stenc_il
stenciled1243963stenciled
stenciler1143783stenciler
stencilers1243003stencilers
stengahs1243393stengahs
stenokies1345313stenokies
stenos63915773sten__os
stenosed946343stenosed
stenosis847993stenosis
stentors839753stentors
stents65019453sten__ts
steppes113110693ste_ppes
steres63929533ste__res
sternites9310073sternites
stichs114511653st_ich_s
stitched14148203stitched
stitcher13168393stitcher
stitchers14147013stitchers
stones65130033ston__es
stonishes1247363stonishes
stretched1546213stretched
stretcher1446293stretcher
stretchers1545173stretchers
strophes13310603strophes
stuccoes1254273stuccoes
subniches1665153subniches
swatches16169963swatches
switches16159133switches
syenites1138943syenites
synched16277213s_ynched
synchs14408453s_ynch_s
taches114224173_t_aches
teacher123714833_teacher
teachers133212393_teachers
teched124014433_te_ched
techies12513603_te_chies
techs106915833_te_ch_s
teethes103611653_teethes
tenaces92814513_tenaces
tench105620003_tench__
tennies73017973_tennies
tenses64722553_ten_ses
tenths94412663_tenth_s
tenues63816443_ten_ues
tenures7412013_tenures
terces83921413_terc_es
tetched133010773_tetched
torches123715443_torches
touches125118343_touches
tranches132915513tranches
trenched14289853trenched
trencher13279313trencher
trenchers14288073trenchers
troches123715343_troches
tusches1237903_tusches
unteaches1446083unteaches
vetches153411263_vetches
welches153710313_welches
wenched163910913_wenched
wencher153811133_wencher
wenchers16319213_wenchers
winches154714373_winches
wrenched17748133wrenched
wrencher16287783wrencher
wrenchers17256333wrenchers
wretches16257283wretches

Search took 9 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.423422437.4
2DLD Change Limit1461622607.67019056.3
3Display Results2602600.1102363.6
 (SQL Overall)1786912608.20321783.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.