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

420 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
maenad93941(None) 
maenads1037371maenads
menad85918981m_enad
amend85717752amen_d
faena85014202faena_
faenas94412762faenas
maenades1137472maenades
maenadic1344612maenadic
mana65341962ma_na_
manas76240432ma_nas
manat76039992ma_nat
maned86634102ma_ned
manna75522542manna_
mannan85413622mannan
mannas85019802mannas
manned94418642manned
maund85515452maun_d
mead75531602m_e_ad
menads95514382m_enads
mend75334032m_en_d
monad85519472m_onad
acned87520663_acned
agenda837253agenda
ahead96817053_ahead
aland65526413_aland
amarna839793amarna_
ameba9312383ameba_
amebae1049633amebae
ameban1039093ameban
amebas10311453amebas
amen66733153amen__
amended11328313amended
amends94713283amends
amens75624843amen_s
ament76036543amen_t
aments85219803aments
ana39559833_a_na_
anal48037523_a_nal
anas46649863_a_nas
and47244173_a_n_d
anear55420323_anear
anna45529013_anna_
annal56520763_annal
annas55824883_annas
arena55323813arena_
arenas65021993arenas
audad71511393_audad
awned96615953_awned
ballad94315323ballad
banal75925993ba_nal
band76740913ba_n_d
banda85223103ba_nda
baned85436353ba_ned
banned94721343banned
barned95623583barned
bead75937923_be_ad
beaned95621473beaned
bend76435263_ben_d
blend85317453blen_d
bread85523113bre_ad
caeca93915133caeca_
caecal103713733caecal
caesar8410933caesar
canal75428043ca_nal
canard9314763ca_nard
caned85838093ca_ned
canid85526343ca_nid
canna75919333canna_
cannas84518403cannas
canned95022063canned
carnal83919203carnal
catena8312483catena_
catenae9311373catenae
catenas9313113catenas
catnap1098383catnap
caudad10157673caudad
daedal849083daedal
damned104212913damned
darned85018483darned
davened124610073davened
dawned113912093dawned
dead65434243_de_ad
deaned84620453deaned
denar65223293_denar
dread74419023dre_ad
earned74818333earned
egad64215413__egad
emend86214893emen_d
end46834353__en_d
ennead736253ennead
evened101010313evened
faecal11359813faecal
fanned104117473fanned
farad95720673fa_rad
fauna84816513fauna_
faunae95210373faunae
faunal94711593faunal
faunas94013633faunas
fawned134910423fawned
fazenda2043253fazenda
fend84832973_fen_d
fiend95312983fien_d
fraena938063fraena_
frena85915273frena_
gaed66031513gae__d
gaen57329603gaen__
gained84617463gained
galena74911093galena_
galenas83310343galenas
gonad75216053_gonad
grenade938413grenade
haed86338583hae__d
haemal113811643haemal
haen76229453haen__
hand86833713ha_n_d
havened14429243havened
head87137173_he_ad
hexad164910623_hexad
hyaena1235363hyaena_
hyaenas1334983hyaenas
hyena11810253hyena_
hyenas1288953hyenas
impend11478793impen_d
jeaned143813463jeaned
jehad1637683_jehad
kana85928533ka_na_
kanas95326913ka_nas
keened114013623keened
kenaf12316033_kenaf
knead10429663kne_ad
ladened979053ladened
lagend838743lagen_d
lampad114510033lampad
lanai5319573la_nai
land56337313la_n_d
latened8711923latened
laterad8310843laterad
lead56038853_le_ad
leaned73422543leaned
lend56233673_len_d
lienal63912783lienal
maar66025063ma__ar
macaw12311763ma_caw
maced108528693ma_ced
macled116718113macled
mad68958713m___ad
madam10316223ma_dam
madcap1336333madcap
madded113513553madded
maddened1334893maddened
madman113712383madman
madras94316433madras
mae57659113mae___
maenadism1443973maenadism
maes66948403mae__s
mafia104418033mafia_
mafias113913573mafias
magenta1038623magenta
magentas1137923magentas
magian9312833magian
magma104513573magma_
magmas115512503magmas
magnate10512703magnate
magnet9320663magnet
magnum1136733magnum
maid75537663ma__id
mailed95326753mailed
maimed114812663maimed
main65345523main__
mainland1145213mainland
mainly11411493mainly
mains75635113main_s
makar115614973ma_kar
malady1237863ma_lady
malar76424443ma_lar
malfed12369763malfed
mallard10310273mallard
malled94626113malled
malted94819863malted
mama86231593ma_ma_
mamas95930773ma_mas
mamba116317523mamba_
mambas125716243mambas
mamma86317913mamma_
mammae94613213mammae
mammal95112753mammal
mammas94616403mammas
man57465873ma_n__
manage93818903ma_nage
managed113212603ma_naged
manana84816073ma_nana
mananas93414733mananas
manats84623463ma_nats
mane65052033ma_n_e
manege94113203manege
manes76648963ma_nes
manga85026203ma_nga
mangas94122923mangas
mange84930193ma_nge
mango85724323ma_ngo
mangy115021243ma_ngy
mania75634153ma_nia
maniac103917973maniac
manias84029033manias
manic94629443ma_nic
manly105022953ma_nly
manmade1237963manmade
mannans93611523mannans
manner84020513manner
mano66536813ma_n_o
manor78023933ma_nor
manos74933623ma_nos
mans66354553ma_n_s
mansard1049313mansard
manse75528233ma_nse
manta75629913ma_nta
mantas85725363mantas
mantid93820383mantid
manual8313463manual
manus75924933ma_nus
manward1349093manward
many95731863ma_n_y
mapped134015883mapped
mara67444573ma_ra_
maras75443283ma_ras
maraud938943maraud
marengo1035263marengo
margay12310593margay
maria75032883maria_
marina84623413marina_
marinade11259383marinade
marinas93519383marinas
marka114620793marka_
markas124717003markas
marked133921623marked
marled95523163marled
marram10313883marram
marred95421043marred
marted94425213marted
masa65034723ma_sa_
masas75630413ma_sas
mashed125325043mashed
masjid16187323masjid
masked134316523masked
masoned1039803masoned
massa75518923massa_
massas85116463massas
massed94421323massed
masted94025803masted
mated85537783ma_ted
maternal1047803maternal
matinal9312603matinal
matsah1138233matsah
matted94521413matted
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
maud75325403ma__ud
mauled94817823mauled
maun65727213maun__
maunds9519653maunds
maundy12506783maundy
maven104816893maven__
mavens114312973maven_s
mawed115824743ma_wed
mawn94424143mawn__
maxed155821193ma_xed
maya95824593ma_ya_
mayan105616903ma_yan
mayas105924383ma_yas
mayday1535883mayday
mayed115522403ma_yed
mayhap1635233mayhap
mazard1838763mazard
mazed175523873ma_zed
mazzard1844463mazzard
meads85425323m_e_ads
meal65643173m_e_al
mean65538093m_e_an
meaner84617843meaner
meanie83718393meanie
meanly115412043meanly
means75831233mean_s
meant76537213mean_t
meany104620483mean_y
meat66359603m_e_at
meatal84114733meatal
meated94222403meated
med66146743m_e__d
medal86221333m_edal
mediad104313713mediad
meed74934703m_e_ed
mega77620873m_ega_
meld75830473m_e_ld
melena81110473melena_
melenas999203melenas
men59252853m_en__
menace103216943m_enace
menaced122710093m_enaced
menage93216543m_enage
mended104418683m_ended
mends84927693m_ends
menial84223033m_enial
meno66031363m_en_o
mensa75318663m_ensa
mensae84114043m_ensae
mensal84615653m_ensal
mensas85115853m_ensas
mense75025633m_ense
mensed93916543m_ensed
mensh105413553m_ensh
menta74424423m_enta
mental84521603m_ental
menu65130233m_en_u
menudo945793m_enudo
menus75822843m_enus
mesa67025483m_esa_
mesas76823203m_esas
meta65932413m_eta_
metal75427383m_etal
meted85424433m_eted
mewed115218013m_ewed
mien65028363mien__
miens76118303mien_s
mina65136923m_ina_
minae75627723m_inae
minas75434113m_inas
mind75434383m_in_d
mined85333353m_ined
moaned94514173moaned
monads94515303m_onads
monas74732153m_onas
mooned94216643mooned
mound83918313moun_d
muraenid1144563muraenid
myna95815303m_yna_
mynah13569563m_ynah
mynas105815233m_ynas
myriad1235913myriad
naiad6313403na_iad
nana46632903na_na_
nanas55928633na_nas
omened93711003omened
opened94311863opened
oread64619603ore_ad
padnag1036073padnag
paean77222723pae_an
paeans85118263paeans
paesan85114093paesan
pained95622853pained
panada94113053pa_nada
panda85022613pa_nda
paned85437183pa_ned
panned94123433panned
pawned124513283pawned
peened94318153peened
penal75228373_penal
pend75934533_pen_d
pentad9313763_pentad
plead85818463ple_ad
pleiad947833pleiad
plena75816393plena_
qanat144426843qa_nat
rained75024603rained
rand55839573ra_n_d
ranid66429333ra_nid
ravened115012283ravened
read55942533_re_ad
renal55929503_renal
rend56136573_ren_d
sained75424243sained
salad65321833sa_lad
sand55338473sa_n_d
saned65636273sa_ned
sauna54117553sauna_
saunaed836703saunaed
saunas63915433saunas
scena74815783scena_
scenas84114703scenas
scend85516293scen_d
send55237293_sen_d
shend94719973shen_d
spend85619333spen_d
stead65520273ste_ad
taenia6313193taenia
taeniae739083taeniae
taenias7311283taenias
tanned75219953tanned
tapenade1145003tapenade
tarnal63716503tarnal
tend56433773_ten_d
thenal92712423thenal
thenar92610003thenar
tread64821703tre_ad
trend64817453tren_d
ulnad65611453_ulnad
upend85011043upen_d
vanda94515923va_nda
vaned94622423va_ned
vanned104614483vanned
varna84516173varna_
varnas94212823varnas
veena81912323veena_
veenas91410413veenas
vena76126293_vena_
venae85920983_venae
venal85523213_venal
vend86626423_ven_d
wakened1546873wakened
wand85833883wa_n_d
waned95831783wa_ned
wanned104318013wanned
warned104018913warned
weaned103816153weaned
weened104013733weened
wend85330453_wen_d
whenas124610463whenas
yarned105514023yarned
yawned13509843yawned
yeaned103813903yeaned

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.1401276364.3
2DLD Change Limit1127164205.12621989.1
3Display Results4204200.1403000.0
 (SQL Overall)1786914205.40633054.2
 
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.