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

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

(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
complect	16	5	901	(None)
compleat	14	7	1015	1	compleat
complects	17	6	641	1	complects
collect	11	33	1459	2	co_llect
compact	15	37	1221	2	comp_act
complected	19	29	586	2	complected
complete	14	34	1205	2	complete
complex	20	3	724	2	comple_x
complice	16	3	933	2	complice
complicit	17	4	743	2	complicit
complot	13	3	1068	2	compl_ot
couplet	11	47	1794	2	couple_t
amplest	11	3	1233	3	_amplest
bomblet	13	4	1226	3	bomble_t
camlet	10	44	2658	3	cam_le_t
campiest	14	22	1213	3	campiest
caplet	10	42	2681	3	c_aple_t
chaplet	14	5	1225	3	chaple_t
codirect	13	10	629	3	codirect
codpiece	15	4	406	3	codpiece
coeffect	18	4	393	3	coeffect
coerect	11	9	1335	3	co_erect
coinfect	15	27	684	3	coinfect
collects	12	27	978	3	co_llects
collet	8	40	3036	3	co_lle_t
comeliest	13	4	1003	3	comeliest
comet	9	59	4607	3	com__e_t
comfiest	15	3	913	3	comfiest
comment	13	103	1770	3	com_ment
compacts	16	36	890	3	comp_acts
compart	13	40	1600	3	comp_art
comped	13	59	1987	3	comp_e_d
compeer	13	38	1155	3	comp_eer
compeers	14	34	1001	3	compeers
compel	12	44	1289	3	comp_e_l
compels	13	32	1088	3	comp_els
compend	14	40	1030	3	comp_end
compere	13	46	1662	3	comp_ere
compete	13	47	1655	3	comp_ete
competent	15	4	1125	3	competent
compile	13	3	1244	3	compile__
compiled	15	3	781	3	compile_d
compiler	14	3	837	3	compile_r
compilers	15	3	705	3	compilers
compiles	14	3	1198	3	compile_s
complacent	18	4	669	3	complacent
complain	14	4	875	3	complain
complaint	15	4	1024	3	complaint
complecting	20	4	574	3	complect~~ing~~
complement	18	5	1010	3	complement
completed	16	28	1026	3	completed
completer	15	33	1041	3	completer
completes	15	32	1292	3	completes
completest	16	29	787	3	completest
complexed	23	29	597	3	complexed
complexer	22	31	620	3	complexer
complexes	22	30	809	3	complexes
complexest	23	26	558	3	complexest
complexity	26	5	342	3	complexity
complexly	25	4	305	3	complexly
compliant	15	4	966	3	compliant
complicate	18	4	762	3	complicate
complices	17	3	925	3	complices
complicity	21	4	569	3	complicity
complied	15	3	967	3	complied
complier	14	3	1025	3	complier
compliers	15	3	829	3	compliers
complies	14	3	1452	3	complies
compliment	18	4	840	3	compliment
complin	13	3	1207	3	compl_in
compline	14	3	1355	3	compline
complins	14	3	1310	3	complins
complots	14	3	816	3	complots
comply	15	28	1038	3	compl__y
component	15	4	1108	3	component
comport	13	36	1684	3	comp_ort
compost	13	45	1535	3	comp_ost
compress	14	3	905	3	compress
compt	11	63	2822	3	comp___t
compted	14	38	1352	3	compte_d
confect	14	36	1427	3	co_nfect
conflict	15	4	775	3	conflict
connect	11	35	1574	3	co_nnect
convect	14	31	1448	3	co_nvect
coolest	9	3	1864	3	co_olest
copeck	16	3	694	3	co_p_eck
coplot	10	5	1827	3	co_pl_ot
copyleft	18	4	398	3	copyleft
corpulent	13	4	684	3	corpulent
correct	11	5	1398	3	co_rrect
corslet	9	3	1806	3	corsle_t
couple	10	44	1596	3	couple__
coupled	12	43	1267	3	couple_d
coupler	11	47	1301	3	couple_r
couplers	12	33	1131	3	couplers
couples	11	53	1705	3	couple_s
couplets	12	38	987	3	couplets
covalent	13	4	922	3	covalent
cromlech	17	4	205	3	crom_lech
nonelect	10	4	1028	3	nonelect
omelet	8	3	1707	3	_omele_t
simplest	12	23	1022	3	simplest
templet	11	27	1200	3	temple_t

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	146162	0.156	1145455.1
2	DLD Change Limit	146162	103	6.750	21653.6
3	Display Results	103	103	0.030	3433.3
	(SQL Overall)	178691	103	6.936	25762.8