def get_keyword_query(keyword):
    """
    Generate the corresponding SQL Statement and SQL parameters for query the watchlist DB
    :param keyword:
    :return: the statement and statement parameters
    """
    sql_parameters = [{'name': 'input_keyword', 'value': {'stringValue': "{0}".format(keyword)}}]
    statement = "SELECT * FROM  watchlist WHERE soundex(lower(entity)) = soundex(lower(:input_keyword)) " \
                "union " \
                "SELECT * FROM  watchlist WHERE levenshtein_less_equal(lower(entity), lower(:input_keyword),2) <=2"
    return statement, sql_parameters