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

Here are the results of your fuzzy-string dictionary search for “accordionists” with Change Limit: [1] [2] [3] [4] [5] [6]

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.

36 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
accordionists	18	6	149	(None)
accordionist	17	6	187	1	accordionist_
abortionists	14	5	497	3	a_bortionists
accordions	15	5	273	3	accordion___s
abortionist	13	5	616	4	a_bortionist_
accompanists	20	6	211	4	acco_mpanists
accordion	14	4	312	4	accordion____
adoptionists	15	5	392	4	a_doptionists
excursionists	22	8	272	4	excursionists
extortionists	20	7	438	4	extortionists
abolitionists	15	13	422	5	abolitionists
accompanist	19	5	301	5	acco_mpanist_
accordances	15	5	319	5	accord_an_ces
accordant	14	4	535	5	accord_an__t_
according	15	4	527	5	accordi_n___g
accordingly	20	6	202	5	accordi_n_gly
acrodonts	12	4	452	5	acro_d_on__ts
adoptionisms	17	5	335	5	a_doptionisms
adoptionist	14	5	496	5	a_doptionist_
arsonists	9	4	741	5	a___r_sonists
cartoonists	13	8	440	5	__cartoonists
colonists	11	25	1250	5	__co__lonists
contortionists	16	10	336	5	contortionists
cordonnets	13	4	353	5	__cord_onnets
crayonists	15	4	413	5	__c_rayonists
creationists	14	7	662	5	_creationists
diversionists	17	6	325	5	diversionists
elocutionists	15	5	431	5	elocutionists
exclusionists	22	6	333	5	exclusionists
excursionist	21	7	320	5	excursionist_
extortionist	19	7	531	5	extortionist_
fictionists	16	5	599	5	fic__tionists
receptionists	17	5	477	5	receptionists
recordists	13	4	440	5	record___ists
secessionists	14	6	333	5	secessionists
vacationists	17	5	458	5	vac_ationists

Search took 10 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	124790	0.403	443402.0
2	DLD Change Limit	124790	36	9.033	13814.9
3	Display Results	36	36	0.016	2250.0
	(SQL Overall)	178691	36	9.452	18905.1