History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aphids"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 493 | 2024-04-03 16:52:54 | aphids | 1 | 48755 | 4 | 2.936 | 16605.9 |
| 492 | 2024-04-03 06:33:45 | aphids | 1 | 48755 | 4 | 3.186 | 15302.9 |
| 491 | 2024-03-31 14:07:10 | aphids | 3 | 112716 | 448 | 11.656 | 9670.2 |
| 490 | 2024-03-31 12:09:41 | aphids | 3 | 112716 | 448 | 18.203 | 6192.2 |
| 489 | 2024-03-31 10:07:53 | aphids | 3 | 112716 | 448 | 18.923 | 5956.6 |
| 488 | 2024-03-31 10:07:53 | aphids | 2 | 82551 | 23 | 5.890 | 14015.4 |
| 487 | 2024-03-31 08:28:13 | aphids | 1 | 48755 | 4 | 0.906 | 53813.5 |
| 486 | 2024-03-28 00:42:34 | aphids | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 485 | 2024-03-08 02:19:25 | aphids | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 484 | 2024-03-04 03:58:55 | aphids | 2 | 82551 | 23 | 8.860 | 9317.3 |
| 483 | 2024-03-04 03:58:51 | aphids | 1 | 48755 | 4 | 2.563 | 19022.6 |
| 482 | 2024-03-02 18:18:27 | aphids | 3 | 112716 | 448 | 13.640 | 8263.6 |
| 481 | 2024-03-01 09:06:25 | aphids | 2 | 82551 | 23 | 2.390 | 34540.2 |
| 480 | 2024-03-01 09:06:06 | aphids | 3 | 112716 | 448 | 5.546 | 20323.8 |
| 479 | 2024-02-29 21:22:25 | aphids | 2 | 82551 | 23 | 2.610 | 31628.7 |
| 478 | 2024-02-29 21:22:04 | aphids | 3 | 112716 | 448 | 7.360 | 15314.7 |
| 477 | 2024-02-29 13:39:47 | aphids | 3 | 112716 | 448 | 5.300 | 21267.2 |
| 476 | 2024-02-29 13:39:15 | aphids | 2 | 82551 | 23 | 2.423 | 34069.7 |
| 475 | 2024-01-26 07:15:54 | aphids | 1 | 48755 | 4 | 0.906 | 53813.5 |
| 474 | 2024-01-02 18:21:06 | aphids | 3 | 112716 | 448 | 5.173 | 21789.3 |
| 473 | 2024-01-02 18:21:07 | aphids | 2 | 82551 | 23 | 2.563 | 32208.7 |
| 472 | 2023-12-23 13:32:21 | aphids | 3 | 112716 | 448 | 5.656 | 19928.6 |
| 471 | 2023-12-20 08:10:06 | aphids | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 470 | 2023-11-19 04:25:32 | aphids | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 469 | 2023-11-19 00:45:31 | aphids | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 468 | 2023-11-13 22:36:41 | aphids | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 467 | 2023-11-05 02:01:30 | aphids | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 466 | 2023-10-29 20:38:26 | aphids | 3 | 112716 | 448 | 11.610 | 9708.5 |
| 465 | 2023-10-29 20:38:23 | aphids | 2 | 82551 | 23 | 2.500 | 33020.4 |
| 464 | 2023-10-21 04:37:28 | aphids | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 463 | 2023-10-13 13:40:24 | aphids | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 462 | 2023-10-06 19:21:48 | aphids | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 461 | 2023-10-06 08:07:58 | aphids | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 460 | 2023-09-24 11:14:18 | aphids | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 459 | 2023-09-13 17:16:51 | aphids | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 458 | 2023-08-05 23:43:20 | aphids | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 457 | 2023-08-02 13:49:47 | aphids | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 456 | 2023-07-21 04:35:43 | aphids | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 455 | 2023-05-03 05:25:14 | aphids | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 454 | 2023-04-28 10:12:09 | aphids | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 453 | 2023-04-24 17:56:26 | aphids | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 452 | 2023-02-27 13:22:43 | aphids | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 451 | 2023-01-16 02:13:01 | aphids | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 450 | 2022-12-24 10:08:51 | aphids | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 449 | 2022-09-28 11:08:54 | aphids | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 448 | 2022-09-12 14:55:43 | aphids | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 447 | 2022-07-14 11:53:31 | aphids | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 446 | 2022-07-04 00:03:58 | aphids | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 445 | 2022-06-15 02:47:34 | aphids | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 444 | 2022-06-13 17:32:12 | aphids | 1 | 48755 | 4 | 0.950 | 51321.1 |
| 443 | 2022-03-16 15:06:22 | aphids | 1 | 48755 | 4 | 0.936 | 52088.7 |
| 442 | 2022-02-27 21:41:10 | aphids | 1 | 48755 | 4 | 0.936 | 52088.7 |
| 441 | 2021-12-27 03:27:40 | aphids | 1 | 48755 | 4 | 0.856 | 56956.8 |
| 440 | 2021-12-24 18:22:58 | aphids | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 439 | 2021-11-23 01:45:46 | aphids | 1 | 48755 | 4 | 1.813 | 26891.9 |
| 438 | 2021-11-20 01:55:18 | aphids | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 437 | 2021-10-31 15:23:15 | aphids | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 436 | 2021-09-22 05:00:31 | aphids | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 435 | 2021-09-21 13:40:52 | aphids | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 434 | 2021-09-20 18:48:17 | aphids | 1 | 48755 | 4 | 0.846 | 57630.0 |
| 433 | 2021-09-14 03:17:58 | aphids | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 432 | 2021-08-24 20:33:21 | aphids | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 431 | 2021-08-22 16:12:41 | aphids | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 430 | 2021-08-16 18:22:18 | aphids | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 429 | 2021-05-29 06:04:47 | aphids | 1 | 48755 | 4 | 1.813 | 26891.9 |
| 428 | 2021-05-16 01:39:35 | aphids | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 427 | 2021-05-12 17:24:36 | aphids | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 426 | 2021-05-03 15:43:50 | aphids | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 425 | 2021-04-24 20:04:11 | aphids | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 424 | 2021-04-23 17:37:40 | aphids | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 423 | 2021-04-22 16:06:02 | aphids | 1 | 48755 | 4 | 1.690 | 28849.1 |
| 422 | 2021-04-14 13:12:10 | aphids | 1 | 48755 | 4 | 0.876 | 55656.4 |
| 421 | 2021-04-01 20:36:38 | aphids | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 420 | 2021-02-10 11:23:44 | aphids | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 419 | 2021-02-08 18:33:52 | aphids | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 418 | 2021-02-03 14:04:59 | aphids | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 417 | 2020-12-09 07:30:06 | aphids | 3 | 112716 | 448 | 4.750 | 23729.7 |
| 416 | 2020-12-09 07:30:03 | aphids | 2 | 82551 | 23 | 2.326 | 35490.5 |
| 415 | 2020-12-09 07:30:02 | aphids | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 414 | 2020-11-22 05:53:26 | aphids | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 413 | 2020-11-08 13:08:15 | aphids | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 412 | 2020-11-03 20:41:22 | aphids | 1 | 48755 | 4 | 1.016 | 47987.2 |
| 411 | 2020-11-01 20:04:43 | aphids | 1 | 48755 | 4 | 0.873 | 55847.7 |
| 410 | 2020-10-29 09:18:08 | aphids | 2 | 82551 | 23 | 2.330 | 35429.6 |
| 409 | 2020-10-03 03:11:35 | aphids | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 408 | 2020-08-24 21:28:15 | aphids | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 407 | 2020-08-11 05:59:43 | aphids | 1 | 48755 | 4 | 0.763 | 63899.1 |
| 406 | 2020-08-09 08:42:30 | aphids | 1 | 48755 | 4 | 0.810 | 60191.4 |
| 405 | 2020-08-09 02:32:23 | aphids | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 404 | 2020-07-30 06:00:08 | aphids | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 403 | 2020-07-26 22:25:04 | aphids | 1 | 48755 | 4 | 0.796 | 61250.0 |
| 402 | 2020-04-24 16:34:13 | aphids | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 401 | 2020-03-27 07:06:56 | aphids | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 400 | 2020-03-25 23:22:55 | aphids | 1 | 48755 | 4 | 1.750 | 27860.0 |
| 399 | 2020-03-24 19:10:46 | aphids | 1 | 48755 | 4 | 0.826 | 59025.4 |
| 398 | 2020-03-23 21:00:41 | aphids | 1 | 48755 | 4 | 0.923 | 52822.3 |
| 397 | 2020-03-22 08:21:51 | aphids | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 396 | 2020-03-18 20:04:20 | aphids | 1 | 48755 | 4 | 0.983 | 49598.2 |
| 395 | 2020-02-25 02:36:26 | aphids | 1 | 48755 | 4 | 1.750 | 27860.0 |
| 394 | 2020-02-19 11:59:05 | aphids | 1 | 48755 | 4 | 0.890 | 54780.9 |