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

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

152 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
dissipation	14	4	721	(None)
dissipations	15	4	653	1	dissipations
dissipating	15	5	631	2	dissipating
dissipative	17	5	381	2	dissipative
destination	12	4	1384	3	destination
dislocation	14	14	750	3	dislocation
disputation	14	11	674	3	disputation
disrelation	12	4	881	3	disrelation
disruption	13	13	573	3	disrup_tion
dissection	13	15	861	3	diss_ection
dissemination	16	5	579	3	dissemination
dissention	11	18	807	3	diss_ention
dissertation	13	6	609	3	dissertation
dissimilation	16	5	652	3	dissimilation
dissimulation	16	5	537	3	dissimulation
dissipate	12	4	703	3	dissipat__e
dissipated	14	4	605	3	dissipat_ed
dissipater	13	4	487	3	dissipat_er
dissipaters	14	5	347	3	dissipaters
dissipates	13	4	655	3	dissipat_es
dissociation	15	5	664	3	dissociation
dissolution	12	14	502	3	dissolution
dissuasion	11	4	384	3	diss_uasion
distillation	13	4	773	3	distillation
distinction	14	4	732	3	distinction
divination	14	13	923	3	di_vination
miscitation	15	4	777	3	miscitation
passivation	16	10	474	3	passivation
visitation	13	4	859	3	vi_sitation
aestivation	14	4	792	4	aestivation
aspiration	12	4	999	4	_aspiration
assignation	12	4	437	4	_assignation
cassation	11	9	791	4	cass__ation
castigation	14	4	797	4	castigation
cessation	11	7	685	4	cess__ation
ciliation	11	11	1249	4	ci_li_ation
constipation	16	4	856	4	constipation
cuspidation	16	4	349	4	cuspidation
deamination	14	4	1154	4	deamination
decimation	15	4	1162	4	d_ecimation
declination	14	4	1187	4	declination
dedication	14	3	1196	4	d_edication
deification	17	4	1166	4	deification
deionization	22	4	988	4	deionization
deoxidation	20	4	595	4	deoxidation
depilation	13	3	1203	4	d_epilation
deprivation	17	8	877	4	deprivation
derivation	14	7	1278	4	d_erivation
desalination	13	4	1113	4	desalination
description	16	4	537	4	descrip_tion
desecration	14	4	1007	4	desecration
desiccation	16	4	638	4	desiccation
designation	13	4	748	4	designation
desolation	11	3	1140	4	d_esolation
desorption	13	4	622	4	desorp_tion
desperation	14	5	1011	4	desperation
destinations	13	4	1266	4	destinations
destitution	12	5	554	4	destitution
deviation	13	3	1239	4	d_evi_ation
dictation	12	8	1056	4	di__ctation
dieselization	23	5	605	4	dieselization
digitization	23	4	768	4	digitization
dilapidation	16	5	336	4	dilapidation
dilatation	11	4	739	4	di_latation
dilation	9	22	1546	4	d___ilation
dimerization	24	4	908	4	dimerization
diminution	13	4	481	4	di_minution
disclamation	17	5	424	4	disclamation
discretion	13	4	752	4	di_scretion
disfunction	17	5	471	4	disfunction
disinflation	16	5	658	4	disinflation
disjunction	21	5	409	4	disjunction
dislocations	15	13	698	4	dislocations
dismission	13	5	436	4	dismi_ssion
dispassion	13	4	432	4	di_s_passion
dispensation	15	5	560	4	dispensation
disposition	14	4	668	4	disposition
disputations	15	10	617	4	disputations
disquisition	22	5	333	4	disquisition
disrelations	13	4	850	4	disrelations
disruptions	14	12	568	4	disrup_tions
disseating	12	11	1178	4	diss_eating
dissections	14	19	826	4	diss_ections
disseminations	17	5	508	4	disseminations
dissension	11	13	572	4	diss_ension
dissentions	12	16	804	4	diss_entions
dissertations	14	6	589	4	dissertations
dissimilations	17	5	586	4	dissimilations
dissimulations	17	5	490	4	dissimulations
dissipatedly	19	7	196	4	dissipatedly
dissociations	16	5	601	4	dissociations
dissolutions	13	14	492	4	dissolutions
dissuasions	12	4	352	4	diss_uasions
distention	11	15	887	4	di_stention
distillations	14	4	694	4	distillations
distinctions	15	5	732	4	distinctions
distortion	11	4	669	4	di_stortion
distraction	14	4	911	4	distraction
distribution	15	5	536	4	distribution
divagation	15	10	437	4	di_vagation
divarication	18	5	590	4	divarication
divinations	15	12	841	4	di_vinations
domination	13	7	1237	4	d_omination
dubitation	13	7	733	4	d_ubitation
duplication	16	4	729	4	duplication
edification	17	4	935	4	edi_fication
estimation	12	4	1084	4	_estimation
estivation	13	4	981	4	_estivation
fasciation	15	4	683	4	fasci_ation
fascination	16	4	679	4	fascination
filiation	12	11	1024	4	fi_li_ation
fustigation	15	4	521	4	fustigation
hesitation	13	4	963	4	_hesitation
idolization	21	4	776	4	idolization
imitation	11	5	1085	4	_i_mitation
incitation	12	3	1222	4	_incitation
indication	13	3	1203	4	_indication
infixation	20	4	753	4	_infixation
insinuation	11	13	726	4	_insinuation
insolation	10	4	1021	4	_insolation
inspiration	13	4	837	4	inspiration
instigation	12	4	924	4	instigation
insulation	10	3	1166	4	_insulation
intimation	12	4	1304	4	_intimation
invitation	13	4	1002	4	_invitation
iodination	11	5	998	4	_iodination
ionization	19	4	1127	4	_ionization
irrigation	11	4	780	4	_irrigation
irritation	10	4	897	4	_irritation
isolation	9	3	1164	4	_i_solation
limitation	12	4	915	4	li_mitation
lionization	20	4	788	4	lionization
liquidation	21	4	318	4	liquidation
litigation	11	4	817	4	li_tigation
mastication	15	6	1029	4	mastication
miscaption	16	4	476	4	miscap_tion
miscitations	16	4	705	4	miscitations
miscreation	15	4	771	4	miscreation
misestimation	17	9	472	4	misestimation
mislocation	15	12	641	4	mislocation
mitigation	13	4	864	4	mi_tigation
passivations	17	6	443	4	passivations
pixilation	19	4	591	4	pi_xilation
respiration	13	5	1119	4	respiration
rustication	13	4	922	4	rustication
sibilation	12	12	877	4	si_bilation
suspiration	13	4	654	4	suspiration
titivation	13	4	703	4	ti_tivation
usurpation	12	4	381	4	_usurpation
vindication	17	4	635	4	vindication
visitations	14	4	767	4	vi_sitations
vitiation	12	3	956	4	vi_ti_ation

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.173	1032896.0
2	DLD Change Limit	148819	152	8.843	16829.0
3	Display Results	152	152	0.093	1634.4
	(SQL Overall)	178691	152	9.109	19617.0