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

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

90 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
changed	14	42	1414	(None)
chanced	15	41	1321	1	chanced
change	12	41	1675	1	change_
changer	13	42	1554	1	changer
changes	13	45	1758	1	changes
chanted	13	40	1595	1	chanted
charged	14	46	1402	1	charged
clanged	11	42	1265	1	clanged
hanged	11	42	2240	1	_hanged
whanged	15	44	761	1	whanged
banged	10	49	2373	2	_banged
cadged	11	48	1234	2	c_adged
caged	9	54	2636	2	c_a_ged
caned	8	58	3809	2	c_an_ed
canned	9	50	2206	2	c_anned
canoed	9	46	1896	2	c_anoed
canted	9	48	2578	2	c_anted
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
chance	13	46	1709	2	chance_
chancel	14	40	1178	2	chancel
chancer	14	42	1563	2	chancer
chances	14	52	1809	2	chances
chang	11	54	1856	2	chang__
changers	14	43	1320	2	changers
changeup	16	4	268	2	changeup
changs	12	52	1537	2	chang_s
channel	12	39	1049	2	channel
chanter	12	39	1973	2	chanter
chantey	15	41	1254	2	chantey
chapped	17	27	1144	2	chapped
chared	12	54	2369	2	cha_red
charge	12	51	1421	2	charge_
charger	13	39	1406	2	charger
charges	13	46	1598	2	charges
charked	17	48	1401	2	charked
charmed	15	47	1425	2	charmed
charred	13	46	1449	2	charred
charted	13	51	1685	2	charted
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
chaunted	14	8	560	2	chaunted
chawed	15	52	1460	2	cha_wed
chined	12	56	2006	2	chin_ed
chinked	17	40	1102	2	chinked
chinned	13	48	1050	2	chinned
chugged	15	8	482	2	chugged
chunked	17	42	821	2	chunked
clagged	12	74	923	2	clagged
clanger	10	41	1349	2	clanger
clanked	14	38	1225	2	clanked
clinged	11	33	1009	2	clinged
cragged	12	47	988	2	cragged
craned	9	61	2165	2	cran_ed
cranked	14	38	1284	2	cranked
cringed	11	33	1240	2	cringed
danged	9	48	1949	2	_danged
exchanged	23	11	367	2	exchanged
fanged	11	43	1823	2	_fanged
flanged	12	38	1084	2	flanged
ganged	9	46	1920	2	_ganged
hagged	12	43	1770	2	_hagged
handed	11	49	1998	2	_handed
hanger	10	40	2326	2	_hanger
hanked	14	42	2060	2	_hanked
hanted	10	41	2431	2	_hanted
hinged	11	46	1892	2	_hinged
panged	10	47	2234	2	_panged
pranged	11	45	1255	2	pranged
ranged	8	48	2432	2	_ranged
rechanged	16	4	685	2	rechanged
rehanged	13	5	783	2	rehanged
shagged	13	42	1013	2	shagged
shanked	15	32	1212	2	shanked
slanged	9	41	1285	2	slanged
stanged	9	41	1385	2	stanged
tanged	8	46	2251	2	_tanged
thanked	15	46	915	2	thanked
thonged	12	37	684	2	thonged
twanged	12	38	728	2	twanged
unchanged	16	3	628	2	unchanged
unhanged	13	25	883	2	unhanged
whangee	14	26	862	2	whangee
whinged	15	40	915	2	whinged

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.360	496363.9
2	DLD Change Limit	107671	90	3.170	33965.6
3	Display Results	90	90	0.033	2727.3
	(SQL Overall)	178691	90	3.563	50151.8