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 “bourbons” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
bourbons124534(None) 
bourbon1135811bourbon_
bourdons1136431bourdons
bonbons1139332bo_nbons
borons85520542bo_r_ons
boubous1138692bou_bous
bourbonism1652012bourbonism
bourdon1036422bourdon_
bourgeons1244392bourgeons
bourns84114062bour__ns
boursins1037512boursins
boutons9310782bou_tons
burbots1168672b_urbots
burtons9310852b_urtons
fourgons1234832fourgons
barons85025383b_ar_ons
baryons121010473b_aryons
baudrons1135763baudrons
bicrons113410473bicr_ons
biotrons1037233biotr_ons
blousons1054403blou_sons
blurbing13326503blurbing
blurbs10489313blurb__s
bobbins103410343bo_bbins
bolsons969483bo_lsons
bonbon10310073bo_nbon_
bonobos1136393bonobo_s
booboos1138143bo_oboos
boons75031913bo___ons
boreens9310403bo_reens
boron76727143bo_r_on_
borrows12349253bo_rrows
borzois1835833bo_rzois
boshboks1943413boshboks
bosons85016653bo__sons
bostons9312903bo_stons
boubou1038433bou_bo_u
boudins10311313bou_dins
bouillons1143603bouillons
bourbonisms1751883bourbonisms
bourgeois1243743bourgeois
bourgeon1144683bourgeon_
bourgs9459993bour__gs
bourn75518483bour__n_
bourne83714093bour__ne
bournes93615023bour_nes
bourrees10127643bourrees
bourses94014303bour_ses
boursin938283boursin_
bouton8311533bou_ton_
buboes104513993b_u_boes
bulbous1138293b_ulbous
bunions92210473b_unions
burans85019303b_ur_ans
burbles114916803b_urbles
burbot10815653b_urbo_t
burbs95423493b_urb__s
burdens1039713b_urdens
burgeons1146053b_urgeons
burgoos1037123b_urgoos
burins84221893b_ur_ins
burnous938823b_urnous
burns74926783b_ur__ns
burros85114993b_urro_s
burrows12399093b_urrows
burton8311273b_urton_
busboys14325023b_usboys
buttons9310333b_uttons
carbons115418943_carbons
corbans11313173co_rbans
cordons104415763co_rdons
coupons112710563cou_pons
courlans10117613courlans
diurons838823diur_ons
durions839963_durions
fourgon1134863fourgon_
godroons1045363godroons
gorgons938853go_rgons
hourlong1242733hourlong
journos14134943journo_s
kouros1039183kour_o_s
monurons1037093monur_ons
morions94014643mo_rions
morons84919543mo_r_ons
morrions1077673morrions
mouflons13133653mouflons
mourns84111013mour__ns
moutons9410313mou_tons
neurons7410443neur_ons
orlons6411013_o_rlons
soupcons1244373soupcons
soursops1043213soursops
turbans939563_turbans
turbos8910783_turbo_s
turbots988023_turbots
turions7311573_turions
turnons737863_turnons
voudons1135323vou_dons
youpons12265983you_pons

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 Filter1786911461620.423422437.4
2DLD Change Limit146162997.26620115.9
3Display Results99990.0462152.2
 (SQL Overall)178691997.73523101.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.