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

Here are the results of your fuzzy-string dictionary search for “loaches” 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.

82 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
loaches	12	36	1398	(None)
coaches	14	40	1869	1	coaches
laches	11	65	2835	1	l_aches
leaches	12	33	1934	1	leaches
loathes	10	35	1324	1	loathes
poaches	14	44	1694	1	poaches
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
bleaches	15	34	1067	2	bleaches
blotches	15	3	743	2	blotches
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
cloches	14	41	1371	2	clo_ches
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
laces	7	61	4176	2	l_ac_es
larches	12	44	1645	2	larches
lashes	9	48	3100	2	l_ashes
latches	12	33	2013	2	latches
lathes	9	51	2750	2	l_athes
leached	13	37	1504	2	leached
leacher	12	40	1484	2	leacher
leachers	13	37	1281	2	leachers
leashes	10	35	1440	2	leashes
leches	11	54	2131	2	l_eches
leeches	12	39	1193	2	leeches
letches	12	40	1548	2	letches
liches	11	47	2429	2	l_iches
loach	10	51	1636	2	loach__
loathe	9	42	1138	2	loathe_
loathed	11	41	944	2	loathed
loather	10	37	1100	2	loather
loathers	11	33	1044	2	loathers
loaves	9	48	1385	2	loa_ves
locales	9	37	1509	2	locales
locates	9	32	1881	2	locates
lochs	10	67	1551	2	lo_ch_s
locoes	8	55	1658	2	lo_coes
louche	11	52	1266	2	louche_
lunches	12	41	1544	2	lunches
lurches	12	33	1166	2	lurches
lyches	14	42	1361	2	l_yches
lynches	15	37	887	2	lynches
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
peaches	14	41	2005	2	peaches
pleaches	15	32	1043	2	pleaches
poached	15	42	1240	2	poached
poacher	14	39	1232	2	poacher
poachers	15	29	1076	2	poachers
pooches	14	32	1416	2	pooches
porches	14	38	1567	2	porches
pouches	14	41	1674	2	pouches
reaches	12	34	2320	2	reaches
roached	13	32	1183	2	roached
rotches	12	35	1570	2	rotches
rouches	12	42	1789	2	rouches
slouches	13	20	807	2	slouches
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 8 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.750	238254.7
2	DLD Change Limit	107671	82	6.733	15991.5
3	Display Results	82	82	0.063	1301.6
	(SQL Overall)	178691	82	7.546	23680.2