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

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

403 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
pips	8	58	3714	(None)
dips	7	55	3692	1	dips
gips	7	56	3293	1	gips
hips	9	64	3371	1	hips
kips	10	64	3053	1	kips
lips	6	71	4145	1	lips
mips	8	55	3409	1	mips
nips	6	58	3093	1	nips
paps	8	64	4345	1	paps
peps	8	51	3451	1	peps
pias	6	65	4256	1	pias
pics	8	56	3392	1	pics
pies	6	69	4961	1	pies
pigs	7	66	3423	1	pigs
pimps	11	46	1698	1	pimps
pins	6	55	5846	1	pins
pip	7	80	5105	1	pip_
pipe	8	64	3444	1	pipe
pipes	9	60	3014	1	pipes
pipy	11	54	2152	1	pipy
pis	5	63	6204	1	pi_s
piss	6	50	3334	1	piss
pits	6	63	4875	1	pits
pops	8	63	4095	1	pops
pups	8	60	3223	1	pups
rips	6	62	3744	1	rips
sips	6	57	4011	1	sips
tips	6	64	3677	1	tips
yips	9	52	2671	1	yips
zips	15	57	2380	1	zips
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
alps	6	55	2924	2	alps
amps	8	62	3034	2	amps
apps	8	63	1969	2	apps
asps	6	56	2209	2	asps
baps	8	60	4084	2	baps
bias	6	47	3817	2	bias
bibs	8	48	3100	2	bibs
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
blips	9	56	1578	2	blips
bops	8	60	3798	2	bops
caps	8	71	4789	2	caps
ceps	8	61	2595	2	ceps
chips	12	57	2125	2	chips
cigs	7	56	2511	2	cigs
cis	5	77	4804	2	ci_s
clips	9	60	1830	2	clips
cops	8	67	5137	2	cops
cups	8	54	3082	2	cups
daps	7	72	3916	2	daps
dibs	7	62	3369	2	dibs
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
dip	6	78	4899	2	dip_
dipso	8	51	1155	2	dipso
dipt	7	73	3933	2	dipt
dis	4	64	5990	2	di_s
diss	5	64	3449	2	diss
dits	5	64	5053	2	dits
drips	8	54	1723	2	drips
dups	7	59	2951	2	dups
epics	9	50	1428	2	epics
fibs	9	63	2951	2	fibs
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
fits	7	60	4347	2	fits
flips	10	51	1774	2	flips
fops	9	65	3268	2	fops
gaps	7	60	4297	2	gaps
gibs	7	55	2928	2	gibs
gids	6	59	3375	2	gids
gies	5	56	4143	2	gies
gigs	6	66	3119	2	gigs
gimps	10	59	1520	2	gimps
gins	5	55	4396	2	gins
gip	6	76	4537	2	gip_
gipsy	11	57	954	2	gipsy
gits	5	57	4460	2	gits
grips	8	55	2013	2	grips
gyps	10	51	1502	2	gyps
haps	9	64	4346	2	haps
hies	7	48	4284	2	hies
hims	9	52	3098	2	hims
hins	7	64	4800	2	hins
hip	8	67	5044	2	hip_
his	6	63	5951	2	hi_s
hiss	7	56	2922	2	hiss
hits	7	55	4514	2	hits
hops	9	79	4263	2	hops
hyps	12	54	1841	2	hyps
ids	4	75	3548	2	_ids
ifs	6	71	2425	2	_ifs
imps	8	62	2112	2	imps
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
keps	10	60	2731	2	keps
kids	9	60	2965	2	kids
kifs	11	60	2352	2	kifs
kins	8	57	4792	2	kins
kip	9	70	4215	2	kip_
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
kops	10	70	3130	2	kops
laps	6	68	4887	2	laps
libs	6	67	3277	2	libs
lids	5	63	3647	2	lids
lies	4	64	5420	2	lies
limps	9	55	2267	2	limps
lins	4	70	5906	2	lins
lip	5	147	5581	2	lip_
lipa	6	84	2593	2	lipa
lipe	6	68	3974	2	lipe
lis	3	71	6228	2	li_s
lisp	6	89	2689	2	lisp
lisps	7	69	1391	2	lisps
lits	4	62	5250	2	lits
lops	6	60	4335	2	lops
maps	8	61	4105	2	maps
mibs	8	53	3049	2	mibs
mics	8	74	3516	2	mics
mids	7	65	4180	2	mids
migs	7	69	3533	2	migs
mils	6	60	4534	2	mils
mirs	6	69	4058	2	mirs
mis	5	81	6263	2	mi_s
miss	6	53	3943	2	miss
mops	8	59	4013	2	mops
naps	6	62	3858	2	naps
nibs	6	50	2832	2	nibs
nils	4	61	3246	2	nils
nims	6	62	2689	2	nims
nip	5	69	4599	2	nip_
nipa	6	94	2164	2	nipa
nipas	7	71	1667	2	nipas
nits	4	57	4165	2	nits
oils	4	63	3798	2	oils
oops	6	52	3267	2	oops
ops	5	66	4125	2	_ops
pacs	8	58	4218	2	pacs
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
palps	9	47	1956	2	palps
pals	6	69	5135	2	pals
pams	8	56	4176	2	pams
pans	6	58	5573	2	pans
pap	7	67	5840	2	pap_
papa	8	58	2714	2	papa
papas	9	49	2749	2	papas
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
pecs	8	46	3410	2	pecs
peds	7	58	3525	2	peds
peeps	9	58	2236	2	peeps
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
pep	7	64	4708	2	pep_
pepo	8	76	2215	2	pepo
pepos	9	66	2008	2	pepos
perps	9	55	2148	2	perps
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
pic	7	60	4683	2	pi_c
pica	8	58	3150	2	pica
picas	9	46	2652	2	picas
pice	8	46	4110	2	pice
pick	12	59	3382	2	pick
picks	13	52	2614	2	picks
pie	5	54	5741	2	pi_e
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
pin	5	70	6673	2	pi_n
pina	6	58	4264	2	pina
pinas	7	54	3445	2	pinas
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
pinups	10	3	741	2	pinups
piny	9	118	3836	2	piny
pion	6	72	3530	2	pion
pions	7	58	2639	2	pions
pious	7	46	2127	2	pious
pipal	9	51	1835	2	pipal
pipals	10	42	1364	2	pipals
piped	10	51	2316	2	piped
piper	9	65	2319	2	piper
pipers	10	43	1866	2	pipers
pipet	9	55	3332	2	pipet
pipets	10	57	1477	2	pipets
pipit	9	52	2487	2	pipit
pipits	10	47	1306	2	pipits
pirn	6	71	2838	2	pirn
pirns	7	60	2009	2	pirns
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
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
plies	7	45	2651	2	plies
plops	9	59	2033	2	plops
plus	6	63	2483	2	plus
pods	7	65	4016	2	pods
pois	6	65	3904	2	pois
pols	6	60	4456	2	pols
pomps	11	53	1619	2	pomps
poms	8	70	3774	2	poms
pons	6	58	5060	2	pons
poops	9	44	2241	2	poops
poos	6	59	4911	2	poos
pop	7	62	5225	2	pop_
pope	8	55	3561	2	pope
popes	9	59	3381	2	popes
popsy	12	57	1340	2	popsy
pots	6	64	5236	2	pots
pows	9	55	3766	2	pows
preps	9	62	2069	2	preps
pries	7	43	3953	2	pries
prigs	8	52	1970	2	prigs
primps	12	47	1182	2	primps
prims	9	54	2593	2	prims
priss	7	46	2389	2	priss
props	9	57	2688	2	props
pros	6	57	4278	2	pros
psis	6	81	2034	2	psis
pubs	8	50	2921	2	pubs
puds	7	56	3052	2	puds
pugs	7	63	3277	2	pugs
pulps	9	51	1648	2	pulps
puls	6	54	3756	2	puls
pumps	11	55	2060	2	pumps
puns	6	66	4148	2	puns
pup	7	63	3988	2	pup_
pupa	8	54	2281	2	pupa
pupas	9	52	1928	2	pupas
pupu	8	76	2071	2	pupu
pupus	9	46	1404	2	pupus
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
pyins	10	58	1586	2	pyins
qis	12	69	3439	2	qi_s
quips	16	47	1337	2	quips
raps	6	62	4773	2	raps
reps	6	59	3795	2	reps
rias	4	55	4060	2	rias
ribs	6	58	3303	2	ribs
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
rip	5	68	5131	2	rip_
ripe	6	60	3893	2	ripe
ripes	7	54	3577	2	ripes
saps	6	53	4637	2	saps
ships	10	51	2377	2	ships
sibs	6	59	3355	2	sibs
sics	6	52	3410	2	sics
simps	9	47	1976	2	simps
sims	6	57	3718	2	sims
sins	4	67	5528	2	sins
sip	5	76	5602	2	sip_
sipe	6	73	4105	2	sipe
sipes	7	60	3695	2	sipes
sirs	4	43	3834	2	sirs
sis	3	73	6055	2	si_s
sits	4	50	5021	2	sits
skips	11	56	1661	2	skips
slips	7	60	2372	2	slips
snips	7	58	1801	2	snips
sops	6	52	4456	2	sops
spics	9	41	2324	2	spics
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
sups	6	48	3443	2	sups
taps	6	60	5068	2	taps
tics	6	57	2964	2	tics
ties	4	52	4832	2	ties
tils	4	57	3962	2	tils
tins	4	52	5131	2	tins
tip	5	65	5123	2	tip_
tipi	6	99	2444	2	tipi
tipis	7	60	1992	2	tipis
tipsy	10	60	1050	2	tipsy
tis	3	70	5665	2	ti_s
tits	4	61	4505	2	tits
tops	6	62	4812	2	tops
trips	7	49	2336	2	trips
tups	6	56	2876	2	tups
umps	8	57	2194	2	umps
ups	5	56	2905	2	_ups
urps	6	69	2048	2	urps
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
waps	9	66	4208	2	waps
whips	13	49	1708	2	whips
wigs	8	49	3126	2	wigs
wimps	12	52	1380	2	wimps
wins	7	59	4918	2	wins
wipe	9	48	3029	2	wipe
wipes	10	48	2708	2	wipes
wis	6	65	5234	2	wi_s
wisp	9	71	2408	2	wisp
wisps	10	52	1418	2	wisps
wiss	7	56	3055	2	wiss
wits	7	60	4488	2	wits
wops	9	66	3415	2	wops
xis	10	69	3534	2	xi_s
yaps	9	59	3352	2	yaps
yeps	9	59	2440	2	yeps
yids	8	52	2497	2	yids
yins	7	53	3513	2	yins
yip	8	72	4119	2	yip_
yipe	9	67	2219	2	yipe
yipes	10	60	1784	2	yipes
yups	9	61	2160	2	yups
zaps	15	68	2689	2	zaps
zeps	15	60	1934	2	zeps
zigs	14	54	2280	2	zigs
zins	13	57	3501	2	zins
zip	14	66	3623	2	zip_
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.293	609866.9
2	DLD Change Limit	29872	403	0.893	33451.3
3	Display Results	403	403	0.093	4333.3
	(SQL Overall)	178691	403	1.279	139711.5