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

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

60 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
spewers	12	42	1066	(None)
sewers	9	47	1972	1	s_ewers
shewers	13	43	1205	1	shewers
skewers	14	49	838	1	skewers
speers	8	50	1995	1	spe_ers
spewer	11	51	1215	1	spewer_
brewers	12	38	1106	2	brewers
chewers	15	41	1114	2	chewers
ewers	8	60	1882	2	__ewers
hewers	12	37	1527	2	_hewers
openers	9	33	949	2	openers
pawers	11	48	1878	2	_pawers
peers	7	51	3027	2	_pe_ers
peters	8	66	2459	2	_peters
pewees	11	3	1139	2	_pewees
pewters	12	41	1335	2	_pewters
powers	11	38	2232	2	_powers
sawers	9	46	2016	2	s_awers
screwers	13	35	806	2	screwers
seders	7	44	2028	2	s_eders
seeders	8	30	1711	2	seeders
seekers	11	37	1233	2	seekers
seemers	9	38	1433	2	seemers
seers	5	51	3638	2	s_e_ers
severs	9	41	2112	2	s_evers
sewars	9	40	1863	2	s_ewars
sewer	8	44	2622	2	s_ewer_
sheers	9	43	2240	2	she_ers
shewer	12	45	1511	2	shewer_
showers	13	46	1268	2	showers
skewer	13	51	961	2	skewer_
sneers	6	40	1617	2	sne_ers
sowers	9	49	2344	2	s_owers
spacers	11	38	1387	2	spacers
spaders	10	42	1447	2	spaders
sparers	9	45	1961	2	sparers
spawners	13	39	649	2	spawners
speakers	14	29	945	2	speakers
spearers	10	37	1114	2	spearers
spears	8	40	1947	2	spe_ars
specters	12	28	1106	2	specters
speeders	11	33	931	2	speeders
speeds	9	43	1605	2	spe_eds
speels	8	51	1639	2	spe_els
speer	7	46	2390	2	spe_er_
speirs	8	50	1323	2	spe_irs
spellers	10	28	1276	2	spellers
spelters	10	39	1224	2	spelters
spencers	12	26	919	2	spencers
spenders	11	32	1174	2	spenders
spewed	12	55	1233	2	spewe_d
spews	10	50	1592	2	spew__s
spicers	11	38	1555	2	spicers
spiders	10	39	1441	2	spiders
spielers	10	31	965	2	spielers
spiers	8	44	2174	2	sp_iers
spikers	13	53	1199	2	spikers
steers	6	38	2098	2	ste_ers
strewers	11	40	906	2	strewers
viewers	13	3	717	2	viewers

Search took 5 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.390	458182.1
2	DLD Change Limit	107671	60	3.766	28590.3
3	Display Results	60	60	0.360	166.7
	(SQL Overall)	178691	60	4.516	39568.4