Siebel performing phonetic search on an Oracle table
Hi all,
IHAC who needs to perform phonetic searches from Siebel to an external “address master table” (search for street names that sound similar to a given street name).
Currently they perform the queries using a service. This service is able to perform Siebel-like queries (*, ?, like), but they want to improve the functionality and also perform phonetic searches.
Restrictions:
- The phonetic search must work for PTB (Brazilian Portuguese). We thought about using SOUNDSLIKE/SOUNDEX but they are suit to English
- UCM is not an option, as the customer wants to keep this master table as THE master table for all applications