History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"quartz"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 840 | 2024-04-25 08:29:46 | quartz | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 839 | 2024-04-24 17:52:45 | quartz | 2 | 82551 | 23 | 2.483 | 33246.5 |
| 838 | 2024-04-24 17:52:27 | quartz | 3 | 112716 | 211 | 4.983 | 22620.1 |
| 837 | 2024-04-22 17:12:18 | quartz | 2 | 82551 | 23 | 2.530 | 32628.9 |
| 836 | 2024-04-22 17:12:17 | quartz | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 835 | 2024-04-22 17:12:03 | quartz | 3 | 112716 | 211 | 6.360 | 17722.6 |
| 834 | 2024-04-21 16:07:50 | quartz | 3 | 112716 | 211 | 11.266 | 10005.0 |
| 833 | 2024-04-21 16:07:49 | quartz | 2 | 82551 | 23 | 7.516 | 10983.4 |
| 832 | 2024-04-21 16:07:47 | quartz | 1 | 48755 | 5 | 3.233 | 15080.4 |
| 831 | 2024-04-05 03:33:11 | quartz | 3 | 112716 | 211 | 9.970 | 11305.5 |
| 830 | 2024-04-03 08:39:06 | quartz | 3 | 112716 | 211 | 10.203 | 11047.3 |
| 829 | 2024-04-03 08:39:06 | quartz | 2 | 82551 | 23 | 4.953 | 16666.9 |
| 828 | 2024-04-03 08:39:02 | quartz | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 827 | 2024-03-29 23:17:58 | quartz | 1 | 48755 | 5 | 1.640 | 29728.7 |
| 826 | 2024-03-23 07:37:13 | quartz | 3 | 112716 | 211 | 5.843 | 19290.8 |
| 825 | 2024-03-20 07:54:11 | quartz | 2 | 82551 | 23 | 2.123 | 38884.1 |
| 824 | 2024-03-20 07:53:43 | quartz | 2 | 82551 | 23 | 2.563 | 32208.7 |
| 823 | 2024-03-20 07:53:36 | quartz | 1 | 48755 | 5 | 1.810 | 26936.5 |
| 822 | 2024-03-20 07:53:20 | quartz | 3 | 112716 | 211 | 6.220 | 18121.5 |
| 821 | 2024-03-18 06:46:18 | quartz | 3 | 112716 | 211 | 16.003 | 7043.4 |
| 820 | 2024-03-18 06:46:24 | quartz | 1 | 48755 | 5 | 1.453 | 33554.7 |
| 819 | 2024-03-18 06:46:19 | quartz | 2 | 82551 | 23 | 3.423 | 24116.6 |
| 818 | 2024-03-14 18:24:23 | quartz | 1 | 48755 | 5 | 1.546 | 31536.2 |
| 817 | 2024-02-28 02:39:31 | quartz | 1 | 48755 | 5 | 2.626 | 18566.3 |
| 816 | 2024-02-25 06:47:05 | quartz | 2 | 82551 | 23 | 2.546 | 32423.8 |
| 815 | 2024-02-22 04:59:22 | quartz | 3 | 112716 | 211 | 11.233 | 10034.4 |
| 814 | 2024-02-21 13:46:47 | quartz | 3 | 112716 | 211 | 11.703 | 9631.4 |
| 813 | 2024-02-17 15:15:08 | quartz | 2 | 82551 | 23 | 2.670 | 30918.0 |
| 812 | 2024-02-17 15:14:46 | quartz | 3 | 112716 | 211 | 5.906 | 19085.0 |
| 811 | 2024-02-14 18:07:21 | quartz | 3 | 112716 | 211 | 5.736 | 19650.6 |
| 810 | 2024-02-14 18:07:20 | quartz | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 809 | 2024-01-16 15:33:00 | quartz | 2 | 82551 | 23 | 2.110 | 39123.7 |
| 808 | 2024-01-13 02:02:43 | quartz | 3 | 112716 | 211 | 4.703 | 23966.8 |
| 807 | 2024-01-09 19:06:06 | quartz | 2 | 82551 | 23 | 2.656 | 31080.9 |
| 806 | 2024-01-04 21:59:44 | quartz | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 805 | 2023-12-12 19:40:26 | quartz | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 804 | 2023-11-29 06:18:25 | quartz | 3 | 112716 | 211 | 4.860 | 23192.6 |
| 803 | 2023-11-17 03:18:23 | quartz | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 802 | 2023-11-15 22:29:55 | quartz | 2 | 82551 | 23 | 2.030 | 40665.5 |
| 801 | 2023-11-04 01:03:57 | quartz | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 800 | 2023-11-03 19:08:14 | quartz | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 799 | 2023-11-01 02:08:43 | quartz | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 798 | 2023-10-17 16:16:15 | quartz | 3 | 112716 | 211 | 9.406 | 11983.4 |
| 797 | 2023-10-17 14:35:17 | quartz | 2 | 82551 | 23 | 2.546 | 32423.8 |
| 796 | 2023-10-16 12:05:38 | quartz | 3 | 112716 | 211 | 4.736 | 23799.8 |
| 795 | 2023-10-11 00:17:40 | quartz | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 794 | 2023-09-28 04:39:53 | quartz | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 793 | 2023-09-27 05:01:32 | quartz | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 792 | 2023-09-13 16:50:10 | quartz | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 791 | 2023-08-17 15:51:24 | quartz | 2 | 82551 | 23 | 2.390 | 34540.2 |
| 790 | 2023-07-26 09:18:03 | quartz | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 789 | 2023-05-02 17:48:50 | quartz | 2 | 82551 | 23 | 2.343 | 35233.0 |
| 788 | 2023-04-25 19:56:22 | quartz | 1 | 48755 | 5 | 0.706 | 69058.1 |
| 787 | 2023-02-15 13:36:52 | quartz | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 786 | 2023-02-06 03:13:56 | quartz | 2 | 82551 | 23 | 2.283 | 36159.0 |
| 785 | 2023-02-05 16:20:47 | quartz | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 784 | 2022-12-20 09:33:50 | quartz | 1 | 48755 | 5 | 1.546 | 31536.2 |
| 783 | 2022-12-11 21:26:30 | quartz | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 782 | 2022-11-19 02:46:27 | quartz | 2 | 82551 | 23 | 2.030 | 40665.5 |
| 781 | 2022-11-12 22:33:45 | quartz | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 780 | 2022-09-19 09:24:24 | quartz | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 779 | 2022-08-14 22:16:38 | quartz | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 778 | 2022-08-14 14:58:20 | quartz | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 777 | 2022-07-28 23:11:03 | quartz | 1 | 48755 | 5 | 0.716 | 68093.6 |
| 776 | 2022-07-16 13:10:56 | quartz | 3 | 112716 | 211 | 4.453 | 25312.4 |
| 775 | 2022-06-24 00:08:42 | quartz | 2 | 82551 | 23 | 2.046 | 40347.5 |
| 774 | 2022-04-01 16:40:43 | quartz | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 773 | 2022-01-03 06:53:25 | quartz | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 772 | 2021-12-03 06:50:29 | quartz | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 771 | 2021-11-20 05:02:31 | quartz | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 770 | 2021-11-01 15:14:47 | quartz | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 769 | 2021-09-26 10:36:08 | quartz | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 768 | 2021-09-21 12:55:54 | quartz | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 767 | 2021-04-03 05:37:46 | quartz | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 766 | 2021-03-07 18:16:21 | quartz | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 765 | 2021-01-18 05:08:06 | quartz | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 764 | 2021-01-04 01:46:24 | quartz | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 763 | 2020-11-23 20:04:31 | quartz | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 762 | 2020-10-31 01:18:16 | quartz | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 761 | 2020-10-09 21:23:33 | quartz | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 760 | 2020-10-04 04:45:56 | quartz | 1 | 48755 | 5 | 0.703 | 69352.8 |
| 759 | 2020-08-07 18:25:41 | quartz | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 758 | 2020-08-04 12:25:14 | quartz | 1 | 48755 | 5 | 0.720 | 67715.3 |
| 757 | 2020-08-02 21:18:31 | quartz | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 756 | 2020-08-01 23:24:27 | quartz | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 755 | 2020-07-24 06:23:05 | quartz | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 754 | 2020-05-11 07:37:30 | quartz | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 753 | 2020-03-26 12:37:47 | quartz | 1 | 48755 | 5 | 1.623 | 30040.0 |
| 752 | 2020-03-26 01:01:08 | quartz | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 751 | 2020-03-24 02:59:42 | quartz | 1 | 48755 | 5 | 1.000 | 48755.0 |
| 750 | 2020-03-24 02:09:48 | quartz | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 749 | 2020-03-23 18:35:50 | quartz | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 748 | 2020-03-22 00:28:28 | quartz | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 747 | 2020-03-21 11:32:21 | quartz | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 746 | 2020-03-21 07:03:50 | quartz | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 745 | 2020-03-18 03:05:41 | quartz | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 744 | 2020-02-29 23:10:21 | quartz | 3 | 112716 | 211 | 6.940 | 16241.5 |
| 743 | 2020-02-29 22:02:14 | quartz | 3 | 112716 | 211 | 5.033 | 22395.4 |
| 742 | 2020-02-29 17:42:39 | quartz | 3 | 112716 | 211 | 5.876 | 19182.4 |
| 741 | 2020-02-29 16:13:10 | quartz | 1 | 48755 | 5 | 1.686 | 28917.6 |