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

265 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
muscat1031465(None) 
mudcat11311201mudcat
musca9311761musca_
muscae10410671muscae
muscats1138931muscats
cushat113513692cushat
ducat86225902du_cat
mascot104016072mascot
mescal104113482mescal
misact10316682misact
miscast11312412miscast
miscut10614812miscut
miseat82925702miseat
mudcap1335132mudcap
mudcats1236222mudcats
mulct93820082mulc_t
muscadet1348142muscadet
muscatel1246062muscatel
muscid11219832muscid
muscle10310972muscle
muscly1337452muscly
musical1139552musical
musket122818202musket
muskit122813252muskit
muskrat1346732muskrat
must65145442mus__t
scat65848372__scat
amusia839173amusia_
amusias938583amusias
ascot76522513_ascot
bobcat12411253bobcat
buccal1248243buccal
busbar1038453busbar
busman10310253busman
bust65947783bus__t
cat58282343___cat
cuscus1038113cuscus
cushats12288273cushats
cushaw14386983cushaw
cuspal1037883cuspal
cuspate1138233cuspate
descant104315583descant
discant103017253discant
ducal84816423du_cal
ducats95011763du_cats
duct75735463du_c_t
dulcet9314493dulcet
dust57142533dus__t
escar74011993_escar
escot75320083_escot
fiscal1139333fiscal
furcate12310453furcate
gusset7316433gusset
gust55240703gus__t
hepcat13611823hepcat
hubcap1553993hubcap
hussar9317283hussar
jurat124829323ju_rat
just115433343jus__t
kismat123011673kismat
lascar868573lascar
lust47442603lus__t
macaw12311763m_acaw
madcap1336333madcap
manat76039993m_anat
marcato1139743marcato
masa65034723mas_a_
masas75630413mas_as
mascara1138023mascara
mascon103612743mascon
mascots113910343mascots
massa75518923massa_
massas85116463massas
mast65959963mas__t
mat58083943m___at
meat66359603m__eat
mecca1139933mecca_
meccas1239493meccas
mesa67025483mes_a_
mesas76823203mes_as
mescals112911553mescals
mesial84818083mesial
mesian84315503mesian
messan83912063messan
mezcal19367853mezcal
mica86428253m_ica_
micas96823053m_icas
midcap1336473midcap
misacts1139353misacts
misate81222693mis_ate
miscall1139643miscall
miscasts1238343miscasts
miscite11314383miscite
miscue10412223miscue
miscuts1139183miscuts
misdate101413963misdate
miseats92815783miseats
misfit112813833misfit
mishap1338863mishap
mishit112618193mishit
miskal123710263miskal
mislay113510683mislay
mislit83019693mislit
mismate111415353mismate
mismet103722373mismet
mispart111113773mispart
misrate91319143misrate
missal84314903missal
missay114112143missay
misseat93617233misseat
misset85028153misset
mist66154533mis__t
moat66352033m__oat
mobcap1444113mobcap
moschate1546583moschate
moshav1446053moshav
most66554203mos__t
much115224033mu_c_h
mucho125013443mu_cho
mucid104115253mu_cid
mucin93116823mu_cin
muck125727853mu_c_k
mucks134622643mu_cks
mucky165015253mu_cky
mucor94011943mu_cor
mucro94513723mu_cro
mucus94015743mu_cus
mudcaps1444103mudcaps
mudflat1364883mudflat
mudra83912433mudra_
mudras94212263mudras
muggar10316443muggar
mughal1236273mughal
mulch124012973mulc_h
mulcts10298713mulcts
muleta839233muleta
mulla74317113mulla_
mullah113710733mullah
mullas84215933mullas
mullet84126823mullet
munch124917103munc_h
mura65633303mu_ra_
mural75225113mu_ral
muras75329583mu_ras
muriate9313363muriate
muricate12311113muricate
murra74519083murra_
murras84916013murras
mus55946753mus___
muscadel1343763muscadel
muscadets1442963muscadets
muscatels1343443muscatels
muscids12187973muscids
muscled1237783muscled
muscles11310563muscles
muscular1246243muscular
muse67136033mus__e
mused85524583mus_ed
muser76024123mus_er
musers84719103musers
muses75134303mus_es
musette938433musette
museum1037703museum
mush94929123mus__h
mushed124420843mushed
musher113820573musher
mushes114124563mushes
mushy135316633mus_hy
music94316403mus_ic
musicale1247343musicale
musicals1247093musicals
musician1246693musician
musick14408703musick
musicks15297053musicks
musics103911783musics
musing93919503musing
musjid16216953musjid
musk104526193mus__k
muskeg13338183muskeg
muskets13258643muskets
muskie123412543muskie
muskits13278563muskits
muskox1933953muskox
muskrats1444313muskrats
musks116119643mus_ks
musky144715293mus_ky
muslin8312213muslin
muss64933763mus__s
mussed94418903mussed
mussel83412903mussel
musses84624783musses
mussy104117643mus_sy
mustang10267933mustang
mustard10359533mustard
musted93321073musted
mustee83922103mustee
muster84724523muster
musth105314783mus_th
musths11589483musths
musts75527443mus_ts
musty105620953mus_ty
mut58357183mu___t
mutant8317693mutant
mutate83017483mu_tate
mutch125016173mutc_h
mutest84218053mutest
mutt65739403mu__tt
mutual838503mutual
mysost1138263mysost
numbat10312083numbat
ocicat101412813ocicat
oust46747443ous__t
outact8317203outact
outcast91013743outcast
outeat62824533outeat
outsat62920283outsat
pascal10812373pascal
pushcart1554553pushcart
pussycat1542333pussycat
rascal8511123rascal
resat55139683res_at
reseat64131493reseat
russet6319433russet
rust45544913rus__t
sat36288483__s_at
scab85926713__scab
scad75725773__scad
scag76626893__scag
scam85932353__scam
scan65530453__scan
scant79735073__scant
scar66434203__scar
scart76139773__scart
scats75930603__scats
scatt76030093__scatt
scot66242613__scot
scut65835543__scut
seat47575563__seat
shat76456603__shat
skat87037903__skat
slat46959023__slat
spat66548523__spat
stat47352693__stat
succah1336643succah
sulcal8311273sulcal
sulcate9314423sulcate
surcoat9412923surcoat
swat77244443__swat
tipcat10312653tipcat
tomcat101013453tomcat
tusche1136783tusche
tussah9356233tussah
tussal6288323tussal
tussar6369543tussar
uncap9312283_uncap
uncast84215713_uncast
uncut73219173_uncut
unhat81119263_unhat
unseat64221023unseat
upcast102710093_upcast
usual5310183_usual
yuca95716723yu_ca_
yucas106013913yu_cas
yucca12467443yucca_
yuccas13426553yuccas

Search took 6 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.376475242.0
2DLD Change Limit1127162655.03022408.7
3Display Results2652650.0932849.5
 (SQL Overall)1786912655.49932495.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.