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

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

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
saphena	12	3	586	1	saphena
saphead	13	5	777	2	saphead
saphenae	13	4	485	2	saphenae
saphenas	13	4	571	2	saphenas
sapiens	9	3	1017	2	sapiens
sapient	9	4	1533	2	sapient
sphene	11	34	1240	2	s_phene
achene	11	3	1381	3	_achene
append	11	3	827	3	_append
ashen	8	78	1867	3	_ashen_
aspen	7	52	1609	3	asp_en_
aspens	8	50	1335	3	asp_ens
astheny	13	4	529	3	astheny
camphene	17	4	661	3	camphene
daphne	12	23	701	3	daph_ne
daphnes	13	32	768	3	daphnes
happen	13	48	1219	3	happen_
happens	14	35	917	3	happens
hapten	11	53	1298	3	hapten_
haptene	12	38	1093	3	haptene
haptens	12	45	1134	3	haptens
hyphen	17	3	639	3	hyphen_
hyphens	18	3	604	3	hyphens
raphe	10	49	1642	3	raphe__
raphes	11	51	1745	3	raphe_s
rappen	10	35	1271	3	rappen_
sachem	13	40	1222	3	sache_m
sachems	14	34	890	3	sachems
sachet	11	47	2577	3	sache_t
sachets	12	39	1410	3	sachets
sadden	8	32	1240	3	sadden_
saddens	9	30	960	3	saddens
sadhe	9	48	1513	3	sadhe__
sadhes	10	47	1537	3	sadhe_s
sahib	10	3	1476	3	sa_h_ib
salient	7	4	1976	3	salient
sapheads	14	6	608	3	sapheads
saphenous	14	4	487	3	saphenous
sapience	12	10	661	3	sapience
sapiency	15	11	449	3	sapiency
sapients	10	3	742	3	sapients
sapless	9	33	1344	3	sapless
sapling	10	32	1786	3	sapling
sapped	11	44	2201	3	sappe_d
sapper	10	38	2235	3	sappe_r
sappers	11	35	1890	3	sappers
sapping	12	35	1931	3	sapping
sarment	9	3	1876	3	sarment
sarsen	6	3	1423	3	sarsen_
sarsens	7	3	1139	3	sarsens
sashed	10	56	2294	3	sashe_d
sashes	9	47	2848	3	sashe_s
sashing	11	46	2147	3	sashing
sateen	6	38	1501	3	sateen_
sateens	7	37	1075	3	sateens
shapen	11	44	1465	3	shap_en_
shend	9	47	1997	3	s__hend
shent	8	59	3350	3	s__hent
siphon	11	3	846	3	siphon_
siphons	12	3	935	3	siphons
sithens	10	3	938	3	sithens
spahee	11	3	1344	3	spahe_e
spahees	12	3	826	3	spahees
spend	8	56	1933	3	s_p_end
spent	7	55	3283	3	s_p_ent
sphenes	12	30	1316	3	s_phenes
sphenic	14	4	909	3	s_phenic
sphere	11	33	1366	3	s_phere
sphery	14	31	888	3	s_phery
sphinx	18	6	620	3	s_phinx
sphynx	21	5	261	3	s_phynx
splent	8	47	2019	3	s_plent
sprent	8	45	2238	3	s_prent
superb	10	44	1099	3	sup_erb
sypher	14	31	708	3	syphe_r
syphers	15	31	727	3	syphers
syphon	14	3	685	3	syphon_
syphons	15	3	750	3	syphons

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.390	458182.1
2	DLD Change Limit	134027	78	6.673	20085.0
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	7.093	25192.6