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

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

75 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
vacationist	16	5	590	(None)
vacationists	17	5	458	1	vacationists
vacationing	17	5	304	2	vacationing
vacations	14	19	1055	2	vacation_s_
creationist	13	7	923	3	creationist
educationist	15	5	526	3	educationist
fictionist	15	5	802	3	fic_tionist
salvationist	15	5	440	3	salvationist
vacation	13	19	1189	3	vacation___
vacationed	16	4	342	3	vacation_ed
vacationer	15	4	330	3	vacation_er
vacationers	16	5	248	3	vacationers
vocationalist	18	5	510	3	vocationalist
vocations	14	19	1142	3	vocation_s_
abortionist	13	5	616	4	abortionist
actinism	12	11	988	4	_ac_ti_nism
actions	9	42	1851	4	_ac_tion_s_
activist	13	10	948	4	_ac_ti_vist
adoptionist	14	5	496	4	adoptionist
alations	8	25	1889	4	_alation_s_
anatomist	11	11	926	4	_anat_omist
antagonist	11	10	690	4	_antagonist
aviations	12	3	1155	4	aviation_s_
avocations	15	16	868	4	avocation_s_
canonist	10	5	1353	4	__ca_nonist
cartoonist	12	5	716	4	ca_rtoonist
cationic	12	3	1001	4	__cationi_c
cations	9	45	2414	4	__cation_s_
coalitionist	14	8	550	4	coalitionist
creationism	15	7	646	4	creationism
creationists	14	7	662	4	creationists
deviationist	16	5	615	4	deviationist
educationists	16	5	434	4	educationists
elocutionist	14	5	509	4	elocutionist
evacuations	16	4	630	4	evacuation_s_
evocations	15	25	987	4	evocation_s_
evolutionist	15	12	681	4	evolutionist
factions	13	30	1306	4	fac_tion_s_
fictionists	16	5	599	4	fic_tionists
halations	12	3	1239	4	halation_s_
inflationist	15	5	529	4	inflationist
isolationist	12	5	588	4	isolationist
jactations	19	3	689	4	jactation_s_
lactations	12	3	942	4	lactation_s_
lavations	12	3	897	4	lavation_s_
laxations	16	3	762	4	laxation_s_
locations	11	25	1274	4	location_s_
macaronis	13	4	656	4	maca_ronis_
machinist	16	4	848	4	mac_hi_nist
magazinist	22	5	290	4	magazi_nist
natations	9	14	1249	4	natation_s_
operationist	14	5	794	4	operationist
pactions	12	26	1350	4	pac_tion_s_
partitionist	14	5	626	4	partitionist
placations	14	3	858	4	placation_s_
receptionist	16	5	640	4	receptionist
recreationist	15	5	574	4	recreationist
sacatons	10	3	897	4	sacat_on_s_
salvationism	17	6	311	4	salvationism
salvationists	16	5	356	4	salvationists
separationist	15	5	527	4	separationist
tactions	10	29	1242	4	tac_tion_s_
taxations	16	3	686	4	taxation_s_
vacating	14	3	1035	4	vacati_n__g
vacationland	18	6	81	4	vacationland
vallations	13	3	908	4	vallation_s_
valuations	13	4	878	4	valuation_s_
variations	13	3	1077	4	variation_s_
venations	12	3	1172	4	venation_s_
vexations	19	3	775	4	vexation_s_
vocation	13	23	1198	4	vocation___
vocational	15	4	695	4	vocation_al
vocationalism	20	5	441	4	vocationalism
vocationalists	19	6	408	4	vocationalists
zacatons	19	4	570	4	zacat_on_s_

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.313	570897.8
2	DLD Change Limit	148819	75	8.750	17007.9
3	Display Results	75	75	0.046	1630.4
	(SQL Overall)	178691	75	9.109	19617.0