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

104 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
broncho1420646(None) 
bronchi14176311bronchi
bronchos15206171bronchos
bronco10179491bronc_o
branch134014772branch_
branchy17357912branchy
broach133611112broach_
broche133612102bro_che
bronc91714342bronc__
bronchia15195992bronchia
bronchus15204742bronchus
broncos11188072broncos
broncs101611152bronc_s
brooch13368442brooch_
brunch13329352brunch_
concho134414262_concho
honcho14389382_honcho
poncho133310122_poncho
rancho114310852_rancho
abroach1446213abroach_
ancho104515303__ancho
banco94019393b_anc_o
barouche1544173barouche
bench125619503b_ench_
blanch133410853blanch_
blench133710453blench_
blotch13197143blotch_
blotchy17293973blotchy
boche124216953b_o_che
boho96923323b_o__ho
bongo85720943b_on_go
bonito8313433b_onito
bonobo1037143b_onobo
boocoo1039003b_oocoo
borsch1336133borsch_
borscht1445993borscht
botch126717453b_otch_
botchy16537823b_otchy
brach126123303br_ach_
brachs134415753br_achs
branched163210453branched
branches153613803branches
branchia15217713branchia
breach134213723breach_
breech13348263breech_
brioche14275923brioche
broached16309123broached
broacher15329263broacher
broaches153211623broaches
brock136017073bro_c_k
brocks145214153bro_cks
bromo95217203bro__mo
bronchial16175333bronchial
bronchiole1752943bronchiole
bronchium1843373bronchium
bronze173610923bron_ze
bronzed19308213bronzed
bronzer18348493bronzer
bronzes183510403bronzes
bronzy20306713bron_zy
broo65129823bro___o
brooches15288193brooches
broth106521093bro_th_
broths115013923bro_ths
brothy14519623bro_thy
brought13308683brought
brunched16317853brunched
bruncher15347783bruncher
brunches153710453brunches
bunch125118603b_unch_
bunchy16437463b_unchy
bunco94616083b_unc_o
conch124620073_conch_
concha134213283_concha
conchos144313963_conchos
conchs134714903_conchs
conchy163710223_conchy
cranch133613533cranch_
crotch133410083crotch_
crouch133910203crouch_
crunch13349503crunch_
crunchy17324763crunchy
drench12369593drench_
drongo836793dron_go
french143511213french_
grinch1238473grinch_
grouch12318473grouch_
grouchy16294243grouchy
honchos15369573_honchos
ponchos143410703_ponchos
pronto8313993pron_to
ranch105019793_ranch_
ranchos123911393_ranchos
reecho11318653_reecho
rhonchi1542493rhonchi
roach105717003_roach_
rondo65218373_ron_do
rotch105815933_rotch_
rotche114311983_rotche
rouche114714313_rouche
tranche123312223tranche
trench114211613trench_
troche113112513tro_che
wrench14439353wrench_

Search took 8 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.1561145455.1
2DLD Change Limit1340271047.06318975.9
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.24924650.4
 
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.