CREATE TABLE users (
id SERIAL PRIMARY KEY
fname TEXT NOT NULL,
lname TEXT NOT NULL);
 
INSERT INTO users (fname, lname) VALUES
('James', 'Smith'), ('David', 'Anderson'),
('Christopher', 'Clark'), ('George', 'Wright'),
('Ronald', 'Mitchell'), ('John', 'Johnson'),
('Richard', 'Thomas'), ('Daniel', 'Rodriguez'),
('Kenneth', 'Lopez'), ('Anthony', 'Perez'),
('Robert', 'Williams'), ('Charles', 'Jackson'),
('Paul', 'Lewis'), ('Steven', 'Hill'),
('Kevin', 'Roberts'), ('Michael', 'Jones'),
('Joseph', 'White'), ('Mark', 'Lee'),
('Edward', 'Scott'), ('Jason', 'Turner'),
('William', 'Brown'), ('Thomas', 'Harris'),
('Donald', 'Walker'), ('Brian', 'Green'),
('Jeff', 'Phillips'), ('Mary', 'Davis'),
('Jennifer', 'Martin'), ('Lisa', 'Hall'),
('Sandra', 'Adams'), ('Michelle', 'Campbell'),
('Patricia', 'Miller'), ('Maria', 'Thompson'),
('Nancy', 'Allen'), ('Donna', 'Baker'),
('Laura', 'Parker'), ('Linda', 'Wilson'),
('Susan', 'Garcia'), ('Karen', 'Young'),
('Carol', 'Gonzalez'), ('Sarah', 'Evans'),
('Barbara', 'Moore'), ('Margaret', 'Martinez'),
('Betty', 'Hernandez'), ('Ruth', 'Nelson'),
('Kimberly', 'Edwards'), ('Elizabeth', 'Taylor'),
('Dorothy', 'Robinson'), ('Helen', 'King'),
('Sharon', 'Carter'), ('Deborah', 'Collins'),
('Jürgen', 'Schnitzel'), ('Dāwiḏ', 'Kabbabi'),
('Heiðar', 'Helguson'), ('Boglárka', 'Ladke');

SELECT
	*
FROM
	users
WHERE
	difference(fname, 'Lunda') > 2;
    
| id | fname   | lname  |
|----|---------|--------|
|  9 | Kenneth | Lopez  |
| 36 | Linda   | Wilson |
 
 
SELECT
	*
FROM
	users
WHERE
	difference (fname, 'Jam') > 2;
    
    
| id | fname | lname    |
|----|-------|----------|
|  1 | James | Smith    |
|  6 | John  | Johnson  |
| 25 | Jeff  | Phillips |
| 34 | Donna | Baker    |

SELECT metaphone('Jim Thebob', 4);
SELECT metaphone('Jorgen McJorgensen', 10);
 
 
-- metaphone
-- -----------
-- JM0BB
-- JRJNMKJRJN

SELECT
	*
FROM
	users
WHERE
	levenshtein (dmetaphone_alt (fname), dmetaphone_alt ('David')) < 2
 
| id | fname   | lname    |
|----|---------|----------|
|  2 | David   | Anderson |
| 47 | Dorothy | Robinson |

SELECT daitch_mokotoff('George');
-- daitch_mokotoff
-----------------
-- {595000}
 
SELECT daitch_mokotoff('John');
-- daitch_mokotoff
-- -----------------
-- {160000,460000}
 
SELECT daitch_mokotoff('Bierschbach');
--                      daitch_mokotoff
-- -----------------------------------------------------------
-- {794575,794574,794750,794740,745750,745740,747500,747400}
 
SELECT daitch_mokotoff('Schwartzenegger');
-- daitch_mokotoff
-- -----------------
-- {479465}