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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

175 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
redemptions	16	4	373	(None)
redemption	15	4	388	1	redemption_
ademptions	15	4	338	2	_ademptions
exemptions	21	6	483	2	_exemptions
preemptions	17	13	485	2	pre_emptions
receptions	14	4	974	2	rece_ptions
redemptioner	17	6	117	2	redemptioner
redemptioners	18	6	89	2	redemptioners
resumptions	15	15	459	2	resumptions
ademption	14	4	349	3	_ademption_
deceptions	15	4	786	3	dece_ptions
demotions	12	5	844	3	__demotions
exemption	20	6	494	3	_exemption_
federations	15	4	888	3	federations
preemption	16	10	525	3	pre_emption_
presumptions	18	15	388	3	presumptions
reception	13	4	1032	3	rece_ption_
redactions	13	5	913	3	red_actions
redemptive	18	5	330	3	redempti_ve
redemptory	18	5	222	3	redempt_ory
reductions	13	5	958	3	red_uctions
reeditions	11	4	765	3	re_editions
refections	15	18	1164	3	refe_ctions
rejections	19	15	1010	3	reje_ctions
relegations	12	4	897	3	relegations
remotions	11	4	970	3	r__emotions
repetitions	13	7	802	3	repetitions
resections	12	15	1303	3	rese_ctions
resorptions	13	4	723	3	resorptions
resumption	14	12	473	3	resumption_
retentions	10	16	1111	3	rete_ntions
revelations	14	4	1030	3	revelations
adaptions	12	4	522	4	_ad_aptions
adoptions	12	4	578	4	_ad_options
assumptions	15	6	273	4	assumptions
cremations	14	4	1071	4	_cremations
crenelations	14	4	618	4	crenelations
deaerations	12	3	1167	4	deaerations
deception	14	4	832	4	dece_ption_
decimations	16	4	1016	4	decimations
decryptions	19	4	361	4	decryptions
dedications	15	3	1087	4	dedications
deductions	14	6	713	4	ded_uctions
defamations	17	4	589	4	defamations
defecations	17	7	900	4	defecations
defections	16	15	1020	4	defe_ctions
dejections	20	16	835	4	deje_ctions
delations	10	26	1659	4	__delations
delegations	13	4	803	4	delegations
deletions	10	26	1093	4	__deletions
demetons	11	3	762	4	__demet_ons
demotion	11	6	907	4	__demotion_
denegations	13	4	854	4	denegations
desertions	11	3	988	4	dese_rtions
desorptions	14	4	599	4	desorptions
detections	13	14	1004	4	dete_ctions
detentions	11	14	880	4	dete_ntions
devotions	13	5	659	4	__devotions
edematous	12	4	442	4	_edemat_ous
editions	9	3	1040	4	_ed__itions
educations	13	3	923	4	_educations
eductions	12	6	877	4	_ed_uctions
egestions	10	4	670	4	_ege_stions
ejections	18	24	996	4	_eje_ctions
elections	11	24	1497	4	_ele_ctions
elevations	13	3	863	4	_elevations
emotions	10	6	1028	4	___emotions
emptins	11	7	940	4	___empti_ns
erections	11	25	1521	4	_ere_ctions
eruptions	11	4	676	4	_e_ruptions
evections	14	25	1069	4	_eve_ctions
exceptions	21	4	686	4	_exceptions
excerptions	22	4	498	4	excerptions
executions	19	4	639	4	_executions
exempting	21	4	422	4	_exempti_ng
exertions	16	3	976	4	_exe_rtions
federation	14	4	957	4	federation_
gemmations	15	4	500	4	ge_mmations
generations	12	3	1142	4	generations
gumptions	14	4	377	4	__gumptions
hebetations	16	5	646	4	hebetations
ideations	10	3	990	4	_ide_ations
inceptions	14	4	853	4	ince_ptions
indentions	11	4	906	4	inde_ntions
indexations	19	4	602	4	indexations
mediations	13	3	1098	4	med_iations
medications	16	4	993	4	medications
meditations	14	4	933	4	meditations
moderations	14	4	827	4	moderations
perceptions	17	9	819	4	perceptions
permeations	15	4	988	4	permeations
predations	13	8	1215	4	pred__ations
predications	17	4	1118	4	predications
predictions	16	4	965	4	pred_ictions
preempting	17	4	539	4	pre_empti_ng
preemptors	16	4	423	4	pre_empt_ors
prelections	15	12	1047	4	prele_ctions
preoptions	14	4	764	4	_preoptions
presumption	17	15	417	4	presumption_
preventions	16	4	853	4	preve_ntions
radiations	11	3	1192	4	rad_iations
rampions	12	24	802	4	r__amp_ions
reactions	11	7	1171	4	r__eactions
reanimations	14	6	878	4	reanimations
rebellions	12	4	420	4	rebe_llions
recautions	12	4	781	4	re_cautions
receipting	15	4	675	4	receipti_ng
receiptors	14	4	365	4	receipt_ors
recensions	12	4	848	4	rece_nsions
receptionist	16	5	640	4	rece_ptionist
receptors	13	5	692	4	rece_pt_ors
recessions	12	4	893	4	rece_ssions
recitations	13	3	1420	4	recitations
reclamations	16	4	571	4	reclamations
recreations	13	4	1225	4	recreations
redaction	12	5	966	4	red_action_
redecorations	16	4	508	4	redecorations
rededications	17	4	612	4	rededications
redefinitions	17	5	233	4	redefinitions
redeploys	15	5	251	4	rede_p_loys
redescriptions	19	6	278	4	rede~~scr~~iptions
redesigns	11	4	407	4	rede__signs
redigestions	14	8	386	4	redigestions
redirections	15	4	617	4	redirections
redivisions	15	5	380	4	redivisions
reduction	12	5	990	4	red_uction_
reedition	10	4	783	4	re_edition_
reeducations	15	4	547	4	reeducations
reelections	13	16	794	4	reelections
reemissions	13	4	415	4	re_emissions
reemploys	16	5	300	4	re_emp_loys
refection	14	15	1228	4	refe_ction_
reflations	13	3	1123	4	re_flations
reflections	16	17	855	4	reflections
reformations	17	4	760	4	reformations
refractions	16	12	772	4	refractions
refutations	14	4	867	4	refutations
regulations	12	3	1071	4	regulations
reignitions	12	4	455	4	reignitions
reiterations	12	4	1087	4	reiterations
rejection	18	17	1025	4	reje_ction_
relations	9	24	1833	4	r__elations
relaxations	18	4	564	4	relaxations
relegation	11	6	1002	4	relegation_
relictions	12	3	1002	4	re_lictions
relocations	13	3	1114	4	relocations
remediations	15	4	827	4	remediations
remotion	10	4	1023	4	r__emotion_
renditions	11	4	918	4	re_nditions
renovations	14	4	842	4	renovations
reoperations	14	4	1006	4	reoperations
reparations	13	6	1166	4	reparations
repetition	12	7	823	4	repetition_
repetitious	13	8	370	4	repetitious
repletions	12	4	747	4	re_pletions
repositions	13	11	1016	4	repositions
reputations	13	4	1073	4	reputations
resection	11	16	1327	4	rese_ction_
reservations	15	8	858	4	reservations
resolutions	11	11	779	4	resolutions
resorption	12	4	725	4	resorption_
restations	10	3	1584	4	re_stations
retention	9	16	1148	4	rete_ntion_
retortions	10	4	914	4	re_tortions
retractions	13	9	1035	4	retractions
revelation	13	4	1092	4	revelation_
reversions	13	4	757	4	reve_rsions
revocations	16	4	1031	4	revocations
revolutions	14	9	763	4	revolutions
sedations	10	3	1125	4	sed__ations
seditions	10	3	901	4	sed__itions
seductions	13	6	687	4	sed_uctions
selections	12	3	1087	4	sele_ctions
vegetations	15	4	732	4	vegetations
venerations	14	4	1131	4	venerations

Search took 10 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	148819	0.423	422437.4
2	DLD Change Limit	148819	175	8.500	17508.1
3	Display Results	175	175	0.093	1881.7
	(SQL Overall)	178691	175	9.016	19819.3