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

Here are the results of your fuzzy-string dictionary search for “correction” 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
correction	14	4	881	(None)
corrections	15	4	886	1	corrections
codirection	16	4	474	2	codirection
collection	14	4	820	2	collection
confection	17	4	1118	2	confection
connection	14	4	1053	2	connection
convection	17	4	1112	2	convection
correcting	15	19	930	2	correcting
correctional	16	7	532	2	correctional
corrective	17	4	744	2	corrective
corrector	13	4	760	2	correct_or
correlation	13	5	855	2	correlation
corruption	14	5	537	2	corruption
bolection	13	11	767	3	bo_lection
coaction	12	3	1077	3	co__action
codirections	17	4	470	3	codirections
coercion	12	4	657	3	coer_c_ion
coerecting	15	21	878	3	coerecting
cofunction	17	4	525	3	cofunction
collections	15	4	793	3	collections
compaction	18	4	675	3	compaction
conception	16	4	1045	3	conception
concoction	13	4	823	3	concoction
concretion	14	4	929	3	concre_tion
conduction	15	4	996	3	conduction
confections	18	4	1139	3	confections
congestion	13	4	904	3	congestion
connections	15	4	1070	3	connections
consecution	15	4	730	3	consecution
contention	12	4	1222	3	contention
contraction	15	4	1124	3	contraction
convections	18	4	1149	3	convections
convention	15	4	1056	3	convention
conviction	17	4	818	3	conviction
coronation	12	4	1207	3	coronation
corotation	12	4	1097	3	corotation
corrasion	11	4	648	3	corr_asion
correct	11	5	1398	3	correct___
corrected	14	3	811	3	correct_ed
correcter	13	4	810	3	correct_er
correctest	14	4	560	3	correctest
correctives	18	4	557	3	correctives
correctly	16	4	496	3	correct_ly
correctors	14	4	749	3	correctors
corrects	12	5	957	3	correct__s
correlations	14	4	786	3	correlations
corrosion	11	4	605	3	corr_osion
corrugation	14	4	599	3	corrugation
corruptions	15	5	517	3	corruptions
coruscation	15	4	569	3	coruscation
creation	10	28	1651	3	c__reation
direction	12	8	978	3	_direction
erection	10	21	1551	3	__erection
objection	20	4	509	3	_objection
perfection	17	4	836	3	perfection
projection	21	5	876	3	projection
protection	14	5	1147	3	protection
surjection	19	7	490	3	surjection

Search took 8 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	140603	0.406	440125.6
2	DLD Change Limit	140603	58	7.000	20086.1
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	7.436	24030.5