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

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

83 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
gammoner	13	4	515	(None)
gammoned	14	4	499	1	gammoned
gammoners	14	4	456	1	gammoners
almoner	9	4	938	2	_almoner
commoner	14	27	1063	2	commoner
gammer	11	123	1833	2	gamm__er
gammier	12	37	1119	2	gamm_ier
gammon	11	3	890	2	gammon__
gammons	12	3	797	2	gammon_s
summoner	12	4	553	2	summoner
almner	8	57	1072	3	_alm_ner
almoners	10	6	813	3	_almoners
ambones	11	3	1268	3	_ambones
ammeter	11	4	839	3	_ammeter
ammine	10	3	1449	3	_ammine_
ammines	11	3	1267	3	_ammines
ammonal	11	3	702	3	_ammonal
ammonia	11	4	869	3	_ammonia
ammonic	13	4	916	3	_ammonic
ammono	10	4	737	3	_ammon_o
armorer	9	25	991	3	_armorer
atoner	6	48	1719	3	_a_toner
commoners	15	33	978	3	commoners
communer	14	34	930	3	communer
daemones	11	20	916	3	daemones
daimones	11	20	880	3	daimones
dammer	11	43	1793	3	damm__er
damner	9	52	1343	3	da_m_ner
dampener	13	3	553	3	dampener
falconer	13	4	604	3	falconer
gainer	7	41	1749	3	ga__iner
galloper	11	13	719	3	galloper
gambier	12	47	1197	3	ga_mbier
gambler	12	36	1268	3	ga_mbler
gamboge	13	3	558	3	gamboge_
gamboges	14	3	565	3	gamboges
gamboled	14	3	587	3	gamboled
gamer	8	49	2894	3	ga_m__er
gamester	11	3	732	3	gamester
gamier	9	36	1793	3	ga_m_ier
gamine	9	46	2015	3	ga_mine_
gamines	10	36	1846	3	ga_mines
gammed	12	42	1616	3	gamm__ed
gammers	12	32	1456	3	gamm__ers
gamming	13	31	1262	3	gammin_g
gammoning	15	4	506	3	gammoning
gaoler	7	39	1357	3	ga__oler
gardener	10	3	710	3	gardener
garner	7	39	1700	3	ga__rner
garroter	9	5	657	3	garroter
gemmier	12	33	738	3	gemm_ier
goner	6	60	2516	3	g___oner
gummer	11	46	1545	3	gumm__er
gummier	12	34	947	3	gumm_ier
gummose	12	3	533	3	gummose_
gummoses	13	4	474	3	gummoses
hambone	14	3	931	3	hambone_
hamboned	16	3	700	3	hamboned
hambones	15	3	967	3	hambones
hammer	13	81	2003	3	hamm__er
hammerer	15	27	814	3	hammerer
hammier	14	35	1065	3	hamm_ier
jammer	17	40	1413	3	jamm__er
jammier	18	40	802	3	jamm_ier
jawboner	20	13	336	3	jawboner
lampooner	13	4	336	3	lampooner
mammer	9	42	1886	3	mamm__er
mammon	9	3	964	3	mammon__
mammons	10	4	851	3	mammon_s
mooner	8	53	1783	3	__mooner
pardoner	11	18	944	3	pardoner
rammer	10	35	1965	3	ramm__er
rammier	11	28	1102	3	ramm_ier
ratooner	8	8	700	3	ratooner
summoned	13	4	572	3	summoned
summoners	13	4	473	3	summoners
tamponed	13	3	602	3	tamponed
waggoner	13	4	342	3	waggoner
wagoner	11	3	609	3	wa_goner
wantoner	11	8	756	3	wantoner
warmonger	15	4	385	3	warmonger
yammer	13	37	1318	3	yamm__er
yammerer	15	22	548	3	yammerer

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	146162	0.420	425454.8
2	DLD Change Limit	146162	83	6.830	21400.0
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	7.280	24545.5