History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rows"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1460 | 2024-04-26 16:01:26 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1459 | 2024-04-08 15:43:05 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
| 1458 | 2024-04-02 20:44:36 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1457 | 2024-04-01 16:36:43 | rows | 1 | 13983 | 30 | 0.296 | 47239.9 |
| 1456 | 2024-03-30 23:16:53 | rows | 1 | 13983 | 30 | 0.800 | 17478.8 |
| 1455 | 2024-03-26 19:33:02 | rows | 1 | 13983 | 30 | 1.110 | 12597.3 |
| 1454 | 2024-03-11 23:30:13 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
| 1453 | 2024-03-03 20:40:21 | rows | 1 | 13983 | 30 | 0.546 | 25609.9 |
| 1452 | 2024-03-02 14:04:34 | rows | 1 | 13983 | 30 | 0.283 | 49409.9 |
| 1451 | 2024-02-29 22:51:54 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1450 | 2024-02-25 16:26:36 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1449 | 2024-01-28 16:47:47 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1448 | 2024-01-26 09:30:33 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1447 | 2024-01-17 08:04:16 | rows | 2 | 29872 | 476 | 0.750 | 39829.3 |
| 1446 | 2024-01-06 14:24:30 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1445 | 2024-01-03 16:18:42 | rows | 1 | 13983 | 30 | 0.500 | 27966.0 |
| 1444 | 2023-12-16 01:14:53 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1443 | 2023-11-28 03:11:34 | rows | 1 | 13983 | 30 | 0.406 | 34440.9 |
| 1442 | 2023-11-27 18:44:04 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
| 1441 | 2023-11-24 09:38:31 | rows | 2 | 29872 | 476 | 0.890 | 33564.0 |
| 1440 | 2023-11-24 02:08:16 | rows | 2 | 29872 | 476 | 0.966 | 30923.4 |
| 1439 | 2023-11-14 05:28:03 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1438 | 2023-11-09 18:13:23 | rows | 2 | 29872 | 476 | 0.890 | 33564.0 |
| 1437 | 2023-11-07 08:22:48 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1436 | 2023-11-03 17:56:02 | rows | 2 | 29872 | 476 | 0.783 | 38150.7 |
| 1435 | 2023-10-28 09:21:40 | rows | 2 | 29872 | 476 | 0.873 | 34217.6 |
| 1434 | 2023-10-27 19:26:50 | rows | 2 | 29872 | 476 | 0.923 | 32364.0 |
| 1433 | 2023-10-27 07:58:15 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1432 | 2023-10-19 20:27:40 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1431 | 2023-10-17 02:07:14 | rows | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1430 | 2023-10-12 05:52:06 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1429 | 2023-10-05 03:51:50 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1428 | 2023-10-02 17:55:18 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1427 | 2023-09-23 16:03:37 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1426 | 2023-09-14 06:40:54 | rows | 1 | 13983 | 30 | 0.280 | 49939.3 |
| 1425 | 2023-09-12 05:17:27 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1424 | 2023-08-05 18:46:26 | rows | 2 | 29872 | 476 | 0.766 | 38997.4 |
| 1423 | 2023-07-29 17:06:23 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1422 | 2023-05-31 11:50:48 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1421 | 2023-04-26 04:41:36 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
| 1420 | 2023-04-18 04:13:07 | rows | 2 | 29872 | 476 | 0.796 | 37527.6 |
| 1419 | 2023-02-18 01:11:06 | rows | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1418 | 2023-02-12 00:33:11 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1417 | 2023-01-24 10:51:45 | rows | 2 | 29872 | 476 | 0.750 | 39829.3 |
| 1416 | 2022-12-13 22:20:24 | rows | 1 | 13983 | 30 | 0.236 | 59250.0 |
| 1415 | 2022-11-05 00:11:54 | rows | 2 | 29872 | 476 | 1.750 | 17069.7 |
| 1414 | 2022-10-29 04:57:46 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1413 | 2022-09-19 18:32:43 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1412 | 2022-09-10 18:21:35 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1411 | 2022-08-19 14:02:46 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1410 | 2022-08-17 04:58:33 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1409 | 2022-08-14 18:28:36 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1408 | 2022-08-06 23:53:21 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1407 | 2022-07-30 01:24:52 | rows | 1 | 13983 | 30 | 0.236 | 59250.0 |
| 1406 | 2022-07-29 02:41:39 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1405 | 2022-07-28 23:25:08 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1404 | 2022-07-15 16:51:12 | rows | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1403 | 2022-07-10 09:59:38 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1402 | 2022-07-03 09:39:53 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1401 | 2022-07-02 19:27:33 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1400 | 2022-06-24 20:39:47 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1399 | 2022-06-16 09:37:55 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1398 | 2022-06-15 16:55:29 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1397 | 2022-05-04 16:16:35 | rows | 2 | 29872 | 476 | 0.873 | 34217.6 |
| 1396 | 2022-05-02 12:45:14 | rows | 2 | 29872 | 476 | 0.766 | 38997.4 |
| 1395 | 2022-04-03 16:34:49 | rows | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1394 | 2022-03-15 02:03:07 | rows | 1 | 13983 | 30 | 0.453 | 30867.5 |
| 1393 | 2022-01-07 10:44:08 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1392 | 2021-12-31 02:41:13 | rows | 2 | 29872 | 476 | 0.783 | 38150.7 |
| 1391 | 2021-12-08 01:13:18 | rows | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1390 | 2021-11-01 11:09:02 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
| 1389 | 2021-10-11 03:33:55 | rows | 2 | 29872 | 476 | 0.783 | 38150.7 |
| 1388 | 2021-09-20 23:00:55 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1387 | 2021-09-18 19:02:17 | rows | 1 | 13983 | 30 | 0.263 | 53167.3 |
| 1386 | 2021-09-07 05:05:59 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1385 | 2021-09-01 08:54:06 | rows | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1384 | 2021-07-25 06:02:41 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1383 | 2021-06-06 06:23:15 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1382 | 2021-06-03 01:42:23 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1381 | 2021-05-15 12:03:18 | rows | 1 | 13983 | 30 | 0.266 | 52567.7 |
| 1380 | 2021-04-14 16:45:15 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1379 | 2021-02-28 14:09:46 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1378 | 2021-02-12 02:30:10 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1377 | 2020-12-30 11:34:07 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1376 | 2020-12-29 05:39:10 | rows | 1 | 13983 | 30 | 0.216 | 64736.1 |
| 1375 | 2020-11-28 18:10:06 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1374 | 2020-10-21 20:35:38 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1373 | 2020-10-14 19:45:17 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1372 | 2020-10-04 12:05:46 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1371 | 2020-09-01 19:41:09 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1370 | 2020-08-31 23:36:38 | rows | 1 | 13983 | 30 | 0.296 | 47239.9 |
| 1369 | 2020-08-27 22:52:54 | rows | 2 | 29872 | 476 | 0.890 | 33564.0 |
| 1368 | 2020-08-27 08:13:18 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1367 | 2020-08-22 09:57:05 | rows | 1 | 13983 | 30 | 0.220 | 63559.1 |
| 1366 | 2020-08-07 07:32:27 | rows | 1 | 13983 | 30 | 0.236 | 59250.0 |
| 1365 | 2020-08-05 01:29:45 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1364 | 2020-08-01 06:49:13 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |
| 1363 | 2020-07-29 02:46:36 | rows | 1 | 13983 | 30 | 0.280 | 49939.3 |
| 1362 | 2020-07-28 00:12:22 | rows | 1 | 13983 | 30 | 0.250 | 55932.0 |
| 1361 | 2020-05-31 17:40:56 | rows | 1 | 13983 | 30 | 0.233 | 60012.9 |