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

Here are the results of your fuzzy-string dictionary search for “tunicates” with Change Limit: [1] [2] [3] [4]

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.

77 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
tunicates	11	26	874	(None)
tunicate	10	33	1004	1	tunicate_
tunicated	12	25	749	1	tunicated
sonicates	11	4	1038	2	sonicates
suricates	11	3	1174	2	suricates
truncates	11	4	584	2	trun_cates
tunicae	9	32	814	2	tunica_e_
tunicles	10	21	713	2	tunic_les
abdicates	14	4	815	3	abdicates
animates	10	13	1642	3	_animates
auspicates	14	4	491	3	auspicates
bunkmates	17	4	367	3	bunkmates
busticates	14	5	661	3	busticates
dedicates	13	3	1169	3	dedicates
delicates	12	3	1431	3	delicates
dunites	8	3	1359	3	duni__tes
duplicates	15	4	663	3	duplicates
enunciates	12	4	513	3	enunciates
fornicates	15	4	584	3	fornicates
fumigates	15	4	557	3	fumigates
funicles	13	24	683	3	funic_les
furcates	13	3	988	3	fu_rcates
gunites	8	3	1312	3	guni__tes
indicates	12	3	1258	3	indicates
jubilates	18	4	584	3	jubilates
juniorates	17	4	358	3	juniorates
loricates	11	3	1012	3	loricates
lubricates	14	4	605	3	lubricates
medicates	14	3	1211	3	medicates
muriates	10	3	1208	3	muri_ates
muricate	12	3	1111	3	muricate_
muricated	14	4	824	3	muricated
musicales	13	4	670	3	musicales
mutilates	11	3	1095	3	mutilates
nictates	10	3	959	3	__nictates
nidates	8	3	1189	3	__nidates
pumicites	15	4	562	3	pumicites
radicates	12	4	1207	3	radicates
rubricates	14	4	589	3	rubricates
ruinates	8	3	1188	3	ru_inates
ruminates	11	4	1019	3	ruminates
runagates	10	4	433	3	runagates
rusticates	12	4	805	3	rusticates
sanitates	9	6	1173	3	sanitates
silicates	11	3	1152	3	silicates
sonicate	10	3	1093	3	sonicate_
sonicated	12	4	845	3	sonicated
supinates	11	3	955	3	supinates
suricate	10	3	1261	3	suricate_
syndicates	16	4	447	3	syndicates
tannates	8	19	1195	3	tan_nates
teniases	8	3	862	3	teni_ases
tinplates	11	4	777	3	tinplates
titivates	12	4	643	3	titivates
tonicities	12	4	1036	3	tonicities
truncate	10	4	628	3	trun_cate_
truncated	12	4	458	3	trun_cated
tubulates	11	4	723	3	tubulates
tungstates	11	4	268	3	tungstates
tunica	8	37	981	3	tunica___
tunicle	9	30	803	3	tunic_le_
tunics	8	38	1126	3	tunic___s
tunnages	9	19	590	3	tun_nages
turbinates	12	4	577	3	turbinates
uncages	10	32	1377	3	_un_cages
uncakes	13	30	1274	3	_un_cakes
uncases	9	35	1655	3	_un_cases
uncrates	10	3	1456	3	_uncrates
unifaces	13	4	639	3	_unifaces
unitages	9	3	827	3	_unitages
unites	6	50	2485	3	_uni__tes
unstates	8	13	1499	3	_unstates
urinates	8	3	1413	3	_urinates
urticates	11	4	889	3	urticates
vesicates	14	11	903	3	vesicates
vindicates	16	4	609	3	vindicates
zincates	19	3	774	3	zin_cates

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	148641	0.406	440125.6
2	DLD Change Limit	148641	77	6.126	24264.0
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	6.562	27231.2