History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"summits"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
278 | 2024-04-21 12:37:01 | summits | 1 | 69583 | 3 | 6.343 | 10970.0 |
277 | 2024-03-22 07:30:16 | summits | 1 | 69583 | 3 | 4.313 | 16133.3 |
276 | 2024-02-29 00:54:17 | summits | 1 | 69583 | 3 | 2.700 | 25771.5 |
275 | 2024-02-28 20:41:00 | summits | 3 | 134027 | 228 | 13.203 | 10151.3 |
274 | 2024-02-26 07:59:43 | summits | 3 | 134027 | 228 | 7.470 | 17942.0 |
273 | 2024-02-26 07:59:37 | summits | 2 | 107671 | 26 | 3.733 | 28843.0 |
272 | 2024-02-22 08:21:58 | summits | 2 | 107671 | 26 | 7.656 | 14063.6 |
271 | 2024-02-21 18:36:48 | summits | 2 | 107671 | 26 | 7.766 | 13864.4 |
270 | 2024-02-21 17:19:31 | summits | 1 | 69583 | 3 | 1.406 | 49490.0 |
269 | 2024-02-21 03:04:06 | summits | 1 | 69583 | 3 | 1.283 | 54234.6 |
268 | 2024-02-18 21:06:53 | summits | 2 | 107671 | 26 | 3.330 | 32333.6 |
267 | 2024-01-26 18:01:03 | summits | 3 | 134027 | 228 | 7.030 | 19065.0 |
266 | 2024-01-19 21:07:12 | summits | 1 | 69583 | 3 | 1.110 | 62687.4 |
265 | 2024-01-11 08:19:36 | summits | 3 | 134027 | 228 | 9.343 | 14345.2 |
264 | 2024-01-10 12:04:44 | summits | 2 | 107671 | 26 | 3.780 | 28484.4 |
263 | 2023-12-04 23:44:11 | summits | 1 | 69583 | 3 | 1.170 | 59472.6 |
262 | 2023-11-29 03:09:10 | summits | 1 | 69583 | 3 | 1.156 | 60192.9 |
261 | 2023-11-17 07:08:37 | summits | 1 | 69583 | 3 | 1.360 | 51164.0 |
260 | 2023-11-16 21:17:10 | summits | 2 | 107671 | 26 | 3.530 | 30501.7 |
259 | 2023-11-05 12:03:32 | summits | 1 | 69583 | 3 | 1.186 | 58670.3 |
258 | 2023-10-20 15:17:15 | summits | 1 | 69583 | 3 | 1.096 | 63488.1 |
257 | 2023-10-03 20:31:41 | summits | 1 | 69583 | 3 | 1.186 | 58670.3 |
256 | 2023-09-19 03:11:02 | summits | 1 | 69583 | 3 | 1.096 | 63488.1 |
255 | 2023-09-03 05:45:08 | summits | 1 | 69583 | 3 | 1.280 | 54361.7 |
254 | 2023-08-18 00:41:21 | summits | 2 | 107671 | 26 | 2.783 | 38688.8 |
253 | 2023-07-12 12:03:53 | summits | 1 | 69583 | 3 | 1.110 | 62687.4 |
252 | 2023-07-11 05:30:53 | summits | 1 | 69583 | 3 | 1.140 | 61037.7 |
251 | 2023-06-03 19:58:34 | summits | 1 | 69583 | 3 | 1.076 | 64668.2 |
250 | 2023-05-02 20:06:12 | summits | 2 | 107671 | 26 | 5.826 | 18481.1 |
249 | 2023-04-19 09:48:42 | summits | 1 | 69583 | 3 | 1.063 | 65459.1 |
248 | 2023-02-09 23:55:39 | summits | 2 | 107671 | 26 | 3.203 | 33615.7 |
247 | 2023-02-05 01:24:28 | summits | 1 | 69583 | 3 | 1.236 | 56296.9 |
246 | 2023-02-02 12:15:09 | summits | 1 | 69583 | 3 | 1.126 | 61796.6 |
245 | 2023-01-29 00:23:23 | summits | 1 | 69583 | 3 | 1.063 | 65459.1 |
244 | 2022-12-17 16:36:45 | summits | 1 | 69583 | 3 | 1.186 | 58670.3 |
243 | 2022-12-04 02:26:04 | summits | 1 | 69583 | 3 | 1.080 | 64428.7 |
242 | 2022-11-29 20:50:01 | summits | 1 | 69583 | 3 | 1.186 | 58670.3 |
241 | 2022-11-24 03:00:17 | summits | 1 | 69583 | 3 | 1.203 | 57841.2 |
240 | 2022-11-22 10:49:32 | summits | 2 | 107671 | 26 | 3.000 | 35890.3 |
239 | 2022-11-08 13:37:33 | summits | 1 | 69583 | 3 | 1.296 | 53690.6 |
238 | 2022-09-19 09:34:28 | summits | 1 | 69583 | 3 | 1.190 | 58473.1 |
237 | 2022-07-29 16:06:54 | summits | 1 | 69583 | 3 | 1.063 | 65459.1 |
236 | 2022-06-26 22:48:18 | summits | 2 | 107671 | 26 | 3.216 | 33479.8 |
235 | 2022-05-06 13:29:44 | summits | 1 | 69583 | 3 | 1.170 | 59472.6 |
234 | 2022-03-22 01:49:24 | summits | 1 | 69583 | 3 | 1.220 | 57035.2 |
233 | 2022-01-09 02:13:35 | summits | 1 | 69583 | 3 | 1.170 | 59472.6 |
232 | 2022-01-05 19:58:54 | summits | 1 | 69583 | 3 | 1.313 | 52995.4 |
231 | 2021-12-30 03:20:54 | summits | 1 | 69583 | 3 | 1.313 | 52995.4 |
230 | 2021-11-16 04:01:08 | summits | 1 | 69583 | 3 | 1.283 | 54234.6 |
229 | 2021-09-20 03:45:29 | summits | 1 | 69583 | 3 | 2.470 | 28171.3 |
228 | 2021-09-16 22:26:51 | summits | 1 | 69583 | 3 | 1.080 | 64428.7 |
227 | 2021-07-12 14:27:27 | summits | 1 | 69583 | 3 | 1.123 | 61961.7 |
226 | 2021-06-09 15:10:48 | summits | 1 | 69583 | 3 | 1.076 | 64668.2 |
225 | 2021-05-01 07:03:29 | summits | 1 | 69583 | 3 | 1.220 | 57035.2 |
224 | 2021-03-07 07:07:32 | summits | 1 | 69583 | 3 | 1.280 | 54361.7 |
223 | 2021-02-08 08:39:51 | summits | 1 | 69583 | 3 | 1.156 | 60192.9 |
222 | 2021-01-14 06:35:26 | summits | 1 | 69583 | 3 | 1.096 | 63488.1 |
221 | 2020-12-15 09:02:26 | summits | 1 | 69583 | 3 | 1.110 | 62687.4 |
220 | 2020-11-28 19:46:33 | summits | 1 | 69583 | 3 | 1.233 | 56433.9 |
219 | 2020-11-18 23:28:53 | summits | 1 | 69583 | 3 | 1.796 | 38743.3 |
218 | 2020-10-31 02:05:13 | summits | 1 | 69583 | 3 | 1.296 | 53690.6 |
217 | 2020-10-08 22:37:46 | summits | 1 | 69583 | 3 | 1.110 | 62687.4 |
216 | 2020-10-02 04:50:08 | summits | 1 | 69583 | 3 | 1.123 | 61961.7 |
215 | 2020-09-06 20:22:13 | summits | 1 | 69583 | 3 | 1.110 | 62687.4 |
214 | 2020-08-27 04:54:48 | summits | 1 | 69583 | 3 | 1.106 | 62914.1 |
213 | 2020-08-24 07:16:59 | summits | 1 | 69583 | 3 | 1.126 | 61796.6 |
212 | 2020-08-16 03:05:37 | summits | 1 | 69583 | 3 | 1.123 | 61961.7 |
211 | 2020-08-03 01:57:11 | summits | 1 | 69583 | 3 | 1.330 | 52318.0 |
210 | 2020-08-02 10:50:12 | summits | 1 | 69583 | 3 | 1.310 | 53116.8 |
209 | 2020-07-27 08:51:00 | summits | 1 | 69583 | 3 | 1.186 | 58670.3 |
208 | 2020-05-26 05:31:34 | summits | 1 | 69583 | 3 | 1.093 | 63662.4 |
207 | 2020-05-11 22:41:56 | summits | 1 | 69583 | 3 | 1.140 | 61037.7 |
206 | 2020-03-29 15:47:10 | summits | 1 | 69583 | 3 | 1.080 | 64428.7 |
205 | 2020-03-21 15:05:26 | summits | 1 | 69583 | 3 | 1.233 | 56433.9 |
204 | 2020-03-10 22:32:44 | summits | 1 | 69583 | 3 | 1.250 | 55666.4 |
203 | 2020-03-01 03:14:29 | summits | 1 | 69583 | 3 | 2.826 | 24622.4 |
202 | 2020-02-29 17:34:37 | summits | 1 | 69583 | 3 | 2.643 | 26327.3 |
201 | 2020-02-29 00:43:39 | summits | 3 | 134027 | 228 | 7.470 | 17942.0 |
200 | 2020-02-28 22:08:13 | summits | 3 | 134027 | 228 | 12.673 | 10575.8 |
199 | 2020-02-28 17:44:02 | summits | 3 | 134027 | 228 | 13.936 | 9617.3 |
198 | 2020-02-28 17:30:32 | summits | 3 | 134027 | 228 | 7.000 | 19146.7 |
197 | 2020-02-28 13:56:51 | summits | 3 | 134027 | 228 | 16.233 | 8256.5 |
196 | 2020-02-28 04:47:56 | summits | 3 | 134027 | 228 | 6.940 | 19312.2 |
195 | 2020-02-13 05:33:59 | summits | 1 | 69583 | 3 | 1.576 | 44151.6 |
194 | 2020-02-10 01:47:43 | summits | 1 | 69583 | 3 | 2.846 | 24449.4 |
193 | 2020-02-06 08:23:36 | summits | 1 | 69583 | 3 | 1.280 | 54361.7 |
192 | 2020-02-05 14:51:56 | summits | 1 | 69583 | 3 | 1.420 | 49002.1 |
191 | 2020-02-01 13:40:02 | summits | 1 | 69583 | 3 | 1.686 | 41271.1 |
190 | 2020-01-27 22:43:12 | summits | 1 | 69583 | 3 | 1.420 | 49002.1 |
189 | 2020-01-24 23:02:30 | summits | 1 | 69583 | 3 | 1.953 | 35628.8 |
188 | 2020-01-20 10:49:42 | summits | 1 | 69583 | 3 | 1.390 | 50059.7 |
187 | 2020-01-19 05:49:10 | summits | 1 | 69583 | 3 | 1.393 | 49951.9 |
186 | 2020-01-14 17:27:16 | summits | 3 | 134027 | 228 | 7.250 | 18486.5 |
185 | 2020-01-14 13:59:23 | summits | 3 | 134027 | 228 | 8.966 | 14948.4 |
184 | 2020-01-14 09:15:50 | summits | 3 | 134027 | 228 | 7.956 | 16846.0 |
183 | 2020-01-14 04:01:00 | summits | 1 | 69583 | 3 | 1.390 | 50059.7 |
182 | 2020-01-06 21:37:59 | summits | 1 | 69583 | 3 | 2.720 | 25582.0 |
181 | 2020-01-03 06:25:27 | summits | 1 | 69583 | 3 | 1.326 | 52475.9 |
180 | 2020-01-02 14:01:17 | summits | 1 | 69583 | 3 | 1.436 | 48456.1 |
179 | 2019-12-29 00:27:13 | summits | 1 | 69583 | 3 | 1.220 | 57035.2 |