Pesquisa simples através do like no SQL buscando com caracteres coringas.

TesteLike.sql

USE MASTER
GO
IF(SELECT Count(name) FROM sys.databases WHERE name = 'TESTELike')=1
	BEGIN
		ALTER DATABASE TESTELike SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
		DROP DATABASE TESTELike;
	END
GO
CREATE DATABASE TESTELike
GO
USE TESTELike
GO
CREATE TABLE Nomes
(
	ID	INT		IDENTITY(1,1) PRIMARY KEY,
	Nome	VARCHAR(100) 	NOT NULL
);
INSERT INTO Nomes(Nome)
	VALUES ('Fabio'),('Fábio'),('Nome3'),('Nome4');

SELECT * FROM Nomes WHERE Nome LIKE 'F[a,á]bio';