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

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

69 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
egoistic	11	4	710	(None)
egotistic	12	4	613	1	egotistic
agonistic	12	4	668	2	agonistic
egoist	7	6	1228	2	egoist__
egoistical	13	5	433	2	egoistical
egoists	8	8	707	2	egoist_s
ekistic	13	7	784	2	e_kistic
eristic	9	8	1409	2	e_ristic
logistic	11	4	782	2	logistic
acoustic	12	4	644	3	acoustic
agnostic	11	4	671	3	agnostic
agrestic	11	4	792	3	agrestic
amoristic	13	4	799	3	amoristic
aoristic	10	3	1116	3	aoristic
artistic	10	3	1089	3	artistic
atomistic	13	4	777	3	atomistic
autistic	10	3	1010	3	autistic
cubistic	14	4	570	3	cubistic
deistic	10	3	1117	3	_deistic
ecliptic	14	5	533	3	ecliptic
egoism	9	7	747	3	egois__m
egoisms	10	6	595	3	egois_ms
egotist	8	4	1127	3	egotist__
egotistical	14	5	316	3	egotistical
egotists	9	3	706	3	egotist_s
ekistics	14	8	570	3	e_kistics
elastic	9	30	1339	3	e_lastic
elliptic	12	5	475	3	elliptic
entastic	10	4	855	3	entastic
eosinic	9	4	771	3	e_osinic
equisetic	20	4	277	3	equisetic
ergastic	11	10	662	3	ergastic
ergotic	10	4	972	3	ergo__tic
eristics	10	6	1019	3	e_ristics
erotic	8	26	2027	3	ero__tic
eulogistic	13	4	456	3	eulogistic
exocytic	22	4	487	3	exocytic
exorcistic	21	5	379	3	exorcistic
exosmic	18	4	437	3	exo_smic
exotic	15	31	1265	3	exo__tic
fistic	11	8	1257	3	__fistic
floristic	14	4	716	3	floristic
geodetic	12	4	632	3	geodetic
gestic	9	3	1277	3	_g_estic
gnostic	10	3	843	3	_gnostic
hedonistic	16	4	454	3	hedonistic
heuristic	14	4	598	3	heuristic
holistic	13	3	1126	3	holistic
jingoistic	20	5	344	3	jingoistic
juristic	17	4	613	3	juristic
legalistic	13	4	527	3	legalistic
logistics	12	4	506	3	logistics
meristic	12	3	1125	3	meristic
monistic	12	3	1130	3	monistic
nepotistic	14	4	488	3	nepotistic
nomistic	12	7	959	3	nomistic
papistic	14	4	873	3	papistic
protistic	13	4	1098	3	protistic
puristic	12	3	938	3	puristic
realistic	11	4	855	3	realistic
rigoristic	13	5	423	3	rigoristic
sadistic	11	4	837	3	sadistic
soloistic	11	4	733	3	soloistic
theistic	13	4	815	3	theistic
tropistic	13	4	722	3	tropistic
truistic	10	4	690	3	truistic
utopistic	13	4	538	3	utopistic
veristic	13	3	988	3	veristic
wholistic	17	4	594	3	wholistic

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.420	425454.8
2	DLD Change Limit	146162	69	7.190	20328.5
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	7.640	23388.9