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

421 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
mammon93964(None) 
gammon1138901gammon
mammons1048511mammons
ammo85520132_ammo_
ammono1047372_ammono
ammos94815822_ammos
camion103917192camion
common12310802common
daemon9279592daemon
daimon9259712daimon
damson938062damson
gammons1237972gammons
macon94519952ma_con
macron103615672macron
madman113712382madman
madmen113511742madmen
mambo115215742mambo_
mambos125414492mambos
mamma86317912mamm_a
mammae94613212mammae
mammal95112752mammal
mammas94616402mammas
mammee94417852mammee
mammer94218862mammer
mammet94319252mammet
mammey124310892mammey
mammie94313782mammie
mammock1664392mammock
mammoth1344982mammoth
mammy115215162mamm_y
marmot10318742marmot
maroon83118202maroon
marron83717542marron
mascon103612742mascon
mason74820182ma_son
matron83918312matron
psammon1342542psammon
ramson8310462ramson
salmon84614182salmon
summon1037622summon
tampon102911232tampon
aboon74918703_aboon
adman84517903_adman
admen84516183_admen
aeon45634613_a_eon
agon56531883_a_gon
almond91410433_almond
amain74922913_amain
amazon1736833amazon
ambo88225143_ambo_
ambos95321253_ambos
amen66733153_a_men
amin66042253_a_min
amino75425503_amino
ammine10314493_ammine
ammino1069883_ammino
ammonal1137023_ammonal
ammonia1148693_ammonia
ammonic1349163_ammonic
amnion84812053amnion
amok10217403_a_mok
among85813303_a_mong
ancon75718233_ancon
anion55028813_anion
anon46134853_a_non
anyon85615223_anyon
apron7318833_apron
argon65520593_argon
armor75118053_armor
arson55118833_arson
atman75520143_atman
avion84218343_avion
axion1211316913_axion
axman144813183_axman
axmen145112273_axmen
axon115524303_a_xon
azlon144312873_azlon
azon135725053_a_zon
baboon103613913baboon
bacon95620593ba_con
badman113813843badman
badmen114613833badmen
bagman114613813bagman
bagmen115412533bagmen
ballon84117493ballon
bamboo12310013bamboo
bammed133913243bammed
bamming144611813bamming
barman103519703barman
barmen105418533barmen
baron78131243ba_ron
baryon111211613baryon
basion84315853basion
batman105214063batman
batmen104414303batmen
baton75822423ba_ton
bayman133712703bayman
baymen134212003baymen
cabman123812503cabman
cabmen123610653cabmen
caiman103615663caiman
cajon144513903ca_jon
cameo95924993cameo_
cameos105818003cameos
camions113916133camions
cammie124615293cammie
camo85731753ca_mo_
camos95927613ca_mos
campion133011413campion
campo115219763campo_
campong14318123campong
campos125217953campos
cannon84514443cannon
canon74725303ca_non
canton85722993canton
canyon114512033canyon
capon95221873ca_pon
carbon104919043carbon
cardon94120853cardon
carman103920743carman
carmen104019343carmen
carton84522663carton
cation83925503cation
cayman133613213cayman
commons13311043commons
crampon1336943crampon
cummin1288783cummin
dacron94310693dacron
daemons10269233daemons
dahoon1039053dahoon
daikon11217243daikon
daimen92210573daimen
daimons10249323daimons
dalton7311273dalton
daman84821163da_man
dammar11438903dammar
dammed124214793dammed
dammer114317933dammer
damming133812743damming
dammit11311133dammit
damn75724323da_m_n
dampen114310593dampen
damsons1038013damsons
demon86520313_demon
dromon939363dromon
etymon1134693etymon
falcon11310293falcon
fanion94514323fanion
fanon84619013fa_non
gabion93211033gabion
gaboon93211773gaboon
gagman103811243gagman
gagmen103910413gagmen
gallon73715813gallon
gambol1138223gambol
gamin84423003ga_min
gamma106116103gamm_a
gammas115714693gammas
gammed124216163gammed
gammer1112318333gammer
gamming133112623gamming
gammoned1444993gammoned
gammoner1345153gammoner
gammy135514893gamm_y
garcon92912483garcon
garron73113493garron
gascon9339723gascon
gasman92911743gasman
gasmen93111563gasmen
gnomon936183gnomon
hadron102913753hadron
haemin113412663haemin
hagdon1188283hagdon
halon86124863ha_lon
hambone1439313hambone
hammal134512063hammal
hammam12419333hammam
hammed144116973hammed
hammer138120033hammer
hamming153014093hamming
hammock2064633hammock
hammy155113433hamm_y
harmin113117393harmin
harmony1538173harmony
haymow1773683haymow
hommos13128503hommos
jammed183811503jammed
jammer174014133jammer
jamming19329793jamming
jammy194810193jamm_y
jargon1448823jargon
jasmin1538073jasmin
jomon14610083_jomon
kampong16294933kampong
kamsin1238323kamsin
kaon87521023ka__on
kation104315683kation
ladron73413323ladron
lagoon7410483lagoon
lammed113915623lammed
lamming123014583lamming
lampion11278303lampion
lampoon11267193lampoon
lardon74415063lardon
lawman11289053lawman
lawmen11308593lawmen
layman113511303layman
laymen113010843laymen
lemon75618183_lemon
lummox1733053lummox
macho126120153macho_
machos135217493machos
macons104017243ma_cons
macro94718173macro_
macrons113514893macrons
macros104017013macros
madden103912523madden
madrona10288703madrona
madrone102812663madrone
madrono10288743madrono
madtom1138023madtom
madzoon1996063madzoon
maggot10311713maggot
magian9312833magian
magma104513573magm_a
magmas115512503magmas
magot8326393ma_got
mahjong2042273mahjong
mahoe10315573ma_hoe
mahzor2035113mahzor
maiden93512283maiden
mailman1137733mailman
mailmen1137273mailmen
maim85831493maim__
maimed114812663maimed
maimer104514593maimer
maiming122912723maiming
maims96321793maim_s
main65345523ma__in
major145212923ma_jor
makimono1641943makimono
mako105622363ma_ko_
makos116518363ma_kos
malign939853malign
malison939693malison
malkin122913153malkin
mallow114014743mallow
malm85129983malm__
malms95021553malm_s
malmy124816343malm_y
maltol8310843maltol
mama86231593ma_m_a
mamas95930773ma_mas
mamba116317523ma_mba
mambas125716243mambas
mamboed14417623mamboed
mamboes135011823mamboes
mamboing1535973mamboing
mamey125418833ma_mey
mameys13449523mameys
mamie95826003ma_mie
mamies104626243mamies
mamluk1434743mamluk
mammals10389273mammals
mammary1335993mammary
mammate104411273mammate
mammati10398373mammati
mammees104411143mammees
mammers104615693mammers
mammets103911113mammets
mammeys13376723mammeys
mammies104314763mammies
mammocks1763893mammocks
mammonism11144973mammonism
mammonist12227143mammonist
mammoths1442853mammoths
mamzer19459833mamzer
man57465873ma___n
mango85724333mango_
mangos94319343mangos
manioc103914823manioc
mannan85413623mannan
mano66536813ma_no_
manor78023933ma_nor
manos74933623ma_nos
mansion9611543mansion
margin94016853margin
marlin84220903marlin
marmots11311513marmots
maroons92615553maroons
marrons93216973marrons
marrow112812613marrow
marten84518263marten
martin84122523martin
mascons113411583mascons
mascot104016073mascot
masons83916513ma_sons
matin75132853ma_tin
matrons93517633matrons
mattin84416633mattin
matzo16312893matzo_
matzoh2035483matzoh
matzoon1896473matzoon
matzos1749263matzos
matzot17710983matzot
maumet103518883maumet
maun65727213ma__un
maven104816893ma_ven
mavin105722953ma_vin
mawn94424143ma__wn
maximin1835263maximin
mayan105616903ma_yan
mayo96524303ma_yo_
mayor106616623ma_yor
mayos105521933ma_yos
maypop1565143maypop
mayvin1436523mayvin
meatman1137903meatman
meatmen1138243meatmen
melon73922083m_elon
melton8311553melton
memo85924793m_emo_
memos95719113m_emos
merlon83012353merlon
merman10513863merman
mermen10813813mermen
meson74118313m_eson
micron103714283micron
mignon937953mignon
mikron12318503mikron
mimeo96018683mimeo_
mimeos104511543mimeos
minion83416243minion
momma85111053momm_a
mommas94110653mommas
mommy114010753momm_y
mon57561583___mon
moon67140813__moon
morion86217733morion
moron76925423m_oron
motion85217553motion
motmot10311073motmot
mouton8410853mouton
mumm75718863mumm__
mummed104411553mummed
mummer93614543mummer
mumming114010023mumming
mumms85513153mumm_s
mummy114913623mumm_y
muon65722733__muon
muton73817003m_uton
mutton8510453mutton
nasion63914083nasion
nation64322803nation
natron64116023natron
paeon74819493pa_eon
pardon94618733pardon
parson83817903parson
parton84720993parton
patron84018043patron
plasmon11257983plasmon
pompon1238943pompon
psammons1442783psammons
racon75422143ra_con
racoon83814473racoon
radon64620503ra_don
ragman94013713ragman
ragmen93712183ragmen
ramen75625193ra_men
rammed113117303rammed
rammer103519653rammer
ramming123115063ramming
rammy124312493ramm_y
ramona8412413ra_mona
rampion11298583rampion
ramrod936833ramrod
ramsons939563ramsons
ration64226013ration
ratoon64417373ratoon
ratton64116123ratton
rayon83815703ra_yon
saimin8313663saimin
salmons93713263salmons
salon55228553sa_lon
saloon64418023saloon
sambo95118013sambo_
sambos104315193sambos
sampan102511893sampan
scammony1743023scammony
sermon8413553sermon
shammos14307203shammos
simoon858063simoon
summons1158003summons
talion6317713talion
talon55824113ta_lon
tamein8313093tamein
tammie104212693tammie
tammy124013223tamm_y
tampan102512323tampan
tampion11298663tampion
tampons112711563tampons
tarpon82812803tarpon
tauon54816583ta_uon
taxman15328613taxman
taxmen15367443taxmen
taxon124414663ta_xon
vanman1139793vanman
vanmen1138403vanmen
wadmol1234053wadmol
waggon1136393waggon
wagon94312953wa_gon
wammus13426733wammus
wanion93213063wanion
wanton94413813wanton
whammo16405193whammo_
wimmin1336153wimmin
yamen104115183ya_men
yammer133713183yammer
yamun10419273ya_mun
yapon104613583ya_pon
yaupon11345493yaupon

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 Filter1786911127160.390458182.1
2DLD Change Limit1127164215.50020493.8
3Display Results4214210.1432944.1
 (SQL Overall)1786914216.03329618.9
 
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.