database with more than a million items

Hi guys, I have a problem that I don’t know how to tackle. I have a database with more than a million items with the following issue, for example: coca, coca cola, coca 1lt, coca cola 1lt, cocacola lt, coca 1.0lt, coca cola bott., coca cola bott.1, coca cola bott.1lt. This applies to a thousand types of items, and I should be able to associate them with ‘coca cola 1lt’ and so on for all the other items. How can I address this issue? Thanks a lot