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

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

57 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
peavies	12	22	1340	(None)
heavies	13	27	1387	1	heavies
beanies	9	38	2109	2	beanies
bevies	11	40	1730	2	be_vies
cavies	11	45	2500	2	_cavies
davies	10	50	2051	2	_davies
dearies	8	35	2627	2	dearies
deaves	10	53	1953	2	deav_es
easies	6	41	2663	2	_easies
eaves	8	52	3199	2	_eav_es
envies	9	3	1405	2	_envies
gravies	11	3	1409	2	gravies
heaves	12	41	2030	2	heav_es
heavier	13	42	942	2	heavier
heaviest	14	32	1044	2	heaviest
leaves	9	42	2238	2	leav_es
leavier	10	31	999	2	leavier
leaviest	11	29	1081	2	leaviest
levies	9	39	1986	2	le_vies
mavies	11	49	2319	2	_mavies
mealies	9	28	2193	2	mealies
meanies	9	36	2074	2	meanies
navies	9	52	1862	2	_navies
paries	8	47	4251	2	p_aries
paves	10	48	3392	2	p_av_es
pavins	11	49	1966	2	p_avins
pavis	10	64	2273	2	p_avi_s
pavise	11	47	1480	2	p_avise
pavises	12	53	1549	2	p_avises
peaces	10	63	2408	2	pea_ces
peaches	14	41	2005	2	peaches
peages	9	43	2185	2	pea_ges
peakier	13	44	1144	2	peakier
peakiest	14	35	1299	2	peakiest
peases	8	52	2947	2	pea_ses
peatier	9	40	1723	2	peatier
peatiest	10	31	1880	2	peatiest
peavey	14	39	879	2	peav_ey
peaveys	15	32	406	2	peaveys
peeries	9	36	2302	2	peeries
peeves	11	38	1487	2	peev_es
pelves	11	45	1466	2	pelv_es
pelvics	14	24	564	2	pelvics
pelvis	11	36	1032	2	pelvi_s
pelvises	13	3	727	2	pelvises
pennies	9	42	1881	2	pennies
peonies	9	36	2015	2	peonies
perries	9	32	2660	2	perries
platies	9	37	2254	2	platies
privies	12	24	1426	2	privies
readies	8	33	2471	2	readies
reaves	9	41	2757	2	reav_es
shavies	13	42	1320	2	shavies
spavies	12	30	1294	2	spavies
wavies	12	50	1984	2	_wavies
wearies	10	30	2022	2	wearies
weaves	12	36	1637	2	weav_es

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	107671	0.523	341665.4
2	DLD Change Limit	107671	57	4.483	24017.6
3	Display Results	57	57	0.016	3562.5
	(SQL Overall)	178691	57	5.022	35581.6