History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prawn"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 895 | 2024-04-08 02:29:40 | prawn | 1 | 28756 | 5 | 1.220 | 23570.5 |
| 894 | 2024-04-03 06:05:52 | prawn | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 893 | 2024-03-31 06:39:23 | prawn | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 892 | 2024-03-31 03:23:28 | prawn | 2 | 53800 | 83 | 5.643 | 9533.9 |
| 891 | 2024-03-31 03:22:12 | prawn | 3 | 83667 | 962 | 4.250 | 19686.4 |
| 890 | 2024-03-30 20:10:26 | prawn | 3 | 83667 | 962 | 4.953 | 16892.2 |
| 889 | 2024-03-30 19:53:10 | prawn | 2 | 53800 | 83 | 6.046 | 8898.4 |
| 888 | 2024-03-30 09:40:43 | prawn | 2 | 53800 | 83 | 3.063 | 17564.5 |
| 887 | 2024-03-30 09:40:12 | prawn | 3 | 83667 | 962 | 4.780 | 17503.6 |
| 886 | 2024-03-29 18:06:49 | prawn | 3 | 83667 | 962 | 4.330 | 19322.6 |
| 885 | 2024-03-29 18:06:50 | prawn | 2 | 53800 | 83 | 1.813 | 29674.6 |
| 884 | 2024-03-28 18:24:43 | prawn | 1 | 28756 | 5 | 0.640 | 44931.3 |
| 883 | 2024-03-28 09:29:03 | prawn | 1 | 28756 | 5 | 1.110 | 25906.3 |
| 882 | 2024-03-04 01:09:59 | prawn | 2 | 53800 | 83 | 4.330 | 12424.9 |
| 881 | 2024-03-04 01:09:52 | prawn | 3 | 83667 | 962 | 10.530 | 7945.6 |
| 880 | 2024-03-04 01:09:27 | prawn | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 879 | 2024-03-01 00:36:44 | prawn | 1 | 28756 | 5 | 0.563 | 51076.4 |
| 878 | 2024-02-28 19:05:45 | prawn | 2 | 53800 | 83 | 1.563 | 34421.0 |
| 877 | 2024-02-28 18:16:11 | prawn | 3 | 83667 | 962 | 4.266 | 19612.5 |
| 876 | 2024-02-28 10:53:11 | prawn | 2 | 53800 | 83 | 3.330 | 16156.2 |
| 875 | 2024-02-28 10:52:42 | prawn | 3 | 83667 | 962 | 7.203 | 11615.6 |
| 874 | 2024-02-28 10:38:23 | prawn | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 873 | 2024-02-28 09:42:17 | prawn | 3 | 83667 | 962 | 9.186 | 9108.1 |
| 872 | 2024-02-28 09:42:19 | prawn | 2 | 53800 | 83 | 5.656 | 9512.0 |
| 871 | 2024-02-26 19:31:40 | prawn | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 870 | 2024-02-03 00:13:43 | prawn | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 869 | 2024-01-28 21:57:39 | prawn | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 868 | 2024-01-27 14:41:40 | prawn | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 867 | 2024-01-02 17:40:45 | prawn | 3 | 83667 | 962 | 4.016 | 20833.4 |
| 866 | 2023-12-26 12:19:22 | prawn | 3 | 83667 | 962 | 3.296 | 25384.4 |
| 865 | 2023-12-26 12:19:20 | prawn | 2 | 53800 | 83 | 1.390 | 38705.0 |
| 864 | 2023-12-08 11:23:31 | prawn | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 863 | 2023-12-05 18:30:21 | prawn | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 862 | 2023-11-24 15:38:29 | prawn | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 861 | 2023-11-12 17:23:36 | prawn | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 860 | 2023-11-10 12:08:00 | prawn | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 859 | 2023-10-27 18:16:35 | prawn | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 858 | 2023-10-24 13:48:51 | prawn | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 857 | 2023-10-11 07:39:01 | prawn | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 856 | 2023-10-08 23:58:32 | prawn | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 855 | 2023-09-24 15:08:18 | prawn | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 854 | 2023-09-22 01:42:30 | prawn | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 853 | 2023-09-20 12:38:42 | prawn | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 852 | 2023-07-21 00:29:50 | prawn | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 851 | 2023-07-16 10:22:40 | prawn | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 850 | 2023-04-21 16:24:29 | prawn | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 849 | 2023-03-12 09:08:20 | prawn | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 848 | 2023-02-12 13:45:02 | prawn | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 847 | 2022-12-11 02:16:52 | prawn | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 846 | 2022-12-01 15:43:46 | prawn | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 845 | 2022-11-17 09:45:13 | prawn | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 844 | 2022-11-17 09:40:07 | prawn | 1 | 28756 | 5 | 0.560 | 51350.0 |
| 843 | 2022-11-03 01:11:37 | prawn | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 842 | 2022-08-23 21:42:23 | prawn | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 841 | 2022-08-20 00:29:13 | prawn | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 840 | 2022-08-15 19:37:36 | prawn | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 839 | 2022-08-13 14:17:45 | prawn | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 838 | 2022-07-29 13:17:33 | prawn | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 837 | 2022-07-17 15:28:33 | prawn | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 836 | 2022-06-18 04:21:05 | prawn | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 835 | 2022-04-02 13:10:27 | prawn | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 834 | 2022-03-03 19:36:30 | prawn | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 833 | 2022-02-08 14:27:23 | prawn | 3 | 83667 | 962 | 3.606 | 23202.2 |
| 832 | 2022-02-03 00:45:56 | prawn | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 831 | 2022-01-17 13:47:13 | prawn | 3 | 83667 | 962 | 3.750 | 22311.2 |
| 830 | 2022-01-16 13:47:10 | prawn | 3 | 83667 | 962 | 3.393 | 24658.7 |
| 829 | 2022-01-15 13:51:43 | prawn | 3 | 83667 | 962 | 3.890 | 21508.2 |
| 828 | 2022-01-14 13:40:12 | prawn | 3 | 83667 | 962 | 3.470 | 24111.5 |
| 827 | 2022-01-13 14:13:33 | prawn | 3 | 83667 | 962 | 3.576 | 23396.8 |
| 826 | 2022-01-12 13:05:25 | prawn | 3 | 83667 | 962 | 3.780 | 22134.1 |
| 825 | 2022-01-11 13:02:46 | prawn | 3 | 83667 | 962 | 4.033 | 20745.6 |
| 824 | 2022-01-10 13:01:34 | prawn | 3 | 83667 | 962 | 3.920 | 21343.6 |
| 823 | 2022-01-09 12:56:19 | prawn | 3 | 83667 | 962 | 4.220 | 19826.3 |
| 822 | 2022-01-08 12:56:01 | prawn | 3 | 83667 | 962 | 3.876 | 21585.9 |
| 821 | 2022-01-08 11:18:15 | prawn | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 820 | 2022-01-07 12:53:10 | prawn | 3 | 83667 | 962 | 3.860 | 21675.4 |
| 819 | 2022-01-06 12:49:58 | prawn | 3 | 83667 | 962 | 4.186 | 19987.3 |
| 818 | 2022-01-05 12:51:27 | prawn | 3 | 83667 | 962 | 4.233 | 19765.4 |
| 817 | 2022-01-04 12:44:46 | prawn | 3 | 83667 | 962 | 4.060 | 20607.6 |
| 816 | 2021-12-30 04:41:09 | prawn | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 815 | 2021-12-24 15:01:30 | prawn | 3 | 83667 | 962 | 8.406 | 9953.2 |
| 814 | 2021-12-23 22:22:55 | prawn | 3 | 83667 | 962 | 4.170 | 20064.0 |
| 813 | 2021-12-23 13:42:00 | prawn | 3 | 83667 | 962 | 4.266 | 19612.5 |
| 812 | 2021-12-23 13:25:55 | prawn | 3 | 83667 | 962 | 3.950 | 21181.5 |
| 811 | 2021-12-23 01:34:18 | prawn | 3 | 83667 | 962 | 3.830 | 21845.2 |
| 810 | 2021-12-22 14:10:09 | prawn | 3 | 83667 | 962 | 3.966 | 21096.1 |
| 809 | 2021-12-22 13:38:11 | prawn | 3 | 83667 | 962 | 5.670 | 14756.1 |
| 808 | 2021-12-22 02:50:38 | prawn | 3 | 83667 | 962 | 4.000 | 20916.8 |
| 807 | 2021-12-21 19:00:34 | prawn | 3 | 83667 | 962 | 4.406 | 18989.3 |
| 806 | 2021-12-21 13:36:08 | prawn | 3 | 83667 | 962 | 8.343 | 10028.4 |
| 805 | 2021-12-21 07:10:00 | prawn | 3 | 83667 | 962 | 3.296 | 25384.4 |
| 804 | 2021-12-20 16:09:50 | prawn | 3 | 83667 | 962 | 3.890 | 21508.2 |
| 803 | 2021-12-20 11:06:38 | prawn | 3 | 83667 | 962 | 8.250 | 10141.5 |
| 802 | 2021-12-20 04:17:49 | prawn | 3 | 83667 | 962 | 3.893 | 21491.7 |
| 801 | 2021-12-19 17:05:44 | prawn | 3 | 83667 | 962 | 3.720 | 22491.1 |
| 800 | 2021-12-19 11:14:21 | prawn | 3 | 83667 | 962 | 4.483 | 18663.2 |
| 799 | 2021-12-19 06:15:00 | prawn | 3 | 83667 | 962 | 3.343 | 25027.5 |
| 798 | 2021-12-18 19:40:26 | prawn | 3 | 83667 | 962 | 4.126 | 20278.0 |
| 797 | 2021-12-18 11:00:57 | prawn | 3 | 83667 | 962 | 3.843 | 21771.3 |
| 796 | 2021-12-17 21:11:50 | prawn | 3 | 83667 | 962 | 4.283 | 19534.7 |