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

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

96 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
convector	16	4	808	(None)
connector	13	4	792	1	connector
convectors	17	6	831	1	convectors
convertor	14	4	878	1	convertor
nonvector	14	4	579	1	nonvector
coinventor	15	6	297	2	coinventor
coinvestor	15	6	257	2	coinvestor
collector	13	4	639	2	collector
concoctor	12	4	632	2	concoctor
conductor	14	4	721	2	conductor
connecter	13	4	905	2	connecter
connectors	14	4	818	2	connectors
contactor	13	4	843	2	contactor
convect	14	31	1448	2	convect__
convected	17	3	878	2	convected
convection	17	4	1112	2	convection
convects	15	34	1099	2	convect_s
convenor	13	30	761	2	conve_nor
converter	14	3	1101	2	converter
convertors	15	4	913	2	convertors
conveyor	16	24	529	2	conve_yor
corrector	13	4	760	2	corrector
nonvectors	15	5	628	2	nonvectors
caveator	13	8	723	3	c_aveator
coactor	11	3	912	3	co__actor
cocreator	13	4	695	3	cocreator
codebtor	13	4	397	3	co_debtor
codirector	15	5	327	3	codirector
coexecutor	21	5	182	3	coexecutor
cofactor	15	4	575	3	co_factor
coinventors	16	5	294	3	coinventors
coinvestors	16	7	287	3	coinvestors
collectors	14	4	659	3	collectors
compactor	17	25	602	3	compactor
concenter	13	3	1221	3	concenter
concerto	12	33	1161	3	concerto_
concertos	13	27	1113	3	concertos
concocter	12	4	762	3	concocter
concoctors	13	4	640	3	concoctors
condemnor	14	4	359	3	condemnor
conductors	15	4	697	3	conductors
confect	14	36	1427	3	confect__
confected	17	3	907	3	confected
confection	17	4	1118	3	confection
confects	15	31	1087	3	confect_s
confessor	14	4	434	3	confessor
confetto	13	4	625	3	confetto_
conjecture	21	13	474	3	conjecture
connect	11	35	1574	3	connect__
connected	14	3	875	3	connected
connecters	14	4	801	3	connecters
connection	14	4	1053	3	connection
connects	12	30	1056	3	connect_s
consecrator	15	4	638	3	consecrator
consenter	11	3	1249	3	consenter
consultor	11	7	647	3	consultor
contactors	14	4	884	3	contactors
contemnor	13	4	464	3	contemnor
contester	11	3	1118	3	contester
contractor	14	4	907	3	contractor
convecting	18	3	1043	3	convecting
convections	18	4	1149	3	convections
convective	20	4	911	3	convective
convener	13	29	1316	3	conve_ner
convenors	14	27	763	3	conve_nors
convent	12	39	1941	3	convent__
convented	15	4	1075	3	convented
convention	15	4	1056	3	convention
convents	13	26	1460	3	convent_s
converser	14	3	809	3	converser
converso	13	3	642	3	converso_
conversos	14	4	689	3	conversos
convert	12	37	2147	3	convert__
converted	15	3	1156	3	converted
converters	15	3	963	3	converters
converts	13	32	1355	3	convert_s
conveyer	16	27	814	3	conve_yer
conveyors	17	23	552	3	conve_yors
convict	14	34	1098	3	convict__
convicted	17	4	631	3	convicted
conviction	17	4	818	3	conviction
convicts	15	33	771	3	convict_s
correcter	13	4	810	3	correcter
correctors	14	4	749	3	correctors
coveter	12	29	1206	3	co_ve_ter
infector	13	47	885	3	_infector
injector	17	23	693	3	_injector
inventor	11	29	815	3	_inventor
invertor	11	23	897	3	_invertor
investor	11	24	741	3	_investor
nonactor	10	4	777	3	non_actor
nondoctor	12	4	517	3	nondoctor
nonfactor	14	4	527	3	nonfactor
nonreactor	12	5	403	3	nonreactor
objector	19	4	380	3	_objector
vector	11	32	1206	3	___vector

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	148641	0.173	1032896.0
2	DLD Change Limit	148641	96	6.360	23371.2
3	Display Results	96	96	0.046	2087.0
	(SQL Overall)	178691	96	6.579	27160.8