English Dictionary

English Dictionary Database of 197,820 Words & Definitions

Data Structure

letter [26]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
char(1)
+ title (100%)
char(1)
+ slug (100%)
int(11)
+ count (100%)
section [1,907]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
char(1)
+ letter_slug (100%)
bigint(20) unsigned
+ letter_id (100%)
int(11)
+ count (100%)
word [197,820]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
varchar(255)
+ section_slug (100%)
char(1)
+ letter_slug (100%)
bigint(20) unsigned
+ letter_id (100%)
bigint(20) unsigned
+ section_id (100%)
text
+ definitions (70.3%)
text
+ synonyms (54.7%)
text
+ antonyms (4.8%)
text
+ see_also (59.4%)
text
+ related_terms (9.1%)
text
+ webster_1913 (49.9%)

Description

This is a very comprehensive English dictionary database containing 197,820 unique English words and phrases. Definitions with usages by part of speech, example sentences, synonyms and antonyms are included for each word entry. Additional fields such as see_also and related_terms are also there for better cross-reference, though not all words have them. All words have definitions (in the definitions field or webster_1913) and most have synonyms.

Synonyms and antonyms in this database are NOT those from the synonyms database or the antonyms database. If they are combined with this one, we'd have a much larger synonyms and antonyms database.

Data Profile

Size 153.19M
Tables 3
Last Commit 2016-12-07 00:38:02

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:38:02 153.19M 3 26 199753
2016-08-29 04:31:08 153.19M 3 26 199753
2016-08-26 02:58:27 144.08M 3 26 199753

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
letter 26 .001 0.026
section 1,907 .001 1.907
word 197,820 .001 197.82
Total Credits 199.753 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.