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

Here are the results of your fuzzy-string dictionary search for “spherulites” with Change Limit: [1] [2] [3] [4] [5]

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.

72 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
spherulites	16	5	250	(None)
spherulite	15	5	328	1	spherulite_
spherules	14	4	382	2	spherul__es
spherulitic	18	7	154	2	spherulitic
perlites	10	3	1636	3	_p_er_lites
scheelites	15	4	325	3	sche_elites
siderolites	12	5	340	3	siderolites
speculates	14	23	790	3	sp_eculates
sperrylites	16	5	256	3	sperrylites
sphericities	19	13	420	3	sphericities
spherule	13	4	384	3	spherul__e_
sporulates	12	4	648	3	sp_orulates
aerolites	9	3	1258	4	__aerolites
aphrodites	16	4	499	4	aph_rodites
cerusites	11	4	652	4	__cerusites
nephelites	15	4	482	4	nephe__lites
ophiolites	15	4	419	4	oph_iolites
pearlites	11	3	823	4	_p_earlites
peculates	13	21	1254	4	_p_eculates
pelites	9	38	2199	4	_p_e__lites
penlites	10	3	1227	4	_p_e_nlites
perlite	9	3	1732	4	_p_er_lite_
phenacites	17	6	540	4	_phenacites
phenakites	19	6	386	4	_phenakites
phenolates	15	4	702	4	_phenolates
phonolites	15	4	765	4	_phonolites
phyllites	17	4	532	4	_ph_yllites
preunites	11	3	893	4	_pre_unites
puerilities	13	4	753	4	_puerilities
saprolites	12	4	705	4	s_aprolites
satellites	10	4	542	4	sate_llites
schedules	15	6	295	4	schedul__es
scheelite	14	4	420	4	sche_elite_
sclerites	11	3	944	4	scler__ites
sedulities	11	4	754	4	s__edulities
severalties	14	5	366	4	severalties
shelties	11	11	1138	4	s_he__lties
sherries	11	18	1289	4	s_her_ri_es
sherrises	12	15	686	4	s_her_rises
shorelines	13	4	614	4	s_horelines
siderites	10	4	1043	4	sider__ites
siderolite	11	5	391	4	siderolite_
speculate	13	23	919	4	sp_eculate_
speculated	15	18	661	4	sp_eculated
spermines	13	3	1054	4	sp_er_mines
sperrylite	15	5	285	4	sperrylite_
sphalerites	16	5	280	4	sphalerites
spheres	12	31	1435	4	spher____es
sphericity	20	5	381	4	sphericit_y
spherics	15	3	707	4	spher__i_cs
spherier	13	3	778	4	spher__i_er
spheriest	14	3	837	4	spher__i_est
spheroids	15	4	554	4	spher_oi_ds
spherometer	18	5	415	4	spherometer
spherometers	19	5	400	4	spherometers
spherular	14	4	289	4	spherul__ar
spiralities	13	4	801	4	sp_iralities
spirulinas	12	4	205	4	sp_irulinas
sporulate	11	4	695	4	sp_orulate_
sporulated	13	4	526	4	sp_orulated
sporules	10	3	770	4	sp_orul__es
sprites	9	42	2033	4	sp__r__ites
staurolites	11	5	259	4	staurolites
stellites	9	3	812	4	s_te_llites
sterilises	10	4	825	4	s_terilises
sterilities	11	12	901	4	s_terilities
sterilizes	19	4	764	4	s_terilizes
sternites	9	3	1007	4	s_ter_nites
superelite	12	4	908	4	superelite_
superlies	11	3	1455	4	super_li_es
thermites	14	3	804	4	_ther_mites
yperites	13	3	1015	4	yp_er__ites

Search took 9 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	148819	0.436	409841.7
2	DLD Change Limit	148819	72	8.500	17508.1
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	8.966	19929.8