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

357 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
mammons104851(None) 
gammons1237971gammons
mammon939641mammon_
ammono1047372_ammono
ammos94815822_ammo_s
camions113916132camions
commons13311042commons
daemons10269232daemons
daimons10249322daimons
damsons1038012damsons
gammon1138902gammon_
macons104017242ma_cons
macrons113514892macrons
mamboes135011822mamboes
mambos125414492mambo_s
mammals10389272mammals
mammas94616402mamm_as
mammees104411142mammees
mammers104615692mammers
mammets103911112mammets
mammeys13376722mammeys
mammies104314762mammies
mammock1664392mammock
mammocks1763892mammocks
mammonism11144972mammonism
mammonist12227142mammonist
mammoth1344982mammoth
mammoths1442852mammoths
marmots11311512marmots
maroons92615552maroons
marrons93216972marrons
mascons113411582mascons
masons83916512ma_sons
matrons93517632matrons
psammons1442782psammons
ramsons939562ramsons
salmons93713252salmons
summons1158002summons
tampons112711552tampons
aeons57624653_a_eons
agons66423783_a_gons
almond91410433_almond
almonds10127953_almonds
amazons1836643amazons
ambones11312683_ambones
ambos95321243_ambo_s
amens75624843_a_mens
amins75534313_a_mins
ammine10314483_ammine
ammines11312673_ammines
ammino1069873_ammino
ammo85520133_ammo__
ammonal1137013_ammonal
ammonals1245393_ammonals
ammonia1148693_ammonia
ammonias1247943_ammonias
ammonic1349163_ammonic
amnions93710913amnions
amoks11413553_a_moks
among85813303_a_mong
anions64123033_anions
anyons94513503_anyons
aprons8316993_aprons
argons75018203_argons
armors85017813_armors
arsons63917213_arsons
atmans84413963_atmans
avions94114393_avions
awmous1157713_awmous
axions134713483_axions
axons125517933_a_xons
azlons154110423_azlons
azons146518253_a_zons
baboons113211073baboons
bacons104917583ba_cons
ballons93916953ballons
bamboos1348753bamboos
bamming144611813bamming
barons85025383ba_rons
baryons121010473baryons
basions94213953basions
batons85519423ba_tons
caimans113811783caimans
cameos105818003cameo_s
camion103917193camion_
cammies134016473cammies
camos95927613ca_mo_s
campions143511293campions
campong14318123campong
campongs15356123campongs
campos125217953campo_s
cannons94412883cannons
canons85522063ca_nons
cantons95221203cantons
canyons124511593canyons
capons104119503ca_pons
carbons115418943carbons
cardons104519933cardons
cartons94122473cartons
cations94524143cations
caymans14349513caymans
common12310803common_
crampons1436643crampons
cummins1358963cummins
dacrons103211033dacrons
daemon9279593daemon_
daemones11209163daemones
dahoons1137753dahoons
daikons12186693daikons
daimon9259713daimon_
daimones11208803daimones
daltons8310403daltons
damans94715983da_mans
dammars12308193dammars
dammers123214273dammers
damming133812743damming
damns84916923da_m_ns
dampens12348563dampens
damson938063damson_
demons94917723_demons
dromons1038193dromons
etymons1244153etymons
falcons1239123falcons
famous11412393fa_mous
fanions103713073fanions
fanons96115213fa_nons
gabions102410053gabions
gaboons10289893gaboons
gallons83015943gallons
gambols1238593gambols
gamins94420043ga_mins
gammas115714693gamm_as
gammers123214563gammers
gamming133112623gamming
gammoned1444993gammoned
gammoner1345153gammoner
gammoners1444563gammoners
garcons102411643garcons
garrons82713463garrons
gascons10289103gascons
gnomons1035753gnomons
gummous1236263gummous
hadrons113314303hadrons
haemins122811393haemins
hagdons1258523hagdons
halons95720713ha_lons
hambone1439313hambone
hambones1539673hambones
hammals14409213hammals
hammams13386433hammams
hammers144216053hammers
hamming153014093hamming
hammock2064633hammock
hammocks2164343hammocks
harmins123716713harmins
harmony1538173harmony
haymows1883813haymows
hommos13128503hommo_s
jammers183710703jammers
jammies183611293jammies
jamming19329793jamming
jargons1558203jargons
jasmins1637083jasmins
kampong16294933kampong
kampongs17293033kampongs
kamsins1346963kamsins
kaons95014853ka__ons
kations114013663kations
ladrons83813193ladrons
lagoons839253lagoons
lamming123014583lamming
lampions12277973lampions
lampoons12266863lampoons
lardons83914493lardons
lemons84415053_lemons
machos135217493macho_s
macon94519953ma_con_
macron103615673macron_
macros104017013macro_s
maddens11359753maddens
madman113712383madman_
madmen113511743madmen_
madrona10288703madrona
madronas11288493madronas
madrone102812663madrone
madrones112912283madrones
madrono10288743madrono
madronos11337543madronos
madtoms1236923madtoms
madzoons20124773madzoons
maggots1136553maggots
magians10310753magians
magmas115512503magm_as
magots9312363ma_gots
mahjong2042273mahjong
mahjongs2141813mahjongs
mahoes11313103ma_hoes
mahzors2135123mahzors
maidens10349663maidens
maimers113813043maimers
maiming122912723maiming
maims96321783maim__s
mains75635093ma__ins
majors154511093ma_jors
makimono1641943makimono
makimonos1741653makimonos
makos116518363ma_ko_s
maligns1038133maligns
malisons1048773malisons
malkins133311803malkins
mallows123714323mallows
malms95021553malm__s
maltols939403maltols
mamas95930773ma_m_as
mambas125716243ma_mbas
mambo115215733mambo__
mamboed14417623mamboed
mamboing1535973mamboing
mameyes14376983mameyes
mameys13449523ma_meys
mamies104626243ma_mies
mamluks1543313mamluks
mamma86317913mamm__a
mammae94613213mamm_ae
mammal95112753mamm_al
mammary1335993mammary
mammate104411273mammate
mammati10398373mammati
mammatus1144233mammatus
mammee94417853mamm_ee
mammer94218863mamm_er
mammet94319253mamm_et
mammey124310893mamm_ey
mammie94313783mamm_ie
mammitis1145593mammitis
mammonisms1254223mammonisms
mammonists13144653mammonists
mammy115215163mamm__y
mamzers20409163mamzers
mangoes104316133mangoes
mangos94319333mango_s
maniocs113611443maniocs
mannans93611523mannans
manors84420883ma_nors
manos74933613ma_no_s
mans66354533ma___ns
mansions1069793mansions
margins103815193margins
marlins93420473marlins
marmot10318743marmo_t
maroon83118203maroon_
marron83717543marron_
marrows122911813marrows
martens93714953martens
martins93322063martins
mascon103612743mascon_
mascots113910343mascots
mason74820183ma_son_
matins84527783ma_tins
matron83918313matron_
mattins93316143mattins
matzohs2134373matzohs
matzoons19105083matzoons
matzos1749263matzo_s
maumets11369693maumets
mavens114312973ma_vens
mavins115119183ma_vins
maximins1944533maximins
mayors115714193ma_yors
mayos105521933ma_yo_s
maypops16104453maypops
mayvins1535323mayvins
melons84117713m_elons
meltons9410923meltons
memos95719113m_emo_s
merlons93311273merlons
mesons83215843m_esons
microns113814783microns
mignons1037863mignons
mikrons13428413mikrons
mimeos104511543mimeo_s
minions93314623minions
mommas94110653momm_as
mommies103912273mommies
mons68152253___mons
moons75331003__moons
morions94014633morions
morons84919543m_orons
motions94215003motions
motmots1166133motmots
moutons9410313moutons
mummers103712843mummers
mummies103812843mummies
mumming114010023mumming
mumms85513153mumm__s
muons75816173__muons
mutons84314363m_utons
muttons949283muttons
nasions73112383nasions
nations74720563nations
natrons73215663natrons
oakmoss1342533oakmoss
paeons83915523pa_eons
pardons103817623pardons
parsons93516873parsons
partons94620513partons
patrons93818103patrons
plasmons12217663plasmons
pompons1338553pompons
psammon1342543psammon_
racons84319343ra_cons
racoons93912433racoons
radons74118523ra_dons
rammers113715043rammers
ramming123115063ramming
ramona8412413ra_mona
ramonas9311093ra_monas
ramous8417103ra_mous
rampions12248023rampions
ramrods1036583ramrods
ramson8310463ramson_
rations74123433rations
ratoons73815473ratoons
rattons73815323rattons
rayons94113343ra_yons
saimins9312113saimins
salmon84614183salmon_
salons63823683sa_lons
saloons74415303saloons
sambos104315193sambo_s
sampans112411003sampans
scammony1743023scammony
sermons9311783sermons
shammos14307203shammo_s
simoons937933simoons
summon1037623summon_
talions7314093talions
talons64019423ta_lons
tameins9311413tameins
tammies113814683tammies
tampans113310983tampans
tampions12358113tampions
tampon102911233tampon_
tarpons92612203tarpons
tauons63412673ta_uons
taxons134211503ta_xons
wadmols1333913wadmols
waggons1235503waggons
wagons103911213wa_gons
wammus13426733wamm_us
wanions104011373wanions
wantons103713013wantons
yamens114010823ya_mens
yammers143410323yammers
yamuns11336513ya_muns
yapons114411773ya_pons
yaupons12345683yaupons

Search took 7 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 Limit1340273576.62620227.4
3Display Results3573570.1232902.4
 (SQL Overall)1786913576.90525878.5
 
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.