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

425 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
mammae9461321(None) 
mamma86317911mamma_
mammal95112751mammal
mammas94616401mammas
mammate104411271mammate
mammee94417851mammee
mammie94313781mammie
cammie124615292cammie
dammar11438902dammar
gamma106116102gamma_
gammas115714692gammas
gemmae11507792gemmae
hammal134512062hammal
hammam12419332hammam
lamiae84817452lamiae
madame1139852madame
madman113712382madman
magma104513572magma_
magmas115512502magmas
mama86231592ma_ma_
mamas95930772ma_mas
mamba116317522mamba_
mambas125716242mambas
mamie95826002ma_mie
mammals10389272mammals
mammary1335992mammary
mammati10398372mammati
mammees104411142mammees
mammer94218862mammer
mammet94319252mammet
mammey124310892mammey
mammies104314762mammies
mammon939642mammon
mammy115215162mamm_y
manmade1237962manmade
momma85111052momma_
mommas94110652mommas
summae103911012summae
tammie104212692tammie
acme86924323_acm_e
adman84517903_adman
agma77623263_agma_
agmas85919873_agmas
alae45643753_a_lae
algae65319623_algae
alma66333023_alma_
almah106917253_almah
almas76629773_almas
alme65832163_alm_e
ama510853303_a_ma_
amah98927493_a_mah
amas67746293_a_mas
amaze166016603_amaze
ambage11510603_ambage
amble95924643_amble
amebae1049633amebae
amia66836903_amia_
amias75831473_amias
amice96122873_amice
amide86128483_amide
amie66339853_a_mie
amine75835383_amine
ammine10314493ammine
ammo85520133_amm_o
ammos94815823_ammos
amole75724593_amole
ample94720303_ample
amuse75920833_amuse
ansae55720973_ansae
antae56828293_antae
aquae142212713_aquae
arame75026623_arame
areae55229743_areae
atma68121773_atma_
atman75520143_atman
atmas75721013_atmas
aurae54128113_aurae
axman144813183_axman
baccae12119703baccae
badman113813843badman
bagman114613813bagman
bammed133913243bammed
barman103519703barman
barmie103816393barmie
batman105214063batman
bayman133712703bayman
cabman123812503cabman
caiman103615663caiman
camas96333523ca_mas
came87648753ca_m_e
camerae11312063camerae
camise103319633camise
cammies134016483cammies
carman103920743carman
cayman133613213cayman
comae97128423_comae
comma114514793comma_
commas124814573commas
commie124215523commie
cymae126713013_cymae
damage10410773damage
daman84821163da_man
damar84117733da_mar
dame77140313da_m_e
dammars12308193dammars
dammed124214793dammed
dammer114317933dammer
dammit11311133dammit
daymare1375633daymare
faciae112913413faciae
fame95639393fa_m_e
famine114318193famine
faunae95210373faunae
femme125011433femm_e
gagman103811243gagman
galeae74717453galeae
gama77035523ga_ma_
gamas85431363ga_mas
gamay116419113ga_may
gamba106018513gamba_
gambade1336383gambade
gambas115817513gambas
gambe106219213ga_mbe
gamble115417183gamble
game76644323ga_m_e
gamete9313593gamete
gamine94620153gamine
gammed124216163gammed
gammer1112318333gammer
gammier123711193gammier
gammon1138903gammon
gammy135514893gamm_y
gasman92911743gasman
gemma106311773gemma_
gemmate12418383gemmate
gimmal11247513gimmal
gimme102411343gimm_e
gimmie11298183gimmie
gramma11499803gramma_
grammar12406893grammar
grammas12499773grammas
gramme114210333gramm_e
gumma105313103gumma_
gummas114810513gummas
haemal113811643haemal
halma108219253halma_
halmas117017893halmas
hamal104623113ha_mal
hamate113319833hamate
hame97043133ha_m_e
hammada1545093hammada
hammals14409223hammals
hammams13386443hammams
hammed144116973hammed
hammer138120033hammer
hammier143510653hammier
hammy155113433hamm_y
hamza19139773hamza_
hamzah23135563hamzah
hamzas20119013hamzas
hazmat20312263hazmat
hermae115314473hermae
imamate1138103imamate
immane1038883_immane
jambe165314753ja_mbe
jammable2144513jammable
jammed183811503jammed
jammer174014133jammer
jammier18408023jammier
jammies183611293jammies
jammy194810193jamm_y
jimmie17376473jimmie
kame105728233ka_m_e
karma113415003karma_
karmas123013733karmas
lama66635293la_ma_
lamas75532793la_mas
lambie103213673lambie
lame66849293la_m_e
lamia75324323lamia_
lamias85020613lamias
laminae93512973laminae
lammed113915623lammed
lampad114510033lampad
lampas106615953lampas
larvae938843larvae
laurae64011663laurae
lawman11289053lawman
layman113511303layman
lemma94811033lemma_
lemmas10349163lemmas
maar66025063ma__ar
mabe85733363ma__be
macaw12311763ma_caw
mace87345793ma__ce
mache125925303ma_che
mackle143716433mackle
macle96127003ma_cle
macrame1338713macrame
maculae113412863maculae
macule104115273macule
madam10316223ma_dam
madames12310063madames
madams11310943madams
madcap1336333madcap
made75440243ma__de
madmen113511743madmen
madras94316433madras
madre85720173ma_dre
mae57659113___mae
maenad939413maenad
mafia104418033mafia_
mafias113913573mafias
mage75739133ma__ge
magian9312833magian
magmata1237463magmata
magnate10512703magnate
magpie1139093magpie
mahoe10315573ma_hoe
maigre9309163maigre
maile75232223ma_ile
mailman1137733mailman
maim85831493maim__
maimed114812663maimed
maimer104514593maimer
maims96321793maim_s
maize164618563ma_ize
makar115614973ma_kar
make105537893ma__ke
malar76424443ma_lar
malate84624553malate
male66052303ma__le
maleate94117543maleate
malgre9299303malgre
malice104818483malice
maline84529083maline
mallee84525593mallee
malm85129983malm__
malmier113611953malmier
malms95021553malm_s
malmsey1433623malmsey
malmy124816343malm_y
maltase938903maltase
mambo115215743ma_mbo
mamboed14417623mamboed
mamboes135011823mamboes
mambos125414493mambos
mamey125418833ma_mey
mameyes14376983mameyes
mameys13449523mameys
mamies104626243mamies
mamluk1434743mamluk
mammatus1144233mammatus
mammered12237653mammered
mammers104615693mammers
mammets103911113mammets
mammeys13376723mammeys
mammillae1243043mammillae
mammock1664393mammock
mammons1048513mammons
mammoth1344983mammoth
mamzer19459833mamzer
mana65341963ma_na_
manage93818903manage
manas76240433ma_nas
manat76039993ma_nat
manche133515103manche
mandate10315573mandate
mane65052033ma__ne
manege94113203manege
manga85026203manga_
mangas94122923mangas
mange84930193ma_nge
mangle93921323mangle
mania75634153mania_
maniac103917973maniac
manias84029033manias
manna75522543manna_
mannan85413623mannan
mannas85019803mannas
manque17259513manque
manse75528233ma_nse
manta75629913manta_
mantas85725363mantas
mantle84420923mantle
manual8313463manual
manure8313653manure
maple95521143ma_ple
mapmaker1864373mapmaker
mara67444573ma_ra_
maras75443293ma_ras
marble104219103marble
mare64759333ma__re
maremma1044463maremma_
maremme1054603maremme
margay12310593margay
marge85328333ma_rge
maria75032883maria_
marine84230403marine
marka114620793marka_
markas124717003markas
marmite112413993marmite
marmot10318743marmot
marque172410503marque
marram10313883marram
marse76231153ma_rse
masa65034723ma_sa_
masas75630413ma_sas
mashie11315933mashie
masque17249383masque
massa75518923massa_
massage1039893massage
massas85116463massas
masse75125293ma_sse
mate65154223ma__te
matsah1138233matsah
matte75626843ma_tte
mature8313463mature
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
maugre9308973maugre
maumet103518883maumet
mauve104013273ma_uve
mavie104722563ma_vie
maxima17568633maxima_
maximal18347093maximal
maxixe1435223maxixe
maya95824593ma_ya_
mayan105616903ma_yan
mayas105924383ma_yas
maybe12311133ma_ybe
mayday1535883mayday
mayhap1635233mayhap
maze155434983ma__ze
mazuma1935603mazuma_
mazumas2034623mazumas
meatman1137903meatman
mediae94217413mediae
meme85330553m_em_e
mensae84114053mensae
merman10513863merman
miasma1097563miasma_
miasmal1176743miasmal
miasmas1167743miasmas
mimbar1297493mimbar
mime85736403m_im_e
minae75627723m_inae
mismade12129353mismade
mismake15139373mismake
mismate111415353mismate
mome85239353m_om_e
mommies103912273mommies
mommy114010753momm_y
morae75831193m_orae
mumble123614343mumble
mumm75718863mumm__
mummed104411553mummed
mummer93614543mummer
mummied11327103mummied
mummies103812843mummies
mumms85513153mumm_s
mummy114913623mumm_y
muscae10410673muscae
myoma1239273myoma_
myomas1338303myomas
name65637413na_m_e
paleae84820293paleae
palmar104113463palmar
palmate113215233palmate
pampa114913423pampa_
pampas124913993pampas
parae76335703pa_rae
pommee122813283pommee
pommie123710503pommie
ragman94013713ragman
ramal74622243ra_mal
ramate83921683ramate
ramble104519973ramble
ramee74633853ra_mee
ramie75027823ra_mie
rammed113117303rammed
rammer103519653rammer
rammier112811023rammier
rammy124312493ramm_y
ramose8314403ramose
rampage1237453rampage
raphae114311733raphae
rummage1234583rummage
salpae84614273salpae
samba95618773samba_
sambaed1238303sambaed
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
same65245643sa_m_e
samite83020603samite
sampan102511893sampan
sample104215013sample
shammas14358723shammas
summa94713313summa_
summas104313163summas
summate113611663summate
tamal73522623ta_mal
tamale83717403tamale
tambac122210243tambac
tambak14249263tambak
tame66343663ta_m_e
tammies113814683tammies
tammy124013223tamm_y
tampan102512323tampan
tarmac10310333tarmac
taxman15328613taxman
teammate1245613teammate
vamose1159283vamose
vanman1139793vanman
wadmal1237283wadmal
wakame1535433wakame
wamble134415753wamble
wame95035483wa_m_e
wammus13426733wammus
yammer133713183yammer
yasmak1534593yasmak
zamia165115213zamia_
zamias174212923zamias

Search took 6 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 Limit1127164254.84623259.6
3Display Results4254250.1403035.7
 (SQL Overall)1786914255.37633238.7
 
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.