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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

120 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
gerbera	10	3	477	(None)
gerberas	11	4	496	1	gerberas
cerebra	11	5	592	2	cerebra
genera	7	12	1171	2	ge_nera
verbena	12	3	537	2	verbena
acerber	11	3	524	3	acerber_
aerier	6	48	2315	3	aerier_
barber	10	44	1932	3	barber_
barbers	11	43	1750	3	barbers
berberin	12	4	656	3	berberin
berberis	12	4	660	3	berberis
bergere	10	6	891	3	bergere
beriberi	12	4	345	3	beriberi
berserk	13	3	491	3	berserk
bursera	9	3	676	3	bursera
carbora	11	3	1070	3	carbora
cerebral	12	6	618	3	cerebral
cerveza	21	4	233	3	cerveza
curber	10	45	1705	3	curber_
curbers	11	55	1438	3	curbers
eerier	6	43	2002	3	eerier_
ember	9	55	1680	3	_ember_
embers	10	41	1618	3	_embers
entera	6	42	1683	3	_entera
fernery	13	3	581	3	fernery
forbear	12	3	752	3	forbear
gabber	11	49	1660	3	gabber_
gabbers	12	46	1283	3	gabbers
garbed	10	48	1566	3	garbe_d
garbler	10	40	1256	3	garbler_
garblers	11	38	1028	3	garblers
garner	7	39	1700	3	garner_
garners	8	38	1598	3	garners
garter	7	44	2051	3	garter_
garters	8	42	1823	3	garters
geezer	16	27	801	3	geezer_
geezers	17	28	651	3	geezers
gelder	8	46	1371	3	gelder_
gelders	9	38	1257	3	gelders
gender	8	35	1793	3	gender_
genders	9	36	1678	3	genders
general	8	10	1093	3	ge_neral
geneva	10	8	585	3	ge_neva
gerbil	9	3	834	3	gerb_il
gerbils	10	3	730	3	gerbils
gerent	7	32	2309	3	ger_ent
germen	9	6	1231	3	germe_n
germens	10	7	862	3	germens
germier	10	30	954	3	germier_
germina	10	3	849	3	germina
gesneria	9	4	405	3	gesneria
getter	7	41	1761	3	getter_
getters	8	42	1610	3	getters
geyser	10	3	651	3	geyser_
geysers	11	3	570	3	geysers
gibber	11	41	1286	3	gibber_
gibbers	12	47	1098	3	gibbers
giber	8	54	1770	3	g_iber_
gibers	9	51	1466	3	g_ibers
gilbert	10	3	1076	3	gilbert
girder	8	43	1206	3	girder_
girders	9	37	994	3	girders
glomera	10	3	594	3	glomera
goober	9	39	1174	3	goober_
goobers	10	21	962	3	goobers
gorger	8	61	1698	3	gorger_
gorgers	9	48	1364	3	gorgers
gorier	7	37	1937	3	gorier_
grebe	8	51	1494	3	grebe__
grebes	9	38	1361	3	grebe_s
greyer	10	45	1009	3	greyer_
herbaria	13	4	609	3	herbaria
herbed	12	35	1345	3	herbe_d
herbier	12	3	959	3	herbier_
herder	10	45	1646	3	herder_
herders	11	39	1412	3	herders
hetaera	10	3	649	3	hetaera
jerboa	15	3	563	3	jerb_oa
jerker	17	36	904	3	jerker_
jerkers	18	28	708	3	jerkers
kerbed	13	33	969	3	kerbe_d
member	12	25	885	3	member_
members	13	25	860	3	members
mercer	10	52	1420	3	mercer_
mercers	11	44	1277	3	mercers
mercery	14	39	762	3	mercery
merer	7	51	2623	3	mer_er_
merger	9	50	1647	3	merger_
mergers	10	38	1342	3	mergers
overbear	13	22	888	3	overbear
perea	7	50	2644	3	per_e_a
pereia	8	52	1798	3	per_eia
perter	8	44	2228	3	perter_
pervert	12	3	1558	3	pervert
puerpera	12	4	285	3	puerpera
serer	5	59	3550	3	ser_er_
serger	7	38	1973	3	serger_
sergers	8	38	1563	3	sergers
seriema	9	3	840	3	seriema
server	9	49	1771	3	server_
servers	10	32	1483	3	servers
sherbert	13	4	879	3	sherbert
tempera	11	32	904	3	tempera
terbia	8	3	1115	3	terb_ia
termer	8	57	1725	3	termer_
termers	9	54	1450	3	termers
terra	5	44	1966	3	ter__ra
terser	6	73	1782	3	terser_
tessera	7	3	633	3	tessera
verbenas	13	4	534	3	verbenas
verger	10	43	1569	3	verger_
vergers	11	44	1263	3	vergers
verier	9	46	2096	3	verier_
verser	9	45	1696	3	verser_
versers	10	38	1352	3	versers
vertebra	13	8	256	3	vertebra
weber	10	3	1352	3	we_ber_
webers	11	3	1094	3	we_bers
yerba	10	10	1076	3	yerb__a
zebra	16	3	788	3	ze_b_ra

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.140	1276364.3
2	DLD Change Limit	134027	120	7.546	17761.3
3	Display Results	120	120	0.046	2608.7
	(SQL Overall)	178691	120	7.732	23110.6