Fuzzy numeric search in AI Search
Summarize
Summary of Fuzzy numeric search in AI Search
Fuzzy numeric search in AI Search enables ServiceNow customers to find indexed records by their Number field values without requiring alphabetic prefixes or leading zeroes. This feature improves search accuracy by matching numerical search terms to records indexed with Number fields, ignoring any alphabetical prefixes and leading zeroes. It applies to numbered tables with Number fields defined in the Number [sysnumber] table and does not work with child tables inheriting Number fields or custom numeric fields with different names.
Show less
Key Features
- Numeric-only search terms: Fuzzy numeric search activates only for all-numeric search inputs, ignoring terms containing alphabetic characters.
- Ignores leading zeroes: For example, searching for "07295" matches records indexed as "7295".
- Matches only Number field values: The search matches indexed Number field values, not occurrences of those numbers in record text.
- Strict substring matching: Numeric searches match only when the numeric substring corresponds to the final digits of the record’s Number field value.
- Supports combined queries: When combined with AND/OR operators, fuzzy numeric search works alongside textual terms to refine results.
Practical Examples
- A search for 23583 returns records like knowledge article KB00023583 and problem PRB00023583.
- A search for 05638 will match records with Number fields KB0005638 and PRB0005638.
- Combined numeric and text queries, such as 2541 828, return records containing both numbers as whole terms, respecting AND/OR operators.
Activation and Availability
Fuzzy numeric search is deactivated by default and must be activated by a ServiceNow AI Platform® administrator. Once activated, it enhances search accuracy for records with numbered tables by matching numeric search terms flexibly.
Fuzzy numeric search lets you find indexed records by their Number field values without needing to enter alphabetic prefixes or leading zeroes.
Fuzzy numeric search overview
Fuzzy numeric search in AI Search allows your numerical search terms to match indexed ServiceNow AI Platform® records by their Number field values. The fuzzy matching compares the numeric search term with each indexed record's Number, ignoring its alphabetical prefix and any leading zeroes. As an example, if you index knowledge article and problem records, a search for 23583 might return knowledge article KB00023583 and problem PRB00023583 as search results.
Fuzzy numeric search only searches records from numbered tables. These are tables with Number fields that have prefixes defined in the Number [sys_number] table. To learn about record numbering and the Number table, see Record numbering.
Child tables that inherit the Number field from their parent table can't be searched using fuzzy numeric search. Only tables that have their own Number field defined work with this feature.
Fuzzy numeric search only finds numeric field values in predefined fields named number. It doesn't search custom fields or predefined fields with other names.
Fuzzy numeric matching behavior
| Fuzzy numeric matching behavior | Description |
|---|---|
| AI Search only checks all-numeric search terms for fuzzy matches | A search for KB52578 doesn't match knowledge article KB00052578 because the search term includes non-numeric characters. If you search for 16867 test, your all-numeric 16867 search term is checked for fuzzy numeric matches, but your non-numeric test search term isn't. |
| Fuzzy numeric matching ignores leading zeroes in all-numeric search terms | A search for 07295 returns the same fuzzy numeric matches as a search for 7295 (without the leading zero) does. |
| Fuzzy numeric search only matches Number field values from indexed records | A search for 28761 matches the knowledge article with Number field value KB00028761, but it doesn't match the term KB00028761 if it occurs in the text of other knowledge articles. |
| Fuzzy numeric matching only ignores alphabetical prefixes and leading zeroes in record Number field values | A search for 729 matches knowledge article KB00000729, but doesn't match article KB00003729 because its Number field value has a non-zero digit before the matching substring. |
| To be a fuzzy match, a numeric substring must match the final digits of a record's Number field value | A search for 1164 matches knowledge article KB00001164, but doesn't match article KB00116497 because its Number field value includes digits after the matching substring. |
Examples of fuzzy numeric search
| Search | Search results |
|---|---|
| 73492 | Search matches these results:
|
| 05638 | Search matches these results:
|
| 2541 828 | Search matches these results when using the AND (conjunctive) operator:
Search matches these results when using the OR (disjunctive) operator:
Note: For more details on the AND and OR operators, see the description of the glide.ais.query.search_operator system property in AI Search system properties. |
| model 9433 | Search matches these results when using the AND (conjunctive) operator:
Search matches these results when using the OR (disjunctive) operator:
Note: For more details on the AND and OR operators, see the description of the glide.ais.query.search_operator system property in AI Search system properties. |
Fuzzy numeric search availability
Fuzzy numeric search is deactivated by default. It's only available at search time if your ServiceNow AI Platform® admin has activated it. To view activation steps for this feature, see Activate fuzzy numeric search in AI Search.