History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piazzas"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 879 | 2024-04-25 23:03:30 | piazzas | 4 | 151207 | 1126 | 26.173 | 5777.2 |
| 878 | 2024-03-29 12:23:02 | piazzas | 1 | 69583 | 3 | 2.766 | 25156.5 |
| 877 | 2024-03-28 23:07:18 | piazzas | 1 | 69583 | 3 | 2.030 | 34277.3 |
| 876 | 2024-02-28 04:47:02 | piazzas | 1 | 69583 | 3 | 4.000 | 17395.8 |
| 875 | 2024-01-19 13:30:37 | piazzas | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 874 | 2024-01-07 15:28:06 | piazzas | 3 | 134027 | 81 | 6.983 | 19193.3 |
| 873 | 2024-01-06 18:26:26 | piazzas | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 872 | 2023-12-03 20:44:43 | piazzas | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 871 | 2023-12-03 20:44:42 | piazzas | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 870 | 2023-12-01 06:00:47 | piazzas | 3 | 134027 | 81 | 13.000 | 10309.8 |
| 869 | 2023-11-29 08:42:25 | piazzas | 4 | 151207 | 1126 | 11.033 | 13705.0 |
| 868 | 2023-11-26 06:20:50 | piazzas | 2 | 107671 | 9 | 3.233 | 33303.7 |
| 867 | 2023-11-20 18:30:20 | piazzas | 2 | 107671 | 9 | 3.216 | 33479.8 |
| 866 | 2023-11-10 00:42:46 | piazzas | 3 | 134027 | 81 | 9.533 | 14059.3 |
| 865 | 2023-11-10 00:37:49 | piazzas | 4 | 151207 | 1126 | 17.330 | 8725.2 |
| 864 | 2023-11-10 00:22:38 | piazzas | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 863 | 2023-10-30 14:41:14 | piazzas | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 862 | 2023-10-29 23:25:54 | piazzas | 2 | 107671 | 9 | 3.453 | 31181.9 |
| 861 | 2023-10-27 03:25:10 | piazzas | 3 | 134027 | 81 | 8.110 | 16526.1 |
| 860 | 2023-10-27 03:24:09 | piazzas | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 859 | 2023-10-27 03:21:08 | piazzas | 4 | 151207 | 1126 | 14.953 | 10112.2 |
| 858 | 2023-10-26 14:22:20 | piazzas | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 857 | 2023-10-24 14:54:20 | piazzas | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 856 | 2023-10-22 19:59:03 | piazzas | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 855 | 2023-10-20 18:41:08 | piazzas | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 854 | 2023-10-20 18:37:34 | piazzas | 3 | 134027 | 81 | 8.046 | 16657.6 |
| 853 | 2023-10-20 18:37:10 | piazzas | 4 | 151207 | 1126 | 12.893 | 11727.8 |
| 852 | 2023-10-18 19:50:33 | piazzas | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 851 | 2023-10-17 14:19:55 | piazzas | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 850 | 2023-10-17 14:13:48 | piazzas | 4 | 151207 | 1126 | 31.640 | 4779.0 |
| 849 | 2023-10-17 14:13:46 | piazzas | 3 | 134027 | 81 | 12.826 | 10449.6 |
| 848 | 2023-10-16 19:23:53 | piazzas | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 847 | 2023-10-14 16:28:10 | piazzas | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 846 | 2023-10-13 12:02:51 | piazzas | 3 | 134027 | 81 | 7.550 | 17751.9 |
| 845 | 2023-10-13 11:59:33 | piazzas | 4 | 151207 | 1126 | 12.670 | 11934.3 |
| 844 | 2023-10-13 07:28:04 | piazzas | 3 | 134027 | 81 | 6.313 | 21230.3 |
| 843 | 2023-10-12 17:02:04 | piazzas | 1 | 69583 | 3 | 1.393 | 49951.9 |
| 842 | 2023-10-11 09:55:05 | piazzas | 2 | 107671 | 9 | 7.313 | 14723.2 |
| 841 | 2023-10-11 09:53:51 | piazzas | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 840 | 2023-10-10 20:38:08 | piazzas | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 839 | 2023-10-08 17:02:38 | piazzas | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 838 | 2023-10-08 12:28:07 | piazzas | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 837 | 2023-10-06 19:57:13 | piazzas | 1 | 69583 | 3 | 1.826 | 38106.8 |
| 836 | 2023-10-05 18:51:24 | piazzas | 2 | 107671 | 9 | 2.953 | 36461.6 |
| 835 | 2023-10-05 17:19:15 | piazzas | 3 | 134027 | 81 | 8.186 | 16372.7 |
| 834 | 2023-10-05 03:15:48 | piazzas | 4 | 151207 | 1126 | 13.360 | 11317.9 |
| 833 | 2023-10-04 13:29:16 | piazzas | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 832 | 2023-10-03 10:11:52 | piazzas | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 831 | 2023-10-03 10:09:22 | piazzas | 4 | 151207 | 1126 | 25.846 | 5850.3 |
| 830 | 2023-09-30 13:11:24 | piazzas | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 829 | 2023-09-26 18:19:10 | piazzas | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 828 | 2023-09-21 07:43:05 | piazzas | 4 | 151207 | 1126 | 19.470 | 7766.2 |
| 827 | 2023-09-21 07:37:17 | piazzas | 3 | 134027 | 81 | 6.750 | 19855.9 |
| 826 | 2023-09-12 19:33:31 | piazzas | 3 | 134027 | 81 | 7.080 | 18930.4 |
| 825 | 2023-09-12 19:33:30 | piazzas | 2 | 107671 | 9 | 3.126 | 34443.7 |
| 824 | 2023-09-10 13:18:29 | piazzas | 1 | 69583 | 3 | 1.153 | 60349.5 |
| 823 | 2023-09-10 13:15:40 | piazzas | 4 | 151207 | 1126 | 21.800 | 6936.1 |
| 822 | 2023-08-28 14:53:44 | piazzas | 4 | 151207 | 1126 | 11.860 | 12749.3 |
| 821 | 2023-08-23 14:40:31 | piazzas | 1 | 69583 | 3 | 2.483 | 28023.8 |
| 820 | 2023-08-14 14:35:45 | piazzas | 4 | 151207 | 1126 | 10.016 | 15096.5 |
| 819 | 2023-07-23 15:55:51 | piazzas | 3 | 134027 | 81 | 5.813 | 23056.4 |
| 818 | 2023-05-29 20:10:08 | piazzas | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 817 | 2023-05-26 12:18:49 | piazzas | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 816 | 2023-04-18 23:55:08 | piazzas | 1 | 69583 | 3 | 1.830 | 38023.5 |
| 815 | 2023-04-12 04:56:11 | piazzas | 4 | 151207 | 1126 | 9.690 | 15604.4 |
| 814 | 2023-04-02 19:32:13 | piazzas | 3 | 134027 | 81 | 5.593 | 23963.3 |
| 813 | 2023-03-20 23:12:41 | piazzas | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 812 | 2023-03-20 06:54:28 | piazzas | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 811 | 2023-03-10 05:11:11 | piazzas | 4 | 151207 | 1126 | 11.796 | 12818.5 |
| 810 | 2023-01-27 01:44:54 | piazzas | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 809 | 2023-01-16 15:47:58 | piazzas | 4 | 151207 | 1126 | 9.970 | 15166.2 |
| 808 | 2023-01-14 09:23:42 | piazzas | 4 | 151207 | 1126 | 9.640 | 15685.4 |
| 807 | 2023-01-07 14:10:30 | piazzas | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 806 | 2023-01-03 05:16:07 | piazzas | 4 | 151207 | 1126 | 10.126 | 14932.5 |
| 805 | 2022-12-31 11:26:52 | piazzas | 3 | 134027 | 81 | 6.936 | 19323.4 |
| 804 | 2022-12-23 16:38:17 | piazzas | 4 | 151207 | 1126 | 9.640 | 15685.4 |
| 803 | 2022-12-02 17:16:00 | piazzas | 4 | 151207 | 1126 | 10.766 | 14044.9 |
| 802 | 2022-11-17 11:31:47 | piazzas | 3 | 134027 | 81 | 6.030 | 22226.7 |
| 801 | 2022-11-17 07:55:58 | piazzas | 4 | 151207 | 1126 | 10.673 | 14167.2 |
| 800 | 2022-11-13 18:29:17 | piazzas | 4 | 151207 | 1126 | 11.080 | 13646.8 |
| 799 | 2022-10-16 16:19:37 | piazzas | 4 | 151207 | 1126 | 10.483 | 14424.0 |
| 798 | 2022-10-15 14:59:46 | piazzas | 3 | 134027 | 81 | 5.653 | 23709.0 |
| 797 | 2022-10-11 09:19:59 | piazzas | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 796 | 2022-10-07 09:32:58 | piazzas | 4 | 151207 | 1126 | 9.593 | 15762.2 |
| 795 | 2022-09-23 18:41:09 | piazzas | 4 | 151207 | 1126 | 9.766 | 15483.0 |
| 794 | 2022-09-13 22:42:45 | piazzas | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 793 | 2022-09-12 10:15:45 | piazzas | 4 | 151207 | 1126 | 9.736 | 15530.7 |
| 792 | 2022-09-08 19:59:29 | piazzas | 4 | 151207 | 1126 | 11.160 | 13549.0 |
| 791 | 2022-09-04 00:51:19 | piazzas | 3 | 134027 | 81 | 6.690 | 20033.9 |
| 790 | 2022-09-02 04:38:40 | piazzas | 4 | 151207 | 1126 | 9.890 | 15288.9 |
| 789 | 2022-07-18 21:27:38 | piazzas | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 788 | 2022-07-12 01:19:14 | piazzas | 4 | 151207 | 1126 | 9.966 | 15172.3 |
| 787 | 2022-06-21 03:11:17 | piazzas | 4 | 151207 | 1126 | 9.686 | 15610.9 |
| 786 | 2022-06-01 00:21:11 | piazzas | 4 | 151207 | 1126 | 9.830 | 15382.2 |
| 785 | 2022-05-31 00:26:31 | piazzas | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 784 | 2022-05-28 20:32:04 | piazzas | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 783 | 2022-05-24 21:54:59 | piazzas | 4 | 151207 | 1126 | 10.576 | 14297.2 |
| 782 | 2022-05-24 19:15:59 | piazzas | 4 | 151207 | 1126 | 9.860 | 15335.4 |
| 781 | 2022-05-17 16:01:17 | piazzas | 4 | 151207 | 1126 | 12.046 | 12552.5 |
| 780 | 2022-05-13 20:58:03 | piazzas | 4 | 151207 | 1126 | 11.796 | 12818.5 |