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

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

406 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
lips	6	71	4144	(None)
blips	9	56	1578	1	blips
clips	9	60	1830	1	clips
dips	7	55	3691	1	dips
flips	10	51	1774	1	flips
gips	7	56	3292	1	gips
hips	9	64	3370	1	hips
kips	10	64	3051	1	kips
laps	6	68	4887	1	laps
libs	6	67	3275	1	libs
lids	5	63	3645	1	lids
lies	4	64	5419	1	lies
limps	9	55	2267	1	limps
lins	4	70	5905	1	lins
lip	5	147	5580	1	lip_
lipa	6	84	2592	1	lipa
lipe	6	68	3973	1	lipe
lis	3	71	6227	1	li_s
lisp	6	89	2687	1	lisp
lisps	7	69	1390	1	lisps
lits	4	62	5249	1	lits
lops	6	60	4335	1	lops
mips	8	55	3407	1	mips
nips	6	58	3092	1	nips
pips	8	58	3713	1	pips
rips	6	62	3743	1	rips
sips	6	57	4010	1	sips
slips	7	60	2372	1	slips
tips	6	64	3676	1	tips
yips	9	52	2669	1	yips
zips	15	57	2379	1	zips
aids	5	78	4635	2	aids
ails	4	56	5471	2	ails
aims	6	77	3818	2	aims
ains	4	61	5888	2	ains
airs	4	64	4742	2	airs
ais	3	90	8357	2	ai_s
aits	4	63	5553	2	aits
alias	5	58	3460	2	alias
alifs	8	61	2126	2	alifs
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	3815	2	bias
bibs	8	48	3097	2	bibs
bids	7	58	3842	2	bids
bigs	7	62	3501	2	bigs
bins	6	65	4824	2	bins
bios	6	63	3531	2	bios
bis	5	68	6065	2	bi_s
bits	6	61	4815	2	bits
blimps	12	58	815	2	blimps
blip	8	83	2277	2	blip_
bliss	7	56	1691	2	bliss
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	2510	2	cigs
cis	5	77	4803	2	ci_s
claps	9	56	2618	2	claps
clip	8	69	2400	2	clip_
clipt	9	63	2427	2	clipt
clops	9	59	2485	2	clops
cops	8	67	5137	2	cops
cups	8	54	3082	2	cups
daps	7	72	3916	2	daps
dibs	7	62	3367	2	dibs
dies	5	56	5352	2	dies
difs	8	60	2732	2	difs
digs	6	60	3605	2	digs
dims	7	54	3502	2	dims
dins	5	66	5204	2	dins
dip	6	78	4898	2	dip_
dipso	8	51	1155	2	dipso
dipt	7	73	3932	2	dipt
dis	4	64	5989	2	di_s
diss	5	64	3448	2	diss
dits	5	64	5052	2	dits
drips	8	54	1723	2	drips
dups	7	59	2951	2	dups
fibs	9	63	2949	2	fibs
fids	8	70	3473	2	fids
figs	8	53	3264	2	figs
fils	7	58	3869	2	fils
fins	7	58	4909	2	fins
firs	7	66	3771	2	firs
fits	7	60	4346	2	fits
flaps	10	56	2138	2	flaps
flics	10	54	1836	2	flics
flies	8	56	3071	2	flies
flip	9	63	2426	2	flip_
flirs	8	55	1893	2	flirs
flits	8	56	2522	2	flits
flops	10	59	2014	2	flops
fops	9	65	3268	2	fops
gaps	7	60	4297	2	gaps
gibs	7	55	2926	2	gibs
gids	6	59	3373	2	gids
gies	5	56	4142	2	gies
gigs	6	66	3118	2	gigs
gimps	10	59	1520	2	gimps
gins	5	55	4395	2	gins
gip	6	76	4536	2	gip_
gipsy	11	57	954	2	gipsy
gits	5	57	4459	2	gits
glias	6	46	1849	2	glias
glims	8	74	1767	2	glims
glops	8	56	1955	2	glops
grips	8	55	2013	2	grips
gyps	10	51	1502	2	gyps
haps	9	64	4346	2	haps
hies	7	48	4283	2	hies
hims	9	52	3097	2	hims
hins	7	64	4799	2	hins
hip	8	67	5043	2	hip_
his	6	63	5950	2	hi_s
hiss	7	56	2921	2	hiss
hits	7	55	4513	2	hits
hops	9	79	4263	2	hops
hyps	12	54	1841	2	hyps
ids	4	75	3546	2	_ids
ifs	6	71	2424	2	_ifs
ilks	8	72	1857	2	ilks
ills	4	70	3042	2	ills
imps	8	62	2111	2	imps
ins	3	59	4560	2	_ins
is	2	70	4821	2	_i_s
its	3	55	3883	2	_its
jibs	13	67	2407	2	jibs
jigs	12	65	2476	2	jigs
jins	11	56	3501	2	jins
keps	10	60	2730	2	keps
kids	9	60	2963	2	kids
kifs	11	60	2350	2	kifs
kins	8	57	4790	2	kins
kip	9	70	4213	2	kip_
kirs	8	58	3173	2	kirs
kis	7	80	5147	2	ki_s
kiss	8	52	2739	2	kiss
kits	8	64	4176	2	kits
kliks	8	39	882	2	kliks
kops	10	70	3129	2	kops
labs	6	71	4512	2	labs
lacs	6	69	4248	2	lacs
lads	5	65	4913	2	lads
lags	5	65	4622	2	lags
laics	7	64	1925	2	laics
lairs	5	54	2587	2	lairs
lamps	9	56	2483	2	lamps
lams	6	65	5226	2	lams
lap	5	85	6527	2	lap_
lapis	7	62	2315	2	lapis
lapse	7	49	1768	2	lapse
lars	4	69	5657	2	lars
las	3	72	8147	2	l_as
lass	4	74	4454	2	lass
lats	4	59	6270	2	lats
lavs	7	67	3415	2	lavs
laws	7	64	4168	2	laws
lays	7	60	4325	2	lays
leaps	7	55	2293	2	leaps
leas	4	59	5418	2	leas
lees	4	54	5588	2	lees
legs	5	61	3369	2	legs
leis	4	57	3960	2	leis
leks	8	54	2760	2	leks
lens	4	61	4649	2	lens
lept	6	64	4088	2	lept
les	3	56	6307	2	l_es
less	4	56	3510	2	less
lets	4	71	4794	2	lets
leys	7	64	3018	2	leys
li	2	99	4875	2	li__
liar	4	72	2968	2	liar
liars	5	47	2316	2	liars
lib	5	77	5026	2	li_b
lice	6	60	4506	2	lice
lich	9	62	3084	2	lich
lick	10	69	3507	2	lick
licks	11	53	2539	2	licks
lid	4	74	5351	2	li_d
lido	5	60	2815	2	lido
lidos	6	52	1988	2	lidos
lie	3	82	6452	2	li_e
lied	5	58	3809	2	lied
lief	7	60	3698	2	lief
lien	4	53	3980	2	lien
liens	5	65	2550	2	liens
lier	4	59	4246	2	lier
liers	5	51	3040	2	liers
lieu	4	65	3436	2	lieu
lieus	5	62	1848	2	lieus
life	7	54	3373	2	life
lift	7	69	4272	2	lift
lifts	8	57	1906	2	lifts
like	8	60	4084	2	like
likes	9	62	3190	2	likes
lilo	4	67	3156	2	lilo
lilos	5	58	2187	2	lilos
lilt	4	63	4994	2	lilt
lilts	5	58	2280	2	lilts
lily	7	67	3018	2	lily
lima	6	57	3413	2	lima
limas	7	56	2763	2	limas
limb	8	54	2937	2	limb
limbs	9	61	1893	2	limbs
lime	6	62	4493	2	lime
limes	7	56	3650	2	limes
limn	6	65	2769	2	limn
limns	7	57	1839	2	limns
limo	6	55	2973	2	limo
limos	7	53	2081	2	limos
limp	8	84	3249	2	limp
limpa	9	70	1446	2	limpa
limpas	10	55	1308	2	limpas
limpsy	13	51	684	2	limpsy
limy	9	57	2771	2	limy
lin	3	79	6737	2	li_n
line	4	69	6557	2	line
lines	5	70	5457	2	lines
ling	5	74	4796	2	ling
lings	6	71	3577	2	lings
link	8	69	4344	2	link
links	9	64	3019	2	links
linn	4	60	3459	2	linn
linns	5	61	2333	2	linns
lino	4	63	4337	2	lino
linos	5	56	3150	2	linos
lint	4	162	6623	2	lint
lints	5	71	3719	2	lints
liny	7	81	4132	2	liny
lion	4	63	3444	2	lion
lions	5	59	2321	2	lions
lipase	8	23	910	2	lipase
lipid	8	59	1617	2	lipid
lipids	9	43	1092	2	lipids
lipin	7	55	1889	2	lipin
lipins	8	50	1688	2	lipins
lippy	12	45	1190	2	lippy
lira	4	69	2868	2	lira
liras	5	60	2198	2	liras
lire	4	78	4529	2	lire
liri	4	51	2825	2	liri
list	4	70	5534	2	list
lists	5	66	2869	2	lists
lit	3	93	7731	2	li_t
litas	5	49	2377	2	litas
lite	4	70	5454	2	lite
litu	4	76	3156	2	litu
live	7	65	4099	2	live
lives	8	61	3319	2	lives
lobs	6	64	4108	2	lobs
logs	5	73	4311	2	logs
loids	6	62	2070	2	loids
loins	5	67	2842	2	loins
loops	7	57	2396	2	loops
loos	4	90	5112	2	loos
lop	5	82	5531	2	lop_
lope	6	59	4192	2	lope
lopes	7	64	3734	2	lopes
loss	4	53	3796	2	loss
lots	4	76	5209	2	lots
loups	7	53	1962	2	loups
lows	7	58	4301	2	lows
lues	4	59	4355	2	lues
lugs	5	52	3352	2	lugs
lumps	9	56	2498	2	lumps
lums	6	57	3424	2	lums
lupus	7	45	1252	2	lupus
luvs	7	58	1850	2	luvs
lyes	7	55	3083	2	lyes
maps	8	61	4104	2	maps
mibs	8	53	3046	2	mibs
mics	8	74	3514	2	mics
mids	7	65	4177	2	mids
migs	7	69	3531	2	migs
mils	6	60	4532	2	mils
mirs	6	69	4056	2	mirs
mis	5	81	6261	2	mi_s
miss	6	53	3941	2	miss
mops	8	59	4013	2	mops
naps	6	62	3858	2	naps
nibs	6	50	2830	2	nibs
nils	4	61	3245	2	nils
nims	6	62	2688	2	nims
nip	5	69	4598	2	nip_
nipa	6	94	2163	2	nipa
nipas	7	71	1667	2	nipas
nits	4	57	4164	2	nits
oils	4	63	3797	2	oils
olios	5	45	2085	2	olios
oops	6	52	3267	2	oops
ops	5	66	4125	2	_ops
oxlips	15	4	443	2	oxlips
paps	8	64	4345	2	paps
peps	8	51	3451	2	peps
pias	6	65	4255	2	pias
pics	8	56	3391	2	pics
pies	6	69	4960	2	pies
pigs	7	66	3422	2	pigs
pimps	11	46	1698	2	pimps
pins	6	55	5845	2	pins
pip	7	80	5104	2	pip_
pipe	8	64	3443	2	pipe
pipes	9	60	3014	2	pipes
pipy	11	54	2151	2	pipy
pis	5	63	6203	2	pi_s
piss	6	50	3333	2	piss
pits	6	63	4874	2	pits
plies	7	45	2651	2	plies
plops	9	59	2033	2	plops
pops	8	63	4095	2	pops
pups	8	60	3223	2	pups
qis	12	69	3438	2	qi_s
quips	16	47	1337	2	quips
raps	6	62	4773	2	raps
reps	6	59	3795	2	reps
rias	4	55	4059	2	rias
ribs	6	58	3301	2	ribs
rids	5	65	3954	2	rids
rifs	7	49	2900	2	rifs
rigs	5	51	3759	2	rigs
rims	6	59	3630	2	rims
rins	4	61	5319	2	rins
rip	5	68	5130	2	rip_
ripe	6	60	3892	2	ripe
ripes	7	54	3577	2	ripes
saps	6	53	4637	2	saps
ships	10	51	2377	2	ships
sibs	6	59	3353	2	sibs
sics	6	52	3409	2	sics
simps	9	47	1976	2	simps
sims	6	57	3717	2	sims
sins	4	67	5527	2	sins
sip	5	76	5601	2	sip_
sipe	6	73	4104	2	sipe
sipes	7	60	3695	2	sipes
sirs	4	43	3833	2	sirs
sis	3	73	6054	2	si_s
sits	4	50	5020	2	sits
skips	11	56	1660	2	skips
slaps	7	60	2571	2	slaps
slims	7	54	2365	2	slims
slip	6	70	3173	2	slip_
slipe	7	56	2613	2	slipe
slipes	8	49	2141	2	slipes
slipt	7	66	2748	2	slipt
slits	5	61	2885	2	slits
slops	7	50	2601	2	slops
snips	7	58	1801	2	snips
sops	6	52	4456	2	sops
sups	6	48	3443	2	sups
taps	6	60	5067	2	taps
tics	6	57	2963	2	tics
ties	4	52	4831	2	ties
tils	4	57	3961	2	tils
tins	4	52	5130	2	tins
tip	5	65	5122	2	tip_
tipi	6	99	2443	2	tipi
tipis	7	60	1992	2	tipis
tipsy	10	60	1050	2	tipsy
tis	3	70	5664	2	ti_s
tits	4	61	4503	2	tits
tops	6	62	4812	2	tops
trips	7	49	2336	2	trips
tulips	8	13	725	2	tulips
tups	6	56	2876	2	tups
umps	8	57	2194	2	umps
ups	5	56	2905	2	_ups
urps	6	69	2047	2	urps
vids	8	56	2753	2	vids
vies	7	52	3862	2	vies
vigs	8	54	2727	2	vigs
vims	9	54	2331	2	vims
vis	6	67	4761	2	vi_s
waps	9	66	4208	2	waps
whips	13	49	1708	2	whips
wigs	8	49	3125	2	wigs
wimps	12	52	1380	2	wimps
wins	7	59	4917	2	wins
wipe	9	48	3028	2	wipe
wipes	10	48	2708	2	wipes
wis	6	65	5233	2	wi_s
wisp	9	71	2407	2	wisp
wisps	10	52	1418	2	wisps
wiss	7	56	3054	2	wiss
wits	7	60	4487	2	wits
wops	9	66	3415	2	wops
xis	10	69	3533	2	xi_s
yaps	9	59	3352	2	yaps
yeps	9	59	2440	2	yeps
yids	8	52	2495	2	yids
yins	7	53	3512	2	yins
yip	8	72	4117	2	yip_
yipe	9	67	2217	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	2279	2	zigs
zins	13	57	3500	2	zins
zip	14	66	3622	2	zip_
zits	13	60	3029	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.080	2233637.5
2	DLD Change Limit	29872	406	0.920	32469.6
3	Display Results	406	406	0.093	4365.6
	(SQL Overall)	178691	406	1.093	163486.7