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

89 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
muggs9491232(None) 
miggs96311371miggs
mugg86316011mugg_
muggy125612371muggy
mugs76232041mu_gs
vuggs10579131vuggs
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
mages85036022mages
mags75444532m_ags
magus85318752magus
megs75530632m_egs
migg85716802migg_
migs76935322m_igs
moggy125212162moggy
mogs75439332m_ogs
mucks134622642mucks
mucus94015742mucus
muds75530652mu_ds
muffs134114212muffs
mug65837692mu_g_
muggar10316442muggar
muggars11316642muggars
mugged114113832mugged
muggee103612832muggee
muggees11338882muggees
mugger103914702mugger
muggers113611932muggers
muggins11248072muggins
muggur10325592muggur
muggurs11315102muggurs
mules75034292mules
mulls75124152mulls
mumms85513152mumms
mumps115619102mumps
mums85732772mu_ms
mumus95517282mumus
mungo84916052mungo
mungos94311372mungos
munis75022002munis
muns65535922mu_ns
muons75816172muons
muras75329582muras
mures75937222mures
murks114821732murks
murrs75521302murrs
mus55946752mu__s
muses75134302muses
musks116119642musks
muss64933762mu_ss
musts75527442musts
mutes75033782mutes
muts64839982mu_ts
mutts75120252mutts
noggs75811182noggs
puggy124612322puggy
pugs76332772pu_gs
pungs85422222pungs
quags154613252quags
raggs75216472raggs
rugs56033682ru_gs
rungs611819402rungs
sughs95313322sughs
teggs74710742teggs
tugs56231672tu_gs
tungs65520632tungs
ughs85410972_ughs
vugg95612712vugg_
vuggy13589482vuggy
vughs12678742vughs
vugs87022872vu_gs
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.326548131.9
2DLD Change Limit53800891.61033416.1
3Display Results89890.0136846.2
 (SQL Overall)178691891.94991683.4
 
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.