History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spavies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
998 | 2024-04-13 07:40:09 | spavies | 1 | 69583 | 5 | 1.263 | 55093.4 |
997 | 2024-01-29 18:02:35 | spavies | 3 | 134027 | 652 | 10.220 | 13114.2 |
996 | 2024-01-04 23:08:03 | spavies | 3 | 134027 | 652 | 8.483 | 15799.5 |
995 | 2023-12-30 13:30:00 | spavies | 1 | 69583 | 5 | 1.126 | 61796.6 |
994 | 2023-12-09 19:11:10 | spavies | 1 | 69583 | 5 | 1.076 | 64668.2 |
993 | 2023-12-07 18:27:22 | spavies | 1 | 69583 | 5 | 1.220 | 57035.2 |
992 | 2023-12-07 18:27:20 | spavies | 1 | 69583 | 5 | 1.220 | 57035.2 |
991 | 2023-11-25 18:52:15 | spavies | 1 | 69583 | 5 | 1.266 | 54962.9 |
990 | 2023-11-23 23:48:00 | spavies | 1 | 69583 | 5 | 1.360 | 51164.0 |
989 | 2023-11-22 07:11:52 | spavies | 1 | 69583 | 5 | 1.266 | 54962.9 |
988 | 2023-11-05 13:35:19 | spavies | 1 | 69583 | 5 | 1.093 | 63662.4 |
987 | 2023-10-22 20:58:07 | spavies | 1 | 69583 | 5 | 1.266 | 54962.9 |
986 | 2023-10-11 01:41:30 | spavies | 3 | 134027 | 652 | 6.953 | 19276.1 |
985 | 2023-10-03 03:23:07 | spavies | 1 | 69583 | 5 | 1.126 | 61796.6 |
984 | 2023-09-26 20:05:38 | spavies | 1 | 69583 | 5 | 1.220 | 57035.2 |
983 | 2023-09-24 00:13:02 | spavies | 1 | 69583 | 5 | 1.280 | 54361.7 |
982 | 2023-08-17 01:09:10 | spavies | 1 | 69583 | 5 | 1.063 | 65459.1 |
981 | 2023-07-20 18:46:04 | spavies | 3 | 134027 | 652 | 6.733 | 19906.0 |
980 | 2023-06-06 08:22:11 | spavies | 1 | 69583 | 5 | 1.060 | 65644.3 |
979 | 2023-06-05 18:07:03 | spavies | 3 | 134027 | 652 | 6.406 | 20922.1 |
978 | 2023-05-18 09:01:17 | spavies | 1 | 69583 | 5 | 1.203 | 57841.2 |
977 | 2023-05-05 05:19:47 | spavies | 1 | 69583 | 5 | 1.170 | 59472.6 |
976 | 2023-04-30 21:08:35 | spavies | 3 | 134027 | 652 | 6.186 | 21666.2 |
975 | 2023-04-23 20:37:03 | spavies | 3 | 134027 | 652 | 5.643 | 23751.0 |
974 | 2023-03-30 03:45:30 | spavies | 3 | 134027 | 652 | 5.623 | 23835.5 |
973 | 2023-03-20 12:26:59 | spavies | 1 | 69583 | 5 | 1.046 | 66522.9 |
972 | 2023-03-14 05:00:20 | spavies | 1 | 69583 | 5 | 1.173 | 59320.5 |
971 | 2023-02-07 17:20:49 | spavies | 1 | 69583 | 5 | 1.110 | 62687.4 |
970 | 2022-12-31 04:18:19 | spavies | 1 | 69583 | 5 | 1.076 | 64668.2 |
969 | 2022-12-28 05:52:14 | spavies | 1 | 69583 | 5 | 1.073 | 64849.0 |
968 | 2022-12-26 21:33:48 | spavies | 3 | 134027 | 652 | 5.626 | 23822.8 |
967 | 2022-12-02 16:50:27 | spavies | 1 | 69583 | 5 | 1.190 | 58473.1 |
966 | 2022-10-10 05:27:45 | spavies | 1 | 69583 | 5 | 1.076 | 64668.2 |
965 | 2022-09-21 21:06:57 | spavies | 1 | 69583 | 5 | 1.046 | 66522.9 |
964 | 2022-08-28 13:58:46 | spavies | 3 | 134027 | 652 | 5.843 | 22938.0 |
963 | 2022-08-25 18:38:27 | spavies | 1 | 69583 | 5 | 1.173 | 59320.5 |
962 | 2022-08-19 18:35:35 | spavies | 3 | 134027 | 652 | 5.983 | 22401.3 |
961 | 2022-08-09 13:13:05 | spavies | 3 | 134027 | 652 | 5.780 | 23188.1 |
960 | 2022-07-15 02:17:32 | spavies | 2 | 107671 | 55 | 2.873 | 37476.9 |
959 | 2022-06-16 02:27:10 | spavies | 1 | 69583 | 5 | 1.126 | 61796.6 |
958 | 2022-05-05 07:29:03 | spavies | 1 | 69583 | 5 | 1.203 | 57841.2 |
957 | 2022-02-08 01:46:59 | spavies | 1 | 69583 | 5 | 1.126 | 61796.6 |
956 | 2022-01-19 23:00:41 | spavies | 1 | 69583 | 5 | 1.216 | 57222.9 |
955 | 2022-01-05 16:52:11 | spavies | 1 | 69583 | 5 | 1.250 | 55666.4 |
954 | 2021-12-16 14:47:01 | spavies | 1 | 69583 | 5 | 1.076 | 64668.2 |
953 | 2021-11-23 15:28:25 | spavies | 1 | 69583 | 5 | 1.126 | 61796.6 |
952 | 2021-11-17 16:39:13 | spavies | 1 | 69583 | 5 | 1.233 | 56433.9 |
951 | 2021-11-05 17:32:34 | spavies | 1 | 69583 | 5 | 1.326 | 52475.9 |
950 | 2021-10-24 18:50:27 | spavies | 1 | 69583 | 5 | 1.186 | 58670.3 |
949 | 2021-10-19 22:07:16 | spavies | 1 | 69583 | 5 | 1.080 | 64428.7 |
948 | 2021-10-05 18:59:41 | spavies | 1 | 69583 | 5 | 1.283 | 54234.6 |
947 | 2021-09-21 00:21:50 | spavies | 1 | 69583 | 5 | 1.093 | 63662.4 |
946 | 2021-09-10 22:02:00 | spavies | 1 | 69583 | 5 | 1.190 | 58473.1 |
945 | 2021-09-10 06:37:09 | spavies | 1 | 69583 | 5 | 1.093 | 63662.4 |
944 | 2021-09-06 21:43:29 | spavies | 1 | 69583 | 5 | 1.080 | 64428.7 |
943 | 2021-09-02 16:31:58 | spavies | 1 | 69583 | 5 | 1.110 | 62687.4 |
942 | 2021-08-15 23:27:56 | spavies | 1 | 69583 | 5 | 1.063 | 65459.1 |
941 | 2021-07-17 15:44:45 | spavies | 1 | 69583 | 5 | 1.170 | 59472.6 |
940 | 2021-07-07 10:45:31 | spavies | 3 | 134027 | 652 | 5.720 | 23431.3 |
939 | 2021-06-26 02:56:53 | spavies | 1 | 69583 | 5 | 1.203 | 57841.2 |
938 | 2021-06-08 19:21:38 | spavies | 1 | 69583 | 5 | 1.110 | 62687.4 |
937 | 2021-05-29 00:58:05 | spavies | 3 | 134027 | 652 | 6.296 | 21287.6 |
936 | 2021-05-21 16:53:06 | spavies | 3 | 134027 | 652 | 7.236 | 18522.2 |
935 | 2021-05-17 05:37:35 | spavies | 3 | 134027 | 652 | 6.700 | 20004.0 |
934 | 2021-05-14 16:10:35 | spavies | 1 | 69583 | 5 | 1.263 | 55093.4 |
933 | 2021-05-08 02:29:22 | spavies | 3 | 134027 | 652 | 7.156 | 18729.3 |
932 | 2021-04-22 08:15:43 | spavies | 3 | 134027 | 652 | 6.266 | 21389.6 |
931 | 2021-04-14 21:06:28 | spavies | 1 | 69583 | 5 | 1.390 | 50059.7 |
930 | 2021-04-14 01:32:10 | spavies | 1 | 69583 | 5 | 1.220 | 57035.2 |
929 | 2021-02-26 22:35:44 | spavies | 3 | 134027 | 652 | 6.253 | 21434.0 |
928 | 2021-02-20 16:14:22 | spavies | 1 | 69583 | 5 | 1.110 | 62687.4 |
927 | 2021-01-15 13:15:45 | spavies | 3 | 134027 | 652 | 5.860 | 22871.5 |
926 | 2021-01-09 09:01:12 | spavies | 1 | 69583 | 5 | 1.093 | 63662.4 |
925 | 2021-01-05 02:37:45 | spavies | 1 | 69583 | 5 | 1.093 | 63662.4 |
924 | 2020-11-13 06:57:23 | spavies | 1 | 69583 | 5 | 1.216 | 57222.9 |
923 | 2020-10-15 18:33:57 | spavies | 3 | 134027 | 652 | 7.860 | 17051.8 |
922 | 2020-10-15 18:19:59 | spavies | 1 | 69583 | 5 | 1.093 | 63662.4 |
921 | 2020-10-15 13:41:19 | spavies | 1 | 69583 | 5 | 1.093 | 63662.4 |
920 | 2020-10-03 17:59:45 | spavies | 1 | 69583 | 5 | 1.110 | 62687.4 |
919 | 2020-07-11 10:23:55 | spavies | 1 | 69583 | 5 | 1.140 | 61037.7 |
918 | 2020-06-16 13:50:37 | spavies | 1 | 69583 | 5 | 1.106 | 62914.1 |
917 | 2020-04-09 12:37:29 | spavies | 1 | 69583 | 5 | 1.143 | 60877.5 |
916 | 2020-03-28 18:38:50 | spavies | 1 | 69583 | 5 | 1.326 | 52475.9 |
915 | 2020-03-26 21:48:33 | spavies | 1 | 69583 | 5 | 1.296 | 53690.6 |
914 | 2020-03-24 06:59:15 | spavies | 1 | 69583 | 5 | 2.376 | 29285.8 |
913 | 2020-03-20 08:17:35 | spavies | 1 | 69583 | 5 | 1.143 | 60877.5 |
912 | 2020-03-09 01:13:50 | spavies | 1 | 69583 | 5 | 1.140 | 61037.7 |
911 | 2020-02-26 08:59:29 | spavies | 1 | 69583 | 5 | 1.356 | 51314.9 |
910 | 2020-02-26 04:44:20 | spavies | 1 | 69583 | 5 | 2.766 | 25156.5 |
909 | 2020-02-22 17:32:11 | spavies | 1 | 69583 | 5 | 1.390 | 50059.7 |
908 | 2020-02-18 09:13:54 | spavies | 3 | 134027 | 652 | 14.033 | 9550.8 |
907 | 2020-02-17 19:51:16 | spavies | 3 | 134027 | 652 | 9.406 | 14249.1 |
906 | 2020-02-11 10:57:17 | spavies | 3 | 134027 | 652 | 8.936 | 14998.5 |
905 | 2020-02-10 00:51:16 | spavies | 1 | 69583 | 5 | 2.890 | 24077.2 |
904 | 2020-02-08 22:58:18 | spavies | 3 | 134027 | 652 | 14.656 | 9144.9 |
903 | 2020-02-08 12:31:49 | spavies | 1 | 69583 | 5 | 1.440 | 48321.5 |
902 | 2020-02-04 10:06:38 | spavies | 1 | 69583 | 5 | 4.173 | 16674.6 |
901 | 2020-02-03 23:16:23 | spavies | 3 | 134027 | 652 | 8.203 | 16338.8 |
900 | 2020-02-03 22:33:45 | spavies | 1 | 69583 | 5 | 1.390 | 50059.7 |
899 | 2020-02-02 07:24:54 | spavies | 1 | 69583 | 5 | 1.313 | 52995.4 |