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

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

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.

54 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
subchapters	20	5	204	(None)
subchapter	19	5	237	1	subchapter_
subchasers	17	4	328	2	subcha_sers
chapters	15	40	1213	3	___chapters
subcastes	13	8	749	3	subc_aste_s
subcenters	14	4	616	3	subc_enters
subchaser	16	4	431	3	subcha_ser_
subclusters	15	5	265	3	subclusters
subtracters	15	7	380	3	subtracters
chanters	13	40	1674	4	___chanters
chapiters	16	3	520	4	___chapiters
chapter	14	42	1385	4	___chapter_
charters	13	41	1558	4	___charters
chatters	13	42	1395	4	___chatters
enchanters	15	4	522	4	_enchanters
outcapers	13	4	438	4	outc_ap_ers
purchasers	17	4	255	4	purcha_sers
recharters	15	5	542	4	_recharters
scatters	10	36	1275	4	s__c_atters
scepters	12	3	779	4	s__c_epters
schappes	17	3	603	4	s__chappe_s
schnappers	19	4	214	4	s__chnappers
scrapers	12	55	1053	4	s__crap_ers
scrappers	15	4	586	4	s__crappers
scripters	13	11	668	4	s__cripters
shapers	12	40	1689	4	s___hap_ers
shatters	11	33	1391	4	s___hatters
subaltern	11	4	324	4	sub__altern
subalterns	12	4	222	4	sub__alterns
subcaste	12	8	785	4	subc_aste__
subcauses	13	4	621	4	subc_ause_s
subcenter	13	4	707	4	subc_enter_
subchiefs	19	4	274	4	subch__iefs
subclasses	14	4	474	4	subclasse_s
subclauses	14	5	388	4	subclause_s
subcluster	14	4	314	4	subcluster_
subcutes	12	3	858	4	subc__ute_s
subdealers	13	4	411	4	subdea_lers
sublates	10	3	1500	4	sub_la_te_s
submitters	14	4	444	4	sub_mitters
subphases	16	4	575	4	subpha_se_s
subshafts	17	4	309	4	subshaft__s
subsisters	12	4	502	4	sub_sisters
substates	11	14	1033	4	substa_te_s
subtracter	14	5	462	4	subtracter_
subverters	15	4	461	4	sub_verters
subwriters	15	4	441	4	sub_writers
sulphates	14	6	616	4	sulpha_te_s
sumpters	12	3	802	4	su___mpters
supplanters	15	11	304	4	supplanters
surcharges	16	4	401	4	surcharge_s
trochanters	16	5	343	4	trochanters
unchaster	14	4	539	4	_unchaster_
webcasters	17	4	214	4	webc_asters

Search took 9 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	148819	0.406	440125.6
2	DLD Change Limit	148819	54	8.500	17508.1
3	Display Results	54	54	0.016	3375.0
	(SQL Overall)	178691	54	8.922	20028.1