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

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

65 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
snorers	7	43	1380	(None)
scorers	9	41	1532	1	scorers
snarers	7	42	1666	1	snarers
snorer	6	43	1676	1	snorer_
snores	6	43	2432	1	snore_s
snorters	8	34	1058	1	snorters
storers	7	50	1868	1	storers
adorers	8	44	1173	2	adorers
borers	8	51	2268	2	_borers
corers	8	52	3107	2	_corers
honorers	11	3	926	2	honorers
ignorers	9	21	524	2	ignorers
knowers	14	3	635	2	knowers
noters	6	40	2100	2	_noters
savorers	11	5	722	2	savorers
scarers	9	46	1851	2	scarers
scorer	8	48	1826	2	scorer_
scores	8	47	2592	2	score_s
scorners	10	22	849	2	scorners
scoters	9	33	1381	2	scoters
scourers	10	34	853	2	scourers
senores	7	32	1811	2	senore_s
sharers	10	47	2062	2	sharers
shnorrers	12	4	353	2	shnorrers
shoers	9	45	1833	2	sho_ers
shores	9	48	3041	2	shore_s
shovers	13	46	1300	2	shovers
showers	13	46	1268	2	showers
slopers	9	42	1309	2	slopers
smokers	13	38	932	2	smokers
snarer	6	46	2084	2	snarer_
snares	6	53	2903	2	snare_s
snarlers	8	29	875	2	snarlers
sneerers	8	30	980	2	sneerers
sneers	6	40	1617	2	sn_eers
snipers	9	33	1177	2	snipers
snookers	12	39	865	2	snookers
snoopers	10	31	984	2	snoopers
snoozers	17	29	694	2	snoozers
snore	5	54	2495	2	snore__
snored	7	48	1954	2	snore_d
snorkels	12	3	441	2	snorkels
snorter	7	44	1266	2	snorter_
snorts	6	41	1650	2	snor_ts
soarers	7	41	1809	2	soarers
sobers	8	52	1886	2	s_obers
sonders	8	38	2071	2	sonders
sooners	7	39	1664	2	sooners
sorels	6	39	2116	2	s_orels
sorer	5	62	3659	2	s_orer_
sores	5	54	5428	2	s_ore_s
sorners	7	34	1687	2	s_orners
sorters	7	42	2113	2	s_orters
sowers	9	49	2344	2	s_owers
sparers	9	45	1961	2	sparers
spores	8	47	2661	2	spore_s
sporters	10	37	1406	2	sporters
starers	7	45	2231	2	starers
stokers	11	45	1518	2	stokers
stoners	7	48	1795	2	stoners
stopers	9	42	1737	2	stopers
storer	6	47	2167	2	storer_
stores	6	55	3366	2	store_s
storeys	10	55	965	2	storeys
stovers	10	37	1373	2	stovers

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.373	479064.3
2	DLD Change Limit	107671	65	4.126	26095.7
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	4.515	39577.2