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

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

103 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
creeps	10	42	1362	(None)
cheeps	13	53	1291	1	cheeps
creeds	9	47	1477	1	creeds
creeks	12	48	1292	1	creeks
creels	8	44	1694	1	creels
creep	9	52	1810	1	creep_
creepy	13	41	880	1	creepy
crepes	10	54	1934	1	crepes
kreeps	12	42	741	1	kreeps
beeps	9	53	2097	2	_beeps
bleeps	10	49	910	2	bleeps
breeds	9	49	1488	2	breeds
breeks	12	53	1079	2	breeks
brees	7	56	3255	2	bree_s
careens	9	45	1470	2	careens
careers	9	52	1878	2	careers
cees	6	59	4159	2	c_ee_s
cepes	9	44	2446	2	c_epes
ceps	8	61	2595	2	c__eps
ceres	7	55	4001	2	cere_s
cereus	8	52	1552	2	cereus
cheaps	13	46	1368	2	cheaps
cheeks	15	47	1278	2	cheeks
cheep	12	54	1650	2	cheep_
cheers	11	45	1891	2	cheers
cleeks	12	50	1054	2	cleeks
clepes	10	42	1462	2	clepes
cramps	12	56	1556	2	cramps
crapes	10	47	2769	2	crapes
craps	9	53	2864	2	cr_aps
creaks	12	43	1596	2	creaks
creams	10	47	1525	2	creams
credos	9	46	1285	2	credos
creds	8	54	1877	2	cr_eds
creed	8	57	2739	2	cree_d
creek	11	49	1739	2	cree_k
creel	7	51	2148	2	cree_l
creeped	12	32	971	2	creeped
creeper	11	33	998	2	creeper
creepers	12	31	863	2	creepers
creepie	11	3	748	2	creepie
creepies	12	3	961	2	creepies
creese	8	40	1433	2	creese
creeses	9	39	1462	2	creeses
creesh	11	32	833	2	creesh
cremes	10	45	1799	2	cremes
crenels	9	37	1101	2	crenels
crepe	9	55	2072	2	cr_epe
creped	11	41	1570	2	creped
crepey	13	51	1093	2	crepey
crept	9	51	2589	2	cr_ept
crepy	12	48	1270	2	cr_epy
cress	7	50	2283	2	cr_ess
crests	8	52	1870	2	crests
crewels	12	43	849	2	crewels
crews	10	59	1750	2	cr_ews
criers	8	39	1858	2	criers
cries	7	54	3840	2	crie_s
crimps	12	46	1345	2	crimps
cripes	10	51	2087	2	cripes
crisps	10	44	1151	2	crisps
crops	9	61	2523	2	cr_ops
croups	10	43	1255	2	croups
cruets	8	53	1495	2	cruets
crumps	12	45	1434	2	crumps
deeps	8	49	2177	2	_deeps
drees	6	56	2852	2	dree_s
freers	9	47	1730	2	freers
frees	8	61	3139	2	free_s
greeds	8	43	1428	2	greeds
greens	7	57	1687	2	greens
grees	6	51	3247	2	gree_s
greets	7	51	1742	2	greets
jeeps	14	47	1537	2	_jeeps
keeps	11	60	2028	2	_keeps
kreep	11	46	1041	2	kreep_
neeps	7	56	1788	2	_neeps
peeps	9	58	2236	2	_peeps
preens	8	50	2011	2	preens
prees	7	59	3717	2	pree_s
preops	10	49	1194	2	preops
preps	9	62	2069	2	pr_eps
reaps	7	56	2619	2	_reaps
reeds	6	54	3090	2	_reeds
reefs	8	51	2166	2	_reefs
reeks	9	41	2403	2	_reeks
reels	5	53	3326	2	_reels
rees	4	53	6419	2	_ree_s
repps	9	51	1434	2	_repps
reps	6	59	3795	2	_r_eps
screeds	10	62	1029	2	screeds
screens	9	52	1218	2	screens
screes	8	50	2397	2	scree_s
seeps	7	48	2875	2	_seeps
sleeps	8	39	1332	2	sleeps
steeps	8	52	1519	2	steeps
sweeps	11	41	1051	2	sweeps
threeps	12	68	704	2	threeps
treens	6	53	1787	2	treens
trees	5	58	3576	2	tree_s
veeps	10	47	1572	2	_veeps
weeps	10	41	2056	2	_weeps
wheeps	14	43	995	2	wheeps

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	82551	0.376	475242.0
2	DLD Change Limit	82551	103	3.420	24137.7
3	Display Results	103	103	0.033	3121.2
	(SQL Overall)	178691	103	3.829	46667.8