We are working on a project which aggregates product information from
different sources. So title of the product can vary from merchant to
merchant.
For example let's say
Merchant A has a product called "Staedtler ergosoft 157 SB24 Coloured
Pencils Box 24"
Same product exists on Merchant B as "Staedtler 157 SB24 ergosoft
Pencils 24-Box"
As you can see there are some words missing and some of the words are
in different places.
I was wondering what is the best way to define the schema which will
return these two products when user searches for "Staedtler SB24 24
box"
Thanks
--