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

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

97 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
rough	9	78	1944	(None)
bough	11	57	1931	1	bough
cough	11	58	1964	1	cough
dough	10	52	1738	1	dough
lough	9	51	1848	1	lough
rouge	6	54	2344	1	rouge
roughs	10	54	1622	1	roughs
roughy	13	70	1086	1	roughy
routh	8	64	2307	1	routh
sough	9	53	2046	1	sough
tough	9	73	2199	1	tough
trough	10	85	1203	1	trough
borough	13	4	452	2	borough
boughs	12	54	1437	2	boughs
bought	12	51	1564	2	bought
brought	13	30	869	2	brought
brugh	11	54	1429	2	brugh
chough	15	69	925	2	chough
clough	12	53	913	2	clough
couch	12	53	2011	2	couch
coughs	12	55	1454	2	coughs
couth	10	61	2249	2	couth
crouch	13	39	1020	2	crouch
doughs	11	59	1293	2	doughs
dought	11	49	1552	2	dought
doughy	14	49	984	2	doughy
drought	12	25	888	2	drought
drouth	10	44	1010	2	drouth
enough	10	4	576	2	enough
faugh	12	57	1296	2	faugh
fought	13	51	1240	2	fought
gouge	7	82	2006	2	gouge
grouch	12	31	847	2	grouch
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
roach	10	57	1700	2	roach
rogue	6	64	1753	2	rogue
rotch	10	58	1593	2	rotch
rouche	11	47	1431	2	rouche
roue	4	59	4174	2	rou_e
rouen	5	49	2090	2	rouen
roues	5	60	3935	2	roues
rouged	8	67	1732	2	rouged
rouges	7	60	2238	2	rouges
roughed	12	42	1094	2	roughed
roughen	11	33	883	2	roughen
rougher	11	35	1103	2	rougher
roughly	14	50	729	2	roughly
round	6	43	1843	2	round
roup	6	66	2769	2	rou_p
roups	7	51	1890	2	roups
roupy	10	61	1271	2	roupy
rouse	5	66	3470	2	rouse
roust	5	55	3206	2	roust
rout	4	61	5328	2	rou_t
route	5	51	3207	2	route
rouths	9	54	1682	2	rouths
routs	5	71	3341	2	routs
roux	11	74	1936	2	rou_x
rowth	11	57	1323	2	rowth
rug	4	60	3915	2	r_ug_
ruga	5	61	2123	2	r_uga
rugs	5	60	3368	2	r_ugs
rush	7	66	2818	2	r_ush
ruth	7	68	2599	2	r_uth
saugh	9	53	1840	2	saugh
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
through	14	164	752	2	through
touch	10	65	1939	2	touch
toughs	10	54	1499	2	toughs
toughy	13	59	1108	2	toughy
troughs	11	69	869	2	troughs
ugh	7	65	2068	2	__ugh
unrough	11	10	524	2	unrough
vouch	13	46	1190	2	vouch
vugh	11	71	1572	2	_vugh
waugh	12	54	1168	2	waugh
wrought	14	27	693	2	wrought
yogh	11	66	1614	2	yo_gh
youth	11	53	1504	2	youth

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	53800	0.660	270743.9
2	DLD Change Limit	53800	97	2.576	20885.1
3	Display Results	97	97	0.046	2108.7
	(SQL Overall)	178691	97	3.282	54445.8