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

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

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.

66 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
tabby	12	52	1389	(None)
cabby	14	53	1456	1	cabby
gabby	13	55	1295	1	gabby
tubby	12	45	1140	1	tubby
yabby	15	38	975	1	yabby
abba	8	105	2265	2	_abba
abbe	8	76	2719	2	_abbe
abbey	12	57	1493	2	_abbey
ably	9	97	2513	2	_ably
aby	8	102	3806	2	_a_by
baby	11	67	2368	2	ba_by
blabby	12	3	481	2	blabby
bobby	11	48	1466	2	bobby
bubby	11	50	1393	2	bubby
cobby	14	55	1641	2	cobby
crabby	15	34	675	2	crabby
cubby	14	52	1212	2	cubby
dauby	11	52	1122	2	dauby
dobby	13	60	1363	2	dobby
flabby	16	3	457	2	flabby
gaby	10	71	2319	2	ga_by
grabby	14	33	618	2	grabby
hobby	15	59	1373	2	hobby
hubby	15	50	1140	2	hubby
lamby	12	51	1484	2	lamby
lobby	12	51	1392	2	lobby
nobby	12	55	1346	2	nobby
nubby	12	50	1103	2	nubby
rabbi	9	31	1318	2	rabbi
ribby	12	41	968	2	ribby
rubby	12	44	1386	2	rubby
scabby	15	3	550	2	scabby
shabby	16	3	580	2	shabby
stably	11	33	1412	2	stably
stubby	13	4	504	2	stubby
swabby	16	3	435	2	swabby
tab	5	74	6032	2	ta_b_
tabbed	11	42	1536	2	tabbed
tabbis	10	29	1086	2	tabbis
taber	7	38	2582	2	taber
tabes	7	60	3392	2	tabes
tabid	8	44	1826	2	tabid
tabla	7	33	1836	2	tabla
table	7	54	2960	2	table
taboo	7	34	1809	2	taboo
tabor	7	55	1839	2	tabor
tabs	6	68	4298	2	ta_bs
tabu	6	63	2849	2	ta_bu
tabun	7	59	1437	2	tabun
tabus	7	48	2092	2	tabus
tacky	14	56	1744	2	tacky
taffy	14	51	1082	2	taffy
talky	12	62	1568	2	talky
tally	8	45	2686	2	tally
tammy	12	40	1322	2	tammy
tangy	9	45	1993	2	tangy
tansy	8	45	1493	2	tansy
tardy	9	47	2046	2	tardy
tarry	8	54	2251	2	tarry
tarty	8	63	2818	2	tarty
tasty	8	48	2031	2	tasty
tatty	8	47	2018	2	tatty
tawny	11	47	1365	2	tawny
toby	9	63	2229	2	t_oby
wabbly	16	34	836	2	wabbly
webby	15	3	715	2	webby

Search took 2 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.296	603685.8
2	DLD Change Limit	53800	66	1.486	36204.6
3	Display Results	66	66	0.013	5076.9
	(SQL Overall)	178691	66	1.795	99549.3