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

330 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
muttons94928(None) 
buttons9310331buttons
mutons84314361mu_tons
mutton8510451mutton_
muttony1235321muttony
burtons9310852burtons
button8310272button_
buttony1236172buttony
cottons9312192cottons
futons93911512fu_tons
gluttons944272gluttons
jettons1437272jettons
matrons93517632matrons
mattins93316142mattins
meltons9410922meltons
mittens9349882mittens
motions94215002motions
mottoes93412192mottoes
mottos84615242motto_s
moutons9410312moutons
muntins92715132muntins
muons75816172mu__ons
mutations111211452mutations
muton73817002mu_ton_
mutters94117142mutters
mutts75120252mutt__s
putons83515152pu_tons
rattons73815322rattons
actions94218513actions
amotions1069843amotions
attorns738443_attorns
auctions104012143auctions
authors10311853authors
autos56523323au_to_s
autumns943763autumns
batons85519423_batons
battens95313263battens
betons84919553_betons
bettors93312473bettors
bostons9312903bostons
bottoms1136993bottoms
boutons9310783boutons
bunions92210473bunions
burton8311273burton_
buteos84913413buteo_s
buttals938503buttals
butters94521723butters
buttes84822563butt_es
butties93217953butties
butting103519283butting
buttock1545563buttock
buttocks1645233buttocks
buttoned1137503buttoned
buttoner1036973buttoner
buttoners1145703buttoners
butts75824253butt__s
cantons95221203cantons
cartons94122473cartons
cations94524143cations
cautions103313183cautions
chitons122611913chitons
citrons92913223citrons
cotton8312993cotton_
cottony1237253cottony
cratons94316033cratons
crotons93714373crotons
customs11348263customs
custos84014313custo_s
cutdowns1443343cutdowns
cutins83919983cu_tins
cutters94218963cutters
cutties93118843cutties
cutting103817493cutting
cuttings11277613cuttings
cuttles93613923cuttles
cytons111710183_cytons
daltons8310403daltons
dattos74311903datto_s
dittos74111973ditto_s
duotone836893duotone
duotones937643duotones
durions839963durions
duteous838453duteous
elutions82513053elutions
emotions10610283emotions
fattens105111713fattens
fusions1039153fusions
futon83113773fu_ton_
futtock1644153futtock
futtocks1743833futtocks
glutton844893glutton_
gluttony1242513gluttony
guenons836563guenons
guidons936623guidons
gustoes879873gustoes
gutters83715513gutters
gutting93415923gutting
guttles83011933guttles
hutting113016033hutting
introns73515023introns
jetons134512613_jetons
jetton1338033jetton_
juntos134110843junto_s
jupons15377803ju_pons
jutties143814003jutties
jutting153313713jutting
kations114013663kations
kittens11347583kittens
lattens75014673lattens
lattins74115483lattins
leptons91910413leptons
lotions74614763lotions
lottos64613103lotto_s
luteins7310103luteins
luteous739273luteous
macons104017243m_acons
macrons113514893macrons
madtoms1236923madtoms
maltols939403maltols
mammons1048513mammons
maroons92615553maroons
marrons93216973marrons
martens93714953martens
martins93322063martins
mascons113411583mascons
masons83916513m_asons
matins84527783m_atins
matron83918313matron_
matters94421753matters
mattes85624533matt_es
mattin84416633mattin_
matting103620143matting
mattings11369673mattings
mattock1535823mattock
mattocks1644983mattocks
mattoid1079283mattoid
mattoids1196183mattoids
matts76829183matt__s
matzohs2134373matzohs
matzoons19105083matzoons
matzos1749263matzo_s
megatons11279703megatons
melons84117713m_elons
melton8311553melton_
mentions10312893mentions
mentors9314993mentors
merlons93311273merlons
mesons83215843m_esons
meteors94610013meteors
methods1338883methods
metols84115773m_etols
metopons12107023metopons
metros84217803metro_s
mettles94115023mettles
microns113814783microns
midtowns1443243midtowns
mignons1037863mignons
mikrons13428413mikrons
minions93314623minions
misbuttons1452113misbuttons
mitten83914093mitten_
mitts75523753mitt__s
mons68152253m___ons
moons75331003m__oons
morions94014643morions
morons84919543m_orons
motion85217553motion_
motmots1166133motmots
motors84616603m_otors
mottes85523693mott_es
mottles93415803mottles
motto76119513motto__
motts76527003mott__s
mouflons13133653mouflons
mouton8410853mouton_
mucins102712513mu_cins
mucors104410853mu_cors
mucous104411653mu_cous
mucrones1237603mucrones
mudhens1335103mudhens
mudstone1145553mudstone
mudstones1245033mudstones
muffins15308343muffins
muftis1158053muft_is
muggins11248073muggins
muktuks1242253muktuks
mulattoes1142883mulattoes
mulattos1044083mulatto_s
mullens93611313mullens
mullions101910353mullions
multiton1087343multiton_
multitone1187763multitone
multitones1277363multitones
mungoes103510463mungoes
mungos94311373mungo_s
munitions1138173munitions
munnions1035273munnions
muns65535913mu___ns
muntin82915183muntin_
munting103718773munting
muntings11289813muntings
muon65722733mu__on_
mureins9310733mureins
muslins9312213muslins
mustang10267933mustang
mustangs11255973mustangs
mustees94614923mustees
musters94522513musters
musths11589483must_hs
musting103221073musting
musts75527443must__s
mutagens1144853mutagens
mutant8317693mu_tant
mutants938583mutants
mutases92012043mutases
mutates92215793mutates
mutating112211753mutating
mutation101412883mutation_
mutches143314283mutches
mutes75033783mu_t_es
muticous1246933muticous
mutine84420373mu_tine
mutines93117823mutines
muting93921523mu_ting
mutinous1047653mutinous
mutiny113612683mu_tiny
mutisms11338453mutisms
muts64839983mu_t__s
mutt65739403mutt___
mutter84418883mutt_er
muttonfish1851503muttonfish
mutuals937123mutuals
mutuels935943mutuels
mutules9311843mutules
mythos14398463mytho_s
nations74720563nations
natrons73215663natrons
nektons1136393nektons
neustons836833neustons
neutrons838293neutrons
newtons1036813newtons
nitons64614903_nitons
notions74014483notions
nutations91411763nutations
nutters74215433nutters
nutting83316233nutting
nuttings9276783nuttings
options93810603options
ottos54714323_otto_s
outdoes8313123outdoes
outdone8311643outdone
outgoes8312643outgoes
outgone8311463outgone
outguns8318693outguns
outmans92413283outmans
outrows10311403outrows
outruns72911543outruns
outsins73417863outsins
outtold8107603outtold
outtrots838373outtrots
outturns835913outturns
partons94620513partons
patrons93818103patrons
pattens95414923pattens
photons123814423photons
phytons15319063phytons
pistons93016373pistons
pitons85319043_pitons
plutons938343plutons
pontons93315553pontons
potions93417423potions
pottos84615873potto_s
protons93118003protons
puntos85915793punto_s
putdowns1443523putdowns
putlogs1065083putlogs
puton73617913pu_ton_
puttees93612913puttees
putters94219193putters
putties94420023putties
putting103218573putting
putto75617663putto__
putts75719273putt__s
pythons1537363pythons
quittors17155413quittors
rations74123433rations
ratoons73815473ratoons
rattans73411953rattans
rattens74213403rattens
ratton64116123ratton_
rattoons8327513rattoons
rebuttons1143503rebuttons
rhytons13295883rhytons
ructions102811683ructions
rutins63818393ru_tins
rutting82718043rutting
setons64620173_setons
sextons143710413sextons
smutting11278063smutting
subtone9310343subtone
subtones10311383subtones
suctions103012903suctions
suitors73012493suitors
sultans72411833sultans
summons1158003summons
suntans72111733suntans
suttas63813793sutt_as
suttees74114063suttees
tattoos738643tattoos
testons7313553testons
tons46553053___tons
toons55027533__toons
tritons73814883tritons
tuitions838283tuitions
turions7311573turions
turnons737863turnons
tutors6912333tu_tors
tutties73216473tutties
tutting83515913tutting
tuttis63611373tutt_is
udons65411463_u_dons
unbuttons1142133unbuttons
unions64216753_unions
uptoss836093_uptoss
uptowns12194343_uptowns
utters63817123_utters
wantons103713013wantons
wittols1035733wittols
wontons103310533wontons
yupons11398353yu_pons

Search took 8 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 Filter1786911340270.1431249587.4
2DLD Change Limit1340273307.40318104.4
3Display Results3303300.1103000.0
 (SQL Overall)1786913307.65623340.0
 
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.