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 |
1400 | 2024-12-28 01:52:39 | award | 3 | 83667 | 1022 | 21.953 | 3811.2 |
1399 | 2024-12-28 01:32:57 | award | 3 | 83667 | 1022 | 22.453 | 3726.3 |
1398 | 2024-12-28 01:32:52 | award | 2 | 53800 | 92 | 8.593 | 6260.9 |
1397 | 2024-12-28 01:23:34 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1396 | 2024-12-24 10:13:49 | award | 3 | 83667 | 1022 | 15.846 | 5280.0 |
1395 | 2024-12-14 04:35:48 | award | 2 | 53800 | 92 | 12.160 | 4424.3 |
1394 | 2024-12-11 23:27:25 | award | 3 | 83667 | 1022 | 19.063 | 4389.0 |
1393 | 2024-12-10 00:04:08 | award | 1 | 28756 | 6 | 2.856 | 10068.6 |
1392 | 2024-12-04 02:18:00 | award | 2 | 53800 | 92 | 7.750 | 6941.9 |
1391 | 2024-12-04 02:16:38 | award | 1 | 28756 | 6 | 2.376 | 12102.7 |
1390 | 2024-12-04 01:32:03 | award | 3 | 83667 | 1022 | 21.360 | 3917.0 |
1389 | 2024-12-03 16:17:50 | award | 3 | 83667 | 1022 | 31.023 | 2696.9 |
1388 | 2024-12-03 10:58:14 | award | 3 | 83667 | 1022 | 15.580 | 5370.2 |
1387 | 2024-11-28 11:02:58 | award | 2 | 53800 | 92 | 3.970 | 13551.6 |
1386 | 2024-11-27 18:15:54 | award | 3 | 83667 | 1022 | 23.736 | 3524.9 |
1385 | 2024-11-27 17:20:00 | award | 2 | 53800 | 92 | 5.466 | 9842.7 |
1384 | 2024-11-27 16:04:27 | award | 3 | 83667 | 1022 | 18.326 | 4565.5 |
1383 | 2024-11-27 16:04:27 | award | 2 | 53800 | 92 | 12.060 | 4461.0 |
1382 | 2024-11-27 15:06:29 | award | 1 | 28756 | 6 | 0.500 | 57512.0 |
1381 | 2024-11-26 05:31:07 | award | 1 | 28756 | 6 | 2.373 | 12118.0 |
1380 | 2024-11-14 13:03:14 | award | 3 | 83667 | 1022 | 29.436 | 2842.3 |
1379 | 2024-11-09 20:04:14 | award | 1 | 28756 | 6 | 1.500 | 19170.7 |
1378 | 2024-11-03 20:38:49 | award | 3 | 83667 | 1022 | 54.236 | 1542.6 |
1377 | 2024-11-03 20:34:42 | award | 2 | 53800 | 92 | 8.326 | 6461.7 |
1376 | 2024-11-03 20:21:25 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1375 | 2024-11-03 12:53:38 | award | 3 | 83667 | 1022 | 20.440 | 4093.3 |
1374 | 2024-10-28 17:40:45 | award | 2 | 53800 | 92 | 8.563 | 6282.8 |
1373 | 2024-10-28 17:16:59 | award | 3 | 83667 | 1022 | 20.376 | 4106.2 |
1372 | 2024-10-28 07:48:40 | award | 3 | 83667 | 1022 | 13.873 | 6030.9 |
1371 | 2024-10-28 07:48:39 | award | 2 | 53800 | 92 | 6.376 | 8437.9 |
1370 | 2024-10-28 07:34:36 | award | 1 | 28756 | 6 | 0.436 | 65954.1 |
1369 | 2024-10-27 04:42:30 | award | 1 | 28756 | 6 | 1.403 | 20496.1 |
1368 | 2024-10-21 21:15:44 | award | 3 | 83667 | 1022 | 15.733 | 5317.9 |
1367 | 2024-10-21 21:10:12 | award | 1 | 28756 | 6 | 2.353 | 12221.0 |
1366 | 2024-10-10 16:55:14 | award | 1 | 28756 | 6 | 1.046 | 27491.4 |
1365 | 2024-10-07 22:14:24 | award | 1 | 28756 | 6 | 1.920 | 14977.1 |
1364 | 2024-10-06 09:28:09 | award | 2 | 53800 | 92 | 13.050 | 4122.6 |
1363 | 2024-10-04 08:56:35 | award | 2 | 53800 | 92 | 12.076 | 4455.1 |
1362 | 2024-10-04 08:56:18 | award | 1 | 28756 | 6 | 1.626 | 17685.1 |
1361 | 2024-10-04 08:12:35 | award | 3 | 83667 | 1022 | 33.156 | 2523.4 |
1360 | 2024-10-03 23:34:05 | award | 3 | 83667 | 1022 | 31.033 | 2696.1 |
1359 | 2024-09-28 15:16:15 | award | 3 | 83667 | 1022 | 28.846 | 2900.5 |
1358 | 2024-09-28 10:47:58 | award | 2 | 53800 | 92 | 11.986 | 4488.6 |
1357 | 2024-09-28 06:13:33 | award | 3 | 83667 | 1022 | 15.503 | 5396.8 |
1356 | 2024-09-28 06:13:33 | award | 2 | 53800 | 92 | 12.596 | 4271.2 |
1355 | 2024-09-28 05:34:37 | award | 1 | 28756 | 6 | 0.470 | 61183.0 |
1354 | 2024-09-27 01:59:05 | award | 1 | 28756 | 6 | 1.860 | 15460.2 |
1353 | 2024-09-21 07:45:26 | award | 3 | 83667 | 1022 | 26.080 | 3208.1 |
1352 | 2024-09-09 03:53:27 | award | 1 | 28756 | 6 | 3.890 | 7392.3 |
1351 | 2024-09-03 05:33:47 | award | 3 | 83667 | 1022 | 27.723 | 3018.0 |
1350 | 2024-09-02 07:37:44 | award | 2 | 53800 | 92 | 11.860 | 4536.3 |
1349 | 2024-08-31 19:20:21 | award | 2 | 53800 | 92 | 15.676 | 3432.0 |
1348 | 2024-08-31 19:20:17 | award | 1 | 28756 | 6 | 3.970 | 7243.3 |
1347 | 2024-08-30 01:44:43 | award | 1 | 28756 | 6 | 5.796 | 4961.4 |
1346 | 2024-08-30 01:34:48 | award | 3 | 83667 | 1022 | 48.236 | 1734.5 |
1345 | 2024-08-30 01:30:33 | award | 3 | 83667 | 1022 | 32.096 | 2606.8 |
1344 | 2024-08-29 08:33:00 | award | 2 | 53800 | 92 | 9.170 | 5867.0 |
1343 | 2024-08-29 08:15:43 | award | 3 | 83667 | 1022 | 42.033 | 1990.5 |
1342 | 2024-08-29 04:44:40 | award | 3 | 83667 | 1022 | 40.176 | 2082.5 |
1341 | 2024-08-29 04:44:34 | award | 2 | 53800 | 92 | 17.490 | 3076.0 |
1340 | 2024-08-29 04:27:38 | award | 1 | 28756 | 6 | 0.453 | 63479.0 |
1339 | 2024-08-10 14:38:51 | award | 1 | 28756 | 6 | 1.736 | 16564.5 |
1338 | 2024-08-08 17:16:39 | award | 1 | 28756 | 6 | 2.796 | 10284.7 |
1337 | 2024-08-05 16:59:31 | award | 1 | 28756 | 6 | 1.063 | 27051.7 |
1336 | 2024-07-31 01:51:38 | award | 1 | 28756 | 6 | 2.736 | 10510.2 |
1335 | 2024-07-30 18:30:45 | award | 3 | 83667 | 1022 | 23.173 | 3610.5 |
1334 | 2024-07-30 18:30:47 | award | 2 | 53800 | 92 | 8.593 | 6260.9 |
1333 | 2024-07-30 18:27:41 | award | 1 | 28756 | 6 | 1.420 | 20250.7 |
1332 | 2024-07-29 23:10:29 | award | 1 | 28756 | 6 | 0.486 | 59168.7 |
1331 | 2024-07-29 04:14:08 | award | 2 | 53800 | 92 | 7.923 | 6790.4 |
1330 | 2024-07-28 17:27:05 | award | 2 | 53800 | 92 | 6.843 | 7862.0 |
1329 | 2024-07-28 07:49:05 | award | 3 | 83667 | 1022 | 21.673 | 3860.4 |
1328 | 2024-07-28 03:31:20 | award | 3 | 83667 | 1022 | 19.530 | 4284.0 |
1327 | 2024-07-27 13:50:16 | award | 1 | 28756 | 6 | 1.720 | 16718.6 |
1326 | 2024-07-27 13:40:29 | award | 2 | 53800 | 92 | 7.483 | 7189.6 |
1325 | 2024-07-27 13:38:47 | award | 3 | 83667 | 1022 | 6.236 | 13416.8 |
1324 | 2024-07-26 21:24:49 | award | 3 | 83667 | 1022 | 9.800 | 8537.4 |
1323 | 2024-07-11 15:21:56 | award | 1 | 28756 | 6 | 0.966 | 29768.1 |
1322 | 2024-07-10 09:05:12 | award | 1 | 28756 | 6 | 2.453 | 11722.8 |
1321 | 2024-07-06 01:43:39 | award | 1 | 28756 | 6 | 1.920 | 14977.1 |
1320 | 2024-07-06 01:42:10 | award | 1 | 28756 | 6 | 1.530 | 18794.8 |
1319 | 2024-07-02 21:48:31 | award | 2 | 53800 | 92 | 8.483 | 6342.1 |
1318 | 2024-07-02 17:46:13 | award | 2 | 53800 | 92 | 6.016 | 8942.8 |
1317 | 2024-06-30 19:19:14 | award | 3 | 83667 | 1022 | 18.140 | 4612.3 |
1316 | 2024-06-30 15:49:16 | award | 2 | 53800 | 92 | 7.720 | 6968.9 |
1315 | 2024-06-30 15:46:41 | award | 1 | 28756 | 6 | 2.140 | 13437.4 |
1314 | 2024-06-30 11:30:34 | award | 3 | 83667 | 1022 | 9.860 | 8485.5 |
1313 | 2024-06-30 10:39:33 | award | 3 | 83667 | 1022 | 7.563 | 11062.7 |
1312 | 2024-06-30 04:33:01 | award | 1 | 28756 | 6 | 1.313 | 21901.0 |
1311 | 2024-06-29 17:26:57 | award | 1 | 28756 | 6 | 2.766 | 10396.2 |
1310 | 2024-06-28 07:14:45 | award | 2 | 53800 | 92 | 8.940 | 6017.9 |
1309 | 2024-06-28 04:27:36 | award | 2 | 53800 | 92 | 8.846 | 6081.8 |
1308 | 2024-06-28 04:26:28 | award | 3 | 83667 | 1022 | 7.766 | 10773.5 |
1307 | 2024-06-28 03:23:15 | award | 3 | 83667 | 1022 | 22.736 | 3679.9 |
1306 | 2024-06-27 13:38:54 | award | 3 | 83667 | 1022 | 15.393 | 5435.4 |
1305 | 2024-06-27 13:38:50 | award | 2 | 53800 | 92 | 3.686 | 14595.8 |
1304 | 2024-06-27 13:38:35 | award | 1 | 28756 | 6 | 2.106 | 13654.3 |
1303 | 2024-06-14 00:42:55 | award | 1 | 28756 | 6 | 1.670 | 17219.2 |
1302 | 2024-06-03 06:41:09 | award | 1 | 28756 | 6 | 1.080 | 26625.9 |
1301 | 2024-05-31 04:32:56 | award | 1 | 28756 | 6 | 0.546 | 52666.7 |