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

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

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.

58 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
convocation	18	4	788	(None)
convocations	19	4	736	1	convocations
collocation	15	4	717	2	collocation
concoction	13	4	823	2	concoc_tion
condonation	14	4	885	2	condonation
connotation	13	4	798	2	connotation
consociation	16	4	819	2	consociation
consolation	13	4	1098	2	consolation
convection	17	4	1112	2	convec_tion
conviction	17	4	818	2	convic_tion
convocational	20	5	447	2	convocational
convolution	16	4	512	2	convolution
invocation	15	4	754	2	_invocation
advocation	16	4	574	3	_advocation
avocation	14	16	899	3	__avocation
coeducation	16	4	623	3	coeducation
coevolution	16	5	422	3	coevolution
collocations	16	4	640	3	collocations
coloration	12	9	1318	3	co_loration
conation	10	14	2088	3	con___ation
concoctions	14	4	825	3	concoc_tions
condonations	15	4	800	3	condonations
conduction	15	4	996	3	conduc_tion
confection	17	4	1118	3	confec_tion
confiscation	19	4	553	3	confiscation
conflation	15	4	1208	3	con_flation
conformation	19	4	732	3	conformation
confutation	16	6	872	3	confutation
congelation	14	4	1034	3	congelation
conglobation	17	5	425	3	conglobation
conjugation	21	4	662	3	conjugation
conjuration	20	4	951	3	conjuration
connation	11	3	1426	3	con__nation
connection	14	4	1053	3	connec_tion
connotations	14	4	728	3	connotations
consecration	16	4	978	3	consecration
consecution	15	4	731	3	consecution
consociations	17	4	751	3	consociations
consolations	14	4	974	3	consolations
contortion	12	4	866	3	conto_rtion
contraction	15	4	1124	3	contraction
conurbation	15	4	746	3	conurbation
convections	18	4	1149	3	convec_tions
convention	15	4	1056	3	conv_ention
conversation	17	4	780	3	conversation
convictions	18	4	804	3	convic_tions
convolutions	17	4	519	3	convolutions
coronation	12	4	1207	3	co_ronation
corotation	12	4	1097	3	co_rotation
corporation	15	12	1065	3	corporation
coruscation	15	4	569	3	coruscation
evocation	14	20	1029	3	__evocation
invocations	16	4	706	3	_invocations
nonvocational	18	5	370	3	nonvocational
provocation	18	4	735	3	provocation
revocation	15	4	1081	3	_revocation
sonication	12	4	1118	3	son_ication
vocation	13	23	1198	3	___vocation

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	121633	0.376	475242.0
2	DLD Change Limit	121633	58	5.563	21864.6
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	5.969	29936.5