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

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

78 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
darkies	12	40	1575	(None)
darbies	10	42	1698	1	darbies
darkie	11	37	1401	1	darkie_
darkles	12	40	1193	1	darkles
alkies	10	45	1809	2	_alkies
armies	8	51	2369	2	_armies
barbies	11	45	1959	2	barbies
barkier	13	38	1448	2	barkier
barkiest	14	41	1515	2	barkiest
birkies	13	37	1243	2	birkies
caries	8	51	4762	2	car_ies
carnies	9	41	2396	2	carnies
carries	9	43	2801	2	carries
daddies	10	34	1494	2	daddies
dailies	8	42	1926	2	dailies
dairies	8	42	1773	2	dairies
daisies	8	42	1709	2	daisies
dallies	8	40	2319	2	dallies
dandies	9	41	2144	2	dandies
dares	6	61	4670	2	dar__es
darics	9	43	1411	2	dar_ics
darked	12	39	1963	2	dark_ed
darken	11	40	1344	2	dark_en
darkens	12	40	987	2	darkens
darker	11	47	1869	2	dark_er
darkest	12	25	1262	2	dark_est
darkey	14	52	1242	2	dark_ey
darkeys	15	35	653	2	darkeys
darking	13	42	1734	2	darking
darkish	15	3	794	2	darkish
darkle	11	38	1394	2	darkle_
darkled	13	37	871	2	darkled
darklier	13	3	501	2	darklier
darkliest	14	3	516	2	darkliest
darkness	13	24	734	2	darkness
darks	10	67	2787	2	dark__s
dartles	8	40	1413	2	dartles
dassies	8	44	1866	2	dassies
dauties	8	33	1576	2	dauties
davies	10	50	2051	2	da_vies
dawties	11	33	1270	2	dawties
dearies	8	35	2627	2	dear_ies
derbies	10	30	1605	2	derbies
derries	8	31	2462	2	derries
diaries	8	33	2195	2	diar_ies
dickies	14	34	1634	2	dickies
dinkies	12	37	1603	2	dinkies
dirties	8	31	1938	2	dirties
dories	7	52	3236	2	dor_ies
dorkier	12	28	1002	2	dorkier
dorkiest	13	31	1125	2	dorkiest
drakes	11	47	1586	2	drak_es
dries	6	47	3367	2	d_r_ies
duckies	14	36	1381	2	duckies
durries	8	38	1735	2	durries
farcies	12	53	1788	2	farcies
gawkies	15	42	912	2	gawkies
hackies	16	34	1824	2	hackies
hankies	14	36	1776	2	hankies
hardies	11	49	2323	2	hardies
harpies	12	38	1831	2	harpies
harries	10	35	2549	2	harries
hawkies	17	33	1124	2	hawkies
jackies	20	29	1262	2	jackies
jerkies	18	34	1158	2	jerkies
larkier	11	37	1152	2	larkier
larkiest	12	37	1331	2	larkiest
marries	9	38	2528	2	marries
paries	8	47	4251	2	par_ies
parries	9	39	2584	2	parries
parties	9	32	3086	2	parties
porkies	13	34	1649	2	porkies
sarkier	11	34	1331	2	sarkier
sarkiest	12	36	1506	2	sarkiest
talkies	11	34	1573	2	talkies
tardies	8	42	2586	2	tardies
tarries	7	33	2426	2	tarries
varies	9	43	3087	2	var_ies

Search took 5 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.140	1276364.3
2	DLD Change Limit	107671	78	4.093	26306.1
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	4.263	41916.7