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

503 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
mediae9421741(None) 
media84721711media_
mediad104313711mediad
medial93819861medial
median94117541median
medias93620781medias
mediate103415211mediate
rediae74221991rediae
aedile73716652aedile
aedine73218392aedine
edile64819492_edile
feriae95618602feriae
medal86221332med_al
meddle103312762meddle
mediacy1536142mediacy
medials103914732medials
medians103214212medians
mediant103516702mediant
mediated123011872mediated
mediates112814062mediates
medic104619652medi_c
medical12312512medical
medicare1347482medicare
medicate13513242medicate
medick154010132medick
medico113711162medico
medics114115352medics
medigap1374622medigap
medii84513492medi_i
medina94114092medina
medinas103411462medinas
meditate11310622meditate
medium113711622medium
medius93613282medius
medivac1554692medivac
medlar93010462medlar
medusae1044762medusae
menial84223032menial
mensae84114042mensae
mesial84818082mesial
mesian84315502mesian
redia65524482redia_
redial74923112redial
redias74523602redias
sedile73517232sedile
teniae64517352teniae
acedia9310393acedia_
acedias1039773acedias
aecia73819283aecia_
aecial84817313aecial
aediles83413903aediles
aerial64625713aerial
aerie54634603aeri_e
amebae1049633ame_bae
amidine103613853amidine
audial7312993audial
audile73315303audile
bediaper1344933bediaper
bedim10313833bedi_m
bedims1149593bedims
bedizen1935943bedizen
bedlam1149273bedlam
bedlike14369533bedlike
bedmate1239433bedmate
bedpan1137583bedpan
bedrape1277693bedrape
bedside1156843bedside
bedtime1236973bedtime
beige81515373be_ige
belie75630383beli_e
belike124616283belike
belive115415303belive
bemire103312803bemire
berime105317333berime
beside95114613beside
betide95115973betide
betime105914833betime
betise85616273betise
bodice11711423bodice
cardiae10713703cardiae
cedar84014323ced_ar
cede74928763ced__e
cedi74919273cedi__
ceding104014803ceding
cedis84317083cedi_s
celiac101910433celiac
cellae84915933cellae
ceria75125353ceria_
cerias83321983cerias
cerise84822043cerise
cerite84724873cerite
chedite1338863chedite
cnidae978143cnidae
comedian1347453comedian
curiae84518373curiae
deciare10710663deciare
decide104116873decide
decile94619213decile
dedal75719023ded_al
dedicate12312803dedicate
deduce1079253deduce
defile105216663defile
define104718143define
deice84320033de_ice
delime9314043delime
demise94618323demise
denial74720513denial
deride84420033deride
derive103817043derive
desire7415303desire
deviate11312713deviate
device124512163device
devise104215753devise
dexie134716893dexi_e
dial55935063__dial
dice75841893__dice
didie74120563didi_e
die46759653__di_e
dike95935763__dike
dime76237643__dime
dine55555333__dine
dire56644143__dire
dite55547553__dite
dive85634773__dive
edge65719663_ed_ge
edible969353_edible
edict84722283_edict
edify12308563_edify
ediles74016983_ediles
edit54934863_edi_t
edited83913673_edited
edits65819033_edits
educe84313453_educe
eerie55228533eeri_e
eide55832233_e_ide
elide64922643_elide
elite56230183_elite
emeritae1046353emeritae
emetine9712943emetine
empire1039323empire
endite73817593endite
endive103310473endive
evite85317683_evite
exedrae1544713exedrae
exile126117653_exile
exine125518493_exine
faciae112913413faciae
fecial114714623fecial
feline94820143feline
feria85922713feria_
ferial94621253ferial
ferias95020393ferias
ferine96422583ferine
fetial95716193fetial
gemmae11507793gemmae
genial74917613genial
genie66124923geni_e
heddle114211163heddle
hedge105317333hed_ge
heliac111010893heliac
hermae115314473hermae
herniae1039043herniae
hydrae13258573hydrae
hydriae14246903hydriae
immediate1444303immediate
indie63721473indi_e
indite73520323indite
iodide84812933iodide
iodine74618653iodine
iodise74214943iodise
iodize164112593iodize
keddah1534263keddah
kedge115513693ked_ge
khedive1842503khedive
lamiae84817453lamiae
ledge76519463led_ge
lenite6719983lenite
madam10316223mad_am
madame1139853madame
madcap1336333madcap
made75440243mad__e
madman113712383madman
madras94316433madras
madre85720173mad_re
mae57659113m___ae
mafia104418033mafia_
mafias113913573mafias
magian9312833magian
maile75232223m_aile
maize164618563m_aize
malice104818483malice
maline84529083maline
mamie95826003mami_e
mammae94613213mammae
mania75634153mania_
maniac103917973maniac
manias84029033manias
maria75032883maria_
marine84230403marine
mavie104722563mavi_e
maxixe1435223maxixe
mead75531603me__ad
meagre9349323meagre
meal65643173me__al
mealie82519813mealie
mean65538093me__an
meanie83718393meanie
measle83513223measle
meat66359603me__at
meatal84114733meatal
mecca1139933mecca_
meccas1239493meccas
med66146743med___
medaka1336343medaka
medakas1435763medakas
medaled113411613medaled
medals94218053medals
meddled123210033meddled
meddler11319953meddler
meddles113213253meddles
medevac1553523medevac
medfly1535223medfly
mediacies1447183mediacies
mediaeval1552173mediaeval
medially14129323medially
medianly14125943medianly
mediants11299493mediants
mediately1544613mediately
mediative1548123mediative
mediatize2146903mediatize
mediator1139043mediator
medicable1647503medicable
medicaid1445783medicaid
medicals1349363medicals
medicant13910823medicant
medicares1446873medicares
medicated15410073medicated
medicates14312113medicates
medicide1447713medicide
medicine1349543medicine
medicks16368413medicks
medicos12339833medicos
medieval1443943medieval
medigaps1463883medigaps
mediocre1343473mediocre
meditated1348083meditated
meditates1239813meditates
mediums12308723mediums
medivaced1843133medivaced
medivacs1644003medivacs
medlars10259443medlars
medley1298333medley
meds75735363med__s
medullae1143203medullae
medusa936293medusa
medusal1035183medusal
medusan1044713medusan
medusas1036213medusas
mega77620873me_ga_
megilp1135833megilp
meikle1236653meikle
meinie82614523meinie
meiny104015413me_iny
melding113414273melding
melee73729103me_lee
melic94722333meli_c
melodia1038883melodia_
melodias1148703melodias
melodise1147593melodise
melodize2046663melodize
meltage1037953meltage
meme85330553me__me
menace103216943menace
menad85918983me_nad
menage93216543menage
mendigo11506333mendigo
mending114018683mending
menials94015683menials
meninx1538703meninx
mensa75318663mensa_
mensal84615653mensal
mensas85115853mensas
mense75025633me_nse
menta74424423menta_
mental84521603mental
mentee84121293mentee
merde84320123me_rde
mere67244443me__re
merge84523683me_rge
mergee94018133mergee
meridian1147683meridian
merino8315093merino
merises93421423merises
merit7339183meri_t
merited10313853merited
merits8320873merits
merle75824373me_rle
merman10513863merman
mesa67025483me_sa_
mesas76823203me_sas
mescal104113483mescal
mesic93617863mesi_c
mesne75116293me_sne
message1037833message
messan83912063messan
messiah1246793messiah
mestee84523883mestee
meta65932413me_ta_
metage93114453metage
metal75427383me_tal
metate82720533metate
mete64438133me__te
methane123211793methane
metical11315363metical
metier83517693metier
meting94320593meting
metis75025903meti_s
metisse936503metisse
metopae1147743metopae
metope10611123metope
metre74821303me_tre
mettle83815723mettle
mewing123914203mewing
mezcal19367853mezcal
meze154420903me__ze
mice87442233m__ice
midair937993midair
midcap1336473midcap
midday13327503midday
middle103414983middle
midge95016543mid_ge
midi75628473midi__
midis85923413midi_s
midlife13248303midlife
midline102315103midline
midsize1946393midsize
midway15327153midway
midwife16225523midwife
mike105535293m__ike
mile66352573m__ile
milia72719573milia_
mime85736403m__ime
minae75627723m_inae
mine67256173m__ine
mire66748233m__ire
misdial1039643misdial
mise66043583m__ise
mite66249413m__ite
mobile103613543mobile
modal85919243mod_al
mode75840303mod__e
modi76826313modi__
modica11310063modica
modify1537173modify
modish123813543modish
modiste1039283modiste
module93011033module
moire71017323m_oire
moline84422033moline
monie75631653moni_e
morae75831193m_orae
motile83818343motile
motive113112143motive
movie105319133movi_e
moxie144018123moxi_e
mudcap1335133mudcap
mudcat11311203mudcat
muddle103414633muddle
mudra83912433mudra_
mudras94212253mudras
muriate9313363muriate
murine84220023murine
muscae10410673muscae
mutine84420373mutine
myeline1238253myeline
myriad1235913myriad
newie81813483newi_e
nudie65118673nudi_e
oedipal1045173oedipal
oidia6314953oidia_
oldie6415473oldi_e
pedal86022503ped_al
pedate93117763pedate
peddle103512823peddle
pedicab1446693pedicab
pedicel1237813pedicel
pedicle1238973pedicle
pedlar93311273pedlar
peise75825773pe_ise
pelite84323003pelite
penial84120893penial
penile82219603penile
pennae84314033pennae
perdie94718513perdi_e
petite84320653petite
podia8415283podia_
podite93315353podite
predial103815413predial
predive13511083predive
radial74020393radial
radiale83813523radiale
radian74117273radian
radiate83416313radiate
recipe103414893recipe
recite83625113recite
redan66125013red_an
redate74124683redate
redbay1238333redbay
redcap1158493redcap
reddle83815913reddle
rede55037663red__e
redear73515173redear
redeye103811793redeye
redialed10310793redialed
redials84416883redials
redid74922393redi_d
reding83825563reding
redip87816963redi_p
redips93713843redips
redipt94116743redipt
redline84218833redline
redone74820053redone
redraw10269853redraw
redrive112410563redrive
reduce9713253reduce
redware1139353redware
redye94413463red_ye
refile95122373refile
refine95225693refine
refire95419473refire
reggae858953reggae
regime95313943regime
reginae84713453reginae
regive104814323regive
rehire95415863rehire
reive85522943re_ive
reline65434353reline
relive95120783relive
remedial1147543remedial
remediate1247543remediate
remise84221953remise
repine85627813repine
rerise64325633rerise
reside74224933reside
resile64627673resile
resite64128453resite
resize154117723resize
retia55326113retia_
retial64724993retial
retie55735303reti_e
retile65929673retile
retime85321803retime
retinae75517333retinae
retine66237333retine
retire64927013retire
revile94921613revile
revise94019743revise
revive124914823revive
rewire95421403rewire
rexine134719443rexine
sedan65620423sed_an
sedate73019803sedate
sedge75019953sed_ge
seduce9610023seduce
seine55732873se_ine
seise54727853se_ise
seize143819503se_ize
senile63420213senile
sepia75318673sepia_
sepias83616103sepias
serial64625863serial
seriate73722473seriate
serine65432673serine
setae56026223se_tae
striae65422273striae
taeniae739083taeniae
tedium9269873tedium
telae54323293te_lae
telia55821143telia_
telial65815363telial
tenia55324483tenia_
tenias64720073tenias
terrae62915213terrae
testae64216253testae
tibiae838483tibiae
unciae83215313unciae
undine7817263undine
updive1234903updive
uredia73610063uredia_
uredial82910483uredial
vegie94614513vegi_e
venae85920983ve_nae
venial94218283venial
venine93718433venine
venire93513693venire
verite94323443verite
vesicae12177703vesicae
wedge105215633wed_ge
wedgie11428353wedgie
xenia124814773xenia_
xenial133414903xenial
xenias133712973xenias
zodiac1835303zodiac

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.1261418182.5
2DLD Change Limit1127165035.37320978.2
3Display Results5035030.1732907.5
 (SQL Overall)1786915035.67231504.1
 
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.