History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rocks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
902 | 2024-04-22 09:12:02 | rocks | 1 | 28756 | 24 | 1.200 | 23963.3 |
901 | 2024-04-17 13:08:13 | rocks | 1 | 28756 | 24 | 0.576 | 49923.6 |
900 | 2024-04-03 08:11:07 | rocks | 2 | 53800 | 219 | 4.046 | 13297.1 |
899 | 2024-04-03 08:02:35 | rocks | 1 | 28756 | 24 | 0.530 | 54256.6 |
898 | 2024-03-31 02:56:49 | rocks | 1 | 28756 | 24 | 0.563 | 51076.4 |
897 | 2024-03-28 23:44:30 | rocks | 2 | 53800 | 219 | 5.576 | 9648.5 |
896 | 2024-03-28 23:22:23 | rocks | 1 | 28756 | 24 | 1.046 | 27491.4 |
895 | 2024-03-23 01:56:34 | rocks | 2 | 53800 | 219 | 2.966 | 18138.9 |
894 | 2024-03-04 03:05:13 | rocks | 2 | 53800 | 219 | 1.703 | 31591.3 |
893 | 2024-03-04 03:05:11 | rocks | 1 | 28756 | 24 | 0.436 | 65954.1 |
892 | 2024-02-27 19:54:56 | rocks | 1 | 28756 | 24 | 0.516 | 55728.7 |
891 | 2024-02-27 03:47:11 | rocks | 1 | 28756 | 24 | 0.466 | 61708.2 |
890 | 2024-02-19 23:52:29 | rocks | 1 | 28756 | 24 | 0.563 | 51076.4 |
889 | 2024-02-04 08:24:26 | rocks | 2 | 53800 | 219 | 1.453 | 37026.8 |
888 | 2024-02-03 00:51:15 | rocks | 1 | 28756 | 24 | 0.530 | 54256.6 |
887 | 2024-01-29 01:53:51 | rocks | 1 | 28756 | 24 | 0.983 | 29253.3 |
886 | 2024-01-28 21:33:09 | rocks | 1 | 28756 | 24 | 0.500 | 57512.0 |
885 | 2024-01-20 06:28:05 | rocks | 2 | 53800 | 219 | 3.030 | 17755.8 |
884 | 2024-01-10 09:09:37 | rocks | 2 | 53800 | 219 | 1.406 | 38264.6 |
883 | 2024-01-02 03:56:16 | rocks | 1 | 28756 | 24 | 0.466 | 61708.2 |
882 | 2023-12-29 09:46:58 | rocks | 1 | 28756 | 24 | 0.593 | 48492.4 |
881 | 2023-12-17 04:00:05 | rocks | 2 | 53800 | 219 | 1.623 | 33148.5 |
880 | 2023-11-18 06:02:00 | rocks | 1 | 28756 | 24 | 0.500 | 57512.0 |
879 | 2023-11-12 03:40:07 | rocks | 1 | 28756 | 24 | 0.483 | 59536.2 |
878 | 2023-11-01 03:18:01 | rocks | 1 | 28756 | 24 | 0.470 | 61183.0 |
877 | 2023-10-24 13:28:09 | rocks | 1 | 28756 | 24 | 0.450 | 63902.2 |
876 | 2023-10-20 06:56:29 | rocks | 1 | 28756 | 24 | 0.500 | 57512.0 |
875 | 2023-10-18 23:53:06 | rocks | 1 | 28756 | 24 | 0.516 | 55728.7 |
874 | 2023-10-12 02:34:48 | rocks | 1 | 28756 | 24 | 0.500 | 57512.0 |
873 | 2023-10-07 12:18:21 | rocks | 1 | 28756 | 24 | 0.440 | 65354.5 |
872 | 2023-09-25 21:36:11 | rocks | 1 | 28756 | 24 | 0.580 | 49579.3 |
871 | 2023-09-12 13:39:43 | rocks | 2 | 53800 | 219 | 1.593 | 33772.8 |
870 | 2023-09-10 13:01:02 | rocks | 1 | 28756 | 24 | 0.483 | 59536.2 |
869 | 2023-09-06 09:11:48 | rocks | 1 | 28756 | 24 | 0.530 | 54256.6 |
868 | 2023-08-20 07:33:44 | rocks | 1 | 28756 | 24 | 0.483 | 59536.2 |
867 | 2023-07-03 20:29:40 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
866 | 2023-05-31 13:56:37 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
865 | 2023-05-24 06:31:16 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
864 | 2023-05-20 13:28:39 | rocks | 1 | 28756 | 24 | 0.436 | 65954.1 |
863 | 2023-04-11 18:22:07 | rocks | 1 | 28756 | 24 | 0.483 | 59536.2 |
862 | 2023-03-21 11:31:02 | rocks | 1 | 28756 | 24 | 0.500 | 57512.0 |
861 | 2023-03-19 02:58:09 | rocks | 1 | 28756 | 24 | 0.440 | 65354.5 |
860 | 2023-02-17 15:11:01 | rocks | 1 | 28756 | 24 | 0.516 | 55728.7 |
859 | 2023-02-03 17:43:34 | rocks | 1 | 28756 | 24 | 0.436 | 65954.1 |
858 | 2023-01-25 21:17:53 | rocks | 1 | 28756 | 24 | 0.436 | 65954.1 |
857 | 2023-01-06 10:33:03 | rocks | 1 | 28756 | 24 | 0.436 | 65954.1 |
856 | 2022-12-29 01:02:28 | rocks | 1 | 28756 | 24 | 0.440 | 65354.5 |
855 | 2022-11-12 23:15:53 | rocks | 1 | 28756 | 24 | 0.440 | 65354.5 |
854 | 2022-10-25 08:25:40 | rocks | 1 | 28756 | 24 | 0.500 | 57512.0 |
853 | 2022-10-13 13:06:09 | rocks | 1 | 28756 | 24 | 0.436 | 65954.1 |
852 | 2022-10-01 14:15:29 | rocks | 1 | 28756 | 24 | 0.486 | 59168.7 |
851 | 2022-09-28 10:07:34 | rocks | 1 | 28756 | 24 | 0.440 | 65354.5 |
850 | 2022-09-11 16:34:12 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
849 | 2022-09-10 16:48:56 | rocks | 1 | 28756 | 24 | 0.500 | 57512.0 |
848 | 2022-09-01 01:07:50 | rocks | 1 | 28756 | 24 | 0.466 | 61708.2 |
847 | 2022-08-23 22:26:50 | rocks | 1 | 28756 | 24 | 0.500 | 57512.0 |
846 | 2022-08-15 22:59:45 | rocks | 1 | 28756 | 24 | 0.450 | 63902.2 |
845 | 2022-08-14 22:00:33 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
844 | 2022-07-30 08:56:24 | rocks | 1 | 28756 | 24 | 0.486 | 59168.7 |
843 | 2022-07-24 06:53:08 | rocks | 1 | 28756 | 24 | 0.466 | 61708.2 |
842 | 2022-06-27 00:11:09 | rocks | 1 | 28756 | 24 | 0.436 | 65954.1 |
841 | 2022-06-24 07:53:54 | rocks | 1 | 28756 | 24 | 0.436 | 65954.1 |
840 | 2022-06-05 02:06:41 | rocks | 1 | 28756 | 24 | 0.466 | 61708.2 |
839 | 2022-05-28 05:34:19 | rocks | 1 | 28756 | 24 | 0.466 | 61708.2 |
838 | 2022-05-15 13:55:34 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
837 | 2022-05-06 20:44:27 | rocks | 1 | 28756 | 24 | 0.530 | 54256.6 |
836 | 2022-04-17 23:57:58 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
835 | 2022-04-13 00:37:03 | rocks | 1 | 28756 | 24 | 0.470 | 61183.0 |
834 | 2022-03-21 20:01:54 | rocks | 1 | 28756 | 24 | 0.483 | 59536.2 |
833 | 2022-03-20 21:17:44 | rocks | 1 | 28756 | 24 | 0.483 | 59536.2 |
832 | 2022-03-07 06:06:02 | rocks | 1 | 28756 | 24 | 0.450 | 63902.2 |
831 | 2022-03-03 19:54:01 | rocks | 1 | 28756 | 24 | 0.516 | 55728.7 |
830 | 2022-03-01 09:50:01 | rocks | 1 | 28756 | 24 | 0.580 | 49579.3 |
829 | 2022-02-28 10:55:48 | rocks | 1 | 28756 | 24 | 1.140 | 25224.6 |
828 | 2022-02-27 08:02:44 | rocks | 1 | 28756 | 24 | 0.466 | 61708.2 |
827 | 2022-02-26 13:59:19 | rocks | 1 | 28756 | 24 | 0.516 | 55728.7 |
826 | 2022-02-25 05:40:16 | rocks | 1 | 28756 | 24 | 0.563 | 51076.4 |
825 | 2022-02-01 08:44:12 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
824 | 2022-01-28 20:02:24 | rocks | 1 | 28756 | 24 | 0.500 | 57512.0 |
823 | 2022-01-28 06:34:06 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
822 | 2022-01-27 12:55:31 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
821 | 2022-01-26 22:01:13 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
820 | 2022-01-26 13:25:04 | rocks | 1 | 28756 | 24 | 0.533 | 53951.2 |
819 | 2022-01-26 06:39:45 | rocks | 1 | 28756 | 24 | 0.500 | 57512.0 |
818 | 2022-01-25 22:59:37 | rocks | 1 | 28756 | 24 | 0.470 | 61183.0 |
817 | 2022-01-25 08:38:44 | rocks | 1 | 28756 | 24 | 0.483 | 59536.2 |
816 | 2022-01-25 02:15:30 | rocks | 1 | 28756 | 24 | 0.470 | 61183.0 |
815 | 2022-01-24 17:29:53 | rocks | 1 | 28756 | 24 | 0.436 | 65954.1 |
814 | 2022-01-23 23:40:29 | rocks | 1 | 28756 | 24 | 0.546 | 52666.7 |
813 | 2022-01-09 18:25:58 | rocks | 1 | 28756 | 24 | 0.563 | 51076.4 |
812 | 2022-01-07 19:29:03 | rocks | 1 | 28756 | 24 | 0.530 | 54256.6 |
811 | 2022-01-06 20:02:22 | rocks | 1 | 28756 | 24 | 0.533 | 53951.2 |
810 | 2022-01-02 20:22:57 | rocks | 1 | 28756 | 24 | 0.483 | 59536.2 |
809 | 2022-01-01 17:37:09 | rocks | 1 | 28756 | 24 | 0.546 | 52666.7 |
808 | 2021-12-31 21:15:22 | rocks | 1 | 28756 | 24 | 0.466 | 61708.2 |
807 | 2021-12-31 10:08:22 | rocks | 1 | 28756 | 24 | 0.546 | 52666.7 |
806 | 2021-12-30 21:02:59 | rocks | 1 | 28756 | 24 | 0.470 | 61183.0 |
805 | 2021-12-30 02:29:26 | rocks | 1 | 28756 | 24 | 0.453 | 63479.0 |
804 | 2021-12-29 14:41:42 | rocks | 1 | 28756 | 24 | 0.533 | 53951.2 |
803 | 2021-12-29 06:11:27 | rocks | 1 | 28756 | 24 | 0.516 | 55728.7 |