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

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

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.

59 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
phoenix	19	4	436	(None)
phenix	18	3	713	1	ph_enix
phoenixes	21	4	339	2	phoenixes
phonic	13	33	1521	2	pho_nic
phrenic	14	3	877	2	phrenic
aphonia	12	27	1188	3	apho_nia
aphonic	14	27	1339	3	apho_nic
fornix	16	3	603	3	_fornix
helix	15	44	1301	3	_h_elix
hoeing	10	41	1702	3	_hoeing
hyenic	14	3	872	3	_hyenic
penis	7	51	2932	3	p__enis
phenixes	20	3	564	3	ph_enixes
phenol	11	4	925	3	ph_enol
phenom	13	3	947	3	ph_enom
phenoxy	22	4	348	3	ph_enoxy
phenyl	14	3	532	3	ph_enyl
phobia	13	27	860	3	pho_bia
phobic	15	30	1007	3	pho_bic
phocine	14	3	883	3	phocine
phoebe	13	3	500	3	phoe_be
phoebes	14	3	581	3	phoebes
phoebus	14	4	382	3	phoebus
phon	9	59	2538	3	pho_n__
phonal	11	3	1038	3	pho_nal
phone	10	56	2193	3	pho_n_e
phoned	12	40	1455	3	pho_ned
phoneme	14	4	620	3	phoneme
phonemic	17	4	717	3	phonemic
phones	11	41	2121	3	pho_nes
phonetic	15	3	1032	3	phonetic
phoney	14	36	1298	3	pho_ney
phoneys	15	43	714	3	phoneys
phonics	14	31	1072	3	pho_nics
phonied	13	37	1056	3	pho_nied
phonier	12	27	1063	3	pho_nier
phonies	12	37	1751	3	pho_nies
phonily	15	3	710	3	pho_nily
phoning	13	3	1205	3	pho_ning
phono	10	49	1702	3	pho_n_o
phonon	11	40	1203	3	pho_non
phonos	11	41	1479	3	pho_nos
phons	10	52	2114	3	pho_n_s
phony	13	67	1544	3	pho_n_y
phoronid	14	4	907	3	phoronid
photic	13	33	1644	3	pho_tic
photonic	15	3	1210	3	photonic
phrensy	15	3	362	3	phrensy
pionic	10	35	1595	3	pio_nic
pleonic	11	3	943	3	pleonic
poetic	10	4	1684	3	p_oetic
prefix	18	35	685	3	p_refix
premix	17	37	1033	3	p_remix
prolix	15	3	868	3	pro_lix
pyogenic	16	4	858	3	pyogenic
sheenie	10	15	949	3	sheenie
shoebox	19	4	362	3	shoebox
shoeing	11	32	1188	3	shoeing
sphenic	14	4	909	3	sph_enic

Search took 8 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	134027	0.406	440125.6
2	DLD Change Limit	134027	59	7.186	18651.1
3	Display Results	59	59	0.033	1787.9
	(SQL Overall)	178691	59	7.625	23434.9