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

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

347 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
rifs	7	49	2900	(None)
difs	8	60	2732	1	difs
ifs	6	71	2424	1	_ifs
kifs	11	60	2350	1	kifs
refs	7	57	3224	1	refs
reifs	8	48	1909	1	reifs
rias	4	55	4059	1	rias
ribs	6	58	3302	1	ribs
rids	5	65	3954	1	rids
rif	6	59	5156	1	rif_
rife	7	46	3232	1	rife
riff	10	44	3010	1	riff
riffs	11	51	1461	1	riffs
rift	7	56	4233	1	rift
rifts	8	57	1864	1	rifts
rigs	5	51	3759	1	rigs
rims	6	59	3630	1	rims
rins	4	61	5319	1	rins
rips	6	62	3743	1	rips
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
alifs	8	61	2126	2	alifs
arfs	7	60	2996	2	arfs
arias	5	54	3802	2	arias
arils	5	87	3220	2	arils
bias	6	47	3816	2	bias
bibs	8	48	3099	2	bibs
bids	7	58	3843	2	bids
biff	12	50	2689	2	biff
biffs	13	48	1441	2	biffs
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
briefs	11	55	1007	2	briefs
bries	7	49	4215	2	bries
brigs	8	58	2322	2	brigs
brims	9	47	2162	2	brims
brins	7	55	3397	2	brins
brios	7	47	2572	2	brios
bris	6	55	3961	2	bri_s
briss	7	58	2427	2	briss
brits	7	64	3308	2	brits
cigs	7	56	2510	2	cigs
cis	5	77	4803	2	ci_s
coifs	10	57	1870	2	coifs
cribs	9	45	1675	2	cribs
cries	7	54	3840	2	cries
cris	6	62	3343	2	cri_s
crits	7	55	2757	2	crits
cuifs	10	48	1469	2	cuifs
dibs	7	62	3368	2	dibs
dies	5	56	5352	2	dies
dif	7	68	4690	2	dif_
diff	11	62	2884	2	diff
diffs	12	63	1548	2	diffs
digs	6	60	3605	2	digs
dims	7	54	3502	2	dims
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
dribs	8	51	1506	2	dribs
dries	6	47	3367	2	dries
drift	9	57	2284	2	drift
drifts	10	49	989	2	drifts
drips	8	54	1723	2	drips
effs	10	51	1403	2	effs
efs	6	68	2960	2	_efs
fibs	9	63	2950	2	fibs
fids	8	70	3473	2	fids
fiefs	11	62	1370	2	fiefs
fife	10	60	2770	2	fife
fifes	11	48	2239	2	fifes
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
fries	8	55	3560	2	fries
frigs	9	60	1927	2	frigs
frits	8	61	2910	2	frits
gibs	7	55	2927	2	gibs
gids	6	59	3373	2	gids
gies	5	56	4142	2	gies
gift	8	67	3579	2	gift
gifts	9	62	1496	2	gifts
gigs	6	66	3118	2	gigs
gins	5	55	4395	2	gins
gips	7	56	3292	2	gips
gits	5	57	4459	2	gits
grids	7	53	2139	2	grids
griefs	10	41	872	2	griefs
griff	12	44	1646	2	griff
griffs	13	39	899	2	griffs
grift	9	59	2446	2	grift
grifts	10	45	1168	2	grifts
grigs	7	53	1819	2	grigs
grins	6	54	2722	2	grins
grips	8	55	2013	2	grips
grits	6	55	2958	2	grits
hies	7	48	4283	2	hies
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
ids	4	75	3546	2	_ids
if	5	72	3995	2	_if_
iff	9	67	3039	2	_iff
ins	3	59	4560	2	_ins
ires	4	56	3928	2	ires
irids	6	64	1777	2	irids
iris	4	57	3255	2	iris
irks	8	62	2013	2	irks
is	2	70	4821	2	_i_s
its	3	55	3883	2	_its
jibs	13	67	2408	2	jibs
jiff	17	53	2141	2	jiff
jiffs	18	57	1031	2	jiffs
jigs	12	65	2476	2	jigs
jins	11	56	3501	2	jins
kafs	11	64	2374	2	kafs
kaifs	12	57	1564	2	kaifs
kefs	11	59	2274	2	kefs
kids	9	60	2963	2	kids
kiefs	12	61	1220	2	kiefs
kif	10	59	4118	2	kif_
kins	8	57	4790	2	kins
kips	10	64	3051	2	kips
kirs	8	58	3173	2	kirs
kis	7	80	5147	2	ki_s
kiss	8	52	2739	2	kiss
kits	8	64	4176	2	kits
kris	8	64	2360	2	kri_s
libs	6	67	3276	2	libs
lids	5	63	3645	2	lids
lies	4	64	5419	2	lies
life	7	54	3373	2	life
lift	7	69	4272	2	lift
lifts	8	57	1906	2	lifts
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
mibs	8	53	3048	2	mibs
mics	8	74	3515	2	mics
mids	7	65	4178	2	mids
miff	12	56	2506	2	miff
miffs	13	45	1288	2	miffs
migs	7	69	3532	2	migs
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
naifs	8	76	1742	2	naifs
neifs	8	56	1304	2	neifs
nibs	6	50	2831	2	nibs
nils	4	61	3245	2	nils
nims	6	62	2688	2	nims
nips	6	58	3092	2	nips
nits	4	57	4164	2	nits
oafs	7	64	2526	2	oafs
offs	10	71	1701	2	offs
oils	4	63	3797	2	oils
pias	6	65	4255	2	pias
pics	8	56	3391	2	pics
pies	6	69	4960	2	pies
pigs	7	66	3422	2	pigs
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
pries	7	43	3953	2	pries
prigs	8	52	1970	2	prigs
prims	9	54	2593	2	prims
priss	7	46	2389	2	priss
profs	10	51	2089	2	profs
qis	12	69	3438	2	qi_s
rads	5	60	4660	2	rads
raff	10	49	3304	2	raff
raffs	11	50	1752	2	raffs
raft	7	62	4591	2	raft
rafts	8	78	2063	2	rafts
rags	5	54	4837	2	rags
raias	5	46	3112	2	raias
raids	6	58	2751	2	raids
rails	5	59	3740	2	rails
rains	5	51	4023	2	rains
rais	4	52	5262	2	rais
rams	6	59	5077	2	rams
raps	6	62	4773	2	raps
ras	3	75	7539	2	r_as
rats	4	62	6037	2	rats
raws	7	52	3821	2	raws
rays	7	76	4235	2	rays
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
reds	5	60	4286	2	reds
reefs	8	51	2166	2	reefs
rees	4	53	6419	2	rees
ref	6	60	5329	2	ref_
reft	7	51	4127	2	reft
regs	5	54	3657	2	regs
reif	7	69	3765	2	reif_
reify	11	48	1497	2	reify
reins	5	62	3456	2	reins
reis	4	53	4323	2	reis
rems	6	62	3772	2	rems
reps	6	59	3795	2	reps
res	3	55	6504	2	r_es
rets	4	53	5256	2	rets
revs	7	50	2705	2	revs
rhos	7	63	1906	2	rhos
rhus	7	51	1405	2	rhus
ria	3	67	4550	2	ri_a
rial	4	59	3809	2	rial
rials	5	50	2667	2	rials
rib	5	68	4803	2	ri_b
ribes	7	55	3017	2	ribes
rice	6	49	4291	2	rice
rices	7	55	3615	2	rices
rich	9	70	2554	2	rich
rick	10	73	3465	2	rick
ricks	11	51	2613	2	ricks
rid	4	67	5462	2	ri_d
ride	5	59	4512	2	ride
rides	6	61	4081	2	rides
riel	4	64	3238	2	riel
riels	5	51	2133	2	riels
rifer	8	47	2198	2	rifer
rifest	9	31	1458	2	rifest
rifle	8	55	1833	2	rifle
rifles	9	42	1770	2	rifles
rig	4	67	4812	2	ri_g
rile	4	56	5053	2	rile
riles	5	53	4364	2	riles
rill	4	51	4090	2	rill
rills	5	50	3271	2	rills
rim	5	60	5227	2	ri_m
rime	6	51	3888	2	rime
rimes	7	56	3454	2	rimes
rimy	9	66	2128	2	rimy
rin	3	66	6318	2	ri_n
rind	5	65	3560	2	rind
rinds	6	48	2614	2	rinds
ring	5	65	4115	2	ring
rings	6	50	2917	2	rings
rink	8	77	3699	2	rink
rinks	9	48	2710	2	rinks
rinse	5	48	2097	2	rinse
riot	4	59	4721	2	riot
riots	5	49	2201	2	riots
rip	5	68	5130	2	ri_p
ripe	6	60	3892	2	ripe
ripes	7	54	3577	2	ripes
rise	4	59	4523	2	rise
rises	5	52	4404	2	rises
risk	8	57	2410	2	risk
risks	9	49	1706	2	risks
risus	5	42	1639	2	risus
rite	4	58	4945	2	rite
rites	5	44	4255	2	rites
ritz	13	51	2998	2	ritz
rive	7	55	3772	2	rive
rives	8	53	3600	2	rives
robs	6	58	3787	2	robs
rocs	6	55	3366	2	rocs
rods	5	64	4206	2	rods
roes	4	59	5413	2	roes
roils	5	48	2679	2	roils
rolfs	8	48	1712	2	rolfs
roms	6	70	3896	2	roms
roofs	8	53	2115	2	roofs
rots	4	64	5409	2	rots
rows	7	59	4175	2	rows
rubs	6	61	3349	2	rubs
rues	4	60	4448	2	rues
ruff	10	51	2765	2	ruff
ruffs	11	45	1674	2	ruffs
rugs	5	60	3368	2	rugs
ruins	5	58	2203	2	ruins
rums	6	48	3347	2	rums
runs	4	64	3807	2	runs
ruts	4	45	4149	2	ruts
ryas	7	72	2461	2	ryas
ryes	7	55	2935	2	ryes
seifs	8	50	1933	2	seifs
serifs	9	40	1705	2	serifs
sibs	6	59	3354	2	sibs
sics	6	52	3409	2	sics
sift	7	107	4066	2	sift
sifts	8	49	1892	2	sifts
sims	6	57	3717	2	sims
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
sris	4	54	3415	2	sri_s
tics	6	57	2963	2	tics
ties	4	52	4831	2	ties
tiff	10	47	2772	2	tiff
tiffs	11	44	1488	2	tiffs
tils	4	57	3961	2	tils
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
tries	5	57	4281	2	tries
trigs	6	54	2306	2	trigs
trims	7	50	2147	2	trims
trios	5	55	2809	2	trios
trips	7	49	2336	2	trips
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
waifs	11	57	1987	2	waifs
wife	10	52	2802	2	wife
wifes	11	45	2256	2	wifes
wigs	8	49	3125	2	wigs
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
wries	8	58	2774	2	wries
writs	8	66	2438	2	writs
xis	10	69	3533	2	xi_s
yids	8	52	2495	2	yids
yins	7	53	3512	2	yins
yips	9	52	2670	2	yips
zigs	14	54	2279	2	zigs
zins	13	57	3500	2	zins
zips	15	57	2379	2	zips
zits	13	60	3029	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.080	2233637.5
2	DLD Change Limit	29872	347	0.890	33564.0
3	Display Results	347	347	0.076	4565.8
	(SQL Overall)	178691	347	1.046	170832.7