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

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

67 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
obliteration	14	5	389	(None)
obliterations	15	5	345	1	obliterations
alliteration	12	8	516	2	alliteration
literation	10	5	1141	2	__literation
obliterating	15	5	339	2	obliterating
obliterative	17	5	305	2	obliterative
obliterator	13	5	278	2	obliterat_or
alliterations	13	8	455	3	alliterations
alteration	10	6	1290	3	_al_teration
deliberation	15	4	636	3	deliberation
iteration	9	5	1503	3	___iteration
liberation	12	6	999	3	__liberation
literations	11	6	1058	3	__literations
obligation	13	4	678	3	obli__gation
obliterate	12	4	507	3	obliterat__e
obliterated	14	5	382	3	obliterat_ed
obliterates	13	4	512	3	obliterat_es
obliterators	14	5	260	3	obliterators
obturation	12	9	714	3	ob__turation
reiteration	11	4	1216	3	_reiteration
adulteration	13	5	366	4	adulteration
alienation	10	4	879	4	_ali_enation
alliterating	13	5	427	4	alliterating
alliterative	15	5	387	4	alliterative
alterations	11	5	1166	4	_al_terations
altercation	13	4	701	4	_al_tercation
alternation	11	4	762	4	_al_ternation
arbitration	13	4	647	4	arbit_ration
botheration	16	5	465	4	_botheration
calibration	15	4	599	4	cali_bration
commiseration	19	6	404	4	commiseration
consideration	16	5	552	4	consideration
deliberations	16	4	553	4	deliberations
delineation	12	4	776	4	deline_ation
desideration	14	5	639	4	desideration
deuteration	12	4	910	4	_deuteration
exenteration	19	5	529	4	exenteration
filtration	13	4	643	4	fil_t_ration
incineration	14	4	629	4	incineration
iterations	10	4	1382	4	___iterations
itineration	11	5	632	4	_itineration
laceration	12	4	957	4	__laceration
liberations	13	5	894	4	__liberations
libration	11	15	1016	4	__li_bration
lineation	9	3	1076	4	__line_ation
literati	8	12	1080	4	__literati__
literatim	11	12	718	4	__literati_m
literator	9	4	868	4	__literat_or
litigation	11	4	817	4	__litigation
melioration	13	6	818	4	meli_oration
nitration	9	3	1344	4	__nit_ration
oblation	10	3	986	4	obl____ation
obligations	14	4	614	4	obli__gations
obscuration	15	4	440	4	ob_scuration
observation	16	6	506	4	ob__servation
obturations	13	11	642	4	ob__turations
obviation	14	4	609	4	obvi___ation
operation	11	3	1400	4	o___peration
postliberation	18	9	205	4	postliberation
proliferation	18	5	303	4	proliferation
reiterations	12	4	1087	4	_reiterations
scatteration	14	5	292	4	scatteration
titration	9	3	1054	4	__tit_ration
toleration	10	4	896	4	tol__eration
trituration	11	4	665	4	_trituration
ulceration	12	4	726	4	_ul_ceration
vociferation	20	5	318	4	vociferation

Search took 7 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.393	454684.5
2	DLD Change Limit	124790	67	6.513	19160.1
3	Display Results	67	67	0.046	1456.5
	(SQL Overall)	178691	67	6.952	25703.5