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

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

90 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
sphynx	21	5	261	(None)
sphinx	18	6	620	1	sphinx
sphene	11	34	1240	2	sphene
sphynxes	23	29	242	2	sphynxes
asphyxy	25	4	138	3	asphyxy
ethyne	12	40	715	3	ethyne
larynx	16	3	285	3	larynx
lynx	14	3	742	3	__lynx
pharynx	22	4	181	3	_pharynx
phenix	18	3	713	3	_phenix
phlox	17	3	733	3	_phlox
phon	9	59	2538	3	_phon_
phone	10	56	2193	3	_phone
phono	10	49	1702	3	_phono
phons	10	52	2114	3	_phons
phony	13	67	1544	3	_phony
phyla	13	46	918	3	_phyla
phyle	13	41	1115	3	_phyle
pyx	15	78	1701	3	_p_y_x
saphena	12	3	586	3	saphena
shank	12	54	2219	3	s_hank
shend	9	47	1997	3	s_hend
shent	8	59	3349	3	s_hent
shin	7	56	3430	3	s_hin_
shine	8	55	3309	3	s_hine
shins	8	51	3104	3	s_hins
shiny	11	51	2214	3	s_hiny
shone	8	37	2597	3	s_hone
shun	7	51	2277	3	s_hun_
shuns	8	50	1814	3	s_huns
shunt	8	52	2650	3	s_hunt
shy	9	67	2819	3	s_hy__
shyer	11	47	1478	3	s_hyer
shying	13	42	1184	3	s_hying
shyly	14	48	1157	3	s_hyly
siphon	11	3	846	3	siphon_
siphons	12	3	934	3	siphons
sophy	13	66	1176	3	sophy__
spadix	16	3	610	3	spadix
span	6	52	3466	3	sp_an_
spang	8	49	1973	3	sp_ang
spank	11	59	1957	3	sp_ank
spans	7	45	2873	3	sp_ans
spawn	10	78	1171	3	spawn_
spawns	11	57	792	3	spawns
spay	9	66	3166	3	spay__
spayed	12	42	1361	3	spayed
spaying	13	30	1462	3	spaying
spays	10	55	2051	3	spay_s
spean	7	46	2051	3	spean_
speans	8	54	1714	3	speans
spend	8	56	1933	3	sp_end
spent	7	55	3283	3	sp_ent
sphenes	12	30	1316	3	sphenes
sphenic	14	4	909	3	sphenic
sphere	11	33	1365	3	sphere
sphery	14	31	888	3	sphery
sphinxes	20	33	440	3	sphinxes
spin	6	62	3130	3	sp_in_
spine	7	65	3442	3	sp_ine
spinny	11	45	1018	3	spinny
spins	7	53	2798	3	sp_ins
spiny	10	49	2130	3	sp_iny
splent	8	47	2019	3	splent
spline	8	60	2053	3	spline
splint	8	52	2328	3	splint
spoon	7	47	1944	3	spoon_
spoons	8	41	1601	3	spoons
spoony	11	41	1179	3	spoony
sprang	9	57	1352	3	sprang
sprent	8	45	2238	3	sprent
spring	9	45	2601	3	spring
sprint	8	45	2679	3	sprint
sprung	9	46	1003	3	sprung
spry	9	68	1912	3	spry__
spryer	11	41	853	3	spryer
spryly	14	3	551	3	spryly
spuing	9	43	1336	3	spuing
spun	6	62	2146	3	sp_un_
spunk	11	45	1340	3	sp_unk
spurn	7	48	1545	3	spurn_
spurns	8	48	1138	3	spurns
spy	8	60	2374	3	sp_y__
spying	12	39	1325	3	spying
syn	6	70	2412	3	s__yn_
sync	9	54	1510	3	s__ync
syne	7	57	2576	3	s__yne
syphon	14	3	685	3	syphon_
syphons	15	3	750	3	syphons
syrinx	16	3	714	3	syrinx

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	112716	0.140	1276364.3
2	DLD Change Limit	112716	90	8.610	13091.3
3	Display Results	90	90	0.063	1428.6
	(SQL Overall)	178691	90	8.813	20275.8