History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sapsuckers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
133 | 2024-05-06 17:05:04 | sapsuckers | 3 | 140603 | 13 | 6.690 | 21016.9 |
132 | 2024-05-06 12:34:16 | sapsuckers | 4 | 161450 | 128 | 14.080 | 11466.6 |
131 | 2024-04-25 22:07:38 | sapsuckers | 1 | 67641 | 2 | 1.310 | 51634.4 |
130 | 2024-04-08 15:25:00 | sapsuckers | 1 | 67641 | 2 | 1.326 | 51011.3 |
129 | 2024-04-06 05:15:51 | sapsuckers | 1 | 67641 | 2 | 1.046 | 64666.3 |
128 | 2024-04-05 03:44:17 | sapsuckers | 1 | 67641 | 2 | 2.110 | 32057.3 |
127 | 2024-03-31 14:51:25 | sapsuckers | 4 | 161450 | 128 | 38.876 | 4152.9 |
126 | 2024-03-31 11:03:21 | sapsuckers | 4 | 161450 | 128 | 31.393 | 5142.9 |
125 | 2024-03-22 00:14:23 | sapsuckers | 4 | 161450 | 128 | 43.816 | 3684.7 |
124 | 2024-03-16 12:29:48 | sapsuckers | 4 | 161450 | 128 | 32.456 | 4974.4 |
123 | 2024-03-16 12:29:39 | sapsuckers | 3 | 140603 | 13 | 12.986 | 10827.3 |
122 | 2024-03-16 12:29:43 | sapsuckers | 2 | 108824 | 2 | 3.766 | 28896.4 |
121 | 2024-03-16 12:28:45 | sapsuckers | 1 | 67641 | 2 | 2.783 | 24305.1 |
120 | 2024-03-04 20:50:07 | sapsuckers | 1 | 67641 | 2 | 2.486 | 27208.8 |
119 | 2024-03-03 17:16:46 | sapsuckers | 4 | 161450 | 128 | 32.046 | 5038.1 |
118 | 2024-03-03 17:16:46 | sapsuckers | 3 | 140603 | 13 | 15.376 | 9144.3 |
117 | 2024-03-03 17:16:52 | sapsuckers | 2 | 108824 | 2 | 8.610 | 12639.3 |
116 | 2024-03-03 17:12:52 | sapsuckers | 1 | 67641 | 2 | 1.126 | 60071.9 |
115 | 2024-02-29 09:13:47 | sapsuckers | 1 | 67641 | 2 | 1.156 | 58513.0 |
114 | 2024-02-28 21:18:42 | sapsuckers | 1 | 67641 | 2 | 1.263 | 53555.8 |
113 | 2024-02-28 21:16:42 | sapsuckers | 1 | 67641 | 2 | 2.486 | 27208.8 |
112 | 2024-02-12 03:57:54 | sapsuckers | 1 | 67641 | 2 | 1.343 | 50365.6 |
111 | 2024-02-12 03:56:11 | sapsuckers | 3 | 140603 | 13 | 17.156 | 8195.6 |
110 | 2024-02-11 15:11:10 | sapsuckers | 4 | 161450 | 128 | 17.033 | 9478.7 |
109 | 2024-02-10 16:00:35 | sapsuckers | 3 | 140603 | 13 | 23.550 | 5970.4 |
108 | 2024-02-10 15:59:49 | sapsuckers | 4 | 161450 | 128 | 24.880 | 6489.1 |
107 | 2024-01-31 09:50:15 | sapsuckers | 1 | 67641 | 2 | 1.173 | 57665.0 |
106 | 2024-01-29 21:01:35 | sapsuckers | 1 | 67641 | 2 | 1.220 | 55443.4 |
105 | 2024-01-29 21:01:33 | sapsuckers | 1 | 67641 | 2 | 1.203 | 56226.9 |
104 | 2024-01-05 04:42:01 | sapsuckers | 2 | 108824 | 2 | 3.156 | 34481.6 |
103 | 2024-01-01 01:38:46 | sapsuckers | 4 | 161450 | 128 | 10.576 | 15265.7 |
102 | 2023-12-31 13:08:04 | sapsuckers | 3 | 140603 | 13 | 5.626 | 24991.6 |
101 | 2023-12-26 14:38:10 | sapsuckers | 1 | 67641 | 2 | 1.173 | 57665.0 |
100 | 2023-12-25 22:00:38 | sapsuckers | 1 | 67641 | 2 | 1.203 | 56226.9 |
99 | 2023-11-30 02:24:54 | sapsuckers | 1 | 67641 | 2 | 1.046 | 64666.3 |
98 | 2023-10-14 10:55:43 | sapsuckers | 1 | 67641 | 2 | 1.063 | 63632.2 |
97 | 2023-10-12 09:49:36 | sapsuckers | 2 | 108824 | 2 | 3.206 | 33943.9 |
96 | 2023-10-05 06:36:47 | sapsuckers | 3 | 140603 | 13 | 5.533 | 25411.7 |
95 | 2023-10-03 12:30:44 | sapsuckers | 4 | 161450 | 128 | 9.516 | 16966.2 |
94 | 2023-08-11 03:10:12 | sapsuckers | 1 | 67641 | 2 | 1.016 | 66575.8 |
93 | 2023-07-22 20:24:11 | sapsuckers | 2 | 108824 | 2 | 2.720 | 40008.8 |
92 | 2023-07-17 03:39:51 | sapsuckers | 3 | 140603 | 13 | 5.610 | 25062.9 |
91 | 2023-07-14 17:43:58 | sapsuckers | 4 | 161450 | 128 | 11.220 | 14389.5 |
90 | 2023-05-08 14:18:37 | sapsuckers | 1 | 67641 | 2 | 1.000 | 67641.0 |
89 | 2023-04-02 01:34:15 | sapsuckers | 2 | 108824 | 2 | 2.656 | 40972.9 |
88 | 2023-03-31 09:24:38 | sapsuckers | 4 | 161450 | 128 | 10.546 | 15309.1 |
87 | 2023-03-29 14:31:47 | sapsuckers | 3 | 140603 | 13 | 6.173 | 22777.1 |
86 | 2023-03-03 13:48:40 | sapsuckers | 1 | 67641 | 2 | 1.033 | 65480.2 |
85 | 2023-01-18 00:04:31 | sapsuckers | 4 | 161450 | 128 | 10.390 | 15539.0 |
84 | 2022-12-31 02:47:37 | sapsuckers | 2 | 108824 | 2 | 2.656 | 40972.9 |
83 | 2022-12-27 22:12:46 | sapsuckers | 4 | 161450 | 128 | 11.643 | 13866.7 |
82 | 2022-12-27 15:57:15 | sapsuckers | 1 | 67641 | 2 | 1.033 | 65480.2 |
81 | 2022-12-26 14:09:03 | sapsuckers | 3 | 140603 | 13 | 5.393 | 26071.4 |
80 | 2022-11-25 07:59:38 | sapsuckers | 4 | 161450 | 128 | 9.483 | 17025.2 |
79 | 2022-10-29 10:06:09 | sapsuckers | 4 | 161450 | 128 | 11.140 | 14492.8 |
78 | 2022-09-14 05:35:03 | sapsuckers | 1 | 67641 | 2 | 1.046 | 64666.3 |
77 | 2022-09-03 11:52:40 | sapsuckers | 2 | 108824 | 2 | 2.673 | 40712.3 |
76 | 2022-08-30 06:14:26 | sapsuckers | 4 | 161450 | 128 | 9.470 | 17048.6 |
75 | 2022-08-28 09:10:00 | sapsuckers | 3 | 140603 | 13 | 5.390 | 26085.9 |
74 | 2022-07-13 22:44:21 | sapsuckers | 1 | 67641 | 2 | 1.033 | 65480.2 |
73 | 2021-09-26 23:02:15 | sapsuckers | 1 | 67641 | 2 | 1.063 | 63632.2 |
72 | 2021-09-22 11:22:55 | sapsuckers | 1 | 67641 | 2 | 1.156 | 58513.0 |
71 | 2021-04-28 14:52:04 | sapsuckers | 1 | 67641 | 2 | 1.203 | 56226.9 |
70 | 2021-03-02 10:14:37 | sapsuckers | 1 | 67641 | 2 | 1.140 | 59334.2 |
69 | 2021-02-22 19:08:45 | sapsuckers | 1 | 67641 | 2 | 1.046 | 64666.3 |
68 | 2020-10-24 09:53:36 | sapsuckers | 1 | 67641 | 2 | 1.030 | 65670.9 |
67 | 2020-10-18 21:30:56 | sapsuckers | 1 | 67641 | 2 | 1.203 | 56226.9 |
66 | 2020-04-02 01:12:52 | sapsuckers | 1 | 67641 | 2 | 1.236 | 54725.7 |
65 | 2020-03-28 03:01:44 | sapsuckers | 1 | 67641 | 2 | 1.203 | 56226.9 |
64 | 2020-02-29 05:10:03 | sapsuckers | 1 | 67641 | 2 | 2.360 | 28661.4 |
63 | 2020-02-28 21:41:48 | sapsuckers | 1 | 67641 | 2 | 2.813 | 24045.9 |
62 | 2020-02-20 13:37:24 | sapsuckers | 1 | 67641 | 2 | 2.673 | 25305.3 |
61 | 2020-02-11 01:53:24 | sapsuckers | 1 | 67641 | 2 | 2.580 | 26217.4 |
60 | 2020-02-05 18:39:13 | sapsuckers | 1 | 67641 | 2 | 1.203 | 56226.9 |
59 | 2020-01-15 20:32:50 | sapsuckers | 1 | 67641 | 2 | 2.486 | 27208.8 |
58 | 2020-01-14 07:28:13 | sapsuckers | 1 | 67641 | 2 | 1.783 | 37936.6 |
57 | 2020-01-07 23:54:27 | sapsuckers | 1 | 67641 | 2 | 3.250 | 20812.6 |
56 | 2020-01-07 15:15:13 | sapsuckers | 1 | 67641 | 2 | 1.313 | 51516.4 |
55 | 2019-12-04 16:14:40 | sapsuckers | 1 | 67641 | 2 | 1.110 | 60937.8 |
54 | 2018-06-02 19:51:55 | sapsuckers | 1 | 67641 | 2 | 1.093 | 61885.6 |
53 | 2018-05-07 19:53:06 | sapsuckers | 1 | 67641 | 2 | 1.036 | 65290.5 |
52 | 2018-01-03 23:46:28 | sapsuckers | 1 | 67641 | 2 | 2.053 | 32947.4 |
51 | 2017-12-05 00:13:44 | sapsuckers | 1 | 67641 | 2 | 1.550 | 43639.4 |
50 | 2017-11-09 11:15:56 | sapsuckers | 1 | 67641 | 2 | 1.660 | 40747.6 |
49 | 2016-12-20 11:25:55 | sapsuckers | 1 | 67641 | 2 | 1.756 | 38519.9 |
48 | 2016-12-01 04:22:02 | sapsuckers | 1 | 67641 | 2 | 1.486 | 45518.8 |
47 | 2016-08-26 04:25:12 | sapsuckers | 1 | 67641 | 2 | 1.360 | 49736.0 |
46 | 2016-07-25 12:42:34 | sapsuckers | 1 | 67641 | 2 | 1.753 | 38585.9 |
45 | 2016-07-06 00:41:00 | sapsuckers | 1 | 67641 | 2 | 1.666 | 40600.8 |
44 | 2016-06-27 16:37:42 | sapsuckers | 3 | 140603 | 13 | 12.390 | 11348.1 |
43 | 2016-06-23 20:29:34 | sapsuckers | 2 | 108824 | 2 | 4.906 | 22181.8 |
42 | 2016-06-21 21:37:47 | sapsuckers | 4 | 161450 | 128 | 24.566 | 6572.1 |
41 | 2016-06-18 15:56:04 | sapsuckers | 1 | 67641 | 2 | 2.116 | 31966.4 |
40 | 2016-05-30 09:28:53 | sapsuckers | 1 | 67641 | 2 | 1.243 | 54417.5 |
39 | 2016-05-28 06:57:23 | sapsuckers | 1 | 67641 | 2 | 1.203 | 56226.9 |
38 | 2016-05-18 21:11:44 | sapsuckers | 1 | 67641 | 2 | 3.126 | 21638.2 |
37 | 2016-03-05 09:52:14 | sapsuckers | 1 | 67641 | 2 | 3.410 | 19836.1 |
36 | 2016-01-08 10:13:45 | sapsuckers | 1 | 67641 | 2 | 1.330 | 50857.9 |
35 | 2015-12-02 03:50:08 | sapsuckers | 1 | 67641 | 2 | 1.116 | 60610.2 |
34 | 2015-11-10 04:09:32 | sapsuckers | 1 | 67641 | 2 | 1.120 | 60393.8 |