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

93 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
mudcaps144410(None) 
madcaps1435241madcaps
mudcap1335131mudcap_
mudcats1236221mudcats
hubcaps1643542hubcaps
madcap1336332madcap_
midcap1336472midcap_
mobcaps1543462mobcaps
mudcat11311202mudca_t
mudflaps1641802mudflaps
mudras94212262mudra_s
muscats1138932muscats
redcaps1247072redcaps
uncaps1039812_uncaps
audads8167103aud_ads
becaps123811403_becaps
bluecaps1442513bluecaps
burlaps1156253burlaps
caps87147893___caps
daps77239163__d_aps
ducats95011763du_cats
gelcaps1235203gelcaps
hubcap1553993hubcap_
icecaps1343863icecaps
judas134911883jud_a_s
kidnaps1453323kidnaps
macaws1337023m_acaws
madams11310943mad_ams
madras94316433madra_s
maps86141053m___aps
meccas1239493mecca_s
medals94218053med_als
medials103914733medials
medians103214213medians
medias93620783media_s
medicals1349363medicals
medigaps1463883medigaps
medlars10259443medlars
mescals112911553mescals
mezcals20246533mezcals
micas96823053m_ica_s
middays14335663middays
midways16386183midways
mishaps1438713mishaps
mobcap1444113mobcap_
modals93914453mod_als
muches134718993mu_ches
mucins102712513mu_cins
mucks134622643mu_c_ks
mucors104410853mu_cors
mucous104411653mu_cous
mucus94015743mu_c_us
mudbugs1342853mudbugs
mudcapped1941383mudcapped
mudders113211113mudders
muddies113513953muddies
muddles112914353muddles
mudflap1542183mudflap_
mudflats1442983mudflats
mudhens1335103mudhens
mudlark1463913mudlark
mudlarks1542883mudlarks
mudpack1843593mudpack
mudpacks1943233mudpacks
mudra83912433mudra__
muds75530653mud___s
muggars11316643muggars
mughals1355763mughals
mulches143210673mulches
mulcts10298713mulc_ts
mullahs12388733mullahs
mullas84215933mulla_s
mumps115619103mu__mps
munches144215793munches
murals84016763mu_rals
muras75329583mu_ra_s
murras84916013murra_s
musca9311763musca__
muscae10410673musca_e
muscat10314653musca_t
muscids12187973muscids
muscles11310563muscles
musicals1247093musicals
mutches143314283mutches
mutuals937123mutuals
recaps103615733_recaps
redcap1158493redcap_
skycaps1842703skycaps
succahs1435323succahs
toecaps1135553toecaps
uncap9312283_uncap_
yucas106013913yu_ca_s
yuccas13426553yucca_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 Limit134027935.64023763.7
3Display Results93930.0332818.2
 (SQL Overall)178691936.07929394.8
 
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.