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

226 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
trenched1428985(None) 
drenched15247911drenched
frenched17299431frenched
trencher13279311trencher
trenches133512601trenches
wrenched17748131wrenched
benched154713942_benched
blenched16358052blenched
branched163210452branched
breached163411642breached
breeched16337382breeched
brunched16317852brunched
clenched16257762clenched
cranched163210412cranched
crunched16328162crunched
drencher14257212drencher
drenches14309802drenches
entrenched1643632entrenched
flenched17267962flenched
frenches163311632frenches
intrenched1644152intrenched
preached163412062preached
quenched2334102quenched
ranched133113602_ranched
reached134619082_reached
retched133814272_retched
retrenched1654392retrenched
stretched1546212stretched
teched124014432t_e_ched
tenches123515522t_enches
tetched133010772t_etched
tranced104414172tranc_ed
tranche123312222tranche_
tranches132915512tranches
trench114211612trench__
trenchers14288072trenchers
trended94011762tren_ded
wenched163910912_wenched
wrencher16287782wrencher
wrenches163210232wrenches
wretched17276532wretched
arched125717323ar__ched
beached154516553_beached
bedrenched1942583bedrenched
belched154011843_belched
bencher144113483_bencher
benches143918603_benches
blanched16308603blanched
bleached16378563bleached
blencher15308393blencher
blenches153310763blenches
branches153613803branches
breacher153011503breacher
breaches153714123breaches
breathed14469643breathed
breeches15258673breeches
broached16309123broached
bruncher15347783bruncher
brunches153710453brunches
bunched154312413_bunched
cinched153910863_cinched
clencher15277973clencher
clenches152910953clenches
clinched16347383clinched
cranches153114543cranches
craunched1764023craunched
creche13310763cre_che_
creches14313093cre_ches
creeshed1435693creeshed
crenated113013913crenated
creneled11326893creneled
crotched16428593crotched
crouched16359143crouched
cruncher15338073cruncher
crunches153711353crunches
crutched16307463crutched
drench12369593drench__
drenchers15296103drenchers
eched116919223__e_ched
entrenches1545213entrenches
erected103213993ere_cted
etched123613703__etched
fenced124412713_fenc_ed
fetched163710473_fetched
fleeched17345823fleeched
flenches163410533flenches
fletched17306693fletched
flinched17316703flinched
french143511213french__
frenzied2144043frenzied
frescoed1436053frescoed
freshed143312593fre_shed
glunched1544263glunched
grinches1436953grinches
grouched15356663grouched
grutched15284673grutched
haunched1744813haunched
hunched163710493_hunched
inched124514483__inched
intrenches1545813intrenches
kenches163912273_kenches
kvetched2142783kvetched
launched1475403launched
leached133715043_leached
leched123716003_le_ched
leeched13369503_leeched
letched133912053_letched
lunched133911823_lunched
lynched16376753_lynched
munched153411073_munched
outreached1645003outreached
paunched1645523paunched
peached154315883_peached
peched144915343_pe_ched
perched154713243_perched
pinched153812453_pinched
pleached16338063pleached
plenches153110623plenches
pranced123714043pranc_ed
preacher153211373preacher
preaches153214893preaches
preacted132710943preacted
prepunched2073113prepunched
punched153512173_punched
quencher2234123quencher
quenches2236013quenches
rancher123013633_rancher
ranches123620113_ranches
reacher123718293_reacher
reaches123423203_reaches
reacted103015713_reacted
rechew14310213_re_chew
recked134821803_re_cked
reechoed1436083_reechoed
renamed103114523_renamed
rended84524103_ren_ded
reneged92010763_reneged
renewed11309993_renewed
rented74426593_ren_ted
rescued10410043_rescued
retches123318513_retches
retrenches1545903retrenches
roached133211833_roached
ruched124314633_r_uched
screeched17114343screeched
scrunched1744033scrunched
sketched1835393sketched
stanched14208903stanched
staunched1553473staunched
stenches132110293stenches
stretcher1446293stretcher
stretches1438293stretches
synched16277213_synched
teacher123714833t_eacher
teaches122718353t_eaches
teenaged10105133teenaged
teethed11318623t_eethed
tench105620003t_ench__
tended83819483t_en_ded
tenoned839363t_enoned
tensed74817833t_en_sed
tented74221003t_en_ted
tenured838363t_enured
thatched1735433thatched
thence112010843thenc_e_
threshed1535643thre_shed
tierced10347053tierc_ed
tincted1037273t_incted
torched133511363t_orched
touched134914963t_ouched
traced94821583tr_ac_ed
trachea12311683tr_achea
tracheid1437583tr_acheid
trachled1438313tr_achled
tracked143716133tr_acked
trance84718763tranc_e_
trances93919643tranc_es
trashed113514703tr_ashed
trauchled1543733trauchled
treachery1744693treachery
treacle939973treacle_
treacles1039703treacles
treaded95014283tre_aded
treadled1067123treadled
treated83618703tre_ated
trebled1038483tre_bled
trebuchet1684073trebuchet
treddled1134473treddled
treed65626733tre___ed
trekked1134343tre_kked
trembled1335253trembled
trenchant1446343trenchant
trenching15227653trenching
trend64817453tren___d
trendier937913trendier
trendies9312213trendies
trendoid1045453trendoid
tressed83714263tre_ssed
triced95518673tr_ic_ed
tricked144016163tr_icked
trindled10388693trindled
trined74920713trin__ed
troche113112513tr_oche_
trochee122613883tr_ochee
troches123715343tr_oches
trocked144312243tr_ocked
trothed114010973tr_othed
trounced1135033trounc_ed
truced95312053tr_uc_ed
trucked143910813tr_ucked
truncated1244583truncated
truncheon1442833truncheon
trundled10306393trundled
trunked12358413trun_ked
twitched17155033twitched
unreached1536883unreached
upreached1764083upreached
welched16298833_welched
wencher153811133_wencher
wenches152914133_wenches
winched163110593_winched
wreathed15257463wreathed
wrecked17418333wre_cked
wrench14439353wrench__
wrenchers17256333wrenchers
wretches16257283wretches

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.860207780.2
2DLD Change Limit1461622268.15617920.8
3Display Results2262260.0932430.1
 (SQL Overall)1786912269.10919617.0
 
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.