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

168 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
mudcat1131120(None) 
mudcap1335131mudcap
mudcats1236221mudcats
muscat10314651muscat
ducat86225902du_cat
madcap1336332madcap
midcap1336472midcap
mudcaps1444102mudcaps
mudflat1364882mudflat
mudra83912432mudra_
mudras94212252mudras
mulct93820082mulc_t
musca9311762musca_
muscae10410672muscae
muscats1138932muscats
audad71511383aud_ad
audial7312993audial
audit62527883aud_it
bobcat12411253bobcat
buccal1248243buccal
budget104618113budget
cat58282343___cat
cushat113513693cushat
didact10711203didact
doat56947673__doat
drat56247833__drat
ducal84816423du_cal
ducats95011763du_cats
duct75735463du_c_t
dulcet9314493dulcet
educate10310213educate
educt85017103educ_t
furcate12310453furcate
hepcat13611823hepcat
hubcap1553993hubcap
judas134911883jud_as
jurat124829323ju_rat
macaw12311763m_acaw
madam10316223mad_am
madcaps1435243madcaps
madman113712383madman
madras94316423madras
manat76039983m_anat
marcato1139743marcato
mascot104016073mascot
mat58083933m___at
meat66359603m__eat
mecca1139933mecca_
meccas1239493meccas
medal86221323med_al
media84721713media_
mediad104313713mediad
mediae94217413mediae
medial93819863medial
median94117543median
mediant103516703mediant
medias93620783medias
mediate103415213mediate
medical12312513medical
medicant13910823medicant
medicate13513243medicate
medlar93010463medlar
mescal104113483mescal
mezcal19367853mezcal
mica86428253m_ica_
micas96823053m_icas
midcult1246303midcult
midday13327503midday
midget103718443midget
midgut103510053midgut
midst85922553mid_st
midway15327153midway
misact10316683misact
miscast11312403miscast
miscut10614813miscut
miseat82925703miseat
moat66352033m__oat
mobcap1444113mobcap
modal85919233mod_al
modest93818453modest
modica11310063modica_
much115224033mu_c_h
mucho125013443mu_cho
mucid104115253mu_cid
mucin93116823mu_cin
muck125727853mu_c_k
mucks134622643mu_cks
mucky165015253mu_cky
mucor94011943mu_cor
mucro94513723mu_cro
mucus94015743mu_cus
mud67336863mud___
mudbug1243253mudbug
mudded114511383mudded
mudder104413493mudder
muddle103414633muddle
muddly13418603muddly
muddy123812233mud_dy
mudflap1542183mudflap
mudflats1442983mudflats
mudhen1236883mudhen
mudlark1463913mudlark
mudpack1843593mudpack
muds75530653mud__s
muggar10316443muggar
mughal1236263mughal
mulch124012973mulc_h
mulcts10298713mulcts
muleta839233muleta
mulla74317113mulla_
mullah113710733mullah
mullas84215933mullas
mullet84126823mullet
munch124917103munc_h
mura65633293mu_ra_
mural75225103mu_ral
muras75329563mu_ras
muriate9313363muriate
muricate12311113muricate
murra74519083murra_
murras84916003murras
muscadet1348143muscadet
muscatel1246063muscatel
muscid11219833muscid
muscle10310973muscle
muscly1337453muscly
musical1139553musical
musket122818203musket
muskit122813253muskit
muskrat1346733muskrat
must65145443mu__st
mut58357183mu___t
mutant8317693mutant
mutate83017483mu_tate
mutch125016173mutc_h
mutest84218053mutest
mutt65739403mu__tt
mutual838503mutual
nudest74113833nudest
nudist73813323nudist
numbat10312083numbat
ocicat101412813ocicat
outact8317203outact
outcast91013743outcast
outeat62824533outeat
outsat62920283outsat
quadrat1769273quadrat
redact9419043redact
redcap1158493redcap
redcoat10410883redcoat
rudest74016313rudest
scat65848373__scat
succah1336643succah
sulcal8311273sulcal
sulcate9314423sulcate
surcoat9412923surcoat
tipcat10312653tipcat
tomcat101013453tomcat
uncap9312283_uncap
uncast84215713_uncast
uncut73219173_uncut
unhat81119263_unhat
upcast102710093_upcast
wildcat1346293wildcat
yuca95716723yu_ca_
yucas106013913yu_cas
yucca12467443yucca_
yuccas13426553yuccas

Search took 5 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 Limit1127161684.73323814.9
3Display Results1681680.0632666.7
 (SQL Overall)1786911684.93936179.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.