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

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

55 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
counteraction	17	5	538	(None)
counteractions	18	5	502	1	counteractions
contraction	15	4	1124	2	co_nt_raction
counteracting	18	5	628	2	counteracting
counteractive	20	5	595	2	counteractive
counterreaction	19	10	237	2	counterreaction
contractions	16	4	1040	3	co_nt_ractions
contraption	15	4	810	3	co_nt_raption
counteract	14	4	960	3	counteract___
counteracted	17	4	736	3	counteract_ed
counteracts	15	4	751	3	counteract__s
counterion	12	4	953	3	counter___ion
countertactic	16	6	391	3	countertacti_c
countertactics	17	6	336	3	countertactics
interaction	13	4	1181	3	__interaction
adulteration	13	5	366	4	adultera_tion
cogeneration	15	4	644	4	cogenera_tion
confection	17	4	1118	4	co_nfe__ction
congelation	14	4	1034	4	co_ngela_tion
conjuration	20	4	951	4	co_njura_tion
connection	14	4	1053	4	co_nne__ction
consecration	16	4	978	4	co_nsecra_tion
conservation	17	4	940	4	co_nservation
consternation	15	10	636	4	consternation
constriction	16	4	826	4	co_nstriction
construction	16	4	808	4	co_nstruction
contention	12	4	1222	4	co_nte__ntion
contestation	14	4	866	4	co_ntestation
contortion	12	4	866	4	co_ntor__tion
contraception	19	5	375	4	co_nt_raception
contractile	15	4	735	4	co_nt_ractile
contracting	16	6	1047	4	co_nt_racting
contractional	17	5	606	4	co_nt_ractional
contractive	18	4	952	4	co_nt_ractive
contractor	14	4	907	4	co_nt_ract_or
contradiction	18	5	456	4	co_nt_radiction
contraptions	16	4	764	4	co_nt_raptions
contrition	12	4	1141	4	co_nt_r_ition
convection	17	4	1112	4	co_nve__ction
conversation	17	4	780	4	co_nversation
cooperation	15	4	1002	4	co_opera_tion
counterattack	21	7	273	4	counterattack
countercries	16	4	899	4	counter_cries
counterfactual	21	6	182	4	counterfactual
counterions	13	4	982	4	counter___ions
counterpetition	19	6	194	4	counterpetition
counterquestion	26	7	121	4	counterquestion
countersign	14	4	724	4	counter__sign
counterstain	14	15	678	4	counter_stain
countertop	14	4	584	4	counter__t_op
deuteration	12	4	910	4	deu_tera_tion
exenteration	19	5	529	4	exentera_tion
interactions	14	4	1046	4	__interactions
overaction	15	4	799	4	_o__veraction
subtraction	15	4	562	4	_subt_raction

Search took 6 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	95024	0.343	520965.0
2	DLD Change Limit	95024	55	5.126	18537.7
3	Display Results	55	55	0.030	1833.3
	(SQL Overall)	178691	55	5.499	32495.2