| Author |
 Topic  |
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
|
|
tosscrosby
Aged Yak Warrior
USA
676 Posts |
 Posted - 07/22/2008 : 08:43:47
|
Well, hopefully those fine folks aren't out there procreating.....
Terry |
 |
|
|
elancaster
A very urgent SQL Yakette
United Kingdom
1208 Posts |
|
|
elancaster
A very urgent SQL Yakette
United Kingdom
1208 Posts |
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
Posted - 07/24/2008 : 10:53:47
|
so don't answer him
on this forum anyone has a right to be a twit. 
_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
Edited by - spirit1 on 07/24/2008 10:53:57 |
|
|
|
tosscrosby
Aged Yak Warrior
USA
676 Posts |
Posted - 07/24/2008 : 11:14:13
|
quote:
Originally posted by elancaster
this guy is really start to get on my nerves...
http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=39129
Em
Mine too, but I didn't want to call him out yet. I was thinking maybe it was me as I'm having a "not so good" morning and am just a bit irritable so I was trying to "play nice". Obviously, it's not me! 
Terry |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 08/28/2008 : 22:02:55
|
I think this guy is just turning into a parody of himself.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109701
"i want to combine the 2 scripts with an if statement. How can i do it? If you are not familir with this task. do not reply."
CODO ERGO SUM |
|
|
|
jezemine
Flowing Fount of Yak Knowledge
USA
2871 Posts |
|
|
blindman
Flowing Fount of Yak Knowledge
USA
2365 Posts |
Posted - 09/02/2008 : 12:43:38
|
quote:
When tested, the new system failed to find matches for terrorist-suspect names that were spelled slightly different from the name entered into the system, a common challenge when translating names from Arabic to English. It also could not perform basic searches of multiple words connected with terms such as "and" and "or."
Makes me wonder if they are using SOUNDEX.
Should I offer to sell them my fuzzy-search algorithm for a paltry million dollars?
Boycotted Beijing Olympics 2008 |
Edited by - blindman on 09/02/2008 12:44:10 |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 09/02/2008 : 18:10:24
|
Did they consider the possibility that someone might just use a fake name?
I guess they're too busy making sure no one tries to carry more than 2 oz. of mouthwash onto a plane.
CODO ERGO SUM |
|
|
|
jezemine
Flowing Fount of Yak Knowledge
USA
2871 Posts |
Posted - 09/03/2008 : 00:53:36
|
too bad the mouthwash patrols aren't using this db.
then you wouldn't be able to take '2 oz.' but all these would get through:
'2 ounces'
'two ounces'
'two oz.'
elsasoft.org |
|
|
|
Stoad strehngthend
Yak Posting Veteran
54 Posts |
Posted - 09/04/2008 : 12:32:05
|
>blindman:
>my fuzzy-search algorithm
Any link to read about it (your implemention)? If you were not kidding on this
|
|
|
|
blindman
Flowing Fount of Yak Knowledge
USA
2365 Posts |
Posted - 09/04/2008 : 15:00:51
|
Sorry. I've posted this before, but here it is:
http://sqlblindman.googlepages.com/fuzzysearchalgorithm
...but if I find you YOU sold it to them for a million dollars, I'll come looking for you!
Boycotted Beijing Olympics 2008 |
Edited by - blindman on 09/04/2008 15:01:45 |
|
|
|
Stoad strehngthend
Yak Posting Veteran
54 Posts |
Posted - 09/04/2008 : 15:13:51
|
thanks :) I'll study it
==========================
btw a bit related to our subj: http://www.spoj.pl/problems/PRHYME/
I tried it but timelimited. True I did it in Python nonetheless..
Not so easy all it; and I'm very unwilling to rewrite it in C++
|
|
|
|
Stoad strehngthend
Yak Posting Veteran
54 Posts |
Posted - 09/04/2008 : 17:04:03
|
print dbo.CompareText('Alan Smith', 'Alan Smith')
print dbo.CompareText('Alan Smith', 'Smith, Alan J.')
print dbo.CompareText('Alan Smith', 'Alan J. Smith')
print dbo.CompareText('Alan Smith', 'Alan Smith, jr')
100
72
85
81 ----<< to my taste it should be 100
----<< ok after all it's fuzzy :)
----<< it's silently implied that "Alan Smith" has nothing more in it
----<< it's not a prefix; it's a whole name of an orphan that cannot be "juniour"
|
|
|
|
DavidChel
Constraint Violating Yak Guru
USA
474 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 09/05/2008 : 09:09:45
|
Someone has to be first 
I am just lucky I haven't made any mockup yet.
E 12°55'05.63"
N 56°04'39.26" |
Edited by - SwePeso on 09/05/2008 09:11:53 |
|
|
|
blindman
Flowing Fount of Yak Knowledge
USA
2365 Posts |
Posted - 09/05/2008 : 10:33:41
|
Stoad, first of all the function is CompareTEXT, not CompareNAME. As you can see from the code it does not parse the string into name components. It treats it as a single text string, which also allows it to be used for comparing addresses and other strings (such as foreign names that do not follow Western three-part name formats).
Second:
quote:
Originally posted by Stoad strehngthend
print dbo.CompareText('Alan Smith', 'Alan Smith, jr')
81 ----<< to my taste it should be 100
...then your taste would be wrong. When searching for "Alan Smith" you cannot match it 100% against "Alan Smith, jr". There could be an "Alan Smith, Sr" in the database, or even simply another "Alan Smith".
Boycotted Beijing Olympics 2008 |
Edited by - blindman on 09/05/2008 10:35:11 |
|
|
|
Topic |
|
Twit List
