When performing a searching using a constituent lookup ID and the 'Include fuzzy search on name' check box is enabled many unrelated records are returned

When searching for constituents there is a search option for "Include fuzzy search on name."  This should return constituents with names that sound like the search criteria entered. For example, if you select this checkbox and enter a last name of “Smith”, the program includes constituents named “Smyth” in the results.  However, when only the constituent ID is specified, it appears to be giving any records that contain numeric values in their name.
When doing a fuzzy search, the following SQL is added to the where clause:

(CONSTITUENT.KEYNAME like @QUICKFINDKEYNAME escape ''\''
or soundex(CONSTITUENT.KEYNAME) = soundex(@QUICKFINDKEYNAME)

@QUICKFINDKEYNAME is set to the lookup ID with %: '8-123456%'

The soundex converts names to its alphanumeric value and some of the last names may cause matches to happen if the KEYNAME is nothing but numbers.

Steps to Duplicate

1. Go to Constituents > Constituent Search
2. Enter a Lookup ID in the field
3. Select Advanced options and check the box for 'Include fuzzy search on name'
4. Click search

 

Environment

 Blackbaud CRM
 4.0

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.