Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “psycho” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

75 similar words found! Changes to Transform each Found Word to your word are shown as:
~~remove a letter~~ ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
psycho	16	7	453	(None)
psych	15	5	496	1	psych_
psyche	16	7	429	1	psyche
psychos	17	6	526	1	psychos
psychs	16	5	365	1	psychs
poncho	13	33	1012	2	poncho
psyched	18	4	391	2	psyched
psyches	17	5	580	2	psyches
psychic	19	4	483	2	psychic
ancho	10	45	1530	3	_ancho
concho	13	44	1426	3	concho
cyclo	12	3	770	3	_cyclo
echo	9	66	1595	3	__echo
gaucho	12	5	622	3	gaucho
honcho	14	38	938	3	honcho
isochor	12	4	474	3	isochor
lych	12	60	1576	3	_lych_
macho	12	61	2015	3	_macho
mucho	12	50	1344	3	_mucho
nacho	10	54	1438	3	_nacho
pacha	12	65	1806	3	p_acha
parch	12	51	2300	3	parch_
patch	12	52	2122	3	patch_
patchy	16	50	957	3	patchy
peach	12	54	2249	3	peach_
peachy	16	45	1084	3	peachy
pech	11	61	2545	3	p_ech_
pechs	12	55	1620	3	p_echs
perch	12	45	1883	3	perch_
phyllo	14	3	587	3	phyllo
picacho	16	4	473	3	picacho
pinch	12	56	1930	3	pinch_
pisco	9	63	1498	3	pisc_o
pitch	12	50	1841	3	pitch_
pitchy	16	47	967	3	pitchy
poach	12	49	1786	3	poach_
poachy	16	38	896	3	poachy
poco	8	68	2615	3	p_oc_o
ponchos	14	34	1070	3	ponchos
pooch	12	48	1530	3	pooch_
porch	12	59	1862	3	porch_
pouch	12	46	1708	3	pouch_
pouchy	16	53	866	3	pouchy
pseudo	9	3	471	3	pseudo
psocid	11	3	725	3	psocid
psychics	20	4	382	3	psychics
psyching	19	3	448	3	psyching
psychoses	19	4	668	3	psycho~~ses~~
psychosis	19	4	679	3	psycho~~sis~~
psychotic	21	4	689	3	psycho~~tic~~
psylla	11	3	395	3	psylla
psyops	13	3	434	3	psyops
psywar	14	4	332	3	psywar
punch	12	51	1842	3	punch_
punchy	16	39	852	3	punchy
pyro	9	60	1939	3	p_y_ro
python	14	4	714	3	p_ython
rancho	11	43	1085	3	rancho
reecho	11	31	865	3	reecho
schmo	12	45	1020	3	_s_chmo
secco	9	3	1242	3	_secco
sicko	11	53	1539	3	_sicko
socko	11	52	1511	3	_socko
such	9	64	2481	3	_such_
sybo	9	7	1474	3	_sy_bo
syce	9	58	2028	3	_syc_e
sycee	10	50	1862	3	_sycee
syces	10	64	1646	3	_syces
synch	13	50	1179	3	_synch_
synchro	15	4	454	3	_synchro
synchs	14	40	845	3	_synchs
syph	12	54	1327	3	_syph_
syphon	14	3	685	3	_syphon
syphs	13	51	945	3	_syphs
wych	15	40	1188	3	_wych_

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	112716	0.373	479064.3
2	DLD Change Limit	112716	75	5.140	21929.2
3	Display Results	75	75	0.033	2272.7
	(SQL Overall)	178691	75	5.546	32219.8