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

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

73 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
refraction	15	13	790	(None)
refractions	16	12	772	1	refractions
retraction	12	13	1053	1	retraction
detraction	13	13	858	2	detraction
fraction	13	5	948	2	__fraction
infraction	15	5	745	2	infraction
reaction	10	6	1260	2	re__action
redaction	12	5	966	2	re_daction
refection	14	15	1228	2	ref_ection
reflation	12	4	1233	2	refla_tion
reflection	15	16	899	2	reflection
refractile	15	4	414	2	refractile
refracting	16	3	873	2	refracting
refractive	18	4	669	2	refractive
refractor	14	15	632	2	refract_or
retractions	13	9	1035	2	retractions
retroaction	13	4	736	2	retroaction
aeration	8	3	1993	3	ae_ra_tion
attraction	12	7	695	3	attraction
defecation	16	7	980	3	defecation
defection	15	16	1064	3	def_ection
deflation	13	3	1065	3	defla_tion
deflection	16	14	773	3	deflection
detractions	14	11	827	3	detractions
diffraction	20	5	349	3	diffraction
erection	10	21	1551	3	_e_rection
exaction	17	3	895	3	_e_xaction
extraction	19	6	798	3	extraction
faction	12	26	1333	3	__f_action
fractions	14	4	910	3	__fractions
friction	13	4	791	3	__friction
infarction	15	4	579	3	infarction
infractions	16	4	696	3	infractions
olfaction	14	6	423	3	olf_action
overaction	15	4	799	3	overaction
perfection	17	4	836	3	perfection
protraction	15	4	721	3	protraction
rarefaction	16	5	265	3	raref_action
reactions	11	7	1171	3	re__actions
recaution	11	4	809	3	re_caution
recreation	12	4	1361	3	recreation
redactions	13	5	913	3	re_dactions
redirection	14	4	605	3	redirection
reduction	12	5	990	3	re_duction
reelection	12	19	863	3	reelection
refashion	15	4	335	3	ref_ashion
refections	15	18	1164	3	ref_ections
reflations	13	3	1123	3	refla_tions
reflections	16	17	855	3	reflections
reformation	16	4	841	3	reformation
refract	12	13	1160	3	refract___
refracted	15	5	739	3	refract_ed
refractors	15	15	627	3	refractors
refractory	18	13	477	3	refractory
refracts	13	13	738	3	refract__s
refrain	10	3	1004	3	refra__i_n
refutation	13	4	991	3	refutation
reification	16	4	1290	3	reification
rejection	18	17	1025	3	re_jection
relation	8	26	1977	3	re_la_tion
reliction	11	3	1069	3	re_liction
relocation	12	3	1211	3	relocation
reparation	12	6	1272	3	reparation
resection	11	16	1327	3	re_section
restation	9	3	1691	3	resta_tion
restriction	13	4	936	3	restriction
retractile	12	4	625	3	retractile
retracting	13	3	1193	3	retracting
retractor	11	21	851	3	retract_or
retroactions	14	4	707	3	retroactions
revocation	15	4	1081	3	revocation
serration	9	4	1406	3	serra_tion
traction	10	4	1268	3	__traction

Search took 7 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.420	425454.8
2	DLD Change Limit	140603	73	6.033	23305.7
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	6.483	27563.0