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

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

58 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
hydrotropic	22	5	528	(None)
hydrotropism	23	10	382	2	hydrotropism
thyrotropic	21	5	455	2	thy_rotropic
heliotropic	18	5	464	3	heliotropic
hydrographic	27	5	636	3	hydrographic
hydrologic	20	4	667	3	hydro_logic
hydromorphic	28	6	407	3	hydromorphic
hydrophobic	27	8	475	3	hydrophobic
hydropic	19	4	727	3	hyd___ropic
hydroponic	21	5	587	3	hydro_ponic
hydrosolic	19	5	461	3	hydro_solic
hydrotropisms	24	10	289	3	hydrotropisms
hygroscopic	24	5	364	3	hygroscopic
neurotropic	15	5	521	3	neurotropic
thyrotrophic	25	7	361	3	thy_rotrophic
thyrotropin	19	6	433	3	thy_rotropin
allotropic	14	5	555	4	_allotropic
anisotropic	15	5	478	4	anisotropic
diatropic	14	4	593	4	__diatropic
endotrophic	19	5	474	4	end_otrophic
esotropic	13	12	679	4	__esotropic
exotropic	20	11	626	4	__exotropic
geotropic	14	6	701	4	__geotropic
gyroscopic	20	5	400	4	gy_roscopic
heterotopic	18	12	530	4	heterot_opic
heterotrophic	23	6	375	4	heterotrophic
hidrotic	14	4	690	4	hidrot___ic
hydrofoil	19	5	378	4	hydro_fo_il
hydrography	27	4	619	4	hydrography
hydrolytic	22	5	620	4	hydro_lytic
hydrometric	22	7	590	4	hydrometric
hydronic	17	4	809	4	hyd___ronic
hydropathic	25	6	495	4	hydropathic
hydrophilic	25	5	519	4	hydrophilic
hydrophobia	25	8	436	4	hydrophobia
hydrophytic	28	5	547	4	hydrophytic
hydroponics	22	5	477	4	hydro_ponics
hydrostatic	20	6	523	4	hydrostatic
hydrothorax	28	6	245	4	hydrothorax
hydroxylic	29	5	422	4	hydro_xylic
hypermetropic	27	6	262	4	hypermetropic
hyperopic	21	4	741	4	hy__peropic
hypertrophic	27	6	368	4	hypertrophic
hypotonic	19	4	819	4	hy_pot_onic
inotropic	13	10	642	4	__inotropic
isotropic	13	9	664	4	__isotropic
lipotropic	16	5	463	4	_lipotropic
luteotropic	15	5	373	4	luteotropic
neotropic	13	6	771	4	__neotropic
nootropic	13	5	627	4	__nootropic
phototropic	20	5	820	4	phototropic
pleiotropic	17	7	414	4	pleiotropic
psychotropic	26	6	448	4	psychotropic
thermotropic	21	5	495	4	thermotropic
thixotropic	25	5	357	4	thixotropic
thyrotrophin	23	6	338	4	thy_rotrophin
thyrotropins	20	6	389	4	thy_rotropins
xenotropic	21	5	478	4	_xenotropic

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.453	394461.4
2	DLD Change Limit	148819	58	9.203	16170.7
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	9.686	18448.4