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

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

78 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
promos	10	51	1642	(None)
bromos	10	42	1331	1	bromos
pomos	9	53	2158	1	p_omos
primos	10	45	1442	1	primos
promo	9	56	1999	1	promo_
proms	9	54	2640	1	prom_s
prosos	8	57	1855	1	prosos
apropos	11	3	884	2	apropos
aromas	8	10	1861	2	aromas
bromes	10	47	1976	2	bromes
bromo	9	52	1720	2	bromo_
brooms	10	49	1587	2	brooms
broos	7	51	2641	2	bro_os
chromos	14	26	1027	2	chromos
dromon	9	3	936	2	dromon
dromons	10	3	819	2	dromons
duomos	9	3	682	2	duomos
grooms	9	45	1252	2	grooms
homos	10	59	2178	2	_homos
irokos	10	3	723	2	irokos
nomos	7	59	1974	2	_nomos
paramos	11	32	1351	2	paramos
parodos	10	30	1175	2	parodos
phonos	11	41	1479	2	phonos
photos	11	33	1663	2	photos
polos	7	61	2991	2	p_olos
pomes	9	48	3393	2	p_omes
pomo	8	58	2845	2	p_omo_
pomps	11	53	1619	2	p_omps
poms	8	70	3774	2	p_om_s
poos	6	59	4911	2	p_o_os
pornos	8	50	1525	2	pornos
prams	9	61	2551	2	pram_s
praos	7	49	2356	2	pr_aos
primas	10	44	1810	2	primas
primes	10	42	2526	2	primes
primo	9	50	1791	2	primo_
primps	12	47	1182	2	primps
prims	9	54	2593	2	prim_s
primus	10	37	1217	2	primus
proas	7	50	2880	2	pro_as
probes	10	41	1945	2	probes
prods	8	55	2355	2	pro_ds
proems	10	47	1116	2	proems
profs	10	51	2089	2	pro_fs
progs	8	66	2415	2	pro_gs
proles	8	46	2720	2	proles
prolog	9	42	1297	2	prolog
prologs	10	35	1213	2	prologs
prom	8	76	3169	2	prom__
promise	11	34	1584	2	promise
promoed	12	3	1008	2	promoed
promote	11	3	1314	2	promote
promotes	12	3	1412	2	promotes
prompt	12	3	1301	2	prompt
prompts	13	3	747	2	prompts
prongs	9	43	1448	2	prongs
proof	10	52	2153	2	pro_of
proofs	11	45	1168	2	proofs
propose	11	27	1484	2	propose
props	9	57	2688	2	pro_ps
pros	6	57	4278	2	pr__os
proses	8	47	3347	2	proses
proso	7	72	2241	2	proso_
pross	7	65	2940	2	pro_ss
proton	8	43	1889	2	proton
protons	9	31	1800	2	protons
proves	11	43	2225	2	proves
provost	12	3	857	2	provost
prowls	11	55	1108	2	prowls
prows	10	63	2701	2	pro_ws
romeos	8	40	1317	2	_romeos
romps	9	46	1754	2	_romps
roms	6	70	3896	2	_rom_s
rooms	7	53	2468	2	_rooms
rotos	5	60	2788	2	_rotos
tromps	10	49	1170	2	tromps
vrooms	11	39	871	2	vrooms

Search took 3 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.123	1452772.4
2	DLD Change Limit	82551	78	2.436	33887.9
3	Display Results	78	78	0.016	4875.0
	(SQL Overall)	178691	78	2.575	69394.6