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

Here are the results of your fuzzy-string dictionary search for “foamers” with Change Limit: [1] [2] [3]

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
foamers	12	38	1210	(None)
flamers	12	46	1636	1	flamers
foamer	11	47	1431	1	foamer_
formers	12	82	1795	1	formers
framers	12	51	1382	1	framers
roamers	9	37	1346	1	roamers
blamers	11	53	1421	2	blamers
boaters	9	34	1924	2	boaters
boomers	11	41	1591	2	boomers
coalers	9	44	1935	2	coalers
coaters	9	35	2579	2	coaters
coaxers	16	43	1108	2	coaxers
comers	10	53	2808	2	co_mers
defoamers	15	28	525	2	defoamers
dormers	10	43	1392	2	dormers
facers	11	55	1944	2	f_acers
faders	10	51	1746	2	f_aders
fakers	13	42	1953	2	f_akers
fames	10	57	3592	2	f_ame_s
farers	9	59	2405	2	f_arers
farmers	12	43	1526	2	farmers
fearers	10	48	1527	2	fearers
filmers	12	42	1129	2	filmers
firmers	12	47	1144	2	firmers
flakers	14	36	1327	2	flakers
flamens	12	46	1106	2	flamens
flamer	11	49	1912	2	flamer_
flames	11	47	2369	2	flame_s
flayers	13	39	1203	2	flayers
floaters	11	27	1151	2	floaters
foamed	12	60	1440	2	foame_d
foamier	12	33	900	2	foamier_
foamless	13	19	584	2	foamless
foams	10	50	1795	2	foam__s
fodders	12	40	1075	2	fodders
foggers	12	41	1201	2	foggers
folders	11	35	1439	2	folders
footers	10	46	1833	2	footers
foragers	12	34	963	2	foragers
foramens	13	3	782	2	foramens
forayers	14	27	727	2	forayers
forcers	12	42	1571	2	forcers
forgers	11	52	1818	2	forgers
forkers	14	46	1578	2	forkers
former	11	42	2140	2	former_
formes	11	46	2371	2	forme_s
fosters	10	42	2010	2	fosters
fowlers	13	34	1120	2	fowlers
foyers	12	54	1313	2	fo_yers
framer	11	48	1744	2	framer_
frames	11	51	1986	2	frame_s
fraters	10	35	1721	2	fraters
fumers	11	36	1338	2	f_umers
gamers	9	44	2083	2	_gamers
gomers	9	41	1688	2	go_mers
hoaxers	17	32	713	2	hoaxers
homers	11	48	2197	2	ho_mers
loaders	8	34	1343	2	loaders
loafers	10	34	946	2	loafers
loaners	7	39	1362	2	loaners
moaners	9	28	1355	2	moaners
namers	8	45	1733	2	_namers
oaters	6	50	2979	2	_oaters
omers	7	69	2319	2	_o_mers
ormers	8	43	1614	2	_ormers
reamers	9	42	2108	2	reamers
roamer	8	47	1516	2	roamer_
roarers	7	38	1274	2	roarers
roomers	9	54	1641	2	roomers
seamers	9	47	1943	2	seamers
soakers	11	41	1495	2	soakers
soapers	9	37	1592	2	soapers
soarers	7	41	1809	2	soarers
tamers	8	42	2403	2	_tamers
vomers	11	56	1494	2	vo_mers
wormers	12	40	1257	2	wormers

Search took 6 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	107671	0.126	1418182.5
2	DLD Change Limit	107671	76	4.593	23442.4
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	4.749	37627.1