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

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

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

331 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
picara	10	3	1190	(None)
picaras	11	3	1127	1	picaras
picaro	10	3	1132	1	picaro
bicarb	12	3	854	2	bicarb
cicada	11	3	641	2	cicada
cicala	10	3	1005	2	cicala
epicarp	13	7	607	2	epicarp
jicama	17	3	487	2	jicama
kinara	10	3	1036	2	kinara
micra	9	62	1497	2	mic_ra
para	6	52	4217	2	p__ara
pica	8	58	3149	2	pic__a
pical	9	55	2437	2	pica_l
picaros	11	3	1089	2	picaros
picas	9	46	2652	2	pica_s
piccata	13	4	570	2	piccata
pilar	7	52	2150	2	pilar_
pinata	8	38	1721	2	pinata
pirana	8	7	1326	2	pirana
piraya	11	6	771	2	piraya
piscary	14	3	742	2	piscary
pitaya	11	8	660	2	pitaya
tiara	5	3	1590	2	ti_ara
vicar	10	5	1386	2	vicar_
vicars	11	7	1226	2	vicars
acari	7	50	2028	3	_acari
apiary	11	39	1038	3	api_ary
apical	10	9	1390	3	apica_l
apicals	11	5	992	3	apicals
apocarp	13	5	513	3	apocarp
arcana	8	9	1258	3	arcana
baccara	13	4	714	3	baccara
bicarbs	13	3	601	3	bicarbs
bicorn	10	36	1010	3	bicorn
bidarka	14	4	384	3	bidarka
binary	11	3	1222	3	binary
buckra	14	3	675	3	buckra
caca	8	55	2808	3	__caca
car	5	91	6556	3	__car_
carat	7	50	4879	3	__carat
carb	8	51	4316	3	__carb
card	7	102	4587	3	__card
care	6	69	6837	3	__care
cark	10	55	3927	3	__cark
carl	6	51	4478	3	__carl
carn	6	62	4543	3	__carn
carp	8	51	3981	3	__carp
carr	6	54	3470	3	__carr
cars	6	73	6476	3	__cars
cart	6	65	7034	3	__cart
casa	6	56	3086	3	__casa
cascara	11	3	831	3	cascara
cicadae	12	4	485	3	cicadae
cicadas	12	3	598	3	cicadas
cicalas	11	3	929	3	cicalas
cicale	10	3	1450	3	cicale
cicero	10	4	850	3	cicero
cigar	8	9	1179	3	cigar_
cigars	9	9	1071	3	cigars
cithara	12	16	649	3	cithara
curara	8	37	1220	3	curara
decare	9	39	1915	3	decare
diary	9	50	1697	3	di_ary
dicamba	14	5	341	3	dicamba
dicast	9	3	1557	3	dicast
dicer	8	54	2642	3	dicer_
dicers	9	47	2074	3	dicers
dicta	8	49	1563	3	dic_ta
dinar	6	63	1989	3	dinar_
dinars	7	54	1756	3	dinars
disarm	9	3	1047	3	disarm
discard	11	3	1021	3	discard
epical	10	4	1339	3	epica_l
epicardia	14	5	340	3	epicardia
epicarps	14	4	478	3	epicarps
epicure	11	3	682	3	epicure
escar	7	40	1199	3	escar_
escarp	10	44	900	3	escarp
escars	8	39	1313	3	escars
fiacre	11	3	762	3	fiacre
fiar	7	64	2733	3	fi_ar_
fiars	8	67	2083	3	fi_ars
filar	8	48	1929	3	filar_
filaria	10	3	965	3	filaria
hijra	15	3	564	3	hi_jra
hilar	8	54	1814	3	hilar_
inarm	7	3	1442	3	_inarm
infra	8	3	864	3	_infra
ixora	12	3	691	3	_ixora
izar	13	66	1601	3	_izar_
izars	14	51	1293	3	_izars
jacana	15	3	793	3	jacana
jicamas	18	4	504	3	jicamas
kinaras	11	5	909	3	kinaras
kithara	14	14	519	3	kithara
labara	8	37	1289	3	labara
liana	5	39	1589	3	li_ana
liar	4	72	2968	3	li_ar_
liard	6	54	1859	3	li_ard
liars	5	47	2316	3	li_ars
libra	7	47	1242	3	li_bra
lidar	6	3	1272	3	lidar_
lidars	7	3	1078	3	lidars
lira	4	69	2868	3	li__ra
lizard	16	36	923	3	lizard
lycra	10	31	797	3	lyc_ra
mara	6	74	4456	3	__mara
mascara	11	3	802	3	mascara
megara	9	3	1009	3	megara
mica	8	64	2824	3	mic__a
micas	9	68	2305	3	mica_s
micro	9	47	1599	3	mic_ro
mikra	11	46	1031	3	mi_kra
nicad	8	3	1261	3	nica_d
nicads	9	3	833	3	nicads
nicer	7	46	1829	3	nicer_
ovipara	12	4	254	3	ovipara
oxcart	15	3	952	3	oxcart
paca	8	51	3224	3	p__aca
pacas	9	60	2940	3	paca_s
pacer	9	61	3161	3	pacer_
pacers	10	51	2454	3	pacers
pacha	12	65	1806	3	pac_ha
paisana	9	40	1022	3	paisana
pajama	17	31	765	3	pajama
pakora	12	4	728	3	pakora
palabra	11	3	718	3	palabra
palapa	10	3	1067	3	palapa
panada	9	41	1305	3	panada
panama	10	42	1334	3	panama
papa	8	58	2714	3	p__apa
papaya	13	3	750	3	papaya
par	5	74	6702	3	p__ar_
parae	7	63	3570	3	p__arae
paras	7	61	4304	3	p__aras
pard	7	64	4132	3	p__ard
pare	6	67	6084	3	p__are
park	10	52	3749	3	p__ark
parka	11	51	2088	3	p__arka
parr	6	57	3115	3	p__arr
pars	6	75	6079	3	p__ars
part	6	59	6746	3	p__art
parura	8	3	1058	3	parura
pataca	10	3	1119	3	pataca
pear	6	97	4523	3	p_ear_
pearl	7	53	2446	3	p_earl
pears	7	51	3861	3	p_ears
peart	7	64	4075	3	p_eart
pecan	9	19	1903	3	peca_n
pecans	10	15	1583	3	pecans
peccary	16	3	628	3	peccary
pericarp	14	4	612	3	pericarp
petard	9	50	1380	3	petard
philtra	12	10	368	3	philtra
pia	5	68	4803	3	pi___a
pial	6	56	3670	3	pi_a_l
pian	6	61	3609	3	pi_a_n
piano	7	61	1871	3	pi_ano
pians	7	51	2696	3	pi_ans
pias	6	65	4255	3	pi_a_s
piasaba	11	4	419	3	piasaba
piasava	12	4	388	3	piasava
piazza	16	4	382	3	piazza
pibal	9	52	1732	3	piba_l
pibals	10	38	1308	3	pibals
pic	7	60	4682	3	pic___
picacho	16	4	473	3	picacho
picador	12	4	592	3	picador
picadors	13	4	583	3	picadors
picante	11	3	1052	3	picante
picaroon	12	4	565	3	picaroon
pice	8	46	4109	3	pic__e
pick	12	59	3381	3	pic__k
pickax	21	3	591	3	pickax
pickaxe	22	4	462	3	pickaxe
picked	15	44	2131	3	picked
picker	14	44	2217	3	picker
pickers	15	37	1809	3	pickers
picket	14	49	2431	3	picket
pickle	14	42	1565	3	pickle
picks	13	52	2614	3	pic_ks
pickup	16	5	563	3	pickup
picky	16	54	1694	3	pic_ky
picloram	14	4	591	3	picloram
picnic	12	34	1026	3	picnic
picofarad	17	5	217	3	picofarad
picogram	15	4	652	3	picogram
picot	9	50	3101	3	pic_ot
picots	10	46	1644	3	picots
picrate	11	20	1414	3	picrate
picric	12	30	992	3	picric
pics	8	56	3391	3	pic__s
picture	11	5	861	3	picture
picul	9	50	1536	3	pic_ul
piculs	10	35	1175	3	piculs
piecer	10	52	1308	3	piecer_
piecers	11	41	1225	3	piecers
pier	6	60	3529	3	pi_er_
piers	7	59	2633	3	pi_ers
pieta	7	54	2175	3	pi_eta
pignora	10	30	636	3	pignora
pika	10	63	2295	3	pi__ka
pikake	11	11	580	3	pikake
pikas	11	42	1809	3	pika_s
piker	11	56	2284	3	piker_
pikers	12	47	1739	3	pikers
pilaf	10	39	2348	3	pila_f
pilaff	14	39	1036	3	pilaff
pilafs	11	35	1102	3	pilafs
pilau	7	36	1852	3	pila_u
pilaus	8	41	1413	3	pilaus
pilaw	10	39	1374	3	pila_w
pilaws	11	39	943	3	pilaws
pilchard	16	4	455	3	pilchard
pilea	7	51	2395	3	pi_lea
pillar	8	3	1402	3	pillar_
pillars	9	3	1348	3	pillars
pima	8	54	2865	3	pi__ma
pimas	9	47	2510	3	pima_s
pina	6	58	4263	3	pi__na
pinang	9	26	1159	3	pinang
pinas	7	54	3445	3	pina_s
pinatas	9	37	1148	3	pinatas
pincer	10	40	1917	3	pincer_
pincers	11	39	1650	3	pincers
pinery	11	52	1428	3	pinery
pineta	8	58	1556	3	pineta
pinna	7	53	2018	3	pi_nna
pinta	7	57	2705	3	pi_nta
pintada	10	9	607	3	pintada
pipage	11	9	914	3	pipage
pipal	9	51	1835	3	pipa_l
pipals	10	42	1364	3	pipals
piper	9	65	2319	3	piper_
pipers	10	43	1866	3	pipers
piracy	13	3	947	3	piracy
piragua	10	4	464	3	piragua
piranas	9	9	1260	3	piranas
piranha	12	12	636	3	piranha
pirate	8	23	2288	3	pirate
pirayas	12	7	748	3	pirayas
pirn	6	71	2837	3	pi__rn
piscina	11	7	704	3	piscina
pita	6	54	3643	3	pi__ta
pitapat	11	4	916	3	pitapat
pitas	7	74	2767	3	pita_s
pitayas	12	8	626	3	pitayas
pitta	7	50	1869	3	pi_tta
pizazz	15	5	422	3	pizazz
pizza	15	3	818	3	pi_zza
placard	12	3	678	3	placard
playa	10	58	1294	3	p_laya
plaza	16	43	1106	3	p_laza
plectra	11	4	578	3	plectra
pleura	8	3	753	3	pleura
plica	9	6	1337	3	plic__a
plicae	10	4	1095	3	plica_e
plical	10	4	1168	3	plica_l
plicate	11	3	1451	3	plicate
pochard	15	3	736	3	pochard
podagra	11	4	360	3	podagra
polar	7	56	2345	3	polar_
polars	8	44	1935	3	polars
posada	9	3	716	3	posada
prearm	10	45	1234	3	prearm
precava	14	4	509	3	precava
pricer	10	39	1829	3	pricer_
pricers	11	39	1506	3	pricers
primary	14	3	770	3	primary
procarp	13	4	682	3	procarp
pucka	13	34	1280	3	puc_ka
puparia	11	4	735	3	puparia
purana	8	7	1293	3	purana
pyjama	20	30	348	3	pyjama
riata	5	46	1802	3	ri_ata
ricer	7	47	2661	3	ricer_
ricers	8	41	2099	3	ricers
ricrac	10	3	701	3	ricrac
ristra	6	3	1070	3	ristra
ritard	7	48	1208	3	ritard
sacra	7	45	1699	3	sac_ra
samara	8	3	1385	3	samara
satara	6	3	1553	3	satara
scar	6	64	3420	3	_scar_
scarab	10	3	1006	3	_scarab
scare	7	53	3446	3	_scare
scarf	10	54	2714	3	_scarf
scarp	9	57	2410	3	_scarp
scars	7	54	3353	3	_scars
scart	7	61	3977	3	_scart
scary	10	52	2259	3	_scary
sierra	6	3	731	3	sierra
sifaka	13	5	355	3	sifaka
simar	7	49	2081	3	simar_
simars	8	49	1693	3	simars
sirra	5	44	1632	3	si_rra
sistra	6	3	933	3	sistra
sitar	5	48	2054	3	sitar_
sitars	6	54	1759	3	sitars
sizar	14	52	1499	3	sizar_
sizars	15	48	1262	3	sizars
spectra	11	27	583	3	spectra
spica	9	47	1794	3	spic__a
spicae	10	43	1370	3	spica_e
spicas	10	47	1582	3	spica_s
spicate	11	32	1419	3	spicate
spicer	10	47	1931	3	spicer_
spicers	11	38	1555	3	spicers
spicery	14	49	901	3	spicery
spicula	11	25	929	3	spicula
spiraea	9	40	798	3	spiraea
tiaras	6	3	1453	3	ti_aras
tical	7	60	2149	3	tica_l
ticals	8	32	1471	3	ticals
timarau	9	7	584	3	timarau
tipcart	11	4	883	3	tipcart
vara	7	55	3088	3	__vara
vicarage	14	4	443	3	vicarage
vicarate	13	7	860	3	vicarate
vicarial	13	4	779	3	vicarial
vicarly	15	3	646	3	vicarly
vicuna	11	11	590	3	vicuna
visard	10	39	1012	3	visard
viscera	12	3	508	3	viscera
vivaria	13	4	698	3	vivaria
vivary	15	3	698	3	vivary
vizard	19	45	885	3	vizard
wicca	12	4	725	3	wic_ca
wirra	8	32	1082	3	wi_rra
wizard	19	37	771	3	wizard
zingara	17	4	549	3	zingara

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	112716	0.203	880251.2
2	DLD Change Limit	112716	331	7.406	15219.6
3	Display Results	331	331	0.173	1913.3
	(SQL Overall)	178691	331	7.782	22962.1