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

Here are the results of your fuzzy-string dictionary search for “jeeping” 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
jeeping	17	40	1033	(None)
beeping	12	40	1391	1	beeping
jeeing	14	45	1214	1	jee_ing
jeering	15	35	1304	1	jeering
keeping	14	40	1254	1	keeping
peeping	12	36	1521	1	peeping
seeping	10	38	1791	1	seeping
weeping	13	36	1367	1	weeping
beefing	13	39	1147	2	beefing
bleeping	13	37	793	2	bleeping
cheeping	16	32	955	2	cheeping
cleping	12	33	1042	2	cleping
creeping	13	33	1010	2	creeping
creping	12	29	1365	2	creping
deeding	10	33	1512	2	deeding
deeming	11	39	1312	2	deeming
feeding	12	35	1507	2	feeding
feeing	10	44	1650	2	fee_ing
feeling	11	36	1707	2	feeling
feezing	20	46	1016	2	feezing
geeing	8	43	1377	2	gee_ing
heaping	13	30	1585	2	heaping
heeding	12	35	1506	2	heeding
heeling	11	36	1851	2	heeling
heezing	20	34	987	2	heezing
helping	13	35	1222	2	helping
japing	16	50	1357	2	j_aping
jauping	17	30	719	2	jauping
jelling	15	35	1661	2	jelling
jerking	19	30	892	2	jerking
jessing	15	37	1062	2	jessing
jesting	15	43	1771	2	jesting
jetting	15	38	1534	2	jetting
jeweling	19	3	548	2	jeweling
jewing	17	44	1142	2	j_ewing
jumping	19	31	980	2	jumping
keeking	11	42	1089	2	keeking
keeling	12	35	1512	2	keeling
keening	12	37	1315	2	keening
keepings	15	34	594	2	keepings
kelping	14	31	919	2	kelping
kepping	16	26	859	2	kepping
leaping	10	32	1599	2	leaping
leering	8	34	1764	2	leering
meeting	10	33	1496	2	meeting
needing	9	32	1442	2	needing
peeing	9	46	1808	2	pee_ing
peeking	14	44	1495	2	peeking
peeling	10	29	1987	2	peeling
peening	10	33	1830	2	peening
peering	10	35	2035	2	peering
peeving	13	51	1224	2	peeving
pepping	11	35	1162	2	pepping
reaping	10	36	2121	2	reaping
reeding	9	41	2413	2	reeding
reefing	11	40	1686	2	reefing
reeking	12	33	1864	2	reeking
reeling	8	31	2686	2	reeling
reeving	11	37	1766	2	reeving
repping	12	33	1498	2	repping
seeding	9	37	1948	2	seeding
seeing	7	42	2214	2	see_ing
seeking	12	40	1606	2	seeking
seeling	8	35	2200	2	seeling
seeming	10	32	1626	2	seeming
sleeping	11	38	1205	2	sleeping
steeping	11	34	1258	2	steeping
sweeping	14	38	914	2	sweeping
teeing	7	39	1697	2	tee_ing
teeming	10	35	1309	2	teeming
temping	12	27	1069	2	temping
veering	11	32	1368	2	veering
weeding	12	38	1521	2	weeding
weening	11	41	1397	2	weening
weepings	14	34	648	2	weepings
weeting	11	38	1605	2	weeting
wheeping	17	33	710	2	wheeping
yelping	13	31	787	2	yelping

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.373	479064.3
2	DLD Change Limit	107671	78	2.800	38453.9
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	3.203	55788.6