History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spoor"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1201 | 2024-04-27 20:20:47 | spoor | 1 | 28756 | 8 | 0.560 | 51350.0 |
1200 | 2024-04-27 07:19:13 | spoor | 1 | 28756 | 8 | 1.750 | 16432.0 |
1199 | 2024-04-18 20:23:22 | spoor | 1 | 28756 | 8 | 0.483 | 59536.2 |
1198 | 2024-04-05 01:36:05 | spoor | 3 | 83667 | 984 | 3.500 | 23904.9 |
1197 | 2024-04-05 01:36:05 | spoor | 2 | 53800 | 84 | 1.593 | 33772.8 |
1196 | 2024-04-05 01:36:00 | spoor | 1 | 28756 | 8 | 0.500 | 57512.0 |
1195 | 2024-04-05 01:35:56 | spoor | 3 | 83667 | 984 | 3.686 | 22698.6 |
1194 | 2024-04-05 01:35:53 | spoor | 2 | 53800 | 84 | 1.673 | 32157.8 |
1193 | 2024-04-05 01:35:49 | spoor | 1 | 28756 | 8 | 1.016 | 28303.1 |
1192 | 2024-04-03 04:34:42 | spoor | 3 | 83667 | 984 | 11.220 | 7457.0 |
1191 | 2024-04-03 04:34:41 | spoor | 2 | 53800 | 84 | 5.530 | 9728.8 |
1190 | 2024-04-03 04:22:36 | spoor | 1 | 28756 | 8 | 0.576 | 49923.6 |
1189 | 2024-03-31 03:46:40 | spoor | 1 | 28756 | 8 | 0.890 | 32310.1 |
1188 | 2024-03-29 02:07:55 | spoor | 1 | 28756 | 8 | 0.546 | 52666.7 |
1187 | 2024-03-04 01:28:56 | spoor | 1 | 28756 | 8 | 0.500 | 57512.0 |
1186 | 2024-02-28 16:51:54 | spoor | 1 | 28756 | 8 | 0.483 | 59536.2 |
1185 | 2024-02-27 19:57:01 | spoor | 1 | 28756 | 8 | 0.483 | 59536.2 |
1184 | 2024-02-05 18:07:56 | spoor | 1 | 28756 | 8 | 0.486 | 59168.7 |
1183 | 2024-02-03 00:27:31 | spoor | 1 | 28756 | 8 | 0.453 | 63479.0 |
1182 | 2024-02-01 22:24:12 | spoor | 1 | 28756 | 8 | 0.436 | 65954.1 |
1181 | 2024-01-28 19:32:33 | spoor | 1 | 28756 | 8 | 0.436 | 65954.1 |
1180 | 2024-01-15 17:16:07 | spoor | 2 | 53800 | 84 | 1.716 | 31352.0 |
1179 | 2023-12-31 09:39:47 | spoor | 1 | 28756 | 8 | 0.453 | 63479.0 |
1178 | 2023-12-25 18:24:45 | spoor | 3 | 83667 | 984 | 3.766 | 22216.4 |
1177 | 2023-11-27 16:11:37 | spoor | 2 | 53800 | 84 | 1.360 | 39558.8 |
1176 | 2023-11-25 02:06:39 | spoor | 1 | 28756 | 8 | 0.483 | 59536.2 |
1175 | 2023-11-23 12:16:01 | spoor | 1 | 28756 | 8 | 0.453 | 63479.0 |
1174 | 2023-11-09 18:03:05 | spoor | 1 | 28756 | 8 | 0.483 | 59536.2 |
1173 | 2023-10-31 03:39:21 | spoor | 1 | 28756 | 8 | 0.453 | 63479.0 |
1172 | 2023-10-28 16:35:17 | spoor | 1 | 28756 | 8 | 0.456 | 63061.4 |
1171 | 2023-10-27 01:36:17 | spoor | 2 | 53800 | 84 | 1.440 | 37361.1 |
1170 | 2023-10-19 20:05:43 | spoor | 1 | 28756 | 8 | 0.466 | 61708.2 |
1169 | 2023-10-13 17:42:09 | spoor | 1 | 28756 | 8 | 0.436 | 65954.1 |
1168 | 2023-10-08 05:11:51 | spoor | 1 | 28756 | 8 | 0.456 | 63061.4 |
1167 | 2023-09-30 02:00:24 | spoor | 3 | 83667 | 984 | 4.080 | 20506.6 |
1166 | 2023-09-29 11:54:21 | spoor | 3 | 83667 | 984 | 3.953 | 21165.4 |
1165 | 2023-09-25 07:02:43 | spoor | 1 | 28756 | 8 | 0.580 | 49579.3 |
1164 | 2023-09-24 14:22:25 | spoor | 3 | 83667 | 984 | 3.360 | 24900.9 |
1163 | 2023-09-24 06:32:06 | spoor | 1 | 28756 | 8 | 0.483 | 59536.2 |
1162 | 2023-09-21 02:12:27 | spoor | 1 | 28756 | 8 | 0.436 | 65954.1 |
1161 | 2023-08-15 01:32:02 | spoor | 1 | 28756 | 8 | 0.483 | 59536.2 |
1160 | 2023-08-05 00:39:39 | spoor | 2 | 53800 | 84 | 1.533 | 35094.6 |
1159 | 2023-06-29 01:48:31 | spoor | 3 | 83667 | 984 | 3.860 | 21675.4 |
1158 | 2023-05-18 09:13:14 | spoor | 1 | 28756 | 8 | 0.436 | 65954.1 |
1157 | 2023-05-14 04:25:27 | spoor | 1 | 28756 | 8 | 0.436 | 65954.1 |
1156 | 2023-04-19 19:10:55 | spoor | 2 | 53800 | 84 | 1.390 | 38705.0 |
1155 | 2023-03-22 11:20:24 | spoor | 3 | 83667 | 984 | 3.233 | 25879.1 |
1154 | 2023-03-07 18:29:41 | spoor | 1 | 28756 | 8 | 0.453 | 63479.0 |
1153 | 2023-03-04 13:35:50 | spoor | 1 | 28756 | 8 | 0.436 | 65954.1 |
1152 | 2023-02-01 02:45:31 | spoor | 3 | 83667 | 984 | 3.626 | 23074.2 |
1151 | 2023-01-22 13:25:41 | spoor | 2 | 53800 | 84 | 1.376 | 39098.8 |
1150 | 2023-01-14 08:00:48 | spoor | 1 | 28756 | 8 | 0.436 | 65954.1 |
1149 | 2022-12-29 07:17:41 | spoor | 1 | 28756 | 8 | 0.436 | 65954.1 |
1148 | 2022-12-21 21:34:17 | spoor | 3 | 83667 | 984 | 3.190 | 26227.9 |
1147 | 2022-12-16 09:42:49 | spoor | 3 | 83667 | 984 | 3.686 | 22698.6 |
1146 | 2022-11-26 20:28:47 | spoor | 3 | 83667 | 984 | 3.720 | 22491.1 |
1145 | 2022-11-03 13:47:41 | spoor | 3 | 83667 | 984 | 3.593 | 23286.1 |
1144 | 2022-11-03 04:09:44 | spoor | 2 | 53800 | 84 | 1.360 | 39558.8 |
1143 | 2022-10-29 20:59:26 | spoor | 3 | 83667 | 984 | 3.736 | 22394.8 |
1142 | 2022-10-25 15:26:41 | spoor | 3 | 83667 | 984 | 3.503 | 23884.4 |
1141 | 2022-10-04 12:52:49 | spoor | 2 | 53800 | 84 | 1.606 | 33499.4 |
1140 | 2022-09-25 05:41:54 | spoor | 3 | 83667 | 984 | 3.393 | 24658.7 |
1139 | 2022-09-15 22:23:43 | spoor | 1 | 28756 | 8 | 0.500 | 57512.0 |
1138 | 2022-09-05 06:29:33 | spoor | 1 | 28756 | 8 | 0.436 | 65954.1 |
1137 | 2022-09-05 04:41:03 | spoor | 2 | 53800 | 84 | 1.546 | 34799.5 |
1136 | 2022-08-19 14:07:35 | spoor | 3 | 83667 | 984 | 3.406 | 24564.6 |
1135 | 2022-07-29 08:00:40 | spoor | 1 | 28756 | 8 | 0.440 | 65354.5 |
1134 | 2022-07-12 21:33:43 | spoor | 1 | 28756 | 8 | 0.453 | 63479.0 |
1133 | 2022-06-07 03:52:13 | spoor | 2 | 53800 | 84 | 1.360 | 39558.8 |
1132 | 2022-06-04 17:03:02 | spoor | 2 | 53800 | 84 | 1.376 | 39098.8 |
1131 | 2022-05-31 06:31:28 | spoor | 2 | 53800 | 84 | 1.513 | 35558.5 |
1130 | 2022-05-16 09:56:39 | spoor | 1 | 28756 | 8 | 0.670 | 42919.4 |
1129 | 2022-05-13 17:39:15 | spoor | 2 | 53800 | 84 | 1.890 | 28465.6 |
1128 | 2022-05-04 22:09:49 | spoor | 2 | 53800 | 84 | 1.390 | 38705.0 |
1127 | 2022-04-20 10:21:00 | spoor | 2 | 53800 | 84 | 1.826 | 29463.3 |
1126 | 2022-04-18 18:24:38 | spoor | 1 | 28756 | 8 | 0.453 | 63479.0 |
1125 | 2022-04-04 06:39:42 | spoor | 2 | 53800 | 84 | 1.500 | 35866.7 |
1124 | 2022-03-18 23:14:53 | spoor | 2 | 53800 | 84 | 1.343 | 40059.6 |
1123 | 2022-03-17 19:26:55 | spoor | 2 | 53800 | 84 | 1.763 | 30516.2 |
1122 | 2022-03-16 23:59:30 | spoor | 2 | 53800 | 84 | 1.643 | 32745.0 |
1121 | 2022-03-15 22:49:25 | spoor | 2 | 53800 | 84 | 1.423 | 37807.4 |
1120 | 2022-03-08 20:44:20 | spoor | 1 | 28756 | 8 | 0.516 | 55728.7 |
1119 | 2022-03-01 17:28:38 | spoor | 2 | 53800 | 84 | 1.893 | 28420.5 |
1118 | 2022-02-24 09:51:39 | spoor | 2 | 53800 | 84 | 1.576 | 34137.1 |
1117 | 2022-02-23 20:21:44 | spoor | 2 | 53800 | 84 | 2.156 | 24953.6 |
1116 | 2022-02-22 20:24:10 | spoor | 2 | 53800 | 84 | 1.406 | 38264.6 |
1115 | 2022-02-21 11:29:34 | spoor | 2 | 53800 | 84 | 1.966 | 27365.2 |
1114 | 2022-02-20 15:45:01 | spoor | 2 | 53800 | 84 | 1.406 | 38264.6 |
1113 | 2022-02-19 12:16:21 | spoor | 2 | 53800 | 84 | 1.423 | 37807.4 |
1112 | 2022-02-18 10:54:42 | spoor | 2 | 53800 | 84 | 1.533 | 35094.6 |
1111 | 2022-02-17 14:53:01 | spoor | 2 | 53800 | 84 | 1.483 | 36277.8 |
1110 | 2022-02-16 20:16:17 | spoor | 2 | 53800 | 84 | 1.906 | 28226.7 |
1109 | 2022-02-15 16:37:31 | spoor | 2 | 53800 | 84 | 1.360 | 39558.8 |
1108 | 2022-02-14 19:02:15 | spoor | 2 | 53800 | 84 | 1.373 | 39184.3 |
1107 | 2022-02-13 19:43:38 | spoor | 2 | 53800 | 84 | 1.673 | 32157.8 |
1106 | 2022-02-10 19:47:30 | spoor | 2 | 53800 | 84 | 1.610 | 33416.1 |
1105 | 2022-01-28 04:13:54 | spoor | 2 | 53800 | 84 | 1.360 | 39558.8 |
1104 | 2022-01-23 21:37:57 | spoor | 2 | 53800 | 84 | 1.373 | 39184.3 |
1103 | 2022-01-16 21:02:43 | spoor | 2 | 53800 | 84 | 1.753 | 30690.2 |
1102 | 2022-01-09 10:42:09 | spoor | 2 | 53800 | 84 | 1.593 | 33772.8 |