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

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

80 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
complects	17	6	641	(None)
complect	16	5	901	1	complect_
collects	12	27	978	2	co_llects
compacts	16	36	890	2	comp_acts
compleat	14	7	1015	2	compleat_
complected	19	29	586	2	complected
complete	14	34	1205	2	comple_te
completes	15	32	1292	2	completes
complexes	22	30	810	2	complexes
complices	17	3	925	2	complices
complots	14	3	816	2	compl_ots
couplets	12	38	987	2	couple_ts
bomblets	14	3	602	3	bomble_ts
camlets	11	43	1462	3	cam_le_ts
caplets	11	49	1452	3	c_aple_ts
chaplets	15	5	688	3	chaple_ts
codirects	14	9	359	3	codirects
codpieces	16	4	380	3	codpieces
coeffects	19	4	246	3	coeffects
coerects	12	5	854	3	co_erects
coinfects	16	34	457	3	coinfects
collect	11	33	1459	3	co_llect_
collets	9	35	1790	3	co_lle_ts
comets	10	58	2358	3	com__e_ts
comments	14	29	1388	3	com_ments
compact	15	37	1221	3	comp_act_
comparts	14	42	1083	3	comp_arts
compeers	14	34	1001	3	comp_eers
compels	13	32	1088	3	comp_e_ls
compends	15	37	825	3	comp_ends
comperes	14	32	1797	3	comp_eres
compete	13	47	1655	3	comp_e_te
competes	14	41	1724	3	comp_etes
compilers	15	3	705	3	compile_rs
compiles	14	3	1198	3	compile__s
complains	15	4	919	3	complains
complaints	16	4	600	3	complaints
complecting	20	4	576	3	complecting
complements	19	4	818	3	complements
completed	16	28	1027	3	completed
completer	15	33	1041	3	completer
completers	16	29	832	3	completers
completest	16	29	787	3	completest
complex	20	3	724	3	comple__x
complexed	23	29	598	3	complexed
complexer	22	31	621	3	complexer
complexest	23	26	559	3	complexest
complexity	26	5	343	3	complexity
complexly	25	4	306	3	complexly
complicate	18	4	762	3	complicate
complicates	19	4	705	3	complicates
complice	16	3	933	3	complic_e
complicit	17	4	743	3	complicit
complicity	21	4	569	3	complicity
compliers	15	3	829	3	compliers
complies	14	3	1452	3	compl_ies
compliments	19	4	658	3	compliments
complines	15	3	1283	3	complines
complins	14	3	1311	3	compl_ins
complot	13	3	1068	3	compl_ot_
components	16	4	694	3	components
comports	14	34	1198	3	comp_orts
composts	14	42	1091	3	comp_osts
compress	14	3	905	3	compre_ss
compts	12	52	1665	3	comp___ts
confects	15	31	1087	3	co_nfects
conflicts	16	4	479	3	conflicts
connects	12	30	1056	3	co_nnects
convects	15	34	1099	3	co_nvects
copecks	17	4	587	3	co_p_ecks
coplots	11	5	1159	3	co_pl_ots
copylefts	19	4	197	3	copylefts
corrects	12	5	957	3	co_rrects
corslets	10	3	827	3	corsle_ts
couplers	12	33	1132	3	couple_rs
couples	11	53	1705	3	couple__s
couplet	11	47	1794	3	couple_t_
cromlechs	18	4	156	3	crom_lechs
omelets	9	3	833	3	_omele_ts
templets	12	22	614	3	temple_ts

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	148641	0.406	440125.6
2	DLD Change Limit	148641	80	7.953	18689.9
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	8.389	21300.6