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

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

75 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
charged	14	46	1402	(None)
changed	14	42	1414	1	changed
chared	12	54	2369	1	char_ed
charge	12	51	1421	1	charge_
charger	13	39	1406	1	charger
charges	13	46	1598	1	charges
charked	17	48	1401	1	charked
charmed	15	47	1425	1	charmed
charred	13	46	1448	1	charred
charted	13	51	1685	1	charted
barged	10	58	2264	2	_barged
cadged	11	48	1234	2	c_adged
caged	9	54	2636	2	c_a_ged
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
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
chalked	17	44	986	2	chalked
champed	17	41	1148	2	champed
chanced	15	41	1321	2	chanced
change	12	41	1675	2	change_
changer	13	42	1554	2	changer
changes	13	45	1758	2	changes
chanted	13	40	1595	2	chanted
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
chargers	14	40	1132	2	chargers
charier	12	43	1790	2	charier
charley	15	11	827	2	charley
charmer	14	49	1366	2	charmer
charnel	12	40	1005	2	charnel
charter	12	39	1830	2	charter
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
chirked	17	38	1033	2	chirked
chirmed	15	37	973	2	chirmed
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
chugged	15	8	482	2	chugged
churned	13	35	837	2	churned
churred	13	40	917	2	churred
clagged	12	74	923	2	clagged
clanged	11	42	1265	2	clanged
cragged	12	47	988	2	cragged
hagged	12	43	1770	2	_hagged
hanged	11	42	2239	2	_hanged
hared	9	57	4218	2	_har_ed
harked	14	54	2255	2	_harked
harmed	12	52	1883	2	_harmed
harped	12	44	1840	2	_harped
parged	10	49	2204	2	_parged
recharged	16	5	633	2	recharged
shagged	13	42	1013	2	shagged
shared	10	58	2906	2	shar_ed
sharked	15	36	1391	2	sharked
sharped	13	41	1205	2	sharped
sparged	11	35	1276	2	sparged
uncharged	16	3	661	2	uncharged
whanged	15	44	761	2	whanged
wharfed	17	3	441	2	wharfed

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.390	458182.1
2	DLD Change Limit	107671	75	2.890	37256.4
3	Display Results	75	75	0.030	2500.0
	(SQL Overall)	178691	75	3.310	53985.2