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

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

64 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
ayahs	11	68	1352	(None)
aahs	7	164	2856	1	a_ahs
amahs	10	78	1906	1	amahs
ayah	10	80	2299	1	ayah_
rayahs	12	57	919	1	rayahs
aah	6	162	5296	2	a_ah_
aals	4	99	4114	2	a_als
aas	3	109	7539	2	a_a_s
abas	6	86	4208	2	aba_s
abash	10	60	1651	2	abash
afars	8	57	1651	2	afars
agars	6	61	2064	2	agars
agas	5	59	3884	2	aga_s
aghas	9	70	1487	2	aghas
ahs	6	86	4482	2	__ahs
alans	5	56	3617	2	alans
alas	4	63	5812	2	ala_s
aliyahs	13	39	532	2	aliyahs
almahs	11	86	1161	2	almahs
amah	9	89	2748	2	amah_
amas	6	77	4629	2	ama_s
amass	7	71	1968	2	amass
anas	4	66	4986	2	ana_s
ankhs	12	11	672	2	ankhs
araks	9	48	2088	2	araks
ataps	7	64	1483	2	ataps
awash	11	66	1316	2	awash
ayes	7	65	4351	2	ay_es
ayins	8	53	2161	2	ayins
ays	6	70	5029	2	ay__s
azans	14	65	1688	2	azans
blahs	10	56	1651	2	blahs
cyans	10	57	1481	2	cyans
dahs	8	82	3181	2	_dahs
dyads	10	54	997	2	dyads
eyas	7	64	2743	2	eya_s
eyass	8	44	1078	2	eyass
galahs	10	55	1267	2	galahs
gayals	10	3	951	2	gayals
hahs	10	83	3336	2	_hahs
kayaks	12	3	633	2	kayaks
kyaks	11	45	916	2	kyaks
kyars	12	48	1396	2	kyars
kyats	12	50	1244	2	kyats
mayas	10	59	2438	2	maya_s
mynahs	14	41	644	2	mynahs
myths	13	59	1160	2	myths
odahs	9	56	1008	2	odahs
opahs	10	54	1198	2	opahs
pyas	9	62	2570	2	pya_s
rajahs	16	49	766	2	rajahs
rayah	11	60	1350	2	rayah_
rayas	8	59	2205	2	raya_s
ryas	7	72	2461	2	rya_s
shahs	11	59	1951	2	shahs
syphs	13	51	945	2	syphs
yags	8	66	3229	2	_yags
yah	9	90	4635	2	_yah_
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

Search took 6 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.186	960704.3
2	DLD Change Limit	53800	64	4.610	11670.3
3	Display Results	64	64	0.046	1391.3
	(SQL Overall)	178691	64	4.842	36904.4