3 Replies - 751 Views - Last Post: 03 February 2019 - 08:36 PM

#1 prkundan   User is offline

  • New D.I.C Head

Reputation: 4
  • View blog
  • Posts: 28
  • Joined: 14-June 18

Phonetic Search

Posted 01 February 2019 - 11:58 PM

In a Search Engine, even if we type something wrong how do they find out the correct word?
Is there any phonetic search?
For instance if in my DBthe word “John” is typed as “Jahn” or “Jan” or “Jon”. While searching I should get all these related entries. Is there any code for it?
Is This A Good Question/Topic? 1
  • +

Replies To: Phonetic Search

#2 andrewsw   User is offline

  • never lube your breaks
  • member icon

Reputation: 6807
  • View blog
  • Posts: 28,143
  • Joined: 12-December 12

Re: Phonetic Search

Posted 02 February 2019 - 02:43 AM

You could start with the SOUNDEX function.
Was This Post Helpful? 2
  • +
  • -

#3 Sheepings   User is offline

  • D.I.C Lover
  • member icon

Reputation: 224
  • View blog
  • Posts: 1,260
  • Joined: 05-December 13

Re: Phonetic Search

Posted 02 February 2019 - 09:26 AM

Its called grammar training. Search engines keep a list of common words, definitions, names and addresses, cities etc. So if you spell something, and the word is compared to a another word, the conditional logic behind it will dictate a suggestion if they almost match, prompting you with; "Did you mean John?". This doesn't really have anything to do with databases or access specifically, and its more about the functions of the code used behind it. Your list of words would be best stored in a file as opposed to a database for best performance and practicality. andrewsw also has a good pointer for starting above.

Edit, I can't spell for sh!t

This post has been edited by Sheepings: 02 February 2019 - 09:27 AM

Was This Post Helpful? 2
  • +
  • -

#4 prkundan   User is offline

  • New D.I.C Head

Reputation: 4
  • View blog
  • Posts: 28
  • Joined: 14-June 18

Re: Phonetic Search

Posted 03 February 2019 - 08:36 PM

View Postandrewsw, on 02 February 2019 - 02:43 AM, said:

You could start with the SOUNDEX function.



Thanks a Lot! GOD BLESS YOU!!!

View Postandrewsw, on 02 February 2019 - 02:43 AM, said:

You could start with the SOUNDEX function.



Thanks a Lot! GOD BLESS YOU!!!
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1