• In the NYSIIS algorithm I am getting what I believe is an incorrect result.  The algorithm states:

    1.Transcode first characters of name:

    MAC»MCC
    KN»NN
    K»C
    PH»FF
    PF»FF
    SCH»SSS

    But in my results, it doesn't look like the K is being replaced.

    select

    dbo.fn_phon_nysiis('Karen'), dbo.fn_phon_nysiis('Caren')

     

    -------- --------

    KARAN CARAN

    (1 row(s) affected)