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

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

87 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
promo	9	56	2000	(None)
bromo	9	52	1720	1	bromo
pomo	8	58	2845	1	p_omo
primo	9	50	1791	1	primo
prom	8	76	3170	1	prom_
promos	10	51	1642	1	promos
proms	9	54	2641	1	proms
proso	7	72	2241	1	proso
aroma	7	12	2014	2	aroma
brome	9	44	2197	2	brome
bromos	10	42	1331	2	bromos
broo	6	51	2982	2	bro_o
broom	9	50	2221	2	broom
chromo	13	28	1101	2	chromo
dromon	9	3	936	2	dromon
duomo	8	3	975	2	duomo
from	9	69	2392	2	from_
groom	8	53	1798	2	groom
homo	9	61	2647	2	_homo
iroko	9	3	966	2	iroko
paramo	10	26	1464	2	paramo
phono	10	49	1702	2	phono
photo	10	44	1723	2	photo
poco	8	68	2615	2	p_oco
polo	6	62	3663	2	p_olo
pom	7	82	4991	2	p_om_
pome	8	56	3669	2	p_ome
pomos	9	53	2158	2	p_omos
pomp	10	62	2546	2	p_omp
poms	8	70	3774	2	p_oms
poo	5	77	5711	2	p_o_o
porno	7	51	2065	2	porno
pram	8	57	3349	2	pram_
prams	9	61	2551	2	prams
prao	6	62	2902	2	pr_ao
prim	8	51	3220	2	prim_
prima	9	50	1934	2	prima
prime	9	65	2560	2	prime
primi	9	50	1740	2	primi
primos	10	45	1442	2	primos
primp	11	56	1592	2	primp
prims	9	54	2593	2	prims
pro	5	58	3726	2	pr__o
proa	6	62	2996	2	pro_a
proas	7	50	2880	2	proas
probe	9	43	2081	2	probe
prod	7	61	2950	2	pro_d
prods	8	55	2355	2	prods
proem	9	48	1827	2	proem
proems	10	47	1116	2	proems
prof	9	61	3466	2	pro_f
profs	10	51	2089	2	profs
prog	7	57	2900	2	pro_g
progs	8	66	2415	2	progs
prole	7	45	2779	2	prole
prolog	9	42	1297	2	prolog
promoed	12	3	1008	2	promoed
promote	11	3	1314	2	promote
prompt	12	3	1301	2	prompt
prone	7	53	3262	2	prone
prong	8	52	1811	2	prong
pronto	8	3	1399	2	pronto
proof	10	52	2153	2	proof
prop	8	59	3281	2	pro_p
props	9	57	2688	2	props
pros	6	57	4278	2	pro_s
prose	7	58	3512	2	prose
prosos	8	57	1855	2	prosos
pross	7	65	2940	2	pross
prost	7	54	3410	2	prost
prosy	10	63	1925	2	prosy
proton	8	43	1889	2	proton
proud	8	46	1548	2	proud
prove	10	48	2319	2	prove
prow	9	70	3038	2	pro_w
prowl	10	56	1512	2	prowl
prows	10	63	2701	2	prows
proximo	18	4	514	2	proximo
proxy	17	50	1101	2	proxy
rom	5	98	5563	2	_rom_
romeo	7	37	1970	2	_romeo
romp	8	59	2657	2	_romp
roms	6	70	3896	2	_roms
room	6	62	3508	2	_room
roto	4	59	3505	2	_roto
tromp	9	58	1580	2	tromp
vroom	10	53	1247	2	vroom

Search took 2 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	87	1.580	34050.6
3	Display Results	87	87	0.013	6692.3
	(SQL Overall)	178691	87	1.686	105985.2