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

Here are the results of your fuzzy-string dictionary search for “market” 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
market	12	32	2604	(None)
marked	13	39	2162	1	marked
marker	12	44	2039	1	marker
markets	13	33	1403	1	markets
armet	7	67	3945	2	_armet
barbet	10	44	2788	2	barbet
barked	13	50	2731	2	barked
barker	12	48	2286	2	barker
barret	8	49	3048	2	barret
basket	12	57	2291	2	basket
caret	7	53	6056	2	car_et
carked	13	40	2482	2	carked
carnet	8	47	3287	2	carnet
carpet	10	45	3009	2	carpet
casket	12	48	2099	2	casket
darked	12	39	1963	2	darked
darken	11	40	1344	2	darken
darker	11	47	1869	2	darker
darkest	12	25	1262	2	darkest
darkey	14	52	1242	2	darkey
garget	8	43	2727	2	garget
garnet	7	39	2841	2	garnet
garret	7	44	2656	2	garret
gasket	11	44	1725	2	gasket
harked	14	54	2255	2	harked
harken	13	51	1634	2	harken
imaret	8	11	2123	2	imar_et
jacket	19	47	2067	2	jacket
larked	11	45	1947	2	larked
larker	10	45	1924	2	larker
magnet	9	3	2066	2	magnet
make	10	55	3789	2	ma_ke_
maker	11	41	2781	2	ma_ker
makes	11	53	3685	2	ma_kes
mallet	8	44	3305	2	mallet
mammet	9	43	1925	2	mammet
marcel	10	37	1485	2	marcel
mare	6	47	5933	2	mar_e_
mares	7	64	5763	2	mar_es
marge	8	53	2833	2	marge_
margent	10	3	1669	2	margent
marges	9	45	2571	2	marges
mark	10	51	3806	2	mark__
marka	11	46	2079	2	mark_a
markas	12	47	1700	2	markas
markers	13	35	1610	2	markers
marketed	15	3	732	2	marketed
marketer	14	3	738	2	marketer
markka	11	41	659	2	markka
marks	11	59	3348	2	mark_s
markup	14	3	690	2	markup
marled	9	55	2316	2	marled
marmot	10	3	1874	2	marmot
marred	9	54	2104	2	marred
marrer	8	37	1667	2	marrer
marse	7	62	3115	2	marse_
marses	8	48	2711	2	marses
mart	6	68	6598	2	mar__t
marted	9	44	2521	2	marted
marten	8	45	1826	2	marten
martlet	9	34	1915	2	martlet
marvel	11	37	1200	2	marvel
masked	13	43	1652	2	masked
maskeg	13	38	869	2	maskeg
masker	12	44	1610	2	masker
maumet	10	35	1888	2	maumet
mirker	12	37	1269	2	mirker
mirkest	13	30	972	2	mirkest
murker	12	37	1524	2	murker
murkest	13	31	1020	2	murkest
musket	12	28	1820	2	musket
narked	11	41	1674	2	narked
packet	14	47	2650	2	packet
parget	9	45	2939	2	parget
parked	13	44	2514	2	parked
parker	12	41	2137	2	parker
racket	12	52	2942	2	racket
remarket	14	21	1103	2	remarket
tacket	12	46	2749	2	tacket
target	7	50	2891	2	target
upmarket	16	4	466	2	upmarket
varlet	9	4	2350	2	varlet
warked	14	44	2121	2	warked

Search took 6 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	82551	0.686	260482.5
2	DLD Change Limit	82551	83	5.126	16104.4
3	Display Results	83	83	0.060	1383.3
	(SQL Overall)	178691	83	5.872	30431.0