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

Here are the results of your fuzzy-string dictionary search for “perceive” with Change Limit: [1] [2] [3] [4]

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
perceive	15	4	697	(None)
perceived	17	4	435	1	perceived
perceiver	16	4	455	1	perceiver
perceives	16	4	631	1	perceives
apperceive	19	5	327	2	apperceive
deceive	13	3	781	2	de_ceive
perceivers	17	4	389	2	perceivers
perceptive	19	4	680	2	perceptive
receive	12	3	973	2	re_ceive
apperceived	21	5	211	3	apperceived
apperceives	20	5	280	3	apperceives
archive	15	46	1048	3	_archive
berceuse	12	4	343	3	berceuse
bereave	12	5	835	3	ber_eave
coercive	15	4	587	3	coerc_ive
conceive	15	3	923	3	conceive
deceived	15	3	589	3	de_ceived
deceiver	14	3	623	3	de_ceiver
deceives	14	3	790	3	de_ceives
decretive	15	4	749	3	decretive
derisive	12	4	750	3	derisive
derive	10	38	1704	3	der__ive
erective	13	3	1183	3	_erective
erosive	10	3	919	3	_erosive
mercerise	13	5	641	3	mercerise
mercerize	22	4	617	3	mercerize
misperceive	20	14	239	3	~~mis~~perceive
narceine	10	4	675	3	narceine
operative	14	11	1055	3	operative
opercele	12	4	459	3	operce_le
orective	13	3	935	3	orective
pareve	11	46	1301	3	par_e_ve
peacetime	15	4	447	3	peacetime
pectize	20	25	991	3	pe_ctize
peeve	10	49	1525	3	pe__e_ve
pensive	12	26	1039	3	pe_nsive
percale	11	3	1409	3	perc_ale
percaline	13	4	1095	3	percaline
perceivable	20	5	340	3	perceiv~~abl~~e
perceiving	18	4	466	3	perceiving
percent	11	35	2060	3	perce_nt
percentile	14	4	741	3	percentile
percents	12	27	1337	3	percents
percept	13	31	1252	3	perce_pt
percepts	14	24	764	3	percepts
perching	16	37	1163	3	perching
percoid	12	3	1231	3	percoi_d
percoids	13	3	966	3	percoids
percussive	17	4	382	3	percussive
perdie	9	47	1851	3	per_di_e
pereia	8	52	1798	3	per_ei_a
pereion	9	3	1205	3	per_eion
perfective	20	4	719	3	perfective
perfusive	17	4	434	3	perfusive
perlite	9	3	1732	3	per_lite
permease	12	4	650	3	permease
permeate	12	3	1161	3	permeate
permeative	17	4	852	3	permeative
peroxide	18	4	818	3	peroxide
perspire	12	4	666	3	perspire
pervasive	17	4	448	3	pervasive
perverse	13	3	610	3	perverse
perversive	18	4	435	3	perversive
porcine	11	3	1284	3	porc_ine
precative	16	3	1257	3	precative
precede	12	3	965	3	prece_de
preceptive	19	4	776	3	preceptive
precipe	13	30	1212	3	prec_ipe
precise	11	35	1817	3	prec_ise
predive	13	5	1108	3	p_redive
preserve	13	10	880	3	preserve
reactive	13	3	1047	3	reactive
received	14	3	798	3	re_ceived
receiver	13	3	741	3	re_ceiver
receives	13	3	974	3	re_ceives
reive	8	55	2294	3	__r_eive
secretive	14	4	693	3	secretive
unperceived	19	5	297	3	unperceived

Search took 9 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	146162	0.423	422437.4
2	DLD Change Limit	146162	78	7.640	19131.2
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	8.093	22079.7