This command that can be used in DB browser for SQLite in the tab "Execute SQL" can be very useful to translate words repeated in the translation file. First the English column must be duplicated and renamed as your translated language. Do also a backup of the file.
UPDATE translation SET language = replace( language, "OriginalString", "TranslatedString");
For Example, to translate IN ALL CELLS the string "Buying price:" in "Prezzo di Acquisto:" (italian translation) you can use this command:
UPDATE translation SET italiano = replace( italiano, "Buying price:", "Prezzo di Acquisto:");
I hope this can be useful to speed up all other translations!