History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"giant"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 898 | 2024-05-01 06:00:23 | giant | 1 | 28756 | 4 | 1.063 | 27051.7 |
| 897 | 2024-04-29 22:58:53 | giant | 1 | 28756 | 4 | 0.503 | 57169.0 |
| 896 | 2024-04-27 21:19:29 | giant | 3 | 83667 | 1259 | 9.626 | 8691.8 |
| 895 | 2024-04-27 18:05:48 | giant | 2 | 53800 | 88 | 1.856 | 28987.1 |
| 894 | 2024-04-27 12:01:50 | giant | 1 | 28756 | 4 | 0.936 | 30722.2 |
| 893 | 2024-04-24 23:47:45 | giant | 2 | 53800 | 88 | 4.280 | 12570.1 |
| 892 | 2024-04-24 23:47:34 | giant | 3 | 83667 | 1259 | 3.796 | 22040.8 |
| 891 | 2024-04-23 22:13:07 | giant | 2 | 53800 | 88 | 6.640 | 8102.4 |
| 890 | 2024-04-23 22:11:29 | giant | 3 | 83667 | 1259 | 4.216 | 19845.1 |
| 889 | 2024-04-20 18:04:24 | giant | 3 | 83667 | 1259 | 3.436 | 24350.1 |
| 888 | 2024-04-16 11:40:49 | giant | 1 | 28756 | 4 | 0.470 | 61183.0 |
| 887 | 2024-04-04 20:05:13 | giant | 2 | 53800 | 88 | 4.143 | 12985.8 |
| 886 | 2024-04-04 20:02:06 | giant | 3 | 83667 | 1259 | 10.110 | 8275.7 |
| 885 | 2024-04-04 03:44:26 | giant | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 884 | 2024-04-04 03:44:25 | giant | 2 | 53800 | 88 | 1.686 | 31909.8 |
| 883 | 2024-04-04 03:43:58 | giant | 3 | 83667 | 1259 | 5.420 | 15436.7 |
| 882 | 2024-04-03 11:24:38 | giant | 3 | 83667 | 1259 | 4.720 | 17726.1 |
| 881 | 2024-04-03 11:24:35 | giant | 2 | 53800 | 88 | 5.580 | 9641.6 |
| 880 | 2024-04-03 11:24:27 | giant | 1 | 28756 | 4 | 1.076 | 26724.9 |
| 879 | 2024-03-31 15:36:24 | giant | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 878 | 2024-03-28 20:27:01 | giant | 3 | 83667 | 1259 | 3.953 | 21165.4 |
| 877 | 2024-03-28 20:26:59 | giant | 2 | 53800 | 88 | 1.673 | 32157.8 |
| 876 | 2024-03-28 20:26:54 | giant | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 875 | 2024-03-05 18:04:04 | giant | 3 | 83667 | 1259 | 7.080 | 11817.4 |
| 874 | 2024-03-04 23:22:32 | giant | 2 | 53800 | 88 | 1.626 | 33087.3 |
| 873 | 2024-03-04 23:22:29 | giant | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 872 | 2024-03-04 23:22:07 | giant | 3 | 83667 | 1259 | 8.703 | 9613.6 |
| 871 | 2024-03-04 16:14:28 | giant | 3 | 83667 | 1259 | 7.860 | 10644.7 |
| 870 | 2024-03-04 09:11:06 | giant | 3 | 83667 | 1259 | 4.203 | 19906.5 |
| 869 | 2024-03-04 09:11:09 | giant | 2 | 53800 | 88 | 1.750 | 30742.9 |
| 868 | 2024-03-04 06:45:29 | giant | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 867 | 2024-03-01 12:26:57 | giant | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 866 | 2024-02-25 19:10:59 | giant | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 865 | 2024-02-03 04:10:39 | giant | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 864 | 2024-01-29 00:07:47 | giant | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 863 | 2024-01-26 06:30:09 | giant | 1 | 28756 | 4 | 0.876 | 32826.5 |
| 862 | 2024-01-18 10:30:24 | giant | 2 | 53800 | 88 | 1.406 | 38264.6 |
| 861 | 2023-12-31 23:24:40 | giant | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 860 | 2023-12-29 12:59:19 | giant | 3 | 83667 | 1259 | 3.393 | 24658.7 |
| 859 | 2023-12-23 22:10:57 | giant | 3 | 83667 | 1259 | 5.326 | 15709.2 |
| 858 | 2023-12-23 22:10:53 | giant | 2 | 53800 | 88 | 1.376 | 39098.8 |
| 857 | 2023-12-20 16:19:10 | giant | 1 | 28756 | 4 | 0.563 | 51076.4 |
| 856 | 2023-12-15 13:44:14 | giant | 3 | 83667 | 1259 | 3.373 | 24804.9 |
| 855 | 2023-11-26 11:33:17 | giant | 3 | 83667 | 1259 | 4.030 | 20761.0 |
| 854 | 2023-11-26 11:33:19 | giant | 2 | 53800 | 88 | 1.606 | 33499.4 |
| 853 | 2023-11-15 14:04:42 | giant | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 852 | 2023-11-12 16:13:55 | giant | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 851 | 2023-11-09 21:32:39 | giant | 1 | 28756 | 4 | 0.516 | 55728.7 |
| 850 | 2023-11-02 07:33:02 | giant | 3 | 83667 | 1259 | 3.860 | 21675.4 |
| 849 | 2023-10-28 05:37:25 | giant | 2 | 53800 | 88 | 3.390 | 15870.2 |
| 848 | 2023-10-26 02:08:57 | giant | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 847 | 2023-10-25 13:47:36 | giant | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 846 | 2023-10-25 11:52:36 | giant | 2 | 53800 | 88 | 1.360 | 39558.8 |
| 845 | 2023-10-23 05:55:40 | giant | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 844 | 2023-10-20 12:37:41 | giant | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 843 | 2023-10-17 05:28:08 | giant | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 842 | 2023-10-11 23:52:31 | giant | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 841 | 2023-10-03 22:37:14 | giant | 1 | 28756 | 4 | 0.466 | 61708.2 |
| 840 | 2023-09-27 18:38:40 | giant | 3 | 83667 | 1259 | 7.296 | 11467.5 |
| 839 | 2023-09-22 22:34:29 | giant | 1 | 28756 | 4 | 0.423 | 67981.1 |
| 838 | 2023-09-14 07:04:46 | giant | 3 | 83667 | 1259 | 3.546 | 23594.8 |
| 837 | 2023-09-11 01:56:09 | giant | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 836 | 2023-08-17 22:51:38 | giant | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 835 | 2023-08-04 04:45:18 | giant | 2 | 53800 | 88 | 1.546 | 34799.5 |
| 834 | 2023-08-02 02:08:02 | giant | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 833 | 2023-06-12 17:16:16 | giant | 3 | 83667 | 1259 | 3.280 | 25508.2 |
| 832 | 2023-06-05 14:50:51 | giant | 3 | 83667 | 1259 | 3.186 | 26260.8 |
| 831 | 2023-05-22 00:17:47 | giant | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 830 | 2023-04-26 04:21:20 | giant | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 829 | 2023-04-24 16:11:44 | giant | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 828 | 2023-04-12 09:31:31 | giant | 2 | 53800 | 88 | 1.576 | 34137.1 |
| 827 | 2023-03-18 10:33:23 | giant | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 826 | 2023-03-17 12:41:45 | giant | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 825 | 2023-03-10 21:00:05 | giant | 3 | 83667 | 1259 | 3.703 | 22594.4 |
| 824 | 2023-01-23 12:14:09 | giant | 3 | 83667 | 1259 | 3.170 | 26393.4 |
| 823 | 2023-01-19 03:34:15 | giant | 2 | 53800 | 88 | 1.343 | 40059.6 |
| 822 | 2023-01-12 07:40:26 | giant | 1 | 28756 | 4 | 0.470 | 61183.0 |
| 821 | 2023-01-04 01:44:05 | giant | 1 | 28756 | 4 | 0.466 | 61708.2 |
| 820 | 2022-12-15 23:02:09 | giant | 3 | 83667 | 1259 | 3.296 | 25384.4 |
| 819 | 2022-12-09 07:04:51 | giant | 3 | 83667 | 1259 | 4.483 | 18663.2 |
| 818 | 2022-11-16 14:03:26 | giant | 3 | 83667 | 1259 | 3.826 | 21868.0 |
| 817 | 2022-11-15 18:08:34 | giant | 3 | 83667 | 1259 | 3.296 | 25384.4 |
| 816 | 2022-11-13 10:31:00 | giant | 3 | 83667 | 1259 | 3.936 | 21256.9 |
| 815 | 2022-11-08 12:15:30 | giant | 3 | 83667 | 1259 | 6.640 | 12600.5 |
| 814 | 2022-10-30 00:23:48 | giant | 2 | 53800 | 88 | 1.330 | 40451.1 |
| 813 | 2022-10-27 23:45:40 | giant | 3 | 83667 | 1259 | 3.906 | 21420.1 |
| 812 | 2022-10-06 09:39:47 | giant | 3 | 83667 | 1259 | 3.956 | 21149.4 |
| 811 | 2022-09-30 10:33:57 | giant | 3 | 83667 | 1259 | 3.280 | 25508.2 |
| 810 | 2022-09-28 12:23:26 | giant | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 809 | 2022-09-24 18:56:50 | giant | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 808 | 2022-09-21 04:41:45 | giant | 1 | 28756 | 4 | 0.546 | 52666.7 |
| 807 | 2022-09-14 19:25:59 | giant | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 806 | 2022-09-12 06:03:15 | giant | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 805 | 2022-09-03 18:57:11 | giant | 1 | 28756 | 4 | 0.440 | 65354.5 |
| 804 | 2022-09-03 10:11:22 | giant | 3 | 83667 | 1259 | 3.233 | 25879.1 |
| 803 | 2022-08-08 02:19:32 | giant | 2 | 53800 | 88 | 1.533 | 35094.6 |
| 802 | 2022-08-08 02:18:59 | giant | 3 | 83667 | 1259 | 3.250 | 25743.7 |
| 801 | 2022-08-06 22:18:43 | giant | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 800 | 2022-08-06 16:31:01 | giant | 3 | 83667 | 1259 | 3.250 | 25743.7 |
| 799 | 2022-07-03 08:51:12 | giant | 1 | 28756 | 4 | 0.423 | 67981.1 |