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

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

351 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
rive	7	55	3773	(None)
dive	8	56	3478	1	dive
drive	9	53	1800	1	drive
five	10	76	2975	1	five
give	8	58	2936	1	give
hive	10	60	2968	1	hive
jive	14	61	2360	1	jive
live	7	65	4100	1	live
rave	7	55	4209	1	rave
reive	8	55	2294	1	reive
rice	6	49	4292	1	rice
ride	5	59	4514	1	ride
rife	7	46	3233	1	rife
rile	4	56	5054	1	rile
rime	6	51	3889	1	rime
ripe	6	60	3893	1	ripe
rise	4	59	4524	1	rise
rite	4	58	4946	1	rite
rived	9	48	2561	1	rived
riven	8	51	2162	1	riven
river	8	57	3169	1	river
rives	8	53	3600	1	rives
rivet	8	56	3636	1	rivet
rove	7	51	3698	1	rove
vive	10	54	2663	1	vive
wive	10	59	3176	1	wive
aide	5	60	4501	2	aide
aiver	8	57	2516	2	aiver
alive	8	57	2251	2	alive
arise	5	64	3643	2	arise
arrive	9	13	1179	2	arrive
ave	6	77	4870	2	_ave
bice	8	62	3557	2	bice
bide	7	60	4151	2	bide
bike	10	65	3261	2	bike
bile	6	61	4719	2	bile
bine	6	66	5087	2	bine
bise	6	64	3711	2	bise
bite	6	65	4701	2	bite
bize	15	59	2630	2	bize
brave	10	49	2550	2	brave
breve	10	53	1705	2	breve
bribe	9	48	2078	2	bribe
bride	8	64	2554	2	bride
brie	6	58	3790	2	bri_e
brine	7	51	3227	2	brine
cave	9	59	4126	2	cave
chive	13	51	1762	2	chive
cine	6	62	4295	2	cine
cire	6	58	3638	2	cire
cite	6	56	4035	2	cite
civet	10	58	2873	2	civet
civie	10	37	1635	2	civie
cove	9	58	3707	2	cove
crave	10	56	2631	2	crave
crime	9	48	2269	2	crime
cripe	9	55	2114	2	cripe
derive	10	38	1704	2	derive
dice	7	58	4190	2	dice
die	4	67	5966	2	di_e
dike	9	59	3577	2	dike
dime	7	62	3765	2	dime
dine	5	55	5534	2	dine
dire	5	66	4415	2	dire
dite	5	55	4756	2	dite
diva	8	59	2089	2	diva
dived	10	63	2137	2	dived
diver	9	48	2780	2	diver
dives	9	58	3240	2	dives
dove	8	51	3156	2	dove
drave	9	52	1927	2	drave
drivel	10	51	1038	2	drivel
driven	10	52	1014	2	driven
driver	10	47	1449	2	driver
drives	10	51	1711	2	drives
drove	9	55	1806	2	drove
eave	7	57	3358	2	eave
eide	5	58	3225	2	eide
eve	6	63	3116	2	_eve
fave	10	55	3296	2	fave
fice	9	57	3712	2	fice
fie	6	71	5245	2	fi_e
fife	10	60	2771	2	fife
file	7	54	4665	2	file
fine	7	51	4796	2	fine
fire	7	62	4560	2	fire
fiver	11	60	2494	2	fiver
fives	11	60	2736	2	fives
frise	8	53	2245	2	frise
gave	8	46	3405	2	gave
gibe	7	59	2779	2	gibe
gie	4	71	4955	2	gi_e
gite	5	54	3862	2	gite
given	9	59	1528	2	given
giver	9	49	2120	2	giver
gives	9	53	2487	2	gives
grave	9	46	2487	2	grave
gride	7	52	2359	2	gride
grieve	10	4	724	2	grieve
grime	8	50	2132	2	grime
gripe	8	46	2296	2	gripe
grivet	10	35	1782	2	grivet
grove	9	52	1933	2	grove
gyve	11	62	1508	2	gyve
have	10	61	3707	2	have
hide	8	51	3465	2	hide
hie	6	76	5271	2	hi_e
hike	11	68	3040	2	hike
hire	7	55	3897	2	hire
hived	12	52	1791	2	hived
hives	11	69	2551	2	hives
hove	10	71	3222	2	hove
ice	5	67	3725	2	_ice
ire	3	69	4318	2	_ire
ivy	9	63	1745	2	_ivy
jibe	13	63	2340	2	jibe
jived	16	51	1504	2	jived
jiver	15	51	1905	2	jiver
jives	15	48	2081	2	jives
jivey	18	51	1187	2	jivey
jivy	17	62	1312	2	jivy
kibe	10	65	2346	2	kibe
kike	7	65	2480	2	kike
kine	8	56	4344	2	kine
kite	8	53	3825	2	kite
kiva	11	65	1642	2	kiva
lave	7	56	4214	2	lave
lice	6	60	4507	2	lice
lie	3	82	6453	2	li_e
lieve	8	63	1547	2	lieve
life	7	54	3374	2	life
like	8	60	4085	2	like
lime	6	62	4494	2	lime
line	4	69	6558	2	line
lipe	6	68	3974	2	lipe
lire	4	78	4530	2	lire
lite	4	70	5455	2	lite
lived	9	55	2372	2	lived
liven	8	50	2173	2	liven
liver	8	51	3296	2	liver
lives	8	61	3319	2	lives
livre	8	56	1325	2	livre
love	7	52	3476	2	love
mice	8	74	4224	2	mice
mike	10	55	3530	2	mike
mile	6	63	5258	2	mile
mime	8	57	3641	2	mime
mine	6	72	5618	2	mine
mire	6	67	4824	2	mire
mise	6	60	4359	2	mise
mite	6	62	4942	2	mite
move	9	66	3072	2	move
naive	8	51	1621	2	naive
nave	7	57	3231	2	nave
neve	7	62	2483	2	neve
nice	6	55	3472	2	nice
nide	5	55	3580	2	nide
nieve	8	56	1318	2	nieve
nine	4	58	4218	2	nine
nite	4	59	4359	2	nite
nixe	11	57	2203	2	nixe
ogive	9	37	909	2	ogive
olive	8	48	1715	2	olive
pave	9	61	3389	2	pave
pice	8	46	4110	2	pice
pie	5	54	5741	2	pi_e
pike	10	63	3522	2	pike
pile	6	56	4970	2	pile
pine	6	77	5572	2	pine
pipe	8	64	3444	2	pipe
price	9	37	2541	2	price
pride	8	47	2474	2	pride
prime	9	65	2560	2	prime
prise	7	46	3261	2	prise
privet	11	38	2134	2	privet
privy	13	43	983	2	privy
prize	16	47	1894	2	prize
prove	10	48	2319	2	prove
race	6	67	4626	2	race
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
raved	9	49	3143	2	raved
ravel	8	46	2151	2	ravel
raven	8	47	2344	2	raven
raver	8	56	3149	2	raver
raves	8	54	4197	2	raves
raze	13	52	3543	2	raze
re	2	61	5374	2	r__e
reave	8	45	2802	2	reave
rede	5	50	3768	2	rede
ree	3	79	7407	2	r_ee
reeve	8	41	2132	2	reeve
regive	10	48	1432	2	regive
reived	10	45	1813	2	reived
reiver	9	53	1829	2	reiver
reives	9	57	2304	2	reives
relive	9	51	2078	2	relive
rete	4	49	4413	2	rete
rev	6	53	3662	2	rev_
revel	8	44	2316	2	revel
revet	8	49	3884	2	revet
revive	12	49	1482	2	revive
revs	7	50	2705	2	revs
revue	8	11	1445	2	revue
ria	3	67	4551	2	ri_a
rial	4	59	3810	2	rial
rias	4	55	4060	2	rias
rib	5	68	4804	2	ri_b
ribes	7	55	3017	2	ribes
ribs	6	58	3303	2	ribs
riced	8	58	2554	2	riced
ricer	7	47	2661	2	ricer
rices	7	55	3615	2	rices
rich	9	70	2555	2	rich
rick	10	73	3466	2	rick
rid	4	67	5464	2	ri_d
rider	6	52	3131	2	rider
rides	6	61	4082	2	rides
ridge	7	50	1868	2	ridge
rids	5	65	3956	2	rids
riel	4	64	3239	2	riel
riever	9	48	1165	2	riever
rif	6	59	5157	2	ri_f
rifer	8	47	2198	2	rifer
riff	10	44	3011	2	riff
rifle	8	55	1833	2	rifle
rifs	7	49	2901	2	rifs
rift	7	56	4234	2	rift
rig	4	67	4813	2	ri_g
rigs	5	51	3760	2	rigs
riled	6	58	3325	2	riled
riles	5	53	4364	2	riles
riley	8	44	2058	2	riley
rill	4	51	4091	2	rill
rille	5	57	2873	2	rille
rim	5	60	5228	2	ri_m
rimed	8	48	2637	2	rimed
rimer	7	54	2924	2	rimer
rimes	7	56	3454	2	rimes
rims	6	59	3631	2	rims
rimy	9	66	2129	2	rimy
rin	3	66	6319	2	ri_n
rind	5	65	3561	2	rind
ring	5	65	4116	2	ring
rink	8	77	3700	2	rink
rins	4	61	5320	2	rins
rinse	5	48	2097	2	rinse
riot	4	59	4722	2	riot
rip	5	68	5131	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	3744	2	rips
risen	5	46	2188	2	risen
riser	5	54	3105	2	riser
rises	5	52	4404	2	rises
risk	8	57	2411	2	risk
rites	5	44	4255	2	rites
ritz	13	51	2999	2	ritz
rivage	10	3	884	2	rivage
rival	8	52	1650	2	rival
rivers	9	46	2654	2	rivers
rivets	9	44	1711	2	rivets
robe	6	53	3564	2	robe
rode	5	58	4431	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
roved	9	53	2355	2	roved
roven	8	55	2197	2	roven
rover	8	55	2737	2	rover
roves	8	48	3448	2	roves
rube	6	55	3201	2	rube
rude	5	56	3279	2	rude
rue	3	55	4926	2	r_ue
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
save	7	57	4136	2	save
scrive	11	54	1494	2	scrive
shive	11	44	2342	2	shive
shrive	12	52	1695	2	shrive
sice	6	55	4560	2	sice
side	5	54	4450	2	side
sieve	8	49	1884	2	sieve
sike	8	71	3879	2	sike
sine	4	65	6063	2	sine
sipe	6	73	4105	2	sipe
sire	4	61	5042	2	sire
site	4	70	5242	2	site
siver	8	57	2861	2	siver
size	13	56	3097	2	size
skive	12	46	1412	2	skive
strive	9	50	2096	2	strive
swive	11	53	1619	2	swive
thrive	12	53	1322	2	thrive
tide	5	52	3739	2	tide
tie	3	65	5754	2	ti_e
tike	8	55	3449	2	tike
tile	4	54	5145	2	tile
time	6	62	3502	2	time
tine	4	58	5514	2	tine
tire	4	61	4336	2	tire
tivy	10	145	1687	2	tivy
trave	8	52	2303	2	trave
tribe	7	44	2027	2	tribe
trice	7	51	2749	2	trice
trike	9	53	2016	2	trike
trine	5	47	3460	2	trine
tripe	7	54	2538	2	tripe
trite	5	47	3003	2	trite
trivet	9	37	2188	2	trivet
trove	8	52	2192	2	trove
urine	5	50	2660	2	urine
vibe	9	51	2451	2	vibe
vice	9	57	3286	2	vice
vide	8	54	3277	2	vide
vie	6	54	4764	2	vi_e
vile	7	61	3981	2	vile
vine	7	56	4369	2	vine
vise	7	56	3268	2	vise
viva	10	61	1910	2	viva
waive	11	42	1460	2	waive
wave	10	52	3473	2	wave
wide	8	52	3542	2	wide
wife	10	52	2803	2	wife
wile	7	59	4438	2	wile
wine	7	49	5343	2	wine
wipe	9	48	3029	2	wipe
wire	7	58	3982	2	wire
wise	7	57	3735	2	wise
wite	7	54	4328	2	wite
wived	12	51	2150	2	wived
wiver	11	59	2451	2	wiver
wives	11	53	2892	2	wives
wove	10	56	2431	2	wove
write	8	55	2283	2	write
yipe	9	67	2219	2	yipe
zine	13	70	3616	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.313	570897.8
2	DLD Change Limit	29872	351	1.030	29001.9
3	Display Results	351	351	0.093	3774.2
	(SQL Overall)	178691	351	1.436	124436.6