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

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

128 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
deliberation	15	4	636	(None)
deliberations	16	4	553	1	deliberations
deliberating	16	4	512	2	deliberating
deliberative	18	5	405	2	deliberative
delineation	12	4	776	2	deline_ation
desideration	14	5	639	2	desideration
liberation	12	6	999	2	__liberation
alliteration	12	8	516	3	alliteration
calibration	15	4	599	3	calib_ration
celebration	15	4	646	3	celeb_ration
deaeration	11	3	1301	3	de__aeration
deceleration	15	4	717	3	deceleration
degeneration	14	4	728	3	degeneration
delegation	12	3	888	3	del__egation
deliberate	13	4	712	3	deliberat__e
deliberated	15	4	563	3	deliberat_ed
deliberately	18	5	243	3	deliberately
deliberates	14	4	679	3	deliberat_es
delimitation	15	9	726	3	delimitation
delineations	13	4	676	3	deline_ations
denigration	13	4	846	3	deni_gration
desiderations	15	4	567	3	desiderations
desperation	14	5	1011	3	de_speration
deuteration	12	4	910	3	de_uteration
elaboration	13	4	574	3	_elaboration
liberations	13	5	894	3	__liberations
libration	11	15	1016	3	__lib_ration
literation	10	5	1141	3	__literation
melioration	13	6	818	3	meli_oration
obliteration	14	5	389	3	obliteration
reiteration	11	4	1216	3	re_iteration
adulteration	13	5	366	4	adul_teration
alienation	10	4	879	4	_ali_enation
alliterations	13	8	455	4	alliterations
alteration	10	6	1290	4	_al_teration
amelioration	14	6	400	4	ameli_oration
calibrations	16	4	515	4	calib_rations
celebrations	16	4	574	4	celeb_rations
cerebration	15	4	792	4	cereb_ration
deaerations	12	3	1167	4	de__aerations
debarkation	18	4	424	4	de__barkation
debilitation	15	4	778	4	debilitation
decelerations	16	4	642	4	decelerations
decerebration	18	8	419	4	decerebration
decimation	15	4	1162	4	deci__mation
declaration	14	4	783	4	de_claration
declination	14	4	1187	4	decli__nation
decoration	13	3	1442	4	de__coration
dedication	14	3	1196	4	dedi__cation
defecation	16	7	980	4	de__fecation
defibrination	19	5	386	4	defibrination
deflagration	17	7	347	4	deflagration
defloration	15	4	726	4	de_floration
degenerations	15	4	635	4	degenerations
dehydration	19	5	406	4	de_hydration
deification	17	4	1166	4	de_ification
delamination	15	4	885	4	delamination
delation	9	23	1808	4	del____ation
delectation	14	4	855	4	del_ectation
delegations	13	4	803	4	del__egations
deletion	9	20	1197	4	del__e__tion
deliberatively	23	7	201	4	deliberatively
delimitations	16	7	663	4	delimitations
delineating	13	4	637	4	deline_ating
delineative	15	5	466	4	deline_ative
delineator	11	7	417	4	deline_at_or
denaturation	13	4	588	4	denaturation
denegation	12	4	941	4	de__negation
denervation	15	6	794	4	de__nervation
denigrations	14	4	735	4	deni_grations
depilation	13	3	1203	4	depi__lation
deprecation	16	4	896	4	de_precation
depredation	15	4	692	4	de_predation
derivation	14	7	1278	4	deri__vation
desecration	14	4	1007	4	de_secration
desertion	10	4	1020	4	de__ser_tion
desiccation	16	4	638	4	desi_ccation
desiderating	15	4	469	4	desiderating
desiderative	17	5	368	4	desiderative
designation	13	4	748	4	desi_gnation
desperations	15	5	952	4	de_sperations
deuterations	13	4	808	4	de_uterations
deviation	13	3	1239	4	devi___ation
elaborations	14	4	492	4	_elaborations
elevation	12	3	923	4	_el__evation
elicitation	13	4	753	4	_elicitation
elimination	13	4	853	4	_elimination
emigration	13	22	821	4	_emi_gration
enumeration	13	10	591	4	_enumeration
evisceration	17	7	300	4	_evisceration
exoneration	18	4	765	4	_exoneration
federation	14	4	957	4	fe__deration
felicitation	17	4	510	4	felicitation
generation	11	3	1242	4	ge__neration
hebetation	15	5	709	4	he__betation
hibernation	16	4	409	4	__hibernation
incineration	14	4	629	4	incineration
iteration	9	5	1503	4	___iteration
itineration	11	5	632	4	_itineration
laceration	12	4	957	4	__laceration
libation	10	24	1136	4	__lib__ation
liberating	13	4	925	4	__liberating
liberator	11	4	706	4	__liberat_or
librations	12	14	906	4	__lib_rations
lineation	9	3	1076	4	__line_ation
literations	11	6	1058	4	__literations
meliorations	14	6	675	4	meli_orations
obliterations	15	5	345	4	obliterations
postliberation	18	9	205	4	postliberation
prelibation	15	12	866	4	prelib__ation
proliferation	18	5	303	4	proliferation
recalibration	17	5	443	4	recalib_ration
recuperation	16	5	672	4	recuperation
refrigeration	17	6	415	4	refrigeration
regeneration	13	4	819	4	regeneration
registration	13	4	753	4	registration
reiterations	12	4	1087	4	re_iterations
relegation	11	6	1002	4	rel__egation
remigration	14	22	891	4	remi_gration
remuneration	14	4	693	4	remuneration
reoperation	13	4	1090	4	re_operation
reverberation	18	9	388	4	reverberation
toleration	10	4	896	4	tol__eration
ulceration	12	4	726	4	_ul_ceration
veneration	13	4	1234	4	ve__neration
verbigeration	19	5	286	4	verbigeration
vibration	14	13	820	4	__vib_ration
vociferation	20	5	318	4	vociferation

Search took 8 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	124790	0.153	1167915.0
2	DLD Change Limit	124790	128	7.423	16811.3
3	Display Results	128	128	0.110	1163.6
	(SQL Overall)	178691	128	7.686	23248.9