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

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

121 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
discussions	14	4	424	(None)
discussion	13	4	450	1	discussion_
discussing	14	4	598	2	discussi_ng
dismissions	14	5	400	2	dismissions
dispassions	14	5	388	2	dispassions
dissuasions	12	4	352	2	dissuasions
abscissions	15	5	240	3	abscissions
concussions	15	12	532	3	concussions
descensions	14	4	437	3	descensions
diffusions	17	4	373	3	diffu_sions
digressions	13	4	474	3	digressions
discretions	14	4	722	3	discretions
discussant	13	5	372	3	discuss_ant
discussants	14	5	247	3	discussants
discussers	13	23	519	3	discuss_ers
discusses	12	26	825	3	discuss__es
discussible	16	5	338	3	discussible
dismission	13	5	436	3	dismission_
dispassion	13	4	432	3	dispassion_
dispersions	14	4	645	3	dispersions
displosions	14	20	383	3	displosions
disruptions	14	12	568	3	disruptions
dissensions	12	17	557	3	dissensions
dissuasion	11	4	384	3	dissuasion_
distensions	12	14	627	3	distensions
disunions	10	5	597	3	dis_u_nions
divulsions	14	4	334	3	di_vulsions
incursions	12	4	483	3	_incursions
percussions	15	4	487	3	percussions
pincushions	18	5	168	3	pincushions
rescissions	13	4	459	3	rescissions
scissions	11	4	543	3	__scissions
abscission	14	5	252	4	abscission_
accessions	14	4	525	4	_accessions
ascensions	12	4	461	4	_ascensions
cessions	10	3	985	4	___cessions
concessions	15	12	810	4	concessions
concussion	14	15	557	4	concussion_
cushions	13	3	569	4	___cushions
decisions	12	4	838	4	d_ec_isions
decurions	12	4	602	4	d_ecu_rions
decussations	15	4	367	4	d_ecussations
delusions	10	3	705	4	d_elu_sions
demissions	13	4	566	4	d_emissions
depressions	14	4	731	4	depressions
descension	13	4	454	4	descension_
detrusions	11	4	421	4	detru_sions
dictations	13	8	970	4	di_ctations
dictions	11	18	1267	4	di_c__tions
diffusion	16	4	397	4	diffu_sion_
digestions	12	4	640	4	di_gestions
digression	12	4	466	4	digression_
dilutions	10	24	858	4	di_lu_tions
diluvions	13	22	444	4	di_lu_vions
dimensions	13	4	461	4	di_mensions
disbursing	14	4	537	4	disbursi_ng
discasing	13	3	943	4	disc_asi_ng
disclosing	14	4	661	4	disclosi_ng
discoursing	15	4	485	4	discoursi_ng
discretion	13	4	752	4	discretion_
discursive	16	4	409	4	discursi_ve
discuses	11	31	1286	4	discu_s__es
discuss	10	35	795	4	discu_s___s
discussable	16	5	355	4	discussable
discussed	13	25	676	4	discuss__ed
discusser	12	24	618	4	discuss__er
disfunctions	18	5	452	4	disfunctions
disguising	13	4	601	4	disguisi_ng
disgusting	13	4	596	4	disgusti_ng
disillusions	13	5	232	4	disillusions
disjunctions	22	5	407	4	disjunctions
dismissing	14	4	506	4	dismissi_ng
dispersion	13	4	686	4	dispersion_
displosion	13	18	449	4	displosion_
dispositions	15	4	647	4	dispositions
disputations	15	10	617	4	disputations
disquisitions	23	5	324	4	disquisitions
disruption	13	13	573	4	disruption_
dissections	14	19	826	4	dissections
disseisins	11	4	595	4	disseisi_ns
dissension	11	13	572	4	dissension_
dissentions	12	16	804	4	dissentions
distension	11	15	627	4	distension_
distentions	12	17	884	4	distentions
distortions	12	4	661	4	distortions
disunion	9	5	611	4	dis_u_nion_
disusing	10	3	900	4	dis_u_si_ng
diversions	14	4	653	4	di_versions
divisions	13	9	628	4	di__visions
divulsion	13	4	355	4	di_vulsion_
excursions	19	4	432	4	_excursions
fissions	11	3	803	4	fi___ssions
illusions	9	4	621	4	_illu_sions
impassions	14	4	484	4	_impassions
impulsions	14	4	360	4	_impulsions
incisions	11	4	735	4	_inc_isions
inclusions	12	7	565	4	_inclusions
incursion	11	4	522	4	_incursion_
infusions	12	4	614	4	_infu_sions
misassigns	13	5	241	4	mis_assigns
miscaptions	17	4	418	4	miscaptions
misprisions	15	5	315	4	misprisions
missions	10	3	1190	4	mi___ssions
misunions	11	5	453	4	mis_u_nions
obsessions	12	4	427	4	obs_essions
percussion	14	4	499	4	percussion_
pincushion	17	5	185	4	pincushion_
possessions	12	6	502	4	possessions
precessions	15	4	855	4	precessions
processions	15	4	815	4	processions
recessions	12	4	893	4	_recessions
recursions	12	4	540	4	_recursions
rediscussing	16	6	184	4	rediscussi_ng
rescission	12	4	486	4	rescission_
scansions	11	4	532	4	__scansions
scission	10	4	556	4	__scission_
scullions	11	5	468	4	__scullions
secessions	12	4	646	4	_secessions
sessions	8	3	972	4	__s_essions
suasions	8	3	878	4	__s_uasions
successions	15	5	397	4	successions

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	148819	0.423	422437.4
2	DLD Change Limit	148819	121	8.250	18038.7
3	Display Results	121	121	0.076	1592.1
	(SQL Overall)	178691	121	8.749	20424.2