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

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

399 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
pics	8	56	3392	(None)
epics	9	50	1428	1	epics
mics	8	74	3516	1	mics
pacs	8	58	4218	1	pacs
pecs	8	46	3410	1	pecs
pias	6	65	4256	1	pias
pic	7	60	4683	1	pic_
pica	8	58	3150	1	pica
picas	9	46	2652	1	picas
pice	8	46	4110	1	pice
pick	12	59	3382	1	pick
picks	13	52	2614	1	picks
pies	6	69	4961	1	pies
pigs	7	66	3423	1	pigs
pins	6	55	5846	1	pins
pips	8	58	3714	1	pips
pis	5	63	6204	1	pi_s
piss	6	50	3334	1	piss
pits	6	63	4875	1	pits
sics	6	52	3410	1	sics
spics	9	41	2324	1	spics
tics	6	57	2964	1	tics
aids	5	78	4637	2	aids
ails	4	56	5472	2	ails
aims	6	77	3819	2	aims
ains	4	61	5889	2	ains
airs	4	64	4743	2	airs
ais	3	90	8358	2	ai_s
aits	4	63	5554	2	aits
apices	10	49	1626	2	apices
arcs	6	78	3478	2	arcs
aspics	10	42	1156	2	aspics
bias	6	47	3817	2	bias
bibs	8	48	3100	2	bibs
bice	8	62	3557	2	bice
bices	9	50	2996	2	bices
bids	7	58	3846	2	bids
bigs	7	62	3503	2	bigs
bins	6	65	4826	2	bins
bios	6	63	3533	2	bios
bis	5	68	6067	2	bi_s
bits	6	61	4817	2	bits
chics	12	39	2094	2	chics
cigs	7	56	2511	2	cigs
cis	5	77	4804	2	ci_s
dibs	7	62	3369	2	dibs
dice	7	58	4190	2	dice
dices	8	64	3424	2	dices
dick	11	64	3239	2	dick
dicks	12	58	2469	2	dicks
dies	5	56	5353	2	dies
difs	8	60	2733	2	difs
digs	6	60	3606	2	digs
dims	7	54	3503	2	dims
dins	5	66	5205	2	dins
dips	7	55	3692	2	dips
dis	4	64	5990	2	di_s
disc	7	61	2324	2	disc
discs	8	53	1626	2	discs
diss	5	64	3449	2	diss
dits	5	64	5053	2	dits
docs	7	56	3115	2	docs
epic	8	69	2130	2	epic_
fibs	9	63	2951	2	fibs
fice	9	57	3712	2	fice
fices	10	60	3116	2	fices
fico	9	58	2460	2	fico
ficus	10	50	1549	2	ficus
fids	8	70	3475	2	fids
figs	8	53	3265	2	figs
fils	7	58	3870	2	fils
fins	7	58	4910	2	fins
firs	7	66	3772	2	firs
fisc	9	68	1976	2	fisc
fiscs	10	53	1188	2	fiscs
fits	7	60	4347	2	fits
flics	10	54	1836	2	flics
gibs	7	55	2928	2	gibs
gids	6	59	3375	2	gids
gies	5	56	4143	2	gies
gigs	6	66	3119	2	gigs
gins	5	55	4396	2	gins
gips	7	56	3293	2	gips
gits	5	57	4460	2	gits
hic	8	65	4057	2	hic_
hick	13	55	3031	2	hick
hicks	14	53	2217	2	hicks
hies	7	48	4284	2	hies
hims	9	52	3098	2	hims
hins	7	64	4800	2	hins
hips	9	64	3371	2	hips
his	6	63	5951	2	hi_s
hiss	7	56	2922	2	hiss
hits	7	55	4514	2	hits
ice	5	67	3725	2	_ice
ices	6	61	2964	2	_ices
ich	8	62	2775	2	_ich
ichs	9	62	1471	2	_ichs
ick	9	73	2933	2	_ick
icy	8	63	2213	2	_icy
ids	4	75	3548	2	_ids
ifs	6	71	2425	2	_ifs
ins	3	59	4561	2	_ins
is	2	70	4822	2	_i_s
its	3	55	3884	2	_its
jibs	13	67	2409	2	jibs
jigs	12	65	2477	2	jigs
jins	11	56	3502	2	jins
kick	9	60	2608	2	kick
kicks	10	44	2009	2	kicks
kids	9	60	2965	2	kids
kifs	11	60	2352	2	kifs
kins	8	57	4792	2	kins
kips	10	64	3053	2	kips
kirs	8	58	3175	2	kirs
kis	7	80	5149	2	ki_s
kiss	8	52	2741	2	kiss
kits	8	64	4178	2	kits
lacs	6	69	4248	2	lacs
laics	7	64	1925	2	laics
libs	6	67	3277	2	libs
lice	6	60	4507	2	lice
lich	9	62	3085	2	lich
lick	10	69	3508	2	lick
licks	11	53	2539	2	licks
lids	5	63	3647	2	lids
lies	4	64	5420	2	lies
lins	4	70	5906	2	lins
lips	6	71	4145	2	lips
lis	3	71	6228	2	li_s
lits	4	62	5250	2	lits
macs	8	67	4251	2	macs
mibs	8	53	3049	2	mibs
mic	7	76	4765	2	mic_
mica	8	64	2826	2	mica
micas	9	68	2305	2	micas
mice	8	74	4224	2	mice
mick	12	63	3344	2	mick
micks	13	55	2537	2	micks
mids	7	65	4180	2	mids
migs	7	69	3533	2	migs
mils	6	60	4534	2	mils
mips	8	55	3409	2	mips
mirs	6	69	4058	2	mirs
mis	5	81	6263	2	mi_s
miss	6	53	3943	2	miss
mocs	8	58	3490	2	mocs
mycs	11	53	1429	2	mycs
nibs	6	50	2832	2	nibs
nice	6	55	3472	2	nice
nick	10	66	2761	2	nick
nicks	11	49	2049	2	nicks
nils	4	61	3246	2	nils
nims	6	62	2689	2	nims
nips	6	58	3093	2	nips
nits	4	57	4165	2	nits
oils	4	63	3798	2	oils
optics	10	28	1018	2	optics
orcs	6	70	2543	2	orcs
pac	7	90	5408	2	pac_
paca	8	51	3224	2	paca
pacas	9	60	2940	2	pacas
pace	8	63	4577	2	pace
paces	9	67	4111	2	paces
pack	12	55	3544	2	pack
packs	13	55	2893	2	packs
pact	8	66	4872	2	pact
pacts	9	51	2580	2	pacts
pacy	11	53	2868	2	pacy
pads	7	67	4296	2	pads
paiks	11	47	1985	2	paiks
pails	7	58	3306	2	pails
pains	7	51	3828	2	pains
pairs	7	53	2583	2	pairs
pals	6	69	5135	2	pals
pams	8	56	4176	2	pams
panics	10	38	1536	2	panics
pans	6	58	5573	2	pans
paps	8	64	4345	2	paps
pars	6	75	6079	2	pars
pas	5	87	7574	2	p_as
pass	6	52	3995	2	pass
pats	6	64	6085	2	pats
paws	9	60	3818	2	paws
pays	9	59	4022	2	pays
peas	6	57	5506	2	peas
pec	7	67	4441	2	pec_
pech	11	61	2545	2	pech
pechs	12	55	1620	2	pechs
peck	12	57	3068	2	peck
pecks	13	57	2443	2	pecks
peds	7	58	3525	2	peds
pees	6	52	5737	2	pees
pegs	7	55	3176	2	pegs
pehs	9	56	2576	2	pehs
peins	7	61	2806	2	peins
pens	6	56	4964	2	pens
peps	8	51	3451	2	peps
pes	5	72	5978	2	p_es
pets	6	62	4833	2	pets
pews	9	57	3153	2	pews
phis	9	57	2490	2	phis
pi	4	81	4537	2	pi__
pia	5	68	4804	2	pi_a
pial	6	56	3671	2	pial
pian	6	61	3610	2	pian
pians	7	51	2696	2	pians
pical	9	55	2437	2	pical
picky	16	54	1694	2	picky
picot	9	50	3101	2	picot
picots	10	46	1644	2	picots
picul	9	50	1536	2	picul
piculs	10	35	1175	2	piculs
pie	5	54	5741	2	pi_e
piece	9	67	1799	2	piece
pieces	10	42	1727	2	pieces
pied	7	50	3537	2	pied
pier	6	60	3530	2	pier
piers	7	59	2633	2	piers
pig	6	57	4498	2	pi_g
pika	10	63	2296	2	pika
pikas	11	42	1809	2	pikas
pike	10	63	3522	2	pike
pikes	11	50	3103	2	pikes
piki	10	65	2057	2	piki
pikis	11	51	1639	2	pikis
pile	6	56	4970	2	pile
piles	7	47	4261	2	piles
pili	6	61	3036	2	pili
pilis	7	58	2520	2	pilis
pill	6	53	3947	2	pill
pills	7	41	3097	2	pills
pilus	7	59	2106	2	pilus
pily	9	61	3274	2	pily
pima	8	54	2866	2	pima
pimas	9	47	2510	2	pimas
pimp	10	60	2491	2	pimp
pimps	11	46	1698	2	pimps
pin	5	70	6673	2	pi_n
pina	6	58	4264	2	pina
pinas	7	54	3445	2	pinas
pinch	12	56	1930	2	pinch
pine	6	77	5572	2	pine
pines	7	60	4886	2	pines
ping	7	59	4360	2	ping
pings	8	58	3088	2	pings
pink	10	70	3939	2	pink
pinks	11	57	2938	2	pinks
pint	6	69	6318	2	pint
pints	7	59	3622	2	pints
piny	9	118	3836	2	piny
pion	6	72	3530	2	pion
pions	7	58	2639	2	pions
pious	7	46	2127	2	pious
pip	7	80	5105	2	pi_p
pipe	8	64	3444	2	pipe
pipes	9	60	3014	2	pipes
pipy	11	54	2152	2	pipy
pirn	6	71	2838	2	pirn
pirns	7	60	2009	2	pirns
pisco	9	63	1498	2	pisco
piscos	10	51	1259	2	piscos
pish	9	61	2792	2	pish
piso	6	67	2757	2	piso
pisos	7	60	2106	2	pisos
pit	5	64	7193	2	pi_t
pita	6	54	3644	2	pita
pitas	7	74	2767	2	pitas
pitch	12	50	1841	2	pitch
pith	9	54	3270	2	pith
piths	10	58	1754	2	piths
pity	9	60	3194	2	pity
piu	5	66	3955	2	pi_u
pix	12	64	3794	2	pi_x
pixes	14	43	2317	2	pixes
pixy	16	61	1777	2	pixy
plica	9	6	1337	2	plica
plies	7	45	2651	2	plies
plus	6	63	2483	2	plus
pock	12	61	2929	2	pock
pocks	13	50	2296	2	pocks
poco	8	68	2615	2	poco
pods	7	65	4016	2	pods
pois	6	65	3904	2	pois
pols	6	60	4456	2	pols
poms	8	70	3774	2	poms
pons	6	58	5060	2	pons
poos	6	59	4911	2	poos
pops	8	63	4095	2	pops
pots	6	64	5236	2	pots
pows	9	55	3766	2	pows
price	9	37	2541	2	price
prices	10	45	2454	2	prices
prick	13	43	1750	2	prick
pricks	14	44	1426	2	pricks
pricy	12	48	1456	2	pricy
pries	7	43	3953	2	pries
prigs	8	52	1970	2	prigs
prims	9	54	2593	2	prims
priss	7	46	2389	2	priss
pros	6	57	4278	2	pros
psis	6	81	2034	2	psis
pubs	8	50	2921	2	pubs
puce	8	51	2788	2	puce
puces	9	49	2463	2	puces
puck	12	49	2794	2	puck
pucks	13	43	2210	2	pucks
puds	7	56	3052	2	puds
pugs	7	63	3277	2	pugs
puls	6	54	3756	2	puls
puns	6	66	4148	2	puns
pups	8	60	3223	2	pups
purs	6	56	4104	2	purs
pus	5	55	4784	2	p_us
puss	6	48	3013	2	puss
puts	6	56	4175	2	puts
pyas	9	62	2570	2	pyas
pyes	9	55	2899	2	pyes
pyic	11	69	1582	2	pyic_
pyins	10	58	1586	2	pyins
qis	12	69	3439	2	qi_s
recs	6	57	3418	2	recs
rias	4	55	4060	2	rias
ribs	6	58	3303	2	ribs
rice	6	49	4292	2	rice
rices	7	55	3615	2	rices
rich	9	70	2555	2	rich
rick	10	73	3466	2	rick
ricks	11	51	2613	2	ricks
rids	5	65	3956	2	rids
rifs	7	49	2901	2	rifs
rigs	5	51	3760	2	rigs
rims	6	59	3631	2	rims
rins	4	61	5320	2	rins
rips	6	62	3744	2	rips
rocs	6	55	3366	2	rocs
sacs	6	57	3907	2	sacs
secs	6	50	3389	2	secs
sibs	6	59	3355	2	sibs
sic	5	58	4788	2	sic_
sice	6	55	4560	2	sice
sices	7	56	3727	2	sices
sick	10	64	3558	2	sick
sicks	11	51	2762	2	sicks
sims	6	57	3718	2	sims
sins	4	67	5528	2	sins
sips	6	57	4011	2	sips
sirs	4	43	3834	2	sirs
sis	3	73	6055	2	si_s
sits	4	50	5021	2	sits
specs	9	69	1667	2	specs
spic	8	52	2743	2	spic_
spica	9	47	1794	2	spica
spicas	10	47	1582	2	spicas
spice	9	55	2881	2	spice
spices	10	43	2603	2	spices
spick	13	45	1907	2	spick
spicks	14	48	1499	2	spicks
spicy	12	54	1771	2	spicy
spies	7	60	3762	2	spies
spiks	11	41	1747	2	spiks
spins	7	53	2798	2	spins
spits	7	44	2955	2	spits
spivs	10	51	1424	2	spivs
tic	5	63	4347	2	tic_
tick	10	62	3123	2	tick
ticks	11	58	2329	2	ticks
ties	4	52	4832	2	ties
tils	4	57	3962	2	tils
tins	4	52	5131	2	tins
tips	6	64	3677	2	tips
tis	3	70	5665	2	ti_s
tits	4	61	4505	2	tits
topics	10	47	1458	2	topics
vacs	9	62	2620	2	vacs
vice	9	57	3286	2	vice
vices	10	57	2553	2	vices
vids	8	56	2755	2	vids
vies	7	52	3863	2	vies
vigs	8	54	2728	2	vigs
vims	9	54	2332	2	vims
vis	6	67	4762	2	vi_s
wich	12	57	2475	2	wich
wick	13	57	2631	2	wick
wicks	14	46	1936	2	wicks
wigs	8	49	3126	2	wigs
wins	7	59	4918	2	wins
wis	6	65	5234	2	wi_s
wiss	7	56	3055	2	wiss
wits	7	60	4488	2	wits
xis	10	69	3534	2	xi_s
yids	8	52	2497	2	yids
yins	7	53	3513	2	yins
yips	9	52	2671	2	yips
zigs	14	54	2280	2	zigs
zincs	16	53	1293	2	zincs
zins	13	57	3501	2	zins
zips	15	57	2380	2	zips
zits	13	60	3030	2	zits

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	29872	0.283	631417.0
2	DLD Change Limit	29872	399	0.920	32469.6
3	Display Results	399	399	0.110	3627.3
	(SQL Overall)	178691	399	1.313	136093.7