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

338 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
muses7513430(None) 
amuses85117941amuses
buses75936011buses
fuses85628421fuses
mises74740561mises
mouses85531421mouses
mules75034291mules
mures75937211mures
muse67136031muse_
mused85524581mused
muser76024121muser
musers84719091musers
mushes114124561mushes
musks116119641musks
muss64933761mus_s
musses84624781musses
musts75527441musts
mutes75033781mutes
puses75532201puses
ruses56136581ruses
uses44931111_uses
abuses85119102abuses
amuse75920832amuse_
amused94412512amused
amuser84712622amuser
amusers94610192amusers
anuses66218772anuses
apses76823912apses
arses55733872arses
asses55629282asses
aures55137092aures
bases75644352bases
bemuses1139292bemuses
beses75830722beses
bises75435622bises
bouses84931782bouses
burses84425512burses
bused85624492bused
bushes115226112bushes
busies85525262busies
busks115521372busks
buss65134912bus_s
busses85023382busses
busts75227692busts
butes714535872butes
cases75048382cases
causes88026472causes
coses76949492coses
cruses88127712cruses
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
cures75645432cures
curses85328272curses
cusec94614902cusec
cusecs10509152cusecs
cusks114916052cusks
cusps94913672cusps
cuss65430612cus_s
cusses84522772cusses
cutes79438312cutes
doses65938502doses
douses74928932douses
druses75517252druses
duces86327472duces
dudes75424372dudes
dues56045502du_es
dukes105023472dukes
dulses73913652dulses
dunes65332172dunes
dupes86425932dupes
dures65635922dures
dusks105317252dusks
dusts65923562dusts
eases56041612eases
emeses86114962emeses
erses55826802erses
eses45336102_eses
esses56422972esses
fumes105224702fumes
fuse76429992fuse_
fused94820442fused
fusee86224582fusee
fusees95416402fusees
fusel85218492fusel
fusels94412452fusels
fuss76027932fus_s
fusses94920552fusses
fuzes175120222fuzes
gases65633992gases
gudes74520812gudes
guess64213362guess
guises74216312guises
gules64831042gules
gushes104719032gushes
gusts65722792gusts
hoses85443172hoses
houses96032272houses
hues75235232hu_es
humuses1237592humuses
hushes124718592hushes
husks125015452husks
jubes145420742jubes
jukes165319102jukes
jupes145218552jupes
justs124918262justs
jutes125125132jutes
kues86426772ku_es
lases54944762lases
leses54930812leses
loses56742012loses
louses66230282louses
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunes55337772lunes
lures56138532lures
lushes94022742lushes
lusts55022802lusts
lusus54813872lusus
lutes55836662lutes
luxes124921502luxes
lyses84518252lyses
mabes96331532mabes
maces97139962maces
maes66948392m_aes
mages85036022mages
makes115336852makes
males75049792males
manes76648952manes
manses84225512manses
mares76457632mares
marses84827112marses
masas75630412masas
maser75029972maser
masers84623452masers
mashes115030002mashes
masks115320532masks
mass66044932mas_s
masse75125292masse
masses85028712masses
masts77035762masts
mates75251362mates
mauves113811552mauves
maxes145629532maxes
mazes165632172mazes
memes94927702memes
menses84222452menses
meres75143572meres
mesas76823202mesas
meshes115019442meshes
mesnes85216212mesnes
mess65932432mes_s
messes84924342messes
metes74736212metes
mezes167719262mezes
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
minuses93512702minuses
mioses84318852mioses
mires75640882mires
mise66043572mise_
miser75430402miser
misers85025702misers
misos76523292misos
miss65339412mis_s
misses85130872misses
mists76633902mists
misuses93216022misuses
mites75141802mites
mixes147224402mixes
modes85537412modes
mokes114631032mokes
moles74747922moles
momes95134472momes
momuses1159262momuses
mopes95134982mopes
mores76249642mores
mosey105922872mosey
moseys114711702moseys
moshes115222872moshes
mosks116117002mosks
moss67641032mos_s
mosses85527682mosses
mosts76028542mosts
motes75944002motes
moues75732842moues
mouse77133002mouse_
moused94423302moused
mouser85822442mouser
mousers95216442mousers
mousey115216192mousey
mousse84813032mousse
mousses94012702mousses
moves106128422moves
muches134718992muches
mucks134622642mucks
mucus94015742mucus
mucuses11148512mucuses
muds75530652mu_ds
muffs134114212muffs
muggs94912322muggs
mugs76232042mu_gs
mule65236972mule_
muled85824432muled
muley104819282muley
muleys11409642muleys
mulls75124152mulls
mumms85513152mumms
mumps115619102mumps
mums85732772mu_ms
mumus95517282mumus
munis75022002munis
muns65535912mu_ns
muons75816172muons
muras75329562muras
mure65941332mure_
mured85726702mured
murex145517172murex
murks114821722murks
murres85019042murres
murrs75521292murrs
mus55946752mu__s
musca9311762musca
muscles11310562muscles
museum1037702museum
museums1134562museums
mush94929122mus_h
mushed124420842mushed
musher113820572musher
mushers124016432mushers
mushy135316632mushy
music94316402music
musics103911782musics
musk104526192mus_k
muskeg13338182muskeg
muskegs14285002muskegs
musket122818202musket
muskets13258632muskets
muskies133614662muskies
musky144715292musky
mussed94418902mussed
mussel83412902mussel
mussels9419842mussels
mussy104117642mussy
must65145442mus_t
musted93321072musted
mustee83922102mustee
mustees94614922mustees
muster84724522muster
musters94522492musters
musth105314782musth
musths11589482musths
musty105620952musty
mutases92012042mutases
mute65136872mute_
muted85023382muted
muter74525542muter
mutest84218052mutest
muts64839982mu_ts
mutts75120252mutts
myases113711552myases
myoses114013842myoses
noses55435642noses
nouses64627162nouses
nudes64723292nudes
nukes95418122nukes
nurses63919352nurses
oases55330982oases
onuses65616252onuses
opuses84012242opuses
oses46641512_oses
ousel55222402ousel
ousels64815272ousels
ousts55225702ousts
pases75346502pases
pauses84621472pauses
pluses83618072pluses
poses74642762poses
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
pulses83818662pulses
purses84826372purses
pushes114621662pushes
puss64830132pus_s
pusses84322842pusses
rases55447212rases
reuses66025522reuses
rhuses94911792rhuses
rises55244042rises
roses56445772roses
rouses65436282rouses
rubes74928412rubes
rues46044482ru_es
rules55234252rules
runes55530222runes
ruse45938932ruse_
rushes94724362rushes
rusks95816192rusks
rusts55026992rusts
sises55233832sises
smushes123710092smushes
souses64229242souses
sudses74114502sudses
sues46247652su_es
supes75628302supes
suss45229302sus_s
susses64221052susses
tmeses85712242tmeses
touses64229672touses
tubes74826452tubes
tules54532792tules
tunes55332192tunes
tushes94319472tushes
tusks94915532tusks
tusses64921242tusses
tuxes124316042tuxes
ukes86122812_ukes
uruses63616502uruses
use36835162_use_
used55722822_used
user45023002_user
users55817572_users
utes45930882_utes
vases84626262vases
vises84427772vises
wamuses1237022wamuses
wises85633192wises
wuss75219332wus_s
wusses93314892wusses
yeses85119322yeses
yules84521582yules

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538003381.79629955.5
3Display Results3383380.0933634.4
 (SQL Overall)1786913381.98290156.9
 
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.