History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sappy"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 960 | 2024-04-03 05:54:03 | sappy | 1 | 28756 | 8 | 1.843 | 15602.8 |
| 959 | 2024-03-31 03:22:41 | sappy | 1 | 28756 | 8 | 0.593 | 48492.4 |
| 958 | 2024-03-29 01:33:07 | sappy | 2 | 53800 | 82 | 1.796 | 29955.5 |
| 957 | 2024-03-29 01:33:05 | sappy | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 956 | 2024-03-29 01:32:37 | sappy | 3 | 83667 | 1066 | 6.500 | 12871.8 |
| 955 | 2024-03-28 23:42:48 | sappy | 3 | 83667 | 1066 | 10.860 | 7704.1 |
| 954 | 2024-03-28 23:42:48 | sappy | 2 | 53800 | 82 | 5.953 | 9037.5 |
| 953 | 2024-03-28 23:24:56 | sappy | 1 | 28756 | 8 | 1.140 | 25224.6 |
| 952 | 2024-03-28 10:23:26 | sappy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 951 | 2024-03-10 17:35:03 | sappy | 2 | 53800 | 82 | 1.876 | 28678.0 |
| 950 | 2024-03-06 03:19:57 | sappy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 949 | 2024-03-03 21:16:05 | sappy | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 948 | 2024-03-01 00:04:32 | sappy | 1 | 28756 | 8 | 0.563 | 51076.4 |
| 947 | 2024-02-29 03:13:06 | sappy | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 946 | 2024-02-28 16:51:58 | sappy | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 945 | 2024-02-28 04:48:22 | sappy | 3 | 83667 | 1066 | 10.936 | 7650.6 |
| 944 | 2024-02-27 22:35:31 | sappy | 2 | 53800 | 82 | 3.766 | 14285.7 |
| 943 | 2024-02-27 22:35:04 | sappy | 3 | 83667 | 1066 | 4.703 | 17790.1 |
| 942 | 2024-02-27 22:33:51 | sappy | 3 | 83667 | 1066 | 4.516 | 18526.8 |
| 941 | 2024-02-27 22:33:50 | sappy | 2 | 53800 | 82 | 1.873 | 28724.0 |
| 940 | 2024-02-27 20:54:08 | sappy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 939 | 2024-01-28 20:51:59 | sappy | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 938 | 2024-01-19 03:30:18 | sappy | 3 | 83667 | 1066 | 3.420 | 24464.0 |
| 937 | 2023-12-25 12:10:13 | sappy | 3 | 83667 | 1066 | 3.610 | 23176.5 |
| 936 | 2023-12-25 12:10:09 | sappy | 2 | 53800 | 82 | 1.660 | 32409.6 |
| 935 | 2023-12-17 10:48:02 | sappy | 3 | 83667 | 1066 | 3.796 | 22040.8 |
| 934 | 2023-12-09 04:25:17 | sappy | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 933 | 2023-11-27 05:23:50 | sappy | 2 | 53800 | 82 | 1.670 | 32215.6 |
| 932 | 2023-11-18 21:40:06 | sappy | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 931 | 2023-11-12 08:32:57 | sappy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 930 | 2023-11-10 00:07:35 | sappy | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 929 | 2023-11-03 10:36:48 | sappy | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 928 | 2023-10-30 20:49:49 | sappy | 3 | 83667 | 1066 | 4.110 | 20356.9 |
| 927 | 2023-10-29 02:30:58 | sappy | 3 | 83667 | 1066 | 3.953 | 21165.4 |
| 926 | 2023-10-20 09:41:25 | sappy | 1 | 28756 | 8 | 0.640 | 44931.3 |
| 925 | 2023-10-19 21:59:22 | sappy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 924 | 2023-10-14 01:19:20 | sappy | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 923 | 2023-10-05 02:39:19 | sappy | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 922 | 2023-09-26 13:18:45 | sappy | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 921 | 2023-09-25 02:19:52 | sappy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 920 | 2023-09-20 18:20:29 | sappy | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 919 | 2023-08-26 17:58:04 | sappy | 2 | 53800 | 82 | 1.670 | 32215.6 |
| 918 | 2023-08-05 14:38:27 | sappy | 3 | 83667 | 1066 | 3.410 | 24535.8 |
| 917 | 2023-07-22 18:13:32 | sappy | 1 | 28756 | 8 | 0.456 | 63061.4 |
| 916 | 2023-07-15 03:41:24 | sappy | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 915 | 2023-05-10 17:02:48 | sappy | 2 | 53800 | 82 | 1.610 | 33416.1 |
| 914 | 2023-04-23 09:15:12 | sappy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 913 | 2023-04-19 21:16:52 | sappy | 3 | 83667 | 1066 | 3.296 | 25384.4 |
| 912 | 2023-03-20 12:34:53 | sappy | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 911 | 2023-02-18 02:29:19 | sappy | 2 | 53800 | 82 | 1.610 | 33416.1 |
| 910 | 2023-02-15 12:07:52 | sappy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 909 | 2023-01-25 23:36:42 | sappy | 3 | 83667 | 1066 | 3.330 | 25125.2 |
| 908 | 2022-12-13 05:51:22 | sappy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 907 | 2022-12-01 06:09:42 | sappy | 2 | 53800 | 82 | 1.390 | 38705.0 |
| 906 | 2022-11-22 09:19:48 | sappy | 1 | 28756 | 8 | 0.610 | 47141.0 |
| 905 | 2022-11-08 19:27:12 | sappy | 3 | 83667 | 1066 | 3.420 | 24464.0 |
| 904 | 2022-10-17 14:00:04 | sappy | 2 | 53800 | 82 | 1.546 | 34799.5 |
| 903 | 2022-09-05 07:21:56 | sappy | 2 | 53800 | 82 | 1.486 | 36204.6 |
| 902 | 2022-09-04 00:41:42 | sappy | 2 | 53800 | 82 | 1.393 | 38621.7 |
| 901 | 2022-08-28 22:25:46 | sappy | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 900 | 2022-08-20 10:36:06 | sappy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 899 | 2022-08-18 15:14:39 | sappy | 1 | 28756 | 8 | 0.450 | 63902.2 |
| 898 | 2022-08-02 12:57:19 | sappy | 2 | 53800 | 82 | 1.593 | 33772.8 |
| 897 | 2022-07-29 14:20:25 | sappy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 896 | 2022-07-26 09:06:49 | sappy | 1 | 28756 | 8 | 0.456 | 63061.4 |
| 895 | 2022-07-26 04:04:49 | sappy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 894 | 2022-07-08 17:05:46 | sappy | 2 | 53800 | 82 | 1.580 | 34050.6 |
| 893 | 2022-06-13 22:51:44 | sappy | 3 | 83667 | 1066 | 3.393 | 24658.7 |
| 892 | 2022-06-11 13:24:57 | sappy | 3 | 83667 | 1066 | 3.423 | 24442.6 |
| 891 | 2022-05-08 14:38:33 | sappy | 3 | 83667 | 1066 | 3.923 | 21327.3 |
| 890 | 2022-04-02 06:48:51 | sappy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 889 | 2022-03-25 14:52:02 | sappy | 3 | 83667 | 1066 | 4.216 | 19845.1 |
| 888 | 2022-03-24 19:30:09 | sappy | 1 | 28756 | 8 | 0.466 | 61708.2 |
| 887 | 2022-02-01 21:03:05 | sappy | 3 | 83667 | 1066 | 3.876 | 21585.9 |
| 886 | 2022-01-20 08:55:21 | sappy | 1 | 28756 | 8 | 0.530 | 54256.6 |
| 885 | 2022-01-03 22:34:40 | sappy | 1 | 28756 | 8 | 1.046 | 27491.4 |
| 884 | 2022-01-01 18:11:39 | sappy | 1 | 28756 | 8 | 0.533 | 53951.2 |
| 883 | 2021-12-09 04:22:05 | sappy | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 882 | 2021-12-04 04:36:26 | sappy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 881 | 2021-11-30 18:31:39 | sappy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 880 | 2021-11-07 05:23:16 | sappy | 3 | 83667 | 1066 | 3.343 | 25027.5 |
| 879 | 2021-10-27 02:02:18 | sappy | 1 | 28756 | 8 | 0.466 | 61708.2 |
| 878 | 2021-09-15 05:56:42 | sappy | 1 | 28756 | 8 | 1.046 | 27491.4 |
| 877 | 2021-08-28 16:40:05 | sappy | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 876 | 2021-08-26 11:46:25 | sappy | 1 | 28756 | 8 | 0.466 | 61708.2 |
| 875 | 2021-08-21 01:24:45 | sappy | 1 | 28756 | 8 | 0.466 | 61708.2 |
| 874 | 2021-08-17 17:55:19 | sappy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 873 | 2021-07-24 23:57:10 | sappy | 2 | 53800 | 82 | 1.423 | 37807.4 |
| 872 | 2021-05-31 04:23:55 | sappy | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 871 | 2021-05-15 04:22:14 | sappy | 2 | 53800 | 82 | 1.466 | 36698.5 |
| 870 | 2021-05-13 18:23:02 | sappy | 1 | 28756 | 8 | 0.593 | 48492.4 |
| 869 | 2021-05-05 23:32:53 | sappy | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 868 | 2021-04-14 07:48:09 | sappy | 2 | 53800 | 82 | 1.686 | 31909.8 |
| 867 | 2021-04-04 02:43:47 | sappy | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 866 | 2021-02-23 18:25:19 | sappy | 3 | 83667 | 1066 | 3.470 | 24111.5 |
| 865 | 2021-02-20 20:07:08 | sappy | 2 | 53800 | 82 | 1.486 | 36204.6 |
| 864 | 2021-02-15 04:32:08 | sappy | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 863 | 2021-01-31 15:10:47 | sappy | 1 | 28756 | 8 | 0.653 | 44036.8 |
| 862 | 2021-01-19 10:18:44 | sappy | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 861 | 2020-11-24 14:28:07 | sappy | 1 | 28756 | 8 | 0.453 | 63479.0 |