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

Here are the results of your fuzzy-string dictionary search for “wheres” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

101 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
wheres	12	59	1743	(None)
heres	8	62	4590	1	_heres
theres	9	65	2547	1	theres
where	11	70	1942	1	where_
whereas	13	44	890	1	whereas
wherves	16	54	805	1	wherves
whores	12	56	1710	1	whores
adheres	11	3	1016	2	adheres
ceres	7	55	4001	2	_ceres
chares	11	56	3180	2	chares
cheers	11	45	1891	2	cheers
cherts	11	56	1723	2	cherts
chevres	15	37	979	2	chevres
chores	11	48	2802	2	chores
coheres	12	29	1769	2	coheres
feres	8	60	3818	2	_feres
freres	9	47	1617	2	freres
ghees	9	52	1555	2	ghe_es
haeres	9	40	1703	2	haeres
hares	8	62	5554	2	_hares
hebes	10	55	2167	2	_hebes
hemes	10	50	3108	2	_hemes
herbs	10	55	2050	2	_herbs
herds	9	64	2468	2	_herds
here	7	64	4710	2	_here_
heresy	12	50	1123	2	_heresy
herls	8	52	2643	2	_herls
herms	10	56	2643	2	_herms
herns	8	48	2558	2	_herns
heroes	9	49	2382	2	_heroes
heros	8	49	3086	2	_heros
herpes	11	55	1732	2	_herpes
hers	7	58	4487	2	_her_s
hexes	15	51	2304	2	_hexes
hires	8	61	3434	2	_hires
inheres	10	3	1517	2	inheres
meres	7	51	4357	2	_meres
nowheres	14	3	751	2	nowheres
peres	7	62	4664	2	_peres
rhemes	11	59	1318	2	rhemes
seres	5	54	4889	2	_seres
shares	9	52	3641	2	shares
sheers	9	43	2240	2	sheers
sherds	10	56	1472	2	sherds
shires	9	52	2557	2	shires
shores	9	48	3041	2	shores
spheres	12	31	1435	2	spheres
steres	6	39	2953	2	steres
thebes	11	59	1449	2	thebes
themes	11	53	1925	2	themes
there	8	75	2739	2	there_
thermes	12	62	1461	2	thermes
therms	11	59	1487	2	therms
theses	9	65	1797	2	theses
threes	9	71	1732	2	threes
wares	8	82	5058	2	w_ares
wees	7	62	4912	2	w_e_es
were	7	62	3833	2	w_ere_
whales	12	47	1694	2	whales
wharfs	15	4	637	2	wharfs
wharves	16	45	713	2	wharves
wheals	12	45	1252	2	wheals
wheats	12	50	1322	2	wheats
whee	10	54	2959	2	whe_e_
wheel	11	55	1533	2	whe_el
wheels	12	38	1171	2	wheels
wheen	11	50	1605	2	whe_en
wheens	12	46	1061	2	wheens
wheep	13	62	1435	2	whe_ep
wheeps	14	43	995	2	wheeps
wheezes	22	30	680	2	wheezes
whelks	16	36	732	2	whelks
whelms	14	37	757	2	whelms
whelps	14	43	784	2	whelps
whenas	12	46	1046	2	whenas
whens	11	46	1876	2	whe_ns
whereat	13	43	1192	2	whereat
whereby	18	4	291	2	whereby
wherein	13	21	659	2	wherein
whereof	16	18	546	2	whereof
whereon	13	19	650	2	whereon
whereto	13	4	606	2	whereto
wherries	14	17	902	2	wherries
wherry	15	47	733	2	wherry
wherve	15	56	811	2	wherve
whets	11	50	1961	2	whe_ts
whews	14	51	1449	2	whe_ws
wheyey	18	3	432	2	wheyey
wheys	14	59	1155	2	whe_ys
whiles	12	44	1801	2	whiles
whines	12	51	2010	2	whines
whirls	12	47	1053	2	whirls
whirrs	12	40	859	2	whirrs
whirs	11	52	1809	2	whir_s
whites	12	39	1988	2	whites
wholes	12	46	1677	2	wholes
whore	11	60	1804	2	whore_
whored	13	55	1212	2	whored
whorls	12	44	1016	2	whorls
whorts	12	51	1143	2	whorts
wires	8	60	3491	2	w_ires

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	101	2.123	38884.1
3	Display Results	101	101	0.030	3366.7
	(SQL Overall)	178691	101	2.513	71106.6