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

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

90 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
stovers	10	37	1373	(None)
estovers	11	3	645	1	estovers
shovers	13	46	1300	1	shovers
stivers	10	36	1354	1	stivers
stokers	11	45	1518	1	stokers
stoners	7	48	1795	1	stoners
stopers	9	42	1737	1	stopers
storers	7	50	1868	1	storers
stover	9	41	1564	1	stover_
stoves	9	38	1892	1	stove_s
atoners	7	50	1395	2	atoners
clovers	12	51	1466	2	clovers
covers	11	46	2796	2	_covers
cutovers	13	3	512	2	cutovers
drovers	11	52	1264	2	drovers
glovers	11	43	1088	2	glovers
hoovers	13	43	1271	2	hoovers
hovers	12	43	2025	2	_hovers
lovers	9	42	2343	2	_lovers
movers	11	51	1719	2	_movers
overs	8	52	2479	2	__overs
plovers	12	36	1183	2	plovers
provers	12	38	1779	2	provers
rovers	9	54	2352	2	_rovers
salvers	10	39	1600	2	salvers
savers	9	38	2592	2	s_avers
scorers	9	41	1532	2	scorers
scoters	9	33	1381	2	scoters
servers	10	32	1483	2	servers
severs	9	41	2112	2	s_evers
shavers	13	41	1509	2	shavers
shivers	13	37	1483	2	shivers
shoers	9	45	1833	2	sho_ers
shovels	13	37	839	2	shovels
shover	12	45	1599	2	shover_
shoves	12	49	1942	2	shove_s
showers	13	46	1268	2	showers
silvers	10	47	1404	2	silvers
sivers	9	53	2415	2	s_ivers
skivers	14	40	970	2	skivers
slavers	10	37	1650	2	slavers
slivers	10	41	1525	2	slivers
slopers	9	42	1309	2	slopers
slovens	10	31	657	2	slovens
smokers	13	38	932	2	smokers
snorers	7	43	1380	2	snorers
sobers	8	52	1886	2	s_obers
solvers	10	44	1425	2	solvers
sooners	7	39	1664	2	sooners
sowers	9	49	2344	2	s_owers
stagers	8	41	1667	2	stagers
starers	7	45	2231	2	starers
starvers	11	45	964	2	starvers
staters	7	39	2234	2	staters
staves	9	45	2519	2	stave_s
stayers	10	38	1363	2	stayers
steers	6	38	2098	2	st_eers
stiver	9	39	1573	2	stiver_
stockers	14	34	1107	2	stockers
stogeys	11	48	612	2	stogeys
stoker	10	44	1762	2	stoker_
stokes	10	48	2179	2	stoke_s
stoles	6	39	2767	2	stole_s
stompers	12	36	1004	2	stompers
stoner	6	58	2320	2	stoner_
stones	6	51	3003	2	stone_s
stookers	12	44	979	2	stookers
stoopers	10	37	1130	2	stoopers
stoper	8	43	2010	2	stoper_
stopes	8	45	2589	2	stope_s
stopovers	14	4	383	2	stopovers
stoppers	12	39	1059	2	stoppers
storer	6	47	2167	2	storer_
stores	6	55	3366	2	store_s
storeys	10	55	965	2	storeys
stoures	7	46	1416	2	stoures
stours	6	50	1563	2	sto_urs
stove	8	52	2025	2	stove__
strivers	11	39	1184	2	strivers
strokers	12	39	1090	2	strokers
stroyers	11	38	892	2	stroyers
stuivers	11	40	667	2	stuivers
stylers	10	35	935	2	stylers
tokers	10	48	1889	2	_tokers
toners	6	41	2800	2	_toners
topers	8	50	2532	2	_topers
toters	6	50	2636	2	_toters
towers	9	44	2367	2	_towers
toyers	9	55	1633	2	_toyers
trovers	10	37	1332	2	trovers

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	107671	0.373	479064.3
2	DLD Change Limit	107671	90	3.393	31733.3
3	Display Results	90	90	0.030	3000.0
	(SQL Overall)	178691	90	3.796	47073.5