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

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

289 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
jigs	12	65	2476	(None)
bigs	7	62	3502	1	bigs
cigs	7	56	2510	1	cigs
digs	6	60	3605	1	digs
figs	8	53	3264	1	figs
gigs	6	66	3118	1	gigs
jags	12	61	3279	1	jags
jibs	13	67	2408	1	jibs
jig	11	56	3351	1	jig_
jins	11	56	3501	1	jins
jogs	12	71	2933	1	jogs
jugs	12	55	2560	1	jugs
migs	7	69	3532	1	migs
pigs	7	66	3422	1	pigs
rigs	5	51	3759	1	rigs
vigs	8	54	2727	1	vigs
wigs	8	49	3125	1	wigs
zigs	14	54	2279	1	zigs
ags	4	75	5166	2	_ags
aids	5	78	4636	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
bags	7	66	4550	2	bags
begs	7	57	3383	2	begs
bias	6	47	3816	2	bias
bibs	8	48	3099	2	bibs
bids	7	58	3845	2	bids
big	6	73	4572	2	big_
bigos	8	50	2001	2	bigos
bins	6	65	4825	2	bins
biogs	8	50	1611	2	biogs
bios	6	63	3532	2	bios
bis	5	68	6066	2	bi_s
bits	6	61	4816	2	bits
bogs	7	57	4275	2	bogs
brigs	8	58	2322	2	brigs
bugs	7	60	3591	2	bugs
cig	6	70	3618	2	cig_
cis	5	77	4803	2	ci_s
cogs	7	73	4003	2	cogs
dags	6	66	4260	2	dags
dibs	7	62	3368	2	dibs
dies	5	56	5352	2	dies
difs	8	60	2732	2	difs
dig	5	75	4447	2	dig_
dims	7	54	3502	2	dims
dings	7	63	3140	2	dings
dins	5	66	5204	2	dins
dips	7	55	3691	2	dips
dis	4	64	5989	2	di_s
diss	5	64	3448	2	diss
dits	5	64	5052	2	dits
djins	13	6	845	2	djins
dogs	6	64	4015	2	dogs
dugs	6	148	3228	2	dugs
eggs	6	65	1615	2	eggs
egis	5	65	2065	2	egis
engs	5	61	2139	2	engs
ergs	5	55	2381	2	ergs
fags	8	69	3912	2	fags
fibs	9	63	2950	2	fibs
fids	8	70	3474	2	fids
fig	7	62	4283	2	fig_
fils	7	58	3869	2	fils
fins	7	58	4909	2	fins
firs	7	66	3771	2	firs
fits	7	60	4346	2	fits
fogs	8	70	3500	2	fogs
frigs	9	60	1927	2	frigs
fugs	8	57	3069	2	fugs
gags	6	64	4106	2	gags
gibs	7	55	2927	2	gibs
gids	6	59	3374	2	gids
gies	5	56	4142	2	gies
gig	5	60	4075	2	gig_
giga	6	67	2094	2	giga
gigas	7	54	1558	2	gigas
gins	5	55	4395	2	gins
gips	7	56	3292	2	gips
gits	5	57	4459	2	gits
grigs	7	53	1819	2	grigs
hags	8	67	4084	2	hags
hies	7	48	4283	2	hies
high	11	66	1992	2	high
highs	12	54	1252	2	highs
hims	9	52	3097	2	hims
hins	7	64	4799	2	hins
hips	9	64	3370	2	hips
his	6	63	5950	2	hi_s
hiss	7	56	2921	2	hiss
hits	7	55	4513	2	hits
hogs	8	71	3966	2	hogs
hugs	8	61	2975	2	hugs
ids	4	75	3547	2	_ids
ifs	6	71	2424	2	_ifs
igg	5	71	1679	2	_igg
iggs	6	66	1267	2	iggs
ins	3	59	4560	2	_ins
is	2	70	4821	2	_i_s
its	3	55	3883	2	_its
jabs	13	58	3009	2	jabs
jag	11	65	4271	2	jag_
jagg	13	61	1531	2	jagg
jaggs	14	81	1149	2	jaggs
jails	12	54	2294	2	jails
jams	13	52	3107	2	jams
jars	11	73	3835	2	jars
jaws	14	50	2729	2	jaws
jays	14	63	2834	2	jays
jees	11	59	3854	2	jees
jess	11	60	2203	2	jess
jets	11	58	3410	2	jets
jews	14	58	2208	2	jews
jiao	11	50	1784	2	jiao
jib	12	58	3597	2	ji_b
jibb	15	58	1674	2	jibb
jibbs	16	60	974	2	jibbs
jibe	13	63	2339	2	jibe
jibes	14	55	2032	2	jibes
jiff	17	53	2141	2	jiff
jiffs	18	57	1031	2	jiffs
jiggy	17	54	914	2	jiggy
jigsaw	17	4	249	2	jigsaw
jill	11	64	3026	2	jill
jills	12	51	2282	2	jills
jilt	11	58	3942	2	jilt
jilts	12	47	1741	2	jilts
jimp	15	56	1846	2	jimp
jin	10	64	4393	2	ji_n
jingo	13	46	1521	2	jingo
jink	15	62	2720	2	jink
jinks	16	50	1933	2	jinks
jinn	11	54	2024	2	jinn
jinns	12	60	1384	2	jinns
jinx	18	55	1657	2	jinx
jism	13	55	1477	2	jism
jisms	14	45	800	2	jisms
jive	14	61	2359	2	jive
jives	15	48	2081	2	jives
jivy	17	62	1311	2	jivy
jobs	13	65	2943	2	jobs
joes	11	66	3589	2	joes
jog	11	74	3831	2	jog_
joins	12	58	1841	2	joins
joss	11	59	2559	2	joss
jots	11	63	3614	2	jots
jows	14	66	3209	2	jows
joys	14	66	2466	2	joys
jug	11	55	2954	2	jug_
juga	12	64	1732	2	juga
jus	10	69	3022	2	j_us
juts	11	59	3016	2	juts
kegs	9	58	2402	2	kegs
kids	9	60	2964	2	kids
kifs	11	60	2351	2	kifs
kings	10	58	2556	2	kings
kins	8	57	4791	2	kins
kips	10	64	3052	2	kips
kirs	8	58	3174	2	kirs
kis	7	80	5148	2	ki_s
kiss	8	52	2740	2	kiss
kits	8	64	4177	2	kits
lags	5	65	4622	2	lags
legs	5	61	3369	2	legs
libs	6	67	3276	2	libs
lids	5	63	3646	2	lids
lies	4	64	5419	2	lies
lings	6	71	3577	2	lings
lins	4	70	5905	2	lins
lips	6	71	4144	2	lips
lis	3	71	6227	2	li_s
lits	4	62	5249	2	lits
logs	5	73	4311	2	logs
lugs	5	52	3352	2	lugs
mags	7	54	4453	2	mags
megs	7	55	3063	2	megs
mibs	8	53	3048	2	mibs
mics	8	74	3515	2	mics
mids	7	65	4179	2	mids
mig	6	56	4608	2	mig_
migg	8	57	1680	2	migg
miggs	9	63	1137	2	miggs
mils	6	60	4533	2	mils
mips	8	55	3408	2	mips
mirs	6	69	4057	2	mirs
mis	5	81	6262	2	mi_s
miss	6	53	3942	2	miss
mogs	7	54	3933	2	mogs
mugs	7	62	3204	2	mugs
nags	5	54	3602	2	nags
negs	5	57	2736	2	negs
nibs	6	50	2831	2	nibs
nigh	8	52	2066	2	nigh
nighs	9	50	1361	2	nighs
nils	4	61	3245	2	nils
nims	6	62	2688	2	nims
nips	6	58	3092	2	nips
nits	4	57	4164	2	nits
nogs	5	65	3461	2	nogs
oils	4	63	3797	2	oils
pegs	7	55	3176	2	pegs
pias	6	65	4255	2	pias
pics	8	56	3391	2	pics
pies	6	69	4960	2	pies
pig	6	57	4497	2	pig_
pings	8	58	3088	2	pings
pins	6	55	5845	2	pins
pips	8	58	3713	2	pips
pis	5	63	6203	2	pi_s
piss	6	50	3333	2	piss
pits	6	63	4874	2	pits
prigs	8	52	1970	2	prigs
pugs	7	63	3277	2	pugs
qis	12	69	3438	2	qi_s
rags	5	54	4837	2	rags
regs	5	54	3657	2	regs
rejigs	14	36	809	2	rejigs
rias	4	55	4059	2	rias
ribs	6	58	3302	2	ribs
rids	5	65	3955	2	rids
rifs	7	49	2900	2	rifs
rig	4	67	4812	2	rig_
rims	6	59	3630	2	rims
rings	6	50	2917	2	rings
rins	4	61	5319	2	rins
rips	6	62	3743	2	rips
rugs	5	60	3368	2	rugs
sags	5	59	4840	2	sags
segs	5	49	3388	2	segs
sibs	6	59	3354	2	sibs
sics	6	52	3409	2	sics
sigh	8	56	2589	2	sigh
sighs	9	54	1674	2	sighs
sign	5	55	2305	2	sign
signs	6	55	1632	2	signs
sims	6	57	3717	2	sims
sings	6	55	3270	2	sings
sins	4	67	5527	2	sins
sips	6	57	4010	2	sips
sirs	4	43	3833	2	sirs
sis	3	73	6054	2	si_s
sits	4	50	5020	2	sits
swigs	9	62	1366	2	swigs
tags	5	55	4523	2	tags
tegs	5	60	3149	2	tegs
tics	6	57	2963	2	tics
ties	4	52	4831	2	ties
tils	4	57	3961	2	tils
tings	6	53	2920	2	tings
tins	4	52	5130	2	tins
tips	6	64	3676	2	tips
tis	3	70	5664	2	ti_s
tits	4	61	4504	2	tits
togs	5	72	4243	2	togs
trigs	6	54	2306	2	trigs
tugs	5	62	3167	2	tugs
twigs	9	69	1117	2	twigs
vids	8	56	2754	2	vids
vies	7	52	3862	2	vies
vig	7	56	3752	2	vig_
viga	8	56	2296	2	viga
vigas	9	48	1788	2	vigas
vims	9	54	2331	2	vims
vis	6	67	4761	2	vi_s
vugs	8	70	2287	2	vugs
wags	8	61	4055	2	wags
whigs	12	56	1264	2	whigs
wig	7	67	4038	2	wig_
wings	9	57	2724	2	wings
wins	7	59	4917	2	wins
wis	6	65	5233	2	wi_s
wiss	7	56	3054	2	wiss
wits	7	60	4487	2	wits
wogs	8	65	3140	2	wogs
xis	10	69	3533	2	xi_s
yags	8	66	3229	2	yags
yids	8	52	2496	2	yids
yins	7	53	3512	2	yins
yips	9	52	2670	2	yips
zags	14	68	2668	2	zags
zig	13	69	3190	2	zig_
zings	15	46	2089	2	zings
zins	13	57	3500	2	zins
zips	15	57	2379	2	zips
zits	13	60	3029	2	zits

Search took 6 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	289	3.453	8651.0
3	Display Results	289	289	0.156	1852.6
	(SQL Overall)	178691	289	3.905	45759.5