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 “madrigal” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

454 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
madrigal12162725(None) 
madrigals13856231madrigals
marital92314182ma_rital
warrigal1244312warrigal
adagial946373_adagial
admiral1046363_admiral
adrenal838263_adrenal
aerial64625713_aeri_al
argal65023393_a_r_gal
arrival1037563_arrival
atrial65418943_atri_al
cardigan1245613cardigan
cardinal1139563cardinal
carinal94318233ca_rinal
iatrical1049273iatrical
lacrimal1244443lacrimal
larrigan944213larrigan
macrural1244963macrural
madeira1045103madeira_
madeiras1144773madeiras
madras94316433madr__as
madrasa10387883madrasa_
madrasah14324783madrasah
madrasas11317763madrasas
madrigalian1551493madrigalian
madrigalist1583133madrigalist
madrona10288703madrona_
madronas11288493madronas
magical1239783ma_gical
malarial10410613malari_al
mandril1049353mandri__l
mandrill1146613mandri_ll
manorial10311083manori_al
manurial1047793manuri_al
margay12310593ma_r_gay
marginal1137603marginal
maria75032883ma_ri_a_
marigold1244093ma_rigold
marina84623413ma_rina_
marinas93519383ma_rinas
marriage1147253marriage
marshal1238973ma_rshal
martial92415413ma_rtial
martingal1244063martingal
material10314103materi_al
matinal9312603ma_tinal
matronal1048113matronal
maximal18347093ma_ximal
medial93819863med_i_al
medical12312513med_ical
medigap1374623med_igap
metrical12311593metrical
milligal1145703milligal
nadiral836343nad_iral
narial6317953na_ri_al
quadriga1944073quadriga_
quadrigae2053633quadrigae
radial74020393rad_i_al
radical103312793rad_ical
warragal1243863warragal
warrigals1343773warrigals
abigail1044194_a_bigail
achiral12109184_achiral
actinal9312294_actinal
adaxial1545324_adaxial
admirals1144354_admirals
adnexal1543824_adnexal
adrenals946304_adrenals
adrift10313114_adri_ft
aecial84817314_aeci_al
aerials74017554_aeri_als
aerogel836524_aerogel
affinal1336444_affinal
affixal2043764_affixal
agria65517144_agri_a_
agrias74315394_agri_as
albinal937814_albinal
algal66518224_a__lgal
alright1148854_alright
amiga85514814_a_miga_
amigas95912174_a_migas
amoral8314634amor__al
amrita8411134_amrita_
amritas939094_amritas
anginal8310164_anginal
animal85016254_a_nimal
antigay1148224_antigay
aortal65217514_aor_tal
apical10913904_a_pical
apsidal1046704_apsidal
areal55928734_a_r_eal
argala74712674_a_r_gala
argali75013754_a_r_gali
argals75517714_a_r_gals
argil65116884_a_r_gil
argol65317264_a_r_gol
aria46245424_a_ri_a_
arias55438024_a_ri_as
ariel55228974_a_ri_el
aright103817664_a_right
aril45843024_a_ri__l
arrayal1055844_arrayal
arrhizal2042954_arrhizal
arriba867684_arriba_
arrivals1145934_arrivals
artal55525474_a_r_tal
arval86017014_a_r_val
astragal945624astragal
atria56022344_atri_a_
audial7312994_audi_al
aural54428964_aur__al
auroral7310474_auroral
axial124515194_a_xi_al
barbal104016664ba_r_bal
barbital1247054barbital
barilla9310324ba_rilla
basinal9310034ba_sinal
bedrivel1444084bedrivel
bridal9511454__bridal
burial84117624_buri_al
cabrilla1245834cabrilla
cambial134010764cambi_al
candidal12367734candidal
cannibal1245204cannibal
capital112311524ca_pital
capsidal1345624capsidal
caracal11312514ca_racal
cardia9916374cardi_a_
cardiac1278814cardi_ac
cardiae10713704cardi_ae
cardias10715114cardi_as
cardigans1345154cardigans
cardinals1247994cardinals
carina84325324ca_rina_
carinae94318584ca_rinae
carinas93622404ca_rinas
caritas93316954ca_ritas
carnal83919204ca_r_nal
carnival1345614carnival
carpal103716254ca_r_pal
carriage1137854carriage
chorial124214144chori_al
clerical1248234clerical
cordial10312944cordi_al
corrival1346154corrival
cuadrilla1243424cuadrilla
curial84019154_curi_al
datival1135584da_tival
decrial10310324decri_al
deprival1444604deprival
detrital946574detrital
dial55935064__d_i_al
drill64718264__dri_ll
drivel105110384__drivel
empirical1544194empirical
facial113615634fa_ci_al
farcical1546954farcical
farfal123410184fa_r_fal
farina94618234fa_rina_
farinas103215234fa_rinas
fascial1258304fasci_al
faucial1257324fauci_al
ferial94621254_feri_al
frugal1036394__frugal
galangal1043894galangal
garigue935584ga_rigue
gavial10310084ga_vi_al
gharial1137344ghari_al
hadal95518124had___al
haptical1547344haptical
harijan1735784ha_rijan
harridan12145124harridan
hartal9415474ha_r_tal
hydria13227904hydri_a_
hydriae14246904hydri_ae
hydrilla1543474hydrilla
hydrogel1644754hydrogel
imaginal1144904ima_ginal
imperial1249024imperi_al
infrugal1242454infrugal
jarina134014064ja_rina_
jarinas143712184ja_rinas
labial84714344la_bi_al
lacrimals1342914lacrimals
laical8312324la__ical
laminal94113634la_minal
lanital7310914la_nital
lariat6629044la_ri_at
larrigans1044014larrigans
larval948504la_r_val
laryngal1242764laryngal
latria62313594latri_a_
latrias71913214latri_as
lubrical12116094lubrical
lyrical1236494_lyrical
mackinaw1943104mackinaw
macruran1244014macruran
madam10316224mad___am
madcap1336334mad__cap
madding123711994maddi_ng
maddish14289484maddi_sh
maderize2049074maderi_ze
maderized2247024maderized
maderizes2148954maderizes
madman113712384mad__man
madonna1044404madonna_
madonnas1143844madonnas
madrasahs15243854madrasahs
madrases112610004madrases
madrassa11274634madrassa
madrassah15293084madrassah
madrassas12304704madrassas
madre85720174madr___e
madres93718184madr__es
madrigalists1672314madrigalists
madrilene1243664madrilene
madrone102812664madr_one
madrones112912284madrones
madrono10288744madr_ono
madronos11337544madronos
madwoman1643694madwoman
maffia14327204maffi_a_
maffias15327284maffi_as
mafia104418034ma_fi_a_
mafias113913574ma_fi_as
magian9312834ma_gi_an
maigre9309164ma__igre
mail65543454ma__i__l
maill74420794ma__i_ll
malanga1036664malanga_
malangas1136864malangas
malaria9313694malari_a_
malarian10311564malari_an
malarias10313774malari_as
malign939854ma_lig_n
malignly1444684ma_lignly
maligns1038134ma_ligns
mamaliga1344134mamaliga_
mamaligas1443384mamaligas
mammal95112754ma__mmal
mammilla1143934mammilla
mandrel1038684mandr__el
mandrills1245454mandrills
mandrils1138494mandri_ls
manga85026204ma__nga_
mangas94122924ma__ngas
mangel94017534ma__ngel
mania75634154ma_ni_a_
maniac103917974ma_ni_ac
maniacal1246724maniacal
manias84029034ma_ni_as
manila84518304ma_nila_
manilas93915874ma_nilas
manilla93012474ma_nilla
mannitol1044044mannitol
mantilla1048164mantilla
manual8313464ma__nual
manubrial1342944manubri_al
maquila1844704maquila_
maquilas1944034maquilas
mara67444574ma_r__a_
maraca10314154ma_raca_
maracas11313774ma_racas
maras75443284ma_r__as
marcel103714854ma_r_cel
margays1337494ma_r_gays
marge85328334ma_r_g_e
marges94525714ma_r_ges
margin94016844ma_r_gin
marginals1246004marginals
margins103815194ma_rgins
marigolds1343084ma_rigolds
marimba1354984ma_rimba
marimbas1444364ma_rimbas
marinade11259384ma_rinade
marinara1046494ma_rinara
marinate103017784ma_rinate
marine84230404ma_ri_ne
mariner93315994ma_riner
marines93928014ma_rines
marish114319054ma_ri_sh
maritally1448234ma_ritally
marka114620794ma_r_ka_
markas124717004ma_r_kas
markka11416594ma_rkka_
markkaa12373924ma_rkkaa
markkas12356084ma_rkkas
marl66341624ma_r___l
marram10313884ma_r_ram
marriages1247384marriages
married104715304marri_ed
marrieds11288074marrieds
marrier93817524marri_er
marriers103312474marriers
marries93825284marri_es
marring103319554marri_ng
marsala939584ma_r_sala
marshall1345484ma_rshall
marshals1337784ma_rshals
martian93514684ma_rtian
martingale1343194martingale
martingals1343314martingals
marvel113712004ma_r_vel
marzipan2142694marzipan
mashgiah1742924mashgiah
materials11510794materi_als
materiel10311254materi_el
maternal1047804maternal
matrices12312084matrices
matricidal1553864matricidal
matrix1539844matri__x
matrixes1738064matrixes
matutinal1143184matutinal
maxilla16248194ma_xilla
maxima17568634ma_xima_
maximals19325224ma_ximals
mayoral1237694ma_yoral
medal86221334med___al
media84721714med_i_a_
mediad104313714med_i_ad
mediae94217414med_i_ae
medials103914734med_i_als
median94117544med_i_an
medias93620784med_i_as
medicals1349364med_icals
medicinal1445084medicinal
medieval1443944medieval
medigaps1463884med_igaps
medina94114094med_ina_
medinas103411464med_inas
medivac1554694med_ivac
medusal1035184med_usal
memorial1249524memori_al
menial84223034m_eni_al
mesial84818084m_esi_al
metical11315364m_etical
midnight1544494midnight
midrib1138244midri__b
midribs1235514midri_bs
midriff1645514midri_ff
midriffs1742534midriffs
milligals1245034milligals
mimical1339234m_imical
minimal114010604m_inimal
misdial1039644misdi_al
mistrial10311384mistri_al
mitral81314324mitr__al
modal85919244mod___al
modica11310064mod_ica_
monadical1446134monad_ical
morainal1047204morainal
moral75533434m_or__al
morgan9311374m_or_gan
mortal84616854m_or_tal
mucoidal1344794mucoidal
mudra83912434mudr__a_
mudras94212254mudr__as
mudsill1045164mudsi_ll
mulligan1145154mulligan
mural75225104m_ur__al
musical1139554m_usical
myriad1235914m_yri_ad
myrica1336834m_yrica_
myricas1436754m_yricas
mystical1546934mystical
mythical1845034mythical
narwal938944na_r_wal
narwhal1344334na_rwhal
nasial6413284na_si_al
nautical1057704nautical
nodical1049864nod_ical
nonrival1146624nonrival
oedipal1045174oed_ipal
ordinal838634ord_inal
origan7310694__origan
outrival1145324outrival
ovarial1037614ovari_al
padri85815174padri___
paginal10269494pa_ginal
pallial92911254palli_al
paprica1337004paprica_
papricas1447054papricas
paprika1544004paprika_
paprikas1643854paprikas
pariah114320584pa_ri_ah
parian83223964pa_ri_an
parietal1048774pa_rietal
parral85517534pa_r_ral
partial92616264pa_rtial
patagial1157174patagial
patronal1048654patronal
perigeal1147544_perigeal
primal104014624__primal
prodigal1246004prodigal
quadrivial2352734quadrivial
rachial122012174rachi_al
racial83419244ra_ci_al
radiale83813524rad_i_ale
radials83614634rad_i_als
radian74117274rad_i_an
radicals112610154rad_icals
radicel10278874rad_icel
rasorial848224rasori_al
redial74923114red_i_al
redrill857894redri_ll
regal65023794___regal
reprisal1045904reprisal
retrial7615554retri_al
rial45938094___ri_al
rival85216504___rival
riyal84413434___riyal
rubrical1296094rubrical
rugal65916094___rugal
sacral83414414sacr__al
sahiwal1344444sa_hiwal
saiga64717934sa__iga_
saigas74114294sa__igas
satirical1146874satirical
satyrical1445034satyrical
saurian739914sauri_an
scribal1137964_scribal
serial64625864_seri_al
springal1145974_springal
sterical10311254sterical
strigil837264_strigil
tactical1248844tactical
taiga64115664ta__iga_
taigas73712564ta__igas
tarnal63716504ta_r_nal
tarsal63315274ta_r_sal
tergal72912834_ter_gal
trial54926354__tri_al
tribal8611134__tribal
trinal6516964__trinal
turrical1046204turrical
urial54823024__uri_al
urinal6614124__urinal
uxorial1446324uxori_al
vaccinal1544904vaccinal
vagal94613634va___gal
vaginal11288404va_ginal
varia85824204va_ri_a_
varias95019904va_ri_as
varietal1145614va_rietal
variola1068894va_riola
vatical1239984va_tical
wadmaal1343204wad_maal
wadmal1237284wad__mal
wanigan1135214wa_nigan
wannigan1242694wannigan
warragals1343474warragals
zariba1736984za_riba_
zaribas1836044za_ribas
zoarial1646924zoari_al

Search took 13 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 Filter1786911616090.1701051123.5
2DLD Change Limit16160945412.51612912.2
3Display Results4544540.1732624.3
 (SQL Overall)17869145412.85913896.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.