History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"adoptees"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 754 | 2024-05-09 13:45:13 | adoptees | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 753 | 2024-05-09 04:39:13 | adoptees | 4 | 161609 | 864 | 26.750 | 6041.5 |
| 752 | 2024-05-05 17:19:45 | adoptees | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 751 | 2024-05-04 01:38:30 | adoptees | 4 | 161609 | 864 | 16.300 | 9914.7 |
| 750 | 2024-05-04 01:38:33 | adoptees | 2 | 121059 | 7 | 4.033 | 30017.1 |
| 749 | 2024-05-04 01:33:45 | adoptees | 3 | 146162 | 59 | 7.423 | 19690.4 |
| 748 | 2024-05-02 16:55:00 | adoptees | 2 | 121059 | 7 | 8.500 | 14242.2 |
| 747 | 2024-05-02 16:31:48 | adoptees | 3 | 146162 | 59 | 8.253 | 17710.2 |
| 746 | 2024-05-02 05:16:26 | adoptees | 2 | 121059 | 7 | 3.876 | 31233.0 |
| 745 | 2024-05-02 05:12:14 | adoptees | 3 | 146162 | 59 | 7.953 | 18378.2 |
| 744 | 2024-05-02 05:12:08 | adoptees | 1 | 82945 | 3 | 3.063 | 27079.7 |
| 743 | 2024-05-02 05:11:03 | adoptees | 2 | 121059 | 7 | 4.253 | 28464.4 |
| 742 | 2024-05-02 05:10:55 | adoptees | 3 | 146162 | 59 | 10.016 | 14592.9 |
| 741 | 2024-05-02 05:10:47 | adoptees | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 740 | 2024-04-29 14:04:38 | adoptees | 4 | 161609 | 864 | 12.390 | 13043.5 |
| 739 | 2024-04-26 12:17:12 | adoptees | 4 | 161609 | 864 | 20.296 | 7962.6 |
| 738 | 2024-04-25 21:07:20 | adoptees | 4 | 161609 | 864 | 14.313 | 11291.1 |
| 737 | 2024-04-25 20:30:47 | adoptees | 4 | 161609 | 864 | 38.566 | 4190.5 |
| 736 | 2024-04-25 20:30:44 | adoptees | 2 | 121059 | 7 | 11.563 | 10469.5 |
| 735 | 2024-04-25 20:30:29 | adoptees | 3 | 146162 | 59 | 23.220 | 6294.7 |
| 734 | 2024-04-25 20:30:26 | adoptees | 1 | 82945 | 3 | 4.326 | 19173.6 |
| 733 | 2024-04-10 22:39:49 | adoptees | 1 | 82945 | 3 | 3.170 | 26165.6 |
| 732 | 2024-04-08 06:11:52 | adoptees | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 731 | 2024-04-02 14:28:13 | adoptees | 4 | 161609 | 864 | 24.283 | 6655.2 |
| 730 | 2024-03-29 12:33:05 | adoptees | 1 | 82945 | 3 | 3.250 | 25521.5 |
| 729 | 2024-03-29 10:03:52 | adoptees | 4 | 161609 | 864 | 15.690 | 10300.1 |
| 728 | 2024-03-29 10:03:53 | adoptees | 2 | 121059 | 7 | 3.923 | 30858.8 |
| 727 | 2024-03-29 10:03:50 | adoptees | 1 | 82945 | 3 | 1.550 | 53512.9 |
| 726 | 2024-03-28 12:13:24 | adoptees | 2 | 121059 | 7 | 3.266 | 37066.4 |
| 725 | 2024-03-28 12:13:05 | adoptees | 3 | 146162 | 59 | 6.266 | 23326.2 |
| 724 | 2024-03-27 09:15:26 | adoptees | 2 | 121059 | 7 | 3.843 | 31501.2 |
| 723 | 2024-03-27 09:15:13 | adoptees | 3 | 146162 | 59 | 7.093 | 20606.5 |
| 722 | 2024-03-25 16:21:55 | adoptees | 2 | 121059 | 7 | 7.250 | 16697.8 |
| 721 | 2024-03-25 16:21:29 | adoptees | 3 | 146162 | 59 | 8.220 | 17781.3 |
| 720 | 2024-03-23 08:17:20 | adoptees | 4 | 161609 | 864 | 39.973 | 4043.0 |
| 719 | 2024-03-23 02:28:40 | adoptees | 4 | 161609 | 864 | 26.406 | 6120.2 |
| 718 | 2024-03-21 22:57:10 | adoptees | 4 | 161609 | 864 | 34.660 | 4662.7 |
| 717 | 2024-03-21 22:47:15 | adoptees | 4 | 161609 | 864 | 14.033 | 11516.4 |
| 716 | 2024-03-21 22:47:13 | adoptees | 3 | 146162 | 59 | 16.206 | 9019.0 |
| 715 | 2024-03-21 22:47:14 | adoptees | 2 | 121059 | 7 | 4.373 | 27683.3 |
| 714 | 2024-03-21 22:46:55 | adoptees | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 713 | 2024-03-06 04:58:20 | adoptees | 1 | 82945 | 3 | 4.860 | 17066.9 |
| 712 | 2024-02-29 21:41:48 | adoptees | 4 | 161609 | 864 | 12.860 | 12566.8 |
| 711 | 2024-02-28 07:05:46 | adoptees | 1 | 82945 | 3 | 2.796 | 29665.6 |
| 710 | 2024-02-27 06:56:16 | adoptees | 2 | 121059 | 7 | 3.843 | 31501.2 |
| 709 | 2024-02-27 06:55:48 | adoptees | 3 | 146162 | 59 | 6.550 | 22314.8 |
| 708 | 2024-02-26 20:52:35 | adoptees | 3 | 146162 | 59 | 14.156 | 10325.1 |
| 707 | 2024-02-26 20:52:35 | adoptees | 4 | 161609 | 864 | 13.330 | 12123.7 |
| 706 | 2024-02-26 20:52:37 | adoptees | 2 | 121059 | 7 | 5.250 | 23058.9 |
| 705 | 2024-02-26 20:52:15 | adoptees | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 704 | 2024-02-12 15:19:58 | adoptees | 3 | 146162 | 59 | 11.940 | 12241.4 |
| 703 | 2024-02-11 18:18:46 | adoptees | 4 | 161609 | 864 | 33.940 | 4761.6 |
| 702 | 2024-02-11 11:12:20 | adoptees | 4 | 161609 | 864 | 25.000 | 6464.4 |
| 701 | 2024-02-11 08:08:01 | adoptees | 4 | 161609 | 864 | 39.550 | 4086.2 |
| 700 | 2024-02-09 21:13:37 | adoptees | 4 | 161609 | 864 | 23.610 | 6844.9 |
| 699 | 2024-02-09 21:13:39 | adoptees | 3 | 146162 | 59 | 9.360 | 15615.6 |
| 698 | 2024-02-09 21:13:40 | adoptees | 2 | 121059 | 7 | 4.096 | 29555.4 |
| 697 | 2024-02-09 21:12:59 | adoptees | 1 | 82945 | 3 | 1.610 | 51518.6 |
| 696 | 2024-01-16 05:58:18 | adoptees | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 695 | 2023-12-27 06:14:34 | adoptees | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 694 | 2023-12-05 05:33:58 | adoptees | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 693 | 2023-11-25 05:10:47 | adoptees | 4 | 161609 | 864 | 12.560 | 12867.0 |
| 692 | 2023-11-25 05:10:49 | adoptees | 3 | 146162 | 59 | 7.500 | 19488.3 |
| 691 | 2023-11-25 05:10:48 | adoptees | 2 | 121059 | 7 | 3.796 | 31891.2 |
| 690 | 2023-11-22 15:57:25 | adoptees | 1 | 82945 | 3 | 1.403 | 59119.7 |
| 689 | 2023-11-10 04:10:36 | adoptees | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 688 | 2023-11-08 00:34:06 | adoptees | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 687 | 2023-10-29 00:40:53 | adoptees | 1 | 82945 | 3 | 2.626 | 31586.1 |
| 686 | 2023-10-27 08:54:18 | adoptees | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 685 | 2023-09-25 10:12:55 | adoptees | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 684 | 2023-08-29 02:33:30 | adoptees | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 683 | 2023-07-05 05:42:26 | adoptees | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 682 | 2023-05-29 04:08:52 | adoptees | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 681 | 2023-03-24 01:00:30 | adoptees | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 680 | 2023-03-18 11:10:40 | adoptees | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 679 | 2023-01-09 00:07:55 | adoptees | 1 | 82945 | 3 | 1.220 | 67987.7 |
| 678 | 2022-11-25 17:38:52 | adoptees | 4 | 161609 | 864 | 10.466 | 15441.3 |
| 677 | 2022-11-25 17:38:32 | adoptees | 4 | 161609 | 864 | 10.453 | 15460.5 |
| 676 | 2022-11-25 17:38:10 | adoptees | 4 | 161609 | 864 | 11.970 | 13501.2 |
| 675 | 2022-11-25 17:37:58 | adoptees | 3 | 146162 | 59 | 6.140 | 23804.9 |
| 674 | 2022-11-25 17:37:51 | adoptees | 2 | 121059 | 7 | 3.313 | 36540.6 |
| 673 | 2022-11-23 23:13:27 | adoptees | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 672 | 2022-11-23 19:11:18 | adoptees | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 671 | 2022-10-06 22:13:03 | adoptees | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 670 | 2022-09-13 23:44:26 | adoptees | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 669 | 2022-08-28 00:12:44 | adoptees | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 668 | 2022-07-27 13:32:40 | adoptees | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 667 | 2022-07-03 21:38:49 | adoptees | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 666 | 2022-05-20 15:41:41 | adoptees | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 665 | 2022-05-18 10:19:35 | adoptees | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 664 | 2022-05-18 10:14:16 | adoptees | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 663 | 2022-03-26 01:16:40 | adoptees | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 662 | 2022-02-04 05:14:28 | adoptees | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 661 | 2022-01-28 07:10:17 | adoptees | 3 | 146162 | 59 | 7.283 | 20068.9 |
| 660 | 2022-01-26 23:20:33 | adoptees | 3 | 146162 | 59 | 6.203 | 23563.1 |
| 659 | 2022-01-26 12:07:10 | adoptees | 3 | 146162 | 59 | 6.516 | 22431.2 |
| 658 | 2022-01-26 00:50:08 | adoptees | 3 | 146162 | 59 | 7.610 | 19206.6 |
| 657 | 2022-01-25 12:21:23 | adoptees | 3 | 146162 | 59 | 6.110 | 23921.8 |
| 656 | 2022-01-25 00:40:44 | adoptees | 3 | 146162 | 59 | 6.236 | 23438.4 |
| 655 | 2022-01-24 08:17:59 | adoptees | 3 | 146162 | 59 | 7.300 | 20022.2 |