History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pistache"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 842 | 2026-02-02 23:16:19 | pistache | 4 | 161609 | 617 | 12.266 | 13175.4 |
| 841 | 2026-02-01 23:14:57 | pistache | 4 | 161609 | 617 | 17.563 | 9201.7 |
| 840 | 2026-02-01 09:35:05 | pistache | 4 | 161609 | 617 | 21.610 | 7478.4 |
| 839 | 2026-01-30 22:48:48 | pistache | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 838 | 2026-01-28 16:36:12 | pistache | 4 | 161609 | 617 | 27.250 | 5930.6 |
| 837 | 2026-01-27 01:26:26 | pistache | 4 | 161609 | 617 | 13.656 | 11834.3 |
| 836 | 2026-01-27 01:20:52 | pistache | 4 | 161609 | 617 | 12.796 | 12629.6 |
| 835 | 2026-01-23 22:36:27 | pistache | 4 | 161609 | 617 | 40.613 | 3979.2 |
| 834 | 2026-01-23 17:02:38 | pistache | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 833 | 2026-01-22 10:27:33 | pistache | 4 | 161609 | 617 | 72.673 | 2223.8 |
| 832 | 2026-01-22 02:34:21 | pistache | 1 | 82945 | 2 | 7.140 | 11616.9 |
| 831 | 2026-01-19 16:45:09 | pistache | 4 | 161609 | 617 | 12.440 | 12991.1 |
| 830 | 2026-01-18 09:18:00 | pistache | 4 | 161609 | 617 | 12.533 | 12894.7 |
| 829 | 2025-12-24 10:14:02 | pistache | 1 | 82945 | 2 | 7.000 | 11849.3 |
| 828 | 2025-12-24 10:13:49 | pistache | 1 | 82945 | 2 | 5.736 | 14460.4 |
| 827 | 2025-12-18 22:54:11 | pistache | 1 | 82945 | 2 | 1.846 | 44932.3 |
| 826 | 2025-12-18 22:24:30 | pistache | 4 | 161609 | 617 | 17.546 | 9210.6 |
| 825 | 2025-12-18 22:24:20 | pistache | 4 | 161609 | 617 | 15.470 | 10446.6 |
| 824 | 2025-12-18 16:00:13 | pistache | 4 | 161609 | 617 | 11.846 | 13642.5 |
| 823 | 2025-12-15 11:44:14 | pistache | 4 | 161609 | 617 | 11.330 | 14263.8 |
| 822 | 2025-12-06 00:06:17 | pistache | 4 | 161609 | 617 | 12.313 | 13125.1 |
| 821 | 2025-10-06 13:32:35 | pistache | 1 | 82945 | 2 | 1.390 | 59672.7 |
| 820 | 2025-10-06 05:45:01 | pistache | 1 | 82945 | 2 | 1.313 | 63172.1 |
| 819 | 2025-09-17 22:03:12 | pistache | 2 | 121059 | 6 | 6.766 | 17892.3 |
| 818 | 2025-09-08 02:29:21 | pistache | 1 | 82945 | 2 | 1.356 | 61168.9 |
| 817 | 2025-09-02 23:12:55 | pistache | 1 | 82945 | 2 | 1.406 | 58993.6 |
| 816 | 2025-08-27 21:41:19 | pistache | 2 | 121059 | 6 | 3.750 | 32282.4 |
| 815 | 2025-08-27 12:06:23 | pistache | 1 | 82945 | 2 | 1.376 | 60279.8 |
| 814 | 2025-08-23 06:45:10 | pistache | 1 | 82945 | 2 | 6.800 | 12197.8 |
| 813 | 2025-08-22 07:21:45 | pistache | 3 | 146162 | 54 | 7.330 | 19940.2 |
| 812 | 2025-08-21 19:57:42 | pistache | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 811 | 2025-08-19 13:30:44 | pistache | 2 | 121059 | 6 | 7.810 | 15500.5 |
| 810 | 2025-08-19 10:45:39 | pistache | 3 | 146162 | 54 | 23.833 | 6132.8 |
| 809 | 2025-08-19 08:34:33 | pistache | 3 | 146162 | 54 | 44.223 | 3305.1 |
| 808 | 2025-08-13 12:34:04 | pistache | 1 | 82945 | 2 | 4.313 | 19231.4 |
| 807 | 2025-08-13 08:34:51 | pistache | 1 | 82945 | 2 | 10.983 | 7552.1 |
| 806 | 2025-08-11 11:58:58 | pistache | 1 | 82945 | 2 | 6.546 | 12671.1 |
| 805 | 2025-07-25 05:20:47 | pistache | 1 | 82945 | 2 | 4.466 | 18572.5 |
| 804 | 2025-07-25 00:14:17 | pistache | 1 | 82945 | 2 | 6.920 | 11986.3 |
| 803 | 2025-07-24 06:17:08 | pistache | 1 | 82945 | 2 | 6.143 | 13502.4 |
| 802 | 2025-07-23 16:32:54 | pistache | 1 | 82945 | 2 | 3.890 | 21322.6 |
| 801 | 2025-07-23 05:58:26 | pistache | 1 | 82945 | 2 | 3.376 | 24569.0 |
| 800 | 2025-07-22 16:22:48 | pistache | 4 | 161609 | 617 | 47.300 | 3416.7 |
| 799 | 2025-07-18 12:44:59 | pistache | 4 | 161609 | 617 | 61.936 | 2609.3 |
| 798 | 2025-07-14 19:15:48 | pistache | 4 | 161609 | 617 | 64.486 | 2506.1 |
| 797 | 2025-07-14 12:28:44 | pistache | 4 | 161609 | 617 | 41.046 | 3937.3 |
| 796 | 2025-07-12 12:59:00 | pistache | 1 | 82945 | 2 | 1.953 | 42470.6 |
| 795 | 2025-07-11 06:44:28 | pistache | 4 | 161609 | 617 | 79.473 | 2033.5 |
| 794 | 2025-07-11 04:02:28 | pistache | 2 | 121059 | 6 | 23.096 | 5241.6 |
| 793 | 2025-07-10 21:58:45 | pistache | 3 | 146162 | 54 | 25.313 | 5774.2 |
| 792 | 2025-07-10 11:42:51 | pistache | 1 | 82945 | 2 | 7.236 | 11462.8 |
| 791 | 2025-07-10 03:36:07 | pistache | 3 | 146162 | 54 | 34.156 | 4279.2 |
| 790 | 2025-07-09 15:10:30 | pistache | 1 | 82945 | 2 | 2.140 | 38759.3 |
| 789 | 2025-07-09 05:02:17 | pistache | 3 | 146162 | 54 | 29.876 | 4892.3 |
| 788 | 2025-06-14 07:41:44 | pistache | 1 | 82945 | 2 | 6.486 | 12788.3 |
| 787 | 2025-06-10 07:27:13 | pistache | 1 | 82945 | 2 | 5.203 | 15941.8 |
| 786 | 2025-06-04 16:50:16 | pistache | 3 | 146162 | 54 | 36.220 | 4035.4 |
| 785 | 2025-06-04 06:11:44 | pistache | 1 | 82945 | 2 | 6.606 | 12556.0 |
| 784 | 2025-06-03 00:41:39 | pistache | 3 | 146162 | 54 | 18.563 | 7873.8 |
| 783 | 2025-05-26 00:20:26 | pistache | 1 | 82945 | 2 | 7.550 | 10986.1 |
| 782 | 2025-04-29 16:23:46 | pistache | 3 | 146162 | 54 | 32.520 | 4494.5 |
| 781 | 2025-04-28 05:42:46 | pistache | 1 | 82945 | 2 | 8.860 | 9361.7 |
| 780 | 2025-04-27 08:10:03 | pistache | 3 | 146162 | 54 | 7.250 | 20160.3 |
| 779 | 2025-04-26 05:03:46 | pistache | 2 | 121059 | 6 | 17.640 | 6862.8 |
| 778 | 2025-04-24 23:17:30 | pistache | 1 | 82945 | 2 | 3.890 | 21322.6 |
| 777 | 2025-04-16 07:20:16 | pistache | 1 | 82945 | 2 | 3.920 | 21159.4 |
| 776 | 2025-03-22 06:58:27 | pistache | 3 | 146162 | 54 | 7.156 | 20425.1 |
| 775 | 2025-03-20 00:33:38 | pistache | 1 | 82945 | 2 | 3.580 | 23169.0 |
| 774 | 2025-03-17 21:30:39 | pistache | 3 | 146162 | 54 | 34.156 | 4279.2 |
| 773 | 2025-03-16 16:00:11 | pistache | 3 | 146162 | 54 | 37.363 | 3911.9 |
| 772 | 2025-03-16 16:00:11 | pistache | 2 | 121059 | 6 | 18.453 | 6560.4 |
| 771 | 2025-03-16 10:12:55 | pistache | 3 | 146162 | 54 | 39.940 | 3659.5 |
| 770 | 2025-03-16 09:53:45 | pistache | 1 | 82945 | 2 | 3.656 | 22687.4 |
| 769 | 2025-03-16 08:10:49 | pistache | 3 | 146162 | 54 | 33.503 | 4362.7 |
| 768 | 2025-03-15 19:28:53 | pistache | 3 | 146162 | 54 | 41.703 | 3504.8 |
| 767 | 2025-03-15 18:05:47 | pistache | 2 | 121059 | 6 | 19.296 | 6273.8 |
| 766 | 2025-03-15 18:05:14 | pistache | 1 | 82945 | 2 | 5.453 | 15210.9 |
| 765 | 2025-03-15 17:59:56 | pistache | 3 | 146162 | 54 | 32.563 | 4488.6 |
| 764 | 2025-03-15 16:27:00 | pistache | 3 | 146162 | 54 | 30.880 | 4733.2 |
| 763 | 2025-03-15 14:07:52 | pistache | 4 | 161609 | 617 | 63.626 | 2540.0 |
| 762 | 2025-03-15 14:07:42 | pistache | 3 | 146162 | 54 | 37.766 | 3870.2 |
| 761 | 2025-03-15 14:07:40 | pistache | 2 | 121059 | 6 | 19.050 | 6354.8 |
| 760 | 2025-03-15 14:07:05 | pistache | 1 | 82945 | 2 | 5.686 | 14587.6 |
| 759 | 2025-03-14 08:05:29 | pistache | 3 | 146162 | 54 | 29.080 | 5026.2 |
| 758 | 2025-03-13 19:08:55 | pistache | 3 | 146162 | 54 | 37.393 | 3908.8 |
| 757 | 2025-03-12 16:37:52 | pistache | 1 | 82945 | 2 | 4.563 | 18177.7 |
| 756 | 2025-03-11 10:59:53 | pistache | 3 | 146162 | 54 | 42.883 | 3408.4 |
| 755 | 2025-03-09 23:52:11 | pistache | 3 | 146162 | 54 | 26.750 | 5464.0 |
| 754 | 2025-02-20 10:23:42 | pistache | 3 | 146162 | 54 | 51.343 | 2846.8 |
| 753 | 2025-02-12 13:09:09 | pistache | 1 | 82945 | 2 | 2.796 | 29665.6 |
| 752 | 2025-02-12 13:07:07 | pistache | 2 | 121059 | 6 | 3.890 | 31120.6 |
| 751 | 2025-02-10 20:08:30 | pistache | 3 | 146162 | 54 | 53.270 | 2743.8 |
| 750 | 2025-02-10 13:09:42 | pistache | 1 | 82945 | 2 | 6.983 | 11878.1 |
| 749 | 2025-02-08 11:00:07 | pistache | 3 | 146162 | 54 | 55.910 | 2614.2 |
| 748 | 2025-02-07 08:21:27 | pistache | 4 | 161609 | 617 | 72.830 | 2219.0 |
| 747 | 2025-02-06 17:56:17 | pistache | 3 | 146162 | 54 | 26.080 | 5604.4 |
| 746 | 2025-02-05 19:15:26 | pistache | 3 | 146162 | 54 | 31.706 | 4609.9 |
| 745 | 2025-02-05 19:15:28 | pistache | 2 | 121059 | 6 | 16.656 | 7268.2 |
| 744 | 2025-02-05 12:55:42 | pistache | 4 | 161609 | 617 | 59.720 | 2706.1 |
| 743 | 2025-02-05 07:29:35 | pistache | 1 | 82945 | 2 | 1.360 | 60989.0 |