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

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

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
filmers	12	42	1129	(None)
filers	9	46	2372	1	fil_ers
fillers	10	43	2021	1	fillers
filmer	11	41	1240	1	filmer_
filters	10	38	1655	1	filters
firmers	12	47	1144	1	firmers
aimers	8	46	2191	2	ai_mers
bilkers	13	47	1186	2	bilkers
billers	9	47	2083	2	billers
dimers	9	43	2109	2	di_mers
dimmers	12	38	1156	2	dimmers
fallers	10	39	1799	2	fallers
falters	10	39	1647	2	falters
farmers	12	43	1526	2	farmers
fellers	10	41	1754	2	fellers
fibbers	14	45	1060	2	fibbers
fibers	11	47	1752	2	fi_bers
fielders	12	15	677	2	fielders
fifers	12	54	1492	2	fi_fers
filbert	12	4	1164	2	filbert
filberts	13	3	499	2	filberts
filchers	16	28	686	2	filchers
filer	8	54	3300	2	fil_er_
files	8	54	4127	2	fil_e_s
filets	9	47	1895	2	fil_ets
filler	9	46	2362	2	filler_
filles	9	42	2452	2	fille_s
fillets	10	34	1475	2	fillets
filmed	12	46	1036	2	filme_d
filmgoers	15	4	198	2	filmgoers
filmier	12	3	750	2	filmier_
filmis	11	46	1028	2	film_is
filmless	13	4	455	2	filmless
films	10	56	1796	2	film__s
filmsets	13	5	341	2	filmsets
filter	9	45	1763	2	filter_
finders	11	37	1787	2	finders
fingers	11	34	1843	2	fingers
firers	9	49	2268	2	fi_rers
firmer	11	47	1244	2	firmer_
fishers	13	47	1472	2	fishers
fitters	10	45	1775	2	fitters
fivers	12	44	2092	2	fi_vers
fixers	16	51	1298	2	fi_xers
fizzers	18	35	700	2	fizzers
flamers	12	46	1636	2	flamers
fleers	9	60	1579	2	f_leers
fliers	9	44	1719	2	f_liers
flyers	12	57	1280	2	f_lyers
foamers	12	38	1210	2	foamers
folders	11	35	1439	2	folders
formers	12	82	1795	2	formers
framers	12	51	1382	2	framers
frillers	11	34	987	2	frillers
fullers	10	38	1737	2	fullers
fulmars	12	4	642	2	fulmars
fumers	11	36	1338	2	f_umers
gilders	9	42	1246	2	gilders
gillers	8	42	1690	2	gillers
hillers	10	37	1873	2	hillers
jilters	14	42	1196	2	jilters
killers	11	42	1558	2	killers
kilters	11	38	1360	2	kilters
limmers	11	34	1308	2	limmers
milers	8	46	2516	2	mil_ers
milkers	13	44	1161	2	milkers
millers	9	36	2134	2	millers
milters	9	36	1909	2	milters
mimers	10	55	2018	2	mi_mers
oilers	6	47	2119	2	oil_ers
palmers	11	35	1362	2	palmers
pilfers	12	3	896	2	pilfers
rimers	8	45	2255	2	ri_mers
rimmers	11	38	1288	2	rimmers
sillers	7	38	2210	2	sillers
silvers	10	47	1404	2	silvers
simmers	11	33	1461	2	simmers
tilers	6	35	2350	2	til_ers
tillers	7	34	1874	2	tillers
tilters	7	33	1595	2	tilters
timers	8	44	2099	2	ti_mers
wilders	11	35	1350	2	wilders
willers	10	35	1791	2	willers

Search took 4 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.390	458182.1
2	DLD Change Limit	107671	83	3.110	34620.9
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	3.530	50620.7