History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"valuer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
722 | 2024-04-27 22:49:02 | valuer | 1 | 48755 | 6 | 0.846 | 57630.0 |
721 | 2024-04-27 02:35:32 | valuer | 1 | 48755 | 6 | 1.843 | 26454.2 |
720 | 2024-03-25 15:56:02 | valuer | 1 | 48755 | 6 | 0.860 | 56691.9 |
719 | 2024-03-20 23:43:07 | valuer | 3 | 112716 | 981 | 19.283 | 5845.4 |
718 | 2024-03-19 15:36:28 | valuer | 3 | 112716 | 981 | 5.780 | 19501.0 |
717 | 2024-03-19 15:36:29 | valuer | 2 | 82551 | 63 | 2.703 | 30540.5 |
716 | 2024-03-19 15:36:28 | valuer | 2 | 82551 | 63 | 2.780 | 29694.6 |
715 | 2024-03-19 15:36:24 | valuer | 1 | 48755 | 6 | 0.860 | 56691.9 |
714 | 2024-03-19 15:35:51 | valuer | 3 | 112716 | 981 | 4.890 | 23050.3 |
713 | 2024-03-18 20:38:53 | valuer | 3 | 112716 | 981 | 11.563 | 9748.0 |
712 | 2024-03-18 11:53:02 | valuer | 3 | 112716 | 981 | 11.986 | 9404.0 |
711 | 2024-03-12 19:38:11 | valuer | 3 | 112716 | 981 | 7.703 | 14632.7 |
710 | 2024-03-12 10:24:45 | valuer | 3 | 112716 | 981 | 4.670 | 24136.2 |
709 | 2024-03-05 23:59:40 | valuer | 1 | 48755 | 6 | 1.890 | 25796.3 |
708 | 2024-03-04 03:00:40 | valuer | 1 | 48755 | 6 | 1.906 | 25579.7 |
707 | 2024-02-28 10:24:01 | valuer | 1 | 48755 | 6 | 0.890 | 54780.9 |
706 | 2024-01-23 05:25:03 | valuer | 2 | 82551 | 63 | 2.750 | 30018.5 |
705 | 2023-12-18 02:47:47 | valuer | 1 | 48755 | 6 | 0.780 | 62506.4 |
704 | 2023-11-29 15:54:32 | valuer | 3 | 112716 | 981 | 4.640 | 24292.2 |
703 | 2023-11-18 22:53:24 | valuer | 1 | 48755 | 6 | 0.750 | 65006.7 |
702 | 2023-11-18 18:55:07 | valuer | 1 | 48755 | 6 | 0.733 | 66514.3 |
701 | 2023-11-03 17:52:10 | valuer | 1 | 48755 | 6 | 0.736 | 66243.2 |
700 | 2023-11-02 15:17:20 | valuer | 2 | 82551 | 63 | 2.123 | 38884.1 |
699 | 2023-11-02 07:35:58 | valuer | 1 | 48755 | 6 | 0.890 | 54780.9 |
698 | 2023-11-02 02:28:30 | valuer | 1 | 48755 | 6 | 0.796 | 61250.0 |
697 | 2023-10-28 08:01:40 | valuer | 1 | 48755 | 6 | 0.940 | 51867.0 |
696 | 2023-10-21 08:15:56 | valuer | 1 | 48755 | 6 | 0.783 | 62266.9 |
695 | 2023-10-16 16:33:13 | valuer | 1 | 48755 | 6 | 0.750 | 65006.7 |
694 | 2023-10-05 18:13:43 | valuer | 1 | 48755 | 6 | 0.733 | 66514.3 |
693 | 2023-10-05 05:54:21 | valuer | 1 | 48755 | 6 | 1.670 | 29194.6 |
692 | 2023-09-25 04:21:52 | valuer | 1 | 48755 | 6 | 0.813 | 59969.2 |
691 | 2023-09-13 17:35:47 | valuer | 1 | 48755 | 6 | 0.736 | 66243.2 |
690 | 2023-08-27 20:53:24 | valuer | 3 | 112716 | 981 | 4.686 | 24053.8 |
689 | 2023-08-23 09:28:30 | valuer | 3 | 112716 | 981 | 5.593 | 20153.0 |
688 | 2023-08-10 20:56:04 | valuer | 2 | 82551 | 63 | 2.546 | 32423.8 |
687 | 2023-08-03 00:24:56 | valuer | 1 | 48755 | 6 | 0.800 | 60943.8 |
686 | 2023-06-13 15:05:16 | valuer | 1 | 48755 | 6 | 0.780 | 62506.4 |
685 | 2023-05-15 22:50:04 | valuer | 3 | 112716 | 981 | 4.653 | 24224.4 |
684 | 2023-05-09 07:59:47 | valuer | 3 | 112716 | 981 | 4.686 | 24053.8 |
683 | 2023-04-26 18:21:28 | valuer | 1 | 48755 | 6 | 0.736 | 66243.2 |
682 | 2023-04-20 10:39:58 | valuer | 2 | 82551 | 63 | 2.110 | 39123.7 |
681 | 2023-03-28 00:36:00 | valuer | 3 | 112716 | 981 | 5.936 | 18988.5 |
680 | 2023-02-23 22:25:39 | valuer | 3 | 112716 | 981 | 5.236 | 21527.1 |
679 | 2023-02-17 08:10:52 | valuer | 1 | 48755 | 6 | 0.716 | 68093.6 |
678 | 2023-01-28 23:38:18 | valuer | 1 | 48755 | 6 | 0.716 | 68093.6 |
677 | 2023-01-21 06:51:41 | valuer | 2 | 82551 | 63 | 2.393 | 34496.9 |
676 | 2022-12-17 02:03:23 | valuer | 1 | 48755 | 6 | 0.843 | 57835.1 |
675 | 2022-12-05 07:39:01 | valuer | 3 | 112716 | 981 | 5.156 | 21861.1 |
674 | 2022-11-01 22:18:48 | valuer | 2 | 82551 | 63 | 2.576 | 32046.2 |
673 | 2022-09-12 04:01:43 | valuer | 1 | 48755 | 6 | 0.830 | 58741.0 |
672 | 2022-09-01 15:07:26 | valuer | 1 | 48755 | 6 | 0.830 | 58741.0 |
671 | 2022-08-24 13:23:18 | valuer | 1 | 48755 | 6 | 0.860 | 56691.9 |
670 | 2022-08-07 18:16:43 | valuer | 1 | 48755 | 6 | 0.733 | 66514.3 |
669 | 2022-05-13 15:30:50 | valuer | 2 | 82551 | 63 | 2.576 | 32046.2 |
668 | 2022-04-15 03:28:01 | valuer | 1 | 48755 | 6 | 1.046 | 46610.9 |
667 | 2022-04-08 02:38:48 | valuer | 1 | 48755 | 6 | 0.736 | 66243.2 |
666 | 2022-04-07 10:23:35 | valuer | 3 | 112716 | 981 | 5.983 | 18839.4 |
665 | 2022-01-05 09:40:50 | valuer | 1 | 48755 | 6 | 0.890 | 54780.9 |
664 | 2021-12-16 15:59:30 | valuer | 3 | 112716 | 981 | 5.393 | 20900.4 |
663 | 2021-12-08 00:59:29 | valuer | 1 | 48755 | 6 | 0.826 | 59025.4 |
662 | 2021-11-24 15:09:30 | valuer | 1 | 48755 | 6 | 0.783 | 62266.9 |
661 | 2021-11-09 20:32:54 | valuer | 1 | 48755 | 6 | 0.843 | 57835.1 |
660 | 2021-10-03 03:33:55 | valuer | 3 | 112716 | 981 | 4.610 | 24450.3 |
659 | 2021-09-27 11:57:13 | valuer | 1 | 48755 | 6 | 0.813 | 59969.2 |
658 | 2021-09-10 07:49:18 | valuer | 1 | 48755 | 6 | 0.780 | 62506.4 |
657 | 2021-08-11 15:59:39 | valuer | 1 | 48755 | 6 | 0.750 | 65006.7 |
656 | 2021-07-27 09:29:38 | valuer | 1 | 48755 | 6 | 0.856 | 56956.8 |
655 | 2021-05-18 04:57:27 | valuer | 1 | 48755 | 6 | 0.813 | 59969.2 |
654 | 2021-04-26 20:20:30 | valuer | 1 | 48755 | 6 | 0.843 | 57835.1 |
653 | 2021-04-18 04:49:40 | valuer | 1 | 48755 | 6 | 0.753 | 64747.7 |
652 | 2021-03-21 00:34:41 | valuer | 1 | 48755 | 6 | 0.750 | 65006.7 |
651 | 2021-01-30 13:56:31 | valuer | 1 | 48755 | 6 | 0.750 | 65006.7 |
650 | 2021-01-02 16:08:41 | valuer | 1 | 48755 | 6 | 0.826 | 59025.4 |
649 | 2021-01-02 01:27:15 | valuer | 1 | 48755 | 6 | 0.813 | 59969.2 |
648 | 2020-10-31 19:01:21 | valuer | 1 | 48755 | 6 | 1.656 | 29441.4 |
647 | 2020-10-27 23:34:11 | valuer | 1 | 48755 | 6 | 0.783 | 62266.9 |
646 | 2020-10-18 00:56:53 | valuer | 1 | 48755 | 6 | 0.736 | 66243.2 |
645 | 2020-09-26 17:11:52 | valuer | 1 | 48755 | 6 | 0.733 | 66514.3 |
644 | 2020-09-25 23:46:50 | valuer | 1 | 48755 | 6 | 0.720 | 67715.3 |
643 | 2020-07-30 18:29:08 | valuer | 1 | 48755 | 6 | 0.830 | 58741.0 |
642 | 2020-07-17 17:58:20 | valuer | 1 | 48755 | 6 | 0.780 | 62506.4 |
641 | 2020-06-02 08:46:36 | valuer | 1 | 48755 | 6 | 0.800 | 60943.8 |
640 | 2020-04-28 15:13:29 | valuer | 1 | 48755 | 6 | 0.750 | 65006.7 |
639 | 2020-03-27 21:33:52 | valuer | 1 | 48755 | 6 | 0.826 | 59025.4 |
638 | 2020-03-26 07:05:49 | valuer | 1 | 48755 | 6 | 0.813 | 59969.2 |
637 | 2020-03-26 05:53:04 | valuer | 1 | 48755 | 6 | 1.720 | 28345.9 |
636 | 2020-03-23 20:39:11 | valuer | 1 | 48755 | 6 | 0.923 | 52822.3 |
635 | 2020-03-22 11:08:07 | valuer | 1 | 48755 | 6 | 0.846 | 57630.0 |
634 | 2020-03-20 03:40:14 | valuer | 1 | 48755 | 6 | 0.733 | 66514.3 |
633 | 2020-03-01 09:24:21 | valuer | 1 | 48755 | 6 | 0.783 | 62266.9 |
632 | 2020-02-28 02:43:48 | valuer | 1 | 48755 | 6 | 0.940 | 51867.0 |
631 | 2020-02-21 13:15:18 | valuer | 1 | 48755 | 6 | 0.953 | 51159.5 |
630 | 2020-02-20 23:26:26 | valuer | 1 | 48755 | 6 | 0.796 | 61250.0 |
629 | 2020-02-13 20:35:38 | valuer | 1 | 48755 | 6 | 0.936 | 52088.7 |
628 | 2020-02-09 17:10:19 | valuer | 1 | 48755 | 6 | 1.843 | 26454.2 |
627 | 2020-02-09 13:46:14 | valuer | 1 | 48755 | 6 | 0.936 | 52088.7 |
626 | 2020-02-07 17:46:30 | valuer | 1 | 48755 | 6 | 1.843 | 26454.2 |
625 | 2020-02-03 23:17:40 | valuer | 1 | 48755 | 6 | 0.953 | 51159.5 |
624 | 2020-02-03 01:51:45 | valuer | 1 | 48755 | 6 | 2.813 | 17332.0 |
623 | 2020-01-27 04:25:18 | valuer | 1 | 48755 | 6 | 0.983 | 49598.2 |