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

189 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
maculate12281562(None) 
jaculate172311781jaculate
maculae113412861macula_e
maculated142411501maculated
maculates132013721maculates
acuate8315632_acu_ate
aculeate1039922_aculeate
acylate12310532_acylate
adulate8313232_adulate
ambulate1239732ambulate
calculate1389872calculate
canulate10314552canulate
ejaculate18187162ejaculate
emasculate1445552emasculate
fabulate1339202fabulate
faculae123210352facula_e
hamulate1359012hamulate
immaculate1653502immaculate
jaculated19289052jaculated
jaculates182810362jaculates
lacunate10128962lacunate
loculate101011402loculate
macerate122314072macerate
macula103013672macula__
macular113011942macula_r
maculas113114022macula_s
macule104115272macul__e
malate84624562ma__late
maturate10312622maturate
modulate1138592modulate
osculate101010612osculate
peculate122414672peculate
sacculate1349022sacculate
tabulate10310892tabulate
vacuolate1445222vacuolate
ablate82219213_a_blate
acaudate1145973_acaudate
accurate12410663accurate
acerate92818913_acerate
acetate92514753_acetate
aciculate132510803aciculate
acidulate12256893_acidulate
acolyte12157653_acolyte
acrylate1347693_acrylate
actuate9311443_actuate
aculeated1247723_aculeated
acute74720363_acu__te
acylated1437873_acylated
acylates1339743_acylates
adulated1039753_adulated
adulates9311913_adulates
alate55340333_a__late
alulae6312743_alula_e
ambulated1457133ambulated
ambulates1348383ambulates
amputate1246263amputate
angulate9312013angulate
annulate8310923annulate
apiculate13279883apiculate
arcuate9311963arcu_ate
aurate64426473_a_urate
baccate131011263bac_cate
backdate1748223backdate
bacula103112673bacula__
baculine1238983baculine
calculated1577803calculated
calculates1498703calculates
cannulate1148633cannulate
canulae9311183canula_e
canulated12310673canulated
canulates11312873canulates
capsulate1347563capsulate
caudate10311353ca_udate
circulate13810433circulate
coagulate1258083coagulate
copulate122614113copulate
cucullate1344733cucullate
cumulate123110223cumulate
cupulate122810033cupulate
curate85226243__curate
ecaudate1145313ecaudate
ejaculated20165903ejaculated
ejaculates19166443ejaculates
emaciate1248753emac_iate
emasculated1644533emasculated
emasculates1544903emasculates
emulate9314123_emulate
escalate1039323escalate
evacuate13217303evacu_ate
exculpate2044833exculpate
fabulated1546323fabulated
fabulates1447733fabulates
faceplate1645223faceplate
facula112912233facula__
facular122810443facula_r
faculty1535573facul_ty
feculae12339203fecula_e
gallate83417133ga_llate
granulate1059183granulate
gratulate1047683gratulate
haulage1136913ha_ulage
incubate1238663incubate
incudate1138873incudate
inculcate1347433inculcate
inculpate1346793inculpate
inoculate1149623inoculate
insulate8312843insulate
jugulate1645483jugulate
lacerate102214713lacerate
lactate9312703lac_tate
lacunae9116803lacuna_e
lazulite1745033lazulite
ligulate92510253ligulate
lobulate1078833lobulate
loculated1288313loculated
lunulate838253lunulate
macerated142010523macerated
macerater13259523macerater
macerates132113573macerates
machete14310883mac_hete
machinate1647953machinate
mackle143716433mackl__e
macle96127003mac_l__e
macrame1338713mac_rame
maculating1549553maculating
maculation14510983maculation
maculed123510053macul_ed
macules114015133macul_es
maculing13219583maculing
magnate10512703ma_gnate
makebate1645063makebate
malates93522613ma__lates
maleate94117543ma_leate
mammate104411273ma_mmate
mandate10315573ma_ndate
manducate1445773manducate
manipulate1445163manipulate
maquette1946113maquette
marinate103017783marinate
marlite92917073ma_rlite
masculine1346443masculine
matelote1047603matelote
matriculate1546193matriculate
maturated1249163maturated
maturates11311763maturates
mercurate1347343mercurate
micturate1366643micturate
modulated1336713modulated
modulates1238053modulates
morulae958963morula_e
moulage1037903m_oulage
mucilage1344203mucilage
mutate83017483m__utate
mutilate10312273mutilate
osculated1298143osculated
osculates11109393osculates
ovulate1039453_ovulate
palate84226793pa__late
paniculate1447213paniculate
papulae11249353papula_e
peculated142310853peculated
peculates132112543peculates
planulate1146903planulate
populate122812093populate
racemate1239063racemate
radulae837963radula_e
regulate9313023regulate
rosulate8310903rosulate
saccate111311763sac_cate
sacculated1546623sacculated
saturate8312813saturate
scutate9310323_scutate
simulate10311133simulate
spatulate11107173spatulate
speculate13239193speculate
spiculate132210163spiculate
subulate10312743subulate
tabulated1237303tabulated
tabulates1139143tabulates
tubulate1038273tubulate
ululate749963_ululate
undulate9310403undulate
ungulate939803ungulate
ustulate868323ustulate
vacate11314553vac__ate
vacillate1456853vacillate
vacuolated1643973vacuolated
vallate103016563va_llate
valuate102512733valu_ate

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621896.87621256.8
3Display Results1891890.0762486.8
 (SQL Overall)1786911897.37524229.3
 
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.