Re: [sqlite] Fuzzy Matching

I cant go into too much detail because of my current job, but for fuzzy matching levenstien isnt very good, you need to try looking into ngram matching techniques, it is absolutely awesome in reducing over/under matches.   Woody --- On Sat, 7/5/08, Stephen Woodbridge <[EMAIL PROTECTED]> wrote:

[sqlite] is there a way to escape a '-' in FTS match syntax?

Is there a way to escape the negatory syntax (the minus sign / dash) in FTS MATCH syntax? I found that if I enclose the search term in quotes (ie. "T-Bone"), FTS does not treat the minus sign as a exclusion from the search. I was just wondering if there is another way that does not require me to

Re: [sqlite] Fuzzy Matching

Stephen Woodbridge wrote: > I would be interested in having something like this also. > > What I don't understand in your approach is how you compute the > (Levenstein) distance during a search. It seems like you have a fixed > set of tokens from your document text and these are indexed. Then

Re: [sqlite] Fuzzy Matching

I would be interested in having something like this also. What I don't understand in your approach is how you compute the (Levenstein) distance during a search. It seems like you have a fixed set of tokens from your document text and these are indexed. Then you have a query token the you want

Re: [sqlite] rtree module crashes

Hi Dan, sorry, but I do not have any access to the page, I think. Hartwig Am 04.07.2008 um 17:00 schrieb Dan: > > On Jul 4, 2008, at 9:24 PM, Hartwig Wiesmann wrote: > >> Hi, >> >> I posted a while ago the mail attached below but did not receive any >> answer. If there is any better place to

Re: [sqlite] validate SQL Statement

>From the manual, doesnt sqlite3_prepare do the following: "To execute an SQL query, it must first be compiled into a byte-code program using one of these routines." If you are really paranoid, what about taking the input SQL statement x and then verifying it by issuing: sqlite3_prepare("EXPLAIN

[sqlite] Trying to free not allocated memory while Insert

Hi , I am working in Sqlite 3.3.6 source files. I tried to insert one record and I found that sqlite3GenericFree (p) is called. But that address is not allocated using sqlite3GenericMalloc (int n). Is this Correct.Kindly clarify. Will all memory gets allocated and freed inside os_common.h or at