History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"threes"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 869 | 2024-05-02 19:45:57 | threes | 1 | 48755 | 7 | 1.843 | 26454.2 |
| 868 | 2024-04-29 02:08:51 | threes | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 867 | 2024-04-27 02:58:31 | threes | 1 | 48755 | 7 | 0.936 | 52088.7 |
| 866 | 2024-04-05 02:58:04 | threes | 1 | 48755 | 7 | 2.173 | 22436.7 |
| 865 | 2024-03-31 14:53:17 | threes | 1 | 48755 | 7 | 1.576 | 30935.9 |
| 864 | 2024-03-07 03:10:25 | threes | 1 | 48755 | 7 | 0.906 | 53813.5 |
| 863 | 2024-03-01 09:59:55 | threes | 1 | 48755 | 7 | 0.936 | 52088.7 |
| 862 | 2024-02-28 16:52:38 | threes | 1 | 48755 | 7 | 0.936 | 52088.7 |
| 861 | 2024-02-25 18:53:39 | threes | 1 | 48755 | 7 | 2.826 | 17252.3 |
| 860 | 2024-02-21 22:04:06 | threes | 2 | 82551 | 91 | 3.876 | 21298.0 |
| 859 | 2024-02-21 22:02:57 | threes | 3 | 112716 | 1124 | 6.236 | 18075.0 |
| 858 | 2024-02-21 12:59:18 | threes | 3 | 112716 | 1124 | 13.500 | 8349.3 |
| 857 | 2024-02-18 03:42:11 | threes | 2 | 82551 | 91 | 2.470 | 33421.5 |
| 856 | 2024-02-18 03:31:38 | threes | 3 | 112716 | 1124 | 8.203 | 13740.8 |
| 855 | 2024-02-17 22:57:14 | threes | 2 | 82551 | 91 | 3.890 | 21221.3 |
| 854 | 2024-02-17 21:48:21 | threes | 3 | 112716 | 1124 | 5.750 | 19602.8 |
| 853 | 2024-02-15 05:23:44 | threes | 2 | 82551 | 91 | 5.296 | 15587.4 |
| 852 | 2024-01-09 08:08:41 | threes | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 851 | 2024-01-03 02:04:07 | threes | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 850 | 2023-12-09 16:06:01 | threes | 3 | 112716 | 1124 | 5.330 | 21147.5 |
| 849 | 2023-12-09 16:06:03 | threes | 2 | 82551 | 91 | 2.500 | 33020.4 |
| 848 | 2023-11-20 08:12:31 | threes | 3 | 112716 | 1124 | 4.830 | 23336.6 |
| 847 | 2023-11-20 08:12:30 | threes | 2 | 82551 | 91 | 2.296 | 35954.3 |
| 846 | 2023-11-20 08:10:49 | threes | 3 | 112716 | 1124 | 5.750 | 19602.8 |
| 845 | 2023-11-20 08:10:51 | threes | 2 | 82551 | 91 | 2.576 | 32046.2 |
| 844 | 2023-11-17 15:58:28 | threes | 3 | 112716 | 1124 | 4.656 | 24208.8 |
| 843 | 2023-11-12 17:47:09 | threes | 2 | 82551 | 91 | 2.060 | 40073.3 |
| 842 | 2023-11-11 04:12:24 | threes | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 841 | 2023-11-09 09:40:39 | threes | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 840 | 2023-11-02 01:42:16 | threes | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 839 | 2023-10-27 02:48:29 | threes | 1 | 48755 | 7 | 1.483 | 32875.9 |
| 838 | 2023-10-20 16:53:12 | threes | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 837 | 2023-10-18 04:01:48 | threes | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 836 | 2023-10-11 04:35:22 | threes | 1 | 48755 | 7 | 0.810 | 60191.4 |
| 835 | 2023-10-04 09:34:16 | threes | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 834 | 2023-09-24 05:32:20 | threes | 1 | 48755 | 7 | 0.793 | 61481.7 |
| 833 | 2023-09-23 20:55:05 | threes | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 832 | 2023-09-23 20:52:24 | threes | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 831 | 2023-09-14 05:48:52 | threes | 3 | 112716 | 1124 | 4.983 | 22620.1 |
| 830 | 2023-09-14 05:48:53 | threes | 2 | 82551 | 91 | 2.343 | 35233.0 |
| 829 | 2023-09-10 14:11:04 | threes | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 828 | 2023-08-24 04:19:01 | threes | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 827 | 2023-08-18 22:33:45 | threes | 3 | 112716 | 1124 | 4.640 | 24292.2 |
| 826 | 2023-08-15 23:20:18 | threes | 2 | 82551 | 91 | 2.076 | 39764.5 |
| 825 | 2023-05-31 14:01:31 | threes | 1 | 48755 | 7 | 0.736 | 66243.2 |
| 824 | 2023-05-27 00:36:35 | threes | 1 | 48755 | 7 | 0.716 | 68093.6 |
| 823 | 2023-05-02 00:27:41 | threes | 2 | 82551 | 91 | 2.170 | 38041.9 |
| 822 | 2023-05-01 07:19:36 | threes | 3 | 112716 | 1124 | 4.606 | 24471.6 |
| 821 | 2023-03-23 14:50:00 | threes | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 820 | 2023-02-05 11:10:55 | threes | 2 | 82551 | 91 | 2.046 | 40347.5 |
| 819 | 2023-02-05 06:40:58 | threes | 3 | 112716 | 1124 | 4.546 | 24794.5 |
| 818 | 2023-01-29 02:25:02 | threes | 1 | 48755 | 7 | 0.716 | 68093.6 |
| 817 | 2023-01-13 23:57:10 | threes | 3 | 112716 | 1124 | 5.110 | 22057.9 |
| 816 | 2023-01-07 21:54:30 | threes | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 815 | 2022-12-29 17:17:49 | threes | 1 | 48755 | 7 | 0.810 | 60191.4 |
| 814 | 2022-12-12 00:45:03 | threes | 3 | 112716 | 1124 | 4.720 | 23880.5 |
| 813 | 2022-11-25 23:03:28 | threes | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 812 | 2022-11-16 19:45:39 | threes | 2 | 82551 | 91 | 2.576 | 32046.2 |
| 811 | 2022-11-16 11:44:16 | threes | 3 | 112716 | 1124 | 4.673 | 24120.7 |
| 810 | 2022-10-07 07:27:22 | threes | 1 | 48755 | 7 | 0.720 | 67715.3 |
| 809 | 2022-09-30 06:25:04 | threes | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 808 | 2022-06-19 01:27:07 | threes | 2 | 82551 | 91 | 2.123 | 38884.1 |
| 807 | 2022-06-18 14:19:43 | threes | 3 | 112716 | 1124 | 4.593 | 24540.8 |
| 806 | 2022-05-24 00:13:03 | threes | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 805 | 2022-05-22 16:38:26 | threes | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 804 | 2022-05-20 14:17:58 | threes | 1 | 48755 | 7 | 0.983 | 49598.2 |
| 803 | 2022-05-17 02:16:05 | threes | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 802 | 2022-02-06 05:58:07 | threes | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 801 | 2022-01-25 23:10:23 | threes | 1 | 48755 | 7 | 0.876 | 55656.4 |
| 800 | 2021-12-02 04:57:27 | threes | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 799 | 2021-11-30 03:05:20 | threes | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 798 | 2021-10-12 14:24:44 | threes | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 797 | 2021-10-11 16:14:28 | threes | 1 | 48755 | 7 | 0.923 | 52822.3 |
| 796 | 2021-10-09 14:09:57 | threes | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 795 | 2021-09-30 23:14:08 | threes | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 794 | 2021-09-28 18:33:18 | threes | 1 | 48755 | 7 | 1.560 | 31253.2 |
| 793 | 2021-09-27 20:57:53 | threes | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 792 | 2021-09-21 08:36:41 | threes | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 791 | 2021-09-20 09:49:50 | threes | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 790 | 2021-09-18 10:38:18 | threes | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 789 | 2021-09-14 01:21:12 | threes | 1 | 48755 | 7 | 0.736 | 66243.2 |
| 788 | 2021-09-12 02:29:16 | threes | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 787 | 2021-08-30 21:14:46 | threes | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 786 | 2021-07-11 11:45:01 | threes | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 785 | 2021-04-30 05:46:08 | threes | 3 | 112716 | 1124 | 5.343 | 21096.0 |
| 784 | 2021-04-30 05:45:59 | threes | 2 | 82551 | 91 | 2.626 | 31436.0 |
| 783 | 2021-04-30 01:58:38 | threes | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 782 | 2021-04-18 16:30:00 | threes | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 781 | 2021-04-17 18:23:21 | threes | 1 | 48755 | 7 | 1.093 | 44606.6 |
| 780 | 2021-04-07 13:06:54 | threes | 1 | 48755 | 7 | 0.876 | 55656.4 |
| 779 | 2021-04-05 03:50:56 | threes | 3 | 112716 | 1124 | 6.016 | 18736.0 |
| 778 | 2021-04-03 09:27:20 | threes | 1 | 48755 | 7 | 0.736 | 66243.2 |
| 777 | 2021-02-22 21:14:04 | threes | 3 | 112716 | 1124 | 4.606 | 24471.6 |
| 776 | 2021-02-22 10:20:31 | threes | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 775 | 2021-02-04 14:45:55 | threes | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 774 | 2021-01-20 09:00:57 | threes | 3 | 112716 | 1124 | 6.736 | 16733.4 |
| 773 | 2020-12-11 06:28:03 | threes | 1 | 48755 | 7 | 0.736 | 66243.2 |
| 772 | 2020-12-11 05:55:42 | threes | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 771 | 2020-11-10 04:12:48 | threes | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 770 | 2020-10-31 13:42:15 | threes | 3 | 112716 | 1124 | 6.846 | 16464.5 |