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

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

374 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
wave	10	52	3473	(None)
ave	6	77	4870	1	_ave
cave	9	59	4126	1	cave
eave	7	57	3358	1	eave
fave	10	55	3296	1	fave
gave	8	46	3405	1	gave
have	10	61	3707	1	have
lave	7	56	4214	1	lave
nave	7	57	3231	1	nave
pave	9	61	3389	1	pave
rave	7	55	4209	1	rave
save	7	57	4136	1	save
wade	8	52	3706	1	wade
wae	6	75	5695	1	wa_e
wage	8	48	3408	1	wage
waive	11	42	1460	1	waive
wake	11	49	3570	1	wake
wale	7	45	4643	1	wale
wame	9	50	3548	1	wame
wane	7	63	4471	1	wane
ware	7	62	5472	1	ware
waved	12	52	2358	1	waved
waver	11	50	2570	1	waver
waves	11	56	3392	1	waves
wavey	14	51	1554	1	wavey
wavy	13	66	2047	1	wavy
weave	11	52	1853	1	weave
wive	10	59	3175	1	wive
wove	10	56	2431	1	wove
ace	5	96	5683	2	_ace
ae	2	125	9029	2	_a_e
agave	9	53	1403	2	agave
age	4	71	5433	2	_age
ale	3	65	7234	2	_ale
ane	3	78	6694	2	_ane
ape	5	72	5118	2	_ape
are	3	78	7457	2	_are
ate	3	70	5924	2	_ate
ava	6	101	3932	2	_ava
aver	7	59	3188	2	_aver
aves	7	61	4260	2	_aves
avo	6	89	3623	2	_avo
awake	12	50	1478	2	awake
aware	8	64	2002	2	aware
awe	6	77	4662	2	_awe
awee	7	63	3664	2	awee
axe	10	82	3949	2	_axe
aye	6	71	5176	2	_aye
babe	8	68	3581	2	babe
bade	7	51	4088	2	bade
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
bane	6	52	5042	2	bane
bare	6	54	6052	2	bare
base	6	48	4702	2	base
bate	6	65	5242	2	bate
brave	10	49	2550	2	brave
cade	7	64	4391	2	cade
cafe	9	52	3032	2	cafe
cage	7	53	3906	2	cage
cake	10	54	3996	2	cake
calve	10	59	1992	2	calve
came	8	76	4875	2	came
cane	6	66	5311	2	cane
cape	8	72	4278	2	cape
care	6	69	6837	2	care
carve	10	62	2775	2	carve
case	6	58	4808	2	case
cate	6	62	5459	2	cate
caved	11	62	2756	2	caved
caver	10	56	2906	2	caver
caves	10	56	3970	2	caves
cavie	10	46	2159	2	cavie
cavy	12	59	2000	2	cavy
clave	10	54	2015	2	clave
cove	9	58	3707	2	cove
crave	10	56	2631	2	crave
dace	7	69	3492	2	dace
dale	5	56	4398	2	dale
dame	7	71	4031	2	dame
dare	5	58	4886	2	dare
date	5	64	4332	2	date
daven	9	49	1647	2	daven
davy	11	60	1552	2	davy
daze	14	73	2723	2	daze
deave	9	50	2233	2	deave
dive	8	56	3477	2	dive
dove	8	51	3156	2	dove
drave	9	52	1927	2	drave
ease	4	50	4233	2	ease
eaved	9	59	2450	2	eaved
eaves	8	52	3199	2	eaves
eve	6	63	3116	2	_eve
face	9	61	4012	2	face
fade	8	57	3634	2	fade
fake	11	55	3494	2	fake
fame	9	56	3939	2	fame
fane	7	53	4356	2	fane
fare	7	63	5446	2	fare
fate	7	54	4428	2	fate
fauve	11	47	1207	2	fauve
fava	10	68	2026	2	fava
faves	11	53	3142	2	faves
faze	16	56	3004	2	faze
five	10	76	2974	2	five
gae	4	64	5770	2	ga_e
gage	6	59	3610	2	gage
gale	5	63	4732	2	gale
game	7	66	4432	2	game
gane	5	51	4529	2	gane
gape	7	51	3451	2	gape
gate	5	57	4657	2	gate
gavel	9	58	1518	2	gavel
gaze	14	50	3241	2	gaze
give	8	58	2935	2	give
grave	9	46	2487	2	grave
gyve	11	62	1508	2	gyve
hade	8	54	4019	2	hade
hae	6	73	6400	2	ha_e
hake	11	56	3784	2	hake
hale	7	60	5283	2	hale
halve	11	48	1892	2	halve
hame	9	70	4313	2	hame
hare	7	62	5573	2	hare
hate	7	84	5017	2	hate
haven	11	47	1853	2	haven
haver	11	51	2446	2	haver
haves	11	60	3487	2	haves
haze	16	48	3339	2	haze
heave	11	45	2181	2	heave
hive	10	60	2967	2	hive
hove	10	71	3222	2	hove
jade	12	53	2544	2	jade
jake	15	59	2577	2	jake
jane	11	50	3147	2	jane
jape	13	49	2342	2	jape
java	14	73	1664	2	java
jive	14	61	2359	2	jive
kae	7	67	4454	2	ka_e
kale	8	65	3375	2	kale
kame	10	57	2823	2	kame
kane	8	51	3396	2	kane
kava	11	58	1970	2	kava
knave	12	38	946	2	knave
lace	6	68	4847	2	lace
lade	5	63	4598	2	lade
lake	8	57	4160	2	lake
lame	6	68	4929	2	lame
lane	4	51	5332	2	lane
lase	4	61	4851	2	lase
late	4	75	6048	2	late
lav	6	68	4734	2	lav_
lava	7	67	2542	2	lava
laved	9	50	2859	2	laved
laver	8	50	3179	2	laver
laves	8	60	3915	2	laves
lavs	7	67	3415	2	lavs
laze	13	62	3505	2	laze
leave	8	47	2372	2	leave
live	7	65	4099	2	live
love	7	52	3476	2	love
mabe	8	57	3334	2	mabe
mace	8	73	4578	2	mace
made	7	54	4023	2	made
mae	5	76	5910	2	ma_e
mage	7	57	3912	2	mage
make	10	55	3788	2	make
male	6	60	5229	2	male
mane	6	50	5201	2	mane
mare	6	47	5932	2	mare
mate	6	51	5421	2	mate
mauve	10	40	1327	2	mauve
maven	10	48	1689	2	maven
mavie	10	47	2256	2	mavie
maze	15	54	3497	2	maze
move	9	66	3072	2	move
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	na_e
naive	8	51	1621	2	naive
name	6	56	3741	2	name
nape	6	52	3080	2	nape
navel	8	70	1657	2	navel
naves	8	70	3038	2	naves
navy	10	75	1863	2	navy
neve	7	62	2483	2	neve
oaves	8	49	2561	2	oaves
pace	8	63	4577	2	pace
page	7	60	3610	2	page
pale	6	60	5501	2	pale
pane	6	49	5028	2	pane
pare	6	67	6084	2	pare
parve	10	98	2485	2	parve
pase	6	53	4686	2	pase
pate	6	53	5046	2	pate
paved	11	55	2526	2	paved
paver	10	42	2583	2	paver
paves	10	48	3392	2	paves
race	6	67	4626	2	race
rage	5	57	4235	2	rage
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
reave	8	45	2802	2	reave
rive	7	55	3772	2	rive
rove	7	51	3698	2	rove
sabe	6	61	4057	2	sabe
sade	5	55	4447	2	sade
sae	3	83	6518	2	sa_e
safe	7	59	3095	2	safe
sage	5	50	4459	2	sage
sake	8	52	4496	2	sake
sale	4	49	5970	2	sale
salve	8	50	2213	2	salve
same	6	52	4564	2	same
sane	4	59	5433	2	sane
sate	4	55	5610	2	sate
saved	9	51	2711	2	saved
saver	8	48	3125	2	saver
saves	8	58	3863	2	saves
shave	11	44	2589	2	shave
slave	8	42	2403	2	slave
soave	8	42	1905	2	soave
stave	8	53	2499	2	stave
suave	8	35	1987	2	suave
swage	9	49	1956	2	swage
swale	8	52	2159	2	swale
sware	8	58	2821	2	sware
swive	11	53	1619	2	swive
tace	6	53	4251	2	tace
tae	3	82	6705	2	ta_e
take	8	47	3926	2	take
tale	4	61	5416	2	tale
tame	6	63	4366	2	tame
tape	6	45	3814	2	tape
tare	4	59	5762	2	tare
tate	4	47	4860	2	tate
tav	6	60	4321	2	tav_
tavs	7	56	3097	2	tavs
trave	8	52	2303	2	trave
twae	7	47	1957	2	twa_e
vale	7	49	3734	2	vale
valve	11	45	1593	2	valve
vane	7	55	3468	2	vane
varve	11	57	1685	2	varve
vase	7	56	2965	2	vase
vav	9	58	2943	2	vav_
vavs	10	57	2043	2	vavs
vive	10	54	2662	2	vive
wab	8	70	5183	2	wa_b
wabs	9	73	3723	2	wabs
wack	13	53	3091	2	wack
wacke	14	59	1862	2	wacke
wad	7	70	5389	2	wa_d
waded	10	60	2475	2	waded
wader	9	53	2536	2	wader
wades	9	56	3414	2	wades
wadi	8	62	2817	2	wadi
wads	8	73	4314	2	wads
wady	11	53	2499	2	wady
waes	7	60	4860	2	waes
wafer	11	44	1764	2	wafer
waff	13	42	2804	2	waff
waft	10	61	3900	2	waft
wag	7	64	5175	2	wa_g
waged	10	48	2278	2	waged
wager	9	59	2505	2	wager
wages	9	53	3093	2	wages
wags	8	61	4055	2	wags
waif	10	58	3674	2	waif
wail	7	52	3882	2	wail
wain	7	58	4019	2	wain
wair	7	58	3005	2	wair
wait	7	55	5369	2	wait
waived	13	45	1128	2	waived
waiver	12	42	1271	2	waiver
waives	12	37	1418	2	waives
waked	13	56	2675	2	waked
waken	12	48	1847	2	waken
waker	12	55	2659	2	waker
wakes	12	66	3365	2	wakes
waled	9	43	3099	2	waled
waler	8	42	2926	2	waler
wales	8	61	4283	2	wales
walk	11	56	2561	2	walk
wall	7	62	3610	2	wall
waly	10	58	3090	2	waly
wames	10	64	3280	2	wames
wan	6	67	6193	2	wa_n
wand	8	58	3387	2	wand
waned	9	58	3178	2	waned
wanes	8	50	4088	2	wanes
waney	11	51	2032	2	waney
wank	11	56	3250	2	wank
wans	7	64	5226	2	wans
want	7	61	5616	2	want
wany	10	64	3235	2	wany
wap	8	65	5337	2	wa_p
waps	9	66	4208	2	waps
war	6	72	6242	2	wa_r
ward	8	65	4225	2	ward
wared	9	63	3987	2	wared
wares	8	82	5058	2	wares
wark	11	57	3777	2	wark
warm	9	59	3567	2	warm
warn	7	52	3932	2	warn
warp	9	56	3500	2	warp
wars	7	86	5980	2	wars
wart	7	78	6608	2	wart
wary	10	67	4001	2	wary
was	6	87	6756	2	wa_s
wash	10	60	3381	2	wash
wasp	9	56	2685	2	wasp
wast	7	56	5585	2	wast
waste	8	61	2505	2	waste
wat	6	73	7892	2	wa_t
water	8	47	3331	2	water
wats	7	75	5588	2	wats
watt	7	55	4541	2	watt
wauk	11	52	2059	2	wauk
waul	7	69	2731	2	waul
waur	7	68	1990	2	waur
wavers	12	50	2247	2	wavers
wavery	15	46	1005	2	wavery
waveys	15	59	701	2	waveys
wavier	12	46	1308	2	wavier
wavies	12	50	1984	2	wavies
waw	9	70	4638	2	wa_w
wawl	10	53	2194	2	wawl
waws	10	68	3490	2	waws
wax	13	70	4118	2	wa_x
waxed	16	60	1848	2	waxed
waxen	15	49	1181	2	waxen
waxer	15	43	1748	2	waxer
waxes	15	58	2550	2	waxes
waxy	17	59	1820	2	waxy
way	9	67	5766	2	wa_y
ways	10	77	3795	2	ways
we	5	70	4345	2	w__e
weaved	13	39	1348	2	weaved
weaver	12	39	1661	2	weaver
weaves	12	36	1637	2	weaves
wee	6	67	6081	2	w_ee
were	7	62	3833	2	were
whale	11	55	1743	2	whale
wharve	15	45	620	2	wharve
whee	10	54	2959	2	whee
wide	8	52	3540	2	wide
wife	10	52	2802	2	wife
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
wived	12	51	2150	2	wived
wiver	11	59	2451	2	wiver
wives	11	53	2892	2	wives
woe	6	66	5124	2	w_oe
woke	11	55	2796	2	woke
wore	7	71	4467	2	wore
woven	11	52	1517	2	woven
wye	9	63	3197	2	w_ye
wyle	10	55	1938	2	wyle
wyte	10	60	1864	2	wyte
yare	7	56	3694	2	yare

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.076	2351197.4
2	DLD Change Limit	29872	374	0.923	32364.0
3	Display Results	374	374	0.093	4021.5
	(SQL Overall)	178691	374	1.092	163636.4