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

Here are the results of your fuzzy-string dictionary search for “pro” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

321 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
pro	5	58	3726	(None)
bro	5	62	3660	1	bro
fro	6	55	3064	1	fro
poo	5	77	5711	1	poo
prao	6	62	2902	1	prao
proa	6	62	2996	1	proa
prod	7	61	2950	1	prod
prof	9	61	3466	1	prof
prog	7	57	2900	1	prog
prom	8	76	3169	1	prom
prop	8	59	3281	1	prop
pros	6	57	4278	1	pros
prow	9	70	3038	1	prow
pry	8	57	2805	1	pry
pyro	9	60	1939	1	pyro
abo	5	90	4596	2	abo
ado	4	91	4687	2	ado
aero	4	54	3534	2	aero
ago	4	88	4552	2	ago
apo	5	111	4212	2	apo
apron	7	3	1883	2	apron
ar	2	113	7938	2	ar_
arb	5	104	4842	2	arb
arc	5	102	5090	2	arc
arco	6	83	3154	2	arco
are	3	78	7457	2	are
arf	6	74	5337	2	arf
ark	7	70	4496	2	ark
arm	5	84	4962	2	arm
ars	3	76	7093	2	ars
art	3	86	7914	2	art
arvo	7	60	2343	2	arvo
avo	6	89	3623	2	avo
azo	12	82	3339	2	azo
bio	5	78	4607	2	bio
biro	6	61	3120	2	biro
bo	4	109	5757	2	_bo
boo	5	81	6366	2	boo
bra	5	63	3946	2	bra
brio	6	54	3249	2	brio
broo	6	51	2982	2	broo
bros	6	56	3566	2	bros
brow	9	72	2844	2	brow
brr	5	69	2192	2	brr
cero	6	63	2945	2	cero
coo	5	95	6636	2	coo
cor	5	99	6094	2	cor
croc	8	57	2373	2	croc
crop	8	76	2863	2	crop
crow	9	64	2813	2	crow
cru	5	71	2956	2	cru
cry	8	97	2624	2	cry
do	3	101	5525	2	_do
dor	4	72	5392	2	dor
drop	7	53	2440	2	drop
dry	7	65	2603	2	dry
duo	4	85	3614	2	duo
duro	5	62	2802	2	duro
ego	4	67	2605	2	ego
er	2	83	4514	2	er_
era	3	57	4150	2	era
ere	3	63	5277	2	ere
erg	4	55	3107	2	erg
ergo	5	64	2015	2	ergo
ern	3	57	3835	2	ern
eros	4	52	3845	2	eros
err	3	56	2653	2	err
ers	3	60	4628	2	ers
euro	4	53	2527	2	euro
faro	7	61	3692	2	faro
for	6	69	5207	2	for
froe	7	53	2999	2	froe
frog	8	56	2436	2	frog
from	9	69	2392	2	from
frow	10	64	2505	2	frow
fry	9	62	2650	2	fry
giro	5	58	2863	2	giro
go	3	87	4874	2	_go
goo	4	77	5477	2	goo
gor	4	78	4826	2	gor
grog	6	59	2334	2	grog
grok	9	58	1968	2	grok
grot	5	59	4205	2	grot
grow	8	61	2730	2	grow
gyro	8	52	1788	2	gyro
hao	6	72	5112	2	hao
hero	7	46	3578	2	hero
ho	5	102	5827	2	_ho
inro	4	59	2079	2	inro
ire	3	69	4317	2	ire
irk	7	64	2636	2	irk
iron	4	67	2846	2	iron
jo	9	95	3960	2	_jo
kor	7	65	3889	2	kor
lo	2	80	5344	2	_lo
loo	3	83	5982	2	loo
mho	8	66	2462	2	mho
mo	4	91	5848	2	_mo
moo	5	84	6051	2	moo
mor	5	68	5500	2	mor
no	2	93	5324	2	_no
noo	3	71	5404	2	noo
nor	3	80	4882	2	nor
oho	6	65	3438	2	oho
ono	3	68	3803	2	ono
or	2	73	5473	2	or_
ora	3	72	5083	2	ora
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
ordo	5	46	2235	2	ordo
ore	3	66	6183	2	ore
ors	3	57	5011	2	ors
ort	3	94	6523	2	ort
orzo	13	45	1678	2	orzo
oxo	10	73	2296	2	oxo
pa	4	104	5648	2	p_a
pac	7	90	5408	2	pac
pad	6	80	5732	2	pad
pah	8	88	5359	2	pah
pal	5	67	6167	2	pal
pam	7	78	5839	2	pam
pan	5	84	6644	2	pan
pap	7	67	5840	2	pap
par	5	74	6702	2	par
para	6	52	4217	2	para
pard	7	64	4132	2	pard
pare	6	67	6084	2	pare
pareo	7	46	3260	2	pareo
pargo	8	67	2372	2	pargo
park	10	52	3749	2	park
parol	7	48	2627	2	parol
parr	6	57	3115	2	parr
pars	6	75	6079	2	pars
part	6	59	6746	2	part
parvo	10	77	1918	2	parvo
pas	5	87	7574	2	pas
pat	5	80	8946	2	pat
paw	8	76	5117	2	paw
pax	12	73	4685	2	pax
pay	8	84	6118	2	pay
pe	4	76	4903	2	p_e
pea	5	66	5724	2	pea
pec	7	67	4441	2	pec
ped	6	67	5152	2	ped
pedro	8	3	1315	2	pedro
pee	5	60	6651	2	pee
peg	6	58	4306	2	peg
peh	8	67	4096	2	peh
pen	5	65	5884	2	pen
peon	6	56	3524	2	peon
pep	7	64	4708	2	pep
pepo	8	76	2215	2	pepo
per	5	63	5309	2	per
pere	6	64	5026	2	pere
peri	6	56	3697	2	peri
perk	10	62	3284	2	perk
perm	8	58	3463	2	perm
perp	8	90	2989	2	perp
pert	6	67	5932	2	pert
perv	9	72	2481	2	perv
pes	5	72	5978	2	pes
peso	6	69	2582	2	peso
pet	5	64	7730	2	pet
pew	8	64	4230	2	pew
phi	8	65	2420	2	phi
phon	9	59	2538	2	phon
phot	9	55	3435	2	phot
pht	8	60	3052	2	pht
pi	4	81	4536	2	p_i
pia	5	68	4803	2	pia
pic	7	60	4682	2	pic
pie	5	54	5740	2	pie
pig	6	57	4497	2	pig
pin	5	70	6672	2	pin
pion	6	72	3529	2	pion
pip	7	80	5104	2	pip
pirn	6	71	2837	2	pirn
pirog	8	39	1367	2	pirog
pis	5	63	6203	2	pis
piso	6	67	2756	2	piso
pit	5	64	7192	2	pit
piu	5	66	3954	2	piu
pix	12	64	3793	2	pix
plod	7	67	2327	2	plod
plop	8	66	2574	2	plop
plot	6	61	4123	2	plot
plow	9	59	2323	2	plow
ploy	9	61	2360	2	ploy
ply	8	63	2355	2	ply
poco	8	68	2615	2	poco
pod	6	63	5148	2	pod
poh	8	67	4053	2	poh
poi	5	72	4466	2	poi
pol	5	64	4938	2	pol
polo	6	62	3663	2	polo
pom	7	82	4991	2	pom
pomo	8	58	2845	2	pomo
pood	7	59	3432	2	pood
poof	9	55	4166	2	poof
pooh	9	60	2738	2	pooh
pool	6	58	3595	2	pool
poon	6	73	4126	2	poon
poop	8	65	3281	2	poop
poor	6	56	3022	2	poor
poos	6	59	4911	2	poos
pop	7	62	5225	2	pop
pore	6	64	5126	2	pore
pork	10	69	2968	2	pork
porn	6	56	3602	2	porn
porno	7	51	2065	2	porno
port	6	60	5963	2	port
pot	5	80	7843	2	pot
pow	8	71	4728	2	pow
pox	12	61	4069	2	pox
pram	8	57	3349	2	pram
praos	7	49	2356	2	praos
prat	6	59	5204	2	prat
prau	6	65	2947	2	prau
pray	9	63	3153	2	pray
pree	6	70	4473	2	pree
preop	9	47	1587	2	preop
prep	8	64	2767	2	prep
prex	13	57	2297	2	prex
prey	9	62	2848	2	prey
prez	15	61	2631	2	prez
prig	7	59	2487	2	prig
prim	8	51	3220	2	prim
primo	9	50	1791	2	primo
prion	7	51	1999	2	prion
prior	7	43	1617	2	prior
proas	7	50	2880	2	proas
probe	9	43	2081	2	probe
prods	8	55	2355	2	prods
proem	9	48	1827	2	proem
profs	10	51	2089	2	profs
progs	8	66	2415	2	progs
prole	7	45	2779	2	prole
promo	9	56	1999	2	promo
proms	9	54	2640	2	proms
prone	7	53	3262	2	prone
prong	8	52	1811	2	prong
proof	10	52	2153	2	proof
props	9	57	2688	2	props
prose	7	58	3512	2	prose
proso	7	72	2241	2	proso
pross	7	65	2940	2	pross
prost	7	54	3410	2	prost
prosy	10	63	1925	2	prosy
proud	8	46	1548	2	proud
prove	10	48	2319	2	prove
prowl	10	56	1512	2	prowl
prows	10	63	2701	2	prows
proxy	17	50	1101	2	proxy
psi	5	66	2162	2	psi
pst	5	79	3251	2	pst
pub	7	60	3769	2	pub
pud	6	58	3665	2	pud
pug	6	53	3718	2	pug
pul	5	61	3806	2	pul
pun	5	88	4651	2	pun
pup	7	63	3988	2	pup
pur	5	68	4055	2	pur
pure	6	55	4333	2	pure
puri	6	59	3144	2	puri
purl	6	56	3142	2	purl
purr	6	49	2581	2	purr
purs	6	56	4104	2	purs
pus	5	55	4784	2	pus
put	5	57	5907	2	put
pya	8	70	2375	2	pya
pye	8	64	3250	2	pye
pyre	9	49	2555	2	pyre
pyros	10	57	1829	2	pyros
pyx	15	78	1701	2	pyx
re	2	61	5374	2	_re
repro	7	53	1591	2	repro
rho	6	59	2483	2	rho
rob	5	67	5430	2	_rob
roc	5	202	4325	2	_roc
rod	4	79	5389	2	_rod
roe	3	68	6107	2	_roe
rom	5	98	5563	2	_rom
rot	3	72	8295	2	_rot
row	6	74	5367	2	_row
so	2	88	5544	2	_so
spry	9	68	1912	2	spry
sri	3	56	3400	2	sri
tao	3	83	5895	2	tao
taro	4	68	4691	2	taro
tho	6	74	3396	2	tho
thro	7	77	2642	2	thro
tiro	4	68	3236	2	tiro
to	2	188	5898	2	_to
too	3	89	6542	2	too
tor	3	92	6168	2	tor
toro	4	80	4568	2	toro
trio	4	52	3334	2	trio
trod	5	76	2795	2	trod
trog	5	76	2821	2	trog
trop	6	68	3330	2	trop
trot	4	63	5131	2	trot
trow	7	80	3142	2	trow
troy	7	74	2968	2	troy
try	6	65	2967	2	try
two	6	79	2583	2	two
tyro	7	66	2236	2	tyro
udo	4	90	2730	2	udo
updo	7	67	1288	2	updo
upo	5	89	2586	2	upo
urb	5	57	3110	2	urb
urd	4	64	2704	2	urd
urn	3	57	3146	2	urn
urp	5	64	2639	2	urp
vrow	10	58	1747	2	vrow
who	9	55	2677	2	who
wo	5	104	4776	2	_wo
woo	6	69	4980	2	woo
wry	9	65	2470	2	wry
yo	5	97	4855	2	_yo
zero	13	48	2246	2	zero
zoo	12	62	3891	2	zoo

Search took 1 second 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	14084	0.063	2836365.1
2	DLD Change Limit	14084	321	0.546	25794.9
3	Display Results	321	321	0.093	3451.6
	(SQL Overall)	178691	321	0.702	254545.6