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

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

89 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
cough	11	58	1964	(None)
bough	11	57	1931	1	bough
chough	15	69	925	1	chough
clough	12	53	913	1	clough
couch	12	53	2011	1	couch
coughs	12	55	1454	1	coughs
couth	10	61	2249	1	couth
dough	10	52	1738	1	dough
lough	9	51	1848	1	lough
rough	9	78	1944	1	rough
sough	9	53	2046	1	sough
tough	9	73	2199	1	tough
boughs	12	54	1437	2	boughs
bought	12	51	1564	2	bought
brugh	11	54	1429	2	brugh
caught	12	49	1168	2	caught
choughs	16	57	663	2	choughs
choush	14	54	906	2	choush
chug	10	59	1411	2	chug_
chugs	11	55	1194	2	chugs
cloughs	13	51	705	2	cloughs
coach	12	59	1945	2	coach
cog	6	95	5290	2	co_g_
cogs	7	73	4003	2	co_gs
coign	8	50	1391	2	coign
colugo	9	3	586	2	colugo
conch	12	46	2007	2	conch
conga	8	54	1987	2	conga
conge	8	52	2759	2	conge
congo	8	56	2313	2	congo
cooch	12	49	1683	2	cooch
corgi	8	3	1608	2	corgi
cosh	9	61	2762	2	co_sh
coude	8	50	2263	2	coude
cougar	9	5	878	2	cougar
coughed	14	33	1090	2	coughed
cougher	13	37	1173	2	cougher
could	8	65	1771	2	could
count	7	49	3205	2	count
coup	8	67	2979	2	cou_p
coupe	9	60	2348	2	coupe
coups	9	55	2247	2	coups
court	7	55	3277	2	court
couths	11	57	1541	2	couths
crouch	13	39	1020	2	crouch
crush	10	68	1599	2	crush
doughs	11	59	1293	2	doughs
dought	11	49	1552	2	dought
doughy	14	49	984	2	doughy
enough	10	4	576	2	enough
faugh	12	57	1296	2	faugh
fought	13	51	1240	2	fought
gouge	7	82	2006	2	gouge
haugh	12	51	1405	2	haugh
heugh	12	54	1092	2	heugh
laugh	9	44	1437	2	laugh
loughs	10	50	1477	2	loughs
mouch	12	47	1580	2	mouch
mouth	10	54	2029	2	mouth
nought	10	47	1397	2	nought
ouch	9	57	2463	2	_ouch
ought	9	52	2154	2	_ought
ouph	9	56	1837	2	_ouph
plough	12	57	756	2	plough
pouch	12	46	1708	2	pouch
pugh	10	66	1923	2	_pugh
rouge	6	54	2344	2	rouge
roughs	10	54	1622	2	roughs
roughy	13	70	1086	2	roughy
routh	8	64	2307	2	routh
saugh	9	53	1840	2	saugh
scouth	11	50	1115	2	scouth
slough	10	53	923	2	slough
soughs	10	51	1562	2	soughs
sought	10	63	1506	2	sought
south	8	52	2357	2	south
sugh	8	64	2344	2	_sugh
teugh	9	55	1161	2	teugh
though	13	94	1078	2	though
touch	10	65	1939	2	touch
toughs	10	54	1499	2	toughs
toughy	13	59	1108	2	toughy
trough	10	85	1203	2	trough
ugh	7	65	2068	2	__ugh
vouch	13	46	1190	2	vouch
vugh	11	71	1572	2	_vugh
waugh	12	54	1168	2	waugh
yogh	11	66	1614	2	yo_gh
youth	11	53	1504	2	youth

Search took 3 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	53800	0.346	516448.0
2	DLD Change Limit	53800	89	1.640	32804.9
3	Display Results	89	89	0.016	5562.5
	(SQL Overall)	178691	89	2.002	89256.2