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

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

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.

42 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
gelations	10	25	1309	(None)
delations	10	26	1659	1	delations
elations	8	37	1912	1	_elations
gelatins	9	34	1409	1	gelati_ns
gelation	9	30	1443	1	gelation_
relations	9	24	1833	1	relations
ablations	11	3	1151	2	ablations
aerations	9	3	1790	2	aerations
alations	8	25	1889	2	_alations
chelations	15	3	907	2	chelations
dealations	11	3	1137	2	dealations
deflations	14	3	971	2	deflations
delation	9	23	1808	2	delation_
deletions	10	26	1093	2	deletions
dilations	10	26	1445	2	dilations
elation	7	36	2045	2	_elation_
elutions	8	25	1305	2	_elutions
enations	8	33	1690	2	_enations
fellations	13	3	806	2	fellations
fetations	12	5	1138	2	fetations
gelatin	8	35	1473	2	gelati_n_
gelatine	9	32	1330	2	gelati_ne
gelatines	10	29	1053	2	gelatines
gelating	10	30	1573	2	gelati_ng
gelatinous	11	4	330	2	gelatinous
gelatis	8	33	1351	2	gelati__s
gelatos	8	31	1151	2	gelat_o_s
gemmations	15	4	500	2	gemmations
gestations	11	3	977	2	gestations
gyrations	13	3	692	2	gyrations
halations	12	3	1239	2	halations
illations	9	3	1139	2	illations
legations	10	27	1192	2	legations
negations	10	28	1196	2	negations
oblations	11	3	937	2	oblations
peltations	12	3	1155	2	peltations
reflations	13	3	1123	2	reflations
relation	8	26	1977	2	relation_
sedations	10	3	1125	2	sedations
solations	9	8	1462	2	solations
venations	12	3	1172	2	venations
vexations	19	3	775	2	vexations

Search took 4 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	121436	0.420	425454.8
2	DLD Change Limit	121436	42	3.173	38271.7
3	Display Results	42	42	0.016	2625.0
	(SQL Overall)	178691	42	3.609	49512.6