>I need to sort out the records by similairity of 4 fields, eg.

field1 field2 field3 field4
   1      2      3      4
   0      5      6      4
   5      3      4      2
   5      6      7      8
so, the sort result sould be
   1      2      3      4
   5      3      4      2 Because 2,3,4 match 1st record, 3 similairity
   0      5      6      4 Because 5,4 match 2nd record
   5      6      7      8 because 5,6 match 3th record

>Anyone have solution for this.

In your example, it appears that each of your four fields can contain a value in the range 0 to 8.
1. What is the actual range of values?
2. What is the data type of the four fields (and size if character)?
3. Do you also have a field that is Primary (if yes what is it)?