Prasenjit Kumar Nag a.k.a Joy

A Developers Adventure in Coding

Some Sources of English Word List

I was in need of a english word list for a application and I was searching for a complete list. First and formost What they are saying around the internet that there’s no such thing as a complete list. English Language has lots of words and the count increases when you add slangs or science terms or other categories.

So I will be sharing some of the sources I have found which can save you some time if you need it at some point.

Finding one from within your nix/mac OS: If you are on a mac or any other nix distro, chances are that you already have a word list in you os. You can find it out by browsing the /usr/share/dict/  directory. In my mac which is 10.6.8 I have the following files in my /usr/share/dict/ directory:

ls /usr/share/dict/
README  connectives  propernames  web2  web2a  words

So to check I just ran a

cat words

and the cat command showed the full word list in the terminal. If you are sure that you dont need more than this then you can insert these words into a mysql table easily.

Login into mysql from your terminal window and select the desired database and run the following command:

LOAD DATA LOCAL INFILE '/usr/share/dict/words' INTO TABLE words;

I am supposing that you have a table named words. If you want the words to be inserted into a multicolumn table the run this one instead

LOAD DATA LOCAL INFILE '/usr/share/dict/words' INTO TABLE words(column);

Replace column with your column name which is of type VARCHAR.

I have found some other online datases too. Most of them are in excel format. You can convert excel files easily into a mysql database. The steps are:

Save the sql file in csv format(you can do that from excel save as dialogue) and then insert this into your table. I have used Sequel Pro to insert the csv into the table. If you face any problem doing this you can ask for details in comment.

And here are some other links where you can find word databases(xls,csv or sql format) too.


Wordlist in source forge sources


Infochimps 350000 Words

And guess what? They are all free. Try all of them to find the one thats suit’s your need. :)

English Words list are needed if you are building applications like Dictionaries or crosswords puzzle or any kind of word games.