Search algorithm Soundlike: Regarding the clean-up of the nameless assets, a special search algorithm had to be developed, which can assign names of account holders not according to their spelling, but according to the sound of the name. For this purpose, a Microsoft Access application was developed which had a special search algorithm that is able to generate the search results by calculation. The application was implemented using Microsoft Access, VBA and SQL.

• The international pressure on major Swiss banks with regard to nameless assets is increasing.
• UBS AG decides to implement an application to search for unnamed assets (fuzzy Soundex search).
• This application should be implemented as simply as possible (RAD).
• The approach is not based directly on the graphic representation of a word, but rather strings that sound the same are searched for - the phonetic search.
• A well-known method in this context that indexes words according to their sound is called the "Soundex algorithm" in English.
• An application is being developed using Microsoft Access and Microsoft Visual Basic for Application, which can search tables of the mainframe systems for specific specifications.
• Requirement Engineering
• Create a data model using Dezign
• Implementation of customer requirements using Microsoft Access 2.0
• Microsoft Visual Basic for Application
• Testing and documentation (user and technical).