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

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

51 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
sphericities	19	13	420	(None)
helicities	15	4	985	3	__helicities
puerilities	13	4	753	3	_puerilities
spasticities	16	5	462	3	spasticities
sphericity	20	5	381	3	sphericit__y
spherulites	16	5	250	3	spherulit_es
sterilities	11	12	901	3	s_terilities
supercities	15	4	1156	3	super_cities
asperities	12	4	976	4	asp_er__ities
centricities	16	6	640	4	centricities
endemicities	17	5	402	4	endemicities
epidemicities	20	6	229	4	epidemicities
ethnicities	16	5	544	4	eth_nicities
febricities	18	4	494	4	_febricities
felicities	15	4	974	4	__felicities
feracities	15	4	871	4	__feracities
ferocities	15	4	824	4	__ferocities
heredities	14	4	722	4	__heredities
infelicities	17	5	510	4	infelicities
lubricities	15	4	507	4	_lubricities
peripeties	14	4	839	4	_p_eripeties
phenacites	17	6	540	4	_phenacit_es
precocities	17	4	816	4	_precocities
predacities	16	4	691	4	_predacities
privities	14	3	1204	4	_p__rivities
publicities	17	4	548	4	_publicities
putridities	14	4	491	4	_putridities
scarcities	14	4	640	4	s_car_cities
scurrilities	14	5	271	4	scurrilities
seismicities	16	5	337	4	seismicities
senilities	10	3	1299	4	s__enilities
septicities	15	4	731	4	s_epticities
serenities	10	4	1106	4	s__erenities
serosities	10	4	1082	4	s__erosities
servilities	14	4	705	4	s__ervilities
severities	13	4	851	4	sever__ities
simplicities	18	6	414	4	simplicities
sparsities	12	4	732	4	sp_ar_sities
specialities	16	5	679	4	sp_ecialities
specialties	15	4	466	4	sp_ecialties
specificities	22	6	259	4	specificities
specifies	16	4	757	4	sp_e__cifies
speciosities	16	5	376	4	sp_eciosities
spermicides	18	5	331	4	sp_ermici_des
spherics	15	3	707	4	spheric____s
spherulite	15	5	328	4	spherulit_e_
spherulitic	18	7	154	4	spheruliti_c
spiralities	13	4	801	4	sp_iralities
sporicides	15	4	444	4	sp_orici_des
superiorities	15	5	632	4	superiorities
veracities	15	4	950	4	__veracities

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	124790	0.140	1276364.3
2	DLD Change Limit	124790	51	7.203	17324.7
3	Display Results	51	51	0.033	1545.5
	(SQL Overall)	178691	51	7.376	24226.0