Fuzzy numeric search in AI Search
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.