Thanks for all of the great ideas :) Plently of techniques to work on there.
Just incase your interested, i woke up this morning and all the words finally made it into sqlite :) It took over 8 hours, so if anyone could tell me a text command that would do this same task of importing a txt file into a table through the sqlite3 command line that would be great. It must be the gui slowing it down somehow. Anyway, i ran the like query using heaps of different combinations of letters and the results are returned instantly :) More than fast enough for my purposes but i will definately check out some of the other methods just for fun :) It seems we under estimated sqlites speed for this task. Anyway, thanks again for all your replies, now i have to figure out how to sort through the resulted word list and score each letter with certain points to find the highest scoring words. Incase you haven't guessed, it is for a scrabble AI project. Am trying to make an AI player in scrabble that finds the highest scoring word with given tiles and pattern recognition of the words that are on the board. In other words, i am trying to clone this site: http://www.scrabblewordfinder.com/ Cheers :) -- View this message in context: http://www.nabble.com/Need-sql-query-help-t1844399.html#a5040314 Sent from the SQLite forum at Nabble.com.
