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?
On
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.
On
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.
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