History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pizzas"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1417 | 2024-05-07 17:51:17 | pizzas | 3 | 112716 | 301 | 12.013 | 9382.8 |
1416 | 2024-05-07 09:45:19 | pizzas | 2 | 82551 | 27 | 2.500 | 33020.4 |
1415 | 2024-05-07 09:45:03 | pizzas | 3 | 112716 | 301 | 5.860 | 19234.8 |
1414 | 2024-05-07 04:07:26 | pizzas | 2 | 82551 | 27 | 2.610 | 31628.7 |
1413 | 2024-05-05 22:00:15 | pizzas | 3 | 112716 | 301 | 5.903 | 19094.7 |
1412 | 2024-05-05 11:24:03 | pizzas | 3 | 112716 | 301 | 13.453 | 8378.5 |
1411 | 2024-05-05 09:16:37 | pizzas | 2 | 82551 | 27 | 3.813 | 21649.9 |
1410 | 2024-05-04 16:55:44 | pizzas | 2 | 82551 | 27 | 2.546 | 32423.8 |
1409 | 2024-05-02 19:02:58 | pizzas | 3 | 112716 | 301 | 6.860 | 16430.9 |
1408 | 2024-05-02 11:19:43 | pizzas | 2 | 82551 | 27 | 2.266 | 36430.3 |
1407 | 2024-05-02 11:16:15 | pizzas | 2 | 82551 | 27 | 2.390 | 34540.2 |
1406 | 2024-05-02 11:16:11 | pizzas | 1 | 48755 | 4 | 0.796 | 61250.0 |
1405 | 2024-05-02 11:15:54 | pizzas | 3 | 112716 | 301 | 5.516 | 20434.4 |
1404 | 2024-05-02 04:11:59 | pizzas | 3 | 112716 | 301 | 12.033 | 9367.2 |
1403 | 2024-04-28 07:51:14 | pizzas | 1 | 48755 | 4 | 0.860 | 56691.9 |
1402 | 2024-04-27 19:07:47 | pizzas | 2 | 82551 | 27 | 2.610 | 31628.7 |
1401 | 2024-04-27 15:57:35 | pizzas | 1 | 48755 | 4 | 0.966 | 50471.0 |
1400 | 2024-04-26 07:59:22 | pizzas | 1 | 48755 | 4 | 1.763 | 27654.6 |
1399 | 2024-04-20 09:22:54 | pizzas | 3 | 112716 | 301 | 7.813 | 14426.7 |
1398 | 2024-04-17 08:51:36 | pizzas | 1 | 48755 | 4 | 0.923 | 52822.3 |
1397 | 2024-04-06 13:23:23 | pizzas | 1 | 48755 | 4 | 3.376 | 14441.6 |
1396 | 2024-04-05 11:46:02 | pizzas | 2 | 82551 | 27 | 8.516 | 9693.6 |
1395 | 2024-04-03 19:29:10 | pizzas | 3 | 112716 | 301 | 13.500 | 8349.3 |
1394 | 2024-04-03 19:29:09 | pizzas | 2 | 82551 | 27 | 8.936 | 9238.0 |
1393 | 2024-03-10 00:59:59 | pizzas | 3 | 112716 | 301 | 17.186 | 6558.6 |
1392 | 2024-03-05 11:48:41 | pizzas | 3 | 112716 | 301 | 5.390 | 20912.1 |
1391 | 2024-03-01 16:46:06 | pizzas | 3 | 112716 | 301 | 12.080 | 9330.8 |
1390 | 2024-03-01 16:46:04 | pizzas | 2 | 82551 | 27 | 5.453 | 15138.6 |
1389 | 2024-02-28 11:22:41 | pizzas | 3 | 112716 | 301 | 6.030 | 18692.5 |
1388 | 2024-02-28 07:53:24 | pizzas | 2 | 82551 | 27 | 2.436 | 33887.9 |
1387 | 2024-02-28 04:42:06 | pizzas | 3 | 112716 | 301 | 14.673 | 7681.9 |
1386 | 2024-02-28 02:53:39 | pizzas | 2 | 82551 | 27 | 3.326 | 24819.9 |
1385 | 2024-02-26 16:12:45 | pizzas | 1 | 48755 | 4 | 1.936 | 25183.4 |
1384 | 2024-02-26 16:11:35 | pizzas | 3 | 112716 | 301 | 11.546 | 9762.3 |
1383 | 2024-02-26 16:11:34 | pizzas | 2 | 82551 | 27 | 5.703 | 14475.0 |
1382 | 2024-02-04 08:30:14 | pizzas | 3 | 112716 | 301 | 5.750 | 19602.8 |
1381 | 2024-02-04 05:30:43 | pizzas | 3 | 112716 | 301 | 4.643 | 24276.5 |
1380 | 2024-01-29 02:54:14 | pizzas | 2 | 82551 | 27 | 2.453 | 33653.1 |
1379 | 2024-01-29 02:53:38 | pizzas | 3 | 112716 | 301 | 4.906 | 22975.1 |
1378 | 2024-01-29 02:53:03 | pizzas | 2 | 82551 | 27 | 4.970 | 16609.9 |
1377 | 2024-01-29 02:52:47 | pizzas | 3 | 112716 | 301 | 5.436 | 20735.1 |
1376 | 2024-01-27 09:09:37 | pizzas | 2 | 82551 | 27 | 4.830 | 17091.3 |
1375 | 2024-01-27 09:09:33 | pizzas | 3 | 112716 | 301 | 5.470 | 20606.2 |
1374 | 2024-01-27 09:08:29 | pizzas | 1 | 48755 | 4 | 0.860 | 56691.9 |
1373 | 2024-01-19 07:48:59 | pizzas | 3 | 112716 | 301 | 5.250 | 21469.7 |
1372 | 2024-01-15 06:50:12 | pizzas | 3 | 112716 | 301 | 4.873 | 23130.7 |
1371 | 2024-01-01 05:13:46 | pizzas | 1 | 48755 | 4 | 0.750 | 65006.7 |
1370 | 2023-12-25 23:21:26 | pizzas | 1 | 48755 | 4 | 0.810 | 60191.4 |
1369 | 2023-12-25 19:30:05 | pizzas | 3 | 112716 | 301 | 4.623 | 24381.6 |
1368 | 2023-12-19 21:01:39 | pizzas | 2 | 82551 | 27 | 2.156 | 38289.0 |
1367 | 2023-12-13 03:06:36 | pizzas | 3 | 112716 | 301 | 5.500 | 20493.8 |
1366 | 2023-12-01 06:00:55 | pizzas | 2 | 82551 | 27 | 2.783 | 29662.6 |
1365 | 2023-11-29 18:41:06 | pizzas | 3 | 112716 | 301 | 5.093 | 22131.6 |
1364 | 2023-11-27 00:38:07 | pizzas | 3 | 112716 | 301 | 4.533 | 24865.7 |
1363 | 2023-11-10 00:42:14 | pizzas | 2 | 82551 | 27 | 3.093 | 26689.6 |
1362 | 2023-11-10 00:35:58 | pizzas | 3 | 112716 | 301 | 4.986 | 22606.5 |
1361 | 2023-11-10 00:22:07 | pizzas | 1 | 48755 | 4 | 0.890 | 54780.9 |
1360 | 2023-10-29 18:32:50 | pizzas | 3 | 112716 | 301 | 5.453 | 20670.5 |
1359 | 2023-10-27 03:25:12 | pizzas | 2 | 82551 | 27 | 5.690 | 14508.1 |
1358 | 2023-10-27 03:16:59 | pizzas | 1 | 48755 | 4 | 0.766 | 63648.8 |
1357 | 2023-10-26 03:27:01 | pizzas | 3 | 112716 | 301 | 5.856 | 19248.0 |
1356 | 2023-10-25 07:57:51 | pizzas | 3 | 112716 | 301 | 5.670 | 19879.4 |
1355 | 2023-10-23 07:19:12 | pizzas | 3 | 112716 | 301 | 5.343 | 21096.0 |
1354 | 2023-10-20 18:39:09 | pizzas | 1 | 48755 | 4 | 0.780 | 62506.4 |
1353 | 2023-10-20 18:37:30 | pizzas | 2 | 82551 | 27 | 5.610 | 14715.0 |
1352 | 2023-10-20 18:12:37 | pizzas | 3 | 112716 | 301 | 6.466 | 17432.1 |
1351 | 2023-10-20 10:05:15 | pizzas | 1 | 48755 | 4 | 0.843 | 57835.1 |
1350 | 2023-10-17 14:17:16 | pizzas | 3 | 112716 | 301 | 11.733 | 9606.8 |
1349 | 2023-10-17 14:13:51 | pizzas | 1 | 48755 | 4 | 1.906 | 25579.7 |
1348 | 2023-10-17 14:13:13 | pizzas | 2 | 82551 | 27 | 2.860 | 28864.0 |
1347 | 2023-10-13 12:04:30 | pizzas | 2 | 82551 | 27 | 2.280 | 36206.6 |
1346 | 2023-10-13 11:58:56 | pizzas | 1 | 48755 | 4 | 0.750 | 65006.7 |
1345 | 2023-10-11 09:52:21 | pizzas | 3 | 112716 | 301 | 5.580 | 20200.0 |
1344 | 2023-10-03 10:07:28 | pizzas | 1 | 48755 | 4 | 0.736 | 66243.2 |
1343 | 2023-10-03 10:06:22 | pizzas | 2 | 82551 | 27 | 2.673 | 30883.3 |
1342 | 2023-10-03 10:05:19 | pizzas | 3 | 112716 | 301 | 6.420 | 17557.0 |
1341 | 2023-09-28 12:43:00 | pizzas | 3 | 112716 | 301 | 4.843 | 23274.0 |
1340 | 2023-09-22 06:47:25 | pizzas | 2 | 82551 | 27 | 2.106 | 39198.0 |
1339 | 2023-09-21 08:27:14 | pizzas | 2 | 82551 | 27 | 2.466 | 33475.7 |
1338 | 2023-09-21 07:43:58 | pizzas | 3 | 112716 | 301 | 10.250 | 10996.7 |
1337 | 2023-09-21 00:34:41 | pizzas | 1 | 48755 | 4 | 0.876 | 55656.4 |
1336 | 2023-09-12 19:24:47 | pizzas | 2 | 82551 | 27 | 2.390 | 34540.2 |
1335 | 2023-09-10 13:17:52 | pizzas | 1 | 48755 | 4 | 0.826 | 59025.4 |
1334 | 2023-09-10 13:15:40 | pizzas | 3 | 112716 | 301 | 9.876 | 11413.1 |
1333 | 2023-08-20 18:27:01 | pizzas | 3 | 112716 | 301 | 4.516 | 24959.3 |
1332 | 2023-08-17 18:52:00 | pizzas | 3 | 112716 | 301 | 5.013 | 22484.7 |
1331 | 2023-08-16 09:29:51 | pizzas | 1 | 48755 | 4 | 0.733 | 66514.3 |
1330 | 2023-08-14 15:25:46 | pizzas | 3 | 112716 | 301 | 5.296 | 21283.2 |
1329 | 2023-08-01 21:15:47 | pizzas | 3 | 112716 | 301 | 5.046 | 22337.7 |
1328 | 2023-07-31 13:24:47 | pizzas | 1 | 48755 | 4 | 0.860 | 56691.9 |
1327 | 2023-07-30 20:52:52 | pizzas | 3 | 112716 | 301 | 4.783 | 23566.0 |
1326 | 2023-07-29 00:43:04 | pizzas | 3 | 112716 | 301 | 4.610 | 24450.3 |
1325 | 2023-07-27 05:37:01 | pizzas | 3 | 112716 | 301 | 5.000 | 22543.2 |
1324 | 2023-07-26 03:43:27 | pizzas | 3 | 112716 | 301 | 4.623 | 24381.6 |
1323 | 2023-07-25 10:31:28 | pizzas | 3 | 112716 | 301 | 4.813 | 23419.1 |
1322 | 2023-07-24 10:11:54 | pizzas | 3 | 112716 | 301 | 4.533 | 24865.7 |
1321 | 2023-07-22 15:36:51 | pizzas | 3 | 112716 | 301 | 5.173 | 21789.3 |
1320 | 2023-07-21 09:23:48 | pizzas | 3 | 112716 | 301 | 4.486 | 25126.2 |
1319 | 2023-07-20 06:15:20 | pizzas | 3 | 112716 | 301 | 4.530 | 24882.1 |
1318 | 2023-07-19 01:53:44 | pizzas | 3 | 112716 | 301 | 5.393 | 20900.4 |