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

Here are the results of your fuzzy-string dictionary search for “recaps” 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
recaps	10	36	1573	(None)
becaps	12	38	1140	1	becaps
reaps	7	56	2619	1	re_aps
recap	9	57	1802	1	recap_
redcaps	12	4	707	1	redcaps
remaps	10	50	1287	1	remaps
arecas	8	48	1744	2	areca_s
becap	11	43	1505	2	becap_
caps	8	71	4789	2	__caps
decafs	12	40	1088	2	decafs
decals	9	37	1771	2	decals
decamps	14	3	564	2	decamps
decays	12	46	1291	2	decays
gelcaps	12	3	520	2	gelcaps
heaps	10	52	2322	2	he_aps
icecaps	13	4	386	2	icecaps
leaps	7	55	2293	2	le_aps
neaps	7	56	1832	2	ne_aps
pecans	10	15	1583	2	pecans
raps	6	62	4773	2	r__aps
reacts	8	36	1660	2	reacts
reads	6	48	3527	2	re_ads
reals	5	50	3865	2	re_als
reams	7	57	2962	2	re_ams
reap	6	59	3474	2	re_ap_
rears	5	47	3965	2	re_ars
rebars	8	40	1983	2	rebars
rebops	10	3	1143	2	rebops
recall	8	38	1573	2	recall
recalls	9	26	1362	2	recalls
recane	8	30	2287	2	recane
recanes	9	32	2226	2	recanes
recant	8	32	2868	2	recant
recants	9	32	1709	2	recants
recast	8	34	2277	2	recast
recasts	9	34	1353	2	recasts
recces	10	6	1491	2	recces
recept	10	33	1908	2	recept
recepts	11	30	1027	2	recepts
recess	8	3	1426	2	recess
recipe	10	34	1489	2	recipe
recipes	11	33	1446	2	recipes
recits	8	36	2135	2	recits
recks	11	56	2513	2	rec_ks
reclads	10	4	999	2	reclads
reclasp	11	3	664	2	reclasp
reclasps	12	3	505	2	reclasps
recoals	9	42	1463	2	recoals
recoats	9	26	1664	2	recoats
recons	8	49	2299	2	recons
recopy	13	3	904	2	recopy
recoups	11	8	884	2	recoups
recs	6	57	3418	2	rec__s
rectos	8	57	1878	2	rectos
rectus	8	33	1463	2	rectus
recurs	8	33	1580	2	recurs
recuts	8	38	1737	2	recuts
redans	7	54	2102	2	redans
redcap	11	5	849	2	redcap_
redips	9	37	1384	2	redips
rehabs	11	3	902	2	rehabs
relapse	9	4	770	2	relapse
relays	9	43	1675	2	relays
remans	8	48	2300	2	remans
remap	9	54	1810	2	remap_
repass	8	41	1470	2	repass
repays	11	38	1397	2	repays
repps	9	51	1434	2	re_pps
reps	6	59	3795	2	re__ps
resaws	9	37	1351	2	resaws
resays	9	37	1415	2	resays
retags	7	34	1430	2	retags
retape	8	39	1768	2	retape
retapes	9	39	1742	2	retapes
revamps	14	3	399	2	revamps
rewraps	12	13	656	2	rewraps
toecaps	11	3	555	2	toecaps
uncaps	10	3	982	2	uncaps

Search took 3 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.330	541487.9
2	DLD Change Limit	82551	78	2.623	31472.0
3	Display Results	78	78	0.016	4875.0
	(SQL Overall)	178691	78	2.969	60185.6