History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"event"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1327 | 2024-05-04 08:46:35 | event | 1 | 28756 | 6 | 0.516 | 55728.7 |
1326 | 2024-04-30 21:11:47 | event | 1 | 28756 | 6 | 0.500 | 57512.0 |
1325 | 2024-04-29 17:32:37 | event | 1 | 28756 | 6 | 0.546 | 52666.7 |
1324 | 2024-04-27 11:14:53 | event | 1 | 28756 | 6 | 1.296 | 22188.3 |
1323 | 2024-04-26 23:49:19 | event | 1 | 28756 | 6 | 0.516 | 55728.7 |
1322 | 2024-04-15 03:47:12 | event | 3 | 83667 | 887 | 6.393 | 13087.3 |
1321 | 2024-04-04 07:31:31 | event | 2 | 53800 | 87 | 1.716 | 31352.0 |
1320 | 2024-04-02 22:19:41 | event | 3 | 83667 | 887 | 6.750 | 12395.1 |
1319 | 2024-04-02 22:19:41 | event | 2 | 53800 | 87 | 5.686 | 9461.8 |
1318 | 2024-04-02 21:40:02 | event | 1 | 28756 | 6 | 0.530 | 54256.6 |
1317 | 2024-03-31 09:02:34 | event | 3 | 83667 | 887 | 11.390 | 7345.7 |
1316 | 2024-03-31 07:15:04 | event | 2 | 53800 | 87 | 4.970 | 10824.9 |
1315 | 2024-03-31 07:08:54 | event | 1 | 28756 | 6 | 1.686 | 17055.8 |
1314 | 2024-03-30 20:07:31 | event | 3 | 83667 | 887 | 10.656 | 7851.6 |
1313 | 2024-03-29 20:42:51 | event | 2 | 53800 | 87 | 1.766 | 30464.3 |
1312 | 2024-03-29 20:42:18 | event | 3 | 83667 | 887 | 5.283 | 15837.0 |
1311 | 2024-03-29 11:49:34 | event | 1 | 28756 | 6 | 0.986 | 29164.3 |
1310 | 2024-03-29 11:47:38 | event | 3 | 83667 | 887 | 13.576 | 6162.9 |
1309 | 2024-03-29 11:47:39 | event | 2 | 53800 | 87 | 3.703 | 14528.8 |
1308 | 2024-03-29 11:47:14 | event | 1 | 28756 | 6 | 0.873 | 32939.3 |
1307 | 2024-03-04 16:06:27 | event | 1 | 28756 | 6 | 0.453 | 63479.0 |
1306 | 2024-03-01 02:30:54 | event | 1 | 28756 | 6 | 1.283 | 22413.1 |
1305 | 2024-02-29 18:30:41 | event | 2 | 53800 | 87 | 1.843 | 29191.5 |
1304 | 2024-02-29 18:30:04 | event | 3 | 83667 | 887 | 3.966 | 21096.1 |
1303 | 2024-02-28 10:00:04 | event | 3 | 83667 | 887 | 4.783 | 17492.6 |
1302 | 2024-02-28 10:00:05 | event | 2 | 53800 | 87 | 3.660 | 14699.5 |
1301 | 2024-02-28 08:00:13 | event | 1 | 28756 | 6 | 1.610 | 17860.9 |
1300 | 2024-02-02 18:51:15 | event | 1 | 28756 | 6 | 0.533 | 53951.2 |
1299 | 2024-01-31 16:23:24 | event | 2 | 53800 | 87 | 1.673 | 32157.8 |
1298 | 2024-01-31 16:23:04 | event | 3 | 83667 | 887 | 3.750 | 22311.2 |
1297 | 2024-01-29 07:36:45 | event | 1 | 28756 | 6 | 0.423 | 67981.1 |
1296 | 2024-01-28 22:39:31 | event | 2 | 53800 | 87 | 1.516 | 35488.1 |
1295 | 2024-01-28 22:38:55 | event | 3 | 83667 | 887 | 8.143 | 10274.7 |
1294 | 2024-01-27 14:20:15 | event | 3 | 83667 | 887 | 4.143 | 20194.8 |
1293 | 2024-01-26 17:24:54 | event | 3 | 83667 | 887 | 4.173 | 20049.6 |
1292 | 2024-01-24 01:26:28 | event | 1 | 28756 | 6 | 0.500 | 57512.0 |
1291 | 2024-01-13 16:54:17 | event | 3 | 83667 | 887 | 3.296 | 25384.4 |
1290 | 2023-12-30 18:04:08 | event | 2 | 53800 | 87 | 1.580 | 34050.6 |
1289 | 2023-12-20 05:09:02 | event | 3 | 83667 | 887 | 3.796 | 22040.8 |
1288 | 2023-12-20 05:09:00 | event | 2 | 53800 | 87 | 2.830 | 19010.6 |
1287 | 2023-12-17 20:42:28 | event | 1 | 28756 | 6 | 0.500 | 57512.0 |
1286 | 2023-12-11 07:08:11 | event | 1 | 28756 | 6 | 0.486 | 59168.7 |
1285 | 2023-12-06 15:14:09 | event | 3 | 83667 | 887 | 3.360 | 24900.9 |
1284 | 2023-12-03 11:33:02 | event | 3 | 83667 | 887 | 3.266 | 25617.6 |
1283 | 2023-12-03 11:32:54 | event | 2 | 53800 | 87 | 1.360 | 39558.8 |
1282 | 2023-11-22 01:09:44 | event | 3 | 83667 | 887 | 3.453 | 24230.2 |
1281 | 2023-11-18 15:42:54 | event | 1 | 28756 | 6 | 0.483 | 59536.2 |
1280 | 2023-11-11 22:35:22 | event | 1 | 28756 | 6 | 0.500 | 57512.0 |
1279 | 2023-10-30 17:03:34 | event | 1 | 28756 | 6 | 0.483 | 59536.2 |
1278 | 2023-10-26 09:06:12 | event | 3 | 83667 | 887 | 6.216 | 13459.9 |
1277 | 2023-10-25 15:11:32 | event | 3 | 83667 | 887 | 5.656 | 14792.6 |
1276 | 2023-10-22 08:06:44 | event | 3 | 83667 | 887 | 3.843 | 21771.3 |
1275 | 2023-10-22 07:11:01 | event | 1 | 28756 | 6 | 0.420 | 68466.7 |
1274 | 2023-10-19 08:11:08 | event | 1 | 28756 | 6 | 0.486 | 59168.7 |
1273 | 2023-10-13 10:19:50 | event | 1 | 28756 | 6 | 0.436 | 65954.1 |
1272 | 2023-10-11 17:05:39 | event | 3 | 83667 | 887 | 4.376 | 19119.5 |
1271 | 2023-10-09 23:10:32 | event | 3 | 83667 | 887 | 3.423 | 24442.6 |
1270 | 2023-10-09 06:52:48 | event | 1 | 28756 | 6 | 0.436 | 65954.1 |
1269 | 2023-10-05 16:24:54 | event | 1 | 28756 | 6 | 0.440 | 65354.5 |
1268 | 2023-09-27 08:53:47 | event | 1 | 28756 | 6 | 0.453 | 63479.0 |
1267 | 2023-09-26 08:49:33 | event | 1 | 28756 | 6 | 0.483 | 59536.2 |
1266 | 2023-09-25 15:37:51 | event | 1 | 28756 | 6 | 0.436 | 65954.1 |
1265 | 2023-09-25 00:56:59 | event | 1 | 28756 | 6 | 0.470 | 61183.0 |
1264 | 2023-08-01 19:10:19 | event | 3 | 83667 | 887 | 3.576 | 23396.8 |
1263 | 2023-07-21 03:39:10 | event | 1 | 28756 | 6 | 0.453 | 63479.0 |
1262 | 2023-07-03 05:03:25 | event | 1 | 28756 | 6 | 0.483 | 59536.2 |
1261 | 2023-04-21 04:54:14 | event | 1 | 28756 | 6 | 0.436 | 65954.1 |
1260 | 2023-04-12 11:59:15 | event | 3 | 83667 | 887 | 3.483 | 24021.5 |
1259 | 2023-03-26 18:05:27 | event | 1 | 28756 | 6 | 0.486 | 59168.7 |
1258 | 2023-02-10 02:56:26 | event | 1 | 28756 | 6 | 0.420 | 68466.7 |
1257 | 2023-01-24 21:24:04 | event | 3 | 83667 | 887 | 3.220 | 25983.5 |
1256 | 2023-01-17 04:26:09 | event | 3 | 83667 | 887 | 3.263 | 25641.1 |
1255 | 2022-12-18 03:00:56 | event | 1 | 28756 | 6 | 0.470 | 61183.0 |
1254 | 2022-12-07 21:27:39 | event | 1 | 28756 | 6 | 0.440 | 65354.5 |
1253 | 2022-12-06 08:49:06 | event | 3 | 83667 | 887 | 4.000 | 20916.8 |
1252 | 2022-12-05 19:55:41 | event | 3 | 83667 | 887 | 4.546 | 18404.5 |
1251 | 2022-10-28 00:41:06 | event | 3 | 83667 | 887 | 3.546 | 23594.8 |
1250 | 2022-10-03 00:29:28 | event | 1 | 28756 | 6 | 0.436 | 65954.1 |
1249 | 2022-09-07 09:31:09 | event | 1 | 28756 | 6 | 0.420 | 68466.7 |
1248 | 2022-08-15 17:01:13 | event | 3 | 83667 | 887 | 3.233 | 25879.1 |
1247 | 2022-08-15 04:54:12 | event | 1 | 28756 | 6 | 0.436 | 65954.1 |
1246 | 2022-08-04 15:47:06 | event | 1 | 28756 | 6 | 0.436 | 65954.1 |
1245 | 2022-07-29 12:15:19 | event | 1 | 28756 | 6 | 0.436 | 65954.1 |
1244 | 2022-07-18 23:58:01 | event | 3 | 83667 | 887 | 3.483 | 24021.5 |
1243 | 2022-07-15 04:57:05 | event | 2 | 53800 | 87 | 1.373 | 39184.3 |
1242 | 2022-07-09 18:39:14 | event | 3 | 83667 | 887 | 3.486 | 24000.9 |
1241 | 2022-07-01 15:16:21 | event | 3 | 83667 | 887 | 3.313 | 25254.2 |
1240 | 2022-06-26 14:37:22 | event | 3 | 83667 | 887 | 3.266 | 25617.6 |
1239 | 2022-05-30 01:01:22 | event | 3 | 83667 | 887 | 3.283 | 25484.9 |
1238 | 2022-05-29 08:50:09 | event | 1 | 28756 | 6 | 0.436 | 65954.1 |
1237 | 2022-05-18 15:46:58 | event | 1 | 28756 | 6 | 0.500 | 57512.0 |
1236 | 2022-03-25 11:02:19 | event | 1 | 28756 | 6 | 0.623 | 46157.3 |
1235 | 2022-02-18 04:15:35 | event | 1 | 28756 | 6 | 0.530 | 54256.6 |
1234 | 2022-01-02 12:24:25 | event | 3 | 83667 | 887 | 3.843 | 21771.3 |
1233 | 2022-01-02 11:53:10 | event | 1 | 28756 | 6 | 0.516 | 55728.7 |
1232 | 2022-01-01 14:03:02 | event | 3 | 83667 | 887 | 3.923 | 21327.3 |
1231 | 2021-12-31 09:25:27 | event | 1 | 28756 | 6 | 0.483 | 59536.2 |
1230 | 2021-12-24 00:17:43 | event | 3 | 83667 | 887 | 4.093 | 20441.5 |
1229 | 2021-12-24 00:01:53 | event | 3 | 83667 | 887 | 3.983 | 21006.0 |
1228 | 2021-12-23 11:35:24 | event | 3 | 83667 | 887 | 3.923 | 21327.3 |