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

424 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
mammal9511275(None) 
hammal134512061hammal
mamma86317911mamma_
mammae94613211mammae
mammals10389271mammals
mammas94616401mammas
dammar11438902dammar
gamma106116102gamma_
gammas115714692gammas
gimmal11247512gimmal
haemal113811642haemal
hamal104623102ha_mal
hammals14409212hammals
hammam12419332hammam
madman113712382madman
magma104513572magma_
magmas115512502magmas
mama86231582ma_ma_
mamas95930772ma_mas
mamba116317512mamba_
mambas125716242mambas
mammary1335992mammary
mammate104411272mammate
mammati10398372mammati
mammee94417852mammee
mammer94218862mammer
mammet94319252mammet
mammey124310892mammey
mammie94313782mammie
mammon939642mammon
mammy115215162mamm_y
manual8313462manual
maximal18347092maximal
miasmal1176742miasmal
momma85111052momma_
mommas94110652mommas
ramal74622242ra_mal
sambal105215182sambal
tamal73522612ta_mal
wadmal1237282wadmal
aal39058673_a__al
adman84517903_adman
agma77623263_agma_
agmas85919873_agmas
algal66518213_algal
alma66333023_alma_
almah106917253_almah
almas76629773_almas
ama510853303_a_ma_
amah98927483_a_mah
amas67746293_a_mas
amia66836893_amia_
amias75831463_amias
ammo85520133_amm_o
ammonal1137013ammonal
ammos94815823_ammos
amoral8314623amoral
ampul91110853_ampul
amyl95515093_a_myl
anal48037523_a_nal
animal85016253animal
annal56520763_annal
appal95315223_appal
areal55928733_areal
argal65023383_argal
artal55525473_artal
arval86017013_arval
atma68121773_atma_
atman75520143_atman
atmas75721013_atmas
aural54428963_aural
axal116520493_a_xal
axial124515193_axial
axman144813183_axman
baal67033113ba__al
badman113813843badman
bagman114613813bagman
bammed133913243bammed
banal75925993ba_nal
barbal104016663barbal
barman103519703barman
basal75722283ba_sal
batman105214063batman
bayman133712703bayman
bromal10313653bromal
brumal1049503brumal
bummalo1353793bummalo
cabal95222153ca_bal
cabman123812503cabman
caecal103713733caecal
caiman103615663caiman
camail10314823camail
camas96333523ca_mas
cambial134010753cambial
camel96822803ca_mel
cameral11311263cameral
cammie124615293cammie
canal75428043ca_nal
cantal84122033cantal
carman103920743carman
carnal83919203carnal
carpal103716253carpal
casual81112863casual
caudal91611483caudal
causal81413203causal
cayman133613213cayman
chasmal14158213chasmal
comal95125133_comal
comma114514793comma_
commas124814573commas
cymbal15236913cymbal
daedal849083daedal
daman84821163da_man
damar84117733da_mar
dammars12308193dammars
dammed124214793dammed
dammer114317933dammer
dammit11311133dammit
damsel9148033damsel
dermal93614343dermal
dismal92412243dismal
domal85619203_domal
facial113615633facial
faecal11359813faecal
fallal93612693fallal
farfal123410183farfal
fatal84819373fa_tal
faucal11339963faucal
faunal94711593faunal
formal113215203formal
gagman103811243gagman
gama77035513ga_ma_
gamas85431353ga_mas
gamay116419103ga_may
gamba106018513gamba_
gambas115817513gambas
gambol1138223gambol
gametal1037603gametal
gammed124216163gammed
gammer1112318333gammer
gammon1138903gammon
gammy135514893gamm_y
gasman92911743gasman
gavial10310083gavial
gayal9312713ga_yal
gemma106311773gemma_
gemmae11507793gemmae
gimbal11228803gimbal
gimmals12225823gimmals
gramma11499803gramma_
grammar12406893grammar
grammas12499773grammas
gumma105313103gumma_
gummas114810513gummas
hadal95518123ha_dal
halal85623593ha_lal
hallal94415563hallal
halma108219253halma_
halmas117017893halmas
hamals114816813ha_mals
hamaul114210863hamaul
hammada1545083hammada
hammams13386433hammams
hammed144116973hammed
hammer138120033hammer
hammily1736063hammily
hammy155113433hamm_y
hamza19139773hamza_
hamzah23135553hamzah
hamzas20119013hamzas
hartal9415473hartal
hazmat20312263hazmat
hemal104419803_hemal
hiemal11339493hiemal
hymnal1434913hymnal
jacal14313703ja_cal
jackal1937613jackal
jammable2144513jammable
jammed183811503jammed
jammer174014133jammer
jammy194810193jamm_y
jumbal1758463jumbal
kamala12339963ka_mala
karma113415003karma_
karmas123013733karmas
kummel14266173kummel
labial84714333labial
laical8312323laical
lama66635293la_ma_
lamas75532793la_mas
lamia75324323lamia_
lamiae84817453lamiae
lamias85020613lamias
laminal94113633laminal
lammed113915623lammed
lampad114510033lampad
lampas106615953lampas
larval948503larval
lawman11289053lawman
layman113511303layman
lemma94811033lemma_
lemmas10349163lemmas
maar66025053ma__ar
macaw12311763ma_caw
macula103013673macula
madam10316223ma_dam
madame1139853madame
madams11310943madams
madcap1336333madcap
madmen113511743madmen
madras94316423madras
maenad939413maenad
mafia104418033mafia_
mafias113913573mafias
magian9312833magian
magical1239783magical
magmata1237463magmata
mail65543433ma__il
maill74420783ma_ill
mailman1137733mailman
maim85831473maim__
maimed114812663maimed
maimer104514593maimer
maims96321783maim_s
makar115614973ma_kar
malar76424443ma_lar
mall64639363ma__ll
malm85129973malm__
malms95021553malm_s
malmy124816343malm_y
maltol8310843maltol
mambo115215733ma_mbo
mambos125414493mambos
mamey125418833ma_mey
mameys13449523mameys
mamie95826003ma_mie
mamies104626243mamies
mamluk1434743mamluk
mammalian1243713mammalian
mammality1544273mammality
mammalogy1652153mammalogy
mammatus1144233mammatus
mammees104411143mammees
mammers104615693mammers
mammets103911113mammets
mammeys13376723mammeys
mammies104314763mammies
mammilla1143933mammilla
mammock1664393mammock
mammons1048513mammons
mammoth1344983mammoth
mamzer19459833mamzer
mana65341943ma_na_
manas76240423ma_nas
manat76039983ma_nat
mandala10310203mandala
manful11610213manful
manga85026193manga_
mangas94122923mangas
mangel94017533mangel
mania75634143mania_
maniac103917973maniac
manias84029033manias
manila84518303manila
manmade1237963manmade
manna75522533manna_
mannan85413623mannan
mannas85019803mannas
manta75629903manta_
mantas85725363mantas
mantel84317973mantel
manuals9311213manuals
mara67444563ma_ra_
maras75443283ma_ras
marcel103714853marcel
maremma1044463maremma_
margay12310593margay
maria75032883maria_
marital92314183marital
marka114620793marka_
markas124717003markas
marl66341613ma__rl
marmot10318743marmot
marram10313883marram
marsala939583marsala
marshal1238973marshal
martial92415413martial
marvel113712003marvel
masa65034713ma_sa_
masala8311813ma_sala
masas75630413ma_sas
massa75518923massa_
massas85116463massas
matinal9312603matinal
matsah1138233matsah
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
maul64830713ma__ul
maumet103518883maumet
maxima17568633maxima_
maximals19325223maximals
maya95824583ma_ya_
mayan105616903ma_yan
mayas105924383ma_yas
mayday1535873mayday
mayhap1635233mayhap
mayoral1237683mayoral
mazuma1935603mazuma_
mazumas2034623mazumas
meal65643173__meal
meatal84114733meatal
meatman1137903meatman
medal86221323m_edal
medial93819863medial
menial84223033menial
mensal84615653mensal
mental84521603mental
merman10513853merman
mescal104113483mescal
mesial84818083mesial
metal75427383m_etal
mezcal19367853mezcal
miasma1097563miasma_
miasmas1167743miasmas
mimbar1297483mimbar
mimical1339233mimical
minimal114010593minimal
miskal123710263miskal
missal84314903missal
mitral81314323mitral
modal85919233m_odal
molal75120343m_olal
mommy114010753momm_y
moral75533433m_oral
mortal84616853mortal
mughal1236263mughal
mumm75718863mumm__
mummed104411553mummed
mummer93614543mummer
mumms85513153mumm_s
mummy114913623mumm_y
mural75225103m_ural
mutual838503mutual
myoma1239273myoma_
myomas1338293myomas
narial6317953narial
narwal938943narwal
nasal56217593na_sal
nasial6413283nasial
natal53921493na_tal
naval85315833na_val
normal83213533normal
oatmeal944973oatmeal
paleal84716673paleal
palmar104113463palmar
palpal104112053palpal
pampa114913423pampa_
pampas124913993pampas
papal95820673pa_pal
parral85517533parral
pascal10812373pascal
pausal81511963pausal
pommel12277453pommel
primal104014623primal
pummel12278043pummel
racial83419243racial
radial74020393radial
ragman94013713ragman
rambla103510933rambla
rammed113117303rammed
rammer103519653rammer
rammy124312493ramm_y
ramtil8311023ramtil
rascal8511123rascal
ratal55025113ra_tal
sabal75422483sa_bal
sacral83414413sacral
salal55425703sa_lal
samba95618773samba_
sambals115213483sambals
sambar103914163sambar
sambas104219263sambas
samiel8313333samiel
sampan102511893sampan
sandal73317283sandal
shammas14358713shammas
stammel11607533stammel
stomal85213313stomal
summa94713313summa_
summae103911013summae
summas104313163summas
tamale83717393ta_male
tamals84116623ta_mals
tambac122210243tambac
tambak14249263tambak
tambala1138023tambala
tammie104212683tammie
tammy124013223tamm_y
tampala1136613tampala
tampan102512323tampan
tarmac10310333tarmac
tarnal63716503tarnal
tarsal63315273tarsal
taxman15328613taxman
timbal102510743timbal
tombal102311023tombal
trammel11357663trammel
tymbal13236823tymbal
vagal94613633va_gal
valval12398863valval
vandal103713833vandal
vanman1139793vanman
vasal85516293va_sal
vassal979243vassal
wadmaal1343203wadmaal
wadmals1335513wadmals
wadmel1235523wadmel
wadmol1234053wadmol
wammus13426733wammus
yammer133713183yammer
yasmak1534593yasmak
zamia165115213zamia_
zamias174212923zamias

Search took 10 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.1401276364.3
2DLD Change Limit1127164248.78312833.4
3Display Results4244240.2661594.0
 (SQL Overall)1786914249.18919446.2
 
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.