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

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

106 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
omber	9	53	1644	(None)
amber	9	45	2321	1	amber
bomber	12	50	1465	1	bomber
comber	12	51	1850	1	comber
ember	9	55	1680	1	ember
ombers	10	42	1440	1	ombers
ombre	9	41	1180	1	ombre
omer	6	70	2839	1	om_er
somber	10	37	1400	1	somber
umber	9	46	1759	1	umber
ambeer	10	45	1160	2	ambeer
ambers	10	45	1958	2	ambers
ambery	13	38	1113	2	ambery
ambler	10	49	1645	2	ambler
ameer	7	56	1898	2	ameer
bobber	9	50	1674	2	bobber
bombe	11	55	1931	2	bombe_
bombed	13	41	1387	2	bombed
bombers	13	45	1259	2	bombers
bombes	12	49	1682	2	bombes
caber	9	51	2683	2	caber
camber	12	44	1848	2	camber
cobber	12	41	1684	2	cobber
combe	11	62	2354	2	combe_
combed	13	55	1654	2	combed
combers	13	45	1662	2	combers
combes	12	53	2173	2	combes
comer	9	58	3269	2	com_er
cuber	9	52	2253	2	cuber
cumber	12	40	1670	2	cumber
cyber	12	49	1038	2	cyber
dobber	11	40	1542	2	dobber
dumber	11	44	1417	2	dumber
embar	9	40	1160	2	embar
embed	10	50	1430	2	embed
embers	10	41	1618	2	embers
emeer	7	48	1536	2	emeer
emmer	9	43	1446	2	emmer
fiber	10	49	2113	2	fiber
giber	8	54	1770	2	giber
gomer	8	52	2065	2	gom_er
goober	9	39	1174	2	goober
hobber	13	41	1463	2	hobber
hombre	13	30	930	2	hombre
homer	10	58	2845	2	hom_er
homier	11	64	1699	2	homier
imbed	10	50	1365	2	imbed
jiber	14	51	1570	2	jiber
jobber	17	38	1335	2	jobber
lamber	10	44	1849	2	lamber
liber	7	47	2362	2	liber
limber	10	43	1679	2	limber
lobber	10	40	1660	2	lobber
lumber	10	38	1777	2	lumber
member	12	25	885	2	member
mobber	12	36	1346	2	mobber
momser	10	40	1141	2	momser
momzer	19	32	755	2	momzer
moper	9	49	2592	2	moper
mover	10	42	2086	2	mover
mower	10	45	2345	2	mower
number	10	39	1322	2	number
oater	5	54	3373	2	oater
obe	5	66	3864	2	o_be_
obes	6	60	3683	2	o_bes
obey	9	65	2130	2	o_bey
ocher	10	45	1610	2	ocher
ocker	11	39	1575	2	ocker
odder	7	45	1539	2	odder
offer	11	43	1138	2	offer
ofter	8	41	1687	2	ofter
ogler	6	59	1744	2	ogler
oiler	5	46	2828	2	oiler
older	6	51	2117	2	older
ombres	10	39	1114	2	ombres
omen	6	68	2818	2	om_en
omers	7	69	2319	2	om_ers
orbed	8	55	1619	2	orbed
orbier	8	3	999	2	orbier
order	6	50	1936	2	order
ormer	7	52	1837	2	ormer
osier	5	35	1801	2	osier
other	8	42	1910	2	other
otter	5	44	2397	2	otter
outer	5	56	3330	2	outer
over	7	72	2734	2	o_ver
owner	8	46	1331	2	owner
oxter	12	34	1409	2	oxter
oyer	7	59	2765	2	o_yer
robber	10	39	1653	2	robber
romper	10	42	1368	2	romper
saber	7	53	3024	2	saber
sobber	10	40	1659	2	sobber
sober	7	48	2241	2	sober
sombre	10	72	947	2	sombre
suber	7	49	2450	2	suber
taber	7	38	2582	2	taber
timber	10	40	1268	2	timber
tombed	11	38	1213	2	tombed
tuber	7	54	2068	2	tuber
umbel	9	36	1284	2	umbel
umbers	10	42	1521	2	umbers
vomer	10	55	1738	2	vom_er
weber	10	3	1352	2	weber
wombed	14	41	923	2	wombed
wombier	14	3	654	2	wombier

Search took 3 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	53800	0.406	440125.6
2	DLD Change Limit	53800	106	1.593	33772.8
3	Display Results	106	106	0.033	3212.1
	(SQL Overall)	178691	106	2.032	87938.5