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

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

72 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
waveys	15	59	701	(None)
wavers	12	50	2247	1	wavers
waves	11	56	3392	1	wave_s
wavey	14	51	1554	1	wavey_
avens	8	64	1933	2	_avens
avers	8	51	2731	2	_avers
aves	7	61	4260	2	_ave_s
cavers	11	50	2684	2	cavers
caves	10	56	3970	2	cave_s
coveys	14	54	1350	2	coveys
davens	10	46	1291	2	davens
eaves	8	52	3199	2	eave_s
faves	11	53	3142	2	fave_s
garveys	14	12	446	2	garveys
gavels	10	59	1109	2	gavels
havens	12	45	1404	2	havens
havers	12	47	2148	2	havers
haves	11	60	3487	2	have_s
jarveys	20	12	341	2	jarveys
lavers	9	45	2636	2	lavers
laves	8	60	3915	2	lave_s
mameys	13	44	952	2	mameys
mateys	11	56	1094	2	mateys
mavens	11	43	1297	2	mavens
navels	9	57	1269	2	navels
naves	8	70	3038	2	nave_s
oaves	8	49	2561	2	oave_s
pavers	11	50	2182	2	pavers
paves	10	48	3392	2	pave_s
peaveys	15	32	406	2	peaveys
ravels	9	47	1707	2	ravels
ravens	9	39	1688	2	ravens
ravers	9	46	2818	2	ravers
raves	8	54	4197	2	rave_s
savers	9	38	2592	2	savers
saves	8	58	3863	2	save_s
savoys	12	42	789	2	savoys
slaveys	13	41	520	2	slaveys
waders	10	91	2064	2	waders
wades	9	56	3414	2	wade_s
waes	7	60	4860	2	wa_e_s
wafers	12	43	1614	2	wafers
wagers	10	51	2220	2	wagers
wages	9	53	3093	2	wage_s
waivers	13	34	1005	2	waivers
waives	12	37	1418	2	waive_s
wakens	13	50	1204	2	wakens
wakers	13	48	2249	2	wakers
wakes	12	66	3365	2	wake_s
walers	9	48	2446	2	walers
wales	8	61	4283	2	wale_s
wames	10	64	3280	2	wame_s
wanes	8	50	4088	2	wane_s
waney	11	51	2032	2	waney_
wares	8	82	5058	2	ware_s
waters	9	50	3063	2	waters
wave	10	52	3473	2	wave__
waved	12	52	2358	2	wave_d
waver	11	50	2570	2	wave_r
wavery	15	46	1005	2	wavery
wavies	12	50	1984	2	wavies
wavy	13	66	2047	2	wav_y_
waxers	16	40	1430	2	waxers
waxes	15	58	2550	2	waxe_s
ways	10	77	3795	2	wa__ys
weavers	13	37	1446	2	weavers
weaves	12	36	1637	2	weave_s
wheys	14	59	1155	2	w_heys
wifeys	15	42	587	2	wifeys
wivers	12	53	2080	2	wivers
wives	11	53	2892	2	wive_s
wovens	12	44	983	2	wovens

Search took 3 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	82551	0.360	496363.9
2	DLD Change Limit	82551	72	2.266	36430.3
3	Display Results	72	72	0.016	4500.0
	(SQL Overall)	178691	72	2.642	67634.7