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

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

55 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
microspheres	21	5	492	(None)
microsphere	20	5	510	1	microsphere_
microspores	17	4	741	2	microsp_ores
biospheres	17	6	514	3	bi__ospheres
ecospheres	17	9	513	3	_ec_ospheres
hydrospheres	24	5	339	3	hydrospheres
ionospheres	16	5	402	3	_ionospheres
lithospheres	20	7	284	3	lithospheres
mesospheres	18	5	369	3	m_esospheres
microamperes	20	5	320	3	microamperes
micromeres	16	4	848	3	micro__meres
microphages	21	5	691	3	micro_phages
microphones	20	4	875	3	micro_phones
micropores	16	6	1017	3	micro_p_ores
microspore	16	4	686	3	microsp_ore_
acrospires	14	4	407	4	_acrosp_ires
atmospheres	18	5	309	4	_atmospheres
biosphere	16	6	478	4	bi__osphere_
ecosphere	16	10	480	4	_ec_osphere_
exospheres	22	9	442	4	__exospheres
heliospheres	20	5	279	4	heliospheres
hydrosphere	23	5	340	4	hydrosphere_
inspheres	14	5	540	4	_i__nspheres
ionosphere	15	5	397	4	_ionosphere_
lithosphere	19	5	317	4	lithosphere_
macromeres	16	4	575	4	macro__meres
macrophages	21	5	495	4	macro_phages
macrophytes	23	5	571	4	macro_phytes
mesosphere	17	5	382	4	m_esosphere_
microampere	19	5	348	4	microampere_
microgametes	19	6	479	4	microgametes
microliters	15	4	580	4	microliter_s
micromere	15	4	787	4	micro__mere_
micrometers	17	4	907	4	micrometer_s
microphage	20	5	646	4	micro_phage_
microphone	19	4	833	4	micro_phone_
microphylls	23	5	472	4	micro_phylls
micropore	15	7	930	4	micro_p_ore_
microprobes	19	5	651	4	micro_probes
micropyles	19	4	696	4	micro_p_yles
microscales	17	5	637	4	micros_cales
microscopes	19	11	909	4	micros_copes
microscopies	20	16	724	4	microscopies
microsomes	16	4	915	4	micros__omes
microspherical	25	8	244	4	microspherical
microsporous	18	5	361	4	microsporous
microstates	15	4	744	4	micros_tates
microsurgeries	19	6	239	4	microsurgeries
noospheres	15	4	514	4	__noospheres
oospheres	14	5	663	4	___oospheres
ozonospheres	26	6	227	4	ozonospheres
photospheres	22	5	580	4	photospheres
rhizospheres	29	6	241	4	rhizospheres
thermospheres	23	6	335	4	thermospheres
tropospheres	19	5	345	4	tropospheres

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.406	440125.6
2	DLD Change Limit	124790	55	7.156	17438.5
3	Display Results	55	55	0.030	1833.3
	(SQL Overall)	178691	55	7.592	23536.7