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

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

79 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
sowens	9	36	1315	(None)
rowens	9	45	1530	1	rowens
sowans	9	42	1589	1	sowans
sowers	9	49	2344	1	sowers
bowels	11	43	1559	2	bowels
bowers	11	55	2370	2	bowers
codens	9	48	2101	2	codens
copens	10	61	1996	2	copens
covens	11	49	1926	2	covens
cowers	11	46	2553	2	cowers
cozens	17	63	1492	2	cozens
dovens	10	44	1390	2	dovens
dowels	10	48	1334	2	dowels
dowers	10	45	2329	2	dowers
downs	9	49	1857	2	dow_ns
doyens	10	48	1022	2	doyens
dozens	16	46	1246	2	dozens
gowans	10	55	1229	2	gowans
gowns	9	51	1510	2	gow_ns
howes	11	47	3026	2	howe_s
lodens	7	43	1506	2	lodens
lowers	9	46	2492	2	lowers
lowes	8	57	3246	2	lowe_s
mowers	11	32	1940	2	mowers
omens	7	56	1896	2	_omens
opens	7	61	1855	2	_opens
ovens	8	62	1745	2	_ovens
owes	7	51	3710	2	_owe_s
owns	7	68	1958	2	_ow_ns
powers	11	38	2232	2	powers
rouens	6	48	1444	2	rouens
rowans	9	57	1534	2	rowans
rowels	9	45	1545	2	rowels
rowen	8	49	2115	2	rowen_
rowers	9	49	2457	2	rowers
sawers	9	46	2016	2	sawers
semens	8	46	1696	2	semens
sevens	9	38	1366	2	sevens
sewans	9	52	1590	2	sewans
sewers	9	47	1972	2	sewers
sheens	9	51	1699	2	sheens
showers	13	46	1268	2	showers
sirens	6	53	1815	2	sirens
skeens	10	39	1291	2	skeens
slovens	10	31	657	2	slovens
sobers	8	52	1886	2	sobers
soddens	9	34	841	2	soddens
softens	10	34	762	2	softens
sokes	9	50	3142	2	soke_s
solans	6	41	2249	2	solans
soles	5	55	4792	2	sole_s
soleus	6	46	1561	2	soleus
solons	6	51	2002	2	solons
somans	8	46	1930	2	somans
sones	5	54	4414	2	sone_s
sons	4	60	4955	2	so__ns
sorels	6	39	2116	2	sorels
sores	5	54	5428	2	sore_s
sorns	5	50	2842	2	so_rns
sowars	9	43	1801	2	sowars
sowed	9	49	3386	2	sowe_d
sower	8	52	2931	2	sowe_r
sowing	10	42	2291	2	sowing
sown	7	51	2745	2	sow_n_
sows	7	53	4249	2	sow__s
sozins	15	5	1079	2	sozins
swans	8	46	2501	2	s_wans
swoons	9	45	1114	2	swoons
swouns	9	35	824	2	swouns
syrens	9	49	1199	2	syrens
tokens	10	47	1156	2	tokens
towels	9	43	1464	2	towels
towers	9	44	2367	2	towers
towns	8	60	1888	2	tow_ns
vowels	12	44	1048	2	vowels
vowers	12	43	1718	2	vowers
wens	7	63	3793	2	__wens
wovens	12	44	983	2	wovens
yowes	11	49	2637	2	yowe_s

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.360	496363.9
2	DLD Change Limit	82551	79	2.453	33653.1
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	2.843	62853.0