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

125 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
bourdons113643(None) 
bourbons1245341bourbons
bourdon1036421bourdon_
baudrons1135762baudrons
borons85520542bo_r_ons
boudins10311312bou_dins
bourbon1135812bourbon_
bourgeons1244392bourgeons
bourns84114062bour__ns
boursins1037512boursins
boutons9310782bou_tons
burdens1039712b_urdens
burtons9310852b_urtons
cordons104415762co_rdons
fourgons1234832fourgons
voudons1135322vou_dons
barons85025383b_ar_ons
baryons121010473b_aryons
bicrons113410473bicr_ons
biotrons1037243biotr_ons
blousons1054403blou_sons
boarders11408623boarders
boarding123110233boarding
boardings13296063boardings
boards94616933board__s
bolsons969483bo_lsons
bombardons1752053bombardons
bonbons1139333bo_nbons
boons75031913bo___ons
bordels103911973bo_rdels
borders104317533bo_rders
boredoms1346043boredoms
boreens9310403bo_reens
boron76727143bo_r_on_
borrows12349263bo_rrows
borzois1835833bo_rzois
bosons85016653bo__sons
bossdoms1343733bossdoms
bostons9312903bo_stons
boubous1138693bou_bous
boudin9412373bou_din_
boudoir1043853bou_doir
boudoirs1143703bou_doirs
bouillons1143603bouillons
boulders113010033boulders
bounden10389453bounden_
bounders114314113bounders
bounding123012133bounding
bounds94415803bound__s
bourbonism1652013bourbonism
bourgeois1243743bourgeois
bourgeon1144683bourgeon_
bourgs9459993bour__gs
bourn75518483bour__n_
bourne83714093bour__ne
bournes93615023bour_nes
bourrees10127643bourrees
bourses94014303bour_ses
boursin938283boursin_
bouton8311533bou_ton_
bunions92210473b_unions
burans85019303b_ur_ans
burbots1168673b_urbots
burden9412473b_urden_
burdies104117563b_urdies
burdock1644603b_urdock
burdocks1744033b_urdocks
burds84626063b_urd__s
burgeons1146053b_urgeons
burgoos1037123b_urgoos
burins84221893b_ur_ins
burnous938823b_urnous
burns74926783b_ur__ns
burros85114993b_urro_s
burrows12399103b_urrows
burton8311273b_urton_
buttons9310333b_uttons
cardons104519943_cardons
codons96119463co__dons
cordon95017293co_rdon_
coupons112710563cou_pons
courlans10117613courlans
diurons838823diur_ons
durions839963_durions
fordoes11311963fo_rdoes
fordone1149383fo_rdone
fourgon1134863fourgon_
godroons1045363godroons
gorgons938853go_rgons
gourdes9109383gourd_es
gourds8108253gourd__s
guerdons1044233guerdons
guidons936623_guidons
hourlong1242733hourlong
jordans1566833jo_rdans
journos14134943journo_s
kouros1039183kour_o_s
lardons83914493_lardons
loudens8368053lou_dens
lurdans837073_lurdans
monurons1037093monur_ons
morions94014643mo_rions
morons84919543mo_r_ons
morrions1077673morrions
mouflons13133653mouflons
mourns84111013mour__ns
moutons9410313mou_tons
neurons7410453neur_ons
ordos65216203_o_rdo_s
orlons6411013_o_rlons
outdoes8313123_outdoes
outdone8311643_outdone
pardons103817623_pardons
sordors8310013so_rdors
soudans8309353sou_dans
soupcons1244373soupcons
sourdine936893sourdine
sourdines1046743sourdines
soursops1043213soursops
turions7311573_turions
turnons737863_turnons
udons65411463__u_dons
voudon1035873vou_don_
voudouns1243203vou_douns
youpons12265983you_pons

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621256.46622604.7
3Display Results1251250.0462717.4
 (SQL Overall)1786911256.93525766.5
 
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.