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

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

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.

81 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
poaches	14	44	1694	(None)
coaches	14	40	1869	1	coaches
loaches	12	36	1398	1	loaches
peaches	14	41	2005	1	peaches
poached	15	42	1240	1	poached
poacher	14	39	1232	1	poacher
poachers	15	29	1076	1	poachers
pooches	14	32	1416	1	pooches
porches	14	38	1567	1	porches
pouches	14	41	1674	1	pouches
roaches	12	36	1621	1	roaches
aches	10	61	3229	2	__aches
apaches	14	34	1184	2	apaches
baches	13	54	2694	2	_baches
beaches	14	41	2065	2	beaches
boches	13	46	1852	2	bo_ches
botches	14	37	1602	2	botches
braches	14	46	2122	2	braches
broaches	15	32	1162	2	broaches
caches	13	79	2691	2	_caches
coached	15	33	1384	2	coached
coacher	14	37	1412	2	coacher
coachers	15	43	1230	2	coachers
conches	14	40	1981	2	conches
cooches	14	35	1583	2	cooches
couches	14	40	2047	2	couches
douches	13	43	1523	2	douches
gouaches	14	3	620	2	gouaches
hooches	15	38	1252	2	hooches
hotches	15	38	1436	2	hotches
laches	11	65	2835	2	_laches
leaches	12	33	1934	2	leaches
loathes	10	35	1324	2	loathes
maches	13	48	2723	2	_maches
mooches	14	37	1445	2	mooches
mouches	14	38	1596	2	mouches
naches	11	46	2241	2	_naches
notches	12	35	1365	2	notches
oraches	12	42	1647	2	oraches
ouches	11	43	2218	2	_ouches
paces	9	67	4111	2	p_ac_es
pachas	13	50	1714	2	p_achas
panaches	15	3	1029	2	panaches
parches	14	37	2000	2	parches
pashes	11	58	2839	2	p_ashes
patches	14	33	2038	2	patches
peaces	10	63	2408	2	peac_es
peached	15	43	1588	2	peached
peacher	14	42	1607	2	peacher
peachers	15	32	1384	2	peachers
perches	14	37	1795	2	perches
pinches	14	41	1793	2	pinches
pitches	14	36	1775	2	pitches
places	10	43	2370	2	plac_es
planches	15	31	1186	2	planches
plashes	12	44	1739	2	plashes
pleaches	15	32	1043	2	pleaches
poach	12	49	1786	2	poach__
poachier	15	5	682	2	poachier
poachiest	16	3	689	2	poachiest
poachy	16	38	896	2	poach_y
pomaces	13	27	1212	2	pomac_es
ponces	10	47	2084	2	ponc_es
ponchos	14	34	1070	2	ponchos
pooched	15	28	1008	2	pooched
potashes	13	3	783	2	potashes
potiches	15	3	920	2	potiches
potlaches	16	11	526	2	potlaches
pouched	15	36	1277	2	pouched
preaches	15	32	1489	2	preaches
psyches	17	5	580	2	psyches
punches	14	48	1613	2	punches
reaches	12	34	2320	2	reaches
roached	13	32	1183	2	roached
rotches	12	35	1570	2	rotches
rouches	12	42	1789	2	rouches
taches	11	42	2417	2	_taches
teaches	12	27	1835	2	teaches
torches	12	37	1544	2	torches
touches	12	51	1834	2	touches
vouches	15	39	1411	2	vouches

Search took 4 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	107671	0.373	479064.3
2	DLD Change Limit	107671	81	3.080	34958.1
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	3.483	51303.8