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

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

69 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
gemmations	15	4	500	(None)
gemmation	14	4	596	1	gemmation_
gelations	10	25	1309	2	ge_lations
geminations	14	13	925	2	geminations
gemmating	15	7	644	2	gemmati_ng
gestations	11	3	977	2	gestations
summations	14	5	678	2	summations
aerations	9	3	1790	3	ae_rations
animations	12	3	1219	3	animations
cessations	12	5	647	3	cessations
commotions	16	8	684	3	commotions
cremations	14	4	1071	3	cremations
damnations	13	3	708	3	damnations
dealations	11	3	1137	3	dealations
decimations	16	4	1016	3	decimations
defamations	17	4	589	3	defamations
deflations	14	3	971	3	deflations
delations	10	26	1659	3	de_lations
demotions	12	5	844	3	de_motions
dentations	11	4	1363	3	dentations
deviations	14	3	1116	3	deviations
elations	8	37	1912	3	_e_lations
emanations	12	8	959	3	_emanations
emotions	10	6	1028	3	_e_motions
emulations	12	3	1094	3	_emulations
enations	8	33	1690	3	_e_nations
equations	18	3	949	3	_equations
fellations	13	3	806	3	fellations
fetations	12	5	1138	3	fe_tations
formations	15	3	820	3	formations
gammadion	15	4	218	3	gammadion_
gelatins	9	34	1409	3	ge_lati_ns
gelation	9	30	1443	3	ge_lation_
gemination	13	14	1065	3	gemination_
gemmates	13	30	767	3	gemmat__es
generations	12	3	1142	3	generations
germinations	15	13	794	3	germinations
gestation	10	3	1066	3	gestation_
gleizations	21	13	528	3	gleizations
gradations	12	8	686	3	gradations
gummatous	14	4	273	3	gummat_ous
gumptions	14	4	377	3	g_umptions
gustations	11	4	723	3	gustations
guttations	11	4	559	3	guttations
gyrations	13	3	692	3	g_yrations
hematins	13	17	1468	3	he_mati_ns
himations	14	3	880	3	_himations
legations	10	27	1192	3	le_gations
lemmatizes	23	4	501	3	lemmatizes
mediations	13	3	1098	3	mediations
mentations	12	3	1258	3	mentations
negations	10	28	1196	3	ne_gations
nervations	13	5	948	3	nervations
palmations	14	3	873	3	palmations
peltations	12	3	1155	3	peltations
permeations	15	4	988	3	permeations
reflations	13	3	1123	3	reflations
relations	9	24	1833	3	re_lations
remotions	11	4	970	3	re_motions
restations	10	3	1584	3	restations
sedations	10	3	1125	3	se_dations
sensations	10	5	985	3	sensations
seriations	10	3	1668	3	seriations
serrations	10	3	1309	3	serrations
summation	13	4	780	3	summation_
temptations	15	4	541	3	temptations
venations	12	3	1172	3	ve_nations
vernations	13	3	1033	3	vernations
vexations	19	3	775	3	ve_xations

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	69	6.050	23240.2
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	6.500	27490.9