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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

120 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
construction	16	4	808	(None)
constriction	16	4	826	1	constriction
constructions	17	4	771	1	constructions
constrictions	17	4	778	2	constrictions
constructing	17	4	675	2	constructing
constructional	18	5	476	2	constructional
constructive	19	5	744	2	constructive
constructor	15	7	652	2	construct_or
contraction	15	4	1124	2	con_traction
deconstruction	19	13	443	2	deconstruction
instruction	13	13	794	2	_instruction
obstruction	15	13	554	2	_obstruction
reconstruction	18	9	477	2	reconstruction
conduction	15	4	996	3	con__duction
conscription	18	5	533	3	conscription
consecution	15	4	731	3	consecu_tion
conservation	17	4	940	3	conservation
consternation	15	10	636	3	consternation
constipation	16	4	856	3	constipation
constitution	14	5	526	3	constitution
constricting	17	4	702	3	constricting
constrictive	19	5	662	3	constrictive
constrictor	15	9	612	3	constrict_or
construct	13	5	871	3	construct___
constructed	16	4	625	3	construct_ed
constructible	19	11	376	3	constructible
constructionist	19	8	403	3	construction~~ist~~
constructors	16	7	647	3	constructors
constructs	14	5	705	3	construct__s
contractions	16	4	1040	3	con_tractions
contraption	15	4	810	3	con_traption
contrition	12	4	1142	3	con_tr_ition
deconstructions	20	12	436	3	deconstructions
destruction	14	4	695	3	_destruction
instructions	14	13	782	3	_instructions
menstruation	14	5	522	3	menstruation
misconstruction	21	6	270	3	~~mis~~construction
nonconstruction	19	8	327	3	~~non~~construction
obstructions	16	15	552	3	_obstructions
reconstructions	19	12	474	3	reconstructions
abstraction	15	4	588	4	_abstraction
castration	12	4	1080	4	c_astr_ation
codirection	16	4	474	4	co_direction
concoction	13	4	823	4	con__coction
concretion	14	4	929	4	con_cr_etion
conductions	16	4	966	4	con__ductions
confection	17	4	1118	4	con__fection
confirmation	19	4	618	4	confirmation
confliction	18	4	523	4	con_fliction
conformation	19	4	732	4	conformation
conjunction	22	4	562	4	con_junction
conjuration	20	4	951	4	conjur_ation
connection	14	4	1053	4	con__nection
conscriptions	19	5	500	4	conscriptions
consecration	16	4	978	4	consecration
consecutions	16	4	705	4	consecu_tions
conservations	18	4	909	4	conservations
consignation	15	13	631	4	consignation
consociation	16	4	819	4	consociation
consolation	13	4	1098	4	cons_olation
conspiration	16	4	838	4	conspiration
constellation	15	5	480	4	constellation
consternations	16	11	604	4	consternations
constipations	17	4	768	4	constipations
constitutions	15	5	486	4	constitutions
constrain	11	4	933	4	constr__ai_n
constrict	13	7	1162	4	constrict___
constricted	16	4	636	4	constrict_ed
constrictors	16	7	601	4	constrictors
constricts	14	7	773	4	constrict__s
constructively	24	6	384	4	constructively
constructivism	23	21	368	4	constructivism
constructivist	21	21	419	4	constructivist
construing	13	4	744	4	constru__ing
consultation	14	4	747	4	consultation
consummation	18	5	529	4	consummation
consumption	17	4	542	4	cons_umption
contention	12	4	1222	4	con_t_ention
continuation	14	4	819	4	continuation
contortion	12	4	866	4	con_t_ortion
contraception	19	5	375	4	con_traception
contractile	15	4	735	4	con_tractile
contracting	16	6	1047	4	con_tracting
contractional	17	5	606	4	con_tractional
contractive	18	4	952	4	con_tractive
contractor	14	4	907	4	con_tract_or
contradiction	18	5	456	4	con_tradiction
contraptions	16	4	764	4	con_traptions
contribution	16	5	509	4	con_tribution
contritions	13	4	1091	4	con_tr_itions
contusion	11	4	706	4	con_t_u_sion
conurbation	15	4	746	4	con_urbation
convection	17	4	1112	4	con__vection
conversation	17	4	780	4	conversation
conviction	17	4	818	4	con__viction
convolution	16	4	512	4	convolu_tion
coproduction	19	5	474	4	coproduction
correction	14	4	881	4	co__rrection
corruption	14	5	537	4	co__rruption
counteraction	17	5	538	4	counteraction
deconstructing	20	11	390	4	deconstructing
deconstructive	22	12	410	4	deconstructive
deconstructor	18	6	364	4	deconstruct_or
destructions	15	4	726	4	_destructions
distraction	14	4	912	4	_distraction
instructing	14	4	629	4	_instructing
instructional	15	5	509	4	_instructional
instructive	16	5	648	4	_instructive
instructor	12	5	516	4	_instruct_or
menstruations	15	8	505	4	menstruations
nonsolution	11	5	474	4	nonsolu_tion
obstructing	16	4	457	4	_obstructing
obstructive	18	5	461	4	_obstructive
obstructor	14	5	375	4	_obstruct_or
reconstructing	19	7	443	4	reconstructing
reconstructive	21	12	446	4	reconstructive
reconstructor	17	6	409	4	reconstruct_or
restriction	13	4	936	4	_restriction
striction	11	4	898	4	___striction
unconstructive	21	10	421	4	unconstructive

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	124790	0.390	458182.1
2	DLD Change Limit	124790	120	8.030	15540.5
3	Display Results	120	120	0.080	1500.0
	(SQL Overall)	178691	120	8.500	21022.5