| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-15 : 08:44:55
|
| Richard writes "I've been searching for the specific rules that Microsoft SQL Server is using to return the Soundex code. I would like to replicate the function exactly in VB and for use with Access.Thanks, Richard" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-15 : 08:47:39
|
| Found this:http://www.bluepoof.com/Soundex/info.htmlAnd I'm pretty sure an older computer programming book will have the algorithm.As to whether Microsoft it using the same exact algorithm, I would say "yes" but can't guarantee it. If they changed it you'll have no way of knowing except to test the values it returns against your own version, their code will never be seen by anyone outside of the company. |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2002-08-15 : 20:12:24
|
| Doesn't "The Guru's Guide to SQL Server Stored Procedures, XML, and HTML" by Ken Henderson have a chapter that examines the soundex algorithm and source code? He also suggests some improvements to the algorithm, explains why, and provides the source for the revised version.SamC |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-16 : 08:18:21
|
 Didn't read that part, now, of course, I have to start cover-to-cover again!The thing is that Ken didn't include the EXACT algorithm that the built-in SOUNDEX() uses, which is what Richard is trying to duplicate. By changing it even slightly it won't produce the same results. Unless Richard creates his own SOUNDEX... |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-16 : 08:31:48
|
Rob, do you know carolyn, or did you just pick up the link from a search? I used her FAQ on Carb Syncing my SV650 ... the internet is such a small world...  Jay White{0}Edited by - Page47 on 08/16/2002 08:32:06 |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-16 : 08:43:50
|
| Don't know Carolyn, just popped "soundex algorithm" into Google and her site was first or second on the list.What is Carb Syncing? Sounds like some kind of diet. |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-16 : 09:14:17
|
| Off-Topic:Whenever you have a multicylinder engine, where each cylinder is feed by its own carburetor, you need to syncronize the carbs so the the throttle slides open exactly the same on each throughout its range of movement. Otherwise one cylinder will be doing more work than the other at various throttle openings, causing roughness and performance problems. Most non-fuel injected motorcycle engines allow you to measure vacuum pressure changes in the intake manifolds and make adjustments so that all the carbs operate in sync.If you think databases are cool, you should try tinkering with internal combustion engines. So many things to tweak and play with . . .You've stumbled upon one of the more proficient motorcycle chics on the web with your soundex link....Jay White{0} |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-16 : 09:47:19
|
quote:
If you think databases are cool, you should try tinkering with internal combustion engines. So many things to tweak and play with . . .
So many things to break or install backwards...I've done my time with my first car, a '74 Chevy Impala 2 door, f---ing indestructible (thank god!), leaked a quart of oil a week, I LOVED that car!Most I ever had to do with it was brake pads and replace the starter motor...would've been very nice if Chevy actually DESIGNED the car to allow the starter to be replaced. You might not believe this, but it's really hard to use your hands for ordinary activites when all of the skin has been peeled off of your knuckles. Since then I gladly pay a mechanic to do the work.  VCR's and PC's, now THOSE are some cool hardware to play with! |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-16 : 09:59:20
|
| Making a stored proc run fast pales in comparison to making abike run fast. Jay White{0} |
|
|
|
|
Soundex Rules