English dictionary SQL dump? [closed]

H

5

22

I'm looking for an open source, full english dictionary, that includes the type of word (i.e.: adjective, past tense, etc.) in some sort of database format, either SQL or something that could be easily parsed and turned into sql.

Any idea where I could find such a thing?

Hepato answered 10/8, 2009 at 15:57 Comment(4)

Random question: Are you going to use this for hacking? It would be cool. Is it bad this is the first thing that comes to my mind when I see the word dictionary being using in a program? – Jacinto 10/8, 2009 at 16:9

Just by the by, the garmmarian's technical term for what you're calling "type of word" is "part of speech" (in English, at least). – Celin 10/8, 2009 at 16:34

Thanks, will keep in mind. I was sure there was another, better term for it. – Eponymous 10/8, 2009 at 17:48

@Jacinto I am very late the question but personally I would use such a dataset to learn and practice SQL. – Cirillo 21/10, 2021 at 4:17

R

7

Im a 11 years late on this, but here is a link to a CSV containing the info you want. As well as a python script that will generate the that data dynamically.

https://github.com/benjihillard/English-Dictionary-Database

Renascence answered 26/2, 2021 at 22:0 Comment(1)

Project doesn't cite the source of the words, but based on the count of words it's likely the same as the SQL link above (a 1913 dictionary missing many important modern words). – Disruption 17/9, 2022 at 15:55

E

11

OSX has a built-in wordlist similar to the ones linked. It is strictly a word list, it does not contain the part of speech or definition.

On Mountain Lion, try:

cat /usr/share/dict/words

There are ~235k entries in there, so it may be over-inclusive.

Electromagnet answered 10/12, 2013 at 18:41 Comment(1)

I used Base to import the OS X word list into an SQLite database. – Petrography 21/3, 2014 at 7:3

R

7

Im a 11 years late on this, but here is a link to a CSV containing the info you want. As well as a python script that will generate the that data dynamically.

https://github.com/benjihillard/English-Dictionary-Database

Renascence answered 26/2, 2021 at 22:0 Comment(1)

Project doesn't cite the source of the words, but based on the count of words it's likely the same as the SQL link above (a 1913 dictionary missing many important modern words). – Disruption 17/9, 2022 at 15:55

E

6

http://sourceforge.net/projects/mysqlenglishdictionary/

I've been using this satisfactorily.

It has source code as well.

The database is made from a plain test English dictionary which is not too wordy and concise so easy to deal with.

This is the the plain test English dictionary.

http://www.mso.anu.edu.au/~ralph/OPTED/

Epirus answered 18/4, 2015 at 16:22 Comment(1)

sourceforge.net/p/mysqlenglishdictionary/code/ci/master/tree/… – Ramer 5/1, 2022 at 10:40

M

4

Some sort of wordlist?

Mcgarry answered 10/8, 2009 at 16:0 Comment(0)

R

4

Dictionaries for download or This one

Radical answered 10/8, 2009 at 16:0 Comment(2)

the "This one" looks quite good, though do excuse, I was looking for something that specifies the type of word (i.e. adjective). – Eponymous 10/8, 2009 at 16:5

did you find it ? – Gallant 9/5, 2019 at 22:31

Recommended topics

Hot tags