SELECT description, SOUNDEX(description) AS SOUNDEX FROM mytable
description                                  SOUNDEX
-------------------------------------------- -------
Promessa High Spirits                        P652
Promessa high Spirits                        P652
Promessa Hgh Spirits                         P652
Promessa high spirits                        P652
And now for something completely different   A530
And now, for something completely different  A530
And now! Something completely different      A530
Something completely different now           S535