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

Here are the results of your fuzzy-string dictionary search for “bivalve” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

63 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
bivalve	15	4	359	(None)
bivalved	17	4	268	1	bivalved
bivalves	16	4	338	1	bivalves
trivalve	14	4	394	2	trivalve
univalve	14	4	347	2	univalve
valve	11	45	1593	2	__valve
bale	6	63	5384	3	b__al_e
behalves	16	4	408	3	behalves
behave	14	20	901	3	beha_ve
biali	7	34	1907	3	bi_al_i
bialies	9	36	1841	3	bi_alies
bialis	8	36	1716	3	bi_alis
bialy	10	51	1932	3	bi_al_y
bialys	11	38	791	3	bi_alys
bible	9	51	1942	3	bi_bl_e
biface	13	5	810	3	bifa_ce
bile	6	61	4718	3	bi__l_e
bilge	8	76	1891	3	bi__lge
billie	8	50	1917	3	bi_llie
binal	7	53	2382	3	binal__
binate	8	4	1977	3	bina_te
bindle	9	45	1626	3	bindl_e
biplane	11	3	903	3	biplane
birle	7	50	2363	3	bi_rl_e
bitable	11	3	1220	3	bitable
bivalence	16	12	460	3	bivalence
bivalent	13	4	612	3	bivalent
bizarre	18	4	410	3	bizarre
brave	10	49	2550	3	b_ra_ve
bubale	10	40	1462	3	bubal_e
calve	10	59	1992	3	__calve
cicale	10	3	1450	3	cical_e
devalue	11	3	601	3	devalue
devolve	14	31	606	3	devolve
disvalue	12	4	443	3	disvalue
divulge	12	4	310	3	divulge
divulse	11	3	491	3	divulse
evolve	12	30	650	3	_evolve
finale	9	41	1676	3	final_e
halve	11	48	1892	3	__halve
involve	13	4	509	3	involve
livable	12	20	1032	3	livable
misvalue	13	4	468	3	misvalue
nival	8	49	1577	3	nival__
revalue	10	3	815	3	revalue
revolve	13	32	837	3	revolve
rivage	10	3	884	3	riva_ge
rival	8	52	1650	3	rival__
rivaled	11	3	893	3	rivaled
rivalled	12	3	609	3	rivalled
rivalry	13	5	403	3	rivalry
rivals	9	42	1318	3	rival_s
salve	8	50	2213	3	__salve
trivalves	15	4	414	3	trivalves
univalved	16	4	348	3	univalved
univalves	15	4	339	3	univalves
vale	7	49	3734	3	__val_e
valse	8	51	1752	3	__valse
value	8	57	1909	3	__value
valved	13	67	1104	3	__valved
valves	12	41	1378	3	__valves
varve	11	57	1685	3	__varve
vivace	14	3	655	3	viva_ce

Search took 8 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	134027	0.170	1051123.5
2	DLD Change Limit	134027	63	7.220	18563.3
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	7.420	24082.3