## Syntax ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR Start((START)) --> DMETAPHONE_ALT[DMETAPHONE_ALT]:::quoted DMETAPHONE_ALT --> End((END)) ``` ## Purpose The `DMETAPHONE_ALT` SQL function converts a value to the alternative Metaphone code as defined on [Wikipedia](https://en.wikipedia.org/wiki/Metaphone). Parameters: - Input (`varchar2`): value to convert to the alternative double metaphone. Returns: the four character alternative double metaphone of the input as a `varchar2`. ## Examples The following example retrieves the alternative double metaphone of `fabulous`: ```sql select dmetaphone_alt('fabulous') ------------------- FPLS ``` The following example retrieves the alternative double metaphone of `success`: ```sql select dmetaphone_alt('success') ------------------- SKSS ```