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

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

82 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
mystical	15	4	693	(None)
gestical	11	3	898	2	gestical
metical	11	3	1536	2	m_etical
musical	11	3	955	2	mus_ical
mystic	13	27	1164	2	mystic__
mystically	20	4	812	2	mystically
mysticly	18	4	332	2	mysticly
mystics	14	27	910	2	mystic_s
mythical	18	4	503	2	mythical
rustical	10	4	839	2	rustical
aestival	11	4	548	3	aestival
bestial	9	3	1164	3	besti_al
biotical	12	4	886	3	biotical
cortical	12	4	1221	3	cortical
cosmical	14	4	801	3	cosmical
critical	12	3	1026	3	critical
cryptical	18	4	469	3	cryptical
cyclical	14	4	565	3	cyclical
cynical	14	3	787	3	cy_nical
cystic	13	27	1065	3	cystic__
deistical	12	4	667	3	deistical
distichal	15	4	483	3	distichal
ekistical	15	4	480	3	ekistical
eristical	11	4	843	3	eristical
erotical	10	19	1198	3	erotical
estival	10	3	632	3	_estival
festival	14	4	471	3	festival
gnostical	12	4	620	3	gnostical
haptical	15	4	734	3	haptical
hectical	15	4	793	3	hectical
hysterical	18	5	444	3	hysterical
lyrical	12	3	649	3	ly_rical
magical	12	3	978	3	m_agical
martial	9	24	1541	3	marti_al
mastic	10	31	1917	3	mastic__
masticate	13	4	1128	3	masticate
mastiche	15	4	717	3	mastiche
mastics	11	26	1478	3	mastic_s
matinal	9	3	1260	3	m_atinal
medical	12	3	1251	3	m_edical
mescal	10	41	1348	3	mes__cal
mesial	8	48	1808	3	mes_i_al
mestiza	18	3	538	3	mestiza_
mestizas	19	4	470	3	mestizas
meticals	12	3	1076	3	m_eticals
metrical	12	3	1159	3	metrical
mimical	13	3	923	3	m_imical
misdial	10	3	964	3	misdi_al
mistral	9	10	1364	3	mist_ral
mistrial	10	3	1138	3	mistrial
multicar	12	4	752	3	multicar
musicale	12	4	734	3	mus_icale
musicals	12	4	709	3	mus_icals
myotic	13	31	1231	3	myotic__
myotics	14	25	760	3	myotic_s
myrica	13	3	683	3	my_rica_
myricas	14	3	675	3	my_ricas
mysticete	16	5	356	3	mysticete
mysticism	18	4	538	3	mysticism
mystify	18	4	356	3	mysti_fy
mystique	22	4	239	3	mystique
nautical	10	5	770	3	nautical
nonmystical	18	5	434	3	~~non~~mystical
optical	11	4	986	3	_optical
physical	18	4	570	3	phys_ical
poetical	12	3	1153	3	poetical
pyritical	16	4	698	3	pyritical
rusticals	11	4	535	3	rusticals
septical	12	5	936	3	septical
statical	10	3	942	3	statical
stoical	9	3	1028	3	__stoical
styptical	16	4	396	3	styptical
syndical	14	4	537	3	syndical
tactical	12	4	884	3	tactical
thetical	13	4	912	3	thetical
tical	7	60	2149	3	___tical
typical	14	3	634	3	ty_pical
vatical	12	3	998	3	_vatical
vertical	13	4	1043	3	vertical
vesical	12	15	981	3	ves_ical
viatical	13	4	706	3	viatical
vortical	13	4	886	3	vortical

Search took 10 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.330	541487.9
2	DLD Change Limit	146162	82	8.733	16736.7
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	9.096	19645.0