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

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

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.

67 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
eyass	8	44	1078	(None)
eyas	7	64	2743	1	eya_s
eyases	9	45	1368	1	eyases
amass	7	71	1968	2	amass
ass	3	78	4406	2	__ass
ayahs	11	68	1352	2	ayahs
bass	6	61	4678	2	_bass
brass	7	54	2802	2	brass
bypass	13	4	504	2	bypass
class	7	55	2548	2	class
crass	7	63	2804	2	crass
cyans	10	57	1481	2	cyans
dyads	10	54	997	2	dyads
ears	4	63	5659	2	e_ars
ease	4	50	4233	2	e_ase
eases	5	60	4161	2	e_ases
east	4	66	5910	2	e_ast
easts	5	75	3032	2	e_asts
easy	7	62	2449	2	e_asy
eats	4	70	5487	2	e_ats
egads	7	46	1092	2	egads
elans	5	55	2775	2	elans
eras	4	54	4150	2	era_s
erase	5	49	2549	2	erase
erases	6	44	2540	2	erases
ess	3	60	3088	2	e__ss
etas	4	64	3227	2	eta_s
exams	14	19	908	2	exams
eyasses	10	38	802	2	eyasses
eyers	8	65	2133	2	eyers
eyes	7	58	3788	2	ey_es
eyras	8	47	1592	2	eyras
eyres	8	49	2177	2	eyres
frass	8	53	2112	2	frass
glass	6	55	1813	2	glass
grass	6	61	2520	2	grass
kvass	12	50	727	2	kvass
kyaks	11	45	916	2	kyaks
kyars	12	48	1396	2	kyars
kyats	12	50	1244	2	kyats
lass	4	74	4454	2	_lass
lyase	8	55	1241	2	lyase
lyases	9	52	1187	2	lyases
mass	6	60	4494	2	_mass
megass	9	21	944	2	megass
myases	11	37	1155	2	myases
myasis	11	40	1047	2	myasis
pass	6	52	3995	2	_pass
pyas	9	62	2570	2	pya_s
quass	14	44	1376	2	quass
repass	8	41	1470	2	repass
ryas	7	72	2461	2	rya_s
sass	4	50	3562	2	_sass
tass	4	56	4057	2	_tass
trass	5	62	2647	2	trass
yags	8	66	3229	2	_yags
yaks	11	60	2520	2	_yaks
yams	9	53	3073	2	_yams
yaps	9	59	3352	2	_yaps
yaws	10	55	3121	2	_yaws
yays	10	57	2891	2	_yays
yeahs	11	52	1455	2	yeahs
yeans	8	66	2488	2	yeans
years	8	45	2767	2	years
yeas	7	86	3842	2	yea_s
yeast	8	53	2794	2	yeast
yeasts	9	64	1305	2	yeasts

Search took 2 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	53800	0.313	570897.8
2	DLD Change Limit	53800	67	1.546	34799.5
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	1.889	94595.6