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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

105 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
statical	10	3	942	(None)
satanical	11	4	541	2	satanical
septical	12	5	936	2	septical
spatial	9	3	1032	2	spati_al
staminal	10	4	698	2	staminal
statal	6	16	1322	2	stat__al
static	8	31	1868	2	static__
statically	15	4	1157	2	statically
statice	9	26	1403	2	static_e
statices	10	27	1234	2	statices
staticky	17	4	323	2	staticky
statics	9	33	1453	2	static_s
stational	9	4	851	2	stational
sterical	10	3	1125	2	sterical
stoical	9	3	1028	2	st_oical
styptical	16	4	396	2	styptical
tactical	12	4	884	2	_tactical
vatical	12	3	998	2	_vatical
viatical	13	4	706	2	viatical
abapical	14	4	494	3	abapical
agnatical	12	4	616	3	agnatical
apical	10	9	1390	3	__apical
ascetical	13	4	627	3	ascetical
astatic	9	5	1419	3	astatic__
atomical	12	4	890	3	atomical
atypical	15	4	468	3	atypical
biotical	12	4	886	3	biotical
botanical	13	6	607	3	botanical
cortical	12	4	1221	3	cortical
critical	12	3	1026	3	critical
datival	11	3	558	3	_datival
erotical	10	19	1198	3	erotical
erratical	11	4	690	3	erratical
ethical	12	3	844	3	et_hical
ethnical	13	4	636	3	ethnical
fanatical	14	4	648	3	fanatical
gestical	11	3	899	3	gestical
haptical	15	4	734	3	haptical
hectical	15	4	793	3	hectical
iatrical	10	4	927	3	iatrical
laical	8	3	1232	3	_la_ical
magical	12	3	978	3	_magical
matinal	9	3	1260	3	_matinal
metical	11	3	1536	3	_metical
mystical	15	4	693	3	mystical
nautical	10	5	770	3	nautical
optical	11	4	986	3	_optical
piratical	13	4	866	3	piratical
poetical	12	3	1153	3	poetical
practical	15	4	884	3	practical
radical	10	33	1279	3	_radical
rustical	10	4	839	3	rustical
sabbatical	16	5	275	3	sabbatical
sahiwal	13	4	444	3	s_ahiwal
satirical	11	4	687	3	satirical
satyrical	14	4	503	3	satyrical
scenical	12	4	713	3	scenical
sceptical	15	4	534	3	sceptical
sciatica	12	10	611	3	sciatica_
sciaticas	13	10	482	3	sciaticas
semantical	14	4	573	3	semantical
silvical	13	4	522	3	silvical
skeptical	17	4	396	3	skeptical
spacial	11	3	876	3	spaci_al
spathal	12	3	626	3	spat_hal
stadia	7	3	1214	3	stadi_a_
stadias	8	4	1111	3	stadi_as
stamina	9	3	1079	3	stamina_
staminas	10	4	885	3	staminas
stamineal	11	4	310	3	stamineal
stasima	9	5	563	3	stasima_
statin	6	39	2147	3	stati__n
stating	8	37	2516	3	stati_ng
statins	7	37	1977	3	stati_ns
station	7	27	1724	3	stati_on
stations	8	24	1522	3	stations
statism	9	4	1228	3	stati_sm
statisms	10	3	954	3	statisms
statist	7	3	1772	3	stati_st
statistical	13	5	419	3	sta~~tis~~tical
statists	8	3	1016	3	statists
stative	10	26	1293	3	stati_ve
statives	11	27	1079	3	statives
stibial	9	4	658	3	stibi_al
stratal	7	27	1060	3	strat__al
strategical	14	5	313	3	strategical
subapical	15	4	461	3	subapical
surgical	11	4	625	3	surgical
swastica	13	8	415	3	swastica_
swasticas	14	9	380	3	swasticas
syndical	14	4	537	3	syndical
syntactical	18	8	325	3	syntactical
taxicab	18	4	341	3	_taxicab
tetanical	11	4	653	3	tetanical
thetical	13	4	912	3	thetical
tical	7	60	2149	3	___tical
topical	11	3	995	3	_topical
toxical	16	3	764	3	_toxical
tragical	11	4	821	3	tragical
typical	14	3	634	3	_typical
venatical	14	4	679	3	venatical
vertical	13	4	1043	3	vertical
viatica	12	4	586	3	viatica_
viaticals	14	4	407	3	viaticals
vortical	13	4	886	3	vortical

Search took 9 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	146162	0.406	440125.6
2	DLD Change Limit	146162	105	7.890	18525.0
3	Display Results	105	105	0.033	3181.8
	(SQL Overall)	178691	105	8.329	21454.1