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?
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.
Dictionaries for download or
This one
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/