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

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

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.

67 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
crenellations	15	5	357	(None)
crenelations	14	4	618	1	crene_lations
crenellation	14	5	391	1	crenellation_
crenelation	13	4	685	2	crene_lation_
crenulations	14	4	649	2	cren_ulations
cancellations	17	5	439	3	cancellations
compellations	19	5	479	3	compellations
crenations	12	5	1168	3	cren___ations
crenelating	14	4	551	3	crene_lati_ng
crenulation	13	4	757	3	cren_ulation_
cupellations	16	4	380	3	c_upellations
revelations	14	4	1030	3	_reve_lations
appellations	16	4	353	4	_appellations
cancelations	16	5	708	4	c_ancelations
cancellation	16	5	501	4	cancellation_
cantillations	15	4	573	4	cantillations
celebrations	16	4	573	4	c_elebrations
cementations	16	5	901	4	c_ementations
cerebrations	16	4	693	4	c_erebrations
chelations	15	3	907	4	c__he_lations
cogenerations	16	5	589	4	cogene_rations
collations	12	3	1284	4	c___ollations
compellation	18	5	510	4	compellation_
conflations	16	4	1113	4	c_on_flations
congelations	15	4	972	4	c_ongelations
consolations	14	4	972	4	c_onsolations
constellations	16	5	440	4	constellations
correlations	14	4	783	4	corre_lations
creations	11	26	1453	4	cr__e__ations
cremations	14	4	1070	4	cr__e_mations
crenation	11	4	1292	4	cren___ation_
crenelates	12	6	618	4	crene_lat__es
crenellated	14	5	252	4	crenellat__ed
crenelling	13	4	568	4	crenell__i_ng
creolizations	24	5	788	4	creolizations
crepitations	16	4	747	4	cre_pitations
cupellation	15	4	414	4	c_upellation_
decollations	15	4	735	4	_decollations
denegations	13	4	854	4	_dene_gations
denervations	16	5	709	4	_denervations
enervations	14	7	857	4	__enervations
fellations	13	3	806	4	___fellations
flagellations	17	5	223	4	flagellations
generations	12	3	1140	4	_gene_rations
granulations	13	4	578	4	gran_ulations
penetrations	14	4	884	4	_penetrations
preselections	17	14	443	4	preselections
presentations	15	4	813	4	presentations
preservations	18	9	554	4	preservations
rebellions	12	4	420	4	_rebell__ions
reelections	13	16	794	4	_re_elections
reflations	13	3	1123	4	_r__eflations
regulations	12	3	1071	4	_re_gulations
reinflations	15	4	664	4	_reinflations
relations	9	24	1833	4	_r__e_lations
relegations	12	4	897	4	_rele_gations
remediations	15	4	827	4	_remediations
renovations	14	4	841	4	_ren_ovations
reregulations	14	5	570	4	_reregulations
reservations	15	8	858	4	_reservations
retaliations	12	5	1140	4	_retaliations
revaluations	15	5	763	4	_revaluations
revelation	13	4	1092	4	_reve_lation_
tessellations	13	5	261	4	tessellations
translations	12	5	835	4	tran_slations
venerations	14	4	1128	4	_vene_rations
ventilations	15	4	740	4	_ventilations

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	95024	0.123	1452772.4
2	DLD Change Limit	95024	67	5.906	16089.4
3	Display Results	67	67	0.033	2030.3
	(SQL Overall)	178691	67	6.062	29477.2