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

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

60 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
photosphere	21	5	592	(None)
photospheres	22	5	580	1	photospheres
photophore	20	5	863	2	photo_phore
photospheric	24	5	513	2	photospheric
chromosphere	24	6	320	3	chromosphere
ionosphere	15	5	397	3	_ionosphere
noosphere	14	4	477	3	_no_osphere
oosphere	13	5	599	3	__o_osphere
ozonosphere	25	6	215	3	ozonosphere
phosphene	19	9	624	3	ph__osphene
phosphore	19	6	789	3	ph__osphore
photophase	20	5	743	3	photo_phase
photophores	21	5	911	3	photo_phores
rhizosphere	28	6	243	3	rhizosphere
troposphere	18	5	359	3	troposphere
atmosphere	17	5	289	4	_atmosphere
biosphere	16	6	478	4	__biosphere
chromospheres	25	6	293	4	chromospheres
ecosphere	16	10	480	4	__ecosphere
exosphere	21	9	416	4	__exosphere
heliosphere	19	5	293	4	heliosphere
hemisphere	20	5	352	4	_hemisphere
hydrosphere	23	5	340	4	hydrosphere
ionospheres	16	5	402	4	_ionospheres
lithosphere	19	5	317	4	lithosphere
mesosphere	17	5	382	4	_mesosphere
microsphere	20	5	510	4	microsphere
noospheres	15	4	514	4	_no_ospheres
oospheres	14	5	663	4	__o_ospheres
ozonospheres	26	6	227	4	ozonospheres
philosopher	21	15	359	4	philosopher_
philosophers	22	14	330	4	philosophers
phosphate	19	7	727	4	ph__osphate
phosphenes	20	7	655	4	ph__osphenes
phosphide	20	6	525	4	ph__osphide
phosphine	19	10	650	4	ph__osphine
phosphite	19	9	712	4	ph__osphite
phosphor	18	6	510	4	ph__osphor_
phosphores	20	7	842	4	ph__osphores
phosphori	19	6	629	4	ph__osphori
phosphors	19	7	654	4	ph__osphors
photocopier	20	6	649	4	photocopier_
photocopiers	21	5	496	4	photocopiers
photogene	15	4	778	4	photo__gene
photographer	23	4	969	4	photographer_
photographers	24	5	717	4	photographers
photometer	17	4	922	4	photometer_
photometers	18	4	844	4	photometers
photophases	21	5	794	4	photo_phases
photoset	13	4	1428	4	photos__e_t
photosets	14	4	784	4	photos__ets
photosetter	16	7	472	4	photosetter_
photosetters	17	7	393	4	photosetters
planisphere	18	5	224	4	planisphere
potsherd	14	3	481	4	p_ot_s_herd
protostele	12	4	507	4	protos_tele
rhizospheres	29	6	241	4	rhizospheres
stratosphere	17	6	240	4	stratosphere
thermosphere	22	6	353	4	thermosphere
tropospheres	19	5	345	4	tropospheres

Search took 10 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	60	9.080	16389.8
3	Display Results	60	60	0.030	2000.0
	(SQL Overall)	178691	60	9.546	18718.9