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

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

64 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
shearers	11	39	1132	(None)
hearers	10	43	1978	1	_hearers
sharers	10	47	2062	1	sh_arers
shearer	10	44	1468	1	shearer_
smearers	10	30	862	1	smearers
spearers	10	37	1114	1	spearers
swearers	11	32	858	1	swearers
bearers	9	46	1959	2	_bearers
cheaters	13	36	1351	2	cheaters
cheerers	13	31	954	2	cheerers
clearers	10	34	930	2	clearers
fearers	10	48	1527	2	_fearers
headers	11	38	1939	2	_headers
healers	10	43	1946	2	_healers
heapers	12	36	1667	2	_heapers
hearer	9	43	2364	2	_hearer_
heaters	10	42	2522	2	_heaters
heavers	13	37	1719	2	_heavers
rearers	7	43	2356	2	_rearers
scarers	9	46	1851	2	s_carers
sealers	7	43	2355	2	s_ealers
seamers	9	47	1943	2	s_eamers
searer	6	54	3202	2	s_earer_
seaters	7	40	2894	2	s_eaters
shaders	11	59	1555	2	sh_aders
shakers	14	40	1556	2	sh_akers
shapers	12	40	1689	2	sh_apers
sharer	9	50	2548	2	sh_arer_
shares	9	52	3641	2	sh_are_s
sharkers	15	40	1105	2	sh_arkers
sharpers	13	38	1094	2	sh_arpers
shavers	13	41	1509	2	sh_avers
sheared	11	45	1600	2	sheare_d
shearlegs	13	4	249	2	shearlegs
shears	9	38	2090	2	shea__rs
sheathers	15	5	755	2	sheathers
sheaves	13	44	1297	2	sheave_s
shedders	13	26	743	2	shedders
sheerer	10	38	1384	2	sheerer_
sheers	9	43	2240	2	she__ers
sheeters	11	31	1186	2	sheeters
shellers	11	28	1257	2	shellers
shelters	11	34	1281	2	shelters
shelvers	14	38	881	2	shelvers
shewers	13	43	1205	2	she_wers
smearer	9	41	1040	2	smearer_
snarers	7	42	1666	2	s_narers
sneakers	12	30	864	2	sneakers
sneerers	8	30	980	2	sneerers
soarers	7	41	1809	2	s_oarers
sparers	9	45	1961	2	s_parers
speakers	14	29	945	2	speakers
spearer	9	39	1366	2	spearer_
squarers	17	33	802	2	squarers
starers	7	45	2231	2	s_tarers
stealers	8	34	1220	2	stealers
steamers	10	34	1087	2	steamers
steerers	8	25	1135	2	steerers
sugarers	9	3	630	2	sugarers
swearer	10	34	995	2	swearer_
sweaters	11	38	1106	2	sweaters
tearers	7	52	1823	2	_tearers
theaters	11	42	1190	2	theaters
wearers	10	46	1590	2	_wearers

Search took 10 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	121059	0.923	193598.0
2	DLD Change Limit	121059	64	8.013	15107.8
3	Display Results	64	64	0.063	1015.9
	(SQL Overall)	178691	64	8.999	19856.8