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

Here are the results of your fuzzy-string dictionary search for “agrestic” 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
agrestic	11	4	792	(None)
acrostic	12	3	994	2	acrostic
agnostic	11	4	671	2	agnostic
agrestal	9	4	565	2	agrestal
amnestic	12	4	705	2	amnestic
aoristic	10	3	1116	2	aoristic
argentic	11	4	902	2	argentic
asbestic	12	4	538	2	asbestic
atresic	9	3	1000	2	atres_ic
atretic	9	3	1392	2	atre_tic
gestic	9	3	1277	2	_g_estic
acetic	10	3	1450	3	a_ce_tic
acoustic	12	4	644	3	acoustic
acrostics	13	4	698	3	acrostics
acrotic	11	25	1554	3	acr_otic
agenetic	11	3	820	3	agenetic
agnatic	10	3	1097	3	ag_natic
agnostics	12	4	446	3	agnostics
agonistic	12	4	668	3	agonistic
agraphic	16	4	618	3	agraphic
agravic	13	4	589	3	agr_avic
airest	6	38	2526	3	airest__
aloetic	9	3	1318	3	aloe_tic
amnesic	11	3	718	3	amnes_ic
amoristic	13	4	799	3	amoristic
anapestic	13	4	631	3	anapestic
andesitic	12	4	524	3	andesitic
anorectic	13	4	698	3	anorectic
anoretic	10	3	1293	3	anore_tic
anuretic	10	4	856	3	anure_tic
aortic	8	3	1661	3	aor__tic
aphetic	14	29	1285	3	aphe_tic
aplastic	12	4	924	3	aplastic
apractic	14	4	830	3	apractic
aprotic	11	27	1524	3	apr_otic
apyretic	15	4	684	3	apyre_tic
arctic	10	3	1351	3	a_r_ctic
areic	7	32	1939	3	a_re__ic
argotic	10	3	1028	3	a_rgotic
arrest	6	37	2263	3	arrest__
arrested	9	3	915	3	arrested
arrestee	8	4	944	3	arrestee
arrester	8	3	925	3	arrester
arresting	10	3	863	3	arresting
arrestive	12	4	675	3	arrestive
arrestor	8	4	765	3	arrestor
arrests	7	33	1268	3	arrest_s
arsenic	9	3	932	3	a_rsenic
artistic	10	3	1089	3	artistic
ascetic	11	3	1006	3	asce_tic
aseptic	11	3	737	3	a_septic
atheistic	14	4	735	3	atheistic
atresia	7	3	1022	3	atres_ia
autistic	10	3	1010	3	autistic
auxetic	16	3	714	3	auxe_tic
cretic	10	28	1628	3	_cre_tic
domestic	13	4	781	3	domestic
drastic	10	3	1088	3	_drastic
egoistic	11	4	710	3	egoistic
ergastic	11	10	662	3	ergastic
eristic	9	8	1409	3	_eristic
gametic	12	3	1000	3	game_tic
gnostic	10	3	843	3	_gnostic
heretic	12	3	1483	3	here_tic
juristic	17	4	613	3	juristic
karstic	13	5	798	3	kar_stic
magnesic	13	4	575	3	magnes_ic
magnetic	13	4	923	3	magne_tic
majestic	19	4	491	3	majestic
meristic	12	3	1125	3	meristic
orectic	11	3	882	3	_orectic
orgastic	11	11	621	3	orgastic
paretic	11	30	1667	3	pare_tic
patristic	13	8	928	3	patristic
phreatic	15	4	834	3	phreatic
puristic	12	3	938	3	puristic
pyretic	14	32	1078	3	pyre_tic
rustic	8	7	1267	3	__rustic
telestic	10	11	895	3	telestic
toreutic	10	4	519	3	toreutic
uretic	8	29	1435	3	_ure_tic
veristic	13	3	988	3	veristic

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	146162	0.436	409841.7
2	DLD Change Limit	146162	82	6.656	21959.4
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	7.125	25079.4