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

131 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
mugful123540(None) 
jugful1734601jugful
mugfuls1344001mugfuls
bagful1237212bagful
cupful1356422cupful
jugfuls1843062jugfuls
jugsful1842682jugsful
lungful1144012lungful
manful11610212manful
moghul1244472moghul
mogul8310212mog_ul
muggur10325592muggur
mughal1236262mughal
museful1245882museful
rueful948202rueful
tubful1136682tubful
aidful1057073aidful
aimful1166703aimful
armful1167163armful
artful968273artful
augur64311213aug_ur
awful1178143_awful
bagfuls1334753bagfuls
bagsful1344893bagsful
boxful18145273boxful
bugout9311863bugout
bulbul10348073bulbul
cageful1356483cageful
canful11610263canful
capful1368173capful
carful11610973carful
cupfuls1444343cupfuls
cupsful1453433cupsful
duffel13407753duffel
dufus94010813du_fus
dugout8310363dugout
dutiful1144763dutiful
earful958963earful
eyeful1235903eyeful
fitful1256333fitful
fugal95613033fug_al
fugu85419863fug_u_
fugue94313373fug_ue
fugus95914013fug_us
fulfil1246423fulfil
furfur1235553furfur
gul45832793__g_ul
hatful12108743hatful
hurtful1344853hurtful
hushful1644333hushful
ireful948713ireful
jarful1646683jarful
joyful1943843joyful
jugal135612403jug_al
jugula1434983jug_ula
jugum15167473jug_um
kugel1068563kug_el
lapful1156483lapful
lawful1235493lawful
lungfuls1242773lungfuls
lustful1045283lustful
magnum1136733magnum
magus85318753mag_us
maul64830713m__aul
miaul71612123m_iaul
mindful1344613mindful
moanful12105003moanful
moghuls1343613moghuls
moguls948553mog_uls
mournful1342503mournful
mouthful1643573mouthful
mucluc1245053mucluc
mucous104411653mucous
mucus94015743mu_cus
mudbug1243253mudbug
muff124723853mu_f_f
muffed154210593muffed
muffin14298873muffin
muffle14339643muffle
muffs134114213mu_ffs
mufti10610543mu_fti
mug65837693mug___
mugg86316013mug__g
muggar10316443muggar
mugged114113833mugged
muggee103612833muggee
mugger103914703mugger
muggily1435103muggily
muggs94912323mug_gs
muggurs11315103muggurs
muggy125612373mug_gy
mughals1355753mughals
mugs76232043mug__s
mugwump1741213mugwump
mukluk1143503mukluk
muktuk1142883muktuk
mull65128803mu__ll
mumu86022063mu_mu_
mumus95517283mu_mus
mural75225103mu_ral
murmur1034853murmur
museum1037703museum
mussel83412903mussel
mutual838503mutual
mutuel837823mutuel
mutule8311423mu_tule
muumuu1042373muumuu
pageful1346353pageful
panful1179743panful
potful1138083potful
poutful1236743poutful
pushful1544493pushful
rugal65916093rug_al
rugous739643rugous
ruthful1344503ruthful
sinful938803sinful
sobful1136333sobful
songful1145163songful
soulful1045293soulful
sulfur937913sulfur
tinful938043tinful
topful1136543topful
tubfuls1245473tubfuls
tuneful1046123tuneful
unfurl937953_unfurl
useful947013useful
vatful12107083vatful
waeful1238123waeful
wilful1235963wilful
woeful1236363woeful
woful1158173_woful

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161317.07615929.3
3Display Results1311310.0502620.0
 (SQL Overall)1786911317.26924582.6
 
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.