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

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

48 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
collector	13	4	639	(None)
collectors	14	4	659	1	collectors
collator	10	3	1037	2	coll_ator
collect	11	33	1459	2	collect__
collected	14	4	797	2	collected
collection	14	4	820	2	collection
collects	12	27	978	2	collect_s
connector	13	4	792	2	connector
convector	16	4	808	2	convector
corrector	13	4	760	2	corrector
coactor	11	3	912	3	co__actor
cocreator	13	4	696	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
colectomy	18	5	488	3	co_lectomy
colessor	10	4	523	3	co_lessor
collators	11	4	1034	3	coll_ators
collecting	15	4	828	3	collecting
collections	15	4	793	3	collections
collective	17	4	712	3	collective
colleger	11	22	793	3	colle_ger
collet	8	40	3036	3	colle_t__
colleted	11	30	1166	3	colle_ted
collets	9	35	1790	3	colle_t_s
collimator	14	9	484	3	collimator
compactor	17	25	602	3	compactor
concoctor	12	4	632	3	concoctor
conductor	14	4	721	3	conductor
connecter	13	4	905	3	connecter
connectors	14	4	818	3	connectors
contactor	13	4	843	3	contactor
convectors	17	6	831	3	convectors
convertor	14	4	878	3	convertor
correcter	13	4	810	3	correcter
correctors	14	4	749	3	correctors
deflector	15	5	506	3	deflector
elector	9	33	1325	3	__elector
inflector	14	6	535	3	inflector
lector	8	35	1498	3	___lector
neglector	12	5	343	3	neglector
noncollector	16	7	286	3	~~non~~collector
nonvector	14	4	579	3	nonvector
objector	19	4	380	3	_objector
prelector	13	4	809	3	prelector
reflector	14	4	573	3	reflector
selector	10	4	861	3	_selector

Search took 8 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.440	406115.9
2	DLD Change Limit	148641	48	7.123	20867.8
3	Display Results	48	48	0.033	1454.5
	(SQL Overall)	178691	48	7.596	23524.4