Improving a SOUNDEX search

May 21, 2008

We were recently working on a project for a client and needed to be able to provide a useful search of the products database. In addition, we wanted to catch some common misspellings. My first thought was that this was going to be simple - just use a quick SOUNDEX() in MySQL. I've done this a million times and it works great. Generally when I've used it, it's been to find potential duplicates, etc. Let's take a look at that...When looking for potential dupli

Read Full Article >>

Latest News

Sep 10, 2008 - Creative Anvil Presents at Internet Marketing Seminar
Creative Anvil Partner Joe Koenig will present at a seminar on Internet Marketing this week. Th... Read More »
Sep 07, 2008 - Pay-per-click and SEO are different...
I've been noticing some disturbing happening in the Search Engine Optimization market. As w... Read More »
Sep 05, 2008 - Twitter added nofollow to “www.” links in their Bio field
Yesterday John Battelle emailed me to ask about Rae’s post. This will be a little inside ... Read More »
Sep 02, 2008 - Creative Anvil welcomes Dalco Home Remodeling
Creative Anvil is happy to welcome Dalco Home Remodeling to our growing list of clients. Creati... Read More »
Sep 01, 2008 - Get Ready for Google Chrome: New Open-Source Web Browser
Google just officially confirmed that it will release a new open-source web browser, called Goo... Read More »
Aug 27, 2008 - Creative Anvil Launches New Web Site for Network 1 Communications
Creative Anvil recently launched a new web site for Network 1 Communications. Network 1 Communi... Read More »
Aug 25, 2008 - Three tips for “company blogging”
This is my personal blog. I don’t run my draft posts by Google’s PR or legal team, ... Read More »
Aug 15, 2008 - Creative Anvil Welcomes Maryville University
Creative Anvil is excited to welcome Maryville University to our client roster. We have been co... Read More »
Aug 12, 2008 - Microsoft Ad Center Doesn't Work on a Mac
I was recently setting up a new account for a new Pay-Per-Click client in Microsoft AdCenter. W... Read More »
Jul 24, 2008 - New Toolbar PageRanks coming
Hey folks, I wanted to let you know that new toolbar PageRank values should become visible over... Read More »
Jul 19, 2008 - Generic Toolbar Indexing Debunk Post
Sometimes people think that the Google Toolbar led to Google indexing a page. Here’s a re... Read More »
Jul 01, 2008 - Google gets better at Flash with Adobe’s help
If you haven’t seen the official posts, Adobe has been working to make Flash more index-a... Read More »
Jun 29, 2008 - Free search engine optimization tips for beginners
Jefferson Graham didn’t just write an article of free SEO tips — he also brought hi... Read More »
Jun 23, 2008 - Short article of free SEO tips
Jefferson Graham of USA Today stopped by the Googleplex a little while ago and we talked about ... Read More »
Jun 20, 2008 - Google Trends for Websites
If you’re a site owner, webmaster, SEO, or otherwise have an interest in website metrics,... Read More »
Jun 17, 2008 - Happy “Download Firefox” Day!
Most people that read my blog know that I really, really like Firefox. I put on a temporary Fir... Read More »
Jun 17, 2008 - Two search tidbits
At SMX a couple weeks ago Eric Enge and I did a 20-25 minute interview. The interview transcrip... Read More »
Jun 16, 2008 - Check your search box for XSS exploits
Just a quick reminder that websites should check for XSS holes on their site, especially freefo... Read More »
Jun 13, 2008 - Don’t end your urls with .exe
Sometimes at a conference people will ask me “Does it matter what extension I use for my ... Read More »
Jun 13, 2008 - Be Wary of Cheap, Guaranteed Search Engine Optimization...
Most professionals in the search engine optimization business are hesitant to give any sort of ... Read More »
Jun 03, 2008 - Improved SEO documentation galore!
One of the wonderful things about a search conference like SMX Advanced is that it gives us a c... Read More »
Jun 01, 2008 - When your USB thumb drive doesn’t show up in XP
Start->Run and type “diskmgmt.msc” then right-click the drive and select “... Read More »
May 25, 2008 - Helping hacked sites
(I’m taking my wife somewhere really soon, so I’m just going to dash out a quick po... Read More »
May 21, 2008 - Improving a SOUNDEX search
We were recently working on a project for a client and needed to be able to provide a useful se... Read More »
May 21, 2008 - How To Create an iSCSI SAN using Heartbeat, DRBD, and OCFS2
OverviewA client had a need recently for a Storage Area Network (SAN). We were expanding the sy... Read More »
May 21, 2008 - Convert a Word Document to PDF Using Java
I had a need today to convert a Word Document to a PDF using Java. This needed to be an automat... Read More »
May 21, 2008 - The Anatomy of a SQL Injection
We had a client recently come to us to add something onto a project that another developer had ... Read More »
May 21, 2008 - The Cure for Content-Delay Syndrome
Clients love to write copy. Well, they love to plan to write it, anyhow. On most web design pro... Read More »
May 21, 2008 - SEO Guide for Designers
According to a poll I conducted, just over 1 out of 10 people don’t think SEO (Search Eng... Read More »
May 20, 2008 - Creative Anvil Launches New Kopytek Website
Creative Anvil launches exciting new online presence for Kopytek Inc. The site is a step forwar... Read More »
May 19, 2008 - Lee BioSolutions Launches New Website
Creative Anvil recently launched an updated web site for Lee BioSolutions, specialists in the d... Read More »
Mar 06, 2008 - Creative Anvil to Present at Upcoming AMA/EDC Event
Joe Koenig, Creative Anvil Partner, will be presenting at an upcoming event titled "Curren... Read More »
Feb 01, 2008 - Creative Anvil Welcomes New Partner
For Immediate Release Creative Anvil welcomes new partner and enhances company services Jo... Read More »