Start a new topic

Total Recall, subsegment matching, fuzziness and Kevin Flanagan’s ‘Lift’.

Hi Igor,

OK, I have a question, which came about in connection with a discussion that is currently going on over at Proz about the new Lift technology, and Total Recall.

It basically boils down to this: how does subsegment matching in CafeTran relate to, or work in 9if it does), Total Recall? 

Hans (van den Broek) and I have been trying to understand it in the forum discussion above. Hans says that since the TR database is SQLite, it cannot apply fuzziness in its operations. I am not sure, or at any rate, don't have a clue.

If you look at my post titled " here’s an example of what I mean (CafeTran LIFTing)" (which is here:, you'll see that there seems to be some subsegment matching (and hence fuzziness) in my example screenshots. However, how is this possible?

Sorry if my question is not very well posed. I'm a bit short on time, as usual.


Keep getting this error:

OK, enough playing around. Got to switch all this nonsense off and make some actual money for a few hours.

I was wondering what Michael was doing - I always wonder what on earth he's doing - and then I realised he's using the TM_Lookup database, rather than the CT database.

A few remarks on databases may be useful.

  1. You can't create a database in CT. Igor did that for us. You can find it in the package, in /Applications/ (Mac, something similar for other OSes)
  2. As Martin found out, if it's not there, you can't create it, so you can't use it. That makes sense. The solution I didn't think of is very simple, just download CT again (the full version,the update won't contain a SQLiteMemoryBase.db for the very simple reason that it would delete an existing DB), and copy the  db to the path mentioned above. And delete the other downloaded files.
  3. The (field) options for the CT DB are limited to the ones mentioned in Edit | Options
  4. You can't create a DB in CT, but you can create tables, including for different language pairs. See the KB.
  5. You can only use table related SQL commands and queries
  6. You can connect to other databases like TM-Lookup, or one you created yourself. Just enter jdbc:sqlite:PathToYour.DB in Edit | Options | Database | Database Connection | Connection URL


7. You can recall more than 1 table...

... and assign different priorities to the resulting TMs. I don't know if you can do that with fields (rather than tables), like context General and context Automative, for example.


8. To search for phrases in a table, use quotes.


Two more articles on Total Recall which explain the storage and retrieval of the segments to the working memory:



Am I right when I say

  • You can't Recall a whole DB (unless it consists of one table only)
  • You can only filter (on context, for example) after extracting the TM. In other words, you can't filter the table in CT before you run Recall


Hi Hans,

  • You can recall the whole base by selecting "All tables" in Total Recall options.
  • You can filter the table before you run Recall. Please see:


Terima kasih, terima kasih, terima kasih.


Login to post a comment