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

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

90 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
illumination	14	5	516	(None)
illuminations	15	5	444	1	illuminations
illuminati	12	5	399	2	illuminati__
illuminating	15	5	392	2	illuminating
illuminative	17	6	324	2	illuminative
illuminator	13	5	386	2	illuminat_or
illuviation	14	5	357	2	illuvi_ation
calumniation	16	6	399	3	calumniation
columniation	16	6	542	3	columniation
culmination	15	5	764	3	cul_mination
delamination	15	4	885	3	delamination
elimination	13	4	853	3	_elimination
fulmination	16	5	588	3	ful_mination
hallucination	18	12	283	3	hallucination
illuminate	12	4	568	3	illuminat__e
illuminated	14	5	443	3	illuminat_ed
illuminates	13	4	508	3	illuminat_es
illuminators	14	5	327	3	illuminators
illustration	12	5	351	3	illustration
illuviations	15	5	305	3	illuvi_ations
insemination	14	4	699	3	insemination
lamination	12	3	1122	3	__lamination
rumination	12	4	1083	3	__rumination
abomination	15	4	748	4	_abomination
agglutination	15	11	265	4	agglutination
alleviation	14	5	465	4	allevi_ation
bromination	15	4	781	4	_bromination
calcination	15	4	890	4	cal_cination
calumniations	17	6	348	4	calumniations
chlorination	17	5	624	4	chlorination
claudication	17	5	332	4	claudication
columniations	17	6	479	4	columniations
commination	17	11	1164	4	_commination
crimination	15	4	941	4	_crimination
culminations	16	4	653	4	cul_minations
deamination	14	4	1154	4	_deamination
delaminations	16	4	794	4	delaminations
delimitation	15	9	726	4	delimitation
denomination	15	11	883	4	denomination
dissemination	16	5	579	4	dissemination
domination	13	7	1237	4	__domination
eliminations	14	4	761	4	_eliminations
elucidation	14	4	501	4	_elucidation
eluviation	13	7	661	4	_eluvi_ation
examination	20	5	845	4	_examination
fluorination	15	9	471	4	fluorination
fulminations	17	4	503	4	ful_minations
fumigation	16	4	562	4	__fumigation
gemination	13	14	1066	4	__gemination
germination	14	14	897	4	_germination
hallucinations	19	11	252	4	hallucinations
illation	8	3	1194	4	ill____ation
illuminable	15	5	281	4	illumina_ble
illuminance	15	5	281	4	illumina_nce
illuminances	16	5	247	4	illuminances
illuminant	12	5	399	4	illumina__nt
illuminants	13	5	290	4	illumina_nts
illuminatingly	20	9	125	4	illuminatingly
illumining	13	4	350	4	illumin__ing
illuminism	14	5	368	4	illumin__ism
illuminist	12	5	485	4	illumin__ist
illustrations	13	5	315	4	illustrations
illuviating	15	5	294	4	illuvi_ating
imagination	14	4	719	4	i_magination
imitation	11	5	1085	4	i___mitation
immunization	25	11	591	4	immunization
inclination	13	4	973	4	i_nclination
incrimination	17	14	565	4	incrimination
infuriation	14	4	824	4	infuri_ation
inhumation	15	6	705	4	inhum__ation
inseminations	15	4	624	4	inseminations
intimidation	15	4	736	4	intimidation
invagination	16	4	564	4	invagination
iodination	11	5	998	4	i__odination
itemization	22	4	834	4	i_temization
laminations	13	3	980	4	__laminations
limitation	12	4	915	4	__limitation
liquidation	21	4	318	4	liqu_idation
lunation	8	3	1192	4	__lu__nation
multination	13	4	897	4	mul_tination
nomination	12	7	1210	4	__nomination
pollination	13	4	801	4	pol_lination
renomination	14	9	918	4	renomination
ruination	9	3	1127	4	__ru_ination
ruminations	13	4	939	4	__ruminations
solmization	22	4	732	4	sol_mization
supination	12	4	988	4	__supination
termination	13	13	1116	4	_termination
unilluminating	17	6	123	4	unilluminating
urination	9	3	1217	4	___urination

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.390	458182.1
2	DLD Change Limit	124790	90	6.063	20582.2
3	Display Results	90	90	0.063	1428.6
	(SQL Overall)	178691	90	6.516	27423.4