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

108 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
bronchi1417631(None) 
bronchia15195991bronchia
broncho14206461broncho
branch134014782branch_
branchia15217712branchia
branchy17357912branchy
broach133611112broach_
broche133612102bro_che
bronc91714342bronc__
bronchial16175332bronchial
bronchium1843372bronchium
bronchos15206172bronchos
bronchus15204742bronchus
bronco10179492bronc_o
broncos11188072broncos
broncs101611152bronc_s
brooch13368442brooch_
brunch13329352brunch_
rhonchi1542502rhonchi
abroach1446213abroach_
barouche1544173barouche
bench125619503b_ench_
biochip1645323bio_chip
blanch133410853blanch_
blench133710453blench_
blotch13197143blotch_
blotchy17293973blotchy
bocci113512713b_o_cci
boche124216953b_o_che
bonaci10310963b_onaci
bonsai838463b_onsai
borsch1336133borsch_
borscht1445993borscht
botch126717453b_otch_
botchy16537823b_otchy
boychik2143943b_oychik
brach126123303br_ach_
brachia141910423br_achia
brachs134415753br_achs
branched163210453branched
branches153613803branches
branchiae16186313branchiae
branchial16215963branchial
branchier1637133branchier
branching17289263branching
breach134213723breach_
breech13348263breech_
brioche14275923brioche
broached16309123broached
broacher15329263broacher
broaches153211623broaches
broaching17287663broaching
broccoli1443553broccoli
brock136017073bro_c_k
brocks145214153bro_cks
brocoli1146353brocoli
bronchiole1752943bronchiole
bronchitic1953013bronchitic
bronchitis1753463bronchitis
bronze173610923bron_ze
bronzed19308213bronzed
bronzer18348493bronzer
bronzes183510403bronzes
bronzy20306713bron_zy
brooches15288193brooches
broth106521093bro_th_
broths115013923bro_ths
brothy14519623bro_thy
brought13308693brought
brunched16317853brunched
bruncher15347783bruncher
brunches153710453brunches
brunching17316483brunching
bunch125118603b_unch_
bunchy16437463b_unchy
conch124620073_conch_
concha134213283_concha
conchie143312683_conchie
concho134414263_concho
conchs134714903_conchs
conchy163710223_conchy
cranch133613533cranch_
croci95818133cro_c_i
crotch133410083crotch_
crouch133910203crouch_
crunch13349503crunch_
crunchy17324763crunchy
drench12369593drench_
elenchi1244723elenchi
french143511213french_
gnocchi1541923gnocchi
grinch1238483grinch_
grouch12318473grouch_
grouchy16294243grouchy
honcho14389383_honcho
poncho133310123_poncho
ranch105019793_ranch_
rancho114310853_rancho
roach105717003_roach_
roshi8310753_ro_shi
rotch105815933_rotch_
rotche114311983_rotche
rouche114714313_rouche
tranche123312223tranche
trench114211613trench_
troche113112513tro_che
trochil1258713tro_chil
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.453394461.4
2DLD Change Limit1340271086.51320578.4
3Display Results1081080.0333272.7
 (SQL Overall)1786911086.99925530.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.