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

183 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
drenched1524791(None) 
drencher14257211drencher
drenches14309801drenches
frenched17299431frenched
trenched14289851trenched
wrenched17748131wrenched
bedrenched1942582bedrenched
benched154713942_benched
blenched16358052blenched
branched163210452branched
breached163411642breached
breeched16337382breeched
brunched16317852brunched
clenched16257762clenched
cranched163210412cranched
crunched16328162crunched
drench12369592drench__
drenchers15296102drenchers
flenched17267962flenched
frenches163311632frenches
preached163412062preached
quenched2334102quenched
ranched133113602_ranched
reached134619082_reached
retched133814272_retched
trencher13279312trencher
trenches133512602trenches
wenched163910912_wenched
wrencher16287782wrencher
wrenches163210232wrenches
wretched17276532wretched
arched125717323ar__ched
beached154516553_beached
bedrenches1843453bedrenches
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
danced105315253d_anc_ed
deashed123411303d_eashed
decked145217623d_e_cked
defenced1537203defenc_ed
deiced104214483d_eic_ed
denied84318633d_en_ied
denimed1159233d_enimed
denned84215633d_en_ned
denoted93512763d_enoted
dented84120513d_en_ted
denuded10167663d_enuded
detached1537733detached
deuced104112123d_euc_ed
directed1238233dire_cted
ditched143711903d_itched
douched144012113d_ouched
dreaded103612023dre_aded
dreamed114310633dre_amed
dredged11346893dre_dged
dreed75222843dre___ed
dreich12377723dreich__
drenching16256033drenching
dressed93511873dre_ssed
droned84616863dron__ed
dunches133312583d_unches
eched116919223__e_ched
entrenched1643633entrenched
erected103213993ere_cted
etched123613703__etched
fenced124412713_fenc_ed
fetched163710473_fetched
fleeched17345823fleeched
flenches163410533flenches
fletched17306693fletched
flinched17316703flinched
french143511213french__
frenzied2144043frenzied
frescoed1436053frescoed
freshed143312593fre_shed
glunched1544263glunched
grinches1436943grinches
grouched15356663grouched
grutched15284673grutched
haunched1744813haunched
hunched163710493_hunched
inched124514483__inched
intrenched1644153intrenched
kenches163912273_kenches
kvetched2142783kvetched
launched1475403launched
leached133715043_leached
leched123716003_le_ched
leeched13369503_leeched
letched133912053_letched
lunched133911823_lunched
lynched16376753_lynched
munched153411073_munched
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
retrenched1654393retrenched
roached133211833_roached
ruched124314633_r_uched
screeched17114343screeched
scrunched1744033scrunched
sketched1835393sketched
stanched14208903stanched
stenches132110293stenches
stretched1546213stretched
synched16277213_synched
teched124014433_te_ched
tenches123515523_tenches
tetched133010773_tetched
tranced104414173tranc_ed
tranche123312223tranche_
tranches132915513tranches
trench114211613trench__
trenchers14288073trenchers
trended94011763tren_ded
unreached1536883unreached
upreached1764083upreached
welched16298833_welched
wencher153811133_wencher
wenches152914133_wenches
winched163110593_winched
wreathed15257463wreathed
wrecked17418333wre_cked
wrench14439353wrench__
wrenchers17256333wrenchers
wretches16257283wretches

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.423422437.4
2DLD Change Limit1461621837.48319532.5
3Display Results1831830.0802287.5
 (SQL Overall)1786911837.98622375.5
 
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.