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

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

86 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
charmed	15	47	1425	(None)
chared	12	54	2369	1	char_ed
charged	14	46	1402	1	charged
charked	17	48	1401	1	charked
charmer	14	49	1366	1	charmer
charred	13	46	1448	1	charred
charted	13	51	1685	1	charted
chasmed	15	47	1017	1	chasmed
chirmed	15	37	973	1	chirmed
harmed	12	52	1883	1	_harmed
alarmed	10	3	773	2	alarmed
armed	8	63	2443	2	__armed
becharmed	19	4	466	2	becharmed
calmed	11	48	1638	2	c_almed
carded	10	54	2490	2	c_arded
cared	8	60	5009	2	c_ar_ed
caried	9	45	2869	2	c_aried
carked	13	40	2482	2	c_arked
carmen	10	40	1934	2	c_armen
caromed	12	37	1362	2	c_aromed
carped	11	59	2376	2	c_arped
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
chaired	13	42	1124	2	chaired
chairmen	15	10	547	2	chairmen
chalked	17	44	986	2	chalked
chammied	18	21	597	2	chammied
champed	17	41	1148	2	champed
chanced	15	41	1321	2	chanced
changed	14	42	1414	2	changed
chanted	13	40	1595	2	chanted
chapmen	16	3	728	2	chapmen
chapped	17	27	1144	2	chapped
charade	13	12	991	2	charade
chard	11	61	2474	2	char__d
chare	10	52	3198	2	char_e_
chares	11	56	3180	2	char_es
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
charm	12	61	2466	2	charm__
charmers	15	42	1133	2	charmers
charms	13	52	1884	2	charm_s
charnel	12	40	1005	2	charnel
charter	12	39	1830	2	charter
chased	12	50	1929	2	cha_sed
chassed	13	47	1213	2	chassed
chatted	13	34	1189	2	chatted
chawed	15	52	1460	2	cha_wed
chimed	14	58	1483	2	ch_imed
chirked	17	38	1033	2	chirked
chirped	15	37	978	2	chirped
chirred	13	36	1212	2	chirred
chorded	14	47	1055	2	chorded
chored	12	53	2188	2	chor_ed
chromed	15	35	1092	2	chromed
chummed	17	39	644	2	chummed
churned	13	35	837	2	churned
churred	13	40	917	2	churred
claimed	12	29	883	2	claimed
clammed	14	36	996	2	clammed
crammed	14	37	1012	2	crammed
farmed	12	51	1765	2	_farmed
hammed	14	41	1697	2	_hammed
hared	9	57	4218	2	_har_ed
harked	14	54	2255	2	_harked
harmer	11	47	1955	2	_harmer
harped	12	44	1840	2	_harped
inarmed	10	26	867	2	inarmed
rearmed	10	39	1282	2	rearmed
shamed	12	51	2021	2	sha_med
shammed	15	39	1142	2	shammed
shared	10	58	2906	2	shar_ed
sharked	15	36	1391	2	sharked
sharped	13	41	1205	2	sharped
swarmed	13	6	748	2	swarmed
unarmed	10	18	1192	2	unarmed
unharmed	14	3	809	2	unharmed
warmed	12	45	1689	2	_warmed
whammed	18	34	513	2	whammed
wharfed	17	3	441	2	wharfed

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	107671	0.143	1249587.4
2	DLD Change Limit	107671	86	7.093	15179.9
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	7.266	24592.8