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

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

297 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
rife	7	46	3232	(None)
fife	10	60	2770	1	fife
life	7	54	3373	1	life
rice	6	49	4291	1	rice
ride	5	59	4513	1	ride
rif	6	59	5156	1	rif_
rifer	8	47	2198	1	rifer
riff	10	44	3010	1	riff
rifle	8	55	1833	1	rifle
rifs	7	49	2900	1	rifs
rift	7	56	4233	1	rift
rile	4	56	5053	1	rile
rime	6	51	3888	1	rime
ripe	6	60	3892	1	ripe
rise	4	59	4523	1	rise
rite	4	58	4945	1	rite
rive	7	55	3772	1	rive
wife	10	52	2802	1	wife
aide	5	60	4500	2	aide
arise	5	64	3643	2	arise
bice	8	62	3556	2	bice
bide	7	60	4150	2	bide
biff	12	50	2689	2	biff
bike	10	65	3260	2	bike
bile	6	61	4718	2	bile
bine	6	66	5086	2	bine
bise	6	64	3710	2	bise
bite	6	65	4700	2	bite
bize	15	59	2629	2	bize
bribe	9	48	2078	2	bribe
bride	8	64	2553	2	bride
brie	6	58	3790	2	bri_e
brief	10	54	2260	2	brief
brine	7	51	3227	2	brine
cafe	9	52	3032	2	cafe
cine	6	62	4294	2	cine
cire	6	58	3637	2	cire
cite	6	56	4034	2	cite
crime	9	48	2269	2	crime
cripe	9	55	2114	2	cripe
dice	7	58	4189	2	dice
die	4	67	5965	2	di_e
dif	7	68	4690	2	dif_
diff	11	62	2884	2	diff
difs	8	60	2732	2	difs
dike	9	59	3576	2	dike
dime	7	62	3764	2	dime
dine	5	55	5533	2	dine
dire	5	66	4414	2	dire
dite	5	55	4755	2	dite
dive	8	56	3477	2	dive
drift	9	57	2284	2	drift
drive	9	53	1800	2	drive
eide	5	58	3224	2	eide
fe	5	79	4474	2	__fe
fice	9	57	3711	2	fice
fie	6	71	5244	2	fi_e
fief	10	73	3136	2	fief
fifed	12	51	1597	2	fifed
fifer	11	55	1997	2	fifer
fifes	11	48	2239	2	fifes
file	7	54	4664	2	file
fine	7	51	4795	2	fine
fire	7	62	4559	2	fire
five	10	76	2974	2	five
frise	8	53	2245	2	frise
gibe	7	59	2778	2	gibe
gie	4	71	4954	2	gi_e
gift	8	67	3579	2	gift
gite	5	54	3861	2	gite
give	8	58	2935	2	give
gride	7	52	2358	2	gride
grief	9	53	1978	2	grief
griff	12	44	1646	2	griff
griffe	13	43	809	2	griffe
grift	9	59	2446	2	grift
grime	8	50	2132	2	grime
gripe	8	46	2296	2	gripe
hide	8	51	3464	2	hide
hie	6	76	5270	2	hi_e
hike	11	68	3039	2	hike
hire	7	55	3896	2	hire
hive	10	60	2967	2	hive
ice	5	67	3724	2	_ice
if	5	72	3995	2	_if_
iff	9	67	3039	2	_iff
ifs	6	71	2424	2	_ifs
ire	3	69	4317	2	_ire
jefe	14	65	1688	2	jefe
jibe	13	63	2339	2	jibe
jiff	17	53	2141	2	jiff
jive	14	61	2359	2	jive
kibe	10	65	2345	2	kibe
kief	11	71	2841	2	kief
kif	10	59	4119	2	kif_
kifs	11	60	2351	2	kifs
kike	7	65	2479	2	kike
kine	8	56	4343	2	kine
kite	8	53	3824	2	kite
knife	12	100	1013	2	knife
lice	6	60	4506	2	lice
lie	3	82	6452	2	li_e
lief	7	60	3699	2	lief
lifer	8	58	2215	2	lifer
lift	7	69	4272	2	lift
like	8	60	4084	2	like
lime	6	62	4493	2	lime
line	4	69	6557	2	line
lipe	6	68	3973	2	lipe
lire	4	78	4529	2	lire
lite	4	70	5454	2	lite
live	7	65	4099	2	live
mice	8	74	4223	2	mice
miff	12	56	2506	2	miff
mike	10	55	3529	2	mike
mile	6	63	5257	2	mile
mime	8	57	3640	2	mime
mine	6	72	5617	2	mine
mire	6	67	4823	2	mire
mise	6	60	4358	2	mise
mite	6	62	4941	2	mite
nice	6	55	3471	2	nice
nide	5	55	3579	2	nide
nine	4	58	4217	2	nine
nite	4	59	4358	2	nite
nixe	11	57	2202	2	nixe
pice	8	46	4109	2	pice
pie	5	54	5740	2	pi_e
pike	10	63	3521	2	pike
pile	6	56	4969	2	pile
pine	6	77	5571	2	pine
pipe	8	64	3443	2	pipe
price	9	37	2541	2	price
pride	8	47	2473	2	pride
prime	9	65	2560	2	prime
prise	7	46	3261	2	prise
prize	16	47	1894	2	prize
race	6	67	4626	2	race
raff	10	49	3304	2	raff
raft	7	62	4591	2	raft
rage	5	57	4235	2	rage
raise	5	48	2805	2	raise
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
rape	6	50	4163	2	rape
rare	4	53	4843	2	rare
rase	4	61	4998	2	rase
rate	4	54	5876	2	rate
rave	7	55	4209	2	rave
raze	13	52	3543	2	raze
re	2	61	5374	2	r__e
rede	5	50	3767	2	rede
ree	3	79	7407	2	r_ee
reef	7	49	3821	2	reef
ref	6	60	5329	2	ref_
refed	9	39	2192	2	refed
refel	8	49	2081	2	refel
refer	8	48	2214	2	refer
refs	7	57	3224	2	refs
reft	7	51	4127	2	reft
reif	7	69	3765	2	reif_
reifs	8	48	1909	2	reifs
reify	11	48	1497	2	reify
reive	8	55	2294	2	reive
rete	4	49	4413	2	rete
ria	3	67	4550	2	ri_a
rial	4	59	3809	2	rial
rias	4	55	4059	2	rias
rib	5	68	4803	2	ri_b
ribes	7	55	3017	2	ribes
ribs	6	58	3302	2	ribs
riced	8	58	2554	2	riced
ricer	7	47	2661	2	ricer
rices	7	55	3615	2	rices
rich	9	70	2554	2	rich
rick	10	73	3465	2	rick
rid	4	67	5463	2	ri_d
rider	6	52	3130	2	rider
rides	6	61	4081	2	rides
ridge	7	50	1867	2	ridge
rids	5	65	3955	2	rids
riel	4	64	3238	2	riel
rifely	12	37	1003	2	rifely
rifest	9	31	1458	2	rifest
riffed	13	38	1156	2	riffed
riffle	12	42	1023	2	riffle
riffs	11	51	1461	2	riffs
rifled	10	41	1500	2	rifled
rifler	9	40	1426	2	rifler
rifles	9	42	1770	2	rifles
rifted	10	41	1531	2	rifted
rifts	8	57	1864	2	rifts
rig	4	67	4812	2	ri_g
rigs	5	51	3759	2	rigs
riled	6	58	3325	2	riled
riles	5	53	4364	2	riles
riley	8	44	2058	2	riley
rill	4	51	4090	2	rill
rille	5	57	2873	2	rille
rim	5	60	5227	2	ri_m
rimed	8	48	2637	2	rimed
rimer	7	54	2924	2	rimer
rimes	7	56	3454	2	rimes
rims	6	59	3630	2	rims
rimy	9	66	2128	2	rimy
rin	3	66	6318	2	ri_n
rind	5	65	3560	2	rind
ring	5	65	4115	2	ring
rink	8	77	3699	2	rink
rins	4	61	5319	2	rins
rinse	5	48	2097	2	rinse
riot	4	59	4721	2	riot
rip	5	68	5130	2	ri_p
riped	8	52	2643	2	riped
ripen	7	56	1926	2	ripen
riper	7	43	2840	2	riper
ripes	7	54	3577	2	ripes
rips	6	62	3743	2	rips
risen	5	46	2188	2	risen
riser	5	54	3105	2	riser
rises	5	52	4404	2	rises
risk	8	57	2410	2	risk
rites	5	44	4255	2	rites
ritz	13	51	2998	2	ritz
rived	9	48	2561	2	rived
riven	8	51	2162	2	riven
river	8	57	3169	2	river
rives	8	53	3600	2	rives
rivet	8	56	3636	2	rivet
robe	6	53	3564	2	robe
rode	5	58	4430	2	rode
roe	3	68	6108	2	r_oe
role	4	58	5182	2	role
rope	6	55	4291	2	rope
rose	4	61	4890	2	rose
rote	4	62	4902	2	rote
roue	4	59	4174	2	roue
rove	7	51	3698	2	rove
rube	6	55	3201	2	rube
rude	5	56	3278	2	rude
rue	3	55	4926	2	r_ue
ruff	10	51	2765	2	ruff
ruffe	11	47	1381	2	ruffe
rule	4	99	3842	2	rule
rune	4	52	3630	2	rune
ruse	4	59	3893	2	ruse
rye	6	60	3254	2	r_ye
ryke	11	56	1640	2	ryke
safe	7	59	3095	2	safe
sice	6	55	4559	2	sice
side	5	54	4449	2	side
sift	7	107	4066	2	sift
sike	8	71	3878	2	sike
sine	4	65	6062	2	sine
sipe	6	73	4104	2	sipe
sire	4	61	5041	2	sire
site	4	70	5241	2	site
size	13	56	3096	2	size
strife	9	53	1836	2	strife
tide	5	52	3738	2	tide
tie	3	65	5753	2	ti_e
tiff	10	47	2772	2	tiff
tike	8	55	3448	2	tike
tile	4	54	5144	2	tile
time	6	62	3501	2	time
tine	4	58	5513	2	tine
tire	4	61	4335	2	tire
tribe	7	44	2027	2	tribe
trice	7	51	2749	2	trice
trifle	9	40	1288	2	trifle
trike	9	53	2016	2	trike
trine	5	47	3460	2	trine
tripe	7	54	2538	2	tripe
trite	5	47	3003	2	trite
urine	5	50	2660	2	urine
vibe	9	51	2450	2	vibe
vice	9	57	3285	2	vice
vide	8	54	3276	2	vide
vie	6	54	4763	2	vi_e
vile	7	61	3980	2	vile
vine	7	56	4368	2	vine
vise	7	56	3267	2	vise
vive	10	54	2662	2	vive
wide	8	52	3541	2	wide
wifed	12	51	1774	2	wifed
wifes	11	45	2256	2	wifes
wifey	14	49	1367	2	wifey
wile	7	59	4437	2	wile
wine	7	49	5342	2	wine
wipe	9	48	3028	2	wipe
wire	7	58	3981	2	wire
wise	7	57	3734	2	wise
wite	7	54	4327	2	wite
wive	10	59	3175	2	wive
write	8	55	2283	2	write
yipe	9	67	2218	2	yipe
zine	13	70	3615	2	zine

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.263	679433.5
2	DLD Change Limit	29872	297	0.893	33451.3
3	Display Results	297	297	0.060	4950.0
	(SQL Overall)	178691	297	1.216	146949.8