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

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

427 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
sims	6	57	3718	(None)
aims	6	77	3819	1	aims
dims	7	54	3503	1	dims
hims	9	52	3098	1	hims
isms	6	62	1347	1	isms
nims	6	62	2689	1	nims
rims	6	59	3631	1	rims
shims	10	44	2255	1	shims
sibs	6	59	3355	1	sibs
sics	6	52	3410	1	sics
sim	5	65	5315	1	sim_
sima	6	47	3079	1	sima
simas	7	57	2755	1	simas
simp	8	52	2878	1	simp
simps	9	47	1976	1	simps
sins	4	67	5528	1	sins
sips	6	57	4011	1	sips
sirs	4	43	3834	1	sirs
sis	3	73	6055	1	si_s
sits	4	50	5021	1	sits
skims	11	45	1720	1	skims
slims	7	54	2365	1	slims
soms	6	62	3937	1	soms
sums	6	58	3758	1	sums
swims	10	55	1414	1	swims
vims	9	54	2332	1	vims
aids	5	78	4637	2	aids
ails	4	56	5472	2	ails
aim	5	78	5822	2	aim_
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
alms	6	58	3492	2	alms
amis	6	64	4532	2	amis
arms	6	61	3749	2	arms
bams	8	70	4445	2	bams
bias	6	47	3817	2	bias
bibs	8	48	3100	2	bibs
bids	7	58	3846	2	bids
bigs	7	62	3503	2	bigs
bima	8	67	2384	2	bima
bimas	9	55	2174	2	bimas
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
brims	9	47	2162	2	brims
bums	8	59	3459	2	bums
cams	8	70	4728	2	cams
cigs	7	56	2511	2	cigs
cis	5	77	4804	2	ci_s
cwms	11	43	957	2	cwms
dams	7	74	4437	2	dams
dibs	7	62	3369	2	dibs
dies	5	56	5353	2	dies
difs	8	60	2733	2	difs
digs	6	60	3606	2	digs
dim	6	81	4650	2	dim_
dime	7	62	3765	2	dime
dimes	8	58	3304	2	dimes
dins	5	66	5205	2	dins
dips	7	55	3692	2	dips
dis	4	64	5990	2	di_s
diss	5	64	3449	2	diss
dits	5	64	5053	2	dits
doms	7	62	3957	2	doms
elms	6	73	2270	2	elms
ems	5	64	3549	2	_ems
fems	9	64	2870	2	fems
fibs	9	63	2951	2	fibs
fids	8	70	3475	2	fids
figs	8	53	3265	2	figs
films	10	56	1796	2	films
fils	7	58	3870	2	fils
fins	7	58	4910	2	fins
firms	10	52	1742	2	firms
firs	7	66	3772	2	firs
fits	7	60	4347	2	fits
gams	7	66	4888	2	gams
gems	7	53	2911	2	gems
gibs	7	55	2928	2	gibs
gids	6	59	3375	2	gids
gies	5	56	4143	2	gies
gigs	6	66	3119	2	gigs
gimp	9	61	2405	2	gimp
gimps	10	59	1520	2	gimps
gins	5	55	4396	2	gins
gips	7	56	3293	2	gips
gits	5	57	4460	2	gits
glims	8	74	1767	2	glims
gums	7	50	3094	2	gums
gyms	10	75	1459	2	gyms
hams	9	64	4613	2	hams
hems	9	55	3494	2	hems
hies	7	48	4284	2	hies
him	8	62	4767	2	him_
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
hums	9	68	3142	2	hums
ids	4	75	3548	2	_ids
ifs	6	71	2425	2	_ifs
imp	7	66	2698	2	_imp
imps	8	62	2112	2	_imps
ins	3	59	4561	2	_ins
is	2	70	4822	2	_i_s
ism	5	63	2239	2	ism_
its	3	55	3884	2	_its
jams	13	52	3107	2	jams
jibs	13	67	2409	2	jibs
jigs	12	65	2477	2	jigs
jimp	15	56	1847	2	jimp
jins	11	56	3502	2	jins
jism	13	55	1478	2	jism
jisms	14	45	800	2	jisms
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
lams	6	65	5226	2	lams
libs	6	67	3277	2	libs
lids	5	63	3647	2	lids
lies	4	64	5420	2	lies
lima	6	57	3414	2	lima
limas	7	56	2763	2	limas
limb	8	54	2939	2	limb
limbs	9	61	1894	2	limbs
lime	6	62	4494	2	lime
limes	7	56	3650	2	limes
limn	6	65	2770	2	limn
limns	7	57	1839	2	limns
limo	6	55	2974	2	limo
limos	7	53	2081	2	limos
limp	8	84	3250	2	limp
limps	9	55	2267	2	limps
limy	9	57	2772	2	limy
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
lums	6	57	3424	2	lums
maims	9	63	2179	2	maims
mems	8	59	3150	2	mems
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
mim	7	60	4843	2	mim_
mime	8	57	3641	2	mime
mimes	9	57	3202	2	mimes
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
moms	8	65	3948	2	moms
mums	8	57	3277	2	mums
nibs	6	50	2832	2	nibs
nils	4	61	3246	2	nils
nim	5	71	4296	2	nim_
nips	6	58	3093	2	nips
nits	4	57	4165	2	nits
noms	6	56	3640	2	noms
ohms	9	55	1403	2	ohms
oils	4	63	3798	2	oils
oms	5	63	3751	2	_oms
oxims	14	10	764	2	oxims
pams	8	56	4176	2	pams
pias	6	65	4256	2	pias
pics	8	56	3392	2	pics
pies	6	69	4961	2	pies
pigs	7	66	3423	2	pigs
pima	8	54	2866	2	pima
pimas	9	47	2510	2	pimas
pimp	10	60	2491	2	pimp
pimps	11	46	1698	2	pimps
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
poms	8	70	3774	2	poms
prims	9	54	2593	2	prims
psis	6	81	2034	2	psi_s
qis	12	69	3439	2	qi_s
rams	6	59	5077	2	rams
rems	6	62	3772	2	rems
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
rim	5	60	5228	2	rim_
rime	6	51	3889	2	rime
rimes	7	56	3454	2	rimes
rimy	9	66	2129	2	rimy
rins	4	61	5320	2	rins
rips	6	62	3744	2	rips
roms	6	70	3896	2	roms
rums	6	48	3347	2	rums
sabs	6	66	4374	2	sabs
sacs	6	57	3907	2	sacs
sags	5	59	4840	2	sags
saids	6	53	2886	2	saids
sails	5	57	3810	2	sails
sains	5	56	3997	2	sains
sals	4	68	5167	2	sals
same	6	52	4564	2	same
samp	8	57	3359	2	samp
samps	9	61	2467	2	samps
sans	4	51	5336	2	sans
saps	6	53	4637	2	saps
sass	4	50	3562	2	sass
saws	7	58	3948	2	saws
says	7	59	4210	2	says
scams	9	44	2397	2	scams
scrims	10	46	1593	2	scrims
scums	9	50	1742	2	scums
seams	7	57	3166	2	seams
seas	4	57	5527	2	seas
secs	6	50	3389	2	secs
seems	7	55	2502	2	seems
sees	4	53	6105	2	sees
segs	5	49	3388	2	segs
seifs	8	50	1933	2	seifs
seis	4	55	4239	2	seis
seism	7	50	1902	2	seism
seisms	8	49	1214	2	seisms
sels	4	63	4598	2	sels
seme	6	58	3665	2	seme
semes	7	57	3158	2	semes
semi	6	51	2722	2	semi
semis	7	46	2353	2	semis
sers	4	57	4665	2	sers
sets	4	55	4950	2	sets
sews	7	58	3602	2	sews
shams	10	58	2941	2	shams
shes	7	57	3435	2	shes
shies	8	61	3655	2	shies
shim	9	58	2786	2	shim_
shins	8	51	3104	2	shins
ships	10	51	2377	2	ships
shits	8	47	3117	2	shits
shivs	11	50	1880	2	shivs
shmo	9	53	1810	2	shmo
si	2	91	4958	2	si__
sial	4	59	3884	2	sial
sials	5	42	2724	2	sials
sib	5	68	5032	2	si_b
sibb	8	59	2143	2	sibb
sibbs	9	62	1190	2	sibbs
sic	5	58	4788	2	si_c
sice	6	55	4560	2	sice
sices	7	56	3727	2	sices
sick	10	64	3558	2	sick
sicks	11	51	2762	2	sicks
side	5	54	4450	2	side
sides	6	58	3837	2	sides
sidh	8	62	2300	2	sidh
sift	7	107	4067	2	sift
sifts	8	49	1892	2	sifts
sigh	8	56	2590	2	sigh
sighs	9	54	1674	2	sighs
sigma	8	45	1383	2	sigma
sigmas	9	41	1136	2	sigmas
sign	5	55	2306	2	sign
signs	6	55	1632	2	signs
sika	8	60	2133	2	sika
sikas	9	46	1702	2	sikas
sike	8	71	3879	2	sike
sikes	9	62	3608	2	sikes
sild	5	50	3059	2	sild
silds	6	55	2053	2	silds
silk	8	55	2933	2	silk
silks	9	46	2068	2	silks
sill	4	55	4516	2	sill
sills	5	51	3599	2	sills
silo	4	60	3792	2	silo
silos	5	60	2943	2	silos
silt	4	65	5820	2	silt
silts	5	53	3082	2	silts
simar	7	49	2081	2	simar
simars	8	49	1693	2	simars
sin	3	62	6590	2	si_n
sine	4	65	6063	2	sine
sines	5	59	5482	2	sines
sing	5	75	4418	2	sing
sings	6	55	3270	2	sings
sinh	7	62	3805	2	sinh
sinhs	8	67	1960	2	sinhs
sink	8	66	4015	2	sink
sinks	9	55	2918	2	sinks
sinus	5	55	2385	2	sinus
sip	5	76	5602	2	si_p
sipe	6	73	4105	2	sipe
sipes	7	60	3695	2	sipes
sir	3	57	4668	2	si_r
sire	4	61	5042	2	sire
sires	5	59	4537	2	sires
sises	5	52	3383	2	sises
sissy	8	58	1207	2	sissy
sit	3	58	7776	2	si_t
site	4	70	5242	2	site
sites	5	60	4543	2	sites
sith	7	54	3516	2	sith
situs	5	50	1923	2	situs
six	10	53	3975	2	si_x
sixes	12	45	2636	2	sixes
sixmo	14	4	830	2	sixmo
sixmos	15	3	481	2	sixmos
size	13	56	3097	2	size
sizes	14	67	2776	2	sizes
sizy	16	48	1640	2	sizy
skas	8	53	2571	2	skas
skids	10	46	1534	2	skids
skies	9	50	2684	2	skies
skim	10	53	2252	2	skim_
skimo	11	63	1255	2	skimo
skimos	12	54	880	2	skimos
skimp	13	54	1133	2	skimp
skimps	14	48	804	2	skimps
skins	9	47	2347	2	skins
skips	11	56	1661	2	skips
skis	8	48	2530	2	skis
skits	9	47	2187	2	skits
slams	7	49	2790	2	slams
slim	6	66	3196	2	slim_
slime	7	49	2575	2	slime
slimes	8	47	2204	2	slimes
slimsy	11	40	772	2	slimsy
slimy	10	54	1742	2	slimy
slips	7	60	2372	2	slips
slits	5	61	2885	2	slits
slums	7	46	2343	2	slums
smit	6	51	3841	2	smit
snibs	7	56	1376	2	snibs
snips	7	58	1801	2	snips
snits	5	41	2483	2	snits
sobs	6	49	4175	2	sobs
sods	5	49	4022	2	sods
soils	5	53	2798	2	soils
sols	4	54	4816	2	sols
som	5	91	5381	2	som_
soma	6	56	3529	2	soma
somas	7	60	3037	2	somas
some	6	60	4038	2	some
sons	4	60	4955	2	sons
sops	6	52	4456	2	sops
sos	3	77	6160	2	s_os
sots	4	55	5245	2	sots
sous	4	69	4721	2	sous
sows	7	53	4249	2	sows
soys	7	52	3393	2	soys
spams	9	49	2219	2	spams
spas	6	70	3672	2	spas
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
sris	4	54	3415	2	sris
stems	7	52	1995	2	stems
sties	5	51	3298	2	sties
stime	7	65	2180	2	stime
stimes	8	59	2057	2	stimes
stimy	10	51	1474	2	stimy
stirs	5	59	2162	2	stirs
stums	7	53	2008	2	stums
subs	6	60	3712	2	subs
suds	5	61	3530	2	suds
sues	4	62	4765	2	sues
suits	5	50	2805	2	suits
suks	8	59	2712	2	suks
sum	5	63	4601	2	sum_
sumo	6	73	2631	2	sumo
sumos	7	57	2009	2	sumos
sump	8	63	3153	2	sump
sumps	9	50	2343	2	sumps
suns	4	58	4190	2	suns
sups	6	48	3443	2	sups
suqs	13	43	1965	2	suqs
suss	4	52	2930	2	suss
swigs	9	62	1366	2	swigs
swim	9	62	2140	2	swim_
swiss	8	67	1290	2	swiss
tams	6	72	4793	2	tams
tics	6	57	2964	2	tics
ties	4	52	4832	2	ties
tils	4	57	3962	2	tils
time	6	62	3502	2	time
times	7	56	3082	2	times
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
toms	6	83	4349	2	toms
trims	7	50	2147	2	trims
vids	8	56	2755	2	vids
vies	7	52	3863	2	vies
vigs	8	54	2728	2	vigs
vim	8	74	3703	2	vim_
vis	6	67	4762	2	vi_s
whims	13	45	1533	2	whims
wigs	8	49	3126	2	wigs
wimp	11	55	2153	2	wimp
wimps	12	52	1380	2	wimps
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
yams	9	53	3073	2	yams
yids	8	52	2497	2	yids
yins	7	53	3513	2	yins
yips	9	52	2671	2	yips
zigs	14	54	2280	2	zigs
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.280	638182.1
2	DLD Change Limit	29872	427	0.890	33564.0
3	Display Results	427	427	0.110	3881.8
	(SQL Overall)	178691	427	1.280	139602.3