Lifetime updates. Come back once in a while to stay updated of new versions of this database.

English Dictionary Database of 197,820 Words & Definitions

Database 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.

Database Meta:

  • Size: 93.1 MB
  • Last updated: Mar. 19th, 2011
  • Formats Included: MySQL dump .sql text file, CSV, MS Excel
  • Tables: 3

Buy Now & Download: $189.00 (USD)


phpMyAdmin Screenshots:

MySQL Database: English Dictionary Database of 197,820 Words & Definitions for Sale

Table Details (Data Structure / Schema):

  • letter
    Records:26

    Table containing all the initial letters and number of words under each letter.

    Data fields

    1. id: int(11)
    2. title: char(1)
    3. slug: char(1)
    4. count: int(11)
  • section
    Records:1,907

    Word to word sections. This is for easier browsing / searching through the words.

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. slug: varchar(255)
    4. letter_slug: char(1)
    5. count: int(11)
  • word
    Records:197,820

    Dictionary table containing all the words and phrases as well as their definitions, synonyms, antonyms, etc.

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. slug: varchar(255)
    4. section_slug: varchar(255)
    5. letter_slug: char(1)
    6. definitions: text
    7. synonyms: text
    8. antonyms: text
    9. see_also: text
    10. related_terms: text
    11. webster_1913: text

Buy Now & Download: $189.00 (USD)



Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.

Instant download upon payment success, just press return button on PayPal website after finishing payment.

Potential Applications / Usage:

  • Words definition lookup / search site
  • Language site / school site enhancement
  • Dictionary site
  • English word games

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

  • Plain CSV
  • CSV for Microsoft Excel
  • Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
  • Microsoft Word .DOC file (2008, 2007, 2003, 2000)
  • LaTeX
  • Open Document Spreadsheet
  • Open Document Text
  • PDF
  • XML
  • YAML
  • WordPress Category / Post Database
  • Single Table Format

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.