History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"agent"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
661 | 2024-04-27 17:50:41 | agent | 1 | 28756 | 7 | 0.500 | 57512.0 |
660 | 2024-04-08 03:28:26 | agent | 1 | 28756 | 7 | 0.533 | 53951.2 |
659 | 2024-04-03 06:05:33 | agent | 1 | 28756 | 7 | 0.470 | 61183.0 |
658 | 2024-03-31 09:23:55 | agent | 1 | 28756 | 7 | 0.516 | 55728.7 |
657 | 2024-03-31 09:23:21 | agent | 2 | 53800 | 105 | 2.656 | 20256.0 |
656 | 2024-03-31 09:23:08 | agent | 1 | 28756 | 7 | 0.500 | 57512.0 |
655 | 2024-03-29 01:40:05 | agent | 1 | 28756 | 7 | 0.563 | 51076.4 |
654 | 2024-03-24 23:59:59 | agent | 2 | 53800 | 105 | 1.687 | 31890.9 |
653 | 2024-03-04 04:07:02 | agent | 2 | 53800 | 105 | 6.610 | 8139.2 |
652 | 2024-03-04 01:39:52 | agent | 2 | 53800 | 105 | 1.766 | 30464.3 |
651 | 2024-03-04 01:20:20 | agent | 1 | 28756 | 7 | 0.483 | 59536.2 |
650 | 2024-03-01 05:13:44 | agent | 1 | 28756 | 7 | 1.126 | 25538.2 |
649 | 2024-02-27 20:24:21 | agent | 1 | 28756 | 7 | 0.560 | 51350.0 |
648 | 2024-02-14 15:51:15 | agent | 1 | 28756 | 7 | 0.483 | 59536.2 |
647 | 2024-02-03 01:00:39 | agent | 1 | 28756 | 7 | 1.046 | 27491.4 |
646 | 2024-01-28 23:31:27 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
645 | 2024-01-28 20:10:17 | agent | 1 | 28756 | 7 | 0.486 | 59168.7 |
644 | 2024-01-16 07:40:12 | agent | 2 | 53800 | 105 | 1.453 | 37026.8 |
643 | 2024-01-14 11:25:32 | agent | 1 | 28756 | 7 | 0.436 | 65954.1 |
642 | 2024-01-06 02:04:02 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
641 | 2024-01-03 04:45:12 | agent | 2 | 53800 | 105 | 1.420 | 37887.3 |
640 | 2023-12-12 11:25:57 | agent | 2 | 53800 | 105 | 1.576 | 34137.1 |
639 | 2023-11-29 22:51:14 | agent | 2 | 53800 | 105 | 1.470 | 36598.6 |
638 | 2023-11-21 17:16:41 | agent | 2 | 53800 | 105 | 1.593 | 33772.8 |
637 | 2023-11-19 05:29:31 | agent | 2 | 53800 | 105 | 1.453 | 37026.8 |
636 | 2023-11-11 09:47:32 | agent | 1 | 28756 | 7 | 0.486 | 59168.7 |
635 | 2023-11-09 08:09:58 | agent | 1 | 28756 | 7 | 0.516 | 55728.7 |
634 | 2023-11-09 02:08:10 | agent | 1 | 28756 | 7 | 0.500 | 57512.0 |
633 | 2023-11-02 02:40:28 | agent | 1 | 28756 | 7 | 0.546 | 52666.7 |
632 | 2023-10-21 15:21:43 | agent | 1 | 28756 | 7 | 0.486 | 59168.7 |
631 | 2023-10-18 19:43:09 | agent | 1 | 28756 | 7 | 0.500 | 57512.0 |
630 | 2023-10-13 18:39:26 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
629 | 2023-10-03 17:57:35 | agent | 1 | 28756 | 7 | 0.890 | 32310.1 |
628 | 2023-09-26 21:01:04 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
627 | 2023-09-26 14:27:27 | agent | 1 | 28756 | 7 | 0.516 | 55728.7 |
626 | 2023-09-24 23:33:10 | agent | 1 | 28756 | 7 | 0.483 | 59536.2 |
625 | 2023-08-29 13:01:55 | agent | 1 | 28756 | 7 | 0.500 | 57512.0 |
624 | 2023-08-28 16:29:32 | agent | 2 | 53800 | 105 | 1.390 | 38705.0 |
623 | 2023-07-08 12:15:46 | agent | 1 | 28756 | 7 | 0.436 | 65954.1 |
622 | 2023-06-22 21:48:05 | agent | 1 | 28756 | 7 | 0.513 | 56054.6 |
621 | 2023-06-01 22:25:29 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
620 | 2023-05-14 00:21:16 | agent | 2 | 53800 | 105 | 1.390 | 38705.0 |
619 | 2023-05-08 22:57:19 | agent | 2 | 53800 | 105 | 1.593 | 33772.8 |
618 | 2023-03-31 15:02:09 | agent | 2 | 53800 | 105 | 1.673 | 32157.8 |
617 | 2023-03-27 01:02:04 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
616 | 2023-03-26 11:49:18 | agent | 1 | 28756 | 7 | 0.436 | 65954.1 |
615 | 2023-03-25 05:47:53 | agent | 2 | 53800 | 105 | 1.796 | 29955.5 |
614 | 2023-03-20 14:42:18 | agent | 1 | 28756 | 7 | 0.546 | 52666.7 |
613 | 2023-02-20 07:09:44 | agent | 2 | 53800 | 105 | 1.690 | 31834.3 |
612 | 2023-01-10 02:19:37 | agent | 1 | 28756 | 7 | 0.436 | 65954.1 |
611 | 2022-12-09 15:39:48 | agent | 2 | 53800 | 105 | 1.580 | 34050.6 |
610 | 2022-12-09 01:43:42 | agent | 1 | 28756 | 7 | 0.513 | 56054.6 |
609 | 2022-12-02 14:32:56 | agent | 2 | 53800 | 105 | 1.360 | 39558.8 |
608 | 2022-10-28 07:31:29 | agent | 2 | 53800 | 105 | 1.373 | 39184.3 |
607 | 2022-10-06 14:04:35 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
606 | 2022-09-30 17:57:39 | agent | 2 | 53800 | 105 | 1.390 | 38705.0 |
605 | 2022-09-10 14:30:21 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
604 | 2022-08-29 03:16:29 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
603 | 2022-08-18 07:00:04 | agent | 2 | 53800 | 105 | 1.530 | 35163.4 |
602 | 2022-08-15 16:39:44 | agent | 1 | 28756 | 7 | 0.436 | 65954.1 |
601 | 2022-07-18 10:21:04 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
600 | 2022-07-17 22:46:55 | agent | 1 | 28756 | 7 | 0.436 | 65954.1 |
599 | 2022-07-10 19:58:10 | agent | 2 | 53800 | 105 | 1.390 | 38705.0 |
598 | 2022-07-02 08:50:31 | agent | 1 | 28756 | 7 | 0.513 | 56054.6 |
597 | 2022-06-16 20:23:12 | agent | 1 | 28756 | 7 | 0.436 | 65954.1 |
596 | 2022-06-15 19:24:24 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
595 | 2022-06-08 15:37:13 | agent | 1 | 28756 | 7 | 0.500 | 57512.0 |
594 | 2022-06-01 18:14:01 | agent | 1 | 28756 | 7 | 0.470 | 61183.0 |
593 | 2022-06-01 12:00:22 | agent | 1 | 28756 | 7 | 0.610 | 47141.0 |
592 | 2022-05-25 15:23:31 | agent | 1 | 28756 | 7 | 0.483 | 59536.2 |
591 | 2022-05-24 13:25:51 | agent | 1 | 28756 | 7 | 0.513 | 56054.6 |
590 | 2022-05-23 10:37:05 | agent | 1 | 28756 | 7 | 0.466 | 61708.2 |
589 | 2022-05-20 00:26:43 | agent | 1 | 28756 | 7 | 0.483 | 59536.2 |
588 | 2022-02-18 19:40:08 | agent | 1 | 28756 | 7 | 0.466 | 61708.2 |
587 | 2022-02-15 08:56:19 | agent | 1 | 28756 | 7 | 0.533 | 53951.2 |
586 | 2022-02-11 19:53:19 | agent | 1 | 28756 | 7 | 0.516 | 55728.7 |
585 | 2021-11-25 13:51:23 | agent | 1 | 28756 | 7 | 0.623 | 46157.3 |
584 | 2021-11-07 09:24:04 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
583 | 2021-10-13 07:41:36 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
582 | 2021-09-09 09:22:53 | agent | 1 | 28756 | 7 | 0.440 | 65354.5 |
581 | 2021-09-07 04:21:02 | agent | 1 | 28756 | 7 | 0.483 | 59536.2 |
580 | 2021-08-18 10:00:09 | agent | 1 | 28756 | 7 | 0.500 | 57512.0 |
579 | 2021-08-12 09:43:48 | agent | 1 | 28756 | 7 | 0.436 | 65954.1 |
578 | 2021-08-04 07:10:59 | agent | 1 | 28756 | 7 | 0.486 | 59168.7 |
577 | 2021-07-05 05:25:34 | agent | 1 | 28756 | 7 | 0.440 | 65354.5 |
576 | 2021-05-13 06:31:48 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
575 | 2021-05-03 14:21:22 | agent | 1 | 28756 | 7 | 0.626 | 45936.1 |
574 | 2021-04-29 22:50:33 | agent | 1 | 28756 | 7 | 0.470 | 61183.0 |
573 | 2021-04-19 05:36:00 | agent | 1 | 28756 | 7 | 0.890 | 32310.1 |
572 | 2021-02-23 23:04:23 | agent | 1 | 28756 | 7 | 0.500 | 57512.0 |
571 | 2021-01-25 11:51:39 | agent | 1 | 28756 | 7 | 0.500 | 57512.0 |
570 | 2021-01-04 22:03:28 | agent | 1 | 28756 | 7 | 0.436 | 65954.1 |
569 | 2021-01-03 21:50:05 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
568 | 2020-12-06 22:29:53 | agent | 1 | 28756 | 7 | 0.500 | 57512.0 |
567 | 2020-10-24 08:34:19 | agent | 1 | 28756 | 7 | 0.453 | 63479.0 |
566 | 2020-10-14 08:28:50 | agent | 1 | 28756 | 7 | 0.500 | 57512.0 |
565 | 2020-08-30 08:26:34 | agent | 1 | 28756 | 7 | 0.530 | 54256.6 |
564 | 2020-08-29 11:44:26 | agent | 1 | 28756 | 7 | 0.450 | 63902.2 |
563 | 2020-08-22 13:52:32 | agent | 1 | 28756 | 7 | 0.653 | 44036.8 |
562 | 2020-07-31 13:02:28 | agent | 2 | 53800 | 105 | 1.500 | 35866.7 |