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

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

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
vitrified	16	4	598	(None)
nitrified	13	4	673	1	nitrified
vitrifies	15	4	722	1	vitrifies
citified	14	3	825	2	cit_ified
devitrified	19	5	271	2	devitrified
lithified	16	4	446	2	lithified
metrified	15	4	786	2	metrified
micrified	17	12	680	2	micrified
nigrified	14	4	533	2	nigrified
nitrifier	12	4	596	2	nitrifier
nitrifies	12	10	792	2	nitrifies
petrified	15	4	834	2	petrified
verified	15	15	1040	2	v_erified
vilified	15	4	724	2	vi_lified
vinified	15	3	754	2	vi_nified
vitrioled	13	4	342	2	vitrioled
vivified	18	4	589	2	vi_vified
aerified	12	13	1014	3	_aerified
certified	15	4	842	3	certified
citifies	13	3	1068	3	cit_ifies
cityfied	17	4	270	3	cit_yfied
clarified	15	4	697	3	clarified
denitrified	16	5	378	3	denitrified
devitrifies	18	5	287	3	devitrifies
dignified	15	4	557	3	dignified
esterified	14	4	540	3	esterified
fortified	16	4	650	3	fortified
gentrified	15	4	568	3	gentrified
glorified	14	4	500	3	glorified
horrified	16	14	506	3	horrified
ignified	13	8	621	3	_ignified
introfied	13	4	561	3	introfied
lignified	14	4	506	3	lignified
liquified	22	4	428	3	liquified
lithifies	15	4	550	3	lithifies
metrifies	14	3	980	3	metrifies
micrifies	16	11	867	3	micrifies
minified	14	3	965	3	mi_nified
mortified	15	4	738	3	mortified
nidified	13	4	676	3	ni_dified
nigrifies	13	4	636	3	nigrifies
nitrided	10	27	675	3	nitri_ded
nitrifiers	13	4	392	3	nitrifiers
notified	12	3	836	3	not_ified
petrifier	14	4	712	3	petrifier
petrifies	14	3	1036	3	petrifies
purified	14	3	874	3	_purified
putrefied	15	4	367	3	putrefied
rarified	12	3	905	3	_rarified
ratified	12	3	1050	3	rat_ified
scarified	15	4	729	3	scarified
scorified	15	4	620	3	scorified
signified	14	4	604	3	signified
sissified	13	4	554	3	sissified
terrified	13	14	758	3	terrified
torrified	13	12	559	3	torrified
trifid	10	3	906	3	__trifi_d
trifled	11	37	1196	3	__trifled
verbified	18	14	602	3	verbified
verifier	14	15	920	3	v_erifier
verifies	14	13	1348	3	v_erifies
versified	16	14	760	3	versified
vibrioid	14	4	441	3	vibrioi_d
vilifier	14	5	669	3	vi_lifier
vilifies	14	3	959	3	vi_lifies
vinifies	14	3	987	3	vi_nifies
viricide	14	4	642	3	vi_ricide
virilized	22	4	623	3	vi_rilized
vitiated	12	28	922	3	vit_iated
vitriform	17	4	333	3	vitriform
vitrify	16	4	500	3	vitrif__y
vitrifying	20	4	417	3	vitrifying
vitrine	10	25	1136	3	vitri_ne_
vitrines	11	26	1091	3	vitri_nes
vitriolled	14	5	166	3	vitriolled
vivifier	17	4	517	3	vi_vifier
vivifies	17	4	702	3	vi_vifies
zincified	24	4	429	3	zincified
zinkified	26	4	316	3	zinkified

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.423	422437.4
2	DLD Change Limit	148641	79	6.093	24395.4
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	6.546	27297.7