History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stare"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1010 | 2024-03-20 18:40:01 | stare | 2 | 53800 | 278 | 1.750 | 30742.9 |
1009 | 2024-03-20 18:39:38 | stare | 1 | 28756 | 24 | 1.123 | 25606.4 |
1008 | 2024-03-20 18:39:01 | stare | 2 | 53800 | 278 | 2.576 | 20885.1 |
1007 | 2024-03-11 03:07:28 | stare | 1 | 28756 | 24 | 0.626 | 45936.1 |
1006 | 2024-03-06 02:31:15 | stare | 1 | 28756 | 24 | 0.576 | 49923.6 |
1005 | 2024-03-04 01:58:41 | stare | 1 | 28756 | 24 | 0.453 | 63479.0 |
1004 | 2024-02-25 18:14:24 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
1003 | 2024-02-25 04:05:56 | stare | 1 | 28756 | 24 | 0.450 | 63902.2 |
1002 | 2024-02-18 08:10:36 | stare | 2 | 53800 | 278 | 5.656 | 9512.0 |
1001 | 2024-02-03 03:48:47 | stare | 1 | 28756 | 24 | 1.030 | 27918.4 |
1000 | 2024-01-26 14:56:49 | stare | 1 | 28756 | 24 | 0.953 | 30174.2 |
999 | 2024-01-18 02:59:49 | stare | 1 | 28756 | 24 | 0.576 | 49923.6 |
998 | 2024-01-05 02:13:25 | stare | 1 | 28756 | 24 | 0.516 | 55728.7 |
997 | 2023-12-25 01:28:32 | stare | 2 | 53800 | 278 | 1.656 | 32487.9 |
996 | 2023-12-23 02:07:30 | stare | 2 | 53800 | 278 | 1.560 | 34487.2 |
995 | 2023-12-16 02:11:39 | stare | 1 | 28756 | 24 | 0.453 | 63479.0 |
994 | 2023-12-13 06:11:27 | stare | 1 | 28756 | 24 | 0.436 | 65954.1 |
993 | 2023-12-09 05:12:58 | stare | 2 | 53800 | 278 | 1.390 | 38705.0 |
992 | 2023-12-08 10:36:21 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
991 | 2023-12-08 10:36:20 | stare | 1 | 28756 | 24 | 0.533 | 53951.2 |
990 | 2023-12-04 18:18:03 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
989 | 2023-12-04 18:18:02 | stare | 1 | 28756 | 24 | 0.516 | 55728.7 |
988 | 2023-12-04 13:08:57 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
987 | 2023-11-27 21:19:32 | stare | 1 | 28756 | 24 | 0.483 | 59536.2 |
986 | 2023-11-26 19:39:05 | stare | 2 | 53800 | 278 | 1.423 | 37807.4 |
985 | 2023-11-12 20:20:39 | stare | 1 | 28756 | 24 | 0.470 | 61183.0 |
984 | 2023-11-10 17:38:46 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
983 | 2023-10-27 11:36:55 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
982 | 2023-10-20 06:39:22 | stare | 1 | 28756 | 24 | 0.453 | 63479.0 |
981 | 2023-10-17 22:05:28 | stare | 1 | 28756 | 24 | 0.533 | 53951.2 |
980 | 2023-10-17 15:16:04 | stare | 2 | 53800 | 278 | 1.420 | 37887.3 |
979 | 2023-10-16 07:45:51 | stare | 2 | 53800 | 278 | 1.623 | 33148.5 |
978 | 2023-10-10 23:56:32 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
977 | 2023-10-04 10:12:10 | stare | 1 | 28756 | 24 | 0.436 | 65954.1 |
976 | 2023-09-30 10:08:19 | stare | 2 | 53800 | 278 | 1.610 | 33416.1 |
975 | 2023-09-29 10:34:50 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
974 | 2023-09-28 15:47:51 | stare | 2 | 53800 | 278 | 1.813 | 29674.6 |
973 | 2023-09-23 22:54:01 | stare | 2 | 53800 | 278 | 1.390 | 38705.0 |
972 | 2023-09-22 16:39:49 | stare | 1 | 28756 | 24 | 0.466 | 61708.2 |
971 | 2023-09-21 18:27:41 | stare | 1 | 28756 | 24 | 0.440 | 65354.5 |
970 | 2023-08-12 02:31:53 | stare | 1 | 28756 | 24 | 0.593 | 48492.4 |
969 | 2023-07-27 05:41:59 | stare | 1 | 28756 | 24 | 0.436 | 65954.1 |
968 | 2023-07-01 07:48:35 | stare | 2 | 53800 | 278 | 1.500 | 35866.7 |
967 | 2023-05-30 17:12:34 | stare | 1 | 28756 | 24 | 0.440 | 65354.5 |
966 | 2023-05-04 14:23:38 | stare | 1 | 28756 | 24 | 0.470 | 61183.0 |
965 | 2023-04-27 04:59:47 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
964 | 2023-04-22 04:17:34 | stare | 1 | 28756 | 24 | 0.513 | 56054.6 |
963 | 2023-04-01 03:57:21 | stare | 2 | 53800 | 278 | 1.360 | 39558.8 |
962 | 2023-03-23 16:12:44 | stare | 2 | 53800 | 278 | 1.376 | 39098.8 |
961 | 2023-02-16 17:04:44 | stare | 1 | 28756 | 24 | 0.440 | 65354.5 |
960 | 2023-02-06 01:53:17 | stare | 2 | 53800 | 278 | 1.393 | 38621.7 |
959 | 2023-01-29 15:06:33 | stare | 1 | 28756 | 24 | 0.440 | 65354.5 |
958 | 2023-01-13 04:51:35 | stare | 2 | 53800 | 278 | 1.546 | 34799.5 |
957 | 2022-12-29 04:26:09 | stare | 2 | 53800 | 278 | 3.250 | 16553.8 |
956 | 2022-12-27 16:52:44 | stare | 1 | 28756 | 24 | 0.440 | 65354.5 |
955 | 2022-12-22 17:43:38 | stare | 2 | 53800 | 278 | 1.373 | 39184.3 |
954 | 2022-12-20 19:10:58 | stare | 2 | 53800 | 278 | 1.546 | 34799.5 |
953 | 2022-12-14 04:09:12 | stare | 1 | 28756 | 24 | 0.453 | 63479.0 |
952 | 2022-11-29 01:49:50 | stare | 2 | 53800 | 278 | 1.436 | 37465.2 |
951 | 2022-11-24 15:25:37 | stare | 1 | 28756 | 24 | 0.466 | 61708.2 |
950 | 2022-11-21 11:23:05 | stare | 1 | 28756 | 24 | 0.453 | 63479.0 |
949 | 2022-11-20 00:02:40 | stare | 2 | 53800 | 278 | 2.453 | 21932.3 |
948 | 2022-11-08 15:16:25 | stare | 1 | 28756 | 24 | 0.453 | 63479.0 |
947 | 2022-11-07 22:38:46 | stare | 2 | 53800 | 278 | 2.796 | 19241.8 |
946 | 2022-11-06 10:55:16 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
945 | 2022-10-15 09:58:30 | stare | 1 | 28756 | 24 | 0.470 | 61183.0 |
944 | 2022-10-12 03:25:03 | stare | 2 | 53800 | 278 | 1.406 | 38264.6 |
943 | 2022-09-07 21:30:57 | stare | 2 | 53800 | 278 | 2.016 | 26686.5 |
942 | 2022-08-30 11:31:43 | stare | 2 | 53800 | 278 | 1.843 | 29191.5 |
941 | 2022-08-30 09:30:53 | stare | 2 | 53800 | 278 | 1.670 | 32215.6 |
940 | 2022-08-20 06:00:23 | stare | 1 | 28756 | 24 | 0.440 | 65354.5 |
939 | 2022-08-18 19:37:25 | stare | 2 | 53800 | 278 | 1.500 | 35866.7 |
938 | 2022-08-16 02:18:20 | stare | 1 | 28756 | 24 | 0.453 | 63479.0 |
937 | 2022-08-07 04:05:27 | stare | 1 | 28756 | 24 | 0.436 | 65954.1 |
936 | 2022-07-25 22:31:29 | stare | 2 | 53800 | 278 | 1.686 | 31909.8 |
935 | 2022-07-18 08:45:33 | stare | 1 | 28756 | 24 | 0.483 | 59536.2 |
934 | 2022-07-11 16:00:56 | stare | 1 | 28756 | 24 | 0.576 | 49923.6 |
933 | 2022-07-10 11:24:23 | stare | 1 | 28756 | 24 | 0.563 | 51076.4 |
932 | 2022-06-26 08:25:15 | stare | 1 | 28756 | 24 | 0.453 | 63479.0 |
931 | 2022-06-25 16:33:10 | stare | 1 | 28756 | 24 | 0.436 | 65954.1 |
930 | 2022-06-25 02:29:23 | stare | 1 | 28756 | 24 | 0.456 | 63061.4 |
929 | 2022-06-08 20:22:59 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
928 | 2022-06-07 09:44:00 | stare | 1 | 28756 | 24 | 0.500 | 57512.0 |
927 | 2022-04-08 13:31:24 | stare | 1 | 28756 | 24 | 0.470 | 61183.0 |
926 | 2022-03-21 22:52:38 | stare | 1 | 28756 | 24 | 0.593 | 48492.4 |
925 | 2022-03-08 22:33:45 | stare | 1 | 28756 | 24 | 0.626 | 45936.1 |
924 | 2022-01-07 23:23:42 | stare | 1 | 28756 | 24 | 0.453 | 63479.0 |
923 | 2022-01-05 21:41:10 | stare | 1 | 28756 | 24 | 0.766 | 37540.5 |
922 | 2021-12-24 00:02:14 | stare | 1 | 28756 | 24 | 0.470 | 61183.0 |
921 | 2021-12-05 09:13:36 | stare | 1 | 28756 | 24 | 0.453 | 63479.0 |
920 | 2021-11-08 05:41:26 | stare | 1 | 28756 | 24 | 0.466 | 61708.2 |
919 | 2021-11-07 20:01:22 | stare | 1 | 28756 | 24 | 0.483 | 59536.2 |
918 | 2021-11-06 04:07:07 | stare | 1 | 28756 | 24 | 0.516 | 55728.7 |
917 | 2021-11-05 22:32:49 | stare | 1 | 28756 | 24 | 0.483 | 59536.2 |
916 | 2021-09-23 15:30:42 | stare | 1 | 28756 | 24 | 0.640 | 44931.3 |
915 | 2021-09-21 12:22:47 | stare | 1 | 28756 | 24 | 0.576 | 49923.6 |
914 | 2021-09-14 20:55:19 | stare | 1 | 28756 | 24 | 0.513 | 56054.6 |
913 | 2021-09-01 22:06:50 | stare | 1 | 28756 | 24 | 0.546 | 52666.7 |
912 | 2021-09-01 06:26:59 | stare | 1 | 28756 | 24 | 0.486 | 59168.7 |
911 | 2021-08-01 23:07:52 | stare | 1 | 28756 | 24 | 0.440 | 65354.5 |