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

258 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
metical1131536(None) 
medical12312511medical
meticals12310761meticals
metrical12311591metrical
epical10413392_epical
ethical1238442_ethical
fetial95716192feti_al
gestical1138982gestical
hectical1547932hectical
helical12311152helical
lexical1637362lexical
magical1239782magical
matinal9312602matinal
medial93819862medi_al
medicals1349362medicals
menial84223032meni_al
meniscal1246192meniscal
mescal104113482me_scal
mesial84818082mesi_al
metal75427382met__al
meticais1248182meticais
mezcal19367852me_zcal
mimical1339232mimical
musical1139552musical
mystical1546932mystical
mythical1845032mythical
optical1149862optical
poetical12311532poetical
retial64724992reti_al
retinal75318352retinal
septical1259362septical
thetical1349122thetical
tical76021492__tical
vatical1239982vatical
vertical13410432vertical
vesical12159812vesical
actinal9312293actinal
aecial84817313aeci_al
aerial64625713aeri_al
aestival1145483aestival
anticar9312663anticar
apical10913903_apical
ascetical1346273ascetical
bestial9311643besti_al
biotical1248863biotical
cecal94619113ce__cal
centrical1348353centrical
cercal10314123ce_rcal
cervical1546853cervical
chemical1748393chemical
clerical1248233clerical
comical13312223comical
conical11316203conical
cortical12412213cortical
cotidal1038463cotidal
critical12310263critical
cubical1338463cubical
cynical1437873cynical
datival1135583datival
decal85523233de__cal
decimal1238083decimal
deifical1445543deifical
deistical1246673deistical
denial74720513deni_al
dentinal939503dentinal
detick1339383detic_k
deticks1437353deticks
detrital946573detrital
devisal1136913devisal
domical1239373domical
edictal1046993_edictal
emetic10614453emetic__
emetically17411423emetically
emetics11610723emetic_s
erica7316543_erica_
ericas8315463_ericas
erotical101911983erotical
estival1036323estival
ethicals1345533_ethicals
ethnical1346363_ethnical
etic66123953_etic__
fecal105119213fe__cal
fecial114714623feci_al
ferial94621253feri_al
festival1444713festival
fetal85623373fet__al
fetials103711743feti_als
fetich1479693fetic_h
feticidal1544153feticidal
finical1239693finical
geminal10109903geminal
genetical1247573genetical
genial74917613geni_al
genital849793genital
geoidal936713geoidal
haptical1547343haptical
heliacal1344723heliacal
heretical1448633heretical
hermetical1746383hermetical
heroical13410023heroical
iatrical1049273iatrical
identical1246313identical
intimal9109943intimal
irenical1048553irenical
laical8312323_laical
lenticel1066123lenticel
lethal939803let_hal
lexica1536103lexica_
logical1038513logical
lyrical1236493lyrical
maniacal1246723maniacal
marital92314183marital
martial92415413marti_al
maximal18347093maximal
meal65643173me___al
meatal84114733me_atal
mecca1139933me_cca_
meccas1239493me_ccas
medal86221333me__dal
media84721713medi_a_
mediacy1536143mediacy
mediad104313713medi_ad
mediae94217413medi_ae
medials103914733medi_als
median94117543medi_an
medias93620783medi_as
medic104619653medic__
medicable1647503medicable
medicaid1445783medicaid
medically17310113medically
medicant13910823medicant
medicare1347483medicare
medicate13513243medicate
medicinal1445083medicinal
medick154010133medic_k
medicks16368413medicks
medico113711163medic_o
medicos12339833medicos
medics114115353medic_s
medieval1443943medieval
medigap1374623medigap
medina94114093medina_
medinas103411463medinas
medivac1554693medivac
medusal1035183medusal
megilla1036273megilla
melic94722333melic__
menials94015683meni_als
mensal84615653me_nsal
mental84521603me_ntal
mescals112911553me_scals
mesian84315503mesi_an
mesic93617863mesic__
mesically16310093mesically
mestiza1835383mestiza_
mestizas1944703mestizas
meta65932413met__a_
metals84520883met__als
metatag1045053metatag
metazoal1944473metazoal
metepa1066013metepa_
metepas1136303metepas
methodical1845143methodical
methyl1436403met_hyl
methylal1644263methylal
metier83517693meti_er
metiers93312843metiers
meting94320593meti_ng
metis75025903meti__s
metisse936503metisse
metol75917813met__ol
metopae1147743metopae
metric10314673metric__
metrically17411083metrically
metricate1349913metricate
metrics11312363metric_s
mezcals20246533me_zcals
mica86428253m__ica_
micas96823053m__icas
minicab13177163minicab
minicam131110053minicam
minicar11109313minicar
minimal114010603minimal
miticidal1444183miticidal
mitral81314323mit_ral
modica11310063modica_
motional1058673motional
multicar1247523multicar
musicale1247343musicale
musicals1247093musicals
mutual838503mut_ual
myrica1336833myrica_
myricas1436753myricas
nautical1057703nautical
nodical1049863nodical
numerical1345973numerical
oedipal1045173oedipal
optimal1145783optimal
pedicab1446693pedicab
pedicel1237813pedicel
pedocal1237893pedocal
pelican1139433pelican
pemican1348153pemican
penial84120893peni_al
penicil1138833penicil
petal76526893pet__al
pical95524373__pical
plical10411683_plical
radical103312793radical
recital9412163recital
redial74923113redi_al
reginal84814293reginal
retia55326113reti_a_
reticle94112623reticle
reticula1047413reticula
reticule1049303reticule
retina65023383retina_
retinae75517333retinae
retinals85612963retinals
retinas74819353retinas
retinol7469693retinol
retotal739843retotal
retral64419743ret_ral
retrial7615553retrial
revisal1038263revisal
revival1337033revival
rustical1048393rustical
scenical1247133scenical
sceptical1545343sceptical
seminal91213403seminal
serial64625863seri_al
setal56430903set__al
skeptical1743963skeptical
statical1039423statical
sterical10311253sterical
stoical9310283stoical
tactical1248843tactical
telial65815363teli_al
tertial7313863terti_al
tetanal738023tetanal
tetanical1146533tetanical
ticals83214713__ticals
tidal64516443__tidal
tincal83913363__tincal
topical1139953topical
toxical1637643toxical
typical1436343typical
unethical1444523unethical
veinal93812963ve_inal
venatical1446793venatical
venial94218283veni_al
verticals1457243verticals
verticil1366913verticil
vesica11157913vesica_
vesicae12177703vesicae
viatical1347063viatical
vortical1348863vortical
xenial133414903xeni_al

Search took 8 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 Filter1786911340270.403443402.0
2DLD Change Limit1340272586.48620664.0
3Display Results2582580.0932774.2
 (SQL Overall)1786912586.98225593.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.