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

Here are the results of your fuzzy-string dictionary search for “shearlegs” with Change Limit: [1] [2] [3] [4]

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.

59 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
shearlegs	13	4	249	(None)
sheerlegs	13	4	329	1	sheerlegs
shearers	11	39	1132	2	shear_ers
shearings	13	33	756	2	shearings
shearlings	14	4	353	2	shearlings
charleys	16	9	563	3	ch_arleys
cheerless	14	9	529	3	cheerless
earless	7	43	1607	3	__earless
fearless	11	3	787	3	_fearless
gearless	9	3	737	3	_gearless
headless	12	28	986	3	_headless
healers	10	43	1946	3	_hea_lers
hearers	10	43	1978	3	_hear_ers
hearings	12	36	1185	3	_hearings
hearkens	15	33	669	3	_hearkens
hearses	10	44	1453	3	_hearse_s
heartens	11	30	1015	3	_heartens
heartless	12	3	639	3	_heartless
heatless	11	30	1146	3	_heatless
heirless	11	4	605	3	_heirless
pearlers	10	3	903	3	_pearlers
scarless	10	18	905	3	s_carless
scarlets	10	17	857	3	s_carlets
sealers	7	43	2355	3	s_ea_lers
seamless	10	23	872	3	s_eamless
seatless	8	32	1300	3	s_eatless
shales	9	47	3125	3	sh_a_le_s
sharers	10	47	2062	3	sh_ar_ers
shares	9	52	3641	3	sh_ar_e_s
sharkers	15	40	1105	3	sh_arkers
sharpens	13	37	781	3	sh_arpens
sharpers	13	38	1094	3	sh_arpers
shealings	13	31	756	3	shealings
sheals	9	44	2064	3	shea_l__s
sheared	11	45	1600	3	shear_e_d
shearer	10	44	1468	3	shear_e_r
shearing	12	39	1590	3	shearing_
shearling	13	3	692	3	shearling
shears	9	38	2090	3	shear___s
sheathers	15	5	755	3	sheathers
sheathes	14	6	1019	3	sheathe_s
sheaves	13	44	1297	3	shea_ve_s
sheerness	12	3	627	3	sheerness
sheetless	12	3	582	3	sheetless
shellers	11	28	1257	3	she_llers
sherbets	13	3	521	3	she_rbets
shereefs	14	3	386	3	she_reefs
sherries	11	18	1289	3	sherrie_s
smearers	10	30	862	3	smear_ers
snarlers	8	29	875	3	s_narlers
spearers	10	37	1114	3	spear_ers
starless	8	16	1084	3	s_tarless
starlets	8	16	1008	3	s_tarlets
stealers	8	34	1220	3	stea_lers
sterlets	8	16	927	3	ste_rlets
sugarless	10	4	367	3	sugarless
swearers	11	32	858	3	swear_ers
tearless	8	4	871	3	_tearless
wheatless	15	3	400	3	wheatless

Search took 8 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	148641	0.156	1145455.1
2	DLD Change Limit	148641	59	7.516	19776.6
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	7.702	23200.6