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

374 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
bleach13361140(None) 
beach124623891b_each
blench133710451blench
breach134213721breach
leach105422521_leach
pleach134211241pleach
bach116131392b__ach
beachy164011252b_eachy
beech124315502b_eech
belch124415502b_elch
bench125619502b_ench
black134719072bl_ack
blah98625062bl_a_h
blanch133410852blanch
bleached16378562bleached
bleacher15358882bleacher
bleaches153410672bleaches
bleak115915382blea_k
bleaks125112432bleaks
blear75918682blea_r
blears85116452blears
bleary115112552bleary
bleat75737002blea_t
bleats85518612bleats
blotch13197142blotch
brach126123302b_rach
breath113916262breath
breech13348262breech
broach133611112broach
clach124617822cl_ach
clench133910052clench
each95530582__each
fleech14367342fleech
flench144010812flench
fletch14388192fletch
ileac75814172ileac_
leachy14419732_leachy
leash85519212_leash
lech96825442_le_ch
leech104913212_leech
letch105215802_letch
loach105116362_loach
peach125422492_peach
plench134010812plench
preach133613922preach
reach105123882_reach
teach105221122_teach
abreact11310823abreact
abroach1446213abroach
alack114820063al_ack
alec66430063ale_c_
alecs76620733ale_cs
aleph10311393ale_ph
almah106917253alma_h
alpaca1047383alpaca
attach11118393attach
back125535763b__ack
bah87755353b__a_h
bash915240163b__ash
batch124620103b_atch
bath95940083b__ath
beached154516553b_eached
beaches144120653b_eaches
beacon10511373b_eacon
bead75937923b_ea_d
beads85429503b_eads
beady114719923b_eady
beak106534383b_ea_k
beaks115326623b_eaks
beaky146118023b_eaky
beam86939233b_ea_m
beams95328173b_eams
beamy126218573b_eamy
bean66443863b_ea_n
beano75421553b_eano
beans75734693b_eans
bear66844643b_ea_r
beard86024963b_eard
bears75739043b_ears
beast76338643b_east
beat66168303b_ea_t
beats76042243b_eats
beau66137273b_ea_u
beaus75127113b_eaus
beaut75135213b_eaut
beaux146513213b_eaux
becap114315053b_ecap
beck126226573b_e_ck
beechy16397503b_eechy
belaced124112153belaced
belady12489933belady
belaud939133belaud
belay105021523bela_y
belays114313853belays
beleap10410283belea_p
beleaps1138053beleaps
beleapt11310253beleapt
beneath1236973beneath
berth104917883b_erth
beseech1453873beseech
beth96629233b_e_th
biface1358103biface
bimah127013273bima_h
bipack1636523bipack
birch124914023b_irch
bitch125017763b_itch
blab86629133bl_a_b
blabs95619633bl_abs
blacks144914953bl_acks
blade85923333bl_ade
blae66134643bl_a_e
blaff135216483bl_aff
blahs105616513bl_ahs
blain75421793bl_ain
blam86131703bl_a_m
blame95625493bl_ame
blams95023853bl_ams
bland85320453bl_and
blank115418553bl_ank
blare75826233bl_are
blase75524233bl_ase
blast76532573bl_ast
blat66550953bl_a_t
blate75933783bl_ate
blats75132503bl_ats
blaw97026723bl_a_w
blawn106813703bl_awn
blaws105620463bl_aws
blaze165520833bl_aze
bleachers16297923bleachers
bleaching17287093bleaching
bleaker133510533bleaker
bleakish1745053bleakish
bleakly1634663bleakly
bleared104211253bleared
bleated104015973bleated
bleater94515303bleater
bleb85425223ble__b
blebby1233743blebby
blebs96416153ble_bs
bled75729313ble__d
bleed85019803ble_ed
bleeds95211593bleeds
bleep95013453ble_ep
bleeps10499103bleeps
blemish1436603blemish
blenched16358053blenched
blencher15308393blencher
blenches153310763blenches
blend85317453ble_nd
blende95413443blende
blends96012883blends
blenny1156203blenny
blent76230953ble_nt
bless75917813ble_ss
blest76431723ble_st
blet66247673ble__t
blets75324943ble_ts
blew94722433ble__w
bloat75229923bloa_t
bloats85215763bloats
bloc85023273bl_oc_
block134917843bl_ock
blocs95219653bl_ocs
blotchy17293973blotchy
bluecap1343113bluecap
blueish1236483blueish
bluejack2342603bluejack
bluish1159243bluish
blush105115313bl_ush
bonaci10310963bonaci
borsch1336133borsch
botch126717453b_otch
brace95629273b_race
brachs134415753b_rachs
bract96332723b_ract
branch134014773branch
brash106221563b_rash
breached163411643breached
breacher153011503breacher
breaches153714123breaches
bread85523113brea_d
breads95419203breads
breadth1365993breadth
bready124511183bready
break115319403brea_k
breaks124816423breaks
bream95121813brea_m
breams104815043breams
breast8319633breast
breathe123711843breathe
breaths124411183breaths
breathy15328033breathy
brooch13368443brooch
brunch13329353brunch
bullace113410673bullace
bunch125118603b_unch
butch125416543b_utch
bycatch1942063bycatch
bypath1645353bypath
clachs133511323cl_achs
clack134720173cl_ack
clash106219033cl_ash
clean75420413clea_n
cleans85817053cleans
clear76219053clea_r
clears84116563clears
cleat76335063clea_t
cleats84919313cleats
cleave114212513cleave
clinch133910353clinch
cloaca1037263cloaca
clutch13367753clutch
coach125919453_coach
deash95617243_deash
death94822523_death
detach12310413detach
dreich12377723dreich
drench12369593drench
eath75735663__eath
elect74327033ele_ct
elenchi1244723elenchi
etch95419143__etch
fetch134913473_fetch
flack144519413fl_ack
flash115716213fl_ash
flea75628493flea__
fleam106017283flea_m
fleams115011943fleams
fleas86423663flea_s
fleche14299303fle_che
fleck148213593fle_ck
fleece11369903fleece
fleecy14266483fleecy
flesh115013743fle_sh
flinch144010103flinch
flitch14928173flitch
flysch1732893flysch
french143511213french
glace87420163gl_ace
gleam86916733glea_m
gleams94812253gleams
gleamy12398113gleamy
glean65818203glea_n
gleans75014743gleans
glitch12286353glitch
glunch1255353glunch
heath115724283_heath
heuch135312333_heuch
ilea45931463ilea__
ileal56118083ilea_l
iliac75013493iliac_
impeach1644273impeach
kench145513923_kench
ketch144912023_ketch
klatch15445933klatch
kvetch1832993kvetch
lac510155823_l_ac_
lace66848473_l_ace
lack105837683_l_ack
lacs66942483_l_acs
lacy95829633_l_acy
laich105920713_laich
lakh114919953_l_akh
larch105919793_larch
lash76539653_l_ash
latch104620463_latch
lath76640383_l_ath
lea37660183_lea__
leached133715043_leached
leacher124014843_leacher
leaches123319343_leaches
lead56038853_lea_d
leads66028493_leads
leady95618603_leady
leaf76441033_lea_f
leafs85721183_leafs
leafy116316213_leafy
leak86233713_lea_k
leaks95923913_leaks
leaky125217723_leaky
leal46043273_lea_l
lean46345243_lea_n
leans55536253_leans
leant56737783_leant
leap66032683_lea_p
leaps75522933_leaps
leapt75027473_leapt
lear47045953_lea_r
learn55322663_learn
lears55938733_lears
leary85927383_leary
leas45954183_lea_s
lease55230263_lease
least56134883_least
leave84723723_leave
leavy115715773_leavy
legacy1256653_legacy
lich96230843_l_ich
loath84918603_loath
loch95527133_l_och
lunch104917243_lunch
lurch104814633_lurch
lych126015763_l_ych
lynch13468983_lynch
mach116134483__mach
merch125417963_merch
neath86020283_neath
obeah1038993obea_h
olea46532723olea__
oleate6318883oleate
oleic7313333oleic_
orach105219233_orach
peace95026083_peace
peachy164510843_peachy
pech116125453_pe_ch
perch124518833_perch
place94824613pl_ace
plack135017843pl_ack
planch133711443planch
plash104616563pl_ash
plea66830603plea__
pleached16338063pleached
pleaches153210433pleaches
plead85818463plea_d
pleads94613953pleads
pleas75627033plea_s
please84315733please
pleat74734473plea_t
pleats85218593pleats
poach124917863_poach
preachy17307313preachy
preact103220393preact
quench2036633quench
react74634333_react
relace83122153relace
retch104818303_retch
reteach1237413reteach
roach105717003_roach
search113312423_search
selah8319613sela_h
sheath12412893sheath
sheuch14267043sheuch
sketch1535363sketch
slack115021763sl_ack
slash84719683sl_ash
slatch114510533slatch
sleave94714153sleave
sleaze152611863sleaze
sleazo15257523sleazo
sleazy18267393sleazy
sleigh10258203sleigh
sleuth937233sleuth
slouch11438523slouch
speech1347563speech
stench114111163stench
sumach135310113sumach
tach96132753__tach
tech95925443_te_ch
tench105620003_tench
teuch105214853_teuch
trench114211613trench
unleash1034963unleash
unteach1246143unteach
upreach1444693upreach
vetch134411843_vetch
welch134411493_welch
wench136214783_wench
wreath124111193wreath
wrench14439353wrench
wretch14326533wretch
yeah106725413_yea_h
yecch15558093_yecch
yech127220533_ye_ch

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 Filter1786911127160.376475242.0
2DLD Change Limit1127163747.98314119.5
3Display Results3743740.1262968.3
 (SQL Overall)1786913748.48521059.6
 
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.