We help IT Professionals succeed at work.
Get Started

Fuzzy search (same as Google) on Oracle or Sybase?

tonikaram asked
Last Modified: 2013-12-12
Is there an easy code, known mechanism, or, if all else fails, an added product that can perform an "intelligent" fuzzy search same as the one Google does, inside Oracle, and/or Sybase? I find the Google very effective, particularly because if it finds a slightly different spelling has a bigger number of records, not only does it show them, but it suggests the new spelling ("did you mean Sarkozy?" when searching for Sarkozi).

I am proficient with SQL, and I found that, on Sybase at least, just a search of many words with an "OR" between them is half a page of coding in SQL, let alone doing anything fuzzy.

This is for an application that will have a form as a user interface on an Oracle Recrods Database or an Oracle normal database, or a Sybase database.
For example, since the content will be arabic, a search for "Kamel" should return all the following:
- Alkamel
- Elkamell
- Al Kamel
- El Kamel
- AlKamal
- ElKamal
- Al Kamal
- El Kamal

As well as more words (dash instead of space, etc), and especially, if there are thousands records with one particular spelling that is very different too, such as El Kemaaaal, then let it return it too, or suggest it.

I am not the person who will program this, but I will the specifications.

Thanks for your very useful answers.
Watch Question
This problem has been solved!
Unlock 3 Answers and 7 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE