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

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

77 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
vintagers	13	12	390	(None)
vintager	12	10	482	1	vintager_
vintages	12	11	827	1	vintage_s
integers	9	3	778	2	_integers
mintages	11	11	1051	2	mintage_s
vantages	12	11	902	2	vantage_s
ventages	12	11	977	2	ventage_s
villagers	13	29	615	2	villagers
vintage	11	12	814	2	vintage__
vintners	11	3	457	2	vint_ners
vitamers	13	3	468	2	vi_tamers
bandagers	13	3	588	3	bandagers
bingers	10	45	1999	3	bin__gers
cottagers	12	30	538	3	cottagers
dingers	9	43	2138	3	din__gers
engagers	10	24	655	3	_engagers
finaglers	13	17	389	3	fin_aglers
fingers	11	34	1843	3	fin__gers
gingers	9	41	1864	3	gin__gers
hingers	11	34	2021	3	hin__gers
hinters	10	37	1958	3	hint__ers
imagers	10	10	776	3	_i_magers
incages	10	30	1388	3	_incage_s
inhalers	11	6	664	3	_inhalers
inlayers	11	3	564	3	_inlayers
innages	8	29	1130	3	_innage_s
intakes	11	3	1094	3	_intake_s
integer	8	3	799	3	_integer_
inters	6	43	2805	3	_int__ers
intoners	8	8	993	3	_intoners
invaders	12	10	530	3	_invaders
linages	8	8	1317	3	lin_age_s
lineages	9	7	918	3	lineage_s
lingers	8	42	2330	3	lin__gers
linkages	13	8	595	3	linkage_s
linters	7	38	2263	3	lint__ers
managers	11	29	1100	3	man_agers
mintage	10	11	1012	3	mintage__
minters	9	38	2247	3	mint__ers
mistakers	15	11	708	3	mistakers
montages	11	14	1218	3	montage_s
onagers	8	3	810	3	_on_agers
pillagers	12	27	692	3	pillagers
pingers	10	40	2074	3	pin__gers
qintars	16	26	857	3	qinta__rs
ringers	8	39	2295	3	rin__gers
singers	8	38	2470	3	sin__gers
sinkages	13	8	685	3	sinkage_s
sinters	7	40	2408	3	sint__ers
stagers	8	41	1667	3	__stagers
tanagers	9	25	900	3	tan_agers
tentages	9	10	1104	3	tentage_s
tinters	7	42	2111	3	tint__ers
unitages	9	3	827	3	unitage_s
upstagers	12	17	333	3	upstagers
vantage	11	10	989	3	vantage__
ventage	11	10	962	3	ventage__
venters	10	37	1773	3	vent__ers
venturers	12	4	552	3	venturers
victualers	15	5	206	3	victualers
villager	12	26	751	3	villager_
villagery	16	27	336	3	villagery
villages	12	30	1060	3	village_s
vinegars	12	4	506	3	vin_egars
vintner	10	3	483	3	vint_ner_
violaters	12	4	596	3	violaters
visages	11	3	869	3	vi_sage_s
vistaless	12	5	457	3	vistaless
vitamer	12	3	547	3	vi_tamer_
voltages	12	3	725	3	voltage_s
voyagers	15	3	281	3	v_oyagers
wantages	12	10	902	3	wantage_s
windages	13	3	826	3	windage_s
wingers	11	39	2148	3	win__gers
winterers	12	20	972	3	winterers
winters	10	37	2048	3	wint__ers
zingers	17	35	1485	3	zin__gers

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	148641	0.420	425454.8
2	DLD Change Limit	148641	77	6.910	21511.0
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	7.360	24278.7