History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"snooper"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
479 | 2024-05-05 20:26:31 | snooper | 1 | 69583 | 9 | 2.373 | 29322.8 |
478 | 2024-04-30 10:43:24 | snooper | 3 | 134027 | 413 | 18.576 | 7215.1 |
477 | 2024-04-28 13:16:07 | snooper | 1 | 69583 | 9 | 3.906 | 17814.4 |
476 | 2024-04-22 06:11:28 | snooper | 3 | 134027 | 413 | 20.566 | 6516.9 |
475 | 2024-04-20 22:12:29 | snooper | 3 | 134027 | 413 | 12.923 | 10371.2 |
474 | 2024-04-20 22:11:40 | snooper | 2 | 107671 | 56 | 8.076 | 13332.2 |
473 | 2024-04-19 12:33:41 | snooper | 2 | 107671 | 56 | 3.796 | 28364.3 |
472 | 2024-04-19 12:33:17 | snooper | 3 | 134027 | 413 | 7.453 | 17983.0 |
471 | 2024-04-18 21:49:36 | snooper | 3 | 134027 | 413 | 11.186 | 11981.7 |
470 | 2024-04-17 01:40:34 | snooper | 2 | 107671 | 56 | 7.220 | 14912.9 |
469 | 2024-04-17 01:40:28 | snooper | 3 | 134027 | 413 | 9.563 | 14015.2 |
468 | 2024-04-17 01:40:16 | snooper | 1 | 69583 | 9 | 2.876 | 24194.4 |
467 | 2024-04-07 15:59:53 | snooper | 1 | 69583 | 9 | 1.826 | 38106.8 |
466 | 2024-03-30 10:54:39 | snooper | 1 | 69583 | 9 | 1.250 | 55666.4 |
465 | 2024-03-30 06:25:58 | snooper | 1 | 69583 | 9 | 4.296 | 16197.2 |
464 | 2024-03-15 23:37:05 | snooper | 1 | 69583 | 9 | 1.436 | 48456.1 |
463 | 2024-03-06 19:18:21 | snooper | 1 | 69583 | 9 | 1.343 | 51811.6 |
462 | 2024-02-26 06:06:53 | snooper | 3 | 134027 | 413 | 15.706 | 8533.5 |
461 | 2024-02-26 06:06:53 | snooper | 2 | 107671 | 56 | 12.250 | 8789.5 |
460 | 2024-02-13 12:27:16 | snooper | 1 | 69583 | 9 | 1.986 | 35036.8 |
459 | 2024-01-08 21:08:41 | snooper | 1 | 69583 | 9 | 1.266 | 54962.9 |
458 | 2023-12-22 03:25:58 | snooper | 1 | 69583 | 9 | 1.110 | 62687.4 |
457 | 2023-12-12 06:28:19 | snooper | 1 | 69583 | 9 | 1.220 | 57035.2 |
456 | 2023-12-04 00:04:45 | snooper | 1 | 69583 | 9 | 1.220 | 57035.2 |
455 | 2023-11-19 23:23:25 | snooper | 1 | 69583 | 9 | 1.250 | 55666.4 |
454 | 2023-11-04 21:45:50 | snooper | 1 | 69583 | 9 | 1.063 | 65459.1 |
453 | 2023-10-20 03:59:32 | snooper | 1 | 69583 | 9 | 2.450 | 28401.2 |
452 | 2023-10-08 18:30:58 | snooper | 1 | 69583 | 9 | 1.080 | 64428.7 |
451 | 2023-09-26 00:58:59 | snooper | 1 | 69583 | 9 | 1.250 | 55666.4 |
450 | 2023-09-22 21:58:50 | snooper | 1 | 69583 | 9 | 1.280 | 54361.7 |
449 | 2023-08-06 13:00:42 | snooper | 1 | 69583 | 9 | 1.173 | 59320.5 |
448 | 2023-07-27 09:53:56 | snooper | 1 | 69583 | 9 | 1.076 | 64668.2 |
447 | 2023-05-02 12:43:13 | snooper | 1 | 69583 | 9 | 1.093 | 63662.4 |
446 | 2023-04-04 12:06:58 | snooper | 1 | 69583 | 9 | 1.063 | 65459.1 |
445 | 2023-02-21 19:54:44 | snooper | 1 | 69583 | 9 | 1.170 | 59472.6 |
444 | 2022-12-19 04:24:16 | snooper | 1 | 69583 | 9 | 1.186 | 58670.3 |
443 | 2022-12-09 14:01:16 | snooper | 1 | 69583 | 9 | 2.593 | 26834.9 |
442 | 2022-08-30 20:06:59 | snooper | 1 | 69583 | 9 | 1.076 | 64668.2 |
441 | 2022-07-30 07:06:09 | snooper | 1 | 69583 | 9 | 1.076 | 64668.2 |
440 | 2022-07-19 14:21:27 | snooper | 1 | 69583 | 9 | 1.080 | 64428.7 |
439 | 2022-05-30 06:11:19 | snooper | 1 | 69583 | 9 | 1.093 | 63662.4 |
438 | 2022-04-29 06:57:07 | snooper | 1 | 69583 | 9 | 1.250 | 55666.4 |
437 | 2022-04-10 22:33:05 | snooper | 1 | 69583 | 9 | 1.110 | 62687.4 |
436 | 2022-04-09 13:23:21 | snooper | 1 | 69583 | 9 | 1.063 | 65459.1 |
435 | 2022-03-25 10:25:53 | snooper | 1 | 69583 | 9 | 1.766 | 39401.5 |
434 | 2022-01-06 18:35:13 | snooper | 1 | 69583 | 9 | 1.313 | 52995.4 |
433 | 2021-12-01 10:58:11 | snooper | 1 | 69583 | 9 | 1.220 | 57035.2 |
432 | 2021-11-05 00:41:09 | snooper | 1 | 69583 | 9 | 1.296 | 53690.6 |
431 | 2021-11-02 23:42:53 | snooper | 1 | 69583 | 9 | 1.250 | 55666.4 |
430 | 2021-10-05 04:37:23 | snooper | 1 | 69583 | 9 | 1.060 | 65644.3 |
429 | 2021-08-15 01:29:37 | snooper | 1 | 69583 | 9 | 1.063 | 65459.1 |
428 | 2021-08-11 17:18:27 | snooper | 1 | 69583 | 9 | 1.080 | 64428.7 |
427 | 2021-07-01 10:25:48 | snooper | 1 | 69583 | 9 | 1.140 | 61037.7 |
426 | 2021-05-04 04:33:32 | snooper | 1 | 69583 | 9 | 1.186 | 58670.3 |
425 | 2021-04-30 21:25:03 | snooper | 1 | 69583 | 9 | 1.796 | 38743.3 |
424 | 2021-04-30 14:23:35 | snooper | 1 | 69583 | 9 | 1.080 | 64428.7 |
423 | 2021-04-13 10:18:52 | snooper | 1 | 69583 | 9 | 1.793 | 38808.1 |
422 | 2021-03-26 09:42:52 | snooper | 3 | 134027 | 413 | 5.783 | 23176.0 |
421 | 2021-03-17 04:48:41 | snooper | 1 | 69583 | 9 | 1.170 | 59472.6 |
420 | 2021-02-28 13:12:39 | snooper | 3 | 134027 | 413 | 6.063 | 22105.7 |
419 | 2021-01-28 01:42:02 | snooper | 1 | 69583 | 9 | 1.233 | 56433.9 |
418 | 2021-01-26 00:54:47 | snooper | 1 | 69583 | 9 | 1.093 | 63662.4 |
417 | 2020-12-29 06:03:04 | snooper | 1 | 69583 | 9 | 1.280 | 54361.7 |
416 | 2020-11-02 01:33:50 | snooper | 3 | 134027 | 413 | 6.563 | 20421.6 |
415 | 2020-11-01 22:17:14 | snooper | 2 | 107671 | 56 | 3.013 | 35735.5 |
414 | 2020-11-01 18:18:15 | snooper | 1 | 69583 | 9 | 1.250 | 55666.4 |
413 | 2020-10-27 11:37:47 | snooper | 1 | 69583 | 9 | 1.080 | 64428.7 |
412 | 2020-10-25 06:24:24 | snooper | 1 | 69583 | 9 | 1.110 | 62687.4 |
411 | 2020-10-21 07:32:44 | snooper | 1 | 69583 | 9 | 1.093 | 63662.4 |
410 | 2020-10-13 08:31:05 | snooper | 1 | 69583 | 9 | 1.076 | 64668.2 |
409 | 2020-10-06 07:22:45 | snooper | 1 | 69583 | 9 | 1.080 | 64428.7 |
408 | 2020-09-22 00:24:10 | snooper | 1 | 69583 | 9 | 1.220 | 57035.2 |
407 | 2020-07-30 22:13:57 | snooper | 1 | 69583 | 9 | 1.156 | 60192.9 |
406 | 2020-07-27 17:49:12 | snooper | 1 | 69583 | 9 | 1.156 | 60192.9 |
405 | 2020-07-22 23:45:05 | snooper | 1 | 69583 | 9 | 1.126 | 61796.6 |
404 | 2020-07-21 23:11:37 | snooper | 1 | 69583 | 9 | 1.313 | 52995.4 |
403 | 2020-04-20 00:27:19 | snooper | 1 | 69583 | 9 | 1.203 | 57841.2 |
402 | 2020-04-15 07:11:11 | snooper | 1 | 69583 | 9 | 1.110 | 62687.4 |
401 | 2020-03-29 22:54:37 | snooper | 1 | 69583 | 9 | 1.123 | 61961.7 |
400 | 2020-03-29 19:33:21 | snooper | 1 | 69583 | 9 | 1.203 | 57841.2 |
399 | 2020-03-25 20:47:22 | snooper | 1 | 69583 | 9 | 1.200 | 57985.8 |
398 | 2020-03-20 23:15:26 | snooper | 1 | 69583 | 9 | 1.076 | 64668.2 |
397 | 2020-03-01 02:18:33 | snooper | 1 | 69583 | 9 | 2.673 | 26031.8 |
396 | 2020-02-25 20:20:25 | snooper | 1 | 69583 | 9 | 1.296 | 53690.6 |
395 | 2020-02-11 12:46:04 | snooper | 1 | 69583 | 9 | 2.843 | 24475.2 |
394 | 2020-02-11 09:59:27 | snooper | 1 | 69583 | 9 | 4.610 | 15093.9 |
393 | 2020-02-11 08:56:30 | snooper | 1 | 69583 | 9 | 4.250 | 16372.5 |
392 | 2020-02-06 10:01:44 | snooper | 1 | 69583 | 9 | 2.546 | 27330.3 |
391 | 2020-02-05 04:57:57 | snooper | 1 | 69583 | 9 | 1.356 | 51314.9 |
390 | 2020-02-02 02:19:29 | snooper | 1 | 69583 | 9 | 1.670 | 41666.5 |
389 | 2020-02-01 01:56:46 | snooper | 1 | 69583 | 9 | 1.190 | 58473.1 |
388 | 2020-01-31 14:49:20 | snooper | 1 | 69583 | 9 | 1.250 | 55666.4 |
387 | 2020-01-19 15:39:32 | snooper | 1 | 69583 | 9 | 1.376 | 50569.0 |
386 | 2020-01-18 17:42:40 | snooper | 1 | 69583 | 9 | 1.283 | 54234.6 |
385 | 2020-01-18 02:45:07 | snooper | 1 | 69583 | 9 | 2.436 | 28564.4 |
384 | 2020-01-14 04:01:44 | snooper | 1 | 69583 | 9 | 1.203 | 57841.2 |
383 | 2020-01-09 00:52:06 | snooper | 1 | 69583 | 9 | 2.483 | 28023.8 |
382 | 2020-01-01 07:51:51 | snooper | 1 | 69583 | 9 | 1.233 | 56433.9 |
381 | 2019-12-29 04:32:30 | snooper | 1 | 69583 | 9 | 1.923 | 36184.6 |
380 | 2019-12-28 19:54:19 | snooper | 1 | 69583 | 9 | 2.233 | 31161.2 |