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

471 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
medial9381986(None) 
medal86221321med_al
media84721711media_
mediad104313711mediad
mediae94217411mediae
medials103914731medials
median94117541median
medias93620781medias
medical12312511medical
menial84223031menial
mesial84818081mesial
redial74923111redial
aecial84817312aecial
aerial64625712aerial
audial7312992audial
dedal75719022ded_al
denial74720512denial
dial55935062__dial
fecial114714622fecial
ferial94621252ferial
fetial95716192fetial
genial74917612genial
meal65643172me__al
meatal84114732meatal
medals94218042med_als
mediacy1536142mediacy
medially14129322medially
medianly14125942medianly
medians103214212medians
mediant103516702mediant
mediate103415212mediate
medic104619652medi_c
medicals1349362medicals
medick154010132medick
medico113711162medico
medics114115352medics
medieval1443942medieval
medigap1374622medigap
medii84513492medi_i
medina94114092medina
medinas103411462medinas
medium113711622medium
medius93613282medius
medivac1554692medivac
medlar93010462medlar
medusal1035182medusal
menials94015682menials
mensal84615652mensal
mental84521602mental
mescal104113482mescal
mesian84315502mesian
metal75427382me_tal
metical11315362metical
mezcal19367852mezcal
misdial1039642misdial
modal85919232mod_al
oedipal1045172oedipal
pedal86022502ped_al
penial84120892penial
predial103815412predial
radial74020392radial
redia65524482redia_
rediae74221992rediae
redials84416882redials
redias74523602redias
remedial1147542remedial
retial64724992retial
serial64625852serial
telial65815362telial
uredial82910482uredial
venial94218282venial
xenial133414902xenial
acedia9310393acedia_
acedias1039763acedias
aecia73819283aecia_
aecidial1147243aecidial
aedile73716653aedile
aedine73218393aedine
aerials74017553aerials
alodial899953alodial
atrial65418943atrial
axial124515193_axial
bedel84219393bed_el
bedell93610043bedell
bedim10313833bedi_m
bedims1149593bedims
bedlam1149273bedlam
bedpan1137583bedpan
bedrail1037253bedrail
benzal1739643benzal
bestial9311643bestial
bewail1189583bewail
bezil163812883bezi_l
bridal9511453bridal
burial84117623burial
cecal94619113ce_cal
cedar84014323ced_ar
cedi74919273cedi__
cedilla1036343cedilla
ceding104014803ceding
cedis84317083cedi_s
cedula977643cedula
ceil65725063ce_i_l
celiac101910433celiac
cental84420963cental
cercal10314123cercal
cereal8315833cereal
ceria75125353ceria_
cerias83321973cerias
comedian1347453comedian
cordial10312933cordial
credal9311673cred_al
curial84019153curial
daedal849083daed_al
dal47554953__d_al
deal56347413__deal
decal85523233de_cal
decimal1238083decimal
decrial10310323decrial
deil56231623de_i_l
denials84114133denials
dental74319173dental
derail74218813derail
dermal93614343dermal
detail74516433detail
devil94714733devi_l
devisal1136913devisal
dhal86719283__dhal
dials64925343__dials
diel59034603__diel
dill55239973__dill
diol57329133__diol
dirl57430023__dirl
dual55928173__dual
edible969353_edible
edict84722283_edict
edictal1046993_edictal
edify12308563_edify
edile64819493_edile
edit54934863_edi_t
edits65819033_edits
egal55119433_e_gal
email74715103emai_l
epical10413393_epical
equal1449823_equal
espial839543espial
evil75318073_evi_l
facial113615633facial
feal713940423fe__al
fecal105119213fe_cal
fecials123510333fecials
federal1148533federal
feral85424653fe_ral
feria85922713feria_
feriae95618603feriae
ferias95020393ferias
festal94213563festal
fetal85623373fe_tal
fetials103711743fetials
feudal1037683feudal
filial93013253filial
finial92814183finial
gavial10310083gavial
geminal10109893geminal
genital849793genital
geoidal936703geoidal
glial66715433_glial
gremial1039153gremial
hadal95518123had_al
heal75645693he__al
heil76328933he_i_l
heliac111010893heliac
helical12311153helical
hemal104419803he_mal
herbal112513493herbal
hernial10310433hernial
hymenial1645293hymenial
ideal65716393_ideal
ilial55317843_ilial
imperial1249023imperial
jezail2234643jezail
jovial1636543jovial
keddah1534263keddah
kevil12399863kevi_l
keypal1534893keypal
khedival1941993khedival
labial84714343labial
leal46043273le__al
legal65715943le_gal
lethal939803lethal
lexical1637363lexical
madam10316223mad_am
madcap1336333madcap
madman113712383madman
madras94316423madras
madrigal121627253madrigal
mafia104418033mafia_
mafias113913573mafias
magian9312833magian
magical1239783magical
mail65543443m_ai_l
maill74420793m_aill
mammal95112753mammal
mania75634143mania_
maniac103917973maniac
manias84029033manias
manila84518303manila
manual8313463manual
maria75032883maria_
marital92314183marital
martial92415413martial
material10314093material
matinal9312603matinal
maximal18347093maximal
mead75531603me__ad
meals75933373me__als
mealy104422183me__aly
mean65538083me__an
meat66359603me__at
mecca1139933mecca_
meccas1239493meccas
med66146743med___
medaka1336343medaka
medakas1435763medakas
medaled113411603med_aled
meddle103312763meddle
medevac1553523medevac
medfly1535223medfly
mediaeval1552173mediaeval
mediants11299493mediants
mediated123011873mediated
mediately1544613mediately
mediates112814063mediates
mediator1139043mediator
medicable1647503medicable
medicaid1445773medicaid
medically17310103medically
medicant13910823medicant
medicare1347483medicare
medicate13513243medicate
medicinal1445073medicinal
medicks16368413medicks
medicos12339833medicos
medievals1553353medievals
medigaps1463883medigaps
meditate11310623meditate
mediums12308723mediums
medivacs1644003medivacs
medlars10259443medlars
medley1298333medley
meds75735363med__s
medulla1044713medulla
medusa936293medusa
medusae1044763medusae
medusan1044713medusan
medusas1036213medusas
mega77620873me_ga_
megadeal1243473megadeal
megilla1036273megilla
megilp1135833megilp
meikle1236653me_ikle
meiny104015413me_iny
mel56047483me___l
melding113414273melding
melic94722333meli_c
mell64935613me__ll
melodia1038883melodia_
melodias1148683melodias
memorial1249503memorial
menad85918983me_nad
mendigo11506333mendigo
mending114018683mending
menially131111093menially
meninx1538703meninx
meniscal1246183meniscal
mensa75318663mensa_
mensae84114043mensae
mensas85115853mensas
menta74424423menta_
meridian1147683meridian
merino8315093merino
merit7339183meri_t
merits8320873merits
merl65830973me__rl
merman10513853merman
mesa67025483me_sa_
mesas76823203me_sas
mescals112911553mescals
mesially13119083mesially
mesic93617863mesi_c
messan83912063messan
messiah1246793messiah
meta65932413me_ta_
metals84520883me_tals
methyl1436403methyl
meticals12310763meticals
metier83517693metier
meting94320593meting
metis75025903meti_s
metol75917813me_tol
metrical12311583metrical
mewing123914203mewing
mewl95618323me__wl
mezcals20246533mezcals
miaul71612123m__iaul
midair937983midair
midcap1336473midcap
midday13327503midday
midi75628473midi__
midis85923413midi_s
midway15327153midway
mil55752113m__i_l
milia72719573milia_
mill66541483m__ill
mimical1339233mimical
minimal114010593minimal
misdeal1037663misdeal
misdials1137493misdials
miskal123710263miskal
missal84314903missal
mitral81314323mitral
modals93914443mod_als
model84521693mod_el
modi76826313modi__
modica11310063modica
modify1537173modify
modioli1045473modioli
modish123813543modish
moil65534093m_oi_l
molal75120343m_olal
moral75533433m_oral
mortal84616853mortal
mudcap1335133mudcap
mudcat11311203mudcat
mudra83912433mudra_
mudras94212253mudras
mudsill1045163mudsill
mughal1236263mughal
mural75225103m_ural
musical1139553musical
mutual838503mutual
mycelial1543423mycelial
myriad1235893myriad
nadiral836343nadiral
narial6317953narial
nasial6413283nasial
neural6311993neural
nidal65217103nid_al
nodal64717793nod_al
nodical1049863nodical
oidia6314953oidia_
omental93210413omental
ordeal779253ordeal
ordinal838633ordinal
peal68648103pe__al
pedalo93811143ped_alo
pedals94316033ped_als
pedicab1446693pedicab
pedicel1237813pedicel
pedicle1238973pedicle
pedipalp1242513pedipalp
pedlar93311273pedlar
pedocal1237893pedocal
penal75228373pe_nal
peridial11411923peridial
peril75425953peri_l
petal76526893pe_tal
phial10313203_phial
pial65636703__pial
podia8415283podia_
praedial1178763praedial
racial83419243racial
radiale83813523radiale
radials83614633radials
radian74117273radian
radical103312793radical
real45750293re__al
rebill84713253rebill
recital9412163recital
recoal84117973recoal
rectal84418133rectal
redan66125013red_an
redbay1238333redbay
redcap1158493redcap
redear73515173redear
redialed10310793redialed
redid74922393redi_d
reding83825563reding
redip87816963redi_p
redips93713843redips
redipt94116743redipt
redraw10269853redraw
redrill857893redrill
redtail858713redtail
refill94514053refill
regal65023793re_gal
reginal84814293reginal
regnal74812933regnal
remail85017123remail
renail65020763renail
renal55929503re_nal
rental63922023rental
reoil55321183reoi_l
repeal84718283repeal
resail64418733resail
reseal64819643reseal
retail65522073retail
retia55326113retia_
retinal75318353retinal
retral64419743retral
retrial7615553retrial
reveal94115053reveal
revisal1038263revisal
revival1337033revival
rial45938093__rial
seal45654373se__al
sedan65620423sed_an
sedile73517233sedile
seidel7311083seidel
seminal91213403seminal
sendal73314993sendal
sepal77723003se_pal
sepia75318673sepia_
sepias83616103sepias
septal84513383septal
serail64222673serail
seral56336383se_ral
serials73919743serials
serval93913413serval
setal56430903se_tal
sexual1338413sexual
sial45938833__sial
social8813333social
somedeal1144573somedeal
special11310303special
sundial859863sundial
teal45546503te__al
tectal83713253tectal
tedium9269873tedium
telia55821143telia_
tenail64516103tenail
tenia55324483tenia_
teniae64517353teniae
tenias64720073tenias
tepal76319583te_pal
tergal72912833tergal
tertial7313853tertial
tibial849843tibial
tidal64516443tid_al
trial54926353_trial
uncial83715223uncial
uredia73610063uredia_
urial54823023_urial
veal76936813ve__al
veil75523593ve_i_l
veinal93812963veinal
venal85523213ve_nal
verbal112513663verbal
vernal93514213vernal
versal93013753versal
vesical12159813vesical
vestal94615573vestal
vexil1538963vexi_l
vial76731093__vial
wadmal1237283wadmal
weal75838683we__al
wedel94513953wed_el
xenia124814773xenia_
xenias133712973xenias
zeal135530333ze__al
zodiac1835303zodiac

Search took 9 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 Limit1127164717.83014395.4
3Display Results4714710.1403364.3
 (SQL Overall)1786914718.11022033.4
 
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.