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

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

79 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
semifit	12	4	997	(None)
semimat	11	4	1291	2	semimat
semitist	10	4	1332	2	semitist
befit	10	52	2266	3	be__fit
bemist	10	52	1696	3	bemi_st
bemixt	17	45	1036	3	bemi_xt
benefit	12	4	807	3	benefit
comfit	13	31	1242	3	com_fit
deficit	13	3	968	3	deficit
deific	12	3	731	3	de_ific
delimit	10	3	1173	3	delimit
demerit	10	3	1499	3	demerit
demit	8	48	3230	3	dem__it
elicit	8	4	1720	3	_elicit
emit	6	54	3842	3	_em__it
feminie	12	17	993	3	feminie
feminist	13	19	1133	3	feminist
feminity	16	4	755	3	feminity
misfit	11	28	1383	3	__misfit
refit	8	42	3006	3	re__fit
remint	8	53	2998	3	remi_nt
remit	7	57	3722	3	rem__it
remixt	15	50	1485	3	remi_xt
resift	9	40	1772	3	resif_t
revisit	10	3	1137	3	revisit
sealift	10	3	1279	3	sealif_t
seamiest	10	27	1542	3	seamiest
sedilia	8	4	724	3	sedilia
seif	7	56	3873	3	se_if__
seifs	8	50	1933	3	se_if_s
seisin	6	37	1512	3	se_isin
seizin	15	36	1085	3	se_izin
sematic	11	17	1688	3	sematic
sememic	13	3	650	3	sememic
semi	6	51	2722	3	sem__i_
semiarid	11	4	779	3	semiarid
semidry	13	4	520	3	semidry
semifinal	14	4	470	3	semifinal
semifitted	16	5	285	3	semifitted
semifluid	15	5	249	3	semifluid
semihigh	17	4	347	3	semihigh
semilog	10	4	600	3	semilog
semimatt	12	5	831	3	semimatt
semimild	13	4	411	3	semimild
semimoist	13	4	561	3	semimoist
semimute	12	4	551	3	semimute
semina	8	9	1557	3	semi_na
seminal	9	12	1341	3	seminal
seminar	9	7	976	3	seminar
semiosis	10	5	987	3	semiosis
semiotic	12	7	1063	3	semiotic
semipro	11	4	425	3	semipro
semiraw	12	4	605	3	semiraw
semis	7	46	2353	3	sem__is
semises	9	39	1655	3	semises
semisoft	13	4	579	3	semisoft
semitists	11	4	818	3	semitists
semiwild	14	4	371	3	semiwild
senility	11	3	968	3	senility
seniti	6	43	1722	3	seniti_
sennit	6	31	1792	3	se_nnit
sericin	9	3	1284	3	sericin
serif	8	41	3213	3	serif__
serifed	11	8	1146	3	serifed
serifs	9	40	1705	3	serif_s
sexiest	14	21	1222	3	sexiest
sexist	13	30	1348	3	sexi_st
shift	11	42	2514	3	s_hif_t
shrift	12	4	1354	3	shrif_t
sift	7	107	4066	3	s__if_t
simioid	10	4	799	3	simioid
smit	6	51	3841	3	s_m__it
soffit	12	3	788	3	s_offit
solicit	9	3	1574	3	solicit
somitic	11	15	1263	3	somitic
specific	17	4	470	3	specific
spirit	8	35	1992	3	s_pirit
summit	10	3	1154	3	sum_mit
swift	11	68	1805	3	s_wif_t

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	134027	0.390	458182.1
2	DLD Change Limit	134027	79	6.500	20619.5
3	Display Results	79	79	0.016	4937.5
	(SQL Overall)	178691	79	6.906	25874.7