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 “muss” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

337 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
muss6493376(None) 
buss65134911buss
cuss65430611cuss
fuss76027931fuss
mass66044931mass
mess65932431mess
miss65339411miss
moss67641031moss
muds75530651muds
mugs76232041mugs
mums85732771mums
muns65535911muns
mus55946751mu_s
muse67136031muse
muses75134301muses
mush94929121mush
musk104526191musk
musks116119641musks
mussy104117641mussy
must65145441must
musts75527441musts
muts64839981muts
puss64830131puss
suss45229301suss
wuss75219331wuss
amass77119682amass
amiss75823062amiss
amus65529612amu_s
amuse75920832amuse
amuses85117942amuses
ass37844062_ass
auks85525262auks
bass66146782bass
boss65938342boss
bubs86235492bubs
buds75235172buds
bugs76035912bugs
bums85934592bums
buns66243722buns
burs65847422burs
bus56950972bu_s
buses75936012buses
bush96630712bush
busk105429222busk
busks115521372busks
bust65947782bust
busts75227692busts
busy94727172busy
buts67247692buts
buys95726792buys
cess65326052cess
coss66143492coss
cubs85832382cubs
cuds76730472cuds
cues65438982cues
cups85430822cups
curs65645542curs
cusk105521632cusk
cusks114916052cusks
cusp86021062cusp
cusps94913672cusps
cusso74912292cusso
cuts65841152cuts
diss56434482diss
doss56235042doss
dubs78432192dubs
duds65530142duds
dues56045502dues
dugs614832282dugs
duns55140432duns
duos56728132duos
dups75929512dups
dusk95724152dusk
dusks105317252dusks
dust57142532dust
dusts65923562dusts
emus66821682emu_s
ess36030882_ess
fess76529162fess
foss76431642foss
fubs96328792fubs
fuds86528562fuds
fugs85730692fugs
funs75235732funs
furs76735042furs
fuse76429992fuse
fuses85628422fuses
fussy115613952fussy
gauss65613452gauss
guess64213362guess
guls55930852guls
gums75030942gums
guns55533482guns
gush85424002gush
gussy95314322gussy
gust55240702gust
gusts65722792gusts
guts56637252guts
guvs85816812guvs
guys85019642guys
hiss75629212hiss
hubs96027142hubs
hues75235232hues
hugs86129752hugs
hums96831422hums
huns76136932huns
hush105224112hush
husk116021952husk
husks125015452husks
hussy116812762hussy
huts76737442huts
jess116022032jess
joss115925592joss
jugs125525602jugs
jus106930222ju_s
just115433342just
justs124918262justs
juts115930162juts
kiss85227392kiss
koss85224812koss
kues86426772kues
kusso9398032kusso
lass47444542lass
less45635102less
loss45337962loss
lues45943552lues
lugs55233522lugs
lums65734242lums
lush75327692lush
lust47442602lust
lusts55022802lusts
lusus54813872lusus
luvs75818502luvs
macs86742502macs
mads76845362mads
maes66948392maes
mags75444522mags
mans66354532mans
maps86141042maps
mars66261862mars
mas58175812m_as
masa65034712masa
masas75630412masas
mash96039392mash
mask105227352mask
masks115320532masks
massa75518922massa
masse75125292masse
massy104518962massy
mast65959952mast
masts77035762masts
mats65460282mats
mauds85519272mauds
mauls76524952mauls
mauts75927192mauts
maws96437132maws
mays96940022mays
meds75735362meds
megs75530632megs
mels65941532mels
mems85931502mems
mesa67025482mesa
mesas76823202mesas
mesh96823002mesh
messy104913832messy
mews96629332mews
mhos95517772mhos
mibs85330462mibs
mics87435142mics
mids76541772mids
migs76935312migs
mils66045322mils
mips85534072mips
mirs66940562mirs
mis58162612m_is
mise66043572mise
mises74740562mises
miso67229892miso
misos76523292misos
missy105617562missy
mist66154522mist
mists76633902mists
moas65545342moas
mobs85737362mobs
mocs85834902mocs
mods77945052mods
mogs75439332mogs
mols65948572mols
moms86539482moms
mons68152252mons
moos66051302moos
mops85940132mops
mors65950062mors
mos57067122m_os
mosh95227602mosh
mosk105622442mosk
mosks116117002mosks
mosso74715182mosso
mossy105217062mossy
most66554202most
mosts76028542mosts
mots66853162mots
moues75732842moues
mouse77133002mouse
mouses85531422mouses
mousse84813032mousse
mousy106716942mousy
mows96340832mows
mu46737482mu__
much115224032much
muck125727852muck
mucks134622642mucks
mucus94015742mucus
mud67336862mu_d
muff124723852muff
muffs134114212muffs
mug65837692mu_g
mugg86316012mugg
muggs94912322muggs
mule65236972mule
mules75034292mules
mull65128802mull
mulls75124152mulls
mum76643612mu_m
mumm75718862mumm
mumms85513152mumms
mump105425722mump
mumps115619102mumps
mumu86022062mumu
mumus95517282mumus
mun56143852mu_n
muni65824402muni
munis75022002munis
muon65722732muon
muons75816172muons
mura65633292mura
muras75329562muras
mure65941332mure
mures75937212mures
murk105527252murk
murks114821722murks
murr65225132murr
murrs75521292murrs
musca9311762musca
mused85524582mused
muser76024122muser
musers84719092musers
mushes114124562mushes
mushy135316632mushy
music94316402music
musics103911782musics
musky144715292musky
mussed94418902mussed
mussel83412902mussel
musses84624782musses
musth105314782musth
musths11589482musths
musty105620952musty
mut58357182mu_t
mute65136872mute
mutes75033782mutes
mutt65739402mutt
mutts75120252mutts
mycs115314292mycs
ness45526562ness
nubs65927142nubs
nuns45228232nuns
nus37939392nu_s
nuts45032672nuts
ouds56430102ouds
ours47237562ours
oust46747442oust
ousts55225702ousts
outs45746962outs
pass65239952pass
piss65033332piss
pubs85029212pubs
puds75630512puds
pugs76332772pugs
puls65437562puls
puns66641482puns
pups86032232pups
purs65641042purs
pus55547842pu_s
puses75532202puses
push95526622push
pussy105614842pussy
puts65641752puts
quass144413762quass
rubs66133492rubs
rues46044482rues
rugs56033682rugs
rums64833472rums
runs46438072runs
ruse45938932ruse
ruses56136582ruses
rush76628182rush
rusk85823312rusk
rusks95816192rusks
rust45544912rust
rusts55026992rusts
ruts44541492ruts
sass45035622sass
smush104410582smush
smuts75415712smuts
subs66037122subs
suds56135292suds
sues46247652sues
suks85927122suks
sums65837582sums
suns45841902suns
sups64834432sups
suqs134319652suqs
tass45640572tass
toss45637972toss
truss54916922truss
tubs65430062tubs
tugs56231672tugs
tuis44829642tuis
tuns45138662tuns
tups65628762tups
tush74523902tush
tusk85621632tusk
tusks94915532tusks
tuts45838452tuts
umps85721942umps
uns35936752_uns
ups55629052_ups
us26937432_u_s
use36835162_use
uses44931112_uses
uts35534372_uts
vugs87022872vugs
wiss75630542wiss
wussy115810342wussy
yuks116418022yuks
yups96121602yups

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298723370.96630923.4
3Display Results3373370.0804212.5
 (SQL Overall)1786913371.126158695.4
 
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.