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

282 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
blench13371045(None) 
bench125619501b_ench
blanch133410851blanch
bleach133611401bleach
clench133910051clench
flench144010811flench
plench134010811plench
beach124623892b_each
beech124315502b_eech
belch124415502b_elch
blenched16358052blenched
blencher15308392blencher
blenches153310762blenches
blend85317452blen_d
blende95413442blende
blends96012882blends
blenny1156202blenny
blent76230952blen_t
blotch13197142blotch
branch134014772branch
breach134213722breach
breech13348262breech
brunch13329352brunch
bunch125118602b_unch
clinch133910352clinch
drench12369592drench
elenchi1244722elenchi
fleech14367342fleech
fletch14388192fletch
flinch144010102flinch
french143511212french
glunch1255352glunch
kench145513922_kench
leach105422522_leach
lech96825442_le_ch
leech104913212_leech
letch105215802_letch
lunch104917242_lunch
lynch13468982_lynch
planch133711442planch
pleach134211242pleach
quench2036632quench
stench114111162stench
tench105620002_tench
trench114211612trench
wench136214782_wench
wrench14439352wrench
absence1137713absence
agency1237033agency
alec66430063ale_c_
alecs76620733ale_cs
alencon945733alencon
aleph10311393ale_ph
bach116131393b__ach
balance11510263balance
banco94019393b_anco
batch124620103b_atch
beachy164011253b_eachy
beck126226573b_e_ck
bedrench1644153bedrench
beechy16397503b_eechy
been65335783been__
ben56554923b_en__
benched154713943b_enched
bencher144113483b_encher
benches143918603b_enches
bend76435263b_en_d
bends85628973b_ends
bendy115017253b_endy
bene66439493b_en_e
benes75536233b_enes
benne76521123b_enne
benni74715363b_enni
benny105217363b_enny
bens65945703b_en_s
bent67759913b_en_t
bento75922953b_ento
bents76033693b_ents
berth104917883b_erth
beseech1453873beseech
beth96629233b_e_th
birch124914023b_irch
bitch125017763b_itch
black134719073bl_ack
blah98625063bl__ah
blanched16308603blanched
blancher15338633blancher
blanches153311603blanches
bland85320453blan_d
blank115418553blan_k
blanks124112893blanks
bleached16378563bleached
bleacher15358883bleacher
bleaches153410673bleaches
bleak115915383ble_ak
bleaks125112433bleaks
blear75918683ble_ar
blears85116453blears
bleary115112553bleary
bleat75737003ble_at
bleats85518613bleats
bleb85425223ble__b
blebby1233743blebby
blebs96416153ble_bs
bled75729313ble__d
bleed85019803ble_ed
bleeds95211593bleeds
bleep95013453ble_ep
bleeps10499103bleeps
blemish1436603blemish
blenchers16356723blenchers
blenching17276503blenching
blended114710713blended
blender104613843blender
blendes104713683blendes
bless75917813ble_ss
blest76431723ble_st
blet66247673ble__t
blets75324943ble_ts
blew94722433ble__w
blin67228173blin__
blind86319323blin_d
blinds95111613blinds
blini75519273blin_i
blinis85313683blinis
blink115720143blin_k
blinks124613573blinks
blintz1788843blintz
bloc85023273bl_oc_
block134917843bl_ock
blocs95219653bl_ocs
blond85618373blon_d
blonde94813293blonde
blonds95213343blonds
blotchy17293973blotchy
blueish1236483blueish
bluish1159243bluish
blunge94311483blunge
blunt75525023blun_t
blunts84512893blunts
blush105115313bl_ush
borsch1336133borsch
botch126717453b_otch
bounce104014833bounce
bouncy13409073bouncy
brach126123303b_rach
branchy17357913branchy
breath113916263breath
bren65629563bren__
brens75823363bren_s
brent75734133bren_t
brents84717273brents
broach133611113broach
bronc91714343bronc_
bronchi14176313bronchi
broncho14206463broncho
bronco10179493bronco
broncs101611153broncs
brooch13368443brooch
bunchy16437463b_unchy
bunco94616083b_unco
butch125416543b_utch
chinch163911233chinch
cinch124516243_cinch
clach124617823cl_ach
clenched16257763clenched
clencher15277973clencher
clenches152910953clenches
clutch13367753clutch
conch124620073_conch
cranch133613533cranch
crunch13349503crunch
dreich12377723dreich
dunch115316263_dunch
each95530583__each
elect74327033ele_ct
elenchic1544233elenchic
elenchus1343643elenchus
etch95419143__etch
fence105319913_fence
fetch134913473_fetch
finch135416973_finch
fleche14299303fle_che
fleck148213593fle_ck
fleece11369903fleece
fleecy14266483fleecy
flenched17267963flenched
flenches163410533flenches
flense938903flense
flesh115013743fle_sh
flitch14928173flitch
fluency1545353fluency
flysch1732893flysch
glance94312313glance
glen56027203glen__
glens66519853glen_s
glitch12286353glitch
grinch1238483grinch
haunch14377343haunch
hence104920043_hence
heuch135312333_heuch
hunch136416213_hunch
ileac75814173ileac_
inch95420823__inch
ketch144912023_ketch
klatch15445933klatch
kvetch1832993kvetch
laich105920713_laich
lance75126723_lance
larch105919793_larch
latch104620463_latch
launch11368063launch
leachy14419733_leachy
leash85519213_leash
lend56233673_len_d
lends65326253_lends
lenes54738523_lenes
length1046103_length
lenis56326863_lenis
leno47331393_len_o
lenos56024863_lenos
lens46146493_len_s
lense54523433_lense
lent46360533_len_t
lento57223393_lento
lich96230843_l_ich
loach105116363_loach
loch95527133_l_och
lurch104814633_lurch
lych126015763_l_ych
mensch13387103_mensch
mensh105413563_mensh
merch125417963_merch
munch124917103_munch
oleic7313333oleic_
painch133511323painch
paunch13369853paunch
peach125422493_peach
pech116125453_pe_ch
pence94924453_pence
perch124518833_perch
pinch125619303_pinch
planche14299753planche
plena75816393plen_a
plenches153110623plenches
plenish1239943plenish
plenty11311413plenty
plenum1039503plenum
plinth11310453plinth
preach133613923preach
punch125118423_punch
ranch105019793_ranch
raunch11358433raunch
reach105123883_reach
retch104818303_retch
sheuch14267043sheuch
silence9310213silence
sketch1535363sketch
slatch114510533slatch
sleigh10258203sleigh
sleuth937233sleuth
slouch11438523slouch
speech1347563speech
spence103813793spence
stanch113812373stanch
stenchy15256213stenchy
synch135011793_synch
teach105221123_teach
tech95925443_te_ch
tenth85421833_tenth
teuch105214853_teuch
thence112010843thence
unclench1544143unclench
valence1268773valence
valency1565463valency
vetch134411843_vetch
welch134411493_welch
whence14187923whence
winch135016663_winch
wretch14326533wretch
yecch15558093_yecch
yech127220533_ye_ch

Search took 7 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.390458182.1
2DLD Change Limit1127162825.57620214.5
3Display Results2822820.0962937.5
 (SQL Overall)1786912826.06229477.2
 
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.