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

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

79 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
stagflations	16	5	286	(None)
stagflation	15	5	314	1	stagflation_
stagnations	12	4	490	2	stag_nations
coagulations	15	4	651	3	coagulations
scalations	12	3	978	3	sca__lations
spallations	13	5	610	3	spa_llations
stagflationary	21	7	76	3	stagflationary
stagnation	11	4	554	3	stag_nation_
starvations	14	4	505	3	sta_rvations
stimulations	14	5	620	3	stimulations
stipulations	14	5	544	3	stipulations
strangulations	15	6	365	3	strangulations
tabulations	13	4	685	3	_tabulations
ablations	11	3	1151	4	__a_blations
acylations	15	4	760	4	__acylations
adulations	11	3	1012	4	__adulations
agitations	11	3	1006	4	__agitations
agnations	10	3	1003	4	__ag_nations
alations	8	25	1889	4	__a__lations
angulations	12	6	805	4	_angulations
coagulation	14	4	727	4	coagulation_
conflations	16	4	1114	4	_conflations
congelations	15	4	973	4	congelations
dealations	11	3	1137	4	dea__lations
deflations	14	3	971	4	__deflations
ejaculations	21	9	521	4	ejaculations
escalations	13	4	766	4	esca__lations
etiolations	11	4	739	4	et_iolations
evaginations	16	4	582	4	evaginations
flagellations	17	5	223	4	flagellations
gelations	10	25	1309	4	___gelations
granulations	13	4	578	4	granulations
gratulations	13	4	517	4	gratulations
halations	12	3	1239	4	_ha__lations
imaginations	15	4	634	4	imaginations
inflations	13	3	1032	4	__inflations
installations	13	5	422	4	insta_llations
lallations	10	3	874	4	_la_llations
maculations	15	6	962	4	_maculations
paginations	14	4	775	4	_paginations
reflations	13	3	1123	4	__reflations
regulations	12	3	1071	4	_regulations
reinflations	15	4	664	4	reinflations
sacculations	16	4	666	4	sacculations
salivations	14	4	873	4	s_alivations
saltations	10	3	1062	4	s_a_ltations
salutations	11	4	764	4	s_alutations
salvations	13	3	813	4	s_a_lvations
sanitations	11	4	1084	4	s_anitations
satiations	10	3	1211	4	s_a_tiations
saturations	11	4	857	4	s_aturations
scalation	11	3	1107	4	sca__lation_
sibilations	13	12	793	4	s_ibilations
simulations	13	6	839	4	s_imulations
slumpflations	20	9	121	4	slumpflations
solations	9	8	1462	4	s___olations
spallation	12	4	702	4	spa_llation_
speculations	16	4	639	4	speculations
spiculations	16	4	617	4	spiculations
sporulations	14	4	568	4	sporulations
stabilizations	25	6	560	4	stabilizations
stagnating	12	5	497	4	stag_nati_ng
stallions	9	4	607	4	sta__l_lions
starvation	13	4	549	4	sta_rvation_
stations	8	24	1522	4	st____ations
stimulation	13	7	722	4	stimulation_
stipulation	13	5	633	4	stipulation_
strangulation	14	6	404	4	strangulation_
striations	10	3	1279	4	st__riations
stridulations	14	5	440	4	stridulations
strobilations	15	5	388	4	strobilations
stylizations	24	4	593	4	stylizations
sublations	12	4	1011	4	s__ublations
sulfations	13	10	781	4	s_ulf_ations
tabulation	12	4	781	4	_tabulation_
tarnations	10	3	890	4	_ta_rnations
taxations	16	3	686	4	_ta__xations
translations	12	5	837	4	translations
vallations	13	3	909	4	_va_llations

Search took 8 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	124790	0.406	440125.6
2	DLD Change Limit	124790	79	6.736	18525.8
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	7.188	24859.6