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

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

74 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
constants	11	4	1091	(None)
constant	10	5	1559	1	constant_
consents	10	27	1589	2	cons_ents
consonants	12	4	648	2	consonants
constancy	16	4	602	2	constancy
constantan	12	5	395	2	constantan
constantans	13	5	343	2	constantans
constantly	15	4	519	2	constantly
constraints	13	4	620	2	constraints
consultants	13	5	468	2	consultants
contacts	12	32	1521	2	con_tacts
contents	10	40	1821	2	con_tents
contestants	13	5	680	2	contestants
instants	8	9	1015	2	_instants
cabstands	14	5	373	3	cabstands
capstans	12	5	724	3	capstan_s
castanets	11	4	633	3	c_astanets
coastings	12	35	786	3	coastings
coastlands	13	4	331	3	coastlands
colorants	11	4	986	3	colorants
combatants	16	5	344	3	combatants
concents	12	25	1660	3	con_cents
confidants	16	4	481	3	confidants
confronts	14	4	706	3	confronts
congrats	11	3	1143	3	congra_ts
conjugants	20	4	336	3	conjugants
conodonts	12	4	606	3	conodonts
consent	9	37	2311	3	cons_ent_
consigns	11	3	753	3	consign_s
consists	10	3	1059	3	cons_ists
consonant	11	4	1016	3	consonant_
consorts	10	15	1234	3	cons_orts
constable	13	3	1100	3	constable
constables	14	4	673	3	constables
constancies	15	4	664	3	constancies
constrains	12	4	972	3	constrains
constraint	12	4	1113	3	constraint_
constricts	14	7	773	3	constricts
constructs	14	5	705	3	constructs
construes	11	4	1013	3	construes
consultant	12	4	670	3	consultant_
consults	10	21	998	3	cons_ults
contact	11	440	2068	3	con_tact_
contains	10	3	1653	3	con_tains
contends	11	28	1057	3	con_tends
content	9	43	2615	3	con_tent_
contestant	12	6	993	3	contestant_
contests	10	34	1338	3	con_tests
contexts	17	37	865	3	con_texts
contorts	10	11	1264	3	con_torts
contracts	13	22	1201	3	contracts
contrasts	11	22	1104	3	contrasts
convents	13	26	1460	3	con_vents
coolants	10	3	994	3	co_olants
cornstalks	16	4	308	3	cornstalks
corybants	16	4	443	3	corybants
cosecants	13	4	653	3	cosecants
costards	11	35	1079	3	co_stards
costars	9	42	1801	3	co_sta_rs
costate	9	40	1927	3	co_sta_te
cotans	8	13	1792	3	co__tan_s
cotenants	11	4	728	3	cotenants
courants	10	3	1080	3	co_urants
covenants	14	4	589	3	covenants
croissants	12	5	264	3	croissants
fondants	12	4	620	3	fon_dants
inconstant	12	5	619	3	inconstant_
instant	7	8	1535	3	_instant_
monotints	11	4	750	3	monotints
montanes	10	11	1452	3	mon_tanes
nonmutants	12	5	427	3	nonmutants
octants	9	12	873	3	_o_ctants
sonants	7	5	1123	3	son__ants
sonorants	9	4	708	3	sonorants

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	148641	0.440	406115.9
2	DLD Change Limit	148641	74	7.733	19221.6
3	Display Results	74	74	0.046	1608.7
	(SQL Overall)	178691	74	8.219	21741.2