That seems like a solution for a problem that shouldn't exist in the first place.
> a product is renamed, or the logic used to generate the URL changes.
In that case you should store both urls and have a redirect_to_id or something similar to give search engines and users a proper 301. I don't see a use case for this fuzzy matching which will just make things not very explicit and unpredictable.
> a product is renamed, or the logic used to generate the URL changes.
In that case you should store both urls and have a redirect_to_id or something similar to give search engines and users a proper 301. I don't see a use case for this fuzzy matching which will just make things not very explicit and unpredictable.