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

151 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
mudcats123622(None) 
mudcaps1444101mudcaps
mudcat11311201mudcat_
muscats1138931muscats
ducats95011762du_cats
madcaps1435242madcaps
mudcap1335132mudca_p
mudflats1442982mudflats
mudras94212262mudra_s
mulcts10298712mulc_ts
muscat10314662muscat_
audads8167103aud_ads
audits72814113aud_its
bobcats1335993bobcats
budgets11489863budgets
cats66356343___cats
cushats12288273cushats
didacts1186063didacts
doats65224883__doats
drats66628373__drats
ducat86225903du_cat_
ducts85319893du_c_ts
dulcets1046283dulcets
educate10310213educate
educates1139623educates
educts9439893educ_ts
furcate12310453furcate
furcates1339883furcates
hepcats1436473hepcats
hubcaps1643543hubcaps
judas134911883jud_a_s
jurats134213203ju_rats
macaws1337023m_acaws
madams11310943mad_ams
madcap1336333madca_p
madras94316433madra_s
manats84623463m_anats
marcato1139743marcato
marcatos1249163marcatos
mascots113910343mascots
mats65460293m___ats
meats75034053m__eats
meccas1239493mecca_s
medals94218063med_als
medials103914743medials
medians103214213medians
mediants11299493mediants
medias93620783media_s
mediate103415213mediate
mediates112814063mediates
medicals1349363medicals
medicants1466783medicants
medicate13513243medicate
medicates14312113medicates
medlars10259443medlars
mescals112911573mescals
mezcals20246543mezcals
micas96823053m_ica_s
midcap1336473midca_p
midcults1343223midcults
middays14335663middays
midgets113910253midgets
midguts11296013midguts
midsts95510053mid_sts
midways16386183midways
misacts1139353misacts
miscast11312423miscast
miscasts1238353miscasts
miscuts1139183miscuts
miseats92815793miseats
moats75827643m__oats
mobcaps1543463mobcaps
modals93914463mod_als
muches134718993mu_ches
mucins102712513mu_cins
mucks134622643mu_c_ks
mucors104410853mu_cors
mucous104411653mu_cous
mucus94015743mu_c_us
mudbugs1342853mudbugs
mudders113211113mudders
muddies113513953muddies
muddles112914353muddles
mudflaps1641803mudflaps
mudflat1364883mudflat_
mudhens1335103mudhens
mudlark1463913mudlark
mudlarks1542883mudlarks
mudpack1843593mudpack
mudpacks1943233mudpacks
mudra83912433mudra__
muds75530653mud___s
muggars11316643muggars
mughals1355763mughals
mulches143210673mulches
mulct93820083mulc_t_
muletas937383muletas
mullahs12388733mullahs
mullas84215933mulla_s
mullets93614783mullets
munches144215793munches
murals84016763mu_rals
muras75329583mu_ra_s
muriate9313363muriate
muriates10312083muriates
muricate12311113muricate
murras84916013murra_s
musca9311763musca__
muscadets1442963muscadets
muscae10410673musca_e
muscatel1246063muscatel
muscatels1343443muscatels
muscids12187973muscids
muscles11310563muscles
musicals1247103musicals
muskets13258643muskets
muskits13278563muskits
muskrats1444313muskrats
musts75527443mu__sts
mutants938583mutants
mutate83017483mu_tate
mutates92215793mu_tates
mutches143314283mutches
muts64839983mu___ts
mutts75120253mu__tts
mutuals937133mutuals
nudists8356833nudists
numbats1137673numbats
ocicats11137413ocicats
outacts9310213outacts
outcast91013743outcast
outcasts10108683outcasts
outeats72215703outeats
quadrats1866483quadrats
redacts10510943redacts
redcaps1247073redcaps
redcoats1147123redcoats
scats75930603__scats
succahs1435323succahs
sulcate9314423sulcate
surcoats1047943surcoats
tipcats1137103tipcats
tomcats11127773tomcats
uncaps1039813_uncaps
uncast84215713_uncast
unhats91110623_unhats
upcast102710093_upcast
upcasts11185643_upcasts
wildcats1444173wildcats
yucas106013913yu_ca_s
yuccas13426553yucca_s

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.403443402.0
2DLD Change Limit1340271516.94019312.2
3Display Results1511510.0463282.6
 (SQL Overall)1786911517.38924183.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.