Find similar records

[eberhardteduard]

Hi,

I need to find similar records in my database.

The objective is to tell which orders are identical or have maximum 1 different product.

example:

order1 has products A,B,C,D

order2 has products A,C,D

I need to tell order1 is similar to order2. I have 4000 products codes.

Tks in advance,