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

396 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
macula10301367(None) 
bacula103112671bacula
facula112912231facula
maculae113412861maculae
macular113011941macular
maculas113114021maculas
macule104115271macule
alula5317092_alula
canula8312962canula
faculae123210352faculae
facular122810442facular
fecula113310052fecula
lacuna8118122lacuna
mackle143716432mackle
macle96127002mac_le
maculate122815622maculate
maculed123510052maculed
macules114015132macules
macumba1573042macumba
makuta1236392makuta
manila84518302manila
manual8313462manual
maquila1844702maquila
masala8311812masala
maul64830722ma_ul_
mauls76524952ma_uls
mazuma1935602mazuma
morula8710472morula
oscula837292oscula
papula103011112papula
radula749312radula
ranula6311812ranula
vacua10510462vacu_a
vascula1245852vascula
abulia83512503_abulia
aceta74017353_aceta
acicula11228133acicula
acold86214933_acold
acta69524803_ac_ta
actual8311023_actual
aculei839793_aculei
acute74720363_acute
acyl95314293_acyl_
acyls104211523_acyls
adult63520653_adult
ahull84010313_ahull
ajuga1335883_ajuga
akela9311343_akela
ala312463603_a__la
alulae6312743_alulae
alular6311353_alular
ampul91110853ampul_
ampule10710613ampule
ampulla1164303ampulla
ampuls1098893ampuls
aqua132813963_aqu_a
asyla839333_asyla
aucuba1045493aucuba
auld54125363_a_uld
aura45836253_a_ura
babul96317713babul_
babuls105413643babuls
bacalao1146613bacalao
bacca111012183bac_ca
baculum1345703baculum
bascule1136573bascule
baulk114914333ba_ulk
cabala103516913cabala
caca85528083cac__a
cackle143416923cackle
calculi1146563calculi
calla74827073ca_lla
cannula937433cannula
canola8313623canola
canulae9311183canulae
canular9310323canular
canulas9312853canulas
casual81112863casual
caul65630003ca_ul_
cauld85318443ca_uld
caulk115315453ca_ulk
cauls75727773ca_uls
cedula977643cedula
cicala10310053cicala
coagula1045413coagula
cola66541393__cola
comatula1244263comatula
copula102812043copula
cull65929643__cull
culm85822383__culm
culpa93610963__culpa
cult66541153__cult
cupula10328433cupula
dacha114812573dac_ha
datura738033datura
doula65717773_doula
fabular12288693fabular
facia103218463fac_ia
facial113615633facial
facile112514883facile
factual1246723factual
faculty1535573faculty
famuli1136763famuli
faucal11339963faucal
fauld95214493fa_uld
fault85428313fa_ult
fauna84816513fa_una
favela1237033favela
feculae12339203feculae
ferula93011173ferula
fibula11258053fibula
furcula1245793furcula
gala55635163ga__la
gault65128483ga_ult
hackle154916813hackle
hackly18298733hackly
halala94715093halala
hamular1236973hamular
hamuli1137063hamuli
haul75530453ha_ul_
haulm104415413ha_ulm
hauls86123733ha_uls
hawala12368913hawala
hula74923753__hula
incult82414773incult
inocula947263inocula
jacal14313703jacal_
jacals1539873jacals
jacana1537933jacana
jackal1937613jackal
jaculate172311783jaculate
jocular1637303jocular
jugula1434983jugula
kabala124011553kabala
kahuna1394103kahuna
kamala12339963kamala
lacily11612763lacily
lacunae9116803lacunae
lacunal9136553lacunal
lacunar9136293lacunar
lacunas9138173lacunas
lacune8169673lacune
laguna7127223laguna
laura54116203la_ura
lazuli1535363lazuli
ligula7359673ligula
locular938953locular
locule83412033locule
loculi8288253loculi
lunula636173lunula
mac78053933mac___
macaco1247853macaco
macadam1446853macadam
macaw12311763mac_aw
macaws1337023macaws
macchia1645893macchia
mace87345793mac__e
maced108528693mac_ed
macer912126943mac_er
macers105321273macers
maces97139963mac_es
mach116134483mac__h
mache125925303mac_he
maches134827233maches
macho126120153mac_ho
machos135217493machos
machs125722563mac_hs
macing114221553macing
mack125733653mac__k
mackled164111923mackled
mackles154415753mackles
macks135127603mac_ks
macled116718113macled
macles107023223macles
macon94519953mac_on
macons104017243macons
macro94718173mac_ro
macron103615673macron
macros104017013macros
macrural1244963macrural
macruran1244013macruran
macs86742513mac__s
maculated142411503maculated
maculates132013723maculates
maculing13219583maculing
macumbas1653013macumbas
madly115218133ma_dly
maduro936983maduro
maffia14327203maffia
mafia104418033ma_fia
magilp1137613magilp
magma104513573ma_gma
maguey1236833maguey
magus85318753magu_s
mail65543453ma_il_
maile75232223ma_ile
maill74420793ma_ill
maills84215283maills
mails76037783ma_ils
mainly11411493mainly
malar76424443ma__lar
male66052303ma__le
mall64639373ma__ll
malls76233433ma_lls
malm85129983ma__lm
malt66254813ma__lt
maltha1137513maltha
mama86231593ma__ma
mamba116317523ma_mba
mamluk1434743mamluk
mamma86317913ma_mma
mammal95112753mammal
mana65341963ma__na
manana84816073manana
mandala10310213mandala
mandola1039023mandola
manful11610213manful_
manga85026203ma_nga
mangle93921323mangle
mania75634153ma_nia
manilas93915873manilas
manilla93012473manilla
manly105022953ma_nly
manna75522543ma_nna
manta75629913ma_nta
mantle84420923mantle
mantra84116093mantra
mantua84412023mantua
manuals9311213manuals
manure8313653manure
manus75924933manu_s
maple95521143ma_ple
maqui16249953maqu_i
maquilas1944033maquilas
maquis17249483maquis
mara67444573ma__ra
maraca10314153maraca
marble104219103marble
marbly134111933marbly
marcel103714853marcel_
marcels113212373marcels
maria75032883ma_ria
marina84623413marina
marka114620793ma_rka
markka11416593markka
marl66341623ma_rl_
marls75535163ma_rls
marly106925613ma_rly
marsala939583marsala
masa65034723ma__sa
masalas9312053masalas
mascara1138023mascara
massa75518923ma_ssa
masscult12104723masscult
matilda1044983matilda
mature8313473mature
matza16311813ma_tza
maud75325403ma_u_d
mauds85519273ma_uds
mauled94817823ma_uled
mauler84416713ma_uler
maun65727213ma_u_n
maund85515453ma_und
maut65448453ma_u_t
mauts75927193ma_uts
mauve104013273ma_uve
maxilla16248193maxilla
maxima17568633maxima
maya95824593ma__ya
mayfly1734403mayfly
mazily20610393mazily
mazumas2034623mazumas
mazurka2272873mazurka
mecca1139933mec_ca
medulla1044713medulla
medusa936293medusa
mezuza1643533mezuza
miaul71612123miaul_
miauls8178713miauls
mica86428253mic__a
micell1098193micell
micella11106823micella
mickle143715133mickle
micra96214973mic_ra
midcult1246303midcult
mizuna1734303mizuna
mocha1249923moc_ha
mochila1446523mochila
modular1087363modular
module93011033module
moduli9267963moduli
modulo9256983modulo
mogul8310213mogul_
moguls948553moguls
mola66035633m__ola
moola75117033m_oola
morulae958963morulae
morular978223morular
morulas959713morulas
mould86015753m_ould
moult74728723m_oult
muchly1686203muchly
muckle143413583muckle
mucluc1245053mucluc
mucosa10166273mucosa
mucus94015743mucu_s
mule65236973m__ule
mull65128803m__ull
mulla74317113m_ulla
mura65633303m__ura
muscular1246243muscular
mutual838503mutual
mutular936643mutular
mutule8311423mutule
mycele1335853mycele
mycelia1444843mycelia
nala46930393na__la
nebula857333nebula
occult1038433occult
ocular8610133_ocular
oculi72010793_oculi
oracular1047533oracular
oscular937933oscular
oscule838193oscule
pabular11259473pabular
paca85132243pac__a
pacha126518063pac_ha
packly17228333packly
paella8410913paella
papulae11249353papulae
papular11299763papular
papule102212133papule
parura8310583parura
payola11208113payola
peculia1147133peculia
piacular1246573piacular
picul95015363picul_
piculs103511753piculs
planula935773planula
pula65129373__pula
qabala17399193qabala
racial83419243racial
racily11715173racily
rackle123917293rackle
radulae837963radulae
radular837833radular
radulas839583radulas
rambla103510933rambla
ranular739433ranular
ranulas7311773ranulas
saccular1246893saccular
saccule1136743saccule
sacculi1145043sacculi
sacra74516993sac_ra
sacral83414413sacral
saul45836523sa_ul_
sauls55128123sa_uls
sault55834963sa_ult
sauna54117553sa_una
scapula1136343scapula
scuba94211593_scuba
sculk115112463_sculk
scull75315763_scull
sculp95314843_sculp
scuta75815753_scuta
secular92211533secular
spatula935893spatula
specula11187413specula
spicula11259293spicula
tabla73318363ta_bla
tabular9279763tabular
tabuli839363tabuli
tackle123815733tackle
tactual936203tactual
tala45938053ta__la
taluka10426773taluka
tenacula1044493tenacula
torula6610393torula
ungula737603ungula
uvula845153_uvula
vacuolar1353483vacuolar
vacuole1245373vacuole
vacuum1334833vacuum
valuta938743valuta
valvula1343253valvula
vascular1346293vascular
vault85823763va_ult
vicuna11115903vicuna
vincula1246393vincula
walla85321033wa_lla
waul76927313wa_ul_
wauls86120553wa_uls
yakuza2261873yakuza
yamulka1651773yamulka
yauld95511183ya_uld
zonula1537223zonula

Search took 7 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.376475242.0
2DLD Change Limit1127163965.60620106.3
3Display Results3963960.1263142.9
 (SQL Overall)1786913966.10829255.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.