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

457 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
mitral8131432(None) 
citral81113891citral
mistral91013641mistral
antral65719412antral
astral66919282astral
citrals91111672citrals
estral64716512estral
literal7613272literal
litoral7610762litoral
metal75427382met_al
micra96214972micra_
mihrab1335522mihrab
mikra114610312mikra_
mineral9312732mineral
miskal123710262miskal
missal84314902missal
mistrals101212622mistrals
mistrial10311382mistrial
mitre75522422mitr_e
mitred94414342mitred
mitres83922072mitres
moral75533432m_oral
mortal84616852mortal
mural75225102m_ural
mutual838502mutual
nitril62511532nitril
retral64419742retral
ritual6310622ritual
viral86419592vi_ral
vital84819672vit_al
withal1238932withal
aboral8314373aboral
actual8311023actual
admiral1046363admi_ral
amitrole1045173amitrole
amoral8314633amoral
amtrac10109123amtrac
antra56521923antra_
anural65714743anural
aortal65217513aortal
apteral9311523apteral
arbitral1045423arbitral
artal55525473art_al
astrals75515243astrals
astray95615543astray
atrial65418943_atrial
aural54428963_aural
austral73411513austral
betray111511443betray
bharal1138893bharal
biaxal1536093biaxal
binal75323823bi_nal
birl65830473bi_r_l
bitmap1235613bitmap
boral75831703_boral
butyral1245713butyral
central93114473central
chiral114614413chiral
chital114313883chit_al
choral115118493choral
citola838393citola
citrate92216803citrate
citric102812313citric
citrin82615413citrin
citron83112983citron
citrus83610923citrus
clitoral10106463clitoral
coital84117053coit_al
comitial1248693comitial
coral76033453_coral
corral83616253corral
crural8610633crural
curtal83914543curtal
dextral1577003dextral
dial55935063di__al
diastral946993diastral
dioptral1144683dioptral
dipteral1147003dipteral
diram84419473di_ram
dirl57430023di_r_l
dismal92412243dismal
distal73615773distal
dita56032523dit_a_
ditas65923673dit_as
diurnal844883diurnal
dotal64919623dot_al
dural64923893_dural
enteral73516443enteral
enthral103410933enthral
entrap8710563entrap
estray95713333estray
estrual7367933estrual
extra1239003extra_
extras13310223extras
fatal84819373fat_al
feral85424653_feral
fetal85623373fet_al
fetial95716193fetial
fibril1137163fibril
figural1145243figural
filial93013253filial
final83922033fi_nal
finial92814183finial
fiscal1139333fiscal
fitful1256333fitful
floral94313813floral
futural1037283futural
gastral8329553gastral
gimbal11228813gimbal
gimmal11247513gimmal
gingal81010153gingal
girl56226553gi_r_l
gooral7310463gooral
goral65125753_goral
gyral94412783_gyral
hartal9415473hartal
hiatal9310203hiatal
hiemal11339503hiemal
hijra1535643hijra_
hijrah1934283hijrah
hijras1635773hijras
hitman112710223hitman
horal86328683_horal
ideal65716393_ideal
ihram10310183_ihram
ileal56118083_ileal
ilial55317843_ilial
immoral1146783immoral
initial7311883initial
inthral10249463inthral
irreal657833_irreal
jingal1498593jingal
jural125120483_jural
kitbag1334973kitbag
kittel10368873kittel
lateral7313573lateral
lethal939803lethal
liberal9310193liberal
libra74712423libra_
librae84310173librae
libras83711703libras
lienal63912783lienal
lineal65616023lineal
lira46928683li_ra_
liras56021983li_ras
litai55216363lit_ai
litas54923773lit_as
literals8312293literals
litre55421463litr_e
litres65220393litres
littoral845273littoral
loral55927823_loral
lustral7339653lustral
luteal64411483luteal
madras94316433madras
magistral1243623magistral
mammal95112753mammal
mantra84116093mantra_
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
manual8313463manual
mara67444573m_ara_
maras75443283m_aras
marital92314183marit_al
marl66341623m_ar_l
marram10313883marram
martial92415413martial
material10314103material
maternal1047803maternal
matinal9312603matinal
matrass939403matrass
matres84522233matres
matrix1539843matrix
matron83918313matron
matronal1048113matronal
matsah1138233matsah
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
mayoral1237693mayoral
mbira977973mbira_
mbiras1077153mbiras
meal65643173m__eal
meatal84114733meatal
medal86221333m_edal
medial93819863medial
menial84223033menial
mensal84615653mensal
mental84521603mental
merl65830973m_er_l
mescal104113483mescal
mesial84818083mesial
meta65932413met_a_
metals84520883met_als
methyl1436403methyl
metical11315363metical
metol75917813met_ol
metrazol1943513metrazol
metre74821303metr_e
metred95315143metred
metres85121563metres
metric10314673metric
metrical12311593metrical
metro74718803metr_o
metros84217803metros
mezcal19367853mezcal
miasmal1176743miasmal
miaul71612123mi_aul
mica86428253mi_ca_
micas96823053mi_cas
micell1098193micell
micro94715993micr_o
micron103714283micron
micros104115363micros
midcap1336473midcap
midday13327503midday
midrash1335423midrash
midrib1138243midrib
midway15327153midway
migrant10314313migrant
migrate101314173migrate
mihrabs1444203mihrabs
mikron12318503mikron
mikvah18143473mikvah
mil55752113mi___l
milia72719573milia_
mill66541483mi__ll
milpa92111403milpa_
milpas101710273milpas
mimbar1297493mimbar
mimical1339233mimical
mina65136923mi_na_
minae75627723mi_nae
minas75434113mi_nas
minerals10311373minerals
minimal114010603minimal
minstrel1046913minstrel
minutial1046423minutial
minyan1138173minyan
mir57046773mi_r__
miracle1138843mi_racle
mirage92313653mi_rage
mire66748233mi_r_e
mired85729223mi_red
mires75640883mi_res
mirex146816623mi_rex
miri66730373mi_r_i
mirin75023153mi_rin
mirk106729503mi_r_k
mirks115122143mi_rks
mirky146315523mi_rky
mirror848003mirror
mirs66940573mi_r_s
mirth106418893mi_rth
mirths114912993mirths
miry96326753mi_r_y
mirza16410443mi_rza
mirzas1738183mirzas
miscall1139643miscall
misdeal1037663misdeal
misdial1039643misdial
misdraw1345623misdraw
miseat82925703miseat
mishap1338863mishap
miskals13369763miskals
mislay113510683mislay
misrate91319143misrate
misread10339723misread
misrely12319613misrely
misrule939353misrule
missals93914423missals
missay114112143missay
missel85216523missel
mistrace12312643mistrace
mistrain10311943mistrain
mistreat10313113mistreat
mistrials1148133mistrials
mite66249413mit__e
miter75734793mit_er
mitered103213233mitered
miterer92511333miterer
miters84328783miters
mites75141803mit_es
mither114218563mither
mitier83620673mitier
mitis75425993mit_is
mitring103514143mitring
mitsvah1542163mitsvah
mitt66145493mit__t
mitten83914093mitten
mitts75523753mit_ts
mity95528213mit__y
mitzvah2441783mitzvah
modal85919243m_odal
moira71012023moira_
moirai886913moirai
molal75120343m_olal
mora66641273m_ora_
morae75831193m_orae
morale85220553m_orale
morals85324633m_orals
moras76438773m_oras
moray105423793m_oray
morel75729093m_orel
mortals93914003mortals
mortar83812043mortar
motel76623243mot_el
mudra83912433mudra_
mudras94212253mudras
mughal1236273mughal
mura65633293m_ura_
murals84016753m_urals
muras75329563m_uras
murra74519083murra_
murras84916003murras
mutuals937123mutuals
mutuel837823mutuel
natal53921493nat_al
natural739513natural
neural6311993neural
neutral737923neutral
nidal65217103ni_dal
nitrate72017013nitrate
nitre57519683nitr_e
nitres65519333nitres
nitric82512063nitric
nitrid72812233nitrid
nitrile73011373nitrile
nitrils72810703nitrils
nitro54914353nitr_o
nitros64214123nitros
nival84915773ni_val
notal55221353not_al
octal71214723oct_al
oral47638123__oral
osteal6312963osteal
outran63218893outran
parral85517533parral
patrol83213023patrol
petal76526893pet_al
petrale9312623petrale
petrel83111533petrel
petrol82714063petrol
peytral1287503peytral
pial65636703pi__al
pibal95217323pi_bal
pical95524373pi_cal
pineal84817683pineal
pinnal84814273pinnal
pipal95118353pi_pal
pita65436433pit_a_
pitas77427673pit_as
pitfall1245823pitfall
pitman102412123pitman
pitsaw1135613pitsaw
pitta75018693pitta_
pittas86014523pittas
plural839823plural
poitrel936193poitrel
portal84218463portal
ratal55025113rat_al
remittal1046513remittal
retial64724993retial
retrial7615553retrial
rial45938093ri__al
ricrac1037013ricrac
rictal83113183rictal
riprap1055513riprap
ristra6310713ristra_
ristras7311563ristras
ritard74812083ritard
rituals738353rituals
rival85216503ri_val
riyal84413433ri_yal
rostral7311333rostral
rural55821173_rural
sacral83414413sacral
satrap86212553satrap
seral56336383_seral
setal56430903set_al
sial45938833si__al
signal73711483signal
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
sisal54217733si_sal
sistra639333sistra_
sitar54820543sit_ar
sitars65417593sitars
somital939403somit_al
spiral83715343spiral
spital83813873spit_al
sporal82915453sporal
steal56125473_steal
strap77925263_strap
straw813321293_straw
stray88525573_stray
sural55931263_sural
sutra54217933sutra_
sutras64818593sutras
sutural7310223sutural
teal45546503__teal
tetra53417953tetra_
tetrad73612053tetrad
tetras63017623tetras
tetryl935693tetryl
tiara5315913tiara_
tiaras6314553tiaras
tibial849843tibial
tical76021493ti_cal
tidal64516443ti_dal
timbal102510753timbal
timbral11237193timbral
tincal83913363tincal
tineal66216163tineal
tirl45029923ti_r_l
titan53318173tit_an
titian62512663titian
titman82711003titman
titrable1038963titrable
titrant7315193titrant
titrate72215573titrate
titre54619393titr_e
titres64718933titres
total55321823tot_al
trad55630913__trad
trail55126773__trail
tram67034553__tram
trap67532803__trap
trawl84915873__trawl
tray77632593__tray
trial54926353__trial
ultra539363ultra_
ultras6310193ultras
umbral1038633umbral
ventral103612173ventral
vestral104111013vestral
vial76731093vi__al
victual1246253victual
vinal85725813vi_nal
vineal94814743vineal
virl76224473vi_r_l
virtual1045913virtual
visual938803visual
vita75828523vit_a_
vitae84217633vit_ae
vitals94514303vit_als
vitrain1038943vitrain
vitric112510113vitric
vitriol1045693vitriol
vitta85015173vitta_
vittae93911003vittae
wirra83210823wirra_
witan83816503wit_an
wittol935923wittol
ziram163912893zi_ram

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.1231452772.4
2DLD Change Limit1127164574.98322620.1
3Display Results4574570.1433195.8
 (SQL Overall)1786914575.24934042.9
 
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.