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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

104 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
codirection	16	4	474	(None)
codirections	17	4	470	1	codirections
codirecting	17	4	364	2	codirecting
codirector	15	5	327	2	codirect_or
correction	14	4	881	2	co_rrection
direction	12	8	978	2	__direction
indirection	14	5	638	2	indirection
redirection	14	4	605	2	redirection
codification	20	10	807	3	codification
codirect	13	10	629	3	codirect___
codirected	16	5	300	3	codirect_ed
codirectors	16	5	334	3	codirectors
codirects	14	9	359	3	codirect__s
collection	14	4	820	3	co_llection
concretion	14	4	929	3	concre_tion
confection	17	4	1118	3	co_nfection
connection	14	4	1053	3	co_nnection
contraction	15	4	1124	3	contraction
convection	17	4	1112	3	co_nvection
corrections	15	4	886	3	co_rrections
directions	13	7	964	3	__directions
indirections	15	5	619	3	indirections
misdirection	17	5	416	3	misdirection
redirections	15	4	617	3	redirections
addiction	13	14	601	4	addi__ction
advection	15	4	555	4	_ad_vection
bidirectional	18	15	249	4	bidirectional
bijection	20	13	479	4	__bijection
bilection	13	15	680	4	__bilection
bisection	13	13	698	4	__bisection
bolection	13	11	767	4	bo__lection
coaction	12	3	1077	4	co___action
codifications	21	12	762	4	codifications
coercion	12	4	657	4	co_er_c_ion
coerecting	15	21	878	4	co_erecting
cofunction	17	4	525	4	co_function
cogitation	13	4	1008	4	cogi_tation
coition	9	3	1431	4	co_i___tion
collections	15	4	793	4	co_llections
coloration	12	9	1318	4	color_ation
compaction	18	4	675	4	co_mpaction
completion	16	4	730	4	comple_tion
compression	17	5	656	4	compression
compunction	19	11	590	4	compunction
conception	16	4	1045	4	co_nception
concoction	13	4	823	4	co_ncoction
concretions	15	4	929	4	concre_tions
condition	12	4	1116	4	condi___tion
conduction	15	4	996	4	co_nduction
confections	18	4	1139	4	co_nfections
confirmation	19	4	618	4	confirmation
confliction	18	4	523	4	confliction
congestion	13	4	904	4	co_ngestion
congregation	16	22	676	4	congregation
conjunction	22	4	562	4	conjunction
connections	15	4	1070	4	co_nnections
consecution	15	4	730	4	co_nsecution
constriction	16	4	826	4	constriction
construction	16	4	808	4	construction
contention	12	4	1222	4	co_ntention
contractions	16	4	1040	4	contractions
contraption	15	4	810	4	contraption
contrition	12	4	1141	4	contr_ition
conurbation	15	4	746	4	conurbation
convections	18	4	1149	4	co_nvections
convention	15	4	1056	4	co_nvention
conviction	17	4	818	4	co_nviction
cooperation	15	4	1002	4	cooperation
correcting	15	19	930	4	co_rrecting
correctional	16	7	532	4	co_rrectional
corrective	17	4	744	4	co_rrective
corrector	13	4	760	4	co_rrect_or
correlation	13	5	855	4	co_rrelation
corruption	14	5	537	4	co_rruption
covariation	16	4	677	4	covariation
creation	10	28	1651	4	c___reation
defection	15	16	1064	4	__defection
dejection	19	17	866	4	__dejection
detection	12	13	1041	4	__detection
diction	10	23	1305	4	__di__ction
digestion	11	4	657	4	__digestion
directing	13	3	882	4	__directing
directional	14	4	544	4	__directional
directive	15	5	777	4	__directive
director	11	4	778	4	__direct_or
dissection	13	15	861	4	__dissection
erection	10	21	1551	4	___erection
indiction	12	3	981	4	indi__ction
indigestion	13	5	375	4	indigestion
iodination	11	5	998	4	iodi_nation
midsection	15	4	443	4	mid_section
misdirections	18	5	423	4	misdirections
moderation	13	4	865	4	moder_ation
modification	20	10	720	4	modification
nondirectional	17	6	308	4	nondirectional
nondirective	18	5	468	4	nondirective
nonelection	13	4	720	4	nonelection
objection	20	4	509	4	_o_bjection
overaction	15	4	799	4	_overaction
predilection	17	5	410	4	predilection
redigestion	13	8	415	4	redigestion
redirecting	15	4	561	4	redirecting
trisection	12	4	598	4	_trisection
vivisection	19	5	270	4	vivisection

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	148819	0.406	440125.6
2	DLD Change Limit	148819	104	8.533	17440.4
3	Display Results	104	104	0.046	2260.9
	(SQL Overall)	178691	104	8.985	19887.7