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

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

80 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
fermented	15	4	662	(None)
fermenter	14	9	754	1	fermenter
cemented	13	3	837	2	ce_mented
demented	12	3	1127	2	de_mented
ferment	12	3	1557	2	ferment__
fermenters	15	11	653	2	fermenters
fermentor	14	4	469	2	fermentor
ferments	13	3	1147	2	ferment_s
ferreted	12	3	633	2	ferre_ted
fomented	14	3	780	2	f_omented
garmented	13	4	588	2	garmented
permeated	14	3	937	2	permeated
rerented	9	25	1616	2	rer_ented
segmented	13	4	506	2	segmented
tormented	12	4	596	2	tormented
unfermented	17	4	386	2	unfermented
alimented	12	4	531	3	alimented
augmented	13	4	383	3	augmented
cementer	12	3	919	3	ce_menter
commented	16	12	961	3	commented
dermestid	13	4	353	3	dermestid
emended	11	32	960	3	_e_mended
erected	10	32	1399	3	_er_ected
ermined	10	4	1060	3	_ermin_ed
feinted	11	37	962	3	fe__inted
fermate	12	28	1300	3	ferm_ate_
fermenting	16	4	682	3	fermenting
fermentors	15	9	423	3	fermentors
ferreled	12	3	484	3	ferre_led
ferrelled	13	4	394	3	ferrelled
ferreter	11	3	654	3	ferre_ter
fervent	13	3	1006	3	fervent__
fervently	18	4	514	3	fervently
flehmened	18	4	177	3	flehmen_ed
fomenter	13	3	926	3	f_omenter
forested	12	3	1246	3	for_ested
forfeited	16	4	379	3	forfeited
forfended	17	4	374	3	forfended
formatted	15	4	488	3	formatted
fragmented	17	4	303	3	fragmented
frequented	23	4	342	3	frequented
fretted	11	34	1185	3	f_r_etted
friended	13	3	503	3	f_riended
fronted	11	40	1127	3	f_r_onted
furmenties	15	4	485	3	furmenties
furmenty	16	4	529	3	furment_y
germinated	14	4	656	3	germinated
helmeted	14	3	583	3	helme_ted
lamented	11	3	819	3	_lamented
margented	13	4	681	3	margented
oriented	9	3	748	3	_oriented
overmelted	16	4	690	3	overmelted
parented	11	9	1221	3	par_ented
pedimented	16	4	410	3	pedimented
perfected	17	3	664	3	perfected
permeate	12	3	1161	3	permeate_
permeates	13	3	1177	3	permeates
permitted	14	4	665	3	permitted
permuted	13	3	671	3	perm_uted
perpended	15	4	608	3	perpended
perverted	15	4	610	3	perverted
pigmented	15	4	406	3	pigmented
precented	14	3	1069	3	precented
presented	12	3	1163	3	presented
prevented	15	3	900	3	prevented
recemented	15	4	616	3	recemented
regimented	14	4	491	3	regimented
relented	9	26	1494	3	re_lented
remelted	11	3	1015	3	re_melted
remended	12	30	1039	3	re_mended
reminted	11	36	1508	3	re_minted
rented	7	44	2659	3	__r_ented
reoriented	11	4	534	3	reoriented
repented	11	26	1498	3	re_pented
resented	9	27	1696	3	re_sented
resmelted	12	3	604	3	resmelted
sedimented	14	4	404	3	sedimented
terminated	13	4	816	3	terminated
tormenter	11	4	670	3	tormenter
unrented	9	24	1392	3	unr_ented

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	148641	0.436	409841.7
2	DLD Change Limit	148641	80	7.503	19810.9
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	7.969	22423.3