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

198 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
branchy1735791(None) 
branch134014771branch_
beachy164011252bea_chy
blanch133410852blanch_
brach126123302bra_ch_
brachs134415752bra_chs
branched163210452branched
branches153613802branches
branchia15217712branchia
brandy124712062bran_dy
branny115111832bran_ny
brashy145210592bra_shy
bronchi14176312bronchi
broncho14206462broncho
brunch13329352brunch_
bunchy16437462b_unchy
cranch133613532cranch_
crunchy17324762crunchy
ranch105019792_ranch_
rancho114310852_rancho
raunchy15284312_raunchy
tranche123312222tranche
achy126316093__a_chy
anarchy1544933anarchy
ancho104515303__ancho
bach116131393b_a_ch_
banco94019393b_anc_o
bancos104713893b_ancos
bandy114824183b_an_dy
banty106624003b_an_ty
barney115314453barn_ey
barny105821733barn__y
batch124620103b_atch_
beach124623893bea_ch_
beanery1237563beanery
beechy16397503b_eechy
bench125619503b_ench_
bitchy16479203b_itchy
blanched16308603blanched
blancher15338633blancher
blanches153311603blanches
blandly1336043blandly
blankly1634263blankly
blench133710453blench_
blotchy17293973blotchy
botchy16537823b_otchy
bouncy13409073bounc_y
brace95629273bra_c_e
braced115420603bra_ced
bracer104620583bra_cer
braces108427773bra_ces
braches144621223bra_ches
brachet144020313bra_chet
brachia141910423bra_chia
bract96332723bra_c_t
bracts105617773bra_cts
braggy13337173bra_ggy
brainily1337313brainily
brainy114815643bra_iny
braky145015813bra__ky
brambly16296253brambly
bran65740383bran___
branchiae16186313branchiae
branchial16215963branchial
branchier1637133branchier
branching17289263branching
branchlet1647183branchlet
brand85124493bran__d
branded114414103branded
brander103915823brander
brands95118943bran_ds
brank115222283bran__k
branks124817383bran_ks
branned104311693branned
branner94212373branner
brans75437433bran__s
brant74742173bran__t
brants85723053bran_ts
brash106221563bra_sh_
brashly15427613brashly
brassy11509233bra_ssy
bratty1159683bra_tty
bravely15428233bravely
bravery15428133bravery
brawly144312353bra_wly
brawnily1644083brawnily
brawny144710603bra_wny
braxy175410893bra__xy
bray95232903bra___y
breach134213723breach_
breathy15328033breathy
breech13348263breech_
bricky17489093br_icky
briny104719663brin__y
brioche14275923brioche
broach133611113broach_
broche133612103br_oche
bronc91714343bronc__
bronchia15195993bronchia
bronchos15206173bronchos
bronchus15204743bronchus
bronco10179493bronc_o
broncos11188073broncos
broncs101611153bronc_s
bronzy20306713bron_zy
brooch13368443brooch_
brothy14519623br_othy
brunched16317853brunched
bruncher15347783bruncher
brunches153710453brunches
brushy14468263br_ushy
bunch125118603b_unch_
cancha134411613_cancha
catchy16559583_catchy
chancy164010863chanc_y
chinchy20335513chinchy
conchy163710223_conchy
cracky175010223cra_cky
cranched163210413cranched
cranches153114543cranches
crankly16358123crankly
cranky153910633cran_ky
cranny114210273cran_ny
cratch134110793cratch_
craunch1464443craunch_
crunch13349503crunch_
diarchy1644673diarchy
drachm1436493dra_chm
drench12369593drench_
dyarchy1942503dyarchy
eparchy17204753eparchy
errancy1256363erranc_y
exarchy22193693exarchy
fancy134615483_fanc_y
franc104615413franc__
francs114112193franc_s
frankly17315633frankly
french143511213french_
granary1157793granary
grandly1238743grandly
granny104311163gran_ny
grinch1238473grinch_
grouchy16294243grouchy
leachy14419733lea_chy
manche133515103_manche
nancy105214923_nanc_y
orach105219233ora_ch_
orache114013593ora_che
orangey11388833orangey
orangy105111233oran_gy
patchy16509573_patchy
paunchy17324443paunchy
peachy164510843pea_chy
planch133711443planch_
planche14299753planche
poachy16388963poa_chy
prance104318573pranc_e
pranced123714043pranced
prancer113613383prancer
prances113618773prances
preachy17307313preachy
punchy16398523_punchy
racy95825683_ra_c_y
rance75028513_ranc_e
rances84625443_rances
ranched133113603_ranched
rancher123013633_rancher
ranches123620113_ranches
ranchos123911393_ranchos
rancid9513863_rancid
rancor8810373_rancor
randy95022083_ran_dy
rangy95320383_ran_gy
rankly133910453_rankly
ratch104221363_ratch_
raunch11358433_raunch_
rebranch1545803rebranch_
reechy14367823_reechy
scratchy1843653scratchy
scrunchy1852383scrunchy
snatchy15355293snatchy
stanch113812373stanch_
stanchly1644443stanchly
starchy15286743starchy
stenchy15256213stenchy
thatchy1833303thatchy
trance84718763tranc_e
tranced104414173tranced
trances93919643trances
tranches132915513tranches
tranny94210863tran_ny
trashy12509053tra_shy
trench114211613trench_
triarchy1643613triarchy
truancy1244993truanc_y
vibrancy1843873vibranc_y
wrathy15377853wra_thy
wrench14439353wrench_

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271986.42320866.7
3Display Results1981980.0762605.3
 (SQL Overall)1786911986.92225814.9
 
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.