History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affect"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 703 | 2024-04-21 11:02:22 | affect | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 702 | 2024-04-19 11:38:12 | affect | 1 | 48755 | 3 | 2.313 | 21078.7 |
| 701 | 2024-04-05 21:26:23 | affect | 3 | 112716 | 174 | 5.860 | 19234.8 |
| 700 | 2024-04-05 21:26:17 | affect | 2 | 82551 | 15 | 2.546 | 32423.8 |
| 699 | 2024-04-03 14:51:24 | affect | 2 | 82551 | 15 | 3.000 | 27517.0 |
| 698 | 2024-04-03 14:51:08 | affect | 1 | 48755 | 3 | 1.000 | 48755.0 |
| 697 | 2024-03-18 22:41:45 | affect | 3 | 112716 | 174 | 14.610 | 7715.0 |
| 696 | 2024-03-18 06:28:01 | affect | 3 | 112716 | 174 | 6.436 | 17513.4 |
| 695 | 2024-03-18 06:28:04 | affect | 2 | 82551 | 15 | 2.686 | 30733.8 |
| 694 | 2024-03-18 06:27:54 | affect | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 693 | 2024-02-28 11:21:44 | affect | 2 | 82551 | 15 | 2.580 | 31996.5 |
| 692 | 2024-02-28 11:21:31 | affect | 3 | 112716 | 174 | 8.986 | 12543.5 |
| 691 | 2024-02-25 06:42:22 | affect | 2 | 82551 | 15 | 2.580 | 31996.5 |
| 690 | 2024-02-25 06:42:11 | affect | 3 | 112716 | 174 | 7.856 | 14347.8 |
| 689 | 2024-02-17 14:12:30 | affect | 2 | 82551 | 15 | 2.216 | 37252.3 |
| 688 | 2024-02-17 14:01:32 | affect | 3 | 112716 | 174 | 5.373 | 20978.2 |
| 687 | 2024-02-14 19:24:25 | affect | 3 | 112716 | 174 | 11.453 | 9841.6 |
| 686 | 2024-02-14 19:24:27 | affect | 2 | 82551 | 15 | 3.253 | 25376.9 |
| 685 | 2024-02-14 19:24:20 | affect | 1 | 48755 | 3 | 0.956 | 50999.0 |
| 684 | 2024-01-30 18:43:39 | affect | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 683 | 2024-01-21 23:47:27 | affect | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 682 | 2024-01-13 15:55:51 | affect | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 681 | 2023-11-26 09:54:36 | affect | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 680 | 2023-11-17 05:11:08 | affect | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 679 | 2023-11-05 21:08:35 | affect | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 678 | 2023-11-01 05:28:02 | affect | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 677 | 2023-10-23 02:47:51 | affect | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 676 | 2023-10-19 05:03:44 | affect | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 675 | 2023-10-14 23:49:12 | affect | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 674 | 2023-10-07 12:11:05 | affect | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 673 | 2023-09-26 08:43:45 | affect | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 672 | 2023-09-15 11:12:30 | affect | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 671 | 2023-09-03 02:15:09 | affect | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 670 | 2023-07-06 05:44:05 | affect | 1 | 48755 | 3 | 0.893 | 54596.9 |
| 669 | 2023-06-09 19:15:08 | affect | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 668 | 2023-04-07 01:30:31 | affect | 3 | 112716 | 174 | 4.453 | 25312.4 |
| 667 | 2023-03-31 16:32:32 | affect | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 666 | 2023-03-16 02:00:39 | affect | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 665 | 2023-01-14 21:29:15 | affect | 3 | 112716 | 174 | 4.470 | 25216.1 |
| 664 | 2023-01-14 05:40:22 | affect | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 663 | 2022-12-18 19:02:38 | affect | 3 | 112716 | 174 | 4.766 | 23650.0 |
| 662 | 2022-11-21 06:16:02 | affect | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 661 | 2022-11-08 06:18:49 | affect | 3 | 112716 | 174 | 5.156 | 21861.1 |
| 660 | 2022-11-06 03:49:18 | affect | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 659 | 2022-10-31 17:33:14 | affect | 3 | 112716 | 174 | 5.046 | 22337.7 |
| 658 | 2022-09-01 17:36:49 | affect | 3 | 112716 | 174 | 4.720 | 23880.5 |
| 657 | 2022-07-28 11:01:51 | affect | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 656 | 2022-07-22 12:58:41 | affect | 3 | 112716 | 174 | 4.560 | 24718.4 |
| 655 | 2022-07-20 06:30:15 | affect | 3 | 112716 | 174 | 4.860 | 23192.6 |
| 654 | 2022-06-28 13:29:22 | affect | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 653 | 2022-06-26 08:46:22 | affect | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 652 | 2022-06-19 12:29:49 | affect | 3 | 112716 | 174 | 4.626 | 24365.8 |
| 651 | 2022-06-13 21:00:14 | affect | 3 | 112716 | 174 | 4.843 | 23274.0 |
| 650 | 2022-04-06 08:36:29 | affect | 1 | 48755 | 3 | 1.420 | 34334.5 |
| 649 | 2022-03-15 11:16:28 | affect | 2 | 82551 | 15 | 2.673 | 30883.3 |
| 648 | 2022-03-14 19:13:44 | affect | 2 | 82551 | 15 | 2.206 | 37421.1 |
| 647 | 2022-03-13 19:14:45 | affect | 2 | 82551 | 15 | 2.626 | 31436.0 |
| 646 | 2022-03-12 17:49:24 | affect | 2 | 82551 | 15 | 2.500 | 33020.4 |
| 645 | 2022-03-01 08:22:51 | affect | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 644 | 2022-01-29 08:02:39 | affect | 2 | 82551 | 15 | 2.126 | 38829.3 |
| 643 | 2022-01-03 21:32:52 | affect | 2 | 82551 | 15 | 2.516 | 32810.4 |
| 642 | 2021-12-30 19:25:32 | affect | 2 | 82551 | 15 | 2.563 | 32208.7 |
| 641 | 2021-12-19 05:29:04 | affect | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 640 | 2021-12-14 02:46:49 | affect | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 639 | 2021-12-07 19:43:39 | affect | 2 | 82551 | 15 | 2.406 | 34310.5 |
| 638 | 2021-12-07 09:08:46 | affect | 2 | 82551 | 15 | 2.453 | 33653.1 |
| 637 | 2021-12-06 23:18:19 | affect | 2 | 82551 | 15 | 2.123 | 38884.1 |
| 636 | 2021-12-06 13:02:52 | affect | 2 | 82551 | 15 | 2.406 | 34310.5 |
| 635 | 2021-12-05 15:59:32 | affect | 2 | 82551 | 15 | 2.453 | 33653.1 |
| 634 | 2021-11-24 13:35:35 | affect | 2 | 82551 | 15 | 3.686 | 22395.8 |
| 633 | 2021-11-23 10:50:41 | affect | 2 | 82551 | 15 | 2.580 | 31996.5 |
| 632 | 2021-11-22 01:24:54 | affect | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 631 | 2021-11-15 15:46:38 | affect | 2 | 82551 | 15 | 2.420 | 34112.0 |
| 630 | 2021-11-14 16:02:35 | affect | 2 | 82551 | 15 | 2.466 | 33475.7 |
| 629 | 2021-11-13 15:22:20 | affect | 2 | 82551 | 15 | 2.326 | 35490.5 |
| 628 | 2021-11-12 18:17:46 | affect | 2 | 82551 | 15 | 2.343 | 35233.0 |
| 627 | 2021-11-11 16:41:56 | affect | 2 | 82551 | 15 | 2.530 | 32628.9 |
| 626 | 2021-10-26 20:57:18 | affect | 2 | 82551 | 15 | 2.656 | 31080.9 |
| 625 | 2021-10-25 13:36:45 | affect | 2 | 82551 | 15 | 2.470 | 33421.5 |
| 624 | 2021-10-25 08:58:02 | affect | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 623 | 2021-10-24 13:44:12 | affect | 2 | 82551 | 15 | 2.140 | 38575.2 |
| 622 | 2021-10-23 10:39:28 | affect | 2 | 82551 | 15 | 2.126 | 38829.3 |
| 621 | 2021-10-23 07:50:48 | affect | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 620 | 2021-10-22 17:09:18 | affect | 2 | 82551 | 15 | 2.093 | 39441.5 |
| 619 | 2021-09-26 16:03:41 | affect | 2 | 82551 | 15 | 2.343 | 35233.0 |
| 618 | 2021-09-26 05:45:19 | affect | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 617 | 2021-09-25 09:33:13 | affect | 2 | 82551 | 15 | 2.360 | 34979.2 |
| 616 | 2021-09-24 08:53:59 | affect | 2 | 82551 | 15 | 2.530 | 32628.9 |
| 615 | 2021-09-23 09:13:44 | affect | 2 | 82551 | 15 | 2.406 | 34310.5 |
| 614 | 2021-09-12 00:44:11 | affect | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 613 | 2021-08-14 00:15:57 | affect | 3 | 112716 | 174 | 5.203 | 21663.7 |
| 612 | 2021-08-10 01:00:31 | affect | 3 | 112716 | 174 | 5.610 | 20092.0 |
| 611 | 2021-08-07 23:14:13 | affect | 3 | 112716 | 174 | 10.983 | 10262.8 |
| 610 | 2021-07-30 02:12:09 | affect | 3 | 112716 | 174 | 5.546 | 20323.8 |
| 609 | 2021-07-28 21:40:55 | affect | 3 | 112716 | 174 | 4.703 | 23966.8 |
| 608 | 2021-07-28 11:19:46 | affect | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 607 | 2021-07-27 18:30:14 | affect | 2 | 82551 | 15 | 2.483 | 33246.5 |
| 606 | 2021-07-26 20:45:09 | affect | 2 | 82551 | 15 | 2.076 | 39764.5 |
| 605 | 2021-07-22 07:07:44 | affect | 2 | 82551 | 15 | 2.296 | 35954.3 |
| 604 | 2021-07-20 16:15:25 | affect | 2 | 82551 | 15 | 2.563 | 32208.7 |