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

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

70 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
discernment	16	11	612	(None)
discernments	17	8	519	1	discernments
concernment	17	6	621	3	concernment
descendent	14	4	628	3	desce_ndent
disbarment	15	4	665	3	disbar_ment
discerned	13	4	786	3	discern_e_d
discerner	12	4	694	3	discern_e_r
discerners	13	4	570	3	discern_ers
discerning	14	4	786	3	discern_ing
discontent	13	4	1025	3	disc_ontent
disownment	16	11	583	3	dis_ownment
disportment	16	5	665	3	disportment
dissepiment	16	5	430	3	dissepiment
dizenment	21	4	583	3	di_ze_nment
internment	12	4	1225	3	_internment
ascendent	12	4	594	4	_asce_ndent
cerement	12	3	1513	4	___cerement
concernments	18	6	524	4	concernments
decrement	14	4	1105	4	d_ec_rement
deferment	15	12	1030	4	d_efer_ment
descendant	14	5	406	4	desce_ndant
descendents	15	5	414	4	desce_ndents
designment	14	4	605	4	des_ignment
determent	12	13	1290	4	d_eter_ment
different	16	4	618	4	differ__ent
diriment	11	4	1074	4	di___riment
disablement	16	5	597	4	disablement
disagreement	16	5	431	4	disagreement
disarmament	16	5	495	4	disarmament
disbandment	17	5	422	4	disbandment
disbarments	16	5	493	4	disbar_ments
disburdenment	19	6	271	4	disburdenment
disbursement	17	5	445	4	disbursement
discern	10	3	849	4	discer___n_
discernable	16	5	445	4	discernable
discernible	16	5	336	4	discernible
discernibly	19	5	273	4	discernibly
discerns	11	3	816	4	discer___ns
discommend	18	5	361	4	disc_ommend
disconcert	15	4	826	4	disc_oncert
disconcertment	21	6	300	4	dis~~con~~certment
disconnect	15	5	587	4	disc_onnect
discontents	14	4	755	4	disc_ontents
discordant	14	4	542	4	discor_dant
discreet	11	4	1318	4	disc_r__eet
discreetest	14	5	391	4	discreetest
discrepant	15	5	424	4	disc_repant
disheartenment	20	20	290	4	disheartenment
disinterment	15	6	587	4	disinter_ment
dislodgment	16	9	372	4	dislodgment
disorient	10	4	1252	4	dis_or_ient
disownments	17	11	490	4	dis_ownments
dispersant	13	4	635	4	disper_sant
disportments	17	5	535	4	disportments
dissentient	12	5	695	4	dissentient
dissepiments	17	5	346	4	dissepiments
disseverment	18	14	361	4	disseverment
divergent	14	4	736	4	di_ver_gent
divestment	16	14	632	4	di_vestment
dizenments	22	4	497	4	di_ze_nments
enserfment	15	4	524	4	ens_erfment
escarpment	16	4	409	4	_escarpment
fishermen	17	4	343	4	fisher_men_
government	16	4	564	4	_government
increment	13	4	1168	4	_inc_rement
interment	11	4	1922	4	_inter_ment
internments	13	5	1028	4	_internments
inurnment	11	4	672	4	_i_nurnment
misgovernment	21	6	200	4	misgovernment
wilderment	16	5	370	4	wilder_ment

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.423	422437.4
2	DLD Change Limit	148819	70	9.203	16170.7
3	Display Results	70	70	0.046	1521.7
	(SQL Overall)	178691	70	9.672	18475.1