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

146 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
maculated14241150(None) 
jaculated19289051jaculated
maculate122815621maculate_
maculates132013721maculates
aculeated1247722_aculeated
acylated1437872_acylated
adulated1039752_adulated
ambulated1457132ambulated
calculated1577802calculated
canulated12310672canulated
ejaculated20165902ejaculated
emasculated1644532emasculated
fabulated1546322fabulated
jaculate172311782jaculate_
jaculates182810362jaculates
loculated1288312loculated
macerated142010522macerated
maculae113412862macula_e_
maculed123510052macul__ed
maturated1249162maturated
modulated1336712modulated
osculated1298142osculated
peculated142310852peculated
sacculated1546622sacculated
tabulated1237302tabulated
vacuolated1643972vacuolated
ablated102513443_a_blated
acerated113113983_acerated
acetated112010683_acetated
acidulated14195153_acidulated
actuated1138743_actuated
acuate8315633_acu_ate_
aculeate1039923_aculeate_
acylate12310533_acylate_
acylates1339743_acylates
adulate8313233_adulate_
adulates9311913_adulates
alated75625143_a__lated
ambulate1239733ambulate_
ambulates1348383ambulates
amputated1444463amputated
angulated1139223angulated
annulated1038603annulated
arcuated1138803arcu_ated
aurated83817793_a_urated
baccated15148373bac_cated
backdated1946483backdated
calculate1389873calculate_
calculates1498703calculates
cannulated1346503cannulated
canulate10314553canulate_
canulates11312873canulates
capsulated1545653capsulated
caudated1238063ca_udated
circulated1588063circulated
coagulated1496533coagulated
copulated142710483copulated
cumulated14237843cumulated
curated104717583__curated
ejaculate18187163ejaculate_
ejaculates19166443ejaculates
emaciated1446933emac_iated
emasculate1445553emasculate_
emasculates1544903emasculates
emulated11310793_emulated
escalated1247303escalated
evacuated15196263evacu_ated
exculpated2243923exculpated
fabulate1339203fabulate_
fabulates1447733fabulates
faculae123210353facula_e_
faulted11227723fa_ul_ted
granulated1256943granulated
gratulated1255733gratulated
hamulate1359013hamulate_
immaculate1653503immaculate_
incubated1446983incubated
inculcated1546173inculcated
inculpated1545733inculpated
inoculated1347593inoculated
insulated10310713insulated
jugulated1844023jugulated
lacerated122210673lacerated
lactated1138863lac_tated
lacunate10128963lacunate_
ligulated11247363ligulated
lobulated12106423lobulated
loculate101011403loculate_
lunulated1036783lunulated
macerate122314073macerate_
macerater13259523macerater
macerates132113573macerates
machinated1845663machinated
mackled164111923mackl__ed
macled116718113mac_l__ed
macula103013673macula___
macular113011943macula__r
maculas113114023macula__s
maculating1549543maculating
maculation14510983maculation
macule104115273macul__e_
macules114015133macul__es
malate84624553ma__late_
malates93522603ma__lates
malted94819863ma__l_ted
mandated12310293ma_ndated
manducated1644563manducated
manipulated1643963manipulated
marinated122513173marinated
matriculated1754613matriculated
maturate10312613maturate_
maturates11311763maturates
mauled94817823ma_ul__ed
medullated1442993medullated
mercurated1545393mercurated
micturated1584993micturated
modulate1138593modulate_
modulates1238053modulates
moulted103310313m_oul_ted
mulcted12296693m__ulcted
mutated102712253m__utated
mutilated1239453mutilated
occulted1344263occul_ted
osculate101010613osculate_
osculates11109393osculates
ovulated1237083_ovulated
peculate122414673peculate_
peculates132112543peculates
populated14228803populated
regulated11310463regulated
sacculate1349023sacculate_
saturated1038993saturated
sculpted1354883_sculpted
simulated1238283simulated
speculated15186613speculated
tabulate10310893tabulate_
tabulates1139143tabulates
tegulated1146633tegulated
tubulated1256063tubulated
ululated947663_ululated
undulated11310083undulated
vacated1349353vac__ated
vacillated1654623vacillated
vacuolate1445223vacuolate_
valuated12239203valu_ated
vaulted11307193va_ul_ted

Search took 8 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.423422437.4
2DLD Change Limit1486411467.25020502.2
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.73623098.6
 
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.