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

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

78 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
phototaxies	23	5	622	(None)
phototaxes	22	4	666	1	phototax_es
phototaxis	22	5	650	1	phototaxi_s
homotaxes	21	4	574	3	_homotax_es
homotaxis	21	4	557	3	_homotaxi_s
phonotypies	21	5	446	3	phonotypies
photocopies	20	5	891	3	photocopies
phototaxy	24	5	415	3	phototax__y
phototoxic	24	5	666	3	phototoxi_c
phototubes	17	5	436	3	photot_ubes
phototypes	20	4	651	3	photot_ypes
phyllotaxies	27	6	192	3	phyllotaxies
pleiotaxies	20	5	250	3	pleiotaxies
chemotaxes	24	11	425	4	chemotax_es
chemotaxis	24	12	422	4	chemotaxi_s
chronaxies	22	4	438	4	ch_ronaxies
dhooties	12	3	764	4	dho_ot__ies
geobotanies	14	5	262	4	geobotanies
hologamies	16	4	587	4	_hologamies
homogamies	18	4	596	4	_homogamies
honoraries	13	4	748	4	_honoraries
hotties	10	30	1696	4	_hot_t__ies
hypotaxes	24	4	532	4	_hypotax_es
hypotaxis	24	4	597	4	_hypotaxi_s
patooties	11	4	718	4	patoot__ies
phantasies	15	4	548	4	ph_antasies
phonologies	17	4	1000	4	phonologies
phonotactics	21	6	260	4	phonotactics
phonotypes	20	4	476	4	phonot_ypes
photocopied	21	5	639	4	photocopied
photocopier	20	6	649	4	photocopier
photocopiers	21	5	496	4	photocopiers
photodiodes	18	5	385	4	photodiodes
photoflashes	23	5	306	4	photoflashes
photogenes	16	4	888	4	photo_genes
photographies	24	5	941	4	photographies
photoionizes	26	5	530	4	photoionizes
photolyses	18	4	665	4	photo_lyses
photolysis	18	4	669	4	photolysi_s
photolyzes	27	4	548	4	photo_lyzes
photomapped	20	5	275	4	photomapped
photomaps	18	4	560	4	photoma__ps
photomasks	21	5	374	4	photoma_sks
photometries	19	6	833	4	photometries
photonics	16	4	935	4	photo__nics
photophases	21	5	793	4	photophases
photophores	21	5	910	4	photophores
photopias	16	4	1014	4	photo__pias
photostated	17	6	586	4	photosta_ted
photostatic	18	5	711	4	photostati_c
photostating	18	13	583	4	photostating
photostats	15	4	706	4	photosta__ts
photostatted	18	6	334	4	photostatted
phototactic	20	5	529	4	phototactic
phototube	16	5	391	4	photot_ube_
phototype	19	4	605	4	photot_ype_
phyllotaxes	26	5	185	4	phyllotax_es
phyllotaxis	26	6	192	4	phyllotaxi_s
phytogenies	20	5	578	4	phytogenies
phytologies	20	4	904	4	phytologies
phytotoxic	27	5	462	4	phytotoxi_c
plottages	12	4	424	4	plot_ta_ges
plotties	10	31	1141	4	plot_t__ies
pottages	11	29	1045	4	p_ot_ta_ges
potteries	11	3	1359	4	p_ot_teries
potties	9	37	2354	4	p_ot_t__ies
proletaries	13	4	845	4	proletaries
prothoraxes	23	5	451	4	prothorax_es
protogalaxies	23	6	177	4	protogalaxies
protonates	12	4	1169	4	protona_tes
protonotaries	15	6	317	4	protonotaries
prototypes	17	4	592	4	protot_ypes
protoxides	20	4	628	4	proto__xides
protoxids	19	4	718	4	proto__xids
rheotaxes	19	4	357	4	rh_eotax_es
rheotaxis	19	4	311	4	rh_eotaxi_s
tropotaxes	19	5	383	4	tropotax_es
tropotaxis	19	5	322	4	tropotaxi_s

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	148819	0.186	960704.3
2	DLD Change Limit	148819	78	8.360	17801.3
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	8.592	20797.4