History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spotted"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1076 | 2024-03-09 00:06:29 | spotted | 3 | 134027 | 611 | 11.656 | 11498.5 |
1075 | 2024-03-08 19:03:14 | spotted | 3 | 134027 | 611 | 18.983 | 7060.4 |
1074 | 2024-03-08 18:07:05 | spotted | 3 | 134027 | 611 | 22.500 | 5956.8 |
1073 | 2024-03-08 02:13:42 | spotted | 3 | 134027 | 611 | 8.096 | 16554.7 |
1072 | 2024-03-07 16:03:20 | spotted | 3 | 134027 | 611 | 6.220 | 21547.7 |
1071 | 2024-03-07 03:36:21 | spotted | 1 | 69583 | 12 | 1.703 | 40859.1 |
1070 | 2024-03-07 00:10:05 | spotted | 3 | 134027 | 611 | 6.313 | 21230.3 |
1069 | 2024-03-07 00:10:05 | spotted | 2 | 107671 | 81 | 3.296 | 32667.2 |
1068 | 2024-03-06 21:02:59 | spotted | 1 | 69583 | 12 | 1.576 | 44151.6 |
1067 | 2024-02-20 10:19:33 | spotted | 1 | 69583 | 12 | 2.733 | 25460.3 |
1066 | 2024-02-11 13:38:00 | spotted | 3 | 134027 | 611 | 23.420 | 5722.8 |
1065 | 2024-02-01 21:31:32 | spotted | 2 | 107671 | 81 | 2.843 | 37872.3 |
1064 | 2024-01-31 22:34:28 | spotted | 2 | 107671 | 81 | 3.296 | 32667.2 |
1063 | 2024-01-31 22:33:40 | spotted | 3 | 134027 | 611 | 6.940 | 19312.2 |
1062 | 2024-01-31 11:30:52 | spotted | 2 | 107671 | 81 | 3.016 | 35699.9 |
1061 | 2024-01-31 11:30:47 | spotted | 3 | 134027 | 611 | 6.013 | 22289.5 |
1060 | 2024-01-30 21:57:43 | spotted | 2 | 107671 | 81 | 3.500 | 30763.1 |
1059 | 2024-01-30 21:57:11 | spotted | 3 | 134027 | 611 | 6.953 | 19276.1 |
1058 | 2024-01-30 14:48:57 | spotted | 3 | 134027 | 611 | 7.033 | 19056.9 |
1057 | 2024-01-08 06:16:11 | spotted | 1 | 69583 | 12 | 1.200 | 57985.8 |
1056 | 2023-11-23 00:45:26 | spotted | 3 | 134027 | 611 | 6.160 | 21757.6 |
1055 | 2023-11-20 11:53:17 | spotted | 3 | 134027 | 611 | 6.873 | 19500.5 |
1054 | 2023-11-18 14:51:47 | spotted | 1 | 69583 | 12 | 1.250 | 55666.4 |
1053 | 2023-11-18 08:54:44 | spotted | 1 | 69583 | 12 | 1.090 | 63837.6 |
1052 | 2023-11-11 10:25:20 | spotted | 1 | 69583 | 12 | 1.220 | 57035.2 |
1051 | 2023-11-08 23:35:01 | spotted | 3 | 134027 | 611 | 5.643 | 23751.0 |
1050 | 2023-11-06 04:23:41 | spotted | 1 | 69583 | 12 | 1.076 | 64668.2 |
1049 | 2023-10-31 21:06:59 | spotted | 1 | 69583 | 12 | 2.673 | 26031.8 |
1048 | 2023-10-24 15:14:50 | spotted | 1 | 69583 | 12 | 1.186 | 58670.3 |
1047 | 2023-09-28 14:34:42 | spotted | 1 | 69583 | 12 | 1.266 | 54962.9 |
1046 | 2023-09-25 17:38:40 | spotted | 1 | 69583 | 12 | 1.046 | 66522.9 |
1045 | 2023-08-24 18:34:14 | spotted | 1 | 69583 | 12 | 1.250 | 55666.4 |
1044 | 2023-08-17 03:11:48 | spotted | 3 | 134027 | 611 | 5.923 | 22628.2 |
1043 | 2023-08-15 15:25:40 | spotted | 3 | 134027 | 611 | 5.750 | 23309.0 |
1042 | 2023-08-14 03:16:13 | spotted | 3 | 134027 | 611 | 6.826 | 19634.8 |
1041 | 2023-08-13 22:02:39 | spotted | 3 | 134027 | 611 | 5.923 | 22628.2 |
1040 | 2023-08-13 05:50:18 | spotted | 3 | 134027 | 611 | 5.720 | 23431.3 |
1039 | 2023-08-12 02:16:26 | spotted | 3 | 134027 | 611 | 6.330 | 21173.3 |
1038 | 2023-08-01 21:31:50 | spotted | 3 | 134027 | 611 | 6.986 | 19185.1 |
1037 | 2023-07-26 17:10:17 | spotted | 3 | 134027 | 611 | 7.360 | 18210.2 |
1036 | 2023-07-25 23:50:43 | spotted | 3 | 134027 | 611 | 6.250 | 21444.3 |
1035 | 2023-07-21 20:16:54 | spotted | 3 | 134027 | 611 | 5.906 | 22693.4 |
1034 | 2023-05-27 17:06:08 | spotted | 1 | 69583 | 12 | 1.233 | 56433.9 |
1033 | 2023-05-26 03:19:38 | spotted | 1 | 69583 | 12 | 1.140 | 61037.7 |
1032 | 2023-04-27 12:54:03 | spotted | 3 | 134027 | 611 | 5.766 | 23244.4 |
1031 | 2023-03-22 03:55:05 | spotted | 1 | 69583 | 12 | 1.076 | 64668.2 |
1030 | 2023-02-01 22:25:54 | spotted | 3 | 134027 | 611 | 5.593 | 23963.3 |
1029 | 2023-01-30 04:34:38 | spotted | 1 | 69583 | 12 | 1.266 | 54962.9 |
1028 | 2023-01-23 08:14:03 | spotted | 3 | 134027 | 611 | 6.830 | 19623.3 |
1027 | 2023-01-16 02:35:18 | spotted | 3 | 134027 | 611 | 6.516 | 20568.9 |
1026 | 2023-01-07 02:54:55 | spotted | 1 | 69583 | 12 | 1.080 | 64428.7 |
1025 | 2022-12-13 14:05:44 | spotted | 3 | 134027 | 611 | 6.843 | 19586.0 |
1024 | 2022-11-13 21:28:51 | spotted | 3 | 134027 | 611 | 5.720 | 23431.3 |
1023 | 2022-10-01 11:10:31 | spotted | 1 | 69583 | 12 | 1.233 | 56433.9 |
1022 | 2022-09-27 20:58:39 | spotted | 1 | 69583 | 12 | 1.140 | 61037.7 |
1021 | 2022-06-18 14:21:33 | spotted | 3 | 134027 | 611 | 6.376 | 21020.5 |
1020 | 2022-06-15 06:45:07 | spotted | 3 | 134027 | 611 | 6.110 | 21935.7 |
1019 | 2022-05-18 20:10:37 | spotted | 1 | 69583 | 12 | 1.186 | 58670.3 |
1018 | 2022-05-14 19:24:18 | spotted | 1 | 69583 | 12 | 1.080 | 64428.7 |
1017 | 2022-05-06 18:20:37 | spotted | 2 | 107671 | 81 | 2.826 | 38100.1 |
1016 | 2022-05-05 17:25:11 | spotted | 2 | 107671 | 81 | 3.283 | 32796.5 |
1015 | 2022-05-04 12:52:19 | spotted | 2 | 107671 | 81 | 3.216 | 33479.8 |
1014 | 2022-05-03 16:34:02 | spotted | 2 | 107671 | 81 | 3.906 | 27565.5 |
1013 | 2022-05-03 10:00:13 | spotted | 3 | 134027 | 611 | 6.860 | 19537.5 |
1012 | 2022-03-01 13:39:22 | spotted | 2 | 107671 | 81 | 3.686 | 29210.8 |
1011 | 2022-02-28 18:57:56 | spotted | 2 | 107671 | 81 | 3.533 | 30475.8 |
1010 | 2022-02-27 21:11:31 | spotted | 2 | 107671 | 81 | 2.830 | 38046.3 |
1009 | 2022-02-27 09:01:44 | spotted | 2 | 107671 | 81 | 3.143 | 34257.4 |
1008 | 2022-02-26 18:08:07 | spotted | 2 | 107671 | 81 | 2.843 | 37872.3 |
1007 | 2022-02-25 18:09:56 | spotted | 2 | 107671 | 81 | 2.906 | 37051.3 |
1006 | 2022-02-25 08:10:55 | spotted | 2 | 107671 | 81 | 3.123 | 34476.8 |
1005 | 2022-02-25 04:10:59 | spotted | 2 | 107671 | 81 | 3.486 | 30886.7 |
1004 | 2022-02-24 10:33:59 | spotted | 2 | 107671 | 81 | 3.296 | 32667.2 |
1003 | 2022-02-23 19:26:18 | spotted | 2 | 107671 | 81 | 3.233 | 33303.7 |
1002 | 2022-02-23 00:14:54 | spotted | 2 | 107671 | 81 | 3.580 | 30075.7 |
1001 | 2022-02-22 05:00:45 | spotted | 2 | 107671 | 81 | 3.220 | 33438.2 |
1000 | 2022-02-21 08:42:09 | spotted | 2 | 107671 | 81 | 3.546 | 30364.1 |
999 | 2022-02-20 20:07:33 | spotted | 2 | 107671 | 81 | 2.876 | 37437.8 |
998 | 2022-02-20 09:00:08 | spotted | 2 | 107671 | 81 | 2.890 | 37256.4 |
997 | 2022-02-19 18:36:44 | spotted | 2 | 107671 | 81 | 3.313 | 32499.5 |
996 | 2022-02-19 06:00:20 | spotted | 2 | 107671 | 81 | 3.046 | 35348.3 |
995 | 2022-02-18 19:47:24 | spotted | 2 | 107671 | 81 | 2.890 | 37256.4 |
994 | 2022-02-18 10:13:15 | spotted | 2 | 107671 | 81 | 3.063 | 35152.1 |
993 | 2022-02-17 18:06:16 | spotted | 2 | 107671 | 81 | 3.143 | 34257.4 |
992 | 2022-02-17 00:17:02 | spotted | 2 | 107671 | 81 | 3.140 | 34290.1 |
991 | 2022-02-16 08:17:56 | spotted | 2 | 107671 | 81 | 6.690 | 16094.3 |
990 | 2022-02-15 14:32:53 | spotted | 2 | 107671 | 81 | 3.236 | 33272.9 |
989 | 2022-02-14 18:23:14 | spotted | 2 | 107671 | 81 | 3.563 | 30219.2 |
988 | 2022-02-13 23:08:07 | spotted | 2 | 107671 | 81 | 3.190 | 33752.7 |
987 | 2022-02-13 03:19:21 | spotted | 2 | 107671 | 81 | 2.983 | 36094.9 |
986 | 2022-02-12 14:48:20 | spotted | 2 | 107671 | 81 | 3.500 | 30763.1 |
985 | 2022-02-11 14:08:32 | spotted | 2 | 107671 | 81 | 2.923 | 36835.8 |
984 | 2022-02-11 04:03:55 | spotted | 2 | 107671 | 81 | 3.186 | 33795.0 |
983 | 2022-02-10 10:19:51 | spotted | 2 | 107671 | 81 | 2.860 | 37647.2 |
982 | 2022-02-09 22:06:30 | spotted | 2 | 107671 | 81 | 3.360 | 32044.9 |
981 | 2022-02-09 04:56:24 | spotted | 2 | 107671 | 81 | 3.173 | 33933.5 |
980 | 2022-02-08 19:33:49 | spotted | 2 | 107671 | 81 | 2.970 | 36252.9 |
979 | 2022-02-08 04:00:58 | spotted | 2 | 107671 | 81 | 2.860 | 37647.2 |
978 | 2022-02-04 14:27:46 | spotted | 1 | 69583 | 12 | 1.313 | 52995.4 |
977 | 2022-02-02 10:44:10 | spotted | 1 | 69583 | 12 | 1.203 | 57841.2 |