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

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

69 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
observe	12	4	533	(None)
observed	14	4	438	1	observed
observer	13	4	473	1	observer
observes	13	4	617	1	observes
conserve	13	3	993	2	conserve
deserve	11	10	870	2	deserve
observers	14	4	397	2	observers
obverse	12	3	475	2	obverse
outserve	11	15	720	2	outserve
reobserve	14	4	247	2	reobserve
reserve	10	10	1120	2	reserve
serve	8	54	2596	2	__serve
subserve	13	4	647	2	subserve
absence	11	3	771	3	absence
absolve	12	4	451	3	absolve
absterge	11	5	408	3	absterge
berme	9	60	2294	3	_b_erme
boiserie	10	4	799	3	boiserie
breve	10	53	1705	3	_bre_ve
caserne	9	37	1006	3	caserne
conserved	15	3	885	3	conserved
conserver	14	4	872	3	conserver
conserves	14	3	1119	3	conserves
deserved	13	10	813	3	deserved
deserver	12	11	838	3	deserver
deserves	12	10	989	3	deserves
disserve	12	8	744	3	disserve
innerve	10	5	675	3	innerve
nerve	8	66	1737	3	__nerve
obese	7	52	1242	3	ob_e_se
obscene	11	4	524	3	obscene
obscure	11	4	533	3	obscure
obsecrate	13	4	464	3	obsecrate
obsequy	21	4	186	3	obsequy
observable	17	4	334	3	observ~~abl~~e
observance	17	12	404	3	observ~~anc~~e
observant	14	4	446	3	observant
observing	15	4	439	3	observing
obsess	8	4	594	3	obse_ss
obsessed	11	4	427	3	obsessed
obsesses	10	3	622	3	obsesses
obsessive	14	4	374	3	obsessive
obverses	13	3	580	3	obverses
obvert	11	4	1299	3	obver_t
obverted	14	3	510	3	obverted
obverts	12	3	540	3	obverts
outserved	13	13	646	3	outserved
outserves	12	14	737	3	outserves
preserve	13	10	880	3	preserve
reobserved	16	4	240	3	reobserved
reobserves	15	4	263	3	reobserves
reserved	12	10	1058	3	reserved
reserver	11	11	963	3	reserver
reserves	11	10	1198	3	reserves
sere	4	61	5347	3	__ser_e
serge	6	47	2747	3	__serge
served	10	46	1681	3	__served
server	9	49	1771	3	__server
serves	9	44	2365	3	__serves
servo	8	45	1668	3	__servo
subsere	9	3	1144	3	subser_e
subserved	15	4	514	3	subserved
subserves	14	4	718	3	subserves
swerve	12	5	629	3	_swerve
unnerve	10	6	665	3	unnerve
unobserved	16	4	243	3	unobserved
unserved	12	4	1023	3	unserved
verve	11	54	1772	3	__verve
wherve	15	56	811	3	_wherve

Search took 7 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.406	440125.6
2	DLD Change Limit	134027	69	6.143	21817.8
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	6.579	27160.8