/**
 * "fuzzy search" to help with searching for profiles
 * @param  string $search   query based on search term
 * @param  string $wp_query query based on entire page (including $search)
 * @return string           sql query for page
 */
function wpse66815_search_query_string( $search, &$wp_query )
{
    if (!is_admin() && is_search()) {

        //print_r($search);

        global $wp_query,$wpdb;

        // get search term
        $search_term = array_shift($wp_query->query_vars['search_terms']);

        // specify string we'll use to replace
        $replace_var = 'TL';

        // find matches for that string
        preg_match_all("/{$replace_var}(?:[^0-9]*)(\d+)/i", $search_term, $out);

        // if there's no matches, return the normal search
        if ( empty($out[0]) )
            return $search;

        //var_dump($out);

        // find/generate the search term with the replacement
        $modified_search_term = preg_replace(
             "/{$replace_var}(?:[^0-9]*)(\d+)/i"
            ,"{$replace_var}-$1"
            ,$search_term
        );

        // combine both the regular and modified search term
        $new_search[] = $search_term;
        $new_search[] = $modified_search_term;

        print_r($new_search[0]);

        // generate the new search query
        $new_string_parts[] = $wpdb->prepare(
             "
                AND ((({$wpdb->posts}.post_title LIKE '%%%s%%')
                OR ({$wpdb->posts}.post_content LIKE '%%%s%%'))
             "
            ,like_escape( $new_search[0] )
            ,like_escape( $new_search[0] )
        );

        $new_string_parts[] = $wpdb->prepare(
             "
                OR (({$wpdb->posts}.post_title LIKE '%%%s%%')
                OR ({$wpdb->posts}.post_content LIKE '%%%s%%')))
             "
            ,like_escape( $new_search[1] )
            ,like_escape( $new_search[1] )
        );

        /*foreach ( $new_search as $keyword)
        {
            if ($keyword === reset($new_search)) {
                $new_string_parts[] = $wpdb->prepare(
                     "
                        AND ((({$wpdb->posts}.post_title LIKE '%%%s%%')
                        OR ({$wpdb->posts}.post_content LIKE '%%%s%%'))
                     "
                    ,like_escape( $keyword )
                    ,like_escape( $keyword )
                );
            }
            elseif ($keyword === end($new_search)) {
                $new_string_parts[] = $wpdb->prepare(
                     "
                        OR (({$wpdb->posts}.post_title LIKE '%%%s%%')
                        OR ({$wpdb->posts}.post_content LIKE '%%%s%%')))
                     "
                    ,like_escape( $keyword )
                    ,like_escape( $keyword )
                );
            }
            else {
                $new_string_parts[] = $wpdb->prepare(
                     "
                        OR (({$wpdb->posts}.post_title LIKE '%%%s%%')
                        OR ({$wpdb->posts}.post_content LIKE '%%%s%%'))
                     "
                    ,like_escape( $keyword )
                    ,like_escape( $keyword )
                );
            }
        }*/

        // set $search equal to results
        $search = implode( " ", $new_string_parts );

        //print_r($search);
    }

    return $search;
}
add_filter('posts_search', 'wpse66815_search_query_string',500,2);