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

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

70 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
complexation	25	14	424	(None)
complexations	26	13	401	1	complexations
compellation	18	5	510	2	compellation
completion	16	4	730	2	comple__tion
complexion	23	4	375	2	complex__ion
complication	20	4	820	2	complication
compellations	19	5	481	3	compellations
compensation	18	12	650	3	compensation
competition	17	5	577	3	comp_etition
compilation	17	4	931	3	comp_ilation
completions	17	4	691	3	comple__tions
complexions	24	4	362	3	complex__ions
complexities	25	11	383	3	complexities
complications	21	4	743	3	complications
compurgation	19	13	418	3	compurgation
computation	17	4	871	3	comp_utation
cooperation	15	4	1002	3	coop_eration
coaptation	14	4	834	4	coap__tation
cogeneration	15	4	644	4	cogeneration
collation	11	3	1399	4	co__l_lation
collection	14	4	820	4	co_lle_ction
colligation	14	5	744	4	co_lligation
collimation	15	5	757	4	co_llimation
collocation	15	4	717	4	co_llocation
coloration	12	9	1318	4	co__loration
combination	17	10	880	4	com_bination
commendation	19	4	651	4	commendation
commination	17	11	1164	4	com_mination
commiseration	19	6	404	4	commiseration
commutation	17	4	800	4	com_mutation
compaction	18	4	675	4	comp__action
companion	15	7	768	4	comp___anion
compensations	19	13	618	4	compensations
competitions	18	4	553	4	comp_etitions
compilations	18	4	868	4	comp_ilations
complain	14	4	876	4	compl__a_i_n
compleat	14	7	1015	4	comple_at___
complecting	20	4	576	4	comple_cting
complementation	23	9	269	4	complementation
completing	17	4	842	4	comple__ting
completive	19	4	623	4	comple__tive
complexified	29	14	179	4	complexified
complexifies	28	12	224	4	complexifies
complexify	29	5	229	4	complex__ify
complexing	24	4	474	4	complex__ing
complexional	25	5	196	4	complex__ional
complexioned	26	5	181	4	complex__ioned
complexity	26	5	343	4	complex__ity
complicating	21	4	563	4	complicating
composition	17	4	679	4	comp_osition
compression	17	5	656	4	compre_ssion
compunction	19	11	590	4	comp_unction
compurgations	20	12	389	4	compurgations
computations	18	4	812	4	comp_utations
conflation	15	4	1208	4	confl__ation
congelation	14	4	1034	4	co_ngelation
conglobation	17	5	425	4	conglobation
congregation	16	22	676	4	congregation
cooperations	16	5	919	4	coop_erations
copulation	14	11	1195	4	co_p_ulation
corporation	15	12	1065	4	corp_oration
correlation	13	5	855	4	co_rrelation
cumulation	14	4	817	4	cumul__ation
cupellation	15	4	414	4	c_upellation
homologation	18	12	265	4	homologation
impletion	13	4	540	4	_imple__tion
implication	17	4	777	4	_implication
imprecation	17	4	654	4	_imprecation
operation	11	3	1400	4	_o_p_eration
toleration	10	4	896	4	to__leration

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	124790	0.390	458182.1
2	DLD Change Limit	124790	70	7.813	15972.1
3	Display Results	70	70	0.046	1521.7
	(SQL Overall)	178691	70	8.249	21662.1