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

365 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
marmots1131151(None) 
marmot10318741marmot_
argots74116032_argots
armets84918352_armets
armors85017812_armors
carrots9714622carrots
harlots103413292harlots
maggots1136562maggots
magots9312362ma_gots
mammets103911112mammets
mammons1048512mammons
mammoth1344982mammoth
mammoths1442852mammoths
markets133314032markets
marmite112413992marmite
marmites122212792marmites
marmosets1344832marmosets
maroons92615552maroons
marplots1245632marplots
marrons93216972marrons
marrows122911822marrows
marts77442232mar__ts
mascots113910342mascots
maumets11369692maumets
merlots92710122merlots
motmots1166132motmots
parrots9312742parrots
tarots66422992tar_ots
abbots1039283_abbots
admits9411413_admits
allots64019173_allots
almost81014433_almost
ammos94815823_ammo_s
amoks11413553_a_moks
arbors84717883_arbors
ardors74416873_ardors
argols74514613_argols
argons75018203_argons
argot67728653_argot_
arhats9312973_arhats
armers85520273_armers
armet76739453_armet_
armies85123693_armies
armlets94610063_armlets
armor75118053_armo_r
armory114211473_armory
armour84411853_armour
armours9389853_armours
armpits1157133_armpits
arms66137493_arm__s
aromas81018613_aromas
arrows92813483_arrows
arsons63917213_arsons
arts49650263_ar__ts
arvos86015663_arvo_s
ascots85312513_ascots
awmous1157713_awmous
ballots94116033ballots
barbets114915843barbets
barbuts11439843barbuts
barhops14288113barhops
barlows12259973barlows
barms96128463barm__s
barons85025383bar_ons
barrets94917103barrets
barrows123411683barrows
baryons121010473baryons
burbots1168673burbots
cahoots1238473cahoots
camos95927613ca_mo_s
carats85929023car_ats
carbons115418943carbons
carbos105122263carbo_s
carboys144711783carboys
cardons104519933cardons
carets85330773car_ets
cargoes104415223cargoes
cargos94619183cargo_s
carhops14329703carhops
carious93320283carious
carnets93918403carnets
carobs104818103car_obs
carols85124983car_ols
caroms105619573car_oms
carpets113915333carpets
carports1238943carports
carroms11512403carroms
carrot8423123carrot_
carroty1248943carroty
cartons94122473cartons
carts78946293car__ts
cermets1139713cermets
chariots1339393chariots
cormous11312353cormous
daemons10269233daemons
daimons10249323daimons
darts67635733dar__ts
earshots1146623earshots
enroots738713enroots
ergots74512373_ergots
faggots1234863faggots
fagots1039963fa_gots
famous11412393fa_mous
farmers124315263farmers
farms106324953farm__s
faros85532023far_o_s
farrows13259783farrows
farts88336843far__ts
formats123113573formats
formols12299413formols
galiots82311323galiots
galoots82410793galoots
gammons1237973gammons
gamuts958783ga_muts
garcons102411643garcons
gargets94614573gargets
garments1139963garments
garnets84115403garnets
garote7717953gar_ote
garotes8614563gar_otes
garrets84413623garrets
garrons82713463garrons
garrote8510103garrote
garrotes969363garrotes
gavots1038113ga_vots
gemots93712153_gemots
griots74713643_griots
grots65025853_gr_ots
harbors12412413harbors
haricots1347333haricots
harlot94422803harlot_
harmers124116593harmers
harmins123716723harmins
harmony1538173harmony
harms106829013harm__s
harrows132611033harrows
harts88441593har__ts
haymows1883813haymows
hazmats2136603hazmats
heriots10312063heriots
hermits12312143hermits
imarets9138643imar_ets
jabots1538883ja_bots
jargons1558203jargons
karats106420493kar_ats
karmas123013733karm_as
karoos102415803kar_oos
kaross101910013kar_oss
karroos1139313karroos
karsts106012943kar_sts
karts97630113kar__ts
lardons83914493lardons
largos74815063largo_s
lariats7615053lariats
machos135217493macho_s
macons104017243ma_cons
macrons113514893macrons
macros104017013macro_s
madtoms1236923madtoms
madworts1456173madworts
maggot10311713maggot_
maggoty1444013maggoty
magmas115512503magm_as
magmata1237463magmata
magnets10311143magnets
magot8326393ma_got_
mahoes11313103ma_hoes
mahouts1237143mahouts
mahzors2135123mahzors
maillots1037473maillots
maimers113813043maimers
maims96321793maim__s
maists85817573ma_ists
majors154511093ma_jors
makos116518363ma_ko_s
mallets93318493mallets
mallows123714323mallows
malms95021553malm__s
maloti8313213ma_loti
maltols939403maltols
malts76331753ma__lts
mamas95930773ma_m_as
mambas125716243ma_mbas
mamboes135011823mamboes
mambos125414493ma_mbos
mameys13449523ma_meys
mamies104626243ma_mies
mammals10389273mammals
mammas94616403ma_mmas
mammate104411273mammate
mammati10398373mammati
mammatus1144233mammatus
mammees104411143mammees
mammers104615693mammers
mammet94319253mammet_
mammeys13376723mammeys
mammies104314763mammies
mammitis1145593mammitis
mammock1664393mammock
mammocks1763893mammocks
mammon939643mammo_n
manats84623463ma_nats
mangoes104316133mangoes
mangos94319333mango_s
manihots13126443manihots
maniocs113611443maniocs
manitos9314053manitos
manors84420883ma_nors
manos74933623ma_no_s
manumits1246003manumits
marabous1249063marabous
marabouts1364963marabouts
maracas11313773maracas
maranta9311693maranta
marantas10310023marantas
maras75443283mar__as
marauds1037553marauds
marbles114516653marbles
marcato1139743marcato
marcatos1249163marcatos
marcels113212373marcels
marches143921173marches
marcs95726623mar__cs
mares76457633mar__es
margays1337493margays
margents11410133margents
marges94525713mar_ges
margins103815193margins
marimbas1444363marimbas
marinas93519383marinas
marines93928013marines
markas124717003mar_kas
markers133516103markers
market123226043market_
markhors1745393markhors
markkas12356083markkas
marks115933483mar__ks
markups1534963markups
marlins93420473marlins
marlite92917073marlite
marlites103415263marlites
marls75535163mar__ls
marmoset12411983marmoset
maroon83118203mar_oon
marplot1149673marplot_
marques182610863marques
marquis18247063marquis
marrams11310123marrams
marrers93414313marrers
marries93825283marries
marron83717543marro_n
marrow112812603marro_w
marrowy15236083marrowy
mars66261873mar___s
marses84827113mar_ses
marshes123615373marshes
mart66865983mar__t_
martens93714953martens
martins93322063martins
martlets103310483martlets
martyrs1234893martyrs
marvels123810093marvels
mascons113411583mascons
mascot104016073mascot_
masons83916513ma_sons
masts77035763ma__sts
matelots1047533matelots
matrons93517633matrons
mats65460293ma___ts
matts76829183ma__tts
matzohs2134373matzohs
matzos1749263matzo_s
matzot17710983matzot_
matzoth2144333matzoth
maumet103518883maumet_
mauts75927193ma__uts
mayors115714193ma_yors
mayos105521933ma_yo_s
maypops16104453maypops
memos95719113m_emo_s
merits8320873mer_its
merlons93311273merlons
merlot83217603merlot_
midmost1246153midmost
midmosts1343773midmosts
mirrors938623mirrors
moots75831663m__oots
morions94014643morions
morons84919543mor_ons
morros83714673morro_s
morrows12318723morrows
morts75533563mor__ts
motmot10311073motmot_
mots66853163___mots
murmurs1134523murmurs
narcos86714203narco_s
narrows10258843narrows
oakmoss1342533oakmoss
paramos113213513paramo_s
pardons103817623pardons
parents93418123parents
pareos87023773pareo_s
pargets105215193pargets
pargos95719043pargo_s
parlors9312913parlors
parlous9414293parlous
parols84722613par_ols
parous84024163par_ous
parrot8320663parrot_
parroty1247863parroty
parsons93516873parsons
partons94620513partons
parts77743373par__ts
parvos116614753parvo_s
patriots1038053patriots
permits11314003permits
ramets83517393ra_mets
ramous8417113ra_mous
ramrods1036583ramrods
rearmost1047263rearmost
riots54922013__riots
roots55933673__roots
rots46454093__r_ots
ryots85313783__ryots
sabots8314703sa_bots
salmons93713263salmons
sarcous9312933sarcous
sargos74318273sargo_s
sarments10311963sarments
sarods74918573sar_ods
saros55238063sar_o_s
sartors7314963sartors
sermons9311783sermons
smarms105712533smarm__s
smarts86218003smar__ts
taproots1047253taproots
targets84314223targets
tarmacs1138323tarmacs
tarocs84615663tar_ocs
taroks106115283tar_oks
taros55640823tar_o_s
tarot55943933tar_ot_
tarpons92612213tarpons
tarts57242023tar__ts
termors94712773termors
trots56629943_tr_ots
turbots988023turbots
unroots738563unroots
uproots937143uproots
various103113103various
varlets10411573varlets
varments1339063varments
varmints1335643varmints
varooms1248883varooms
wadmols1333913wadmols
warmers124514293warmers
warmest123113033warmest
warmouth1644143warmouth
warmouths1742853warmouths
warms107726853warm__s
warmth1477933warm_th
warmths1583783warmths
warmups1433813warmups
warts814840403war__ts
yarrows13277853yarrows

Search took 9 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.1561145455.1
2DLD Change Limit1340273658.67315453.4
3Display Results3653650.1232967.5
 (SQL Overall)1786913658.95219961.0
 
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.