This is an old revision of the document!
Overview | Example | SQL | Optimization | Tips
In this example of PowerSearch, a user is trying to find a person in the database. They were introduced to them as Bill Meyers, but they didn't know the exact spelling of the name. They knew he lived on Fifth Avenue in New York, but they were sure of the zip code. They thought they knew the phone number, but the area code was wrong and the numbers were transposed. They misspelled the email address, but nonetheless, they found who they were looking for.
In this example, each column required a different flexibility as described below:
When searching a database containing first names, you never know whether the formal given name is stored, or one of common variations. PowerSearch will automatically search for common synonyms for first names.
Given Name | Synonyms |
---|---|
William | Bill, Billy, Will, Williams, Willie, Willis, Wilson |
James | Jim, Jimmy, Jimmie, Jay, Jaime, Jacob |
Elizabeth | Beth, Betty, Eliza, Elsa, Lisa, Liz, Liza |
Ann | Ana, Anita, Anna, Anne, Annette, Annie, Annmarie |
See also: