building a php search engine, google stlye sugestions?

[blueman378]

hi guys, well as the title says im building a php search engine,

but thats easy what im wanting to do tho is have the google stlye suggestions,

 

ive found a few functions like

levenshtein

but i dont want to have to pull all the results out of the database to run it,

 

so the most promising is

SOUNDEX()

but im wandering does anyone have any better functions they can suggest

 

[Fadion]

My god! Until i checked it at php.net, i thought u re kidding about a levenshtein() function. Pretty weird, but ive never worked on a "smart" search engine, so its normal . Sorry for the offtopic and good luck.

[blueman378]

dont worry i thought the same thing till i did it lol, i was googling and found that function and im jsut like what the? that cant be right but it acctually is,

 

but yeah it will be interesting to see what people suggest for it,

 

as soundex seems like a long way to go

[trq]

Last time I had to do something similar for a client I found this article on phpriot() a great resource.

[blueman378]

hmm i jsut realised i explained myself wrong, i had no idea google acctually had a suggestion thing like that, i more meant:

 

Did you mean: closest search query

 

sorry about the confusion, although i might think of implementing that ither feature later for now im jsut looking for something like this,

 

oh yeah i dont want to have a entire table full of alternate spellings

 

 

cheers

[trq]

Then its likely you'll find mysql's SOUNDS LIKE operator usefull.

[blueman378]

yeah same as soundex(),

 

so im guessing thats the most efficient way of doing it?

[trq]

so im guessing thats the most efficient way of doing it?

 

Using mysql yes. Not php.