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

385 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
broach13361111(None) 
abroach1446211abroach
brach126123301br_ach
breach134213721breach
brooch13368441brooch
roach105717001_roach
bach116131392b__ach
beach124623892b_each
bleach133611402bleach
blotch13197142blotch
borsch1336132borsch
botch126717452b_otch
brace95629272br_ace
brachs134415752br_achs
bract96332722br_act
branch134014772branch
brash106221562br_ash
breath113916262breath
breech13348262breech
broached16309122broached
broacher15329262broacher
broaches153211622broaches
broad84817692broa_d
broads94515142broads
broche133612102bro_che
brock136017072bro_ck
bronc91714342bronc_
bronchi14176312bronchi
broncho14206462broncho
bronco10179492bronco
broncs101611152broncs
broth106521092bro_th
brunch13329352brunch
caroach1488862caroach
coach125919452_coach
crotch133410082crotch
crouch133910202crouch
grouch12318472grouch
loach105116362_loach
orach105219232or_ach
poach124917862_poach
preach133613922preach
reach105123882_reach
rotch105815932_rotch
abreact11310823abreact
abroad9310943abroa_d
aircoach1542863aircoach
approach1743763approach
arch98628443ar__ch
arrack121110253arrack
attach11118393attach
avouch1434833avouch
back125535763b__ack
bah87755353b__a_h
barouche1544173barouche
barrack1538253barrack
bash915240163b__ash
batch124620103b_atch
bath95940083b__ath
beachy164011253b_eachy
beech124315503b_eech
belch124415503b_elch
bench125619503b_ench
berdache1644033berdache
biface1358103biface
bimah127013263bima_h
biotech14104493biotech
bipack1636523bipack
birch124914023b_irch
birrotch1542393birrotch
bitch125017763b_itch
black134719073b_lack
blah98625063b_la_h
blanch133410853blanch
blench133710453blench
bloat75229923bloa_t
bloats85215763bloats
bloc85023273blo_c_
block134917843blo_ck
blocs95219653blo_cs
blotchy17293973blotchy
boa56954033b_oa__
boar66134293b_oa_r
board85523003b_oard
boars75229603b_oars
boart78835933b_oart
boas66150833b_oa_s
boast75935703b_oast
boat66360313b_oa_t
boats75635153b_oats
bocce114313113b_occe
bocci113512713b_occi
boche124216953b_o_che
bock126032513b_o_ck
bonaci10310963bonaci
booth105522013b_ooth
bora66141633bora__
boraces113716853boraces
boracic1338723boracic
borage93917013borage
boral75831703bora_l
borals86721913borals
borane84620213borane
boras75938303bora_s
borate85026153borate
borax145918723bora_x
boric98024223boric_
borough1344513borough
borscht1445993borscht
bosh96328973b_o_sh
botchy16537823b_otchy
both96533433b_o_th
bough115719313b_ough
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
breached163411643breached
breacher153011503breacher
breaches153714113breaches
bread85523113brea_d
breads95419203breads
breadth1365993breadth
bready124511183bready
break115319403brea_k
breaks124816423breaks
bream95121813brea_m
breams104815043breams
breast8319633breast
breathe123711843breathe
breaths124411183breaths
breathy15328033breathy
briar75718153bria_r
briard94311293briard
briars84814823briars
briary114912003briary
brick134618153br_ick
brioche14275923brioche
brith104924373br_ith
bro56236603bro___
broachers16328133broachers
broaching17287663broaching
broadax1744453broadax
broaden10289143broaden
broader103412603broader
broadish1446933broadish
broadly1337153broadly
brocade1238533brocade
brocks145214153brocks
brogan9311043brogan
brogans1049663brogans
brogue94211033brogue
broil74918223bro_il
broils84114173broils
brokage1436673brokage
broke116019783bro_ke
broken124011523broken
broker124314243broker
brolly114510853brolly
bromal10313653bromal
bromals1139743bromals
bromate11313553bromate
brome94421973bro_me
bromes104719763bromes
bromic122412693bromic
bromid112612893bromid
bromin102615693bromin
bromo95217203bro_mo
bromos104213313bromos
bronchia15195993bronchia
bronchos15206173bronchos
bronchus15204743bronchus
broncos11188073broncos
bronze173610923bronze
bronzy20306713bronzy
broo65129823bro__o
brooches15288193brooches
brood84620243bro_od
broods95416383broods
broody124510083broody
brook114717763bro_ok
brooks125813883brooks
broom95022213bro_om
brooms104915873brooms
broomy13449953broomy
broos75126413bro_os
bros65635663bro__s
brose75227033bro_se
broses86524403broses
brosy106115383bro_sy
broths115013923broths
brothy14519623brothy
brought13308683brought
brow97228443bro__w
browed125216393browed
brown105619533bro_wn
browns116415633browns
browny144510043browny
brows105425983bro_ws
browse115713853browse
brugh115414293br_ugh
brush105917473br_ush
bunch125118603b_unch
butch125416543b_utch
bycatch1942063bycatch
bypath1645353bypath
byroad1236623byroa_d
byroads1335293byroads
caroch13911763caro_ch
clach124617823_clach
cloaca1037263cloaca
coact96130573_coact
conch124620073_conch
cooch124916833_cooch
coronach1545763coronach
couch125320113_couch
crack134120533cr_ack
cranch133613533cranch
crash109120013cr_ash
cratch134110793cratch
croak115216633croa_k
croaks125812983croaks
croaky15528483croaky
croc85723733cro_c_
croci95818133cro_ci
crock135921993cro_ck
crocs95722433cro_cs
crunch13349503crunch
crutch13408243crutch
currach1446453currach
detach12310413detach
drachm1436493dr_achm
dreich12377723dreich
drench12369593drench
drouth104410103drouth
each95530583__each
encroach1542963encroach
epoch1248203epo_ch
french143511213french
frock145314653fro_ck
frosh115713403fro_sh
froth115919283fro_th
grace85124543gr_ace
graph115315613gr_aph
grinch1238473grinch
groan65618423groa_n
groans74815063groans
groat65531973groa_t
groats74816653groats
grouchy16294243grouchy
growth1377383growth
grutch12285563grutch
hooch135813703_hooch
hootch14386403hootch
horah117922043hora_h
hotch136214723_hotch
isopach1444243isopach
isotach1244953isotach
leach105422523_leach
loath84918603_loath
loch95527133_lo_ch
mach116134473__mach
mooch125313613_mooch
mouch124715803_mouch
notch105613323_notch
oath76132153__oath
orache114013593or_ache
ouch95724633__ouch
peach125422493_peach
pibroch1643803pibro_ch
pleach134211243pleach
poachy16388963_poachy
pooch124815303_pooch
porch125918623_porch
pouch124617083_pouch
preachy17307313preachy
preact103220393preact
proa66229963proa__
proas75028803proa_s
race66746263_r_ace
rack106234883_r_ack
racy95825683_r_acy
rah68052403_r_a_h
ranch105019793_ranch
rash76039933_r_ash
ratch104221363_ratch
rath76037663_r_ath
react74634333_react
reproach1544953reproach
retch104818303_retch
rich97025543_r_ich
roached133211833_roached
roaches123616213_roaches
road56332113_roa_d
roads66523613_roads
roam67132413_roa_m
roams74919613_roams
roan47234203_roa_n
roans54926443_roans
roar46328573_roa_r
roars55622233_roars
roast56230143_roast
roc520243253_ro_c_
rock105735183_ro_ck
rocs65533663_ro_cs
rotche114311983_rotche
rouche114714313_rouche
rough97819433_rough
routh86423073_routh
rowth115713233_rowth
scooch13228123scooch
scorch13198093scorch
scotch13207513scotch
scrooch1444953scrooch
slouch11438523slouch
smooch13266803smooch
stomach1436033stomach
sumach135310113sumach
tach96132753__tach
teach105221123_teach
torah87125273tora_h
torch107420933_torch
touch106519393_touch
trace75829613tr_ace
track114823013tr_ack
tract75635713tr_act
trash86119763tr_ash
trench114211613trench
triac74116373triac_
triacs83913223triacs
troak95213573troa_k
troaks104410593troaks
trocar848763trocar
troche113112513tro_che
trock114817603tro_ck
troth85622203tro_th
trough108512023trough
trowth1277883trowth
upreach1444693upreach
vouch134611903_vouch
wrack145413883wr_ack
wrath115715873wr_ath
wreath124111193wreath
wrench14439353wrench
wretch14326533wretch
wroth116815883wro_th

Search took 6 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.1561145455.1
2DLD Change Limit1127163855.25021469.7
3Display Results3853850.1432692.3
 (SQL Overall)1786913855.54932202.4
 
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.