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

Here are the results of your fuzzy-string dictionary search for “photoset” 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
photoset	13	4	1427	(None)
photosets	14	4	781	1	photosets
photoed	13	3	890	2	photo_ed
photos	11	33	1663	2	photos__
photostat	14	4	798	2	photostat
choose	11	51	1614	3	cho_ose_
chooser	12	44	1296	3	cho_oser
chooses	12	57	1741	3	cho_oses
choosey	15	45	923	3	cho_osey
homosex	19	3	612	3	_homosex
hottest	10	4	1138	3	_hottest
lotoses	7	37	1364	3	_lotoses
pentose	9	3	1159	3	pentose_
pentoses	10	3	1289	3	pentoses
pharoses	13	3	1031	3	pharoses
phattest	13	3	691	3	phattest
phimoses	15	3	719	3	phimoses
phoniest	13	28	1153	3	phoniest
phonos	11	41	1479	3	phonos__
phooey	14	37	923	3	pho_o_ey
photo	10	44	1722	3	photo___
photocell	16	5	410	3	photocell
photog	12	37	980	3	photo__g
photogene	15	4	777	3	photogene
photogs	13	35	820	3	photo_gs
photoing	14	3	906	3	photoing
photolyses	18	4	664	3	photolyses
photomap	17	4	552	3	photomap
photometer	17	4	920	3	photometer
photometry	20	5	646	3	photometry
photon	11	115	1482	3	photo__n
photonic	15	3	1208	3	photonic
photons	12	38	1441	3	photo_ns
photopia	15	4	970	3	photopia
photopic	17	4	1107	3	photopic
photoscan	16	5	505	3	photoscan
photosetter	16	7	471	3	photosetter
photostats	15	4	705	3	photostats
phots	10	54	1849	3	phot_s__
pocosen	11	4	683	3	p_ocosen
porose	8	48	1874	3	p_orose_
posset	8	49	2325	3	p_o_sset
propose	11	27	1484	3	propose_
proposed	13	20	1107	3	proposed
proposer	12	18	1063	3	proposer
proposes	12	25	1597	3	proposes
proptoses	13	4	987	3	proptoses
protases	10	21	1503	3	protases
proteose	10	22	941	3	proteose_
proteoses	11	22	1101	3	proteoses
protest	9	3	1753	3	protes_t
protist	9	3	2022	3	protis_t
provost	12	3	857	3	provos_t
ptoses	8	35	1467	3	p__toses

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.156	1145455.1
2	DLD Change Limit	146162	54	7.703	18974.7
3	Display Results	54	54	0.016	3375.0
	(SQL Overall)	178691	54	7.875	22690.9