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

Here are the results of your fuzzy-string dictionary search for “sheerer” 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
sheerer	10	38	1384	(None)
cheerer	12	35	1175	1	cheerer
shearer	10	44	1468	1	shearer
sheered	11	35	1545	1	sheered
sheeter	10	38	1491	1	sheeter
sneerer	7	35	1231	1	sneerer
steerer	7	31	1363	1	steerer
cheeper	14	36	1074	2	cheeper
cheered	13	37	1329	2	cheered
cheerers	13	31	954	2	cheerers
cheerier	13	4	800	2	cheerier
hearer	9	43	2364	2	_hearer
heeder	10	42	1604	2	_heeder
heeler	9	39	1731	2	_heeler
jeerer	13	38	993	2	_jeerer
queerer	16	10	650	2	queerer
searer	6	54	3202	2	s_earer
seeder	7	43	2077	2	s_eeder
seeker	10	36	1536	2	s_eeker
seemer	8	44	1804	2	s_eemer
serer	5	59	3551	2	s__erer
severer	10	35	1156	2	severer
sharer	9	50	2548	2	sh_arer
sheared	11	45	1600	2	sheared
shearers	11	39	1132	2	shearers
shedder	12	33	932	2	shedder
sheened	11	35	1170	2	sheened
sheeney	13	39	893	2	sheeney
sheenier	11	16	742	2	sheenier
sheer	8	47	2689	2	sh_e_er
sheerest	11	3	1008	2	sheerest
sheerly	13	33	770	2	sheerly
sheers	9	43	2240	2	sheer_s
sheeted	11	38	1304	2	sheeted
sheeters	11	31	1186	2	sheeters
sheeve	12	34	1284	2	sheeve_
sheeves	13	39	1195	2	sheeves
sheller	10	35	1588	2	sheller
shelter	10	32	1496	2	shelter
shelterer	12	4	503	2	shelterer
shelver	13	42	1106	2	shelver
shereef	13	3	774	2	shereef
shewer	12	45	1511	2	sh_ewer
shiverer	14	18	666	2	shiverer
showerer	14	3	616	2	showerer
skeeter	11	34	1041	2	skeeter
sleeker	11	33	982	2	sleeker
sleeper	9	32	1156	2	sleeper
smearer	9	41	1040	2	smearer
sneered	8	31	1397	2	sneered
sneerers	8	30	980	2	sneerers
sneerier	8	7	810	2	sneerier
sneezer	16	23	796	2	sneezer
soberer	9	31	1035	2	soberer
spearer	9	39	1366	2	spearer
speeder	10	38	1107	2	speeder
speered	10	36	1481	2	speered
steeper	9	38	1277	2	steeper
steered	8	36	1525	2	steered
steerers	8	25	1135	2	steerers
swearer	10	34	995	2	swearer
sweeper	12	32	937	2	sweeper
sweeter	10	32	1200	2	sweeter
wheeler	13	29	877	2	wheeler
wheezer	22	29	667	2	wheezer

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.376	475242.0
2	DLD Change Limit	107671	65	3.483	30913.3
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	3.892	45912.4