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

204 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
maculae11341286(None) 
faculae123210351faculae
macula103013671macula_
macular113011941macular
maculas113114021maculas
maculate122815621maculate
macule104115271macul_e
alulae6312742_alulae
bacula103112672bacula_
canulae9311182canulae
facula112912232facula_
facular122810442facular
feculae12339202feculae
jaculate172311782jaculate
lacunae9116802lacunae
mackle143716432mackl_e
macle96127002mac_l_e
maculated142411502maculated
maculates132013722maculates
maculed123510052maculed
macules114015132macules
morulae958962morulae
papulae11249352papulae
radulae837962radulae
aciculae12267703aciculae
acuate8315633_acuate
aculeate1039923_aculeate
aculei839793_aculei
acute74720363_acu_te
acylate12310533_acylate
adulate8313233_adulate
alae45643753_a__lae
alula5317093_alula_
alular6311353_alular
ambulate1239733ambulate
ampule10710613ampul_e
ampullae1253773ampullae
aquae142212713_aqu_ae
aurae54128113_a_urae
avulse935843_avulse
bacalao1146613bacalao
baccae12119703bac_cae
baculine1238983baculine
baculum1345703baculum
bascule1136573bascul_e
cackle143416923cackl_e
calculate1389873calculate
cannulae1046493cannulae
canula8312963canula_
canular9310323canular
canulas9312853canulas
canulate10314553canulate
comatulae1343253comatulae
copulae112810613copulae
culpae10389263__culpae
cupulae11347853cupulae
ejaculate18187163ejaculate
emasculate1445553emasculate
fabular12288693fabular
fabulate1339203fabulate
faciae112913413fac_iae
facile112514883facil_e
faculty1535573faculty
faunae95210373fa_unae
fecula113310053fecula_
ferulae10309603ferulae
fibulae12237013fibulae
furculae1345063furculae
hackle154916813hackl_e
hamular1236973hamular
hamulate1359013hamulate
haulage1136913ha_ulage
immaculate1653503immaculate
jaculated19289053jaculated
jaculates182810363jaculates
jocular1637303jocular
lacuna8118123lacuna_
lacunal9136553lacunal
lacunar9136293lacunar
lacunas9138173lacunas
lacunate10128963lacunate
lacune8169673lacu_ne
laurae64011663la_urae
ligulae8308753ligulae
locular938953locular
loculate101011403loculate
locule83412033locul_e
lunulae735613lunulae
macabre1335223macabre
macadam1446853macadam
macaque2044053macaque
macaw12311763mac__aw
macchie1647193macchie
mace87345793mac___e
macerate122314073macerate
mache125925303mac__he
machete14310883machete
machine14313493machine
machree1438513machree
mackled164111923mackled
mackles154415753mackles
macled116718113mac_led
macles107023223mac_les
macrame1338713macrame
macrural1244963macrural
macruran1244013macruran
maculing13219583maculing
macumba1573043macumba
macumbas1653013macumbas
maile75232223ma_il_e
makuta1236393makuta_
malar76424443ma__lar
malate84624553ma__late
male66052303ma__l_e
mallee84525593ma_llee
mammae94613213ma_mmae
mangle93921323mangl_e
manila84518303manila_
manilas93915873manilas
manille92613273manille
mantle84420923mantl_e
manual8313463manu_al
manuals9311213manuals
manure8313653manu_re
maple95521143ma_pl_e
maquila1844703maquila_
maquilas1944033maquilas
marble104219103marbl_e
masala8311813masala_
masalas9312053masalas
masculine1346443masculine
maturate10312613maturate
mature8313463matu_re
maugre9308973ma_ugre
maul64830723ma_ul__
mauled94817823ma_uled
mauler84416713ma_uler
mauls76524953ma_ul_s
mauve104013273ma_u_ve
maxillae17256723maxillae
mazuma1935603mazuma_
mazumas2034623mazumas
medullae1143203medullae
medusae1044763medusae
micellae1295723micellae
micelle1178343micelle
mickle143715133mickl_e
modular1087363modular
modulate1138593modulate
module93011033modul_e
morula8710473morula_
morular978223morular
morulas959713morulas
moulage1037903m_oulage
mucilage1344203mucilage
muckle143413583muckl_e
mucosae11155313mucosae
mule65236973m__ul_e
muscular1246243muscular
mutular936643mutular
mutule8311423mutul_e
mycele1335853mycel_e
nacelle938153nacelle
nebulae955493nebulae
ocular8610133_ocular
oracular1047533oracular
oscula837293oscula_
oscular937933oscular
osculate101010613osculate
oscule838193oscul_e
pabular11259473pabular
papula103011113papula_
papular11299763papular
papule102212133papul_e
peculate122414673peculate
piacular1246573piacular
planulae1044793planulae
rackle123917293rackl_e
radula749313radula_
radular837833radular
radulas839583radulas
ranula6311813ranula_
ranular739433ranular
ranulas7311773ranulas
saccular1246893saccular
sacculate1349023sacculate
saccule1136743saccul_e
scapulae1255433scapulae
secular92211533secular
spiculae12218603spiculae
tabular9279763tabular
tabulate10310893tabulate
tackle123815733tackl_e
torulae758553torulae
ungulae837313ungulae
uvulae945323_uvulae
vacua10510463vacu_a_
vacuolar1353483vacuolar
vacuolate1445223vacuolate
vacuole1245373vacuole
valvulae1442723valvulae
vascula1245853vascula_
vascular1346293vascular
zonulae1645963zonulae

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 Filter1786911340270.393454684.5
2DLD Change Limit1340272046.28021341.9
3Display Results2042040.0762684.2
 (SQL Overall)1786912046.74926476.7
 
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.