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

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

53 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
heavies	13	27	1387	(None)
heaves	12	41	2030	1	heav_es
heavier	13	42	942	1	heavier
heaviest	14	32	1044	1	heaviest
peavies	12	22	1339	1	peavies
beanies	9	38	2109	2	beanies
bevies	11	40	1730	2	be_vies
cavies	11	45	2500	2	_cavies
cheapies	15	3	903	2	cheapies
chevies	15	35	1144	2	che_vies
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
haves	11	60	3487	2	h_av_es
headier	11	32	1295	2	headier
headiest	12	30	1555	2	headiest
hearses	10	44	1453	2	hearses
hearties	11	3	1541	2	hearties
heaumes	12	3	742	2	heaumes
heave	11	45	2181	2	heav_e_
heaved	13	47	1786	2	heav_ed
heaven	12	39	1260	2	heav_en
heavens	13	43	930	2	heavens
heaver	12	48	1967	2	heav_er
heavers	13	37	1719	2	heavers
heavily	16	6	590	2	heavily
heaviness	15	20	706	2	heaviness
heaving	14	41	1476	2	heaving
heinies	10	25	1454	2	heinies
helves	12	43	1606	2	helv_es
henries	10	27	1828	2	henries
herries	10	40	2507	2	herries
hoagies	11	28	1199	2	hoagies
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
readies	8	33	2470	2	readies
reaves	9	41	2757	2	reav_es
shavies	13	42	1320	2	shavies
sheaves	13	44	1297	2	sheav_es
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 4 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.143	1249587.4
2	DLD Change Limit	107671	53	3.500	30763.1
3	Display Results	53	53	0.013	4076.9
	(SQL Overall)	178691	53	3.656	48876.1