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

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

348 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
kips	10	64	3051	(None)
dips	7	55	3691	1	dips
gips	7	56	3292	1	gips
hips	9	64	3370	1	hips
keps	10	60	2730	1	keps
kids	9	60	2963	1	kids
kifs	11	60	2350	1	kifs
kins	8	57	4790	1	kins
kip	9	70	4213	1	kip_
kirs	8	58	3173	1	kirs
kis	7	80	5147	1	ki_s
kiss	8	52	2739	1	kiss
kits	8	64	4176	1	kits
kops	10	70	3129	1	kops
lips	6	71	4144	1	lips
mips	8	55	3408	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
skips	11	56	1660	1	skips
tips	6	64	3676	1	tips
yips	9	52	2670	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
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	3816	2	bias
bibs	8	48	3099	2	bibs
bids	7	58	3843	2	bids
bigs	7	62	3502	2	bigs
bins	6	65	4825	2	bins
bios	6	63	3532	2	bios
bis	5	68	6066	2	bi_s
bits	6	61	4816	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	2510	2	cigs
cis	5	77	4803	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	3368	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	2950	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
flips	10	51	1774	2	flips
fops	9	65	3268	2	fops
gaps	7	60	4297	2	gaps
gibs	7	55	2927	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
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
imps	8	62	2112	2	imps
ins	3	59	4560	2	_ins
is	2	70	4821	2	_i_s
its	3	55	3883	2	_its
jibs	13	67	2408	2	jibs
jigs	12	65	2476	2	jigs
jins	11	56	3501	2	jins
kaas	8	65	3184	2	kaas
kabs	10	71	3084	2	kabs
kaes	8	57	3406	2	kaes
kafs	11	64	2374	2	kafs
kaifs	12	57	1564	2	kaifs
kails	9	55	2521	2	kails
kains	9	61	2564	2	kains
kapa	10	60	2129	2	kapa
kapas	11	60	2173	2	kapas
kaph	13	58	1575	2	kaph
kaphs	14	49	1150	2	kaphs
kas	7	70	5858	2	k_as
kats	8	59	4433	2	kats
kays	11	60	3219	2	kays
keas	8	63	3709	2	keas
keeps	11	60	2028	2	keeps
kefs	11	59	2274	2	kefs
kegs	9	58	2401	2	kegs
keirs	9	53	1367	2	keirs
kelps	11	51	1642	2	kelps
kemps	13	50	1252	2	kemps
kens	8	54	3523	2	kens
kep	9	64	3720	2	kep_
kepi	10	53	1563	2	kepi
kepis	11	53	1336	2	kepis
kept	10	62	3294	2	kept
keys	11	63	2216	2	keys
khis	11	70	1798	2	khis
ki	6	75	3795	2	ki__
kibe	10	65	2344	2	kibe
kibes	11	55	2111	2	kibes
kick	9	60	2606	2	kick
kicks	10	44	2008	2	kicks
kid	8	65	4061	2	ki_d
kief	11	71	2840	2	kief
kiefs	12	61	1220	2	kiefs
kier	8	65	2680	2	kier
kiers	9	53	2009	2	kiers
kif	10	59	4118	2	ki_f
kike	7	65	2478	2	kike
kikes	8	51	2255	2	kikes
kill	8	55	3317	2	kill
kills	9	45	2617	2	kills
kiln	8	56	2097	2	kiln
kilns	9	51	1298	2	kilns
kilo	8	60	2866	2	kilo
kilos	9	50	2147	2	kilos
kilt	8	61	4441	2	kilt
kilts	9	51	2218	2	kilts
kin	7	63	5396	2	ki_n
kina	8	56	3199	2	kina
kinas	9	56	2691	2	kinas
kind	9	61	2855	2	kind
kinds	10	62	2181	2	kinds
kine	8	56	4342	2	kine
kines	9	50	3913	2	kines
king	9	59	3365	2	king
kings	10	58	2556	2	kings
kink	7	60	3439	2	kink
kinks	8	49	2608	2	kinks
kino	8	62	3361	2	kino
kinos	9	66	2614	2	kinos
kiosk	8	3	623	2	kiosk
kir	7	65	3567	2	ki_r
kirk	7	62	2156	2	kirk
kirks	8	49	1526	2	kirks
kirn	8	71	2343	2	kirn
kirns	9	53	1545	2	kirns
kissy	12	55	1031	2	kissy
kist	8	65	4079	2	kist
kists	9	58	2211	2	kists
kit	7	85	5987	2	ki_t
kite	8	53	3823	2	kite
kites	9	54	3254	2	kites
kith	11	58	2635	2	kith
kiths	12	58	1497	2	kiths
kiva	11	65	1640	2	kiva
kivas	12	46	1473	2	kivas
kiwi	11	32	1179	2	kiwi
kiwis	12	32	858	2	kiwis
kliks	8	39	882	2	kliks
knaps	11	55	1117	2	knaps
knits	9	39	1474	2	knits
knops	11	59	1181	2	knops
koas	8	56	3509	2	koas
kobs	10	58	3108	2	kobs
kois	8	51	2940	2	kois
kop	9	74	4020	2	kop_
koph	13	58	1654	2	koph
kophs	14	50	1093	2	kophs
kors	8	59	3301	2	kors
kos	7	69	4482	2	k_os
koss	8	52	2481	2	koss
kris	8	64	2360	2	kris
kues	8	64	2677	2	kues
kvas	11	70	1594	2	kvas
kyes	11	51	2493	2	kyes
laps	6	68	4887	2	laps
libs	6	67	3276	2	libs
lids	5	63	3645	2	lids
lies	4	64	5419	2	lies
limps	9	55	2267	2	limps
lins	4	70	5905	2	lins
lip	5	147	5580	2	lip_
lipa	6	84	2592	2	lipa
lipe	6	68	3973	2	lipe
lis	3	71	6227	2	li_s
lisp	6	89	2688	2	lisp
lisps	7	69	1391	2	lisps
lits	4	62	5249	2	lits
lops	6	60	4335	2	lops
maps	8	61	4105	2	maps
mibs	8	53	3048	2	mibs
mics	8	74	3515	2	mics
mids	7	65	4178	2	mids
migs	7	69	3532	2	migs
mils	6	60	4533	2	mils
mirs	6	69	4057	2	mirs
mis	5	81	6262	2	mi_s
miss	6	53	3942	2	miss
mops	8	59	4013	2	mops
naps	6	62	3858	2	naps
nibs	6	50	2831	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
oops	6	52	3267	2	oops
ops	5	66	4125	2	_ops
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
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	3302	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	3354	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
skeps	11	56	1425	2	skeps
skids	10	46	1532	2	skids
skies	9	50	2683	2	skies
skimps	14	48	804	2	skimps
skims	11	45	1719	2	skims
skins	9	47	2346	2	skins
skip	10	54	2175	2	skip_
skis	8	48	2529	2	ski_s
skits	9	47	2186	2	skits
slips	7	60	2372	2	slips
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	4504	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	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	4118	2	yip_
yipe	9	67	2218	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 3 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.110	1624463.6
2	DLD Change Limit	29872	348	2.203	13559.7
3	Display Results	348	348	0.156	2230.8
	(SQL Overall)	178691	348	2.469	72373.8