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

454 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
breach13421372(None) 
beach124623891b_each
bleach133611401bleach
brach126123301br_ach
breath113916261breath
breech13348261breech
broach133611111broach
preach133613921preach
reach105123881_reach
abreact11310822abreact
abroach1446212abroach
bach116131392b__ach
beachy164011252b_eachy
beech124315502b_eech
belch124415502b_elch
bench125619502b_ench
blench133710452blench
brace95629272br_ace
brachs134415752br_achs
bract96332722br_act
branch134014782branch
brash106221562br_ash
breached163411642breached
breacher153011502breacher
breaches153714122breaches
bread85523112brea_d
breads95419202breads
breadth1365992breadth
bready124511182bready
break115319402brea_k
breaks124816422breaks
bream95121812brea_m
breams104815042breams
breast8319632breast
breathe123711842breathe
breaths124411192breaths
breathy15328032breathy
brooch13368442brooch
brunch13329352brunch
dreich12377722dreich
drench12369592drench
each95530582__each
french143511212french
leach105422522_leach
orach105219232or_ach
peach125422492_peach
pleach134211242pleach
preachy17307312preachy
preact103220392preact
react74634332_react
retch104818302_retch
roach105717002_roach
teach105221122_teach
trench114211612trench
upreach1444692upreach
wreath124111192wreath
wrench14439352wrench
wretch14326532wretch
abreacts1245643abreacts
abreast9311283abreast
arch98628443ar__ch
area45843393area__
areae55229743area_e
areal55928733area_l
areas55935773area_s
areca75618633are_ca
arecas84817443arecas
areic73219393areic_
arrack121110253arrack
attach11118393attach
back125535763b__ack
bah87755353b__a_h
bareback1846093bareback
barrack1538253barrack
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
bedrench1644153bedrench
beechy16397503b_eechy
beneath1236973beneath
berake124216083berake
berate84729023berate
berdache1644033berdache
bereave1258353bereave
berth104917883b_erth
beseech1453873beseech
beth96629233b_e_th
biface1358103biface
bimah127013273bima_h
bipack1636523bipack
birch124914023b_irch
bitch125017763b_itch
black134719073b_lack
blah98625063b_la_h
blanch133410853blanch
bleached16378563bleached
bleacher15358883bleacher
bleaches153410673bleaches
bleak115915383blea_k
bleaks125112433bleaks
blear75918683blea_r
blears85116453blears
bleary115112553bleary
bleat75737003blea_t
bleats85518613bleats
blotch13197143blotch
bonaci10310963bonaci
boreal84817213borea_l
boreas85421733borea_s
borsch1336133borsch
botch126717453b_otch
bra56339463br_a__
braced115420603br_aced
bracer104620583br_acer
braces108427773br_aces
braches144621223br_aches
brachet144020313br_achet
brachia141910423br_achia
bracts105617773br_acts
brad75234343br_a_d
brads85528293br_ads
brae65639113br_a_e
braes75735053br_aes
brag75229723br_a_g
brags85625103br_ags
braid85822263br_aid
brail75525553br_ail
brain76229383br_ain
brake116025343br_ake
braky145015813br_aky
bran65740383br_a_n
branchy17357913branchy
brand85124493br_and
brank115222283br_ank
brans75437433br_ans
brant74742173br_ant
bras65746453br_a_s
brashy145210593br_ashy
brass75428023br_ass
brat66055543br_a_t
brats75336013br_ats
brava106414793br_ava
brave104925503br_ave
bravi104715753br_avi
bravo105214343br_avo
braw94829563br_a_w
brawl106217963br_awl
brawn106018563br_awn
braws106425193br_aws
braxy175410893br_axy
bray95232903br_a_y
brays106723113br_ays
braza165214253br_aza
braze165423453br_aze
breachers16369853breachers
breaching17269403breaching
breaded115014063breaded
breadths1474463breadths
breaker133912923breaker
breakup1543463breakup
breamed124011593breamed
breasts939703breasts
breathed14469643breathed
breather133610593breather
breathes134212903breathes
breccia1344453breccia
brecham1646833bre_cham
brechan1437223bre_chan
bred75130973bre__d
brede85520503bre_de
bredes94818473bredes
bree67241263bre__e
breeched16337383breeched
breeches15258673breeches
breed85526693bre_ed
breeds94914883breeds
breeks125310793breeks
brees75632553bre_es
breeze17298963breeze
breezy20295853breezy
bregma1134963bregma
bren65629563bre__n
brens75823363bre_ns
brent75734133bre_nt
brents84717273brents
breve105317053bre_ve
breves115516423breves
brevet115717333brevet
brew95023563bre__w
brewage1347183brewage
brewed125411873brewed
brewer114812553brewer
brewis11469983brewis
brews105617073bre_ws
briar75718153bria_r
briard94311293briard
briars84814823briars
briary114912003briary
brick134618153br_ick
brioche14275923brioche
brith104924373br_ith
broached16309123broached
broacher15329263broacher
broaches153211623broaches
broad84817693broa_d
broads94515153broads
broche133612103br_oche
brock136017073br_ock
bronc91714343bronc_
bronchi14176313bronchi
broncho14206463broncho
bronco10179493bronco
broncs101611153broncs
broth106521093br_oth
brugh115414293br_ugh
brush105917473br_ush
bunch125118603b_unch
bureau8712523burea_u
bureaus979293bureaus
bureaux1664593bureaux
butch125416543b_utch
bycatch1942063bycatch
bypath1645353bypath
caroach1488863caroach
clach124617823_clach
clench133910053clench
coach125919453_coach
crack134120533cr_ack
cranch133613533cranch
crash109120013cr_ash
cratch134110793cratch
creak115418433crea_k
creaks124315963creaks
creaky154911553creaky
cream95721353crea_m
creams104715253creams
creamy134811363creamy
crease85519573crease
creasy114612303creasy
create85126383create
creche13310763cre_che
creesh11328333creesh
crotch133410083crotch
crouch133910203crouch
crunch13349503crunch
crutch13408243crutch
currach1446453currach
deash95617243_deash
death94822523_death
detach12310413detach
drachm1436493dr_achm
dread74419023drea_d
dreads84115023dreads
dream85120393drea_m
dreams94513983dreams
dreamt94615713dreamt
dreamy12509993dreamy
drear65016903drea_r
drears74614253drears
dreary104611673dreary
dreck124812803dre_ck
dreigh11246443dreigh
eath75735663__eath
erect74129333ere_ct
etch95419143__etch
fetch134913473_fetch
fleech14367343fleech
flench144010813flench
fletch14388193fletch
freak125115243frea_k
freaks134713063freaks
freaky16439233freaky
fresco1136473fresco
fresh115012203fre_sh
gerah9315303gera_h
grace85124543gr_ace
graph115315613gr_aph
grease75416233grease
greasy10419463greasy
great66034243grea_t
greats76318393greats
greave104611493greave
grinch1238483grinch
grouch12318473grouch
grutch12285563grutch
heath115724283_heath
heuch135312333_heuch
ileac75814173ileac_
impeach1644273impeach
kench145513923_kench
ketch144912023_ketch
kreplach1942613kreplach
kvetch1832993kvetch
leachy14419733_leachy
leash85519213_leash
lech96825443_le_ch
leech104913213_leech
letch105215803_letch
loach105116363_loach
mach116134483__mach
merch125417963_merch
neath86020283_neath
obeah1038993obea_h
orache114013593or_ache
oread64619603orea_d
oreads73915773oreads
outreach1346003outreach
peace95026083_peace
peachy164510843_peachy
pech116125453_pe_ch
perch124518833_perch
plench134010813plench
poach124917863_poach
preached163412063preached
preacher153211373preacher
preaches153214893preaches
preacts113211363preacts
preamp1238993preamp
prearm104512353prearm
preface14510923preface
prelacy1437583prelacy
prepack1757643prepack
prerace11414123prerace
prewash1535213prewash
quench2036633quench
race66746263_r_ace
rack106234883_r_ack
racy95825683_r_acy
rah68052403_r_a_h
ranch105019793_ranch
rash76039933_r_ash
ratch104221363_ratch
rath76037663_r_ath
reached134619083_reached
reacher123718293_reacher
reaches123423203_reaches
reacts83616603_reacts
read55942533_rea_d
readd74617133_readd
reads64835273_reads
ready94821503_ready
real45750293_rea_l
realm75621623_realm
reals55038653_reals
ream65841613_rea_m
reams75729623_reams
reap65934743_rea_p
reaps75626193_reaps
rear45644553_rea_r
rearm75923573_rearm
rears54739653_rears
reata54225393_reata
reave84528023_reave
rec55645463_re_c_
recap95718023_recap
recce9514563_recce
reck106130563_re_ck
recs65734183_re_cs
redact9419043_redact
reecho11318653_reecho
reechy14367823_reechy
reface113616353_reface
rehash1237433_rehash
relace83122153_relace
rematch1436193_rematch
repack142412163_repack
repatch1435843_repatch
rerack122513163_rerack
resh76523453_re_sh
retack122612823_retack
reteach1237413reteach
rewash1237673_rewash
rich97025543_r_ich
rotch105815933_rotch
screech1435223screech
search113312423_search
serac75925203serac_
seracs84418573seracs
seraph114011163seraph
sheath12412893sheath
sheuch14267043sheuch
sketch1535363sketch
speech1347563speech
stench114111163stench
stretch1236413stretch
sumach135310113sumach
tach96132753__tach
tech95925443_te_ch
tench105620003_tench
teraph11319093teraph
teuch105214853_teuch
trace75829613tr_ace
track114823013tr_ack
tract75635713tr_act
trash86119763tr_ash
treacle939973treacle
treacly1237093treacly
tread64821703trea_d
treads74817923treads
treat56240353trea_t
treats64821693treats
treaty94414353treaty
trefah1235093trefah
triac74116373triac_
triacs83913223triacs
unbreech1542233unbreech
unteach1246143unteach
urea46528063urea__
ureal56722683urea_l
ureas55826013urea_s
urease64516993urease
ureic74514463ureic_
vetch134411843_vetch
welch134411493_welch
wench136214783_wench
wrack145413883wr_ack
wrath115715873wr_ath
wreak125513273wrea_k
wreaks134711113wreaks
wreathe13339053wreathe
wreaths13338373wreaths
wreathy16326063wreathy
wreck144611043wre_ck
xerarch1943843xerarch
yeah106725413_yea_h
yecch15558093_yecch
yech127220533_ye_ch

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 Filter1786911127160.453394461.4
2DLD Change Limit1127164548.58013137.1
3Display Results4544540.1562910.3
 (SQL Overall)1786914549.18919446.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.