NOTE.md

Spellfix1

missing module from mattn/sqlite, need to use mattn/go-sqlite3#1160

1. ensure spellfix is available (likely compile tags)

2. have bookmark table

   • CREATE VIRTUAL TABLE IF NOT EXISTS Bookmarks_vocabulary USING spellfix1

3. populate vocab table with all bookmarks (title, tags, description)

   • will need a 'migration' capability

4. add better ui info showing that we are doing a multi-stage setup process

   • possibly stream in the results if it doesn't happen in time?

Example:

-- User searches: "javascrpt tutorial"
-- 1. FTS5 search (no results)
SELECT * FROM Bookmarks_fts WHERE Bookmarks_fts MATCH 'javascrpt tutorial';
-- 2. Spellfix1 correction
SELECT word FROM spellfix WHERE word MATCH 'javascrpt';  -- returns "javascript"
-- 3. Retry FTS5 with corrected query
SELECT * FROM Bookmarks_fts WHERE Bookmarks_fts MATCH 'javascript tutorial';

func CorrectSpelling(db *DB, query string) string {
    words := strings.Fields(query)
    correctedWords := make([]string, len(words))

    for i, word := range words {
        // Skip operators
        if word == "AND" || word == "OR" || word == "NOT" {
            correctedWords[i] = word
            continue
        }

        // Try to find spelling correction
        var suggestion string
        err := db.QueryRow(`
            SELECT word FROM Bookmarks_vocabulary
            WHERE word MATCH ?
            AND top = 1
            LIMIT 1;
        `, word).Scan(&suggestion)

        if err == nil && suggestion != "" {
            correctedWords[i] = suggestion
        } else {
            correctedWords[i] = word
        }
    }
    return strings.Join(correctedWords, " ")
}

pseudocode:

func AutoCorrectingSearch(db *DB, query string) ([]Bookmark, error) {
    // Tier 1: Try exact FTS match
    results, err := SearchBookmarks(db, query)
    if err == nil && len(results) > 0 {
        return results, nil
    }

    // Tier 2: Try spell correction
    correctedQuery := CorrectSpelling(db, query)

    // Only retry if correction actually changed something
    if correctedQuery != query {
        results, err = SearchBookmarks(db, correctedQuery)
        if err == nil && len(results) > 0 {
            return results, nil
        }
    }

    // Tier 3: do vector search matching

    // Return whatever we have (may be empty)
    return results, err
}