History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"caned"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
938 | 2024-04-22 05:33:18 | caned | 1 | 28756 | 24 | 0.923 | 31154.9 |
937 | 2024-04-22 05:32:42 | caned | 2 | 53800 | 402 | 3.753 | 14335.2 |
936 | 2024-04-21 03:39:27 | caned | 2 | 53800 | 402 | 3.920 | 13724.5 |
935 | 2024-04-20 20:11:49 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
934 | 2024-04-18 15:22:41 | caned | 1 | 28756 | 24 | 2.093 | 13739.1 |
933 | 2024-04-03 04:28:19 | caned | 1 | 28756 | 24 | 0.580 | 49579.3 |
932 | 2024-03-31 07:24:53 | caned | 1 | 28756 | 24 | 0.483 | 59536.2 |
931 | 2024-03-27 01:55:03 | caned | 1 | 28756 | 24 | 0.546 | 52666.7 |
930 | 2024-03-24 17:46:29 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
929 | 2024-03-21 22:59:40 | caned | 2 | 53800 | 402 | 1.936 | 27789.3 |
928 | 2024-03-03 21:07:01 | caned | 1 | 28756 | 24 | 0.550 | 52283.6 |
927 | 2024-03-01 09:30:55 | caned | 1 | 28756 | 24 | 0.576 | 49923.6 |
926 | 2024-02-25 17:54:47 | caned | 1 | 28756 | 24 | 1.156 | 24875.4 |
925 | 2024-02-23 19:07:20 | caned | 1 | 28756 | 24 | 0.580 | 49579.3 |
924 | 2024-02-02 20:23:15 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
923 | 2024-01-28 20:56:07 | caned | 1 | 28756 | 24 | 0.470 | 61183.0 |
922 | 2024-01-25 20:50:53 | caned | 1 | 28756 | 24 | 0.546 | 52666.7 |
921 | 2024-01-24 21:54:44 | caned | 1 | 28756 | 24 | 0.530 | 54256.6 |
920 | 2024-01-19 12:17:07 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
919 | 2023-12-27 14:21:32 | caned | 1 | 28756 | 24 | 0.483 | 59536.2 |
918 | 2023-12-19 23:40:13 | caned | 1 | 28756 | 24 | 0.450 | 63902.2 |
917 | 2023-12-03 06:44:08 | caned | 2 | 53800 | 402 | 1.716 | 31352.0 |
916 | 2023-11-27 10:37:00 | caned | 2 | 53800 | 402 | 1.420 | 37887.3 |
915 | 2023-11-26 23:14:31 | caned | 2 | 53800 | 402 | 1.500 | 35866.7 |
914 | 2023-11-12 13:17:28 | caned | 1 | 28756 | 24 | 0.503 | 57169.0 |
913 | 2023-11-10 00:41:38 | caned | 2 | 53800 | 402 | 1.423 | 37807.4 |
912 | 2023-11-09 22:00:55 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
911 | 2023-10-26 15:05:22 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
910 | 2023-10-20 11:45:42 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
909 | 2023-10-17 07:24:19 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
908 | 2023-10-16 02:46:55 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
907 | 2023-10-11 21:00:26 | caned | 1 | 28756 | 24 | 0.466 | 61708.2 |
906 | 2023-10-03 23:58:39 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
905 | 2023-09-23 04:17:26 | caned | 1 | 28756 | 24 | 0.470 | 61183.0 |
904 | 2023-09-13 07:55:07 | caned | 1 | 28756 | 24 | 0.450 | 63902.2 |
903 | 2023-09-11 05:16:26 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
902 | 2023-09-09 23:57:09 | caned | 1 | 28756 | 24 | 0.483 | 59536.2 |
901 | 2023-09-02 16:40:07 | caned | 1 | 28756 | 24 | 0.530 | 54256.6 |
900 | 2023-08-11 14:16:00 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
899 | 2023-07-02 06:43:48 | caned | 1 | 28756 | 24 | 0.533 | 53951.2 |
898 | 2023-07-01 05:14:43 | caned | 1 | 28756 | 24 | 0.450 | 63902.2 |
897 | 2023-06-09 09:50:41 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
896 | 2023-06-06 03:19:13 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
895 | 2023-05-30 00:41:20 | caned | 1 | 28756 | 24 | 0.436 | 65954.1 |
894 | 2023-05-12 16:06:44 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
893 | 2023-05-09 23:39:04 | caned | 1 | 28756 | 24 | 0.466 | 61708.2 |
892 | 2023-05-09 03:07:25 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
891 | 2023-04-10 05:10:18 | caned | 1 | 28756 | 24 | 0.483 | 59536.2 |
890 | 2023-03-27 14:43:31 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
889 | 2023-03-20 04:42:11 | caned | 1 | 28756 | 24 | 0.516 | 55728.7 |
888 | 2023-03-18 21:32:34 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
887 | 2023-03-06 11:46:22 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
886 | 2023-03-03 16:16:27 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
885 | 2023-01-24 18:33:22 | caned | 1 | 28756 | 24 | 0.440 | 65354.5 |
884 | 2023-01-23 08:10:05 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
883 | 2023-01-20 10:01:50 | caned | 1 | 28756 | 24 | 0.483 | 59536.2 |
882 | 2022-12-30 01:00:17 | caned | 1 | 28756 | 24 | 0.516 | 55728.7 |
881 | 2022-12-10 14:15:39 | caned | 1 | 28756 | 24 | 0.436 | 65954.1 |
880 | 2022-12-09 03:28:30 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
879 | 2022-12-06 09:50:59 | caned | 1 | 28756 | 24 | 0.436 | 65954.1 |
878 | 2022-11-25 11:42:07 | caned | 1 | 28756 | 24 | 0.513 | 56054.6 |
877 | 2022-10-30 21:57:53 | caned | 1 | 28756 | 24 | 0.813 | 35370.2 |
876 | 2022-10-29 20:19:26 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
875 | 2022-10-28 21:02:45 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
874 | 2022-10-27 19:57:36 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
873 | 2022-10-25 18:25:33 | caned | 1 | 28756 | 24 | 0.450 | 63902.2 |
872 | 2022-10-24 22:59:11 | caned | 1 | 28756 | 24 | 0.513 | 56054.6 |
871 | 2022-10-24 08:17:35 | caned | 1 | 28756 | 24 | 0.470 | 61183.0 |
870 | 2022-10-23 22:09:56 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
869 | 2022-10-23 01:17:46 | caned | 1 | 28756 | 24 | 0.436 | 65954.1 |
868 | 2022-10-22 20:01:53 | caned | 1 | 28756 | 24 | 0.436 | 65954.1 |
867 | 2022-10-20 10:37:38 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
866 | 2022-10-19 22:36:58 | caned | 1 | 28756 | 24 | 0.436 | 65954.1 |
865 | 2022-10-13 21:29:21 | caned | 1 | 28756 | 24 | 0.483 | 59536.2 |
864 | 2022-10-11 22:56:39 | caned | 1 | 28756 | 24 | 0.450 | 63902.2 |
863 | 2022-10-08 23:09:28 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
862 | 2022-09-17 20:36:16 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
861 | 2022-09-14 08:59:05 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
860 | 2022-09-10 18:48:56 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
859 | 2022-09-09 13:28:32 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
858 | 2022-09-06 17:43:42 | caned | 1 | 28756 | 24 | 0.436 | 65954.1 |
857 | 2022-09-01 16:24:28 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
856 | 2022-08-28 05:48:41 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
855 | 2022-08-25 07:13:19 | caned | 1 | 28756 | 24 | 0.546 | 52666.7 |
854 | 2022-08-14 20:06:10 | caned | 1 | 28756 | 24 | 0.470 | 61183.0 |
853 | 2022-08-06 13:17:17 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
852 | 2022-07-22 22:00:10 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
851 | 2022-07-21 16:28:50 | caned | 1 | 28756 | 24 | 0.440 | 65354.5 |
850 | 2022-07-16 20:28:20 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
849 | 2022-06-03 22:38:36 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
848 | 2022-06-02 14:41:06 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
847 | 2022-05-29 20:29:23 | caned | 1 | 28756 | 24 | 0.436 | 65954.1 |
846 | 2022-05-22 23:22:14 | caned | 1 | 28756 | 24 | 0.453 | 63479.0 |
845 | 2022-05-19 13:13:11 | caned | 1 | 28756 | 24 | 0.483 | 59536.2 |
844 | 2022-05-19 05:29:06 | caned | 1 | 28756 | 24 | 0.516 | 55728.7 |
843 | 2022-05-18 14:05:08 | caned | 1 | 28756 | 24 | 0.513 | 56054.6 |
842 | 2022-05-17 16:58:59 | caned | 1 | 28756 | 24 | 0.576 | 49923.6 |
841 | 2022-05-16 23:52:25 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
840 | 2022-05-16 03:36:06 | caned | 1 | 28756 | 24 | 0.500 | 57512.0 |
839 | 2022-05-15 14:14:28 | caned | 1 | 28756 | 24 | 0.470 | 61183.0 |