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

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

361 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
zits	13	60	3030	(None)
aits	4	63	5554	1	aits
bits	6	61	4817	1	bits
dits	5	64	5053	1	dits
fits	7	60	4347	1	fits
gits	5	57	4460	1	gits
hits	7	55	4514	1	hits
its	3	55	3884	1	_its
kits	8	64	4178	1	kits
lits	4	62	5250	1	lits
nits	4	57	4165	1	nits
pits	6	63	4875	1	pits
sits	4	50	5021	1	sits
tits	4	61	4505	1	tits
wits	7	60	4488	1	wits
zigs	14	54	2280	1	zigs
zins	13	57	3501	1	zins
zips	15	57	2380	1	zips
zit	12	60	5000	1	zit_
ziti	13	60	2238	1	ziti
zitis	14	58	1558	1	zitis
acts	6	69	2986	2	acts
adits	6	65	2371	2	adits
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
airts	5	56	2634	2	airts
ais	3	90	8358	2	ai_s
ait	3	80	9391	2	ait_
alts	4	66	3990	2	alts
ants	4	72	4347	2	ants
arts	4	96	5026	2	arts
baits	7	66	3058	2	baits
bats	6	69	6233	2	bats
bets	6	70	5144	2	bets
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
bints	7	61	3018	2	bints
bios	6	63	3533	2	bios
bis	5	68	6067	2	bi_s
bit	5	70	7091	2	bit_
bite	6	65	4701	2	bite
bites	7	56	4117	2	bites
bitsy	10	45	1130	2	bitsy
bitt	6	55	4582	2	bitt
bitts	7	50	2259	2	bitts
bots	6	64	5395	2	bots
brits	7	64	3308	2	brits
buts	6	72	4769	2	buts
cats	6	63	5634	2	cats
chits	10	54	2457	2	chits
cigs	7	56	2511	2	cigs
cis	5	77	4804	2	ci_s
cist	6	72	4497	2	cist
cists	7	66	2453	2	cists
cite	6	56	4035	2	cite
cites	7	44	3559	2	cites
city	9	51	2263	2	city
cots	6	80	5484	2	cots
crits	7	55	2757	2	crits
cuts	6	58	4115	2	cuts
dibs	7	62	3369	2	dibs
dies	5	56	5353	2	dies
diets	6	60	2664	2	diets
difs	8	60	2733	2	difs
digs	6	60	3606	2	digs
dims	7	54	3503	2	dims
dins	5	66	5205	2	dins
dints	6	74	3131	2	dints
dips	7	55	3692	2	dips
dirts	6	68	2446	2	dirts
dis	4	64	5990	2	di_s
diss	5	64	3449	2	diss
dit	4	70	7134	2	dit_
dita	5	60	3253	2	dita
ditas	6	59	2367	2	ditas
dite	5	55	4756	2	dite
dites	6	63	3915	2	dites
ditsy	9	56	1256	2	ditsy
ditz	14	69	2952	2	ditz
doits	6	62	2367	2	doits
dots	5	56	4766	2	dots
duits	6	50	2188	2	duits
eats	4	70	5487	2	eats
edits	6	58	1903	2	edits
efts	7	65	1948	2	efts
emits	7	54	2147	2	emits
exits	12	55	1591	2	exits
fats	7	62	5250	2	fats
fets	7	53	4594	2	fets
fiats	8	53	2448	2	fiats
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
fist	7	62	4843	2	fist
fists	8	55	2754	2	fists
fit	6	63	6546	2	fit_
flits	8	56	2522	2	flits
frits	8	61	2910	2	frits
gaits	6	57	2601	2	gaits
gats	5	67	5344	2	gats
gets	5	54	4248	2	gets
gibs	7	55	2928	2	gibs
gids	6	59	3375	2	gids
gies	5	56	4143	2	gies
gifts	9	62	1496	2	gifts
gigs	6	66	3119	2	gigs
gilts	6	49	2426	2	gilts
gins	5	55	4396	2	gins
gips	7	56	3293	2	gips
girts	6	54	2362	2	girts
gist	5	60	4677	2	gist
gists	6	60	2619	2	gists
git	4	62	6606	2	git_
gite	5	54	3862	2	gite
gites	6	56	3018	2	gites
grits	6	55	2958	2	grits
guts	5	66	3725	2	guts
hats	7	68	5825	2	hats
hets	7	55	4720	2	hets
hies	7	48	4284	2	hies
hilts	8	69	2441	2	hilts
hims	9	52	3098	2	hims
hins	7	64	4800	2	hins
hints	8	73	3062	2	hints
hips	9	64	3371	2	hips
his	6	63	5951	2	hi_s
hiss	7	56	2922	2	hiss
hist	7	65	5155	2	hist
hists	8	63	2837	2	hists
hit	6	65	6920	2	hit_
hots	7	83	4933	2	hots
huts	7	67	3744	2	huts
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
it	2	84	5569	2	_it_
jets	11	58	3410	2	jets
jibs	13	67	2409	2	jibs
jigs	12	65	2477	2	jigs
jilts	12	47	1741	2	jilts
jins	11	56	3502	2	jins
jots	11	63	3614	2	jots
juts	11	59	3016	2	juts
kats	8	59	4434	2	kats
kids	9	60	2965	2	kids
kifs	11	60	2352	2	kifs
kilts	9	51	2219	2	kilts
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
kist	8	65	4081	2	kist
kists	9	58	2212	2	kists
kit	7	85	5989	2	kit_
kite	8	53	3825	2	kite
kites	9	54	3255	2	kites
kith	11	58	2637	2	kith
kiths	12	58	1498	2	kiths
knits	9	39	1475	2	knits
lats	4	59	6270	2	lats
lets	4	71	4794	2	lets
libs	6	67	3277	2	libs
lids	5	63	3647	2	lids
lies	4	64	5420	2	lies
lifts	8	57	1906	2	lifts
lilts	5	58	2280	2	lilts
lins	4	70	5906	2	lins
lints	5	71	3719	2	lints
lips	6	71	4145	2	lips
lis	3	71	6228	2	li_s
list	4	70	5535	2	list
lists	5	66	2869	2	lists
lit	3	93	7732	2	lit_
litas	5	49	2377	2	litas
lite	4	70	5455	2	lite
litu	4	76	3157	2	litu
lots	4	76	5209	2	lots
mats	6	54	6029	2	mats
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
milts	7	54	3071	2	milts
mints	7	68	3404	2	mints
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
mist	6	61	5454	2	mist
mists	7	66	3390	2	mists
mite	6	62	4942	2	mite
mites	7	51	4180	2	mites
mitis	7	54	2599	2	mitis
mitt	6	61	4550	2	mitt
mitts	7	55	2375	2	mitts
mity	9	55	2822	2	mity
mots	6	68	5316	2	mots
muts	6	48	3998	2	muts
nets	4	59	4153	2	nets
nibs	6	50	2832	2	nibs
nils	4	61	3246	2	nils
nims	6	62	2689	2	nims
nips	6	58	3093	2	nips
nit	3	70	6595	2	nit_
nite	4	59	4359	2	nite
nites	5	57	3634	2	nites
nuts	4	50	3267	2	nuts
oats	4	65	5421	2	oats
obits	7	46	1755	2	obits
oils	4	63	3798	2	oils
omits	7	50	1826	2	omits
oots	4	64	4644	2	oots
opts	6	81	2474	2	opts
orts	4	65	3833	2	orts
outs	4	57	4696	2	outs
pats	6	64	6085	2	pats
pets	6	62	4833	2	pets
pias	6	65	4256	2	pias
pics	8	56	3392	2	pics
pies	6	69	4961	2	pies
pigs	7	66	3423	2	pigs
pins	6	55	5846	2	pins
pints	7	59	3622	2	pints
pips	8	58	3714	2	pips
pis	5	63	6204	2	pi_s
piss	6	50	3334	2	piss
pit	5	64	7193	2	pit_
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
pots	6	64	5236	2	pots
puts	6	56	4175	2	puts
qats	13	53	3134	2	qats
qis	12	69	3439	2	qi_s
quits	14	41	2235	2	quits
rats	4	62	6037	2	rats
rets	4	53	5256	2	rets
rias	4	55	4060	2	rias
ribs	6	58	3303	2	ribs
rids	5	65	3956	2	rids
rifs	7	49	2901	2	rifs
rifts	8	57	1864	2	rifts
rigs	5	51	3760	2	rigs
rims	6	59	3631	2	rims
rins	4	61	5320	2	rins
riots	5	49	2201	2	riots
rips	6	62	3744	2	rips
rite	4	58	4946	2	rite
rites	5	44	4255	2	rites
ritz	13	51	2999	2	ritz
rots	4	64	5409	2	rots
ruts	4	45	4149	2	ruts
sets	4	55	4950	2	sets
shits	8	47	3117	2	shits
sibs	6	59	3355	2	sibs
sics	6	52	3410	2	sics
sifts	8	49	1892	2	sifts
silts	5	53	3082	2	silts
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
sit	3	58	7776	2	sit_
site	4	70	5242	2	site
sites	5	60	4543	2	sites
sith	7	54	3516	2	sith
situs	5	50	1923	2	situs
skits	9	47	2187	2	skits
slits	5	61	2885	2	slits
snits	5	41	2483	2	snits
sots	4	55	5245	2	sots
spits	7	44	2955	2	spits
suits	5	50	2805	2	suits
tats	4	68	5813	2	tats
tets	4	58	4746	2	tets
tics	6	57	2964	2	tics
ties	4	52	4832	2	ties
tils	4	57	3962	2	tils
tilts	5	53	2561	2	tilts
tins	4	52	5131	2	tins
tints	5	60	3092	2	tints
tips	6	64	3677	2	tips
tis	3	70	5665	2	ti_s
tit	3	67	7106	2	tit_
titi	4	71	3063	2	titi
titis	5	60	2381	2	titis
toits	5	53	2747	2	toits
tots	4	66	5412	2	tots
tuts	4	58	3845	2	tuts
twits	8	60	1579	2	twits
units	5	49	2343	2	units
uts	3	55	3437	2	_uts
vats	7	68	4174	2	vats
vets	7	68	3509	2	vets
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
vita	7	58	2853	2	vita
waits	8	83	3352	2	waits
wats	7	75	5588	2	wats
wets	7	59	4029	2	wets
whits	11	59	2382	2	whits
wigs	8	49	3126	2	wigs
wilts	8	50	2350	2	wilts
wins	7	59	4918	2	wins
wis	6	65	5234	2	wi_s
wiss	7	56	3055	2	wiss
wist	7	80	4930	2	wist
wists	8	67	2852	2	wists
wit	6	65	6378	2	wit_
wite	7	54	4328	2	wite
wites	8	55	3696	2	wites
with	10	57	3048	2	with
wots	7	63	4289	2	wots
writs	8	66	2438	2	writs
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
zags	14	68	2668	2	zags
zaps	15	68	2689	2	zaps
zas	12	69	4683	2	z_as
zeds	14	58	2181	2	zeds
zees	13	63	3189	2	zees
zeins	14	47	1539	2	zeins
zeks	17	58	1506	2	zeks
zeps	15	60	1934	2	zeps
zest	13	60	3570	2	zest
zests	14	54	1974	2	zests
zeta	13	51	2164	2	zeta
zetas	14	50	1816	2	zetas
zibets	17	3	774	2	zibets
zig	13	69	3191	2	zi_g
zill	13	57	2762	2	zill
zills	14	40	2078	2	zills
zin	12	56	4378	2	zi_n
zinc	15	68	1910	2	zinc
zincs	16	53	1293	2	zincs
zine	13	70	3616	2	zine
zines	14	52	3265	2	zines
zing	14	57	2862	2	zing
zings	15	46	2089	2	zings
zip	14	66	3623	2	zi_p
zoos	13	58	2880	2	zoos

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.296	603685.8
2	DLD Change Limit	29872	361	1.500	19914.7
3	Display Results	361	361	0.470	768.1
	(SQL Overall)	178691	361	2.266	78857.5