AnsweredAssumed Answered

Multi string matching in Productnames

Question asked by firebase on Feb 25, 2017
Latest reply on Feb 27, 2017 by philmodjunk

I am trying to find a solution to find product names in long product link lists.

 

For example I search for

 

    BMW 420d xD Grand Coupe

 

and in this long link list there are three more or less fitting entry like

 

    BMW 420d xD Coupe used

    BMW 430d xD Grand Coupe white

    BMW 420d xD Caprio black, new

 

And a few other that are no so close, but simular, like

    BMW 330d red

 

Also there can be even more other words of variations of the exact naming I search for. like used, new, KW, color what ever a car can have, or instead of xD it could be xDrive which is 4 wheel.

 

Does anyone have any strategies or HowTos or examples where I can start to find a solution?

 

I am using the MBS Plug-in and tried these functions

Text.LevenshteinDistance

Text.JaroWinklerDistance

 

So far but with not much luck.

 

After some time I thought if i maybe could load these lists into some Google Service and use their API, but which???

Outcomes