coderchris.com

This article is interesting:

http://lamp.codeproject.com/KB/recipes/soundslike.aspx

Combining methods to better search for words that sound like other words when searching a MySQL database

This kind of idea can be quite handy when combining feeds of data from different sources.

For example feed x may tell you the specifications of a product, feed y may tell you the the purchase information for a product and each feed may come from a different source e.g. feed y may come from a manufacturer and feed y may come from an affiliate network.

If the manufacture has a slightly different name for the product to the affiliate network (in this example), and the name is the only possible field on which to combine the data sources then it may be difficult to associate the two entries.

Methods such as the one illustrated allow us to make an varying levels of intelligent guess of what matches up with what, and as such can massively assist what could otherwise end up being an entirely manual matching process.

Related posts on coderchris.com:

1. Handling CType Data With SimpleXML in PHP
   If you're new to SimpleXML then the output and representation of complex XML data produced...
2. Personal Papers
   Not everyone has, or wants to have a device that they can read rss feeds...
3. Webservices and the Curse of Email
   It always amazes me how little secure and reliable communication methods are implemented by companies...
4. ctype_digit rtfm!
   For the last 5-10 minutes I've been wondering why a check on a variable which...
5. Some useful news from the WASC
   The Web Application Security Consortium (WASC) is pleased to announce the inital release of data...