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

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

92 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
quays	17	46	1204	(None)
quads	15	45	1584	1	quads
quags	15	46	1325	1	quags
quais	14	46	1839	1	quais
quass	14	44	1376	1	quass
quay	16	46	1835	1	quay_
queys	17	39	836	1	queys
aquas	14	24	1261	2	aqua_s
ays	6	70	5029	2	__ays
bays	9	71	4391	2	_bays
brays	10	67	2311	2	brays
buoys	10	48	1063	2	buoys
buys	9	57	2679	2	bu_ys
cays	9	54	3767	2	_cays
chays	13	53	1974	2	chays
clays	10	55	2133	2	clays
days	8	76	3713	2	_days
drays	9	58	1977	2	drays
duads	7	65	1534	2	duads
duals	6	56	2008	2	duals
equals	15	3	870	2	equals
fays	10	85	3536	2	_fays
flays	11	63	2105	2	flays
frays	11	69	2010	2	frays
gays	8	73	3802	2	_gays
grays	9	56	2133	2	grays
guans	6	44	1944	2	guans
guars	6	50	2105	2	guars
guys	8	50	1964	2	gu_ys
hays	10	61	3807	2	_hays
jays	14	63	2834	2	_jays
kays	11	60	3220	2	_kays
kumys	14	3	593	2	kumys
lays	7	60	4325	2	_lays
luaus	5	45	1490	2	luaus
mays	9	69	4003	2	_mays
nays	7	59	3159	2	_nays
ofays	11	48	892	2	ofays
okays	12	60	944	2	okays
pays	9	59	4022	2	_pays
plays	10	63	2077	2	plays
prays	10	50	2243	2	prays
qats	13	53	3134	2	q_ats
qua	12	48	2197	2	qua__
quack	20	38	1250	2	quack
quacks	21	47	1010	2	quacks
quad	14	46	1870	2	qua_d
quaff	20	13	1135	2	quaff
quaffs	21	12	569	2	quaffs
quag	14	48	1594	2	qua_g
quai	13	44	2039	2	qua_i
quail	14	43	1436	2	quail
quails	15	34	1264	2	quails
quake	18	41	1464	2	quake
quakes	19	40	1334	2	quakes
quaky	21	43	1074	2	quaky
quale	14	36	1785	2	quale
qualm	16	35	1118	2	qualm
qualms	17	31	724	2	qualms
quant	14	36	2481	2	quant
quants	15	36	1414	2	quants
quare	14	39	2054	2	quare
quark	18	46	1412	2	quark
quarks	19	38	1091	2	quarks
quart	14	40	2785	2	quart
quarts	15	47	1594	2	quarts
quash	17	45	1216	2	quash
quasi	14	40	1502	2	quasi
quate	14	45	2141	2	quate
queans	15	31	1075	2	queans
queasy	18	5	517	2	queasy
quey	16	46	1647	2	quey_
quids	15	49	1747	2	quids
quins	14	48	1985	2	quins
quips	16	47	1337	2	quips
quits	14	41	2235	2	quits
quods	15	46	1022	2	quods
rays	7	76	4235	2	_rays
says	7	59	4210	2	_says
shays	11	60	2143	2	shays
slays	8	57	2368	2	slays
spays	10	55	2051	2	spays
squabs	17	42	932	2	squabs
squads	16	44	1029	2	squads
squats	15	37	1296	2	squats
squaws	18	43	878	2	squaws
stays	8	60	2202	2	stays
sways	11	55	1846	2	sways
trays	8	56	2343	2	trays
ways	10	77	3795	2	_ways
yays	10	57	2891	2	_yays
yuans	8	46	1332	2	yuans

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	92	1.376	39098.8
3	Display Results	92	92	0.030	3066.7
	(SQL Overall)	178691	92	1.719	103950.6