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

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

104 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
peeping	12	36	1521	(None)
beeping	12	40	1391	1	beeping
jeeping	17	40	1033	1	jeeping
keeping	14	40	1254	1	keeping
peeing	9	46	1808	1	pee_ing
peeking	14	44	1495	1	peeking
peeling	10	29	1987	1	peeling
peening	10	33	1830	1	peening
peering	10	35	2035	1	peering
peeving	13	51	1224	1	peeving
pepping	11	35	1162	1	pepping
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	1376	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
jeeing	14	45	1214	2	jee_ing
jeering	15	35	1304	2	jeering
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
palping	12	41	1287	2	palping
peacing	12	41	1707	2	peacing
peaking	14	43	1769	2	peaking
pealing	10	41	2320	2	pealing
peching	15	45	1390	2	peching
pecking	16	40	1778	2	pecking
peelings	11	33	952	2	peelings
pegging	12	28	1113	2	pegging
peining	10	46	1915	2	peining
peising	10	34	1676	2	peising
pelting	10	29	1727	2	pelting
pending	11	41	1977	2	pending
penning	10	36	1649	2	penning
peopling	13	3	835	2	peopling
pepino	10	3	1033	2	p_epino
perking	14	37	1646	2	perking
perming	12	34	1609	2	perming
petering	11	25	1681	2	petering
petting	10	37	2095	2	petting
piecing	12	4	1045	2	piecing
pieing	9	39	1765	2	pie_ing
pimping	14	38	1212	2	pimping
piping	11	40	1745	2	p_iping
pipping	11	34	1474	2	pipping
pooping	12	36	1544	2	pooping
popping	11	37	1541	2	popping
preeing	10	38	1767	2	preeing
preening	11	31	1584	2	preening
prepping	12	30	976	2	prepping
preying	13	31	1455	2	preying
pulping	12	36	1232	2	pulping
pumping	14	42	1355	2	pumping
pupping	11	44	1250	2	pupping
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
speeding	12	28	1093	2	speeding
speeling	11	27	1312	2	speeling
speering	11	31	1632	2	speering
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 7 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.126	1418182.5
2	DLD Change Limit	107671	104	6.720	16022.5
3	Display Results	104	104	0.076	1368.4
	(SQL Overall)	178691	104	6.922	25814.9