[Tutorial] [4.0+] For beginners – SQLite Database Browser to modify Google dictionary

For beginners – How to use SQLite Database Browser to change Google Keyboard Dictionary

• Place the user_dict.db file in the PC


• Download SQLite Database Browser to the PC (http://portableapps.com/apps/develop...owser_portable)


• Open the EXE file, and run


• You will be presented with this page:

• Click Open Database. There will be two tables, i.e. “android_metadata” and “words”


• Click Browse Data

• Choose “words” from the Table (pulldown menu)

The content of the dictionary will be displayed. This “words” table (with the letter s) has 6 fields:

• _id for indexing


• word, the word


• frequency, max 255, that is supposed to mean the most used choice. Lower figures mean more rare occurrence. So if one word that you seldom use keep popping up, change this to 100 or 10 or whatever.


• locale: words considered system dictionary has the “null” notation. En_US means US English. This can be changed to null easily.


• appid: don’t really know about this


• shortcut: your shortcut

Just double click the record to change its value.




Typing certain letters in the FILTER will instantly show filtered records.
Try entering this :

• hami% --> will show “hamil”, “hamili”, “hamilnya”. But not “kehamilan”. To show the later, type %hami%


• ___ (three underscore, garis bawah) --> will show all words that consist of the three letters, One underscore is a subtitute of one letter.

Click on Execute SQL to write full SQL commands. Below, the command produces the same result as the filtered records above.

• For locale, the value is "null" or "en_US" (without the quotes). This command shows all records with en_US value.


• In practice, either value is OK; no difference in practice.


• For frequency, the value is 0 to 255, with 255 means as the most often used word.

• For Updating (changing values of) the database, use update command. Remember the table name is “words”, and the field name is “word”


• For deleting, use the command “DELETE FROM words WHERE ….”


• See SQL programming tutorial for further study but I guess updating and deleting is enough for the purpose of modifying the dictionary.


• You may want to learn how to “import” if you have a lot of words to insert.