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

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

56 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
catalectics	14	9	310	(None)
acatalectics	15	6	143	1	acatalectics
catalectic	13	8	460	1	catalectic_
cataleptics	17	8	284	1	cataleptics
acatalectic	14	5	212	2	acatalectic_
cataleptic	16	8	402	2	cataleptic_
analectic	13	4	723	3	_analectic_
analeptics	14	4	442	3	_analeptics
ataractics	14	4	423	3	_ataractics
athletics	14	10	582	3	_athle_tics
catalatic	13	4	732	3	catal_atic_
catalepsies	15	5	261	3	catalepsies
catalexis	18	4	495	3	catale_xi_s
catalytic	16	4	589	3	catal_ytic_
cathectic	15	4	524	3	cat_hectic_
dialectics	15	4	421	3	_dialectics
agalactias	13	5	313	4	_agalactias
analects	10	4	770	4	_analect__s
analeptic	13	4	651	4	_analeptic_
analgetics	13	18	436	4	_analgetics
analytics	14	4	551	4	_anal_ytics
anapestics	14	4	437	4	_anapestics
anorectics	14	4	451	4	_anorectics
atactic	11	4	1008	4	_ata__ctic_
ataractic	13	4	623	4	_ataractic_
athletic	13	11	865	4	_athle_tic_
cabalettas	14	5	262	4	cabale_ttas
cabalistic	16	4	571	4	cabalistic_
cachectic	14	4	320	4	ca_chectic_
candlestick	20	7	226	4	candlestick
candlesticks	21	7	164	4	candlesticks
catalexes	18	4	591	4	catale__xes
catalogic	14	4	668	4	catal_ogic_
catalysis	14	4	587	4	catal_ysi_s
catalysts	14	4	551	4	catalyst__s
cataplexies	22	5	217	4	cataple_xies
cataractous	15	5	214	4	cataractous
cataracts	13	4	558	4	cataract__s
catatonics	14	4	460	4	cata_tonics
catechins	16	4	664	4	cat__echins
cathartics	17	4	308	4	cat_hartics
cathecting	18	4	483	4	cat_hecting
cathects	15	4	579	4	cat_hect__s
catheptic	18	4	490	4	cat_heptic_
cavaletti	14	4	316	4	cavaletti__
dialectic	14	4	571	4	_dialectic_
dyslectics	18	10	279	4	_dyslectics
eclectics	12	5	481	4	__eclectics
eutectics	13	4	402	4	eut__ectics
fatalistic	15	4	671	4	fatalistic_
fatalities	13	4	944	4	fatal_ities
natalities	10	4	1066	4	natal_ities
paralytics	17	4	520	4	paral_ytics
tabetics	12	4	568	4	__tabe_tics
tactics	11	4	932	4	__ta__ctics
telestics	11	9	696	4	__telestics

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.420	425454.8
2	DLD Change Limit	148819	56	8.266	18003.8
3	Display Results	56	56	0.030	1866.7
	(SQL Overall)	178691	56	8.716	20501.5