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

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

134 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
constraints	13	4	620	(None)
constrains	12	4	972	1	constrain_s
constraint	12	4	1113	1	constraint_
constants	11	4	1091	2	const_a_nts
constrain	11	4	933	2	constrain__
constrained	14	4	535	2	constrained
constricts	14	7	773	2	constr_icts
unconstraints	15	6	191	2	unconstraints
conscripts	16	4	459	3	conscr_ipts
consonants	12	4	648	3	consona_nts
constant	10	5	1559	3	const_a_nt_
constraining	15	5	454	3	constraining
constrict	13	7	1162	3	constr_ict_
constringe	13	4	585	3	constr_inge
constringes	14	4	504	3	constr_inges
constructs	14	5	705	3	constr_ucts
construing	13	4	744	3	construin_g
contains	10	3	1653	3	con_t_ain_s
contracts	13	22	1201	3	con_tra_cts
contradicts	16	5	458	3	con_tradicts
contrails	11	4	1054	3	con_trai_ls
contrasts	11	22	1104	3	con_tra_sts
distraints	11	6	687	3	_distraints
restraints	10	5	660	3	_restraints
unconstraint	14	6	356	3	unconstraint_
bowstrings	16	17	322	4	bowstr_ings
cantraips	13	25	527	4	can_trai_ps
centralists	13	4	814	4	cen_tralists
centrings	12	22	760	4	cen_tr_ings
centrists	11	4	1023	4	cen_tr_ists
coastings	12	35	786	4	coast__ings
coastlands	13	4	331	4	coastla_nds
coastlines	12	12	533	4	coast_lines
coistrils	11	4	642	4	coistr_i_ls
colorants	11	4	986	4	co_lora_nts
complaints	16	4	600	4	co_mplaints
concertinas	15	10	755	4	concertinas
concertinos	15	15	812	4	concertinos
concurrents	15	5	456	4	concurrents
conferments	18	4	832	4	conferments
confidants	16	4	481	4	confida_nts
conformists	18	5	418	4	conformists
confronts	14	4	706	4	con_fr_onts
congrats	11	3	1143	4	con_gra__ts
conjugants	20	4	336	4	conjuga_nts
conscribes	16	4	519	4	conscr_ibes
conscript	15	4	712	4	conscr_ipt_
consents	10	27	1589	4	cons___ents
consequents	22	7	446	4	consequents
conserving	16	3	976	4	conservin_g
consists	10	3	1059	4	cons___ists
consonant	11	4	1016	4	consona_nt_
consorting	13	4	1074	4	consortin_g
consortiums	15	6	284	4	consortiums
consorts	10	15	1234	4	consor___ts
constables	14	4	673	4	const_ables
constancy	16	4	602	4	const_a_ncy
constantan	12	5	395	4	const_a_ntan
constantans	13	5	343	4	const_a_ntans
constantly	15	4	519	4	const_a_ntly
constatives	16	4	693	4	constatives
constituents	14	8	335	4	constituents
constrainedly	19	6	157	4	constrainedly
constricted	16	4	636	4	constr_icted
constrictor	15	9	612	4	constr_ictor
constrictors	16	7	601	4	constr_ictors
constringed	15	4	359	4	constr_inged
construals	12	4	522	4	constr_uals
construct	13	5	871	4	constr_uct_
construers	12	4	587	4	constr_uers
construes	11	4	1013	4	constr__ues
consultants	13	5	468	4	consultants
contacts	12	32	1521	4	con_t_a_cts
contain	9	3	1583	4	con_t_ain__
contained	12	3	1089	4	con_t_ained
container	11	3	1107	4	con_t_ainer
containers	12	4	990	4	con_t_ainers
contents	10	40	1821	4	con_t__ents
contestants	13	5	680	4	contest_a_nts
continents	12	4	956	4	con_tinents
contrabands	16	5	298	4	con_trabands
contrabass	14	5	321	4	con_trabass
contract	12	29	1563	4	con_tra_ct_
contradict	15	5	678	4	con_tradict_
contrail	10	4	1098	4	con_trai__l
contralti	11	4	774	4	con_tra_lti
contralto	11	4	709	4	con_tra_lto
contraltos	12	4	676	4	con_traltos
contrarians	13	4	635	4	con_trarians
contraries	12	7	1193	4	con_traries
contrariety	16	5	463	4	con_trariety
contrariness	14	5	548	4	con_trariness
contrarious	13	5	473	4	con_trarious
contras	9	30	1562	4	con_tra___s
contrast	10	26	1478	4	con_tra_st_
contrasty	14	21	719	4	con_tra_sty
contravenes	16	5	563	4	con_travenes
contrite	10	3	1854	4	con_tr_i_te
contrives	14	3	1170	4	con_tr_ives
cormorants	14	4	534	4	cormora_nts
coscripts	15	4	377	4	co_scr_ipts
cosecants	13	4	653	4	co_seca_nts
courants	10	3	1080	4	co__ura_nts
coxswains	21	4	246	4	coxs_wain_s
distrains	10	4	1133	4	_distrain_s
distraint	10	11	1290	4	_distraint_
entrains	8	3	1296	4	_en_train_s
entrants	8	3	1175	4	_en_tra_nts
eyestrains	13	4	356	4	eyestrain_s
instants	8	9	1015	4	_inst_a_nts
insurants	9	4	765	4	_insura_nts
intrants	8	3	1286	4	_in_tra_nts
ministrants	13	5	385	4	ministra_nts
mistrains	11	5	1135	4	_mistrain_s
monetarists	13	5	561	4	monetarists
monotints	11	4	750	4	monot__ints
monstrance	14	4	523	4	monstra_nce
monstrances	15	4	501	4	monstrances
nonstudents	12	5	291	4	nonstudents
obstruents	12	5	332	4	_obstruents
oestrins	8	3	1267	4	_oestr_in_s
outpaints	11	4	528	4	_o_utpaints
penetrants	12	4	527	4	penetra_nts
portraits	11	4	680	4	po_rtrai_ts
remonstrants	14	7	353	4	remonstra_nts
restrains	9	3	1162	4	_restrain_s
restraint	9	4	1275	4	_restraint_
sonorants	9	4	708	4	son_ora_nts
strains	7	42	1815	4	___strain_s
straits	7	49	1632	4	___strai_ts
unconstrained	16	6	248	4	unconstrained
unrestraints	12	5	207	4	unrestraints
unstrained	11	4	637	4	_unstrained
unstrings	10	4	601	4	_unstr_ings

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.420	425454.8
2	DLD Change Limit	148819	134	9.093	16366.3
3	Display Results	134	134	0.063	2127.0
	(SQL Overall)	178691	134	9.576	18660.3