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

325 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
mums8573277(None) 
bums85934591bums
gums75030941gums
hums96831421hums
lums65734241lums
mems85931501mems
moms86539481moms
muds75530651muds
mugs76232041mugs
mum76643611mum_
mumm75718861mumm
mumms85513151mumms
mump105425721mump
mumps115619101mumps
mumu86022061mumu
mumus95517281mumus
muns65535911muns
mus55946751mu_s
muss64933761muss
muts64839981muts
rums64833471rums
sums65837581sums
aims67738182aims
alms65834922alms
alums75720602alums
amus65529612amu_s
arms66137492arms
arums75517832arums
auks85525262auks
bams87044452bams
bubs86235502bubs
buds75235172buds
bugs76035912bugs
bum75342692bum_
bumf116126512bumf
bumfs125414052bumfs
bump106228242bump
bumps115921142bumps
buns66243722buns
burs65847422burs
bus56950972bu_s
buss65134912buss
buts67247692buts
buys95726792buys
cams87047282cams
chums125015832chums
cubs85832382cubs
cuds76730472cuds
cues65438982cues
culms95314192culms
cum76440162cum_
cups85430822cups
curs65645542curs
cuss65430612cuss
cuts65841152cuts
cwms11439572cwms
dams77444372dams
dims75435022dims
doms76239572doms
doums85417642doums
drums85415872drums
dubs78432192dubs
duds65530142duds
dues56045502dues
dugs614832282dugs
duma75524452duma
dumas85420432dumas
dumb97124102dumb
dumbs105915752dumbs
dump95927092dump
dumps105220102dumps
duns55140432duns
duos56728132duos
dups75929512dups
elms67322702elms
ems56435492_ems
emus66821682emu_s
fems96428702fems
fubs96328792fubs
fuds86528562fuds
fugs85730692fugs
fume96727632fume
fumes105224702fumes
fumy127118582fumy
funs75235732funs
furs76735042furs
fuss76027932fuss
gams76648882gams
gaums86217072gaums
gems75329112gems
geums85414112geums
glums84621422glums
guls55930852guls
gum67439532gum_
guns55533482guns
guts56637252guts
guvs85816812guvs
guys85019642guys
gyms107514592gyms
hams96446132hams
hems95534942hems
hims95230972hims
hubs96027142hubs
hues75235232hues
hugs86129752hugs
hum85542932hum_
hump116228722hump
humps126322802humps
humus106215072humus
huns76136932huns
huts76737442huts
imams91511112imams
imaums10106302imaums
isms66213472isms
jams135231072jams
jugs125525602jugs
jump156621722jump
jumps165116492jumps
jus106930222ju_s
juts115930162juts
kues86426772kues
kumys1435932kumys
lams66552262lams
lues45943552lues
lugs55233522lugs
lum55542932lum_
luma65527522luma
lumas75622912lumas
lump86531702lump
lumps95624982lumps
luvs75818502luvs
macs86742502macs
mads76845362mads
maes66948392maes
mags75444522mags
maims96321792maims
malms95021552malms
mama86231582mama
mamas95930772mamas
mans66354532mans
maps86141042maps
mars66261862mars
mas58175812m_as
mass66044932mass
mats65460282mats
mauds85519272mauds
mauls76524952mauls
mauts75927192mauts
maws96437132maws
mays96940022mays
meds75735362meds
megs75530632megs
mels65941532mels
mem77943472mem_
meme85330552meme
memes94927702memes
memo85924792memo
memos95719112memos
mess65932432mess
mews96629332mews
mhos95517772mhos
mibs85330482mibs
mics87435152mics
mids76541782mids
migs76935322migs
mils66045332mils
mim76048422mim_
mime85736402mime
mimes95732022mimes
mips85534082mips
mirs66940572mirs
mis58162622m_is
miss65339422miss
mm67826812m_m_
moas65545342moas
mobs85737372mobs
mocs85834902mocs
mods77945052mods
mogs75439332mogs
mols65948572mols
mom78853162mom_
mome85239352mome
momes95134472momes
momi87524482momi
momus96116112momus
mons68152252mons
moos66051302moos
mops85940132mops
mors65950062mors
mos57067122m_os
moss67641032moss
mots66853162mots
moues75732842moues
mows96340832mows
mu46737482mu__
much115224032much
muck125727852muck
mucks134622642mucks
mucus94015742mucus
mud67336862mu_d
muff124723862muff
muffs134114212muffs
mug65837692mu_g
mugg86316012mugg
muggs94912322muggs
mule65236972mule
mules75034292mules
mull65128802mull
mulls75124152mulls
mummy114913622mummy
mun56143852mu_n
muni65824402muni
munis75022002munis
muon65722732muon
muons75816172muons
mura65633292mura
muras75329562muras
mure65941332mure
mures75937212mures
murk105527252murk
murks114821722murks
murr65225132murr
murrs75521292murrs
muse67136032muse
muses75134302muses
mush94929122mush
musk104526192musk
musks116119642musks
mussy104117642mussy
must65145442must
musts75527442musts
mut58357182mu_t
mute65136872mute
mutes75033782mutes
mutt65739402mutt
mutts75120252mutts
mycs115314292mycs
neums75414252neums
nims66226882nims
noms65636402noms
nubs65927142nubs
numb85520612numb
numbs94913092numbs
nuns45228232nuns
nus37939392nu_s
nuts45032672nuts
ohms95514032ohms
oms56337512_oms
ouds56430102ouds
ours47237562ours
outs45746962outs
pams85641762pams
plums94619952plums
poms87037742poms
pubs85029212pubs
puds75630512puds
pugs76332772pugs
puls65437562puls
puma85424122puma
pumas95121562pumas
pump105726852pump
pumps115520602pumps
puns66641482puns
pups86032232pups
purs65641042purs
pus55547842pu_s
puss64830132puss
puts65641752puts
rams65950772rams
rems66237722rems
rims65936302rims
roms67038962roms
rubs66133492rubs
rues46044482rues
rugs56033682rugs
rum56644642rum_
rump86729082rump
rumps95922292rumps
runs46438072runs
ruts44541492ruts
scums95017422scums
sims65737172sims
slums74623432slums
smuts75415712smuts
soms66239372soms
stums75320082stums
subs66037122subs
suds56135292suds
sues46247652sues
suks85927122suks
sum56346012sum_
sumo67326312sumo
sumos75720092sumos
sump86331532sump
sumps95023432sumps
suns45841902suns
sups64834432sups
suqs134319652suqs
suss45229302suss
tams67247932tams
toms68343492toms
tubs65430062tubs
tugs56231672tugs
tuis44829642tuis
tump85927032tump
tumps95420792tumps
tuns45138662tuns
tups65628762tups
tuts45838452tuts
um47338832_um_
umm711921262_umm
ump76130442_ump
umps85721942umps
uns35936752_uns
ups55629052_ups
us26937432_u_s
uts35534372_uts
vims95423312vims
vugs87022872vugs
vum85428652vum_
wuss75219332wuss
yams95330732yams
yuks116418022yuks
yum86132822yum_
yups96121602yups

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 Filter178691298720.406440125.6
2DLD Change Limit298723254.6566415.8
3Display Results3253250.656495.4
 (SQL Overall)1786913255.71831250.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.