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

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

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.

50 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
heliotropisms	20	7	259	(None)
heliotropism	19	7	346	1	heliotropism_
chemotropisms	24	6	333	3	che_motropisms
geotropisms	16	9	365	3	ge__otropisms
heliotropes	16	5	404	3	heliotrop__es
heliotropic	18	5	464	3	heliotropi__c
hydrotropisms	24	10	289	3	hydrotropisms
thermotropisms	23	14	266	3	thermotropisms
anisotropisms	17	6	299	4	anisotropisms
chemotropism	23	6	407	4	che_motropism_
geotropism	15	7	456	4	ge__otropism_
heliotrope	15	5	377	4	heliotrop___e
heliotypies	19	5	246	4	heliot_ypi_es
helotisms	14	4	683	4	hel_ot___isms
hydrotropism	23	10	382	4	hydrotropism_
meliorisms	14	4	555	4	melio_r__isms
phototropisms	22	6	468	4	phototropisms
pleiotropies	16	5	372	4	pleiotropi_es
thermotropism	22	13	360	4	thermotropism_
thigmotropisms	24	7	160	4	thigmotropisms
allotropies	13	5	552	5	_allotropi_es
anisotropism	16	6	351	5	anisotropism_
atropisms	13	4	711	5	____atropisms
deviationisms	19	5	388	5	deviationisms
elitisms	10	4	819	5	_eli_t___isms
esotropias	12	11	472	5	_e_sotropi_as
exotropias	19	11	455	5	_e_xotropi_as
heliograms	16	4	485	5	heliogr___ams
heliographs	20	4	712	5	heliograp__hs
heliotypes	18	4	357	5	heliot_yp__es
heliotyping	20	5	184	5	heliot_ypi_ng
helistops	14	4	406	5	helist_op___s
helotism	13	4	770	5	hel_ot___ism_
helotries	12	6	956	5	hel_otr__i_es
hemimorphisms	24	6	233	5	hemimorphisms
hemitropes	17	5	448	5	hemi_trop__es
henotheisms	19	5	375	5	he_not_heisms
heroisms	13	3	869	5	he____ro_isms
hylozoisms	27	5	242	5	hyl_o_zo_isms
lipotropies	15	5	457	5	__lipotropi_es
lipotropins	15	6	377	5	__lipotropi_ns
malapropisms	20	6	173	5	mal_apropisms
meliorism	13	4	623	5	melio_r__ism_
meliorists	12	4	598	5	melio_r__ists
neotropics	14	7	517	5	ne__otropi_cs
phototropism	21	5	632	5	phototropism_
pleiotropic	17	7	414	5	pleiotropi__c
semitropics	17	5	305	5	semi_tropi_cs
thigmotropism	23	7	208	5	thigmotropism_
tropisms	12	4	772	5	_____tropisms

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	124790	0.393	454684.5
2	DLD Change Limit	124790	50	8.420	14820.7
3	Display Results	50	50	0.033	1515.2
	(SQL Overall)	178691	50	8.846	20200.2