kaz_64 Posted February 12, 2007 Share Posted February 12, 2007 I have created a mysql database of most english words (approx. 102,115) and their metaphone key... this is a function that takes a word and creates a key for it based on how it sounds I am using it to provide some spell checking/spelling suggestion abilities in a search engine I am building. It is roughly 2.2 MB unzipped, 602 Kb zipped. the maximum upload size on the forum is 500 Kb, but I will find some free host to put it on if there is any interest in it. note: this database DOESN'T contain any definitions for the words. tech details: MyISAM, UTF-8 unicode, 26 tables A-Z based off of GCIDE_XML Link to comment https://forums.phpfreaks.com/topic/38117-mysql-dump-of-english-dictionary-and-metaphone-output/ Share on other sites More sharing options...
hackerkts Posted February 13, 2007 Share Posted February 13, 2007 There's alot free hosting that allow big size file, example http://www.mediafire.com/ Link to comment https://forums.phpfreaks.com/topic/38117-mysql-dump-of-english-dictionary-and-metaphone-output/#findComment-183993 Share on other sites More sharing options...
fert Posted February 14, 2007 Share Posted February 14, 2007 there already is a php spelling extension Link to comment https://forums.phpfreaks.com/topic/38117-mysql-dump-of-english-dictionary-and-metaphone-output/#findComment-184163 Share on other sites More sharing options...
kaz_64 Posted February 14, 2007 Author Share Posted February 14, 2007 yes, i know that php has aspell extentions, but i hadn't been able to find any benchmarks for it and this application i'm developing would be a high trafic one... i have yet to compare them Link to comment https://forums.phpfreaks.com/topic/38117-mysql-dump-of-english-dictionary-and-metaphone-output/#findComment-184342 Share on other sites More sharing options...
TreeNode Posted February 15, 2007 Share Posted February 15, 2007 I'm VERY interested in this, please send me a PM (as I can't right now, I'm a noob on this MB). Thanks. Link to comment https://forums.phpfreaks.com/topic/38117-mysql-dump-of-english-dictionary-and-metaphone-output/#findComment-185680 Share on other sites More sharing options...
Azu Posted March 5, 2007 Share Posted March 5, 2007 Hi, I'm intested in this to. And I'm wandering, does it list what type of word it is? E.G. verb noun etc? Or is it just a huge list of words? Link to comment https://forums.phpfreaks.com/topic/38117-mysql-dump-of-english-dictionary-and-metaphone-output/#findComment-200278 Share on other sites More sharing options...
apaezp Posted July 12, 2008 Share Posted July 12, 2008 I am also starting a metaphone feature for a search engine and I would like to get your tables. Please send them to apaezp at gmail dot com Link to comment https://forums.phpfreaks.com/topic/38117-mysql-dump-of-english-dictionary-and-metaphone-output/#findComment-588340 Share on other sites More sharing options...
corbin Posted July 13, 2008 Share Posted July 13, 2008 kaz_64 "Last Active: February 13, 2007, 10:41:22 PM" Good luck with that apaezp. Link to comment https://forums.phpfreaks.com/topic/38117-mysql-dump-of-english-dictionary-and-metaphone-output/#findComment-588753 Share on other sites More sharing options...
veejay Posted September 14, 2009 Share Posted September 14, 2009 Hello kaz_64 I would like to have the tables you have made. Thanks. VJ Link to comment https://forums.phpfreaks.com/topic/38117-mysql-dump-of-english-dictionary-and-metaphone-output/#findComment-918190 Share on other sites More sharing options...
DEVILofDARKNESS Posted September 17, 2009 Share Posted September 17, 2009 kaz_64 "Last Active: February 13, 2007, 10:41:22 PM" Good luck with that apaezp. @Veejay Which part of the sentence above you don't get? Link to comment https://forums.phpfreaks.com/topic/38117-mysql-dump-of-english-dictionary-and-metaphone-output/#findComment-920210 Share on other sites More sharing options...
Recommended Posts