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

151 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
maculates13201372(None) 
jaculates182810361jaculates
maculate122815621maculate_
maculated142411501maculated
acylates1339742_acylates
adulates9311912_adulates
ambulates1348382ambulates
calculates1498702calculates
canulates11312872canulates
ejaculates19166442ejaculates
emasculates1544902emasculates
fabulates1447732fabulates
jaculate172311782jaculate_
jaculated19289052jaculated
macerates132113572macerates
maculae113412862macula_e_
maculas113114022macula__s
macules114015132macul__es
malates93522602ma__lates
maturates11311762maturates
modulates1238052modulates
osculates11109392osculates
peculates132112542peculates
tabulates1139142tabulates
ablates92416903_a_blates
acetates102013063_acetates
acidulates13215843_acidulates
acolytes13168043_acolytes
acrylates1446683_acrylates
actuates10310313_actuates
acuate8315633_acu_ate_
aculeate1039923_aculeate_
aculeated1247723_aculeated
acutes83917723_acu__tes
acylate12310533_acylate_
acylated1437873_acylated
adulate8313233_adulate_
adulated1039753_adulated
alates64833963_a__lates
ambulate1239733ambulate_
ambulated1457133ambulated
amputates1345263amputates
angulates10310863angulates
backdates1848153backdates
calculate1389873calculate_
calculated1577803calculated
cannulates1247783cannulates
canulate10314553canulate_
canulated12310673canulated
caudates11310263ca_udates
circulates1489283circulates
coagulates13137453coagulates
copulates132612463copulates
cumulates13258973cumulates
curates95323833__curates
ejaculate18187163ejaculate_
ejaculated20165903ejaculated
emaciates1347883emac_iates
emasculate1445553emasculate_
emasculated1644533emasculated
emulates10312573_emulates
escalates1148823escalates
evacuates14256803evacu_ates
exculpates2144123exculpates
fabulate1339203fabulate_
fabulated1546323fabulated
faceplates1744613faceplates
faculae123210353facula_e_
faculties1455143faculties
gallates92815523ga_llates
granulates1148463granulates
gratulates1157133gratulates
hamulate1359013hamulate_
haulages1236623ha_ulages
immaculate1653503immaculate_
incubates1347603incubates
inculcates1446563inculcates
inculpates1445973inculpates
inoculates1248703inoculates
insulates9311843insulates
jugulates1744603jugulates
lacerates112413773lacerates
lactates10311223lac_tates
lacunate10128963lacunate_
lazulites1844253lazulites
loculate101011403loculate_
loculated1288313loculated
macerate122314073macerate_
macerated142010523macerated
macerater13259523macerater
maceraters14226633maceraters
machetes1539633mac_hetes
machinates1747323machinates
mackles154415753mackl__es
macles107023223mac_l__es
macrames1438953mac_rames
macula103013673macula___
macular113011943macula__r
maculating1549543maculating
maculation14510983maculation
maculations1569623maculations
macule104115273macul__e_
maculed123510053macul__ed
magnates11511613ma_gnates
makebates1744973makebates
malate84624553ma__late_
maleates103316343ma_leates
mandates11314093ma_ndates
manducates1545593manducates
manipulates1544633manipulates
maquettes2045913maquettes
marinates112516383marinates
marlites103415263ma_rlites
masculines1445513masculines
matelotes1146333matelotes
matriculates1655473matriculates
maturate10312613maturate_
maturated1249163maturated
mercurates1446853mercurates
micturates1456093micturates
modulate1138593modulate_
modulated1336713modulated
moulages1138053m_oulages
mucilages1443813mucilages
mutates92215793m__utates
mutilates11310953mutilates
osculate101010613osculate_
osculated1298143osculated
ovulates1148523_ovulates
palates93624933pa__lates
peculate122414663peculate_
peculated142310853peculated
populates132710673populates
racemates1348853racemates
regulates101211723regulates
sacculate1349023sacculate_
sacculated1546623sacculated
saturates9811603saturates
simulates1139853simulates
speculates14237903speculates
tabulate10310893tabulate_
tabulated1237303tabulated
tubulates1147233tubulates
ululates848433_ululates
undulates1048923undulates
ungulates1048353ungulates
vacates12312833vac__ates
vacillates1555713vacillates
vacuolate1445223vacuolate_
vacuolated1643973vacuolated
valuates112811203valu_ates

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411516.22023897.3
3Display Results1511510.0632396.8
 (SQL Overall)1786911516.70326658.4
 
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.