History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canary"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
367 | 2024-05-06 20:08:55 | canary | 1 | 48755 | 2 | 0.920 | 52994.6 |
366 | 2024-05-06 08:32:51 | canary | 3 | 112716 | 612 | 6.016 | 18736.0 |
365 | 2024-04-30 19:08:55 | canary | 3 | 112716 | 612 | 8.080 | 13950.0 |
364 | 2024-04-29 15:46:24 | canary | 1 | 48755 | 2 | 1.063 | 45865.5 |
363 | 2024-04-28 10:28:37 | canary | 3 | 112716 | 612 | 10.483 | 10752.3 |
362 | 2024-04-27 18:55:08 | canary | 2 | 82551 | 42 | 3.390 | 24351.3 |
361 | 2024-04-27 18:54:39 | canary | 3 | 112716 | 612 | 6.343 | 17770.1 |
360 | 2024-04-27 13:51:53 | canary | 2 | 82551 | 42 | 3.736 | 22096.1 |
359 | 2024-04-26 09:26:56 | canary | 2 | 82551 | 42 | 5.300 | 15575.7 |
358 | 2024-04-26 09:21:52 | canary | 2 | 82551 | 42 | 3.110 | 26543.7 |
357 | 2024-04-26 09:21:48 | canary | 3 | 112716 | 612 | 5.906 | 19085.0 |
356 | 2024-04-26 09:21:44 | canary | 1 | 48755 | 2 | 1.766 | 27607.6 |
355 | 2024-04-26 09:21:12 | canary | 3 | 112716 | 612 | 8.156 | 13820.0 |
354 | 2024-04-25 17:22:12 | canary | 3 | 112716 | 612 | 11.550 | 9759.0 |
353 | 2024-04-25 09:18:08 | canary | 3 | 112716 | 612 | 5.263 | 21416.7 |
352 | 2024-04-19 14:57:42 | canary | 1 | 48755 | 2 | 1.906 | 25579.7 |
351 | 2024-03-28 05:28:56 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
350 | 2024-03-09 03:06:24 | canary | 1 | 48755 | 2 | 0.796 | 61250.0 |
349 | 2024-03-09 01:26:11 | canary | 1 | 48755 | 2 | 2.470 | 19738.9 |
348 | 2024-02-12 17:58:40 | canary | 1 | 48755 | 2 | 0.906 | 53813.5 |
347 | 2024-01-27 11:25:34 | canary | 1 | 48755 | 2 | 0.906 | 53813.5 |
346 | 2024-01-22 23:50:23 | canary | 1 | 48755 | 2 | 0.766 | 63648.8 |
345 | 2024-01-02 02:44:50 | canary | 3 | 112716 | 612 | 5.720 | 19705.6 |
344 | 2024-01-02 02:44:52 | canary | 2 | 82551 | 42 | 2.610 | 31628.7 |
343 | 2023-12-08 06:30:32 | canary | 2 | 82551 | 42 | 2.266 | 36430.3 |
342 | 2023-12-08 06:30:27 | canary | 3 | 112716 | 612 | 4.846 | 23259.6 |
341 | 2023-12-01 21:44:43 | canary | 1 | 48755 | 2 | 0.860 | 56691.9 |
340 | 2023-11-13 20:05:05 | canary | 1 | 48755 | 2 | 1.843 | 26454.2 |
339 | 2023-11-11 01:53:35 | canary | 1 | 48755 | 2 | 0.826 | 59025.4 |
338 | 2023-11-03 19:19:35 | canary | 1 | 48755 | 2 | 0.873 | 55847.7 |
337 | 2023-11-03 13:45:18 | canary | 1 | 48755 | 2 | 0.750 | 65006.7 |
336 | 2023-10-20 14:20:44 | canary | 1 | 48755 | 2 | 0.923 | 52822.3 |
335 | 2023-10-13 14:52:59 | canary | 1 | 48755 | 2 | 0.796 | 61250.0 |
334 | 2023-10-12 11:51:57 | canary | 1 | 48755 | 2 | 0.876 | 55656.4 |
333 | 2023-10-05 06:31:00 | canary | 1 | 48755 | 2 | 0.763 | 63899.1 |
332 | 2023-10-03 22:04:50 | canary | 1 | 48755 | 2 | 0.876 | 55656.4 |
331 | 2023-09-24 13:15:34 | canary | 1 | 48755 | 2 | 0.766 | 63648.8 |
330 | 2023-09-16 19:11:05 | canary | 1 | 48755 | 2 | 0.856 | 56956.8 |
329 | 2023-09-12 20:22:10 | canary | 1 | 48755 | 2 | 0.763 | 63899.1 |
328 | 2023-08-17 10:28:46 | canary | 1 | 48755 | 2 | 0.860 | 56691.9 |
327 | 2023-07-06 15:39:02 | canary | 1 | 48755 | 2 | 1.706 | 28578.5 |
326 | 2023-04-02 21:25:13 | canary | 1 | 48755 | 2 | 0.843 | 57835.1 |
325 | 2022-12-24 23:47:00 | canary | 1 | 48755 | 2 | 0.766 | 63648.8 |
324 | 2022-12-21 07:42:20 | canary | 1 | 48755 | 2 | 0.826 | 59025.4 |
323 | 2022-11-13 10:00:34 | canary | 1 | 48755 | 2 | 0.766 | 63648.8 |
322 | 2022-09-07 02:58:51 | canary | 1 | 48755 | 2 | 0.906 | 53813.5 |
321 | 2022-07-04 09:57:18 | canary | 1 | 48755 | 2 | 0.766 | 63648.8 |
320 | 2022-05-25 21:56:05 | canary | 1 | 48755 | 2 | 0.796 | 61250.0 |
319 | 2022-03-04 22:30:28 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
318 | 2022-02-17 21:12:14 | canary | 1 | 48755 | 2 | 0.876 | 55656.4 |
317 | 2022-02-14 17:13:37 | canary | 1 | 48755 | 2 | 0.876 | 55656.4 |
316 | 2022-02-12 10:24:21 | canary | 1 | 48755 | 2 | 0.923 | 52822.3 |
315 | 2021-12-19 15:42:09 | canary | 1 | 48755 | 2 | 0.890 | 54780.9 |
314 | 2021-11-16 12:21:14 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
313 | 2021-10-26 16:29:42 | canary | 1 | 48755 | 2 | 0.796 | 61250.0 |
312 | 2021-10-22 05:59:06 | canary | 1 | 48755 | 2 | 0.873 | 55847.7 |
311 | 2021-09-14 21:21:05 | canary | 1 | 48755 | 2 | 0.890 | 54780.9 |
310 | 2021-08-28 06:28:09 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
309 | 2021-08-16 22:57:42 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
308 | 2021-06-05 15:57:15 | canary | 1 | 48755 | 2 | 0.890 | 54780.9 |
307 | 2021-05-29 17:37:27 | canary | 2 | 82551 | 42 | 2.860 | 28864.0 |
306 | 2021-05-16 06:43:57 | canary | 1 | 48755 | 2 | 0.860 | 56691.9 |
305 | 2021-05-12 22:01:29 | canary | 1 | 48755 | 2 | 1.000 | 48755.0 |
304 | 2021-05-11 15:54:55 | canary | 1 | 48755 | 2 | 0.890 | 54780.9 |
303 | 2021-05-04 05:41:00 | canary | 2 | 82551 | 42 | 4.920 | 16778.7 |
302 | 2021-04-10 09:54:48 | canary | 1 | 48755 | 2 | 0.906 | 53813.5 |
301 | 2021-02-10 21:30:10 | canary | 2 | 82551 | 42 | 2.236 | 36919.1 |
300 | 2021-02-09 02:13:07 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
299 | 2021-02-03 19:37:20 | canary | 1 | 48755 | 2 | 0.796 | 61250.0 |
298 | 2021-01-24 20:00:09 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
297 | 2021-01-17 09:04:24 | canary | 2 | 82551 | 42 | 2.296 | 35954.3 |
296 | 2020-11-25 14:21:22 | canary | 2 | 82551 | 42 | 2.233 | 36968.7 |
295 | 2020-11-05 19:28:25 | canary | 2 | 82551 | 42 | 2.376 | 34743.7 |
294 | 2020-11-02 03:22:41 | canary | 1 | 48755 | 2 | 0.936 | 52088.7 |
293 | 2020-10-26 22:15:34 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
292 | 2020-10-21 02:20:41 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
291 | 2020-10-12 23:27:41 | canary | 1 | 48755 | 2 | 0.796 | 61250.0 |
290 | 2020-10-08 21:36:26 | canary | 1 | 48755 | 2 | 0.766 | 63648.8 |
289 | 2020-10-08 03:35:20 | canary | 1 | 48755 | 2 | 0.766 | 63648.8 |
288 | 2020-10-03 14:40:55 | canary | 2 | 82551 | 42 | 2.283 | 36159.0 |
287 | 2020-09-10 18:49:54 | canary | 1 | 48755 | 2 | 0.986 | 49447.3 |
286 | 2020-09-05 02:32:57 | canary | 1 | 48755 | 2 | 0.766 | 63648.8 |
285 | 2020-08-07 20:31:53 | canary | 2 | 82551 | 42 | 2.673 | 30883.3 |
284 | 2020-08-03 07:12:47 | canary | 1 | 48755 | 2 | 0.796 | 61250.0 |
283 | 2020-08-03 02:15:02 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
282 | 2020-08-02 16:20:40 | canary | 1 | 48755 | 2 | 0.923 | 52822.3 |
281 | 2020-07-16 08:33:04 | canary | 2 | 82551 | 42 | 2.486 | 33206.4 |
280 | 2020-05-19 03:45:17 | canary | 1 | 48755 | 2 | 0.876 | 55656.4 |
279 | 2020-05-01 04:51:46 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
278 | 2020-03-25 07:25:45 | canary | 1 | 48755 | 2 | 0.860 | 56691.9 |
277 | 2020-03-24 08:31:02 | canary | 1 | 48755 | 2 | 0.920 | 52994.6 |
276 | 2020-03-22 11:52:19 | canary | 1 | 48755 | 2 | 0.890 | 54780.9 |
275 | 2020-03-22 09:43:24 | canary | 1 | 48755 | 2 | 1.063 | 45865.5 |
274 | 2020-03-21 08:10:34 | canary | 1 | 48755 | 2 | 0.780 | 62506.4 |
273 | 2020-03-18 01:57:12 | canary | 1 | 48755 | 2 | 0.766 | 63648.8 |
272 | 2020-03-01 01:53:31 | canary | 3 | 112716 | 612 | 6.486 | 17378.4 |
271 | 2020-02-29 22:32:34 | canary | 3 | 112716 | 612 | 6.016 | 18736.0 |
270 | 2020-02-26 18:35:23 | canary | 1 | 48755 | 2 | 0.983 | 49598.2 |
269 | 2020-02-26 12:51:47 | canary | 3 | 112716 | 612 | 5.920 | 19039.9 |
268 | 2020-02-26 06:53:14 | canary | 3 | 112716 | 612 | 5.563 | 20261.7 |