History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"leads"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
875 | 2024-03-13 20:43:33 | leads | 1 | 28756 | 19 | 0.596 | 48248.3 |
874 | 2024-03-04 01:57:20 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
873 | 2024-03-01 03:03:00 | leads | 1 | 28756 | 19 | 0.486 | 59168.7 |
872 | 2024-02-27 20:29:37 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
871 | 2024-02-22 17:03:53 | leads | 1 | 28756 | 19 | 0.546 | 52666.7 |
870 | 2024-02-06 00:20:34 | leads | 1 | 28756 | 19 | 1.080 | 26625.9 |
869 | 2024-02-03 02:32:47 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
868 | 2024-02-02 04:32:23 | leads | 1 | 28756 | 19 | 1.000 | 28756.0 |
867 | 2024-01-28 18:49:21 | leads | 1 | 28756 | 19 | 0.440 | 65354.5 |
866 | 2024-01-28 18:13:55 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
865 | 2024-01-20 19:12:15 | leads | 2 | 53800 | 273 | 1.373 | 39184.3 |
864 | 2024-01-18 11:56:35 | leads | 2 | 53800 | 273 | 1.436 | 37465.2 |
863 | 2024-01-05 12:44:31 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
862 | 2023-12-27 19:57:22 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
861 | 2023-12-25 07:47:03 | leads | 2 | 53800 | 273 | 1.750 | 30742.9 |
860 | 2023-12-14 05:40:25 | leads | 2 | 53800 | 273 | 1.420 | 37887.3 |
859 | 2023-12-04 10:04:28 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
858 | 2023-12-04 10:04:27 | leads | 1 | 28756 | 19 | 0.453 | 63479.0 |
857 | 2023-11-30 07:11:12 | leads | 2 | 53800 | 273 | 3.016 | 17838.2 |
856 | 2023-11-26 19:15:34 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
855 | 2023-11-26 14:26:16 | leads | 1 | 28756 | 19 | 0.440 | 65354.5 |
854 | 2023-11-18 06:58:56 | leads | 1 | 28756 | 19 | 1.110 | 25906.3 |
853 | 2023-11-11 11:06:40 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
852 | 2023-10-30 17:41:10 | leads | 1 | 28756 | 19 | 0.470 | 61183.0 |
851 | 2023-10-30 00:43:05 | leads | 2 | 53800 | 273 | 1.546 | 34799.5 |
850 | 2023-10-28 20:02:51 | leads | 1 | 28756 | 19 | 0.623 | 46157.3 |
849 | 2023-10-25 21:07:49 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
848 | 2023-10-22 02:56:47 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
847 | 2023-10-17 22:15:45 | leads | 1 | 28756 | 19 | 0.483 | 59536.2 |
846 | 2023-10-12 01:06:36 | leads | 1 | 28756 | 19 | 0.516 | 55728.7 |
845 | 2023-10-07 11:53:00 | leads | 1 | 28756 | 19 | 0.486 | 59168.7 |
844 | 2023-10-06 07:07:21 | leads | 1 | 28756 | 19 | 0.873 | 32939.3 |
843 | 2023-09-27 08:40:27 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
842 | 2023-09-13 17:29:50 | leads | 1 | 28756 | 19 | 0.483 | 59536.2 |
841 | 2023-08-21 11:48:40 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
840 | 2023-08-10 06:14:18 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
839 | 2023-08-09 07:05:34 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
838 | 2023-08-06 07:18:46 | leads | 2 | 53800 | 273 | 1.390 | 38705.0 |
837 | 2023-06-29 03:45:19 | leads | 1 | 28756 | 19 | 0.453 | 63479.0 |
836 | 2023-06-27 09:49:25 | leads | 1 | 28756 | 19 | 0.440 | 65354.5 |
835 | 2023-06-23 18:06:14 | leads | 1 | 28756 | 19 | 0.560 | 51350.0 |
834 | 2023-05-23 08:20:12 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
833 | 2023-05-07 03:17:37 | leads | 1 | 28756 | 19 | 0.440 | 65354.5 |
832 | 2023-05-04 04:06:35 | leads | 1 | 28756 | 19 | 0.420 | 68466.7 |
831 | 2023-04-18 02:12:02 | leads | 2 | 53800 | 273 | 1.393 | 38621.7 |
830 | 2023-03-21 10:34:53 | leads | 1 | 28756 | 19 | 0.516 | 55728.7 |
829 | 2023-03-20 22:57:47 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
828 | 2023-03-17 07:09:05 | leads | 1 | 28756 | 19 | 0.483 | 59536.2 |
827 | 2023-03-13 13:57:54 | leads | 1 | 28756 | 19 | 0.483 | 59536.2 |
826 | 2023-01-24 20:40:26 | leads | 2 | 53800 | 273 | 1.373 | 39184.3 |
825 | 2023-01-22 09:18:34 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
824 | 2023-01-06 09:50:00 | leads | 1 | 28756 | 19 | 0.420 | 68466.7 |
823 | 2022-12-27 07:27:22 | leads | 1 | 28756 | 19 | 0.466 | 61708.2 |
822 | 2022-12-16 08:30:59 | leads | 1 | 28756 | 19 | 0.470 | 61183.0 |
821 | 2022-12-08 05:42:48 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
820 | 2022-11-06 18:00:08 | leads | 2 | 53800 | 273 | 1.436 | 37465.2 |
819 | 2022-10-22 02:29:16 | leads | 1 | 28756 | 19 | 0.440 | 65354.5 |
818 | 2022-10-16 10:58:52 | leads | 1 | 28756 | 19 | 0.470 | 61183.0 |
817 | 2022-09-30 12:52:36 | leads | 1 | 28756 | 19 | 0.516 | 55728.7 |
816 | 2022-09-19 19:09:47 | leads | 1 | 28756 | 19 | 0.470 | 61183.0 |
815 | 2022-09-18 14:13:37 | leads | 1 | 28756 | 19 | 0.450 | 63902.2 |
814 | 2022-09-08 12:06:41 | leads | 1 | 28756 | 19 | 0.470 | 61183.0 |
813 | 2022-09-03 04:13:38 | leads | 1 | 28756 | 19 | 0.453 | 63479.0 |
812 | 2022-09-02 05:43:05 | leads | 1 | 28756 | 19 | 0.423 | 67981.1 |
811 | 2022-08-15 11:30:46 | leads | 1 | 28756 | 19 | 0.483 | 59536.2 |
810 | 2022-08-15 00:27:06 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
809 | 2022-08-14 05:25:02 | leads | 1 | 28756 | 19 | 0.453 | 63479.0 |
808 | 2022-08-06 05:59:14 | leads | 1 | 28756 | 19 | 0.453 | 63479.0 |
807 | 2022-08-05 21:56:59 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
806 | 2022-07-30 05:33:16 | leads | 1 | 28756 | 19 | 0.440 | 65354.5 |
805 | 2022-07-18 05:43:17 | leads | 1 | 28756 | 19 | 0.453 | 63479.0 |
804 | 2022-07-17 18:53:09 | leads | 1 | 28756 | 19 | 0.453 | 63479.0 |
803 | 2022-07-14 04:42:35 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
802 | 2022-07-10 04:35:02 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
801 | 2022-07-09 21:48:12 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
800 | 2022-07-02 16:10:47 | leads | 1 | 28756 | 19 | 0.440 | 65354.5 |
799 | 2022-06-28 07:38:40 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
798 | 2022-06-25 06:41:33 | leads | 1 | 28756 | 19 | 0.440 | 65354.5 |
797 | 2022-06-24 19:38:28 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
796 | 2022-06-15 20:56:04 | leads | 1 | 28756 | 19 | 0.453 | 63479.0 |
795 | 2022-06-06 02:44:58 | leads | 2 | 53800 | 273 | 1.393 | 38621.7 |
794 | 2022-06-01 14:51:33 | leads | 2 | 53800 | 273 | 1.546 | 34799.5 |
793 | 2022-05-31 06:02:21 | leads | 1 | 28756 | 19 | 0.486 | 59168.7 |
792 | 2022-05-27 04:07:49 | leads | 1 | 28756 | 19 | 0.453 | 63479.0 |
791 | 2022-05-13 11:57:35 | leads | 1 | 28756 | 19 | 0.610 | 47141.0 |
790 | 2022-05-11 07:25:11 | leads | 1 | 28756 | 19 | 0.483 | 59536.2 |
789 | 2022-04-12 18:57:58 | leads | 1 | 28756 | 19 | 0.470 | 61183.0 |
788 | 2022-04-08 14:06:21 | leads | 1 | 28756 | 19 | 0.593 | 48492.4 |
787 | 2022-02-19 14:18:14 | leads | 1 | 28756 | 19 | 0.453 | 63479.0 |
786 | 2022-01-25 22:19:32 | leads | 1 | 28756 | 19 | 0.453 | 63479.0 |
785 | 2022-01-24 01:24:03 | leads | 1 | 28756 | 19 | 0.516 | 55728.7 |
784 | 2022-01-23 01:29:00 | leads | 2 | 53800 | 273 | 1.593 | 33772.8 |
783 | 2022-01-20 21:17:00 | leads | 2 | 53800 | 273 | 1.453 | 37026.8 |
782 | 2021-12-14 06:43:38 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
781 | 2021-11-28 11:34:37 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |
780 | 2021-11-27 08:44:28 | leads | 1 | 28756 | 19 | 0.530 | 54256.6 |
779 | 2021-11-23 22:03:18 | leads | 1 | 28756 | 19 | 0.483 | 59536.2 |
778 | 2021-11-20 03:26:52 | leads | 1 | 28756 | 19 | 0.466 | 61708.2 |
777 | 2021-11-19 21:29:43 | leads | 1 | 28756 | 19 | 0.436 | 65954.1 |
776 | 2021-11-19 12:11:28 | leads | 1 | 28756 | 19 | 0.500 | 57512.0 |