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

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

47 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
aphelian	13	7	696	(None)
aphelia	12	4	942	1	aphelia_
aphelion	13	7	562	1	aphelion
abelian	9	28	1064	2	a_belian
aphelions	14	7	481	2	aphelions
aphidian	14	4	553	2	aphidian
abelia	8	31	1440	3	a_belia_
abelias	9	32	1356	3	a_belias
achenial	13	4	828	3	achenial
acholia	12	3	997	3	acholia_
acholias	13	4	957	3	acholias
adhesion	12	4	443	3	adhesion
aeolian	7	3	862	3	a_eolian
amphibian	18	5	349	3	amphibian
annelidan	10	5	261	3	annelidan
anthelia	11	4	911	3	anthelia_
anthelion	12	4	638	3	anthelion
apelike	13	3	1053	3	ap_elike
aphagia	13	24	766	3	aphagia_
aphagias	14	23	734	3	aphagias
aphasia	12	25	1087	3	aphasia_
aphasiac	15	28	659	3	aphasiac
aphasias	13	27	1043	3	aphasias
aphesis	12	6	1051	3	aphesi_s
aphetic	14	29	1285	3	apheti_c
aphidians	15	4	405	3	aphidians
aphonia	12	27	1188	3	aphonia_
aphonias	13	26	1114	3	aphonias
apian	7	50	1833	3	ap___ian
apiarian	10	4	832	3	apiarian
appellant	13	4	635	3	appellant
apteria	9	3	1291	3	apteria_
atheling	12	4	920	3	atheling
avellan	10	3	729	3	a_vellan
bohemian	15	4	476	3	bohemian
capelan	11	3	900	3	cap_el_an
capelin	11	5	1097	3	cap_eli_n
carnelian	11	4	574	3	carnelian
heliac	11	10	1089	3	__heliac
mycelian	15	4	319	3	mycelian
ophidian	14	4	436	3	ophidian
paphian	14	3	745	3	paph__ian
parhelia	13	4	671	3	parhelia_
parhelion	14	4	422	3	parhelion
pelican	11	3	943	3	_p_elican
spelean	9	3	712	3	sp_elean
therian	10	3	1129	3	_therian

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	146162	0.420	425454.8
2	DLD Change Limit	146162	47	6.423	22756.0
3	Display Results	47	47	0.016	2937.5
	(SQL Overall)	178691	47	6.859	26052.0