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

463 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
branch13401477(None) 
blanch133410851blanch
brach126123301bra_ch
branchy17357911branchy
brunch13329351brunch
cranch133613531cranch
ranch105019791_ranch
bach116131392b_a_ch
banco94019392b_anco
batch124620102b_atch
beach124623892bea_ch
bench125619502b_ench
blench133710452blench
brace95629272bra_ce
brachs134415752bra_chs
bract96332722bra_ct
bran65740382bran__
branched163210452branched
branches153613802branches
branchia15217712branchia
brand85124492bran_d
brands95118942brands
brandy124712062brandy
brank115222282bran_k
branks124817382branks
branny115111832branny
brans75437432bran_s
brant74742172bran_t
brants85723052brants
brash106221562bra_sh
breach134213722breach
breech13348262breech
broach133611112broach
bronc91714342bronc_
bronchi14176312bronchi
broncho14206462broncho
bronco10179492bronco
broncs101611152broncs
brooch13368442brooch
bunch125118602b_unch
cratch134110792cratch
craunch1464442craunch
crunch13349502crunch
drench12369592drench
franc104615412franc_
francs114112192francs
french143511212french
grinch1238472grinch
orach105219232ora_ch
planch133711442planch
prance104318572prance
rance75028512_rance
rancho114310852_rancho
ratch104221362_ratch
raunch11358432_raunch
rebranch1545802rebranch
stanch113812372stanch
trance84718762trance
tranche123312222tranche
trench114211612trench
wrench14439352wrench
abroach1446213abroach
anabranch1652823anabranch
anarch11310393anarch
ancho104515303__ancho
ankh111114413__ankh
arch98628443__arch
bacca111012183b_acca
back125535763b_a_ck
bah87755353b_a__h
baith108023133b_aith
balance11510263balance
ban58366843b_an__
banal75925993b_anal
bancos104713893b_ancos
band76740913b_an_d
banda85223103b_anda
bands85233423b_ands
bandy114824183b_andy
bane65250433b_an_e
baned85436353b_aned
banes74945583b_anes
bang74837003b_an_g
bangs85627773b_angs
bani65334963b_an_i
banish111416043b_anish
banjo143812443b_anjo
bank105835753b_an_k
banks115527903b_anks
banns75321233b_anns
bans66555143b_an_s
banty106624003b_anty
barca91319433b_arca
baric96125693baric_
barn66444643barn__
barned95623583barned
barney115314453barney
barns76335143barn_s
barny105821733barn_y
barranca1245583barranca
barranco1244943barranco
bash915240163b_a_sh
bath95940083b_a_th
beachy164011253bea_chy
bean66443863bean__
beaned95621473beaned
beanie83618593beanie
beano75421553bean_o
beanos85516513beanos
beans75734693bean_s
bedrench1644153bedrench
beech124315503b_eech
belch124415503b_elch
bhang115512923bhan_g
bhangs12449663bhangs
birch124914023b_irch
bitch125017763b_itch
black134719073bla_ck
blah98625063bla__h
blanched16308603blanched
blancher15338633blancher
blanches153311603blanches
bland85320453blan_d
blank115418553blan_k
blanks124112893blanks
bleach133611403bleach
blotch13197143blotch
bonaci10310963bonaci
borane84620213boran_e
boranes93720403boranes
borsch1336133borsch
botch126717453b_otch
bounce104014833bounce
bouncy13409073bouncy
bra56339463bra___
braced115420603braced
bracer104620583bracer
braces108427773braces
braches144621223bra_ches
brachet144020313bra_chet
brachia141910423bra_chia
bracts105617773bracts
brad75234343bra__d
brads85528293bra_ds
brae65639113bra__e
braes75735053bra_es
brag75229723bra__g
braggy13337173braggy
brags85625103bra_gs
brahma1336193brahma
braid85822263bra_id
braids95015693braids
brail75525553bra_il
brails84621293brails
brain76229383bra_in
brained103816103brained
brainish1338813brainish
brains85125473brains
brainy114815643brainy
braise84318753braise
braize174113113braize
brake116025343bra_ke
braked135318693braked
brakes124923123brakes
braky145015813bra_ky
branchiae16186313branchiae
branchial16215953branchial
branchier1637133branchier
branching17289263branching
branchlet1647183branchlet
branded114414103branded
brander103915823brander
brandish1469023brandish
branned104311693branned
branner94212373branner
bras65746453bra__s
brashy145210593brashy
brasil8713863brasil
brass75428023bra_ss
brassy11509233brassy
brat66055543bra__t
brats75336013bra_ts
bratty1159683bratty
brava106414793bra_va
bravas114913323bravas
brave104925503bra_ve
braved124817443braved
braver114719043braver
braves115524083braves
bravi104715753bra_vi
bravo105214343bra_vo
bravos114711393bravos
braw94829563bra__w
brawer114216333brawer
brawl106217963bra_wl
brawls115214333brawls
brawly144312353brawly
brawn106018563bra_wn
brawns115614083brawns
brawny144710603brawny
braws106425193bra_ws
braxy175410893bra_xy
bray95232903bra__y
brayed124615783brayed
brayer115315313brayer
brays106723113bra_ys
braza165214253bra_za
brazas175812433brazas
braze165423453bra_ze
brazed184717083brazed
brazen174812453brazen
brazer174917533brazer
brazes175522193brazes
brazil1779623brazil
breadth1365993breadth
breath113916263breath
bren65629563bren__
brens75823363bren_s
brent75734133bren_t
brents84717273brents
brick134618153br_ick
brin67038193brin__
brine75132273brin_e
brined95118413brined
briner84519043briner
brines85028853brines
bring85528503brin_g
brings94618433brings
brinish1239963brinish
brink116122003brin_k
brinks124616313brinks
brins75533973brin_s
briny104719663brin_y
brioche14275923brioche
brisance1245953brisance
brith104924373br_ith
broche133612103br_oche
brock136017073br_ock
bronchia15195993bronchia
bronchos15206173bronchos
bronchus15204743bronchus
broncos11188073broncos
bronze173610923bronze
bronzy20306713bronzy
broth106521093br_oth
brugh115414293br_ugh
brunched16317853brunched
bruncher15347783bruncher
brunches153710453brunches
brunet84419293brunet
brung84613913brun_g
brunt75728753brun_t
brunts85215453brunts
brush105917473br_ush
bunchy16437463b_unchy
bunco94616083b_unco
buran75225303buran__
burans85019303buran_s
butch125416543b_utch
bwana10310243bwan_a
bwanas1157443bwanas
bycatch1942063bycatch
cancha134411613_cancha
caroch13911763caroch
catch125120373_catch
chance134617093chance
chancy164010863chancy
chinch163911233chinch
cinch124516243_cinch
clach124617823cla_ch
clench133910053clench
clinch133910353clinch
coach125919453coa_ch
conch124620073_conch
crack134120533cra_ck
cranched163210413cranched
cranches153114543cranches
crane75331603cran_e
craned96121653craned
cranes84330753cranes
crania82418433crania
crank114819613cran_k
cranks125015313cranks
cranky153910633cranky
cranny114210273cranny
crash109120013cra_sh
crotch133410083crotch
crouch133910203crouch
crunchy17324763crunchy
crutch13408243crutch
dance85223133_dance
disbranch1744383disbranch
drachm1436493dra_chm
drank104816203dran_k
dreich12377723dreich
dunch115316263_dunch
durance1059113durance
each95530583_ea_ch
eparch13258423eparch
errancy1256363errancy
exarch18196173exarch
fancy134615483_fancy
fiance11310743fiance
finch135416973_finch
flench144010813flench
flinch144010103flinch
frank124417513fran_k
franks134912733franks
glance94312313glance
glunch1255353glunch
grace85124543gra_ce
gran56335013gran__
grana65722093gran_a
grand75122693gran_d
grands84218243grands
grange83716203grange
granny104311163granny
grans64832543gran_s
grant64840023gran_t
grants73722473grants
granum9310913granum
graph115315613gra_ph
grouch12318473grouch
grutch12285563grutch
hance105424153_hance
hatch135719593_hatch
haunch14377343haunch
hunch136416213_hunch
inarch1139173inarch
inch95420823__inch
kench145513923_kench
klatch15445933klatch
laich105920713_laich
lance75126723_lance
larch105919793_larch
latch104620463_latch
launch11368063launch
leach105422523lea_ch
loach105116363loa_ch
lunch104917243_lunch
lynch13468983_lynch
mach116134483_ma_ch
manche133515103_manche
march125622893_march
match125621103_match
munch124917103_munch
nance74721843_nance
nancy105214923_nancy
natch105018223_natch
nuance859043nuance
orache114013593ora_che
orang65119943oran_g
orange74016323orange
orangs74116033orangs
orangy105111233orangy
painch133511323painch
parch125123003_parch
patch125221223_patch
paunch13369853paunch
peach125422493pea_ch
pinch125619303_pinch
planche14299753planche
plench134010813plench
poach124917863poa_ch
pranced123714043pranced
prancer113613383prancer
prances113618773prances
prang84820323pran_g
prangs94816233prangs
prank115019453pran_k
pranks124814723pranks
preach133613923preach
prince104114763prince
punch125118423_punch
quaich2047693quaich
quench2036633quench
race66746263_ra_ce
rack106234883_ra_ck
racy95825683_ra_cy
rah68052403_ra__h
rajah155711423_rajah
ralph1078743_ralph
ran38266623_ran__
rances84625443_rances
ranched133113603_ranched
rancher123013633_rancher
ranches123620113_ranches
ranchos123911393_ranchos
rancid9513863_rancid
rancor8810373_rancor
rand55839573_ran_d
rands65930453_rands
randy95022083_randy
ranee55438103_ranee
rang56939163_ran_g
range64728413_range
rangy95320383_rangy
rani46640113_ran_i
ranid66429333_ranid
ranis55235833_ranis
rank85135533_ran_k
ranks95225733_ranks
rant45864683_ran_t
rants55935343_rants
rash76039933_ra_sh
rath76037663_ra_th
raunchy15284313_raunchy
rayah116013503_rayah
reach105123883_reach
retch104818303_retch
rich97025543_r_ich
roach105717003_roach
rotch105815933_rotch
sangh95517453_sangh
sauch104918773_sauch
scraich1436763scraich
scratch1446013scratch
scrunch1444033scrunch
seance83716683seance
search113312423search
slatch114510533slatch
snatch114310603snatch
stance84316913stance
starch113013203starch
staunch1244273staunch
stench114111163stench
subbranch1853513subbranch
swatch14549283swatch
synch135011793_synch
tach96132753_ta_ch
teach105221123tea_ch
tench105620003_tench
thatch1435613thatch
trace75829613tra_ce
track114823013tra_ck
tract75635713tra_ct
tranced104414173tranced
trances93919643trances
tranches132915513tranches
trank96222423tran_k
tranks104017763tranks
tranny94210863tranny
tranq145416893tran_q
tranqs155210313tranqs
trans54933043tran_s
trash86119763tra_sh
truancy1244993truancy
urania62516123urania
uranic82315183uranic
uranyl936293uranyl
usance858013usance
vibrance1545843vibrance
vibrancy1843873vibrancy
watch135617063_watch
wench136214783_wench
winch135016663_winch
wrack145413883wra_ck
wraith1258603wraith
wrang94716113wran_g
wrangs104611913wrangs
wrath115715873wra_th
wretch14326533wretch
xerarch1943843xerarch

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.1401276364.3
2DLD Change Limit1127164635.51620434.4
3Display Results4634630.1403307.1
 (SQL Overall)1786914635.79630830.1
 
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.