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 |
| 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 |
| 742 | 2025-02-05 05:35:30 | pistache | 4 | 161609 | 617 | 60.080 | 2689.9 |
| 741 | 2025-02-05 01:45:00 | pistache | 4 | 161609 | 617 | 56.850 | 2842.7 |
| 740 | 2025-01-22 16:36:55 | pistache | 1 | 82945 | 2 | 5.470 | 15163.6 |
| 739 | 2025-01-17 01:34:41 | pistache | 4 | 161609 | 617 | 56.003 | 2885.7 |
| 738 | 2025-01-11 16:22:38 | pistache | 2 | 121059 | 6 | 9.423 | 12847.2 |
| 737 | 2025-01-09 11:07:10 | pistache | 2 | 121059 | 6 | 13.376 | 9050.5 |
| 736 | 2025-01-09 11:07:00 | pistache | 1 | 82945 | 2 | 2.953 | 28088.4 |
| 735 | 2025-01-08 05:16:44 | pistache | 4 | 161609 | 617 | 47.363 | 3412.1 |
| 734 | 2025-01-08 05:17:00 | pistache | 3 | 146162 | 54 | 23.486 | 6223.4 |
| 733 | 2025-01-06 03:50:10 | pistache | 2 | 121059 | 6 | 4.906 | 24675.7 |
| 732 | 2025-01-05 19:23:40 | pistache | 3 | 146162 | 54 | 10.656 | 13716.4 |
| 731 | 2025-01-05 16:13:23 | pistache | 4 | 161609 | 617 | 49.266 | 3280.3 |
| 730 | 2025-01-04 19:27:03 | pistache | 3 | 146162 | 54 | 6.936 | 21073.0 |
| 729 | 2025-01-04 19:08:42 | pistache | 4 | 161609 | 617 | 48.190 | 3353.6 |
| 728 | 2025-01-04 15:23:26 | pistache | 2 | 121059 | 6 | 19.706 | 6143.3 |
| 727 | 2025-01-04 15:22:05 | pistache | 4 | 161609 | 617 | 45.083 | 3584.7 |
| 726 | 2025-01-04 15:22:06 | pistache | 3 | 146162 | 54 | 19.376 | 7543.5 |
| 725 | 2025-01-04 15:21:52 | pistache | 1 | 82945 | 2 | 2.406 | 34474.2 |
| 724 | 2025-01-03 15:28:59 | pistache | 1 | 82945 | 2 | 3.530 | 23497.2 |
| 723 | 2024-12-19 17:46:40 | pistache | 1 | 82945 | 2 | 1.280 | 64800.8 |
| 722 | 2024-12-09 01:46:26 | pistache | 1 | 82945 | 2 | 10.186 | 8143.0 |