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

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

71 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
firmers	12	47	1144	(None)
farmers	12	43	1526	1	farmers
filmers	12	42	1129	1	filmers
firers	9	49	2268	1	fir_ers
firmer	11	47	1244	1	firmer_
formers	12	82	1795	1	formers
affirmers	17	4	256	2	affirmers
aimers	8	46	2191	2	ai_mers
airers	6	49	2231	2	air_ers
armers	8	55	2027	2	_armers
birders	10	39	1326	2	birders
birlers	9	38	1300	2	birlers
dimers	9	43	2109	2	di_mers
dimmers	12	38	1156	2	dimmers
dormers	10	43	1392	2	dormers
farcers	12	47	1344	2	farcers
farers	9	59	2405	2	far_ers
farmer	11	50	1737	2	farmer_
fibbers	14	45	1060	2	fibbers
fibers	11	47	1752	2	fi_bers
fifers	12	54	1492	2	fi_fers
filers	9	46	2372	2	fi_lers
fillers	10	43	2021	2	fillers
filmer	11	41	1240	2	filmer_
filters	10	38	1655	2	filters
finders	11	37	1787	2	finders
fingers	11	34	1843	2	fingers
firer	8	112	2925	2	fir_er_
fires	8	57	4075	2	fir_e_s
firmans	12	23	852	2	firmans
firmed	12	54	1188	2	firme_d
firmest	12	3	927	2	firmest
firmness	13	3	474	2	firmness
firms	10	52	1742	2	firm__s
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
flirters	11	33	793	2	flirters
foamers	12	38	1210	2	foamers
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
framers	12	51	1382	2	framers
freers	9	47	1730	2	f_reers
friers	9	47	1893	2	f_riers
frizers	19	32	955	2	frizers
fryers	12	57	1097	2	f_ryers
fumers	11	36	1338	2	f_umers
furlers	10	42	1422	2	furlers
girders	9	37	994	2	girders
harmers	12	41	1659	2	harmers
hirers	9	45	1806	2	hir_ers
kirmess	13	23	431	2	kirmess
limmers	11	34	1308	2	limmers
mimers	10	55	2018	2	mi_mers
ormers	8	43	1614	2	_ormers
primers	11	42	1567	2	primers
rimers	8	45	2255	2	ri_mers
rimmers	11	38	1288	2	rimmers
simmers	11	33	1461	2	simmers
termers	9	54	1450	2	termers
timers	8	44	2099	2	ti_mers
trimers	9	46	1514	2	trimers
warmers	12	45	1429	2	warmers
wirers	9	46	1789	2	wir_ers
wormers	12	40	1257	2	wormers

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.126	1418182.5
2	DLD Change Limit	107671	71	3.156	34116.3
3	Display Results	71	71	0.013	5461.5
	(SQL Overall)	178691	71	3.295	54231.0