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

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

52 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
vuggs1057913(None) 
muggs94912321muggs
vugg95612711vugg_
vuggy13589481vuggy
vughs12678741vughs
vugs87022871vu_gs
buggy124613482buggy
bugs76035912bu_gs
bungs85323862bungs
burgs84924092burgs
dugs614832282du_gs
dungs75821972dungs
eggs66516152_eggs
fuggy135411672fuggy
fugs85730692fu_gs
fugus95914012fugus
hoggs107212462hoggs
hugs86129752hu_gs
iggs66612672_iggs
jaggs148111492jaggs
jugs125525602ju_gs
luges65928752luges
lugs55233522lu_gs
lungs65223882lungs
miggs96311372miggs
mugg86316012mugg_
muggy125612372muggy
mugs76232042mu_gs
noggs75811182noggs
puggy124612322puggy
pugs76332772pu_gs
pungs85422222pungs
quags154613252quags
raggs75216472raggs
rugs56033682ru_gs
rungs611819402rungs
sughs95313322sughs
teggs74710742teggs
tugs56231672tu_gs
tungs65520622tungs
ughs85410972_ughs
vagus96713812vagus
vangs96319582vangs
veges94118862veges
vigas94817882vigas
vigs85427272v_igs
vug76127412vu_g_
vugh117115722vu_gh
vulgo936952vulgo
vulgus1035782vulgus
yeggs10608162yeggs
yugas95012062yugas

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800521.75030742.9
3Display Results52520.0163250.0
 (SQL Overall)178691521.85996122.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.