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

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

77 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
kreep	11	46	1041	(None)
creep	9	52	1810	1	creep
keep	10	63	2982	1	k_eep
kreeps	12	42	741	1	kreeps
beep	8	59	3121	2	_beep
bleep	9	50	1345	2	bleep
bree	6	72	4126	2	bree_
breed	8	55	2669	2	breed
brees	7	56	3255	2	brees
cheep	12	54	1650	2	cheep
creed	8	57	2739	2	creed
creek	11	49	1739	2	creek
creel	7	51	2148	2	creel
creeps	10	42	1362	2	creeps
creepy	13	41	880	2	creepy
crepe	9	55	2072	2	crepe
deep	7	60	3188	2	_deep
dree	5	66	3832	2	dree_
dreed	7	52	2284	2	dreed
drees	6	56	2852	2	drees
free	7	59	4018	2	free_
freed	9	52	2354	2	freed
freer	8	60	2124	2	freer
frees	8	61	3139	2	frees
gree	5	66	4156	2	gree_
greed	7	51	2569	2	greed
greek	10	59	1594	2	greek
green	6	55	2214	2	green
grees	6	51	3247	2	grees
greet	6	58	3532	2	greet
jeep	13	56	2484	2	_jeep
keef	11	58	3000	2	k_eef
keek	7	56	2497	2	k_eek
keel	8	57	2947	2	k_eel
keen	8	48	3041	2	k_een
keeps	11	60	2028	2	k_eeps
keet	8	53	4734	2	k_eet
kelep	11	60	1456	2	kelep
kelp	10	53	2280	2	k_elp
kemp	12	64	1876	2	k_emp
kep	9	64	3720	2	k__ep
knee	8	53	2360	2	knee_
kneed	10	46	1205	2	kneed
kneel	9	50	1203	2	kneel
knees	9	51	1487	2	knees
krewe	12	3	819	2	krewe
krewes	13	3	792	2	krewes
neep	6	57	2831	2	_neep
peep	8	58	3369	2	_peep
pree	6	70	4473	2	pree_
preed	8	51	2812	2	preed
preen	7	59	2505	2	preen
prees	7	59	3717	2	prees
preop	9	47	1587	2	preop
prep	8	64	2767	2	pr_ep
reap	6	59	3474	2	_reap
ree	3	79	7407	2	_ree_
reed	5	55	4962	2	_reed
reef	7	49	3821	2	_reef
reek	8	52	3252	2	_reek
reel	4	52	4053	2	_reel
rees	4	53	6419	2	_rees
rep	5	58	4780	2	_r_ep
repp	8	54	1874	2	_repp
seep	6	65	4034	2	_seep
sheep	10	53	2152	2	sheep
sleep	7	49	2018	2	sleep
steep	7	60	2070	2	steep
sweep	10	47	1572	2	sweep
threep	11	59	1011	2	threep
tree	4	77	4581	2	tree_
treed	6	56	2673	2	treed
treen	5	56	2275	2	treen
trees	5	58	3576	2	trees
veep	9	53	2509	2	_veep
weep	9	51	3165	2	_weep
wheep	13	62	1435	2	wheep

Search took 2 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	53800	0.313	570897.8
2	DLD Change Limit	53800	77	1.423	37807.4
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	1.766	101184.0