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

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

80 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
summation	13	4	780	(None)
summations	14	5	678	1	summations
gemmation	14	4	596	2	gemmation
squamation	21	5	353	2	squamation
sublation	11	3	1101	2	sublation
sudation	9	3	1080	2	su_dation
sulcation	11	7	1073	2	sulcation
sulfation	12	8	878	2	sulfation
summating	14	3	794	2	summating
summational	15	5	368	2	summational
summative	16	4	620	2	summative
animation	11	3	1368	3	animation
automation	12	4	914	3	automation
commotion	15	7	698	3	commotion
consummation	18	5	529	3	~~con~~summation
cremation	13	5	1164	3	cremation
cumulation	14	4	817	3	cumulation
damnation	12	3	840	3	damnation
duration	9	3	1269	3	du_ration
emulation	11	3	1239	3	emulation
estimation	12	4	1084	3	estimation
formation	14	3	942	3	formation
fumigation	16	4	562	3	fumigation
furcation	14	4	835	3	furcation
gammadion	15	4	218	3	gammadion
gemmations	15	4	500	3	gemmations
gumption	13	4	398	3	gu_mption
gustation	10	4	796	3	gustation
guttation	10	4	617	3	guttation
himation	13	3	975	3	_himation
lunation	8	3	1192	3	lu_nation
luxation	15	3	823	3	lu_xation
mutation	10	14	1288	3	mu_tation
numeration	12	13	796	3	numeration
nunnation	9	12	656	3	nunnation
nutation	8	15	1310	3	nu_tation
palmation	13	3	1022	3	palmation
pulsation	11	3	714	3	pulsation
pupation	12	6	950	3	pu_pation
purgation	12	4	739	3	purgation
quotation	18	14	697	3	quotation
ruination	9	3	1127	3	ruination
rumination	12	4	1083	3	rumination
saltation	9	3	1200	3	saltation
salvation	12	3	929	3	salvation
satiation	9	3	1343	3	satiation
scalation	11	3	1107	3	scalation
sedation	9	3	1245	3	s_edation
sensation	9	5	1058	3	sensation
seriation	9	3	1806	3	seriation
serration	9	4	1406	3	serration
siltation	9	3	921	3	siltation
simulation	12	6	958	3	simulation
sinuation	9	3	1041	3	sinuation
situation	9	4	942	3	situation
solation	8	9	1615	3	s_olation
solvation	12	3	777	3	solvation
squamations	22	7	274	3	squamations
station	7	27	1724	3	s__tation
striation	9	3	1348	3	striation
suasion	7	3	936	3	su__asion
sublations	12	4	1011	3	sublations
sublimation	15	5	718	3	sublimation
substation	12	4	899	3	substation
suction	9	37	1304	3	su__ction
sudations	10	3	990	3	su_dations
sulcations	12	8	958	3	sulcations
sulfations	13	10	781	3	sulfations
summaries	13	11	818	3	summaries
summarily	16	4	383	3	summarily
summarise	13	11	573	3	summarise
summarist	13	11	676	3	summarist
summarize	22	10	565	3	summarize
summate	11	36	1166	3	summat__e
summated	13	29	883	3	summat_ed
summates	12	26	1049	3	summat_es
summiting	14	4	579	3	summiting
summon	10	3	762	3	summ___on
supination	12	4	988	3	supination
usurpation	12	4	381	3	usurpation

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	80	6.140	24208.6
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	6.610	27033.4