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

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

79 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
reelection	12	19	863	(None)
preelection	15	13	648	1	preelection
reelections	13	16	794	1	reelections
reflection	15	16	899	1	reflection
deflection	16	14	773	2	deflection
election	10	20	1535	2	__election
prelection	14	15	1129	2	prelection
preselection	16	15	488	2	preselection
reelecting	13	3	878	2	reelecting
refection	14	15	1228	2	r_efection
reflections	16	17	855	2	reflections
rejection	18	17	1025	2	r_ejection
reliction	11	3	1069	2	r_eliction
repletion	11	4	769	2	reple_tion
resection	11	16	1327	2	r_esection
selection	11	3	1127	2	_selection
bilection	13	15	680	3	_bilection
bolection	13	11	767	3	_bolection
collection	14	4	820	3	collection
defection	15	16	1064	3	_defection
deflections	17	18	732	3	deflections
dejection	19	17	866	3	_dejection
deletion	9	20	1197	3	_dele_tion
depletion	12	5	666	3	deple_tion
dereliction	14	4	457	3	dereliction
detection	12	13	1041	3	_detection
ejection	17	25	1004	3	__ejection
elections	11	24	1497	3	__elections
electron	10	26	1141	3	__electron
erection	10	21	1551	3	__erection
evection	13	19	1083	3	__evection
exsection	18	4	749	3	_exsection
flection	13	23	956	3	__flection
inflection	15	4	763	3	inflection
lection	9	26	1486	3	___lection
nonelection	13	4	720	3	nonelection
perfection	17	4	836	3	perfection
predilection	17	5	410	3	predilection
preelecting	16	4	647	3	preelecting
prelections	15	12	1047	3	prelections
preselections	17	14	444	3	preselections
reaction	10	6	1260	3	r_e_action
reception	13	4	1033	3	r_eception
recollection	16	5	485	3	recollection
recreation	12	4	1361	3	recreation
redaction	12	5	966	3	r_edaction
redirection	14	4	605	3	redirection
reduction	12	5	990	3	r_eduction
reedition	10	4	783	3	ree_dition
reeducation	14	4	593	3	reeducation
reejecting	20	4	581	3	reejecting
reelect	9	115	1563	3	reelect___
reelected	12	3	831	3	reelect_ed
reelects	10	31	1088	3	reelect__s
reerecting	13	3	997	3	reerecting
refections	15	18	1164	3	r_efections
reflation	12	4	1233	3	refl_ation
reflecting	16	3	882	3	reflecting
reflectional	17	5	399	3	reflectional
reflective	18	5	712	3	reflective
reflector	14	4	573	3	reflect_or
reflexion	19	4	361	3	refle_xion
refraction	15	13	790	3	refraction
reinfection	16	4	544	3	reinfection
reinjection	20	4	458	3	reinjection
rejections	19	15	1010	3	r_ejections
relation	8	26	1977	3	r_el_ation
relegation	11	6	1002	3	relegation
relictions	12	3	1002	3	r_elictions
relocation	12	3	1211	3	r_elocation
repletions	12	4	747	3	reple_tions
replication	15	7	1201	3	replication
resections	12	15	1303	3	r_esections
reselecting	14	4	602	3	reselecting
retention	9	16	1148	3	r_etention
retraction	12	13	1053	3	retraction
revelation	13	4	1092	3	revel_ation
selections	12	3	1087	3	_selections
venesection	16	5	294	3	venesection

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.440	406115.9
2	DLD Change Limit	140603	79	7.156	19648.3
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	7.626	23431.8