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

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

89 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
lobelia	9	4	721	(None)
lobelias	10	4	720	1	lobelias
obelia	8	32	945	1	_obelia
abelia	8	31	1440	2	_abelia
labella	9	8	895	2	labella
lobefin	12	4	460	2	lobefin
lobeline	10	3	996	2	lobeline
obeli	7	37	1193	2	_obeli_
obelias	9	27	903	2	_obelias
abelian	9	28	1065	3	_abelian
abelias	9	32	1356	3	_abelias
aboulia	9	6	655	3	aboulia
abulia	8	35	1250	3	_abulia
alopecia	12	4	443	3	alopecia
aphelia	12	4	942	3	aphelia
babesia	11	4	662	3	babesia
belga	8	3	1323	3	__belga
belie	7	56	3038	3	__belie
bohemia	14	4	636	3	bohemia
borrelia	10	4	455	3	borrelia
bumelia	11	4	526	3	bumelia
camelia	11	5	1044	3	camelia
cobia	9	41	1751	3	cob__ia
codeia	9	41	1219	3	code_ia
coeliac	11	3	823	3	co_eliac
coremia	11	3	1036	3	coremia
dobla	8	49	1364	3	dob_l_a
flabella	13	4	496	3	flabella
folia	8	36	1893	3	fo__lia
glabella	11	4	427	3	glabella
globelike	16	4	385	3	globelike
globulin	11	4	419	3	globulin
goblin	9	3	950	3	gob_lin
godetia	9	4	535	3	godetia
label	7	50	1938	3	label__
labeled	10	25	1056	3	labeled
labeler	9	23	1018	3	labeler
labeling	11	3	1165	3	labeling
labels	8	45	1568	3	label_s
labia	7	52	1901	3	lab__ia
lamella	9	8	862	3	lamella
libel	7	41	1610	3	libel__
libeled	10	24	941	3	libeled
libelee	9	25	1098	3	libelee
libeler	9	21	900	3	libeler
libeling	11	3	987	3	libeling
libelist	10	3	1082	3	libelist
libels	8	51	1269	3	libel_s
lobe	6	55	3536	3	lobe___
lobed	8	60	2213	3	lobe__d
lobefins	13	4	482	3	lobefins
lobelines	11	3	856	3	lobelines
lobes	7	53	3100	3	lobe__s
lobular	9	3	666	3	lobular
lobule	8	29	1006	3	lobul_e
lobules	9	25	1081	3	lobules
lochia	11	5	831	3	lo_chia
loculi	8	28	825	3	loculi_
logania	8	4	783	3	logania
loggia	8	45	705	3	lo_ggia
logia	6	81	1660	3	lo__gia
lomein	8	4	1020	3	lome_in
lomenta	9	27	1013	3	lomenta
lonelier	8	3	800	3	lonelier
lonelily	11	4	497	3	lonelily
lonely	9	29	1247	3	lonel_y
losel	5	44	1942	3	losel__
losels	6	47	1459	3	losel_s
lovelier	11	3	643	3	lovelier
lovelies	11	3	989	3	lovelies
lovelily	14	4	433	3	lovelily
lovely	12	33	971	3	lovel_y
mohelim	14	4	476	3	mohelim
mycelia	14	4	484	3	mycelia
nobelium	12	4	571	3	nobelium
novella	10	7	621	3	novella
obelise	9	3	1017	3	_obelise
obelisk	13	4	519	3	_obelisk
obelism	11	3	820	3	_obelism
obelize	18	3	824	3	_obelize
obelus	8	34	840	3	_obelus
obia	6	79	2311	3	_ob__ia
oboli	7	37	1287	3	_oboli_
rubella	9	14	652	3	rubella
sobeit	8	3	1536	3	sobe_it
telia	5	58	2114	3	__telia
toxemia	16	4	487	3	toxemia
zoecia	17	3	555	3	zo_ecia
zooecia	18	4	384	3	zooecia

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.436	409841.7
2	DLD Change Limit	134027	89	7.000	19146.7
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	7.466	23934.0