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

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

63 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
verticals	14	5	724	(None)
vertical	13	4	1043	1	vertical_
verticils	14	4	618	1	verticils
meticals	12	3	1076	2	me_ticals
tertials	8	5	1007	2	terti_als
vertically	18	4	1092	2	vertically
vertices	13	6	1228	2	vertic_es
verticil	13	6	691	2	verticil_
viaticals	14	4	407	2	viaticals
vortical	13	4	886	2	vortical_
aerials	7	40	1755	3	aer_i_als
berascals	13	4	350	3	berascals
cervical	15	4	685	3	cervical_
clericals	13	4	535	3	cler_icals
cortical	12	4	1221	3	cortical_
ericas	8	3	1546	3	_er_ica_s
erotical	10	19	1198	3	_erotical_
ethicals	13	4	553	3	_ethicals
festivals	15	4	337	3	festivals
fetials	10	37	1174	3	fe_ti_als
gestical	11	3	898	3	gestical_
hectical	15	4	793	3	hectical_
heretical	14	4	863	3	heretical_
heroical	13	4	1001	3	heroical_
jerricans	18	8	375	3	jerricans
lenticels	11	8	449	3	lenticels
medicals	13	4	936	3	me_dicals
meticais	12	4	818	3	me_ticais
metical	11	3	1536	3	me_tical_
metrical	12	3	1159	3	metrical_
partials	10	19	1195	3	parti_als
retinals	8	56	1296	3	re_tinals
retrials	8	5	1082	3	retri_als
rusticals	11	4	535	3	rusticals
septical	12	5	936	3	septical_
serials	7	39	1974	3	ser_i_als
terminals	11	4	745	3	terminals
tertial	7	3	1385	3	terti_al_
tertians	8	3	910	3	terti_ans
ticals	8	32	1471	3	___ticals
vatical	12	3	998	3	v_atical_
venatical	14	4	679	3	venatical_
ventrals	11	29	1000	3	vent_rals
verbals	12	19	1074	3	ver__bals
verdicts	14	4	601	3	verdic_ts
veridical	15	4	598	3	veridical_
veritas	10	30	1275	3	ver_ita_s
vernicle	13	4	643	3	vernic_le
vernicles	14	4	613	3	vernicles
veronicas	14	4	639	3	veronica_s
verrucas	13	4	392	3	verruca_s
versicle	13	6	658	3	versic_le
versicles	14	4	635	3	versicles
verticality	19	5	505	3	verticality
verticalness	17	5	418	3	vertical~~nes~~s
vertigoes	13	5	470	3	vertigoes
vertigos	12	5	497	3	verti_gos
vesical	12	15	981	3	ve_sical_
vestals	10	46	1233	3	vest__als
viatical	13	4	706	3	viatical_
virginals	13	4	320	3	virginals
vortically	18	4	918	3	vortically
vortices	13	6	912	3	vortic_es

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	148641	0.156	1145455.1
2	DLD Change Limit	148641	63	7.716	19264.0
3	Display Results	63	63	0.033	1909.1
	(SQL Overall)	178691	63	7.905	22604.8