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

Here are the results of your fuzzy-string dictionary search for “roughs” 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
roughs	10	54	1621	(None)
boughs	12	54	1437	1	boughs
coughs	12	55	1454	1	coughs
doughs	11	59	1293	1	doughs
loughs	10	50	1477	1	loughs
rouges	7	60	2238	1	rouges
rough	9	78	1943	1	rough_
roughy	13	70	1085	1	roughy
rouths	9	54	1682	1	rouths
soughs	10	51	1562	1	soughs
toughs	10	54	1498	1	toughs
troughs	11	69	867	1	troughs
boroughs	14	4	379	2	boroughs
bough	11	57	1931	2	bough_
bought	12	51	1563	2	bought
brought	13	30	868	2	brought
brughs	12	50	906	2	brughs
choughs	16	57	662	2	choughs
cloughs	13	51	705	2	cloughs
cough	11	58	1964	2	cough_
couths	11	57	1539	2	couths
dough	10	52	1738	2	dough_
dought	11	49	1551	2	dought
doughy	14	49	984	2	doughy
drought	12	25	887	2	drought
droughts	13	24	573	2	droughts
drouths	11	43	648	2	drouths
enoughs	11	4	462	2	enoughs
fought	13	51	1239	2	fought
gouges	8	63	1869	2	gouges
haughs	13	40	856	2	haughs
heughs	13	51	690	2	heughs
laughs	10	48	902	2	laughs
lough	9	51	1848	2	lough_
mouths	11	52	1453	2	mouths
nought	10	47	1396	2	nought
noughts	11	47	808	2	noughts
ought	9	52	2153	2	_ought
oughts	10	47	1018	2	_oughts
ouphs	10	43	1127	2	_ouphs
ploughs	13	52	610	2	ploughs
rogues	7	46	1767	2	rogues
rouche	11	47	1431	2	rouche
rouches	12	42	1789	2	rouches
rouens	6	48	1444	2	rouens
roues	5	60	3935	2	rou_es
rouge	6	54	2344	2	roug_e
rouged	8	67	1732	2	rouged
roughed	12	42	1094	2	roughed
roughen	11	33	883	2	roughen
roughens	12	28	689	2	roughens
rougher	11	35	1103	2	rougher
roughers	12	32	917	2	roughers
roughest	12	3	877	2	roughest
roughies	12	9	832	2	roughies
roughish	15	4	521	2	roughish
roughly	14	50	729	2	roughly
rounds	7	36	1561	2	rounds
roups	7	51	1890	2	rou_ps
rouses	6	54	3628	2	rouses
rousts	6	170	1672	2	rousts
routes	6	61	2931	2	routes
routh	8	64	2307	2	routh_
routs	5	71	3341	2	rou_ts
rowths	12	45	817	2	rowths
rugs	5	60	3368	2	r_ug_s
ruths	8	57	1464	2	r_uths
saughs	10	48	1205	2	saughs
sloughs	11	49	756	2	sloughs
sough	9	53	2046	2	sough_
sought	10	63	1505	2	sought
souths	9	52	1660	2	souths
sughs	9	53	1332	2	_sughs
tough	9	73	2198	2	tough_
toughy	13	59	1107	2	toughy
trough	10	85	1202	2	trough_
ughs	8	54	1097	2	__ughs
vughs	12	67	874	2	_vughs
wrought	14	27	692	2	wrought
yoghs	12	54	1059	2	yo_ghs
youths	12	45	1004	2	youths

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	82551	0.110	1624463.6
2	DLD Change Limit	82551	81	2.483	33246.5
3	Display Results	81	81	0.033	2454.5
	(SQL Overall)	178691	81	2.626	68046.8