When you create and use word replacements, consider these issues:
Avoid recursive word replacement pairs that can generate inconclusive results.
For example, you need to create word replacements for common variations of a name such as Caroline, Carolyn, Carolan, Carole, and Carol.
This table shows an example of effective word replacement pairings of original and replacement words.
Effective Word Replacement Pairs
| Original Word | Replacement Word |
|---|---|
| Caroline | Carol |
| Carolyn | Carol |
| Carolan | Carol |
| Carole | Carol |
This table shows an example of ineffective word pairings using recursive word replacement.
Ineffective Word Replacement Pairs
| Original Word | Replacement Word |
|---|---|
| Caroline | Carolyn |
| Carolyn | Carolan |
| Carolan | Carole |
| Carole | Carol |
Create word replacement pairs consistent with the type of party information in the word lists for person names, addresses, organization names, or states. For example, if you apply a word replacement pair for a person name to an organization name, Jonathan Deere might be used as a replacement for the company name, John Deere.
Create a limited number of word replacement pairs between person names and organization names.
Because some organizations are named after people, a limited number of common word replacements of person names to organization names can be appropriate. For example, your organization has regular contact with a group of professional firms such as accountants and lawyers. You can create word replacement pairs specifically for these organizations that would match person names to organization names. Word replacement pairs between different types of party information should be limited to reduce inappropriate matches.
Create a limited number of word replacement pairs between address-related words and organization names.
Because some organizations are named after geographical locations, a limited number of word replacements of address elements to organization names can be appropriate. For example, your organization has regular contact with the Main Street Cafe. You can create a word replacement pair specifically for this organization that would match an address element to the organization name. Word replacement pairs between different types of party information should be limited to reduce inappropriate matches.
Consider replacing the original word, or symbol, & with the replacement word and.
Several of the seeded transformations remove symbols such as &, that are not alphanumeric characters. If some form of conjunction is important to your searches, you should replace & with and. You can also avoid or customize the seeded transformations that remove &.
Consider mapping generic address-related words such as street, avenue, and so on to a blank Replacement Word field.
People often know the proper name for an address but might not know the generic portion of the address. For example, you can broaden the search criteria so that both Market Street and Market Avenue are included in the search results as possible matches. By mapping the words street and avenue to a blank Word Replacement field, you would broaden the possible matches.
See: Seeded Word Replacement Lists, Oracle Trading Community Architecture Reference Guide.