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

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

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.

90 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
constructor	15	7	652	(None)
constrictor	15	9	612	1	constrictor
constructors	16	7	647	1	constructors
constrictors	16	7	601	2	constrictors
construct	13	5	871	2	construct__
constructed	16	4	625	2	constructed
construction	16	4	808	2	construction
constructs	14	5	705	2	construct_s
contractor	14	4	907	2	con_tractor
deconstructor	18	6	364	2	deconstructor
instructor	12	5	516	2	_instructor
obstructor	14	5	375	2	_obstructor
reconstructor	17	6	409	2	reconstructor
conductor	14	4	721	3	con__ductor
conservator	16	5	637	3	conservator
constrict	13	7	1162	3	constrict__
constricted	16	4	636	3	constricted
constriction	16	4	826	3	constriction
constricts	14	7	773	3	constrict_s
constructing	17	4	675	3	constructing
constructions	17	4	771	3	constructions
constructive	19	5	744	3	constructive
construer	11	4	691	3	constru__er
consultor	11	7	647	3	cons__ultor
contactor	13	4	843	3	con_t_actor
contractors	15	4	916	3	con_tractors
deconstructors	19	6	362	3	deconstructors
instructors	13	5	538	3	_instructors
obstructors	15	6	400	3	_obstructors
reconstructors	18	6	393	3	reconstructors
abstractor	14	4	438	4	_abstractor
castrator	11	4	764	4	c_astr_ator
codirector	15	5	327	4	co_director
concoctor	12	4	632	4	con__coctor
conductors	15	4	697	4	con__ductors
connector	13	4	792	4	con__nector
consecrator	15	4	638	4	consecrator
conservators	17	5	597	4	conservators
conservatory	20	5	475	4	conservatory
conspirator	15	5	565	4	conspirator
constricting	17	4	702	4	constricting
constrictions	17	4	778	4	constrictions
constrictive	19	5	662	4	constrictive
construable	15	5	478	4	construable
construal	11	4	679	4	constru__al
construals	12	4	521	4	constru_als
constructible	19	11	376	4	constructible
constructional	18	5	476	4	constructional
construe	10	4	905	4	constru___e
construed	12	4	731	4	constru__ed
construers	12	4	587	4	constru_ers
construes	11	4	1013	4	constru__es
construing	13	4	744	4	constru_ing
consulter	11	9	822	4	cons__ulter
consultors	12	8	640	4	cons__ultors
consummator	17	13	405	4	consummator
contactors	14	4	884	4	con_t_actors
continuator	13	8	601	4	continuator
contract	12	29	1563	4	con_tract__
contracted	15	4	982	4	con_tracted
contraction	15	4	1124	4	con_traction
contracts	13	22	1201	4	con_tract_s
contracture	15	7	662	4	con_tracture
contradictor	17	8	382	4	con_tradictor
contralto	11	4	709	4	con_tralto_
contraltos	12	4	676	4	con_traltos
contributor	15	15	396	4	con_tributor
convector	16	4	808	4	con__vector
convertor	14	4	878	4	conver__tor
corrector	13	4	760	4	co__rrector
corruptor	13	4	404	4	co__rruptor
deconstruct	16	5	414	4	deconstruct__
deconstructed	19	5	370	4	deconstructed
deconstruction	19	13	443	4	deconstruction
deconstructs	17	5	371	4	deconstruct_s
instruct	10	4	754	4	_instruct__
instructed	13	4	563	4	_instructed
instruction	13	13	794	4	_instruction
instructs	11	4	579	4	_instruct_s
nonstructural	15	7	367	4	nonstructural
nonstructured	16	6	344	4	nonstructured
obstruct	12	4	603	4	_obstruct__
obstructed	15	4	423	4	_obstructed
obstruction	15	13	554	4	_obstruction
obstructs	13	4	457	4	_obstruct_s
reconstruct	15	5	490	4	reconstruct__
reconstructed	18	5	426	4	reconstructed
reconstruction	18	9	477	4	reconstruction
reconstructs	16	5	424	4	reconstruct_s
unconstructed	18	5	392	4	unconstructed

Search took 10 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	148819	0.436	409841.7
2	DLD Change Limit	148819	90	9.046	16451.4
3	Display Results	90	90	0.046	1956.5
	(SQL Overall)	178691	90	9.528	18754.3