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

116 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
mughals135576(None) 
mughal1236271mughal_
moghuls1343622moghuls
mugfuls1344002mugfuls
muggars11316642muggars
murals84016762mu_rals
mutuals937132mutuals
nuchals12216932nuchals
afghans1443573afghans
aghas97014873_agha_s
argals75517713arg_als
aughts104710243augh_ts
bubals103513843bu_bals
bugshas1334513bugsha_s
buhls105111803bu_h_ls
burghal1335073burghal_
burials93612083burials
bushels124110713bushels
buttals938503buttals
curtals93111623curtals
cushats12288273cushats
cushaws15356293cushaws
dhals95415443__dhals
duals65620083du__als
fugal95613033fug_al_
fulhams1543983fulhams
fungals11276783fungals
gals57946503__g_als
ghats95818613__ghats
goals65521293__goals
jubhahs2242353jubhahs
jugal135612403jug_al_
jugfuls1843063jugfuls
jugheads2042923jugheads
jumbals18106533jumbals
kugels1146073kug_els
legals73412733leg_als
lethals1038113lethals
lugsails942743lugsails
magians10310753magians
magmas115512503magma_s
mammals10389273mammals
manuals9311223manuals
marshals1337783marshals
meals75933383m__eals
medals94218063m_edals
medials103914743medials
megass9219443meg_ass
menials94015693menials
mescals112911573mescals
metals84520893m_etals
methyls1535453methyls
mezcals20246543mezcals
mights123516253migh_ts
mishaps1438723mishaps
miskals13369773miskals
missals93914433missals
mochas13310663mocha_s
modals93914463m_odals
moghul1244473moghul_
moguls948563mog_uls
mohels115011333m_ohels
morals85324643m_orals
mortals93914013mortals
muches134718993much_es
muchly1686203much_ly
mudcaps1444103mudcaps
mudcats1236223mudcats
mudhens1335103mudhens
mudhole1344913mudhole
mudholes1444873mudholes
mudras94212263mudra_s
mugful1235403mugful_
muggar10316443mugga_r
muggees11338883muggees
muggers113611933muggers
muggily1435103muggily
muggins11248073muggins
muggs94912323mug__gs
muggurs11315103muggurs
mugs76232043mug___s
muhly1358523mu_h_ly
mullahs12388733mullahs
mullas84215933mulla_s
mulls75124153mu__lls
mural75225113mu_ral_
muras75329583mu_ra_s
murras84916013murra_s
murrhas12286173murrha_s
muscats1138933muscats
mushers124016443mushers
mushes114124563mush_es
mushily152410093mushily
musicals1247103musicals
mussels9419843mussels
mutual838503mutual_
mutuels935943mutuels
muzhiks2573093muzhiks
nuchal11218873nuchal_
oghams1245853_oghams
oughts104710183ough_ts
outhauls1137223outhauls
quezals2544253quezals
ringhals1256263ringhals
rugal65916093rug_al_
rugolas836373rugolas
signals8359163signals
subgoals1145553subgoals
sugars7312423sug_ars
sughs95313323sugh__s
ughs85410973_ugh__s
unhats91110623_unhats
urials64415193_urials
usuals637793_usuals
vughs12678743vugh__s
yugas95012063yug_a_s

Search took 7 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.406440125.6
2DLD Change Limit1340271165.62323835.5
3Display Results1161160.0333515.2
 (SQL Overall)1786911166.06229477.2
 
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.