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

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

77 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
soughs	10	51	1562	(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
roughs	10	54	1622	1	roughs
saughs	10	48	1205	1	saughs
sloughs	11	49	756	1	sloughs
sough	9	53	2046	1	sough_
sought	10	63	1506	1	sought
souths	9	52	1660	1	souths
sughs	9	53	1332	1	s_ughs
toughs	10	54	1499	1	toughs
bough	11	57	1931	2	bough_
bought	12	51	1564	2	bought
brughs	12	50	906	2	brughs
choughs	16	57	663	2	choughs
cloughs	13	51	705	2	cloughs
cough	11	58	1964	2	cough_
couths	11	57	1541	2	couths
dough	10	52	1738	2	dough_
dought	11	49	1552	2	dought
doughy	14	49	984	2	doughy
enoughs	11	4	463	2	enoughs
fought	13	51	1240	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	1397	2	nought
noughts	11	47	808	2	noughts
ought	9	52	2154	2	_ought
oughts	10	47	1018	2	_oughts
ouphs	10	43	1127	2	_ouphs
ploughs	13	52	610	2	ploughs
rouges	7	60	2238	2	rouges
rough	9	78	1944	2	rough_
roughy	13	70	1086	2	roughy
rouths	9	54	1682	2	rouths
sanghs	10	53	1207	2	sanghs
sauchs	11	51	1223	2	sauchs
saugh	9	53	1840	2	saugh_
saughy	13	50	746	2	saughy
scouths	12	52	789	2	scouths
shaughs	14	24	528	2	shaughs
sheughs	14	26	453	2	sheughs
sighs	9	54	1674	2	s_ighs
slough	10	53	923	2	slough_
sloughy	14	53	580	2	sloughy
slugs	6	46	1856	2	slug_s
snugs	6	49	1302	2	snug_s
songs	6	77	2555	2	song_s
sooths	9	57	1559	2	sooths
sophs	10	49	1602	2	so_phs
sorgho	10	34	871	2	sorgho
sorghos	11	32	760	2	sorghos
sorgos	7	45	1466	2	sorgos
soths	8	62	1863	2	so_ths
soughed	12	38	1162	2	soughed
souks	9	48	2052	2	sou_ks
souls	5	51	2736	2	sou_ls
sounds	7	46	1618	2	sounds
soups	7	53	2294	2	sou_ps
sours	5	52	3050	2	sou_rs
sous	4	69	4721	2	sou__s
souses	6	42	2924	2	souses
south	8	52	2357	2	south_
sugh	8	64	2344	2	s_ugh_
tough	9	73	2199	2	tough_
toughy	13	59	1108	2	toughy
troughs	11	69	869	2	troughs
ughs	8	54	1097	2	__ughs
vughs	12	67	874	2	_vughs
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.343	520965.0
2	DLD Change Limit	82551	77	2.500	33020.4
3	Display Results	77	77	0.016	4812.5
	(SQL Overall)	178691	77	2.859	62501.2