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

281 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
drench1236959(None) 
dreich12377721dreich
french143511211french
trench114211611trench
wrench14439351wrench
bedrench1644152bedrench
bench125619502_bench
blench133710452blench
branch134014772branch
breach134213722breach
breech13348262breech
brunch13329352brunch
clench133910052clench
cranch133613532cranch
crunch13349502crunch
dreck124812802dre_ck
dreigh11246442dreigh
drenched15247912drenched
drencher14257212drencher
drenches14309802drenches
dunch115316262d_unch
flench144010812flench
grinch1238472grinch
kench145513922_kench
plench134010812plench
preach133613922preach
quench2036632quench
ranch105019792_ranch
reach105123882_reach
retch104818302_retch
stench114111162stench
tench105620002_tench
wench136214782_wench
wretch14326532wretch
adrenal838263adrenal
agency1237033agency
arch98628443ar__ch
ardency1346483ardency
areca75618633are_ca
areic73219393areic_
arena55323813aren_a
arenas65021993arenas
arene55329413aren_e
arenes64928393arenes
beach124623893_beach
beech124315503_beech
belch124415503_belch
blanch133410853blanch
bleach133611403bleach
brach126123303br_ach
branchy17357913branchy
breath113916263breath
bren65629563bren__
brens75823363bren_s
brent75734133bren_t
brents84717273brents
broach133611113broach
bronc91714343bronc_
bronchi14176313bronchi
broncho14206463broncho
bronco10179493bronco
broncs101611153broncs
brooch13368443brooch
bunch125118603_bunch
chinch163911223chinch
cinch124516243_cinch
clinch133910353clinch
conch124620073_conch
cratch134110793cratch
craunch1464443craunch
creche13310763cre_che
creesh11328333creesh
crenel84213063crenel
crotch133410083crotch
crouch133910203crouch
crunchy17324763crunchy
crutch13408243crutch
dance85223133d_ance
deash95617243d_eash
death94822523d_eath
decency1537453decency
deck115827753d_e_ck
deco76125973d_e_co
defence1339893defence
deice84320033d_eice
den47554343d_en__
denar65223293d_enar
dene56643413d_en_e
denes65639723d_enes
deni56929393d_en_i
denim85518843d_enim
dens55945073d_en_s
dense65923503d_ense
dent57158413d_en_t
dents65031803d_ents
deny86027123d_en_y
depth114311853d_epth
detach12310413detach
deuce84517493d_euce
diene65720133dien_e
dienes75719903dienes
direct93817333dire_ct
ditch115015093d_itch
doeth9411983doe_th
dorneck1444303dorneck
dozenth2044323dozenth
drachm1436493dr_achm
drank104816203dran_k
dread74419023dre_ad
dreads84115023dreads
dream85120393dre_am
dreams94513983dreams
dreamt94615713dreamt
dreamy12509993dreamy
drear65016903dre_ar
drears74614253drears
dreary104611673dreary
drecks13459203drecks
drecky16486333drecky
dredge9308553dredge
dree56638323dre__e
dreed75222843dre_ed
drees65628523dre_es
dreg66821653dre__g
dreggy12364633dreggy
dregs76114863dre_gs
dreidl835233dreidl
drek96321083dre__k
dreks105714743dre_ks
drenchers15296103drenchers
drenching16256033drenching
dress65319833dre_ss
dressy10518143dressy
drest65530343dre_st
drew86221673dre__w
driegh11254563driegh
drink106816383drin_k
drinks116810713drinks
drone65324983dron_e
droned84616863droned
droner74717673droner
drones75023433drones
drongo836793drongo
dronish1138913dronish
drouth104410103drouth
drunk10549843drun_k
drunks11427513drunks
dryish1336323dryish
duende836923duende
duenna734593duenna
dunce86319263d_unce
durance1059113durance
dutch114713823d_utch
each95530583__each
elenchi1244713elenchi
entrench13115723entrench
erect74129333ere_ct
erenow937373erenow
etch95419143__etch
fence105319913_fence
fetch134913473_fetch
finch135416973_finch
fleech14367343fleech
fletch14388193fletch
flinch144010103flinch
franc104615413franc_
francs114112193francs
frena85915273fren_a
frenched17299433frenched
frenches163311633frenches
frenum1188803frenum
frenzy2135883frenzy
fresco1136473fresco
fresh115012203fre_sh
glunch1255353glunch
greenth11116723greenth
grouch12318473grouch
grutch12285563grutch
haunch14377343haunch
hence104920043_hence
heuch135312333_heuch
hunch136416213_hunch
inch95420823__inch
intrench1396593intrench
irenic8311103irenic
irenics937833irenics
ketch144912023_ketch
kvetch1832993kvetch
launch11368063launch
leach105422523_leach
lech96825443_le_ch
leech104913213_leech
letch105215803_letch
lunch104917243_lunch
lynch13468983_lynch
mensch13387083_mensch
mensh105413553_mensh
merch125417963_merch
munch124917103_munch
orach105219233or_ach
painch133511323painch
paunch13369853paunch
peach125422493_peach
pech116125453_pe_ch
pence94924453_pence
perch124518833_perch
pinch125619303_pinch
planch133711443planch
pleach134211243pleach
prance104318573prance
preachy17307313preachy
preact103220393preact
prelunch1543433prelunch
prepunch1743643prepunch
prince104114763prince
punch125118423_punch
rance75028513_rance
rancho114310853_rancho
ratch104221363_ratch
raunch11358433raunch
react74634333_react
rec55645463_re_c_
recce9514563_recce
reck106130563_re_ck
recs65734183_re_cs
reecho11318653_reecho
reechy14367823_reechy
renal55929503_renal
rend56136573_ren_d
rends65129953_rends
renew83917513_renew
renig64518913_renig
renin54830033_renin
rent46661243_ren_t
rente54733783_rente
rents55935183_rents
resh76523453_re_sh
retrench1346283retrench
rich97025543_r_ich
roach105717003_roach
rotch105815933_rotch
screech1435213screech
scrunch1444033scrunch
sheuch14267043sheuch
sketch1535353sketch
speech1347563speech
spence103813793spence
stanch113812373stanch
stenchy15256213stenchy
stretch1236413stretch
synch135011793_synch
teach105221123_teach
tech95925443_te_ch
tenth85421833_tenth
teuch105214853_teuch
thence112010843thence
trance84718763trance
tranche123312223tranche
trefah1235093trefah
trenched14289853trenched
trencher13279313trencher
trenches133512603trenches
trend64817453tren_d
trends75513543trends
trendy10469603trendy
upreach1444693upreach
ureic74514463ureic_
urgency1345663urgency
vetch134411843_vetch
welch134411493_welch
whence14187923whence
winch135016663_winch
wreath124111193wreath
wreck144611043wre_ck
wren78221683wren__
wrenched17748133wrenched
wrencher16287783wrencher
wrenches163210233wrenches
wrens85016243wren_s
yecch15558093_yecch
yech127220533_ye_ch

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 Filter1786911127160.266671770.7
2DLD Change Limit1127162817.45315123.6
3Display Results2812810.0933021.5
 (SQL Overall)1786912817.81222873.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.