History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pickets"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 761 | 2025-12-07 18:53:48 | pickets | 1 | 69583 | 9 | 1.343 | 51811.6 |
| 760 | 2025-12-01 11:42:56 | pickets | 1 | 69583 | 9 | 1.250 | 55666.4 |
| 759 | 2025-12-01 11:40:40 | pickets | 1 | 69583 | 9 | 1.453 | 47889.2 |
| 758 | 2025-12-01 11:37:33 | pickets | 1 | 69583 | 9 | 1.233 | 56433.9 |
| 757 | 2025-12-01 10:42:31 | pickets | 1 | 69583 | 9 | 2.563 | 27149.0 |
| 756 | 2025-11-30 14:05:58 | pickets | 1 | 69583 | 9 | 1.110 | 62687.4 |
| 755 | 2025-11-30 00:56:28 | pickets | 1 | 69583 | 9 | 1.156 | 60192.9 |
| 754 | 2025-11-29 03:23:33 | pickets | 1 | 69583 | 9 | 1.453 | 47889.2 |
| 753 | 2025-11-17 14:57:36 | pickets | 1 | 69583 | 9 | 1.483 | 46920.4 |
| 752 | 2025-11-17 11:19:58 | pickets | 1 | 69583 | 9 | 1.330 | 52318.0 |
| 751 | 2025-11-16 04:48:36 | pickets | 1 | 69583 | 9 | 1.280 | 54361.7 |
| 750 | 2025-11-15 19:39:14 | pickets | 1 | 69583 | 9 | 1.266 | 54962.9 |
| 749 | 2025-11-15 10:25:19 | pickets | 1 | 69583 | 9 | 1.203 | 57841.2 |
| 748 | 2025-11-15 09:49:38 | pickets | 1 | 69583 | 9 | 1.203 | 57841.2 |
| 747 | 2025-11-12 14:08:46 | pickets | 1 | 69583 | 9 | 1.203 | 57841.2 |
| 746 | 2025-10-30 02:07:16 | pickets | 1 | 69583 | 9 | 1.233 | 56433.9 |
| 745 | 2025-10-29 18:36:55 | pickets | 1 | 69583 | 9 | 1.310 | 53116.8 |
| 744 | 2025-10-29 16:22:03 | pickets | 1 | 69583 | 9 | 1.096 | 63488.1 |
| 743 | 2025-10-17 15:04:52 | pickets | 1 | 69583 | 9 | 1.110 | 62687.4 |
| 742 | 2025-10-16 12:55:13 | pickets | 1 | 69583 | 9 | 1.156 | 60192.9 |
| 741 | 2025-10-13 14:31:34 | pickets | 1 | 69583 | 9 | 1.203 | 57841.2 |
| 740 | 2025-10-12 11:31:51 | pickets | 1 | 69583 | 9 | 1.156 | 60192.9 |
| 739 | 2025-10-06 10:46:44 | pickets | 1 | 69583 | 9 | 1.110 | 62687.4 |
| 738 | 2025-10-05 17:14:32 | pickets | 1 | 69583 | 9 | 1.280 | 54361.7 |
| 737 | 2025-09-29 02:11:09 | pickets | 1 | 69583 | 9 | 1.250 | 55666.4 |
| 736 | 2025-09-29 02:00:25 | pickets | 1 | 69583 | 9 | 1.326 | 52475.9 |
| 735 | 2025-09-28 15:07:26 | pickets | 1 | 69583 | 9 | 1.266 | 54962.9 |
| 734 | 2025-09-28 04:03:36 | pickets | 1 | 69583 | 9 | 1.266 | 54962.9 |
| 733 | 2025-09-16 15:05:43 | pickets | 1 | 69583 | 9 | 1.250 | 55666.4 |
| 732 | 2025-09-12 18:11:33 | pickets | 1 | 69583 | 9 | 1.110 | 62687.4 |
| 731 | 2025-09-12 13:10:47 | pickets | 1 | 69583 | 9 | 1.826 | 38106.8 |
| 730 | 2025-09-11 19:57:23 | pickets | 1 | 69583 | 9 | 1.610 | 43219.3 |
| 729 | 2025-09-10 13:22:23 | pickets | 1 | 69583 | 9 | 1.470 | 47335.4 |
| 728 | 2025-09-10 12:19:54 | pickets | 1 | 69583 | 9 | 1.360 | 51164.0 |
| 727 | 2025-09-10 10:21:52 | pickets | 1 | 69583 | 9 | 1.390 | 50059.7 |
| 726 | 2025-09-07 15:33:40 | pickets | 1 | 69583 | 9 | 1.266 | 54962.9 |
| 725 | 2025-09-05 04:30:31 | pickets | 1 | 69583 | 9 | 1.250 | 55666.4 |
| 724 | 2025-09-02 22:18:25 | pickets | 2 | 107671 | 72 | 3.186 | 33795.0 |
| 723 | 2025-09-02 02:07:21 | pickets | 1 | 69583 | 9 | 1.093 | 63662.4 |
| 722 | 2025-08-28 10:37:41 | pickets | 1 | 69583 | 9 | 1.280 | 54361.7 |
| 721 | 2025-08-27 14:48:22 | pickets | 1 | 69583 | 9 | 1.266 | 54962.9 |
| 720 | 2025-08-27 03:36:00 | pickets | 1 | 69583 | 9 | 1.203 | 57841.2 |
| 719 | 2025-08-27 02:18:22 | pickets | 1 | 69583 | 9 | 1.093 | 63662.4 |
| 718 | 2025-08-17 14:24:10 | pickets | 1 | 69583 | 9 | 3.033 | 22942.0 |
| 717 | 2025-08-13 21:36:17 | pickets | 1 | 69583 | 9 | 1.220 | 57035.2 |
| 716 | 2025-08-09 01:54:16 | pickets | 1 | 69583 | 9 | 5.203 | 13373.6 |
| 715 | 2025-08-07 15:30:42 | pickets | 1 | 69583 | 9 | 5.236 | 13289.3 |
| 714 | 2025-08-07 02:40:30 | pickets | 3 | 134027 | 486 | 30.283 | 4425.8 |
| 713 | 2025-08-06 09:58:08 | pickets | 3 | 134027 | 486 | 39.986 | 3351.8 |
| 712 | 2025-08-05 03:01:16 | pickets | 3 | 134027 | 486 | 26.343 | 5087.8 |
| 711 | 2025-08-03 18:00:48 | pickets | 2 | 107671 | 72 | 9.453 | 11390.1 |
| 710 | 2025-08-03 16:25:02 | pickets | 1 | 69583 | 9 | 3.220 | 21609.6 |
| 709 | 2025-08-03 16:21:01 | pickets | 3 | 134027 | 486 | 17.590 | 7619.5 |
| 708 | 2025-08-01 23:16:05 | pickets | 2 | 107671 | 72 | 9.046 | 11902.6 |
| 707 | 2025-08-01 14:02:22 | pickets | 1 | 69583 | 9 | 5.910 | 11773.8 |
| 706 | 2025-07-31 13:09:11 | pickets | 3 | 134027 | 486 | 27.300 | 4909.4 |
| 705 | 2025-07-31 06:08:45 | pickets | 2 | 107671 | 72 | 8.600 | 12519.9 |
| 704 | 2025-07-30 12:36:20 | pickets | 1 | 69583 | 9 | 1.233 | 56433.9 |
| 703 | 2025-07-27 02:25:01 | pickets | 1 | 69583 | 9 | 3.233 | 21522.7 |
| 702 | 2025-07-26 18:26:15 | pickets | 1 | 69583 | 9 | 8.233 | 8451.7 |
| 701 | 2025-07-24 21:34:34 | pickets | 1 | 69583 | 9 | 4.436 | 15686.0 |
| 700 | 2025-07-23 14:35:36 | pickets | 1 | 69583 | 9 | 4.313 | 16133.3 |
| 699 | 2025-07-23 11:42:20 | pickets | 1 | 69583 | 9 | 6.986 | 9960.3 |
| 698 | 2025-07-22 21:39:33 | pickets | 1 | 69583 | 9 | 2.673 | 26031.8 |
| 697 | 2025-07-22 19:59:32 | pickets | 1 | 69583 | 9 | 4.866 | 14299.8 |
| 696 | 2025-07-22 16:05:31 | pickets | 1 | 69583 | 9 | 3.640 | 19116.2 |
| 695 | 2025-07-22 13:40:53 | pickets | 1 | 69583 | 9 | 3.203 | 21724.3 |
| 694 | 2025-07-21 11:28:00 | pickets | 1 | 69583 | 9 | 5.453 | 12760.5 |
| 693 | 2025-07-14 15:33:36 | pickets | 1 | 69583 | 9 | 3.030 | 22964.7 |
| 692 | 2025-07-10 09:11:41 | pickets | 2 | 107671 | 72 | 16.423 | 6556.1 |
| 691 | 2025-07-08 14:38:59 | pickets | 1 | 69583 | 9 | 5.610 | 12403.4 |
| 690 | 2025-06-27 10:58:54 | pickets | 1 | 69583 | 9 | 7.780 | 8943.8 |
| 689 | 2025-06-25 21:39:33 | pickets | 3 | 134027 | 486 | 17.910 | 7483.4 |
| 688 | 2025-06-24 16:29:04 | pickets | 1 | 69583 | 9 | 5.876 | 11841.9 |
| 687 | 2025-06-24 12:05:53 | pickets | 3 | 134027 | 486 | 21.800 | 6148.0 |
| 686 | 2025-06-20 07:38:50 | pickets | 3 | 134027 | 486 | 25.890 | 5176.8 |
| 685 | 2025-06-20 06:13:43 | pickets | 1 | 69583 | 9 | 5.876 | 11841.9 |
| 684 | 2025-06-20 00:35:07 | pickets | 3 | 134027 | 486 | 26.626 | 5033.7 |
| 683 | 2025-06-19 21:52:36 | pickets | 3 | 134027 | 486 | 41.800 | 3206.4 |
| 682 | 2025-06-18 23:00:18 | pickets | 3 | 134027 | 486 | 23.266 | 5760.6 |
| 681 | 2025-06-17 05:28:23 | pickets | 1 | 69583 | 9 | 3.470 | 20052.7 |
| 680 | 2025-06-16 19:46:01 | pickets | 1 | 69583 | 9 | 6.813 | 10213.3 |
| 679 | 2025-06-13 01:57:13 | pickets | 1 | 69583 | 9 | 5.876 | 11841.9 |
| 678 | 2025-06-12 16:45:01 | pickets | 1 | 69583 | 9 | 5.920 | 11753.9 |
| 677 | 2025-06-04 11:02:54 | pickets | 1 | 69583 | 9 | 4.796 | 14508.5 |
| 676 | 2025-06-03 09:29:01 | pickets | 3 | 134027 | 486 | 7.186 | 18651.1 |
| 675 | 2025-05-31 21:50:26 | pickets | 1 | 69583 | 9 | 5.750 | 12101.4 |
| 674 | 2025-05-31 10:00:45 | pickets | 3 | 134027 | 486 | 32.750 | 4092.4 |
| 673 | 2025-05-27 09:00:30 | pickets | 3 | 134027 | 486 | 23.733 | 5647.3 |
| 672 | 2025-05-18 08:36:36 | pickets | 3 | 134027 | 486 | 37.236 | 3599.4 |
| 671 | 2025-05-17 07:38:29 | pickets | 1 | 69583 | 9 | 1.860 | 37410.2 |
| 670 | 2025-05-17 01:15:42 | pickets | 3 | 134027 | 486 | 17.956 | 7464.2 |
| 669 | 2025-05-15 19:18:09 | pickets | 3 | 134027 | 486 | 6.936 | 19323.4 |
| 668 | 2025-05-14 21:43:42 | pickets | 1 | 69583 | 9 | 1.250 | 55666.4 |
| 667 | 2025-05-14 15:42:39 | pickets | 1 | 69583 | 9 | 5.750 | 12101.4 |
| 666 | 2025-05-12 12:41:59 | pickets | 3 | 134027 | 486 | 34.876 | 3843.0 |
| 665 | 2025-05-12 05:54:35 | pickets | 3 | 134027 | 486 | 34.656 | 3867.4 |
| 664 | 2025-05-12 02:34:51 | pickets | 1 | 69583 | 9 | 6.326 | 10999.5 |
| 663 | 2025-05-12 02:09:52 | pickets | 3 | 134027 | 486 | 25.360 | 5285.0 |
| 662 | 2025-05-11 21:45:13 | pickets | 3 | 134027 | 486 | 22.736 | 5894.9 |