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

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

70 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
gemmation	14	4	596	(None)
gemmations	15	4	500	1	gemmations
gammadion	15	4	218	2	gammadion
gelation	9	30	1443	2	ge_lation
gemination	13	14	1066	2	gemination
gemmating	15	7	644	2	gemmating
gestation	10	3	1066	2	gestation
summation	13	4	780	2	summation
aeration	8	3	1993	3	ae_ration
animation	11	3	1368	3	animation
cessation	11	7	685	3	cessation
commotion	15	7	698	3	commotion
cremation	13	5	1164	3	cremation
damnation	12	3	840	3	damnation
dealation	10	3	1300	3	dealation
decimation	15	4	1162	3	decimation
defamation	16	4	684	3	defamation
deflation	13	3	1065	3	deflation
delation	9	23	1808	3	de_lation
demotion	11	6	907	3	de_motion
dentation	10	3	1524	3	dentation
deviation	13	3	1239	3	deviation
elation	7	36	2045	3	_e_lation
emanation	11	9	1078	3	_emanation
emotion	9	7	1130	3	_e_motion
emulation	11	3	1239	3	_emulation
enation	7	34	1923	3	_e_nation
equation	17	3	1048	3	_equation
fellation	12	3	884	3	fellation
fetation	11	6	1314	3	fe_tation
formation	14	3	942	3	formation
gelatin	8	35	1473	3	ge_lati_n
gelations	10	25	1309	3	ge_lations
geminations	14	13	926	3	geminations
gemmate	12	41	838	3	gemmat__e
gemmated	14	33	629	3	gemmat_ed
gemmates	13	30	767	3	gemmat_es
generation	11	3	1242	3	generation
germination	14	14	897	3	germination
gestations	11	3	977	3	gestations
gleization	20	11	578	3	gleization
gradation	11	10	771	3	gradation
gumption	13	4	398	3	g_umption
gustation	10	4	796	3	gustation
guttation	10	4	617	3	guttation
gyration	12	3	776	3	g_yration
hematin	12	15	1602	3	he_mati_n
himation	13	3	975	3	_himation
legation	9	24	1293	3	le_gation
lemmatize	22	4	556	3	lemmatize
mediation	12	3	1229	3	mediation
mentation	11	3	1398	3	mentation
negation	9	29	1302	3	ne_gation
nervation	12	6	1024	3	nervation
palmation	13	3	1022	3	palmation
peltation	11	3	1296	3	peltation
permeation	14	4	1056	3	permeation
reflation	12	4	1233	3	reflation
relation	8	26	1977	3	re_lation
remotion	10	4	1023	3	re_motion
restation	9	3	1691	3	restation
sedation	9	3	1245	3	se_dation
sensation	9	5	1058	3	sensation
seriation	9	3	1806	3	seriation
serration	9	4	1406	3	serration
summations	14	5	678	3	summations
temptation	14	4	638	3	temptation
venation	11	5	1350	3	ve_nation
vernation	12	3	1108	3	vernation
vexation	18	3	878	3	ve_xation

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	148641	0.440	406115.9
2	DLD Change Limit	148641	70	6.076	24463.6
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	6.549	27285.2