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

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

69 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
figwort	14	4	822	(None)
figworts	15	4	468	1	figworts
fanwort	13	3	1073	2	fanwort
felwort	13	4	1057	2	felwort
mugwort	13	4	675	2	mugwort
ragwort	11	5	1073	2	ragwort
ribwort	12	4	899	2	ribwort
airport	9	5	1138	3	airport
awlwort	13	5	635	3	awlwort
bagworm	15	6	634	3	bagworm
bigfoot	13	5	599	3	bigfoot
bighorn	13	4	606	3	bighorn
bigot	8	48	2832	3	big_o_t
bistort	9	12	1652	3	bistort
diglot	8	30	1433	3	diglo_t
disport	10	10	1595	3	disport
distort	8	11	2033	3	distort
faggot	11	3	904	3	faggo_t
fagot	9	3	2340	3	fag_o_t
fanworts	14	4	610	3	fanworts
felworts	14	4	595	3	felworts
fight	12	40	2709	3	fig__ht
figment	13	7	974	3	figment
figure	10	25	883	3	fig_ure
filbert	12	4	1164	3	filbert
finfoot	13	4	717	3	finfoot
fiord	9	43	1334	3	fi__ord
firework	18	4	740	3	firework
fireworm	16	4	668	3	fireworm
fishworm	19	4	379	3	fishworm
fleawort	14	4	701	3	fleawort
foghorn	14	4	543	3	foghorn
fort	7	64	5644	3	f___ort
forworn	13	10	778	3	forworn
giglot	8	40	1313	3	giglo_t
gigot	7	40	2307	3	gig_o_t
ignore	7	26	906	3	_ignore
import	10	27	1375	3	_import
intort	6	4	1892	3	_intort
legwork	15	4	565	3	legwork
lugworm	13	4	489	3	lugworm
lungwort	12	4	549	3	lungwort
madwort	13	6	1136	3	madwort
milkwort	17	4	549	3	milkwort
missort	9	3	1465	3	missort
misword	13	3	841	3	misword
mugworts	14	4	344	3	mugworts
piefort	12	4	953	3	piefort
pigboat	12	4	782	3	pigboat
pignora	10	30	636	3	pignora
pigout	9	3	1461	3	pig_out
pilewort	13	8	912	3	pilewort
pinwork	16	10	724	3	pinwork
pinworm	14	6	717	3	pinworm
ragworts	12	12	580	3	ragworts
ribworts	13	4	509	3	ribworts
rigor	6	27	1405	3	rig_or_
rigors	7	28	1371	3	rig_ors
ringworm	14	4	466	3	ringworm
signor	7	35	1035	3	signor_
signora	8	34	850	3	signora
signore	8	32	909	3	signore
signori	8	34	789	3	signori
signors	8	34	1090	3	signors
signory	11	42	751	3	signory
tinwork	14	7	699	3	tinwork
vigor	9	26	1242	3	vig_or_
vigors	10	29	1148	3	vig_ors
wort	7	66	5475	3	___wort

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	134027	0.296	603685.8
2	DLD Change Limit	134027	69	7.063	18975.9
3	Display Results	69	69	0.016	4312.5
	(SQL Overall)	178691	69	7.375	24229.3