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

62 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
burgonet114810(None) 
burgonets1243511burgonets
baronet91022202bar_onet
burgeoned1343702burgeoned
burgout1049772burgo_ut
burnet84326172bur__net
ballonet10314503ballonet
baronets101410903bar_onets
bayonet121212213b_ayonet
begone9512133b_egone_
beignet101510963beig_net
bourgeoned1452543bourgeoned
brunet84419293b_r_unet
budget104618123budg__et
bugout9311863bu_go_ut
burbot10815653burbo__t
burdened1236423burdened
burdener1136143burdener
buret77444013bur___et
burgage1136633burgage_
burgages1236483burgages
burgee97120593burg__ee
burgees104915893burg_ees
burgeon1036433burgeon__
burgeons1146053burgeon_s
burger94020793burg__er
burgher1337003burg_her
burgle94815863burg_le_
burgled115511423burg_led
burgles105615963burg_les
burgoo938933burgo__o
burgoos1037123burgo_os
burgouts1145123burgouts
burgundy1541353burgundy
burned95818963bur__ned
burner83819203bur__ner
burnets93813263bur__nets
burnout9310453burno_ut
burnt75230333bur__n_t
burrowed1444443burrowed
burrower1374263burrower
burstone1057133burstone_
burstones1187153burstones
burton8311273burton__
burtons9310853burton_s
buttoned1137503buttoned
buttoner1036973buttoner
bygone1256173b_ygone_
bygones1335913b_ygones
coronet94227173cor_onet
dragonet10138953dragonet
forgone1139343forgone_
gurglet94412033gurg_let
gurnet74920873gur__net
jargoned1735233jargoned
jargonel1643683jargonel
orgone71110913_orgone_
orgones81010793_orgones
outgone8311463outgone_
turbojet1755383turbojet
turgent8712393turgen_t
urgent73816043_urgen_t

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.406440125.6
2DLD Change Limit146162626.56322270.6
3Display Results62620.0302066.7
 (SQL Overall)178691626.99925530.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.