History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shows"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
897 | 2024-05-02 11:09:54 | shows | 1 | 28756 | 19 | 0.560 | 51350.0 |
896 | 2024-04-29 20:33:37 | shows | 1 | 28756 | 19 | 0.530 | 54256.6 |
895 | 2024-04-28 07:46:05 | shows | 1 | 28756 | 19 | 0.516 | 55728.7 |
894 | 2024-04-28 07:44:34 | shows | 1 | 28756 | 19 | 0.530 | 54256.6 |
893 | 2024-04-16 08:15:52 | shows | 1 | 28756 | 19 | 0.533 | 53951.2 |
892 | 2024-04-04 19:40:49 | shows | 2 | 53800 | 220 | 6.830 | 7877.0 |
891 | 2024-04-03 20:11:29 | shows | 1 | 28756 | 19 | 1.170 | 24577.8 |
890 | 2024-04-03 20:11:10 | shows | 2 | 53800 | 220 | 3.123 | 17227.0 |
889 | 2024-04-03 20:11:00 | shows | 1 | 28756 | 19 | 1.156 | 24875.4 |
888 | 2024-04-03 04:45:44 | shows | 2 | 53800 | 220 | 7.220 | 7451.5 |
887 | 2024-04-03 04:38:15 | shows | 1 | 28756 | 19 | 1.140 | 25224.6 |
886 | 2024-03-27 16:49:35 | shows | 1 | 28756 | 19 | 0.530 | 54256.6 |
885 | 2024-03-04 01:14:53 | shows | 2 | 53800 | 220 | 1.423 | 37807.4 |
884 | 2024-03-03 20:06:46 | shows | 2 | 53800 | 220 | 1.670 | 32215.6 |
883 | 2024-03-03 20:06:31 | shows | 1 | 28756 | 19 | 0.516 | 55728.7 |
882 | 2024-03-02 14:42:06 | shows | 1 | 28756 | 19 | 2.280 | 12612.3 |
881 | 2024-02-25 22:57:13 | shows | 1 | 28756 | 19 | 1.563 | 18398.0 |
880 | 2024-02-05 05:00:48 | shows | 1 | 28756 | 19 | 0.516 | 55728.7 |
879 | 2024-02-02 22:43:32 | shows | 2 | 53800 | 220 | 1.640 | 32804.9 |
878 | 2024-02-02 19:11:56 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
877 | 2024-01-26 20:20:49 | shows | 1 | 28756 | 19 | 0.546 | 52666.7 |
876 | 2024-01-20 07:09:01 | shows | 2 | 53800 | 220 | 1.846 | 29144.1 |
875 | 2024-01-02 14:52:40 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |
874 | 2023-12-04 08:14:58 | shows | 2 | 53800 | 220 | 1.593 | 33772.8 |
873 | 2023-11-27 20:15:57 | shows | 1 | 28756 | 19 | 0.733 | 39230.6 |
872 | 2023-11-26 05:39:10 | shows | 2 | 53800 | 220 | 1.483 | 36277.8 |
871 | 2023-11-19 10:54:38 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |
870 | 2023-11-15 16:32:10 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |
869 | 2023-11-09 17:51:20 | shows | 1 | 28756 | 19 | 0.486 | 59168.7 |
868 | 2023-10-31 02:40:52 | shows | 2 | 53800 | 220 | 1.410 | 38156.0 |
867 | 2023-10-28 04:50:30 | shows | 2 | 53800 | 220 | 1.360 | 39558.8 |
866 | 2023-10-28 00:29:21 | shows | 1 | 28756 | 19 | 0.470 | 61183.0 |
865 | 2023-10-26 14:38:18 | shows | 1 | 28756 | 19 | 0.513 | 56054.6 |
864 | 2023-10-19 20:40:35 | shows | 1 | 28756 | 19 | 0.436 | 65954.1 |
863 | 2023-10-19 08:46:31 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |
862 | 2023-10-11 11:48:14 | shows | 1 | 28756 | 19 | 0.513 | 56054.6 |
861 | 2023-10-09 07:01:44 | shows | 2 | 53800 | 220 | 1.626 | 33087.3 |
860 | 2023-10-03 15:29:00 | shows | 1 | 28756 | 19 | 0.436 | 65954.1 |
859 | 2023-09-27 18:18:10 | shows | 2 | 53800 | 220 | 1.470 | 36598.6 |
858 | 2023-09-22 07:13:07 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
857 | 2023-09-19 18:38:01 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
856 | 2023-09-13 20:34:53 | shows | 1 | 28756 | 19 | 0.516 | 55728.7 |
855 | 2023-08-07 14:41:47 | shows | 2 | 53800 | 220 | 1.390 | 38705.0 |
854 | 2023-07-25 14:25:29 | shows | 1 | 28756 | 19 | 0.483 | 59536.2 |
853 | 2023-06-22 14:53:22 | shows | 1 | 28756 | 19 | 0.436 | 65954.1 |
852 | 2023-04-22 10:14:04 | shows | 2 | 53800 | 220 | 1.360 | 39558.8 |
851 | 2023-04-10 03:51:18 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
850 | 2023-04-03 04:21:16 | shows | 1 | 28756 | 19 | 0.436 | 65954.1 |
849 | 2023-01-29 10:02:55 | shows | 2 | 53800 | 220 | 1.360 | 39558.8 |
848 | 2023-01-17 10:34:36 | shows | 1 | 28756 | 19 | 0.483 | 59536.2 |
847 | 2022-12-24 19:28:00 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
846 | 2022-11-12 18:42:55 | shows | 1 | 28756 | 19 | 0.436 | 65954.1 |
845 | 2022-11-11 11:38:32 | shows | 2 | 53800 | 220 | 1.376 | 39098.8 |
844 | 2022-08-20 23:29:12 | shows | 1 | 28756 | 19 | 0.450 | 63902.2 |
843 | 2022-08-15 17:06:35 | shows | 2 | 53800 | 220 | 1.563 | 34421.0 |
842 | 2022-07-19 08:44:12 | shows | 2 | 53800 | 220 | 1.546 | 34799.5 |
841 | 2022-07-04 02:43:50 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |
840 | 2022-06-08 18:53:25 | shows | 2 | 53800 | 220 | 1.343 | 40059.6 |
839 | 2022-04-20 09:48:42 | shows | 1 | 28756 | 19 | 0.780 | 36866.7 |
838 | 2022-04-17 00:18:16 | shows | 1 | 28756 | 19 | 0.593 | 48492.4 |
837 | 2022-03-22 15:05:19 | shows | 1 | 28756 | 19 | 0.470 | 61183.0 |
836 | 2022-03-21 20:17:31 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
835 | 2022-03-20 21:16:21 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
834 | 2022-03-19 12:02:12 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |
833 | 2022-03-18 16:59:23 | shows | 1 | 28756 | 19 | 0.983 | 29253.3 |
832 | 2022-03-17 05:45:32 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
831 | 2022-03-16 12:05:55 | shows | 1 | 28756 | 19 | 0.563 | 51076.4 |
830 | 2022-03-06 19:24:18 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
829 | 2022-02-24 23:19:43 | shows | 1 | 28756 | 19 | 0.703 | 40904.7 |
828 | 2022-02-21 22:48:59 | shows | 1 | 28756 | 19 | 0.623 | 46157.3 |
827 | 2022-02-19 23:30:59 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
826 | 2022-02-18 22:20:56 | shows | 1 | 28756 | 19 | 0.546 | 52666.7 |
825 | 2021-12-25 20:34:16 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
824 | 2021-12-23 12:12:24 | shows | 1 | 28756 | 19 | 1.076 | 26724.9 |
823 | 2021-12-22 11:13:14 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |
822 | 2021-12-21 12:15:15 | shows | 1 | 28756 | 19 | 0.530 | 54256.6 |
821 | 2021-12-21 12:06:50 | shows | 1 | 28756 | 19 | 1.110 | 25906.3 |
820 | 2021-12-20 10:08:08 | shows | 1 | 28756 | 19 | 1.390 | 20687.8 |
819 | 2021-11-09 18:22:13 | shows | 1 | 28756 | 19 | 0.513 | 56054.6 |
818 | 2021-11-08 08:10:32 | shows | 1 | 28756 | 19 | 0.470 | 61183.0 |
817 | 2021-10-30 21:47:15 | shows | 1 | 28756 | 19 | 0.546 | 52666.7 |
816 | 2021-10-29 20:27:22 | shows | 1 | 28756 | 19 | 0.516 | 55728.7 |
815 | 2021-10-26 10:41:00 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
814 | 2021-09-15 10:13:23 | shows | 1 | 28756 | 19 | 0.466 | 61708.2 |
813 | 2021-09-12 10:26:06 | shows | 1 | 28756 | 19 | 0.440 | 65354.5 |
812 | 2021-09-10 06:45:42 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |
811 | 2021-09-08 18:50:02 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
810 | 2021-08-23 15:42:26 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |
809 | 2021-07-28 17:05:40 | shows | 1 | 28756 | 19 | 0.516 | 55728.7 |
808 | 2021-07-16 09:35:13 | shows | 1 | 28756 | 19 | 0.440 | 65354.5 |
807 | 2021-06-15 11:15:51 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |
806 | 2021-05-05 16:17:15 | shows | 1 | 28756 | 19 | 0.530 | 54256.6 |
805 | 2021-04-22 00:46:31 | shows | 2 | 53800 | 220 | 1.500 | 35866.7 |
804 | 2021-04-03 19:18:22 | shows | 1 | 28756 | 19 | 0.470 | 61183.0 |
803 | 2021-03-16 02:21:04 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |
802 | 2021-01-31 12:53:37 | shows | 2 | 53800 | 220 | 1.423 | 37807.4 |
801 | 2021-01-07 06:56:12 | shows | 2 | 53800 | 220 | 1.406 | 38264.6 |
800 | 2020-12-09 11:26:37 | shows | 2 | 53800 | 220 | 1.436 | 37465.2 |
799 | 2020-12-09 09:16:49 | shows | 1 | 28756 | 19 | 0.500 | 57512.0 |
798 | 2020-11-24 07:20:37 | shows | 1 | 28756 | 19 | 0.453 | 63479.0 |