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

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

53 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
heliotropes	16	5	404	(None)
heliotrope	15	5	377	1	heliotrope_
heliotropic	18	5	464	2	heliotropic
heliotropism	19	7	346	2	heliotropism
heliotypes	18	4	357	2	heliot_ypes
hemitropes	17	5	448	2	hemi_tropes
allotropes	12	5	559	3	_allotropes
heliographs	20	4	712	3	heliographs
heliotropisms	20	7	259	3	heliotropisms
heliotype	17	4	359	3	heliot_ype_
heliotyped	19	5	255	3	heliot_yped
heliotypies	19	5	246	3	heliotypies
helistops	14	4	406	3	helist_op_s
helotries	12	6	956	3	hel_otr_ies
hemitrope	16	5	428	3	hemi_trope_
pleiotropies	16	5	372	3	pleiotropies
allotrope	11	5	503	4	_allotrope_
allotropies	13	5	552	4	_allotropies
azeotropes	21	5	376	4	_azeotropes
biotopes	12	4	696	4	__biot_opes
boltropes	13	4	406	4	bol__tropes
electrodes	13	4	725	4	_electrodes
emmetropes	16	5	234	4	_emmetropes
epistrophes	18	8	344	4	_epistrophes
epitopes	12	4	697	4	_epi_t_opes
footropes	14	4	641	4	__footropes
hagioscopes	19	5	389	4	hagioscopes
halitoses	12	4	660	4	hali_t_oses
heatstrokes	18	5	225	4	heatstrokes
helicopts	16	4	380	4	heli__copts
helictites	15	4	465	4	helict_ites
heliograms	16	4	485	4	heliogr_ams
heliograph	19	4	690	4	heliograp_h
heliographed	22	7	551	4	heliographed
heliolatries	15	5	254	4	heliolatr_ies
heliolatrous	15	6	137	4	heliolatro_us
heliotypy	20	5	202	4	heliot_yp_y
heliozoans	22	5	181	4	helio_zoans
helistop	13	4	432	4	helist_op__
helotages	13	4	612	4	hel_ot_ages
heritrices	15	5	530	4	heri_trices
heritrixes	20	4	374	4	heri_trixes
heterotrophs	20	6	399	4	heterotrophs
holotypes	17	4	521	4	hol_ot_ypes
lipotropies	15	5	457	4	__lipotropies
meliorates	12	8	890	4	melio_rates
mellotrons	12	5	356	4	mellotro_ns
pleiotropic	17	7	414	4	pleiotropic
pleiotropy	17	5	248	4	pleiotrop_y
pliotrons	11	4	470	4	_pliotro_ns
sellotapes	12	10	374	4	sellot_apes
teliospores	13	5	287	4	teliospores
velodromes	16	5	234	4	vel_odromes

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.440	406115.9
2	DLD Change Limit	148819	53	8.610	17284.4
3	Display Results	53	53	0.030	1766.7
	(SQL Overall)	178691	53	9.080	19679.6