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

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

419 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
pianic	10	37	1412	(None)
panic	9	39	2390	1	p_anic
picnic	12	34	1026	1	picnic
pionic	10	35	1595	1	pionic
bionic	10	36	1457	2	bionic
cyanic	13	31	1077	2	cyanic
ionic	7	46	2265	2	_ionic
limnic	10	41	883	2	limnic
manic	9	46	2943	2	_manic
panics	10	38	1536	2	p_anics
phasic	13	36	1205	2	phasic
phatic	13	30	1440	2	phatic
phonic	13	33	1520	2	phonic
pian	6	61	3609	2	pian__
pianism	11	6	1103	2	pianism
pianist	9	6	1510	2	pianist
piano	7	61	1871	2	pian_o
pianos	8	43	1593	2	pianos
pians	7	51	2696	2	pian_s
picnics	13	29	734	2	picnics
picric	12	30	992	2	picric
piratic	11	3	1429	2	piratic
priapic	13	4	602	2	priapic
puranic	11	4	1048	2	puranic
pyknic	17	3	489	2	pyknic
sialic	8	3	1363	2	sialic
titanic	9	6	854	2	titanic
uranic	8	23	1518	2	uranic
viatic	11	3	1145	2	viatic
vinic	10	3	1497	2	vi_nic
acinic	10	47	1354	3	acinic
aeonic	8	35	1704	3	aeonic
agamic	11	31	1054	3	agamic
agaric	9	35	1362	3	agaric
agonic	9	35	1514	3	agonic
alanin	6	3	1727	3	alanin
aminic	10	44	1351	3	aminic
amnic	9	55	1623	3	_amnic
ani	3	77	5117	3	__ani_
anil	4	64	3743	3	__anil
anionic	9	3	1287	3	anionic
anis	4	57	4646	3	__anis
antic	7	57	2886	3	__antic
aphasic	14	28	1006	3	aphasic
aphonic	14	27	1339	3	aphonic
apian	7	50	1833	3	apian__
apimania	12	4	546	3	apimania
apraxic	18	4	629	3	apraxic
arabic	10	3	1273	3	arabic
atavic	11	18	929	3	atavic
ataxic	15	16	920	3	ataxic
atonic	8	34	2047	3	atonic
aviatic	12	3	924	3	aviatic
avionic	12	3	769	3	avionic
axenic	15	42	1000	3	axenic
axonic	15	43	1272	3	axonic
azonic	17	55	1315	3	azonic
bani	6	53	3495	3	_bani_
baric	9	61	2569	3	_baric
basic	9	62	2052	3	_basic
beanie	8	36	1859	3	beanie
biali	7	34	1907	3	biali_
bialis	8	36	1716	3	bialis
bibasic	13	4	564	3	bibasic
binit	7	64	3158	3	bi_nit
bionics	11	43	1087	3	bionics
biontic	11	4	833	3	biontic
biopic	12	37	1067	3	biopic
biotic	10	38	1660	3	biotic
botanic	11	5	958	3	botanic
canid	8	55	2634	3	_canid
cantic	10	39	2053	3	_cantic
citric	10	28	1230	3	citric
civic	12	34	1254	3	ci_vic
clinic	10	43	1279	3	clinic
clonic	10	49	1467	3	clonic
conic	9	53	2979	3	_conic
crania	8	24	1843	3	crania
cyanid	12	39	1203	3	cyanid
cyanin	11	39	1145	3	cyanin
cynic	12	47	1242	3	_cynic
danio	6	3	1978	3	_danio
daric	8	56	2311	3	_daric
diacid	10	3	1063	3	diacid
diamin	9	3	1251	3	diamin
diapir	9	35	711	3	diapir
diatonic	11	3	867	3	diatonic
diazin	16	3	916	3	diazin
dibasic	12	4	603	3	dibasic
dyadic	13	3	609	3	dyadic
edenic	9	3	1022	3	edenic
eirenic	9	3	900	3	eirenic
enatic	8	3	1756	3	enatic
epigeic	12	4	598	3	epigeic
epigenic	13	4	748	3	epigenic
epigonic	13	4	672	3	epigonic
epiphanic	18	4	412	3	epiphanic
epitaxic	19	4	428	3	epitaxic
epizoic	20	4	519	3	epizoic
ethnic	11	4	885	3	ethnic
exonic	15	32	1141	3	exonic
fanfic	14	3	631	3	_fanfic
fiance	11	3	1074	3	fiance
filmic	13	34	845	3	filmic
finis	8	68	2426	3	fi_nis
fistic	11	8	1257	3	fistic
franc	10	46	1541	3	fran_c
frantic	12	3	1036	3	frantic
gamic	10	39	1619	3	_gamic
genic	8	51	1939	3	_genic
giant	6	54	3059	3	gian_t
giants	7	47	1350	3	giants
gigantic	12	4	429	3	gigantic
guanin	7	6	1080	3	guanin
hyaenic	15	4	599	3	hyaenic
hyenic	14	3	872	3	hyenic
hypnic	16	3	726	3	hypnic
iambic	12	46	825	3	_iambic
iatric	8	3	1215	3	_iatric
iconic	10	4	1159	3	iconic
ictic	9	3	1179	3	_ictic
inia	4	50	2469	3	_i_nia
iodic	8	48	1674	3	_iodic
ionics	8	42	1447	3	_ionics
irenic	8	3	1110	3	irenic
ironic	8	3	1377	3	ironic
italic	8	3	990	3	italic
jinni	12	53	1063	3	jinni_
jinnis	13	48	905	3	jinnis
kainit	10	4	1448	3	kainit
kaonic	12	3	876	3	kaonic
kiang	10	48	1135	3	kian_g
kiangs	11	37	836	3	kiangs
kinin	9	49	1732	3	ki_nin
laic	6	59	3156	3	_la_ic
liana	5	39	1589	3	lian_a
lianas	6	37	1338	3	lianas
liane	5	47	2066	3	lian_e
lianes	6	38	1932	3	lianes
liang	6	49	1441	3	lian_g
liangs	7	44	1059	3	liangs
lianoid	8	3	752	3	lianoid
lignin	7	49	1119	3	lignin
limbic	12	52	872	3	limbic
linac	7	3	1541	3	li_nac
linin	5	80	2552	3	li_nin
lithic	11	3	949	3	lithic
mafic	12	56	1546	3	_mafic
magic	10	58	1865	3	_magic
malic	9	45	2565	3	_malic
mania	7	56	3414	3	_mania
maniac	10	39	1797	3	_maniac
manics	10	39	1993	3	_manics
manioc	10	39	1482	3	_manioc
mantic	10	41	2090	3	_mantic
meanie	8	37	1839	3	meanie
melanic	11	3	1040	3	melanic
miasmic	13	3	574	3	miasmic
mimic	11	14	1431	3	mi_mic
mini	6	56	3454	3	mi_ni_
minim	9	73	2159	3	mi_nim
minis	7	54	3298	3	mi_nis
miotic	10	37	1574	3	miotic
muonic	10	4	1018	3	muonic
naric	7	68	2417	3	_naric
niacin	8	3	1022	3	niacin
niobic	10	3	723	3	niobic
nirvanic	13	4	225	3	nirvanic
nitric	8	25	1206	3	nitric
oceanic	11	4	616	3	oceanic
opsonic	11	3	725	3	opsonic
organic	10	3	831	3	organic
ovonic	11	28	818	3	ovonic
oxalic	15	3	709	3	oxalic
ozonic	17	30	894	3	ozonic
pac	7	90	5408	3	p_a__c
padi	7	63	3178	3	p_adi_
padis	8	62	2714	3	p_adis
paid	7	57	3748	3	p_a_id
paik	10	57	2680	3	p_a_ik
pail	6	61	4183	3	p_a_il
pain	6	56	4724	3	p_a_in
painch	13	35	1132	3	painch
pained	9	56	2285	3	pained
paining	10	39	2024	3	paining
pains	7	51	3828	3	pain_s
paint	7	54	4369	3	pain_t
paints	8	59	2183	3	paints
painty	11	47	1475	3	painty
pair	6	60	3151	3	p_a_ir
pan	5	84	6644	3	p_an__
panda	8	50	2261	3	p_anda
pandit	9	38	2075	3	p_andit
pandy	11	50	2117	3	p_andy
pane	6	49	5028	3	p_an_e
paned	8	54	3718	3	p_aned
panel	7	60	2362	3	p_anel
panes	7	61	4869	3	p_anes
pang	7	53	3628	3	p_an_g
panga	8	53	2353	3	p_anga
pangs	8	46	2866	3	p_angs
panicky	18	3	385	3	p_anicky
panicle	11	12	998	3	p_anicle
panicum	13	4	639	3	p_anicum
panier	8	44	2550	3	p_anier
panini	8	3	1427	3	p_anini
panino	8	3	1568	3	p_anino
panne	7	66	2365	3	p_anne
pans	6	58	5572	3	p_an_s
pansy	10	57	1797	3	p_ansy
pant	6	60	6125	3	p_an_t
pantie	8	43	2647	3	p_antie
panto	7	61	2941	3	p_anto
pants	7	65	3692	3	p_ants
panty	10	59	2930	3	p_anty
paranoic	12	4	983	3	paranoic
paris	7	51	4594	3	p_aris
patin	7	68	3285	3	p_atin
patio	7	44	2635	3	p_atio
pavid	11	57	1700	3	p_avid
pavin	10	56	2320	3	p_avin
pavis	10	64	2273	3	p_avis
paynim	13	3	736	3	paynim
pean	6	61	4717	3	pean__
peans	7	54	3764	3	pean_s
peanut	8	3	1818	3	peanut
pectic	12	29	1387	3	pectic
pedantic	13	4	658	3	pedantic
pelagic	12	3	786	3	pelagic
pelvic	13	30	755	3	pelvic
penis	7	51	2932	3	p_enis
penni	7	46	1790	3	penni_
pennia	8	44	1297	3	pennia
pennis	8	43	1574	3	pennis
peptic	12	21	1315	3	peptic
pernio	8	5	1314	3	pernio
phallic	14	4	729	3	phallic
phasis	11	46	1492	3	phasis
phenix	18	3	713	3	phenix
phobic	15	30	1006	3	phobic
phonics	14	31	1072	3	phonics
photic	13	33	1642	3	photic
phrenic	14	3	877	3	phrenic
phylic	16	27	955	3	phylic
physic	16	28	847	3	physic
pia	5	68	4803	3	pia___
piaffe	14	9	491	3	piaffe
pial	6	56	3670	3	pia__l
pianisms	12	4	901	3	pianisms
pianistic	13	4	716	3	pian~~ist~~ic
pianists	10	4	901	3	pianists
pias	6	65	4255	3	pia__s
piazza	16	4	382	3	piazza
piazze	16	3	468	3	piazze
pic	7	60	4682	3	p___ic
picante	11	3	1052	3	picante
picnicky	21	4	217	3	picnicky
pidgin	10	25	981	3	pidgin
pieing	9	39	1765	3	pieing
piggie	10	32	1077	3	piggie
piggin	10	31	1109	3	piggin
pignus	9	3	795	3	pignus
pignut	9	3	1157	3	pignut
piing	8	52	1883	3	piin_g
piki	10	65	2056	3	pi_ki_
piking	13	37	1964	3	piking
pikis	11	51	1639	3	pi_kis
pilei	7	40	2178	3	pilei_
pili	6	61	3035	3	pi_li_
piling	9	50	2559	3	piling
pilis	7	58	2520	3	pi_lis
pin	5	70	6672	3	pi_n__
pina	6	58	4263	3	pi_n_a
pinang	9	26	1159	3	pinang
pinangs	10	26	779	3	pinangs
pinas	7	54	3445	3	pi_nas
pinata	8	38	1721	3	pinata
pinch	12	56	1930	3	pi_nch
pine	6	77	5571	3	pi_n_e
pined	8	59	3532	3	pi_ned
pines	7	60	4886	3	pi_nes
piney	10	57	2750	3	pi_ney
ping	7	59	4359	3	pi_n_g
pingo	8	71	2271	3	pi_ngo
pings	8	58	3088	3	pi_ngs
pinier	8	40	2469	3	pi_nier
pining	9	37	2653	3	pi_ning
pinion	8	38	1589	3	pi_nion
pinite	8	3	2124	3	pi_nite
pink	10	70	3938	3	pi_n_k
pinkie	12	44	1427	3	pinkie
pinko	11	56	1825	3	pi_nko
pinks	11	57	2938	3	pi_nks
pinky	14	58	2340	3	pi_nky
pinna	7	53	2018	3	pi_nna
pinnace	11	35	1031	3	pinnace
pinnae	8	44	1464	3	pinnae
pinnal	8	48	1427	3	pinnal
pinnas	8	53	1551	3	pinnas
pinned	9	48	1838	3	pinned
pinner	8	45	2149	3	pinner
pinnies	9	33	1844	3	pinnies
pinning	10	34	1785	3	pinning
pinny	10	52	2206	3	pi_nny
pinon	7	60	2453	3	pi_non
pinot	7	87	3729	3	pi_not
pins	6	55	5845	3	pi_n_s
pint	6	69	6317	3	pi_n_t
pinta	7	57	2705	3	pi_nta
pinto	7	56	2575	3	pi_nto
pints	7	59	3622	3	pi_nts
pinup	9	6	1288	3	pi_nup
piny	9	118	3835	3	pi_n_y
pinyin	11	27	1061	3	pinyin
pion	6	72	3529	3	pion__
pions	7	58	2639	3	pion_s
piping	11	40	1745	3	piping
pipit	9	52	2487	3	pi_pit
pipkin	14	24	860	3	pipkin
pippin	9	28	1030	3	pippin
pirana	8	7	1326	3	piran_a
piranas	9	9	1260	3	piranas
piranha	12	12	636	3	piranha
pirn	6	71	2837	3	pirn__
pirns	7	60	2009	3	pirn_s
pistil	8	39	1507	3	pistil
pixie	14	54	1552	3	pi_xie
placid	11	40	1254	3	placid
plaice	10	3	1155	3	pla_ice
plaid	8	51	1830	3	pla_id
plain	7	48	2330	3	pla_in
plains	8	50	1959	3	plains
plaint	8	53	2320	3	plaint
plait	7	56	3157	3	pla_it
plan	6	58	3394	3	plan__
planar	8	42	1271	3	planar
planch	13	37	1144	3	planch
plane	7	49	2914	3	plan_e
planed	9	44	2091	3	planed
planer	8	41	2265	3	planer
planes	8	50	2808	3	planes
planet	8	42	2835	3	planet
planing	10	34	1825	3	planing
planish	12	4	1205	3	planish
plank	11	52	2114	3	plan_k
planks	12	41	1675	3	planks
plans	7	57	3127	3	plan_s
plant	7	54	3711	3	plan_t
plants	8	49	2180	3	plants
plasmic	13	24	911	3	plasmic
plastic	11	28	1506	3	plastic
platinic	12	3	707	3	platinic
platonic	12	3	877	3	platonic
pleonic	11	3	943	3	pleonic
pliancy	14	3	559	3	pliancy
pliant	8	39	1882	3	plian_t
poetic	10	4	1684	3	poetic
potamic	13	3	1085	3	potamic
practic	13	3	1224	3	practic
prance	10	43	1857	3	prance
prang	8	48	2032	3	pran_g
prangs	9	48	1623	3	prangs
prank	11	50	1945	3	pran_k
pranks	12	48	1472	3	pranks
praxis	15	40	1225	3	praxis
priapi	10	3	792	3	priapi_
psalmic	13	4	533	3	psalmic
psoatic	11	3	930	3	psoatic
ptotic	10	27	1336	3	ptotic
pubic	11	45	1371	3	p_ubic
public	12	23	814	3	public
pudic	10	46	1456	3	p_udic
puritanic	13	4	358	3	puritanic
pyaemic	16	4	587	3	pyaemic
pyemic	15	3	789	3	pyemic
pyic	11	69	1582	3	p__yic
pyknics	18	4	248	3	pyknics
pyric	12	38	1507	3	p_yric
quantic	18	27	906	3	quantic
quinic	17	31	947	3	quinic
rabic	9	38	1739	3	_rabic
rani	4	66	4010	3	_rani_
ranid	6	64	2933	3	_ranid
ranis	5	52	3583	3	_ranis
riant	5	58	3315	3	rian_t
runic	7	36	1577	3	_runic
salic	7	34	2471	3	_salic
satanic	9	3	993	3	satanic
scandic	12	3	700	3	scandic
scenic	10	5	1051	3	scenic
sciatic	11	9	1016	3	sciatic
sialid	7	3	1493	3	sialid
siganid	9	4	718	3	siganid
sonic	7	52	2528	3	_sonic
sphenic	14	4	909	3	sphenic
splenic	11	4	866	3	splenic
stannic	9	3	666	3	stannic
static	8	31	1867	3	static
tannic	8	28	1147	3	tannic
tetanic	9	8	1013	3	tetanic
thionic	12	3	887	3	thionic
titania	7	3	828	3	titania
tonic	7	47	2765	3	_tonic
tragic	9	38	1154	3	tragic
triadic	10	3	782	3	triadic
tunic	7	40	1822	3	_tunic
urania	6	25	1612	3	urania
uratic	8	30	1635	3	uratic
vatic	10	3	1642	3	_vatic
viand	9	5	1107	3	vian_d
viands	10	4	781	3	viands
viatica	12	4	586	3	viatica
vitric	11	25	1011	3	vitric
wienie	9	22	997	3	wienie
xenic	14	41	1464	3	_xenic
yonic	10	59	2084	3	_yonic
zinc	15	68	1909	3	zi_n_c
zincic	19	3	590	3	zincic
zinnia	15	3	601	3	zinnia

Search took 7 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.140	1276364.3
2	DLD Change Limit	112716	419	6.673	16891.4
3	Display Results	419	419	0.123	3406.5
	(SQL Overall)	178691	419	6.936	25762.8