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

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

89 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
charred	13	46	1448	(None)
chaired	13	42	1124	1	chaired
chared	12	54	2369	1	cha_red
charged	14	46	1402	1	charged
charked	17	48	1401	1	charked
charmed	15	47	1425	1	charmed
charted	13	51	1685	1	charted
chirred	13	36	1212	1	chirred
churred	13	40	917	1	churred
barred	9	57	2579	2	_barred
carded	10	54	2490	2	c_arded
cared	8	60	5009	2	c_a_red
caried	9	45	2869	2	c_aried
carked	13	40	2482	2	c_arked
carped	11	59	2376	2	c_arped
carrel	8	47	1863	2	c_arrel
carried	10	37	1715	2	c_arried
carted	9	86	3144	2	c_arted
carved	12	43	2085	2	c_arved
chafed	15	48	1391	2	cha_fed
chaffed	19	38	770	2	chaffed
chained	13	38	1269	2	chained
chalked	17	44	986	2	chalked
champed	17	41	1148	2	champed
chanced	15	41	1321	2	chanced
changed	14	42	1414	2	changed
chanted	13	40	1595	2	chanted
chapped	17	27	1144	2	chapped
charade	13	12	991	2	charade
chard	11	61	2474	2	cha_r_d
chare	10	52	3198	2	cha_re_
chares	11	56	3180	2	cha_res
charge	12	51	1421	2	charge_
charger	13	39	1406	2	charger
charges	13	46	1598	2	charges
charier	12	43	1790	2	charier
charley	15	11	827	2	charley
charmer	14	49	1366	2	charmer
charnel	12	40	1005	2	charnel
charr	10	48	2178	2	charr__
charrier	13	7	868	2	charrier
charro	11	42	1295	2	charr_o
charros	12	43	1214	2	charros
charrs	11	52	1919	2	charr_s
charry	14	50	1211	2	charr_y
charter	12	39	1830	2	charter
chartered	15	15	839	2	chartered
chased	12	50	1929	2	cha_sed
chasmed	15	47	1017	2	chasmed
chassed	13	47	1213	2	chassed
chatted	13	34	1189	2	chatted
chawed	15	52	1460	2	cha_wed
cheered	13	37	1329	2	cheered
chirked	17	38	1033	2	chirked
chirmed	15	37	973	2	chirmed
chirped	15	37	978	2	chirped
chirre	11	41	1185	2	chirre_
chirren	12	38	874	2	chirren
chirres	12	38	1225	2	chirres
choired	13	34	934	2	choired
chorded	14	47	1055	2	chorded
chored	12	53	2188	2	ch_ored
churned	13	35	837	2	churned
curred	9	43	1926	2	c_urred
garred	8	52	1740	2	_garred
gnarred	9	32	700	2	gnarred
haired	10	51	1717	2	_haired
hared	9	57	4218	2	_ha_red
harked	14	54	2255	2	_harked
harmed	12	52	1883	2	_harmed
harped	12	44	1840	2	_harped
harried	11	38	1553	2	_harried
hatred	10	48	1433	2	_hatred
jarred	14	46	1325	2	_jarred
knarred	12	26	600	2	knarred
marred	9	54	2104	2	_marred
parred	9	50	2407	2	_parred
scarred	10	45	1263	2	scarred
shared	10	58	2906	2	sha_red
sharked	15	36	1391	2	sharked
sharped	13	41	1205	2	sharped
shirred	11	37	1050	2	shirred
sparred	10	45	1286	2	sparred
starred	8	50	1345	2	starred
tarred	7	47	2028	2	_tarred
uncharred	15	3	610	2	uncharred
warred	10	40	1984	2	_warred
wharfed	17	3	441	2	wharfed
whirred	14	38	693	2	whirred

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	89	3.420	31482.7
3	Display Results	89	89	0.033	2697.0
	(SQL Overall)	178691	89	3.829	46667.8