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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

167 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
psyched	18	4	391	(None)
psyche	16	7	429	1	psyche_
psyches	17	5	580	1	psyches
parched	15	40	1369	2	parched
patched	15	35	1462	2	patched
peached	15	43	1588	2	peached
peched	14	49	1534	2	p_eched
perched	15	47	1324	2	perched
pinched	15	38	1245	2	pinched
pitched	15	35	1292	2	pitched
poached	15	42	1240	2	poached
pooched	15	28	1008	2	pooched
pouched	15	36	1277	2	pouched
psych	15	5	496	2	psych__
psychic	19	4	483	2	psychic
psycho	16	7	453	2	psych_o
psychos	17	6	526	2	psychos
psychs	16	5	365	2	psych_s
punched	15	35	1217	2	punched
synched	16	27	721	2	_synched
ached	11	92	2783	3	__ached
arched	12	57	1732	3	_arched
ashed	9	78	2977	3	as__hed
bached	14	55	1989	3	_bached
batched	15	41	1424	3	batched
beached	15	45	1655	3	beached
belched	15	40	1184	3	belched
benched	15	47	1394	3	benched
birched	15	34	991	3	birched
bitched	15	32	1292	3	bitched
botched	15	36	1190	3	botched
bunched	15	43	1241	3	bunched
cached	14	54	1920	3	_cached
cinched	15	39	1086	3	cinched
cliched	15	37	1102	3	cliched
coached	15	33	1384	3	coached
couched	15	41	1579	3	couched
cycled	14	3	654	3	_cycled
ditched	14	37	1190	3	ditched
douched	14	40	1211	3	douched
eched	11	69	1922	3	__eched
eschew	14	3	633	3	es_chew
etched	12	36	1370	3	_etched
fetched	16	37	1047	3	fetched
filched	16	30	742	3	filched
hatched	16	34	1446	3	hatched
hitched	16	33	1225	3	hitched
hotched	16	36	1092	3	hotched
hunched	16	37	1049	3	hunched
hutched	16	35	988	3	hutched
inched	12	45	1448	3	_inched
itched	12	38	1202	3	_itched
kythed	17	40	731	3	_kythed
latched	13	39	1407	3	latched
leached	13	37	1504	3	leached
leched	12	37	1600	3	_leched
leeched	13	36	950	3	leeched
letched	13	39	1205	3	letched
lunched	13	39	1182	3	lunched
lurched	13	35	803	3	lurched
lychee	14	37	1089	3	_lychee
lyches	14	42	1361	3	_lyches
lynched	16	37	675	3	lynched
marched	15	38	1340	3	marched
matched	15	35	1396	3	matched
miched	14	39	1339	3	_miched
mooched	15	39	1053	3	mooched
mouched	15	36	1259	3	mouched
mulched	15	30	776	3	mulched
munched	15	34	1107	3	munched
niched	12	55	1406	3	_niched
notched	13	42	1030	3	notched
ouched	12	43	1693	3	_ouched
paced	10	69	3168	3	p_ac_ed
packed	15	48	2260	3	p_acked
parches	14	37	2000	3	parches
pashed	12	59	2314	3	p_ashed
patcher	14	35	1514	3	patcher
patches	14	33	2038	3	patches
paunched	16	4	552	3	paunched
paycheck	24	4	255	3	paycheck
payed	11	59	2593	3	pay__ed
peaced	11	58	1891	3	peac_ed
peacher	14	42	1607	3	peacher
peaches	14	41	2005	3	peaches
pecked	15	50	1910	3	p_ecked
percher	14	33	1342	3	percher
perches	14	37	1795	3	perches
physed	15	38	679	3	phy_sed
picked	15	44	2131	3	p_icked
pieced	11	39	1210	3	piec_ed
pincher	14	38	1271	3	pincher
pinches	14	41	1793	3	pinches
pished	12	48	1706	3	p_ished
pitcher	14	38	1371	3	pitcher
pitches	14	36	1775	3	pitches
pithed	12	46	1561	3	p_ithed
placed	11	43	1800	3	plac_ed
plashed	13	37	1264	3	plashed
pleached	16	33	806	3	pleached
plucked	16	36	796	3	plucked
poacher	14	39	1232	3	poacher
poaches	14	44	1694	3	poaches
pocked	15	48	1898	3	p_ocked
ponced	11	43	1481	3	ponc_ed
ponchoed	16	4	613	3	ponchoed
pooches	14	32	1416	3	pooches
poohed	12	39	1252	3	p_oohed
porches	14	38	1567	3	porches
pouches	14	41	1674	3	pouches
preached	16	34	1206	3	preached
priced	11	50	1888	3	pric_ed
pricked	16	46	1383	3	pricked
proceed	12	3	1055	3	proceed
prythee	15	4	538	3	prythee
psalmed	12	3	450	3	psalmed
pschent	14	3	741	3	ps_chent
pshawed	16	10	303	3	pshawed
psocid	11	3	725	3	psoc_id
psychics	20	4	382	3	psychics
psyching	19	3	448	3	psyching
psychoses	19	4	668	3	psychoses
psyllid	13	4	452	3	psyllid
puncher	14	33	1167	3	puncher
punches	14	48	1613	3	punches
pushed	12	50	1746	3	p_ushed
ranched	13	31	1360	3	ranched
reached	13	46	1908	3	reached
retched	13	38	1427	3	retched
roached	13	32	1183	3	roached
ruched	12	43	1463	3	_ruched
sachem	13	40	1222	3	_sachem
sachet	11	47	2577	3	_sachet
sacked	13	55	2521	3	_sacked
sacred	9	49	1710	3	_sacred
sashed	10	56	2294	3	_sashed
scythed	16	38	530	3	scythed
shed	8	65	3615	3	_s__hed
sicced	11	48	965	3	_sicced
sicked	13	45	2440	3	_sicked
sighed	11	37	1205	3	_sighed
socked	13	47	2150	3	_socked
spaced	11	45	1725	3	spac_ed
spathed	13	40	1318	3	spathed
specced	14	26	670	3	specced
specked	16	32	901	3	specked
spiced	11	52	1831	3	spic_ed
sucked	13	41	2049	3	_sucked
sughed	11	36	1020	3	_sughed
syce	9	58	2028	3	_syc_e_
sycee	10	50	1862	3	_syc_ee
sycees	11	40	965	3	_sycees
syces	10	64	1646	3	_syc_es
synced	12	26	696	3	_synced
sypher	14	31	708	3	_sypher
teched	12	40	1443	3	_teched
tetched	13	30	1077	3	tetched
torched	13	35	1136	3	torched
touched	13	49	1496	3	touched
tythed	13	45	750	3	_tythed
vouched	16	39	1056	3	vouched
watched	16	30	1282	3	watched
welched	16	29	883	3	welched
wenched	16	39	1091	3	wenched
winched	16	31	1059	3	winched
witched	16	30	1219	3	witched
wyches	17	38	791	3	_wyches

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	167	5.643	23751.0
3	Display Results	167	167	0.060	2783.3
	(SQL Overall)	178691	167	6.109	29250.5