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

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

384 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
mics	8	74	3516	(None)
macs	8	67	4251	1	macs
mibs	8	53	3049	1	mibs
mic	7	76	4765	1	mic_
mica	8	64	2826	1	mica
micas	9	68	2305	1	micas
mice	8	74	4224	1	mice
mick	12	63	3344	1	mick
micks	13	55	2537	1	micks
mids	7	65	4180	1	mids
migs	7	69	3533	1	migs
mils	6	60	4534	1	mils
mips	8	55	3409	1	mips
mirs	6	69	4058	1	mirs
mis	5	81	6263	1	mi_s
miss	6	53	3943	1	miss
mocs	8	58	3490	1	mocs
mycs	11	53	1429	1	mycs
pics	8	56	3392	1	pics
sics	6	52	3410	1	sics
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
amias	7	58	3147	2	amias
amice	9	61	2287	2	amice
amices	10	50	1801	2	amices
amici	9	42	1739	2	amici
amicus	10	38	1000	2	amicus
amids	8	56	2752	2	amids
amies	7	68	3769	2	amies
amins	7	55	3432	2	amins
amirs	7	59	2492	2	amirs
amis	6	64	4532	2	ami_s
amiss	7	58	2307	2	amiss
arcs	6	78	3478	2	arcs
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
comics	12	40	1556	2	comics
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
emic	8	64	2275	2	emic_
emirs	7	61	1616	2	emirs
emits	7	54	2147	2	emits
epics	9	50	1428	2	epics
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
imids	8	60	1515	2	imids
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
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
mac	7	80	5393	2	mac_
mace	8	73	4579	2	mace
maces	9	71	3996	2	maces
mach	11	61	3448	2	mach
machs	12	57	2256	2	machs
mack	12	57	3365	2	mack
macks	13	51	2760	2	macks
mads	7	68	4538	2	mads
maes	6	69	4840	2	maes
magics	11	53	1161	2	magics
mags	7	54	4453	2	mags
maids	8	63	2715	2	maids
mails	7	60	3778	2	mails
maims	9	63	2179	2	maims
mains	7	56	3511	2	mains
mairs	7	62	2830	2	mairs
manics	10	39	1993	2	manics
mans	6	63	5455	2	mans
maps	8	61	4105	2	maps
marcs	9	57	2662	2	marcs
mars	6	62	6187	2	mars
mas	5	81	7582	2	m_as
mass	6	60	4494	2	mass
mats	6	54	6029	2	mats
maws	9	64	3714	2	maws
mays	9	69	4003	2	mays
medics	11	41	1535	2	medics
meds	7	57	3537	2	meds
megs	7	55	3063	2	megs
mels	6	59	4153	2	mels
mems	8	59	3150	2	mems
mercs	9	60	2045	2	mercs
mess	6	59	3243	2	mess
mews	9	66	2933	2	mews
mhos	9	55	1777	2	mhos
mi	4	82	4906	2	mi__
miasm	9	12	1109	2	miasm
mib	7	69	4613	2	mi_b
miche	12	62	1924	2	miche
miches	13	43	2073	2	miches
micra	9	62	1497	2	micra
micro	9	47	1599	2	micro
micros	10	41	1536	2	micros
mid	6	73	5448	2	mi_d
midi	7	56	2849	2	midi
midis	8	59	2342	2	midis
midst	8	59	2256	2	midst
mien	6	50	2837	2	mien
miens	7	61	1830	2	miens
miff	12	56	2507	2	miff
miffs	13	45	1288	2	miffs
mig	6	56	4609	2	mi_g
migg	8	57	1681	2	migg
miggs	9	63	1137	2	miggs
mike	10	55	3530	2	mike
mikes	11	51	2989	2	mikes
mil	5	57	5212	2	mi_l
milch	12	44	1337	2	milch
mild	7	53	3086	2	mild
milds	8	64	2206	2	milds
mile	6	63	5258	2	mile
miles	7	46	4507	2	miles
milk	10	50	2848	2	milk
milks	11	50	2058	2	milks
mill	6	65	4149	2	mill
mills	7	54	3505	2	mills
milo	6	55	3611	2	milo
milos	7	54	2801	2	milos
milt	6	54	5582	2	milt
milts	7	54	3071	2	milts
mim	7	60	4843	2	mi_m
mime	8	57	3641	2	mime
mimes	9	57	3202	2	mimes
mimics	12	8	936	2	mimics
mina	6	51	3693	2	mina
minas	7	54	3411	2	minas
mince	9	53	2523	2	mince
minces	10	44	2080	2	minces
mincy	12	58	1741	2	mincy
mind	7	54	3439	2	mind
minds	8	54	2713	2	minds
mine	6	72	5618	2	mine
mines	7	56	5195	2	mines
mini	6	56	3457	2	mini
minis	7	54	3299	2	minis
mink	10	66	3654	2	mink
minks	11	58	2927	2	minks
mint	6	67	5807	2	mint
mints	7	68	3404	2	mints
minus	7	52	2393	2	minus
minx	13	77	2336	2	minx
mir	5	70	4678	2	mi_r
mire	6	67	4824	2	mire
mires	7	56	4088	2	mires
miri	6	67	3038	2	miri
mirk	10	67	2951	2	mirk
mirks	11	51	2214	2	mirks
miry	9	63	2676	2	miry
mise	6	60	4359	2	mise
mises	7	47	4056	2	mises
miso	6	72	2991	2	miso
misos	7	65	2329	2	misos
missy	10	56	1756	2	missy
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
mix	12	61	3819	2	mi_x
mixes	14	72	2440	2	mixes
mixt	13	68	3193	2	mixt
moas	6	55	4534	2	moas
mobs	8	57	3737	2	mobs
moc	7	78	4508	2	moc_
mock	12	64	2944	2	mock
mocks	13	50	2382	2	mocks
mods	7	79	4506	2	mods
mogs	7	54	3933	2	mogs
moils	7	61	2575	2	moils
mols	6	59	4857	2	mols
moms	8	65	3948	2	moms
mons	6	81	5226	2	mons
moos	6	60	5130	2	moos
mops	8	59	4013	2	mops
mors	6	59	5006	2	mors
mos	5	70	6712	2	m_os
moss	6	76	4103	2	moss
mots	6	68	5316	2	mots
mows	9	63	4083	2	mows
much	11	52	2403	2	much
muck	12	57	2785	2	muck
mucks	13	46	2264	2	mucks
mucus	9	40	1574	2	mucus
muds	7	55	3066	2	muds
mugs	7	62	3204	2	mugs
mums	8	57	3277	2	mums
muns	6	55	3592	2	muns
mus	5	59	4675	2	m_us
musics	10	39	1178	2	musics
muss	6	49	3376	2	muss
muts	6	48	3998	2	muts
myc	10	65	1950	2	myc_
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
omits	7	50	1826	2	omits
orcs	6	70	2543	2	orcs
osmics	10	3	646	2	osmics
pacs	8	58	4218	2	pacs
pecs	8	46	3410	2	pecs
pias	6	65	4256	2	pias
pic	7	60	4683	2	pic_
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
pies	6	69	4961	2	pies
pigs	7	66	3423	2	pigs
pins	6	55	5846	2	pins
pips	8	58	3714	2	pips
pis	5	63	6204	2	pi_s
piss	6	50	3334	2	piss
pits	6	63	4875	2	pits
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
spics	9	41	2324	2	spics
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
umiacs	10	3	566	2	umiacs
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.266	671770.7
2	DLD Change Limit	29872	384	0.876	34100.5
3	Display Results	384	384	0.093	4129.0
	(SQL Overall)	178691	384	1.235	144689.1