Re: How to achieve scalability

OK, here is a quick test on the simil() function done in vba as
follows:

Debug.Print "Start time: " & Now()
For i = 1 To 700000
    score = Simil("The Yummy and Tasty Waffle Cor****ation",
"TASTYWAFFLE")
Next
Debug.Print "Finish time: " & Now()
Debug.Print score

and the results are:
Start time: 4/07/2008 9:19:55 AM
Finish time: 4/07/2008 9:21:13 AM
 0.448979591836735

I would love to run a test with this using SALAD's ShortName function
and see if the score is higher. Unfortunately I am working in A97 at
the moment and dont have the option to work on a newer verion to test
this (no split function). Any takers for the test? I posted a link to
the VBA implementation of the SIMIL() function as the fifth post in
this thread (2nd July 08).

This was done on a Pentium M 1.2Ghz laptop with nothing else running
at the time (or not that I am aware of anyway).

To answer Lyle's "Why Not?" : The difference between probability and
certainty. While ambiguity exists you can only ever assign a
probability that one one thing is another (or equal to another), and
as such there is always a margin of error (a chance they are not the
same). As a result you cannot guarantee 100% effectiveness for any
query of this type where a probabilistic determination is involved.
The best you can do manage / minimise the risks by setting your P
cutoff threshold high enough for the result of the query to be
considered significant enough to be trusted.

Cheers

The Frog