History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"award"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1294 | 2024-05-10 08:07:30 | award | 1 | 28756 | 6 | 0.610 | 47141.0 |
1293 | 2024-05-01 21:50:48 | award | 2 | 53800 | 92 | 1.720 | 31279.1 |
1292 | 2024-05-01 06:30:29 | award | 2 | 53800 | 92 | 1.563 | 34421.0 |
1291 | 2024-05-01 06:30:01 | award | 3 | 83667 | 1022 | 6.530 | 12812.7 |
1290 | 2024-04-30 22:15:31 | award | 1 | 28756 | 6 | 0.466 | 61708.2 |
1289 | 2024-04-30 21:41:50 | award | 3 | 83667 | 1022 | 4.220 | 19826.3 |
1288 | 2024-04-29 23:02:37 | award | 1 | 28756 | 6 | 0.513 | 56054.6 |
1287 | 2024-04-28 02:54:56 | award | 1 | 28756 | 6 | 0.873 | 32939.3 |
1286 | 2024-04-25 02:10:19 | award | 1 | 28756 | 6 | 0.670 | 42919.4 |
1285 | 2024-04-23 19:59:57 | award | 1 | 28756 | 6 | 1.610 | 17860.9 |
1284 | 2024-04-11 11:32:33 | award | 1 | 28756 | 6 | 0.513 | 56054.6 |
1283 | 2024-04-04 19:47:38 | award | 3 | 83667 | 1022 | 14.736 | 5677.7 |
1282 | 2024-04-03 15:34:55 | award | 3 | 83667 | 1022 | 12.720 | 6577.6 |
1281 | 2024-04-03 15:34:55 | award | 2 | 53800 | 92 | 2.530 | 21264.8 |
1280 | 2024-04-03 15:34:48 | award | 1 | 28756 | 6 | 0.593 | 48492.4 |
1279 | 2024-04-03 15:34:41 | award | 3 | 83667 | 1022 | 4.876 | 17158.9 |
1278 | 2024-04-03 15:34:42 | award | 2 | 53800 | 92 | 2.970 | 18114.5 |
1277 | 2024-04-03 15:34:37 | award | 1 | 28756 | 6 | 1.140 | 25224.6 |
1276 | 2024-04-02 15:09:02 | award | 2 | 53800 | 92 | 1.423 | 37807.4 |
1275 | 2024-03-31 15:07:26 | award | 1 | 28756 | 6 | 0.470 | 61183.0 |
1274 | 2024-03-29 08:40:48 | award | 1 | 28756 | 6 | 1.080 | 26625.9 |
1273 | 2024-03-28 19:51:53 | award | 1 | 28756 | 6 | 1.653 | 17396.2 |
1272 | 2024-03-05 12:52:46 | award | 3 | 83667 | 1022 | 4.923 | 16995.1 |
1271 | 2024-03-04 09:41:32 | award | 3 | 83667 | 1022 | 6.720 | 12450.4 |
1270 | 2024-03-04 09:41:34 | award | 2 | 53800 | 92 | 5.360 | 10037.3 |
1269 | 2024-03-04 06:39:10 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1268 | 2024-03-01 12:22:31 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1267 | 2024-03-01 10:32:34 | award | 1 | 28756 | 6 | 1.156 | 24875.4 |
1266 | 2024-02-28 07:24:25 | award | 2 | 53800 | 92 | 2.173 | 24758.4 |
1265 | 2024-02-28 05:20:22 | award | 3 | 83667 | 1022 | 16.343 | 5119.4 |
1264 | 2024-02-28 02:38:15 | award | 3 | 83667 | 1022 | 6.546 | 12781.4 |
1263 | 2024-02-28 02:38:13 | award | 2 | 53800 | 92 | 3.313 | 16239.1 |
1262 | 2024-02-28 02:37:26 | award | 1 | 28756 | 6 | 1.123 | 25606.4 |
1261 | 2024-02-13 16:10:19 | award | 3 | 83667 | 1022 | 6.170 | 13560.3 |
1260 | 2024-02-13 05:06:01 | award | 3 | 83667 | 1022 | 3.470 | 24111.5 |
1259 | 2024-02-06 23:56:36 | award | 1 | 28756 | 6 | 0.546 | 52666.7 |
1258 | 2024-02-06 11:56:49 | award | 1 | 28756 | 6 | 0.500 | 57512.0 |
1257 | 2024-02-03 04:40:40 | award | 1 | 28756 | 6 | 0.516 | 55728.7 |
1256 | 2024-02-03 03:47:19 | award | 1 | 28756 | 6 | 0.530 | 54256.6 |
1255 | 2024-01-29 08:04:31 | award | 1 | 28756 | 6 | 0.483 | 59536.2 |
1254 | 2024-01-29 00:23:56 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1253 | 2024-01-28 22:55:01 | award | 1 | 28756 | 6 | 0.483 | 59536.2 |
1252 | 2023-12-24 11:09:29 | award | 3 | 83667 | 1022 | 3.593 | 23286.1 |
1251 | 2023-12-24 11:09:31 | award | 2 | 53800 | 92 | 1.576 | 34137.1 |
1250 | 2023-12-18 09:28:08 | award | 3 | 83667 | 1022 | 8.783 | 9526.0 |
1249 | 2023-12-18 09:28:09 | award | 2 | 53800 | 92 | 3.576 | 15044.7 |
1248 | 2023-12-05 23:38:51 | award | 2 | 53800 | 92 | 1.670 | 32215.6 |
1247 | 2023-12-03 14:29:20 | award | 1 | 28756 | 6 | 0.533 | 53951.2 |
1246 | 2023-12-03 14:29:19 | award | 1 | 28756 | 6 | 0.516 | 55728.7 |
1245 | 2023-11-24 20:36:52 | award | 1 | 28756 | 6 | 0.483 | 59536.2 |
1244 | 2023-11-12 21:59:41 | award | 1 | 28756 | 6 | 0.500 | 57512.0 |
1243 | 2023-11-11 22:12:40 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1242 | 2023-11-03 05:39:19 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1241 | 2023-10-22 17:24:46 | award | 1 | 28756 | 6 | 0.470 | 61183.0 |
1240 | 2023-10-20 06:31:06 | award | 1 | 28756 | 6 | 0.500 | 57512.0 |
1239 | 2023-10-17 17:10:07 | award | 1 | 28756 | 6 | 0.516 | 55728.7 |
1238 | 2023-10-13 14:30:21 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1237 | 2023-09-23 22:21:23 | award | 1 | 28756 | 6 | 0.500 | 57512.0 |
1236 | 2023-09-12 18:19:01 | award | 1 | 28756 | 6 | 0.530 | 54256.6 |
1235 | 2023-09-10 06:47:49 | award | 1 | 28756 | 6 | 0.500 | 57512.0 |
1234 | 2023-09-03 05:42:45 | award | 2 | 53800 | 92 | 1.576 | 34137.1 |
1233 | 2023-08-10 12:36:57 | award | 3 | 83667 | 1022 | 3.423 | 24442.6 |
1232 | 2023-07-17 07:01:34 | award | 1 | 28756 | 6 | 0.456 | 63061.4 |
1231 | 2023-07-12 02:01:17 | award | 3 | 83667 | 1022 | 3.750 | 22311.2 |
1230 | 2023-07-08 12:50:41 | award | 1 | 28756 | 6 | 0.593 | 48492.4 |
1229 | 2023-06-17 12:47:41 | award | 1 | 28756 | 6 | 0.483 | 59536.2 |
1228 | 2023-04-09 13:58:36 | award | 1 | 28756 | 6 | 0.486 | 59168.7 |
1227 | 2023-04-03 11:43:12 | award | 1 | 28756 | 6 | 0.436 | 65954.1 |
1226 | 2023-03-31 14:04:02 | award | 3 | 83667 | 1022 | 3.596 | 23266.7 |
1225 | 2023-03-26 21:14:51 | award | 1 | 28756 | 6 | 0.513 | 56054.6 |
1224 | 2023-01-17 08:46:49 | award | 1 | 28756 | 6 | 0.466 | 61708.2 |
1223 | 2023-01-04 08:48:10 | award | 1 | 28756 | 6 | 0.436 | 65954.1 |
1222 | 2022-12-22 06:40:23 | award | 2 | 53800 | 92 | 1.610 | 33416.1 |
1221 | 2022-11-13 22:05:39 | award | 1 | 28756 | 6 | 0.500 | 57512.0 |
1220 | 2022-09-17 03:15:51 | award | 1 | 28756 | 6 | 0.513 | 56054.6 |
1219 | 2022-09-11 21:44:05 | award | 1 | 28756 | 6 | 0.450 | 63902.2 |
1218 | 2022-09-03 14:13:37 | award | 1 | 28756 | 6 | 0.440 | 65354.5 |
1217 | 2022-09-01 21:51:45 | award | 1 | 28756 | 6 | 0.530 | 54256.6 |
1216 | 2022-08-25 23:37:18 | award | 1 | 28756 | 6 | 0.456 | 63061.4 |
1215 | 2022-08-19 18:05:01 | award | 2 | 53800 | 92 | 1.390 | 38705.0 |
1214 | 2022-08-14 01:28:47 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1213 | 2022-08-06 16:38:26 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1212 | 2022-07-29 21:44:51 | award | 1 | 28756 | 6 | 0.483 | 59536.2 |
1211 | 2022-07-04 04:43:56 | award | 1 | 28756 | 6 | 0.440 | 65354.5 |
1210 | 2022-07-03 04:59:43 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1209 | 2022-07-01 23:22:58 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1208 | 2022-06-16 05:06:24 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1207 | 2022-06-15 15:38:46 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1206 | 2022-05-28 11:16:48 | award | 1 | 28756 | 6 | 0.440 | 65354.5 |
1205 | 2022-03-20 05:21:33 | award | 1 | 28756 | 6 | 0.500 | 57512.0 |
1204 | 2022-03-04 17:12:04 | award | 1 | 28756 | 6 | 0.483 | 59536.2 |
1203 | 2022-03-02 14:15:31 | award | 1 | 28756 | 6 | 0.563 | 51076.4 |
1202 | 2022-02-20 12:17:26 | award | 1 | 28756 | 6 | 0.516 | 55728.7 |
1201 | 2022-01-20 13:17:14 | award | 3 | 83667 | 1022 | 3.673 | 22778.9 |
1200 | 2022-01-02 22:13:31 | award | 3 | 83667 | 1022 | 3.860 | 21675.4 |
1199 | 2022-01-01 19:27:46 | award | 3 | 83667 | 1022 | 3.843 | 21771.3 |
1198 | 2021-12-17 08:00:05 | award | 1 | 28756 | 6 | 0.530 | 54256.6 |
1197 | 2021-12-15 06:15:32 | award | 1 | 28756 | 6 | 0.486 | 59168.7 |
1196 | 2021-12-09 08:06:36 | award | 3 | 83667 | 1022 | 3.326 | 25155.4 |
1195 | 2021-11-19 10:27:55 | award | 3 | 83667 | 1022 | 4.110 | 20356.9 |