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

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

89 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
stypsis	12	4	524	(None)
sepsis	8	30	1129	2	s_epsis
skepsis	13	4	425	2	skepsis
stasis	6	31	1687	2	st_asis
stypsises	14	4	342	2	stypsises
styptic	14	4	545	2	styptic
styptics	15	4	381	2	styptics
apsis	7	57	1829	3	__apsis
asepsis	9	8	590	3	asepsis
atypic	13	33	765	3	atyp_ic
cyesis	11	4	857	3	_cyesis
esthesis	11	4	846	3	esthesis
gypsies	13	3	595	3	_gypsies
lysis	8	45	1146	3	_ly_sis
myasis	11	40	1047	3	_myasis
myosis	11	40	1256	3	_myosis
osteosis	8	4	674	3	osteosis
ostosis	7	13	1012	3	ost_osis
physis	14	35	966	3	phy_sis
psis	6	81	2034	3	___psis
ptosis	8	36	1182	3	pt_osis
pyosis	11	40	1212	3	_pyosis
scyphi	16	4	317	3	scyphi_
scyphus	17	4	320	3	scyphus
sepses	8	45	1588	3	s_epses
skyphos	19	6	373	3	skyphos
slypes	11	44	1048	3	slyp_es
sorosis	7	26	1197	3	sorosis
stapes	8	50	2873	3	stap_es
staphs	11	44	1103	3	stap_hs
staples	9	36	1721	3	staples
stases	6	42	2556	3	st_ases
steapsin	10	4	471	3	steapsin
steapsins	11	4	463	3	steapsins
stenosis	8	4	799	3	stenosis
steppes	11	31	1069	3	steppes
steps	7	66	1988	3	step__s
stepson	9	4	567	3	stepson
stepsons	10	4	566	3	stepsons
stepwise	13	4	416	3	stepwise
stipels	9	41	895	3	stipels
stipes	8	45	2405	3	stip_es
stopers	9	42	1737	3	stopers
stopes	8	45	2589	3	stop_es
stops	7	48	2728	3	stop__s
stoss	5	43	1634	3	st_os_s
strass	6	71	1722	3	stras_s
stress	6	66	1667	3	stres_s
stupas	8	39	1088	3	stup_as
stupes	8	41	1695	3	stup_es
stupid	9	3	759	3	stup_id
stupids	10	3	527	3	stupids
stupors	9	3	588	3	stupors
styes	8	63	1652	3	sty__es
stylers	10	35	935	3	stylers
styles	9	44	1865	3	sty_les
stylets	10	36	921	3	stylets
styli	8	39	1117	3	sty_li_
stylise	10	20	895	3	stylise
stylises	11	18	894	3	stylises
stylish	13	19	744	3	stylish
stylist	10	21	1028	3	stylist
stylists	11	20	702	3	stylists
styloid	11	3	755	3	styloid
stylus	9	39	746	3	sty_lus
styluses	11	20	477	3	styluses
stymie	11	3	762	3	sty_mie
stymies	12	3	921	3	stymies
sycosis	12	3	882	3	sycosis
sylis	8	43	1602	3	s_y_lis
synapsis	13	4	514	3	synapsis
synesis	10	3	916	3	synesis
synopsis	13	4	665	3	synopsis
syphs	13	51	945	3	s_yp_hs
tapis	7	50	2886	3	_tap_is
thesis	9	49	1373	3	_thesis
tipis	7	60	1992	3	_tip_is
tmesis	8	52	979	3	_tmesis
topis	7	60	2583	3	_top_is
trypsin	12	4	511	3	trypsin
trypsins	13	4	490	3	trypsins
tussis	6	37	995	3	_tussis
types	10	57	2106	3	_typ_es
typhus	14	39	571	3	_typhus
typic	12	45	1196	3	_typ_ic
typist	11	3	982	3	_typist
typists	12	3	617	3	_typists
typos	10	60	1581	3	_typ_os
typps	12	54	930	3	_typ_ps

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.436	409841.7
2	DLD Change Limit	134027	89	6.643	20175.7
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	7.109	25135.9