我不知道这会有多慢，但我认为它可以改进。

from sqlalchemy import (
    create_engine,
    Integer,
    String,
)
from sqlalchemy.schema import (
    Column,
)
from sqlalchemy.sql import select, func, or_
from sqlalchemy.orm import declarative_base
from sqlalchemy.orm import Session

Base = declarative_base()

engine = create_engine("sqlite://", echo=True)

class Result(Base):
    __tablename__ = 'results'
    id = Column(Integer, primary_key=True, index=True)
    text = Column(String)


Base.metadata.create_all(engine)

should_match = ["This is first example. This will continue...", "Let us continue the example", "Continue reading example!!"]
should_not_match = ["To be continued but not matched", "Not a match", "Not matching again...."]
with Session(engine) as session:
    for text in should_match:
        session.add(Result(text=text))
    for text in should_not_match:
        session.add(Result(text=text))
    session.commit()

with Session(engine) as session:
    keywords = ["continue", "example"]
    and_args = []
    for keyword in keywords:
        and_args.append(Result.text.ilike(f'%{keyword}%'))
    stmt = select(Result.text).where(*and_args).subquery()
    to_replace = [".", ",", "?", ",", "!"]
    cond = stmt.c.text
    for sub in to_replace:
        cond = func.replace(cond, sub, " ")
    and_args = []
    for keyword in keywords:
        start_cond = cond.ilike(keyword+" %")
        middle_cond = cond.ilike("% "+keyword+" %")
        end_cond = cond.ilike("% "+keyword)
        and_args.append(or_(start_cond, middle_cond, end_cond))
    stmt2 = select(stmt.c.text).where(*and_args)
    matches = [r for r in session.execute(stmt2).scalars()]
    assert len(matches) == len(should_match), str(matches)