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

378 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
branches15361380(None) 
blanches153311601blanches
braches144621221bra_ches
branched163210451branched
brunches153710451brunches
cranches153114541cranches
ranches123620111_ranches
tranches132915511tranches
baches135426942b_a_ches
batches144019612b_atches
beaches144120652bea_ches
benches143918602b_enches
blanched16308602blanched
blancher15338632blancher
blanchers16307432blanchers
blenches153310762blenches
braces108427772bra_c_es
brachet144020312bra_chet
brachets154311982bra_chets
brachs134415752bra_ch_s
branch134014772branch__
branchia15217712branchia
branchier1637132branchier
branchiest1746712branchiest
branchless1743302branchless
branchlet1647182branchlet
branchlets1743802branchlets
branchy17357912branch_y
brandies11714562brandies
brashes124518462bra_shes
breaches153714122breaches
breeches15258672breeches
brioches15227252brioches
britches15278682britches
broaches153211622broaches
bronchos15206172bronchos
bronchus15204742bronchus
brooches15288192brooches
brunched16317852brunched
bruncher15347782bruncher
brunchers16296252brunchers
bunches144116032b_unches
cranched163210412cranched
cratches153012542cratches
craunches1655722craunches
crunches153711352crunches
drenches14309802drenches
frenches163311632frenches
grinches1436942grinches
manches143818622_manches
oraches124216472ora_ches
planches153111862planches
prances113618772pranc_es
rances84625442_ranc_es
ranched133113602_ranched
rancher123013632_rancher
ranchers133311792_ranchers
ranchos123911392_ranchos
ratches123620462_ratches
raunches1368052_raunches
rebranches1745192rebranches
stanches132312792stanches
trances93919642tranc_es
tranche123312222tranche_
trenches133512602trenches
wrenches163210232wrenches
aches106132293__a_ches
anabranches1852163anabranches
anchos114214893__anchos
apaches143411833apa_ches
arches114822043__arches
babiches1735253babiches
bached145519893b_a_ched
balances1279973balanc_es
bancos104713893b_anc_os
bandies104124863b_andies
banes74945583b_an__es
bangles103617413b_angles
banishes131812463b_anishes
banjoes16317313b_anjoes
banshee121212453b_anshee
banshees13127863b_anshees
banshies131110663b_anshies
banties94324763b_anties
barnacles1355333barnacles
barouches1644973barouches
bashes115631393b_a_shes
batched154114243b_atched
batcher144414853b_atcher
batchers153613273b_atchers
bathes116524833b_a_thes
beached154516553bea_ched
beanies93821093bean_ies
bedrenches1843453bedrenches
beeches143413883b_eeches
belches143514343b_elches
benched154713943b_enched
bencher144113483b_encher
benchers153611013b_enchers
berdaches1745053berdaches
birches143412323b_irches
bitches144117063b_itches
blanch133410853blanch__
bleaches153410673bleaches
blenched16358053blenched
blencher15308393blencher
blenchers16356723blenchers
blotches1537433blotches
bobeches1744483bobeches
boches134618523b__oches
boraces113716853bora_c_es
boranes93720403boran__es
borsches1536003borsches
botches143716023b_otches
bounces113813683bounc_es
brabbles11349753brabbles
brace95629273bra_c_e_
braced115420603bra_c_ed
bracer104620583bra_c_er
bracers114616703bra_cers
brach126123303bra_ch__
brachia141910423bra_chia
bracken15409813bra_cken
brackens16327923bra_ckens
bracket154117233bra_cket
brackets163310433bra_ckets
bracted12410933bra_cted
bracts105617773bra_c_ts
braes75735053bra___es
brailles1039493brailles
braincase1343683braincase
braincases1444003braincases
braises93818873bra_ises
braizes183112453bra_izes
brakes124923123bra__kes
brambles14308973brambles
branchiae16186313branchiae
branchial16215953branchial
branching17289263branching
branchlines1843613branchlines
branded114414103bran_ded
brander103915823bran_der
branders114313093branders
brandied1259113brandied
brandishes1645893brandishes
brandless1236123brandless
brands95118943bran__ds
branks124817383bran__ks
branned104311693bran_ned
branner94212373bran_ner
branners104010923branners
brannier10218933brannier
branniest11199383branniest
brans75437433bran___s
brants85723053bran__ts
brasher124515243bra_sher
brashest133511763bra_shest
brasses93818353bra_sses
brassies103613533brassies
brattles10199333brattles
braunites1146723braunites
braves115524083bra__ves
bravoes12418533bra_voes
braxies16711463bra_xies
brazes175522193bra__zes
breached163411643breached
breacher153011503breacher
breachers16369853breachers
breathes134212903breathes
breeched16337383breeched
brindles113710223brindles
brines85028853brin__es
brinies93317913brin_ies
brioche14275923brioche_
brisances1345843brisanc_es
broached16309123broached
broacher15329263broacher
broachers16328153broachers
broche133612103br_oche_
bronchi14176313bronch_i
bronchia15195993bronchia
broncho14206463bronch_o
broncos11188073bronc_os
broncs101611153bronc__s
bronzes183510403bron_zes
brunch13329353brunch__
brushes124014663br_ushes
bunched154312413b_unched
butches144315363b_utches
bycatches2142683bycatches
caches137926913_ca_ches
canchas143212403_canchas
caroches15710693caroches
catches144320773_catches
chances145218093chanc_es
chancres15429363chancres
chinches18369363chinches
cinches144215773_cinches
clenches152910953clenches
clinches153910363clinches
coaches144018693coa_ches
conches144019813_conches
cranch133613533cranch__
cranes84330753cran__es
crankles143510153crankles
crannies10313013crannies
crashes124618403cra_shes
craunched1764023craunched
creches14313093cr_eches
crotches153411303crotches
crouches153711293crouches
crunched16328163crunched
cruncher15338073cruncher
crunchers16316243crunchers
crutches15359593crutches
dances95120653_danc_es
disbranches1953523disbranches
drachms1534253dra_chms
drenched15247913drenched
drencher14257213drencher
drenchers15296103drenchers
dunches133312583_dunches
durances1158683duranc_es
earaches13411303earaches
errancies1147963errancies
fancies124018783_fancies
fiancees1335103fiancees
fiances12310673fianc_es
finches153914193_finches
flenches163410533flenches
flinches16358953flinches
franchise1746003franchise
franchises1855633franchises
francizes2346793francizes
francs114112193franc__s
frenched17299433frenched
ganaches1437413_ganaches
glances104113143glanc_es
glunches1436263glunches
graces94523493gra_c_es
grandees103211283grandees
granges93516523gran_ges
granites92116363granites
grannies9312613grannies
grantees92510973grantees
granules939933granules
grouches14328213grouches
grutches14285853grutches
hances115621283_hanc_es
hatches153420273_hatches
haunches1656963haunches
hunches153913463_hunches
inarches1358043inarches
inches114419673__inches
kenches163912273_kenches
klatches17157133klatches
laches116528343_la_ches
lances84824103_lanc_es
larches124416443_larches
latches123320123_latches
launches1387903launches
leaches123319343lea_ches
loaches123613983loa_ches
lunches124115443_lunches
lynches15378873_lynches
maches134827233_ma_ches
manche133515103_manche_
manchet143317773_manchet
manchets15269573_manchets
marches143921173_marches
matches143219783_matches
munches144215793_munches
naches114622413_na_ches
nances83618643_nanc_es
nancies93516843_nancies
nuances938523nuanc_es
orache114013593ora_che_
oracles93212423ora_cles
oranges84215333oran_ges
painches1588913painches
panaches15310283_panaches
panoches1548123_panoches
parches143720003_parches
patches143320383_patches
paunches1568173paunches
peaches144120053pea_ches
pinches144117933_pinches
planche14299753planche_
planchet152511963planchet
planchets16236743planchets
plenches153110623plenches
poaches144416943poa_ches
prance104318573pranc_e_
pranced123714043pranc_ed
prancer113613383pranc_er
prancers123210333prancers
preaches153214893preaches
princes113015143princ_es
punches144816133_punches
quaiches2235343quaiches
quenches2236013quenches
races74943243_ra_c_es
rachet115028973_ra_chet
rachets124516833_ra_chets
rachis114017653_ra_chis
rance75028513_ranc_e_
ranch105019793_ranch__
ranchero13277423_ranchero
rancheros14255793_rancheros
ranchless1444453_ranchless
ranchmen1545833_ranchmen
rancho114310853_ranch_o
rancors9811373_rancors
randies84225663_randies
ranees64623963_ran_ees
ranges73826923_ran_ges
rankles113114543_rankles
raphes115117453_ra_phes
rashes95330153_ra_shes
ratchet124218333_ratchet
ratchets133110263_ratchets
reaches123423203_reaches
rebranched1843673rebranched
retches123318513_retches
revanches1746253revanches
riches115022083_r_iches
roaches123616213_roaches
rotches123515703_rotches
rouches124217893_rouches
ruches114819583_r_uches
scratches1647323scratches
scrunches1635403scrunches
seances93015343seanc_es
searches132112903searches
slatches131511523slatches
snatches131410713snatches
stances93715963stanc_es
stanched14208903stanched
stancher13198813stancher
stanchers14206813stanchers
stanchest14218213stanchest
starches131912913starches
staunches1444603staunches
stenches132110293stenches
subbranches2052803subbranches
swatches16169963swatches
taches114224173_ta_ches
teaches122718353tea_ches
tenches123515523_tenches
thatches1637513thatches
traces85329933tra_c_es
trachea12311673tra_chea
tracheas13410273tra_cheas
trachles13311753tra_chles
trance84718763tranc_e_
tranced104414173tranc_ed
trannies8415013trannies
trashes104119263tra_shes
trauchles1445493trauchles
trenched14289853trenched
trencher13279313trencher
trenchers14288073trenchers
troches123715343tr_oches
truancies1146883truancies
unbranched1843533unbranched
uranides92211283uranides
uranites82514643uranites
usances967373usanc_es
vibrances1645763vibranc_es
vibrancies1744413vibrancies
watches153017373_watches
wenches152914133_wenches
winches154714373_winches
wrangles1237463wrangles
wrenched17748133wrenched
wrencher16287783wrencher
wrenchers17256333wrenchers
wretches16257283wretches

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461623788.03318195.2
3Display Results3783780.1862032.3
 (SQL Overall)1786913788.38921300.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.