If it's going via MS SQL, have a look at SOUNDEX, it will compare two things, then DIFFERENCE will give you a difference score, most commonly used to show how close a search match is, but should work fine for this also.
Regards Dale Fraser -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Tuesday, 1 July 2008 4:20 PM To: [email protected] Subject: [cfaussie] Text change percentage or score Does anyone know of a method where you can calculate either by percentage or score or something as to how much a string has changed? For example: 1) Hi my name is Steve 2) Hi my name is John Only the name has changed to the actual percentage change would be low, like 20% Or.... 1) Hi my name is Steve 2) The cow jumped over the moon The percentage change would be high, like 100% Steve --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
