History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scamp"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
930 | 2024-04-23 12:16:18 | scamp | 1 | 28756 | 12 | 1.096 | 26237.2 |
929 | 2024-04-21 06:44:25 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
928 | 2024-04-21 06:32:43 | scamp | 1 | 28756 | 12 | 0.466 | 61708.2 |
927 | 2024-04-02 20:49:46 | scamp | 1 | 28756 | 12 | 0.453 | 63479.0 |
926 | 2024-03-31 02:39:14 | scamp | 1 | 28756 | 12 | 0.483 | 59536.2 |
925 | 2024-03-28 18:39:19 | scamp | 1 | 28756 | 12 | 1.203 | 23903.6 |
924 | 2024-03-27 22:09:52 | scamp | 1 | 28756 | 12 | 0.513 | 56054.6 |
923 | 2024-03-11 02:16:36 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
922 | 2024-03-08 22:02:51 | scamp | 2 | 53800 | 112 | 1.750 | 30742.9 |
921 | 2024-03-02 14:44:10 | scamp | 1 | 28756 | 12 | 1.920 | 14977.1 |
920 | 2024-02-29 23:17:20 | scamp | 1 | 28756 | 12 | 0.986 | 29164.3 |
919 | 2024-02-27 09:25:38 | scamp | 2 | 53800 | 112 | 1.736 | 30990.8 |
918 | 2024-02-26 22:41:38 | scamp | 2 | 53800 | 112 | 3.513 | 15314.5 |
917 | 2024-02-26 19:37:28 | scamp | 1 | 28756 | 12 | 0.483 | 59536.2 |
916 | 2024-01-29 02:38:03 | scamp | 1 | 28756 | 12 | 0.483 | 59536.2 |
915 | 2024-01-26 16:49:05 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
914 | 2024-01-23 01:24:11 | scamp | 1 | 28756 | 12 | 0.563 | 51076.4 |
913 | 2024-01-19 07:47:04 | scamp | 2 | 53800 | 112 | 1.530 | 35163.4 |
912 | 2024-01-17 19:25:22 | scamp | 1 | 28756 | 12 | 0.453 | 63479.0 |
911 | 2024-01-04 11:24:51 | scamp | 2 | 53800 | 112 | 1.720 | 31279.1 |
910 | 2023-12-02 13:18:25 | scamp | 1 | 28756 | 12 | 0.436 | 65954.1 |
909 | 2023-11-27 01:42:26 | scamp | 2 | 53800 | 112 | 1.563 | 34421.0 |
908 | 2023-11-24 10:58:00 | scamp | 2 | 53800 | 112 | 1.673 | 32157.8 |
907 | 2023-11-23 02:08:55 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
906 | 2023-11-17 22:39:16 | scamp | 1 | 28756 | 12 | 0.436 | 65954.1 |
905 | 2023-11-14 05:34:55 | scamp | 1 | 28756 | 12 | 0.516 | 55728.7 |
904 | 2023-11-03 17:14:53 | scamp | 1 | 28756 | 12 | 0.453 | 63479.0 |
903 | 2023-10-23 04:27:23 | scamp | 1 | 28756 | 12 | 0.486 | 59168.7 |
902 | 2023-10-21 17:02:29 | scamp | 2 | 53800 | 112 | 1.533 | 35094.6 |
901 | 2023-10-17 00:03:15 | scamp | 1 | 28756 | 12 | 0.530 | 54256.6 |
900 | 2023-10-11 19:16:39 | scamp | 1 | 28756 | 12 | 0.466 | 61708.2 |
899 | 2023-10-05 21:31:23 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
898 | 2023-09-25 23:20:38 | scamp | 2 | 53800 | 112 | 2.750 | 19563.6 |
897 | 2023-09-19 14:46:08 | scamp | 1 | 28756 | 12 | 0.516 | 55728.7 |
896 | 2023-09-14 11:58:02 | scamp | 1 | 28756 | 12 | 0.453 | 63479.0 |
895 | 2023-09-14 08:25:59 | scamp | 1 | 28756 | 12 | 1.063 | 27051.7 |
894 | 2023-09-10 04:58:37 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
893 | 2023-08-25 23:19:46 | scamp | 2 | 53800 | 112 | 1.720 | 31279.1 |
892 | 2023-06-15 16:36:18 | scamp | 1 | 28756 | 12 | 0.470 | 61183.0 |
891 | 2023-05-28 07:01:03 | scamp | 1 | 28756 | 12 | 0.440 | 65354.5 |
890 | 2023-05-24 23:36:32 | scamp | 1 | 28756 | 12 | 0.453 | 63479.0 |
889 | 2023-05-09 20:57:29 | scamp | 2 | 53800 | 112 | 1.390 | 38705.0 |
888 | 2023-03-30 04:54:30 | scamp | 1 | 28756 | 12 | 0.423 | 67981.1 |
887 | 2023-02-16 19:11:52 | scamp | 2 | 53800 | 112 | 1.360 | 39558.8 |
886 | 2023-02-10 05:18:08 | scamp | 2 | 53800 | 112 | 1.530 | 35163.4 |
885 | 2023-02-04 20:52:41 | scamp | 1 | 28756 | 12 | 1.046 | 27491.4 |
884 | 2023-01-12 17:07:53 | scamp | 1 | 28756 | 12 | 0.436 | 65954.1 |
883 | 2022-12-30 06:57:52 | scamp | 2 | 53800 | 112 | 3.283 | 16387.5 |
882 | 2022-12-22 17:20:26 | scamp | 2 | 53800 | 112 | 1.623 | 33148.5 |
881 | 2022-11-28 12:56:27 | scamp | 2 | 53800 | 112 | 1.500 | 35866.7 |
880 | 2022-11-06 05:01:04 | scamp | 2 | 53800 | 112 | 1.686 | 31909.8 |
879 | 2022-11-05 08:05:24 | scamp | 2 | 53800 | 112 | 1.376 | 39098.8 |
878 | 2022-10-30 20:52:12 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
877 | 2022-10-18 12:10:38 | scamp | 1 | 28756 | 12 | 0.436 | 65954.1 |
876 | 2022-10-14 18:40:48 | scamp | 1 | 28756 | 12 | 0.453 | 63479.0 |
875 | 2022-09-29 15:42:56 | scamp | 2 | 53800 | 112 | 1.373 | 39184.3 |
874 | 2022-09-12 12:50:35 | scamp | 1 | 28756 | 12 | 0.436 | 65954.1 |
873 | 2022-08-14 07:35:05 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
872 | 2022-08-07 06:37:17 | scamp | 1 | 28756 | 12 | 0.483 | 59536.2 |
871 | 2022-08-06 00:01:43 | scamp | 1 | 28756 | 12 | 0.486 | 59168.7 |
870 | 2022-07-05 19:44:14 | scamp | 2 | 53800 | 112 | 1.373 | 39184.3 |
869 | 2022-06-20 17:12:50 | scamp | 1 | 28756 | 12 | 0.453 | 63479.0 |
868 | 2022-06-18 21:50:03 | scamp | 1 | 28756 | 12 | 0.483 | 59536.2 |
867 | 2022-02-22 16:56:27 | scamp | 1 | 28756 | 12 | 0.610 | 47141.0 |
866 | 2022-02-09 02:18:37 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
865 | 2021-11-30 19:11:26 | scamp | 1 | 28756 | 12 | 0.546 | 52666.7 |
864 | 2021-11-11 07:26:52 | scamp | 1 | 28756 | 12 | 0.546 | 52666.7 |
863 | 2021-10-10 05:35:54 | scamp | 1 | 28756 | 12 | 0.436 | 65954.1 |
862 | 2021-09-25 13:35:07 | scamp | 2 | 53800 | 112 | 1.733 | 31044.4 |
861 | 2021-09-06 03:07:21 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
860 | 2021-09-03 06:13:44 | scamp | 1 | 28756 | 12 | 0.486 | 59168.7 |
859 | 2021-08-21 16:31:43 | scamp | 1 | 28756 | 12 | 0.436 | 65954.1 |
858 | 2021-08-05 21:43:56 | scamp | 1 | 28756 | 12 | 0.436 | 65954.1 |
857 | 2021-08-04 19:56:25 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
856 | 2021-07-18 17:45:31 | scamp | 1 | 28756 | 12 | 0.486 | 59168.7 |
855 | 2021-05-28 12:33:59 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
854 | 2021-05-08 00:11:47 | scamp | 1 | 28756 | 12 | 0.453 | 63479.0 |
853 | 2021-04-23 03:50:42 | scamp | 1 | 28756 | 12 | 0.626 | 45936.1 |
852 | 2021-04-06 10:11:44 | scamp | 1 | 28756 | 12 | 0.450 | 63902.2 |
851 | 2021-02-27 01:37:41 | scamp | 1 | 28756 | 12 | 0.453 | 63479.0 |
850 | 2021-01-21 16:52:24 | scamp | 1 | 28756 | 12 | 0.516 | 55728.7 |
849 | 2021-01-18 16:57:50 | scamp | 1 | 28756 | 12 | 0.436 | 65954.1 |
848 | 2020-10-29 13:21:36 | scamp | 1 | 28756 | 12 | 0.516 | 55728.7 |
847 | 2020-10-25 19:07:47 | scamp | 1 | 28756 | 12 | 0.483 | 59536.2 |
846 | 2020-10-16 17:36:57 | scamp | 1 | 28756 | 12 | 0.486 | 59168.7 |
845 | 2020-10-14 19:46:59 | scamp | 1 | 28756 | 12 | 0.470 | 61183.0 |
844 | 2020-10-07 00:34:29 | scamp | 1 | 28756 | 12 | 0.436 | 65954.1 |
843 | 2020-08-15 19:32:44 | scamp | 1 | 28756 | 12 | 0.453 | 63479.0 |
842 | 2020-08-03 13:08:47 | scamp | 1 | 28756 | 12 | 0.503 | 57169.0 |
841 | 2020-07-15 12:42:32 | scamp | 1 | 28756 | 12 | 0.466 | 61708.2 |
840 | 2020-05-19 07:32:06 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
839 | 2020-04-07 13:42:05 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |
838 | 2020-03-26 05:59:38 | scamp | 1 | 28756 | 12 | 0.530 | 54256.6 |
837 | 2020-03-25 04:16:33 | scamp | 1 | 28756 | 12 | 0.470 | 61183.0 |
836 | 2020-03-23 13:11:45 | scamp | 1 | 28756 | 12 | 0.653 | 44036.8 |
835 | 2020-03-21 23:20:40 | scamp | 1 | 28756 | 12 | 0.453 | 63479.0 |
834 | 2020-03-21 05:43:18 | scamp | 1 | 28756 | 12 | 0.516 | 55728.7 |
833 | 2020-03-20 13:55:27 | scamp | 1 | 28756 | 12 | 0.640 | 44931.3 |
832 | 2020-03-18 02:25:49 | scamp | 1 | 28756 | 12 | 0.610 | 47141.0 |
831 | 2020-03-02 10:35:47 | scamp | 1 | 28756 | 12 | 0.500 | 57512.0 |