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

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

76 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
foremost	13	4	858	(None)
foremast	13	4	861	1	foremast
forecast	13	4	976	2	forecast
forefoot	14	4	815	2	forefoot
foremasts	14	4	579	2	foremasts
forepast	13	4	804	2	forepast
forest	9	49	2674	2	fore__st
aftermost	14	4	490	3	aftermost
filemot	12	4	670	3	filemo_t
fireboat	13	4	909	3	fireboat
firepot	12	4	873	3	firepo_t
firepots	13	4	689	3	firepots
firmest	12	3	927	3	fir_mest
folkmoot	17	7	433	3	folkmoot
folkmot	16	7	568	3	folkmo_t
folkmots	17	8	360	3	folkmots
forams	11	51	1591	3	foram_s_
forcemeat	16	4	425	3	forcemeat
forebode	14	4	827	3	forebode
forebody	17	4	515	3	forebody
foreboom	15	4	613	3	foreboom
forecasts	14	4	580	3	forecasts
foreclose	14	4	462	3	foreclose
forecourt	14	4	575	3	forecourt
foredo	10	5	1082	3	foredo__
foredoes	12	3	1080	3	foredoes
foredone	12	4	973	3	foredone
foredoom	14	4	581	3	foredoom
forefeet	14	12	939	3	forefeet
forefelt	14	11	736	3	forefelt
forefront	15	4	649	3	forefront
forego	10	3	890	3	forego__
foregoer	12	3	725	3	foregoer
foregoes	12	3	952	3	foregoes
foregone	12	3	858	3	foregone
foregut	11	4	916	3	fore_gut
foreguts	12	4	556	3	foreguts
forehoof	17	4	660	3	forehoof
forelock	17	4	559	3	forelock
foreman	12	3	1236	3	forem_an
foremen	12	4	1292	3	forem_en
foremilk	17	4	437	3	foremilk
forenoon	11	4	682	3	forenoon
forepart	13	4	970	3	forepart
fores	8	58	4710	3	fore__s_
forests	10	41	1495	3	fore__sts
foretaste	12	9	586	3	foretaste
foretold	12	5	649	3	foretold
foretooth	15	4	388	3	foretooth
foretop	12	11	789	3	foreto_p
foretops	13	13	748	3	foretops
forewent	14	3	942	3	forewent
foreword	15	11	896	3	foreword
foreworn	14	10	886	3	foreworn
forgot	10	43	1813	3	for_go_t
forkiest	15	38	1230	3	forkiest
formant	12	34	1600	3	for_mant
format	11	30	2135	3	for_m_at
formats	12	31	1357	3	for_mats
formers	12	82	1795	3	formers_
formes	11	46	2371	3	for_mes_
formol	11	29	1033	3	for_mo_l
formols	12	29	941	3	for_mols
forms	10	53	2705	3	for_m_s_
forums	11	46	1184	3	forum_s_
freest	9	53	1828	3	f_re_est
frost	8	47	2783	3	f_r__ost
lowermost	14	4	304	3	lowermost
northmost	14	5	430	3	northmost
outmost	9	5	1121	3	_outmost
polemist	12	4	1236	3	polemist
premolt	11	3	1207	3	_premolt
sorest	6	50	2800	3	sore__st
topmost	11	4	817	3	to_pmost
toreros	7	3	1134	3	toreros_
totemist	10	4	903	3	totemist

Search took 9 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.436	409841.7
2	DLD Change Limit	146162	76	8.453	17291.1
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	8.919	20034.9