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

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

49 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
charlady	17	4	340	(None)
charade	13	12	991	2	char_ade
charley	15	11	827	2	charl_ey
carload	10	3	978	3	c_arload_
carloads	11	3	839	3	c_arloads
chalah	14	35	1166	3	cha_la_h
chalahs	15	28	988	3	cha_lahs
chalaza	21	4	573	3	cha_laza
chalky	18	46	877	3	cha_l_ky
challa	11	40	1419	3	challa__
challah	15	45	832	3	challa_h
challahs	16	37	756	3	challahs
challas	12	44	1412	3	challa_s
chally	14	43	1429	3	cha_l_ly
chamade	15	13	845	3	cha_made
chaplain	15	4	619	3	chaplain
charades	14	13	1085	3	char_ades
charas	11	42	2361	3	char_a_s
charcoaly	19	15	317	3	charcoaly
chard	11	61	2474	3	char__d_
chards	12	51	1973	3	char__ds
chared	12	54	2369	3	char_ed_
charged	14	46	1402	3	charged_
charily	15	3	1028	3	char_ily
charity	15	3	1102	3	char_ity
charka	15	40	1170	3	charka__
charkas	16	48	1096	3	charka_s
charked	17	48	1401	3	charked_
charladies	16	4	402	3	charladies
charlatan	14	4	354	3	charlatan
charleys	16	9	563	3	charleys
charlie	12	30	1192	3	charl_ie
charlies	13	34	1423	3	charlies
charlock	19	4	439	3	charlock
charmed	15	47	1425	3	charmed_
charpai	14	3	663	3	charpa_i
charpais	15	3	693	3	charpais
charpoy	17	3	571	3	char_poy
charred	13	46	1449	3	charred_
charry	14	50	1211	3	char__ry
charted	13	51	1685	3	charted_
chartulary	18	5	170	3	chartulary
chary	13	50	2313	3	char___y
chorally	16	3	810	3	chorally
hardy	12	56	2206	3	_har__dy
malady	12	3	786	3	_ma_lady
parlay	11	37	1399	3	_parla_y
pharmacy	20	4	324	3	pharmacy
thready	14	43	590	3	th_ready

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	146162	0.423	422437.4
2	DLD Change Limit	146162	49	7.016	20832.7
3	Display Results	49	49	0.013	3769.2
	(SQL Overall)	178691	49	7.452	23978.9