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

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

78 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
smallish	13	4	657	(None)
saltish	10	3	1216	2	s_altish
smallest	10	3	940	2	smallest
smalls	8	45	1412	2	small_s_
squallish	21	4	340	2	squallish
stablish	13	4	834	2	stablish
tallish	10	33	1358	2	_tallish
baldish	13	3	950	3	_baldish
bullish	12	5	1119	3	_bullish
carlish	12	3	1276	3	_carlish
challis	12	46	1346	3	challis_
coalfish	16	3	549	3	coalfish
dealfish	15	4	550	3	dealfish
diallist	9	4	955	3	diallist
dollish	11	6	1009	3	_dollish
dullish	11	4	874	3	_dullish
embellish	16	4	342	3	embellish
establish	14	4	474	3	establish
fallfish	17	4	446	3	_fallfish
hellish	13	3	1072	3	_hellish
maddish	14	28	948	3	_maddish
maidish	13	23	955	3	_maidish
malaise	9	3	1267	3	_malaise
malling	10	36	2366	3	_malling
malls	7	62	3343	3	_mall_s_
mannish	12	17	1069	3	_mannish
marish	11	43	1905	3	_ma_rish
mawkish	19	3	582	3	_mawkish
mulish	11	3	1190	3	_m_ulish
palish	11	47	1827	3	_pa_lish
phallism	15	4	571	3	phallism
phallist	13	3	898	3	phallist
qualmish	22	4	401	3	qualmish
sailfish	14	4	605	3	sailfish
sallied	8	33	1695	3	s_allied
sallier	7	33	2042	3	s_allier
sallies	7	32	2781	3	s_allies
sallowish	15	4	494	3	s_allowish
salmis	8	5	1427	3	s_almis_
sawfish	16	3	768	3	s_awfish
scallion	10	4	679	3	scallion
scalls	8	42	1820	3	scall_s_
scampish	17	4	489	3	scampish
seallike	12	10	832	3	seallike
selfish	13	8	851	3	s_elfish
shellfish	18	4	322	3	shellfish
slavish	13	3	823	3	sla_vish
small	7	40	1626	3	small___
smallage	11	4	518	3	smallage
smaller	9	34	1033	3	small_er
smallness	11	7	451	3	smallness
smallpox	19	4	184	3	smallpox
smalltime	13	4	219	3	smalltime
smalti	8	41	1119	3	smalti__
smaltine	10	3	783	3	smaltine
smaltite	10	4	690	3	smaltite
smaltos	9	40	819	3	smaltos_
smalts	8	52	1489	3	sma_lts_
smash	10	48	1443	3	sma___sh
smellier	10	3	679	3	smellier
smelliest	11	3	660	3	smelliest
smelling	11	37	1272	3	smelling
smells	8	39	1474	3	smell_s_
snappish	15	4	523	3	snappish
spalling	11	32	1346	3	spalling
spalls	8	42	1734	3	spall_s_
sparkish	17	27	697	3	sparkish
stalling	9	51	1670	3	stalling
stallion	8	3	751	3	stallion
stalls	6	40	1993	3	stall_s_
standish	12	3	854	3	standish
starfish	14	3	808	3	starfish
stylish	13	19	744	3	s_tylish
swainish	14	4	475	3	swainish
swampish	18	4	417	3	swampish
swellfish	18	4	270	3	swellfish
tallis	6	33	1996	3	_tallis_
tallith	10	29	1306	3	_tallith

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	146162	0.423	422437.4
2	DLD Change Limit	146162	78	7.233	20207.7
3	Display Results	78	78	0.033	2363.6
	(SQL Overall)	178691	78	7.689	23239.8