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

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

54 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
primroses	13	4	484	(None)
primrose	12	4	450	1	primrose_
phimoses	15	3	719	2	phim_oses
preimposes	16	4	403	2	preimposes
primuses	12	3	708	2	prim_uses
arthroses	12	4	871	3	arthroses
fibroses	13	4	597	3	_fibroses
hidroses	12	3	790	3	_hidroses
imposes	11	32	1368	3	__imposes
pharoses	13	3	1031	3	p_haroses
phimosis	15	4	617	3	phim_osis
plimsoles	13	4	357	3	plimsoles
preimpose	15	4	401	3	preimpose_
preimposed	17	4	323	3	preimposed
premises	12	30	1827	3	prem_ises
premisses	13	28	876	3	premisses
premorse	12	3	755	3	premorse_
priapuses	13	4	370	3	priapuses
primacies	15	4	845	3	primacies
primages	13	15	927	3	prim_ages
primaries	13	4	1083	3	primaries
primates	12	15	1593	3	prim_ates
primeness	13	3	865	3	primeness
primeros	12	33	688	3	primero__s
primes	10	42	2526	3	prim___es
primines	12	30	1370	3	prim_ines
primness	12	7	676	3	primnes_s
primnesses	14	9	780	3	primnesses
primos	10	45	1442	3	prim_o__s
princoxes	20	4	408	3	princoxes
priorates	11	4	1075	3	priorates
prioress	10	3	539	3	priores_s
prioresses	12	4	570	3	prioresses
priories	10	3	1245	3	prior_ies
prises	8	41	3317	3	pri___ses
prisses	9	48	1671	3	pri__sses
prodromes	14	4	606	3	prodromes
prognoses	12	4	753	3	prognoses
promises	12	29	1676	3	prom_ises
promotes	12	3	1412	3	prom_otes
proposes	12	25	1597	3	pr_oposes
proptoses	13	4	987	3	proptoses
proses	8	47	3347	3	p___roses
proteoses	11	22	1101	3	proteoses
psiloses	10	3	643	3	psi_loses
reimposes	13	4	547	3	reimposes
remorses	10	3	1199	3	_remorses
riboses	9	3	1044	3	_ri_boses
rimose	8	3	1059	3	_rim_ose_
rimrocks	16	4	404	3	_rimrocks
trichoses	14	10	796	3	trichoses
trioses	7	50	1565	3	tri__oses
triposes	10	3	997	3	tri_poses
viroses	10	3	1053	3	_vi_roses

Search took 9 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.173	1032896.0
2	DLD Change Limit	148641	54	7.843	18952.1
3	Display Results	54	54	0.030	1800.0
	(SQL Overall)	178691	54	8.046	22208.7