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

92 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
mugfuls134400(None) 
jugfuls1843061jugfuls
mugful1235401mugful_
bagfuls1334752bagfuls
cupfuls1444342cupfuls
jugful1734602jugful_
lungfuls1242772lungfuls
moghuls1343612moghuls
moguls948552mog_uls
muggurs11315102muggurs
mughals1355762mughals
tubfuls1245482tubfuls
armfuls1275013armfuls
augurs7399963aug_urs
bagful1237213bagful_
boxfuls19113603boxfuls
bugouts1036193bugouts
bulbuls11346783bulbuls
cagefuls1484343cagefuls
canfuls1248423canfuls
capfuls1436523capfuls
carfuls1249133carfuls
cupful1356423cupful_
duffels14296453duffels
dufus94010813du_fu_s
dugouts935043dugouts
earfuls1036863earfuls
eyefuls1343843eyefuls
fugues104511683fug_ues
fugus95914013fug_u_s
fulfils1345723fulfils
guls55930853__g_uls
hatfuls1386023hatfuls
jarfuls1754773jarfuls
jugsful1842683jugsful_
jugula1434983jug_ula
jugums16104673jug_ums
kugels1146073kug_els
lapfuls1234503lapfuls
lungful1144013lungful_
magnums1234683magnums
magus85318753mag_u_s
manful11610213manful_
mauls76524953m__auls
miauls8178713m_iauls
moghul1244473moghul_
mogul8310213mog_ul_
mouthfuls1742893mouthfuls
muclucs1343683muclucs
mucous104411653mucou_s
mucus94015743mu_cu_s
mudbugs1342853mudbugs
muffins15308343muffins
muffle14339643mu_ffle
muffles153910443muffles
muffs134114213mu_f_fs
muftis1158053mu_ftis
muggars11316643muggars
muggees11338883muggees
muggers113611933muggers
muggily1435103muggily
muggins11248073muggins
muggs94912323mug__gs
muggur10325593muggu_r
mughal1236273mughal_
mugs76232043mug___s
mugwump1741213mugwump
mugwumps184813mugwumps
mukluks1242413mukluks
muktuks1242253muktuks
mulls75124153mu__lls
mumus95517283mu_mu_s
murals84016753mu_rals
murmurs1134523murmurs
museful1245883museful_
museums1134563museums
mussels9419843mussels
mutuals937123mutuals
mutuels935943mutuels
mutule8311423mu_tule
mutules9311843mu_tules
muumuus1141763muumuus
pagefuls1474343pagefuls
panfuls1237173panfuls
potfuls1236293potfuls
rueful948203rueful_
rugous739653rugou_s
sulfurs1037343sulfurs
tinfuls1036593tinfuls
tubful1136683tubful_
unfurls1035573_unfurls
vatfuls1384853vatfuls

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 Filter1786911340270.1731032896.0
2DLD Change Limit134027927.01619103.1
3Display Results92920.0303066.7
 (SQL Overall)178691927.21924752.9
 
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.