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

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

86 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
dissolution	12	14	502	(None)
dissolutions	13	14	492	1	dissolutions
absolution	12	4	440	3	_absolution
desolation	11	3	1140	3	d_esolation
devolution	14	8	628	3	d_evolution
dilution	9	23	914	3	di___lution
disillusion	12	5	239	3	disillusion
dislocation	14	14	750	3	dislocation
disposition	14	4	668	3	disposition
disrelation	12	4	881	3	disrelation
dissection	13	15	861	3	diss_ection
dissention	11	18	807	3	diss_ention
dissipation	14	4	721	3	dissipation
dissociation	15	5	664	3	dissociation
dissolute	10	4	575	3	dissolut__e
dissolutely	15	6	233	3	dissolutely
distortion	11	4	669	3	disto_rtion
exsolution	17	4	376	3	_exsolution
insolation	10	4	1021	3	_insolation
involution	13	4	594	3	_involution
isolation	9	3	1164	3	_i_solation
nonsolution	11	5	474	3	nonsolution
resolution	10	9	773	3	_resolution
solution	8	8	959	3	___solution
absolutions	13	4	471	4	_absolutions
coevolution	16	5	422	4	coevolution
consolation	13	4	1098	4	consolation
convolution	16	4	512	4	convolution
demolition	13	7	698	4	d_emolition
desolations	12	3	1059	4	d_esolations
desorption	13	4	622	4	d_esorption
despoliation	15	4	671	4	despoliation
destitution	12	5	554	4	destitution
devolutions	15	10	626	4	d_evolutions
dilation	9	22	1546	4	di___lation
dilutions	10	24	858	4	di___lutions
diluvion	12	21	541	4	di___luvion
diminution	13	4	481	4	di_minution
discoloration	16	12	472	4	discoloration
disconsolation	17	6	341	4	dis~~con~~solation
discretion	13	4	752	4	di_scretion
disfunction	17	5	471	4	disfunction
disillusions	13	5	232	4	disillusions
disinflation	16	5	658	4	disinflation
disjunction	21	5	409	4	disjunction
dislocations	15	13	698	4	dislocations
displosion	13	18	449	4	di_splosion
dispositions	15	4	647	4	dispositions
disputation	14	11	674	4	disputation
disrelations	13	4	850	4	disrelations
disruption	13	13	573	4	di_sruption
dissections	14	19	826	4	diss_ections
dissension	11	13	572	4	diss_ension
dissentions	12	16	804	4	diss_entions
dissertation	13	6	609	4	dissertation
dissimilation	16	5	652	4	dissimilation
dissimulation	16	5	537	4	dissimulation
dissipations	15	4	653	4	dissipations
dissociations	16	5	601	4	dissociations
dissoluble	13	5	317	4	dissolu_ble
dissolving	15	4	511	4	dissol_ving
dissuasion	11	4	384	4	diss_uasion
distention	11	15	887	4	di_stention
distillation	13	4	773	4	distillation
distinction	14	4	732	4	distinction
distortions	12	4	661	4	disto_rtions
distraction	14	4	911	4	distraction
distribution	15	5	536	4	distribution
disunion	9	5	611	4	di_s__union
evolution	12	11	709	4	__evolution
exsolutions	18	4	401	4	_exsolutions
immolation	14	4	610	4	_immolation
insolations	11	4	918	4	_insolations
insulation	10	3	1166	4	_insulation
involutions	14	4	590	4	_involutions
irresolution	12	13	241	4	irresolution
isolations	10	3	1069	4	_i_solations
mislocation	15	12	641	4	mislocation
misposition	15	5	568	4	misposition
nonsolutions	12	5	417	4	nonsolutions
resolutions	11	11	779	4	_resolutions
revolution	13	11	756	4	_revolution
solation	8	9	1615	4	___solation
solutions	9	8	888	4	___solutions
violation	12	3	844	4	vi__olation
volution	11	9	860	4	___volution

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.406	440125.6
2	DLD Change Limit	148819	86	8.830	16853.8
3	Display Results	86	86	0.046	1869.6
	(SQL Overall)	178691	86	9.282	19251.3