History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"habit"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1032 | 2024-04-27 22:58:04 | habit | 1 | 28756 | 2 | 1.156 | 24875.4 |
| 1031 | 2024-04-27 21:49:45 | habit | 1 | 28756 | 2 | 2.623 | 10963.0 |
| 1030 | 2024-04-18 19:33:19 | habit | 1 | 28756 | 2 | 0.546 | 52666.7 |
| 1029 | 2024-04-06 06:06:04 | habit | 1 | 28756 | 2 | 0.530 | 54256.6 |
| 1028 | 2024-03-31 18:30:42 | habit | 1 | 28756 | 2 | 0.546 | 52666.7 |
| 1027 | 2024-03-29 09:04:31 | habit | 1 | 28756 | 2 | 0.546 | 52666.7 |
| 1026 | 2024-03-07 06:20:53 | habit | 2 | 53800 | 68 | 1.780 | 30224.7 |
| 1025 | 2024-03-07 03:04:18 | habit | 1 | 28756 | 2 | 0.516 | 55728.7 |
| 1024 | 2024-03-06 21:45:03 | habit | 3 | 83667 | 1048 | 8.796 | 9511.9 |
| 1023 | 2024-03-06 11:19:38 | habit | 3 | 83667 | 1048 | 13.203 | 6337.0 |
| 1022 | 2024-03-06 05:48:58 | habit | 3 | 83667 | 1048 | 7.826 | 10690.9 |
| 1021 | 2024-03-01 11:43:31 | habit | 1 | 28756 | 2 | 0.470 | 61183.0 |
| 1020 | 2024-02-28 19:12:36 | habit | 3 | 83667 | 1048 | 3.610 | 23176.5 |
| 1019 | 2024-02-28 18:26:28 | habit | 2 | 53800 | 68 | 1.470 | 36598.6 |
| 1018 | 2024-02-28 11:56:52 | habit | 2 | 53800 | 68 | 1.813 | 29674.6 |
| 1017 | 2024-02-28 07:20:19 | habit | 3 | 83667 | 1048 | 7.173 | 11664.2 |
| 1016 | 2024-02-28 07:16:49 | habit | 3 | 83667 | 1048 | 4.406 | 18989.3 |
| 1015 | 2024-02-28 07:16:48 | habit | 2 | 53800 | 68 | 1.733 | 31044.4 |
| 1014 | 2024-02-28 07:16:43 | habit | 1 | 28756 | 2 | 0.596 | 48248.3 |
| 1013 | 2024-02-15 21:06:51 | habit | 1 | 28756 | 2 | 0.810 | 35501.2 |
| 1012 | 2024-02-03 17:56:39 | habit | 1 | 28756 | 2 | 0.516 | 55728.7 |
| 1011 | 2024-01-29 10:16:36 | habit | 1 | 28756 | 2 | 1.030 | 27918.4 |
| 1010 | 2024-01-29 05:31:49 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 1009 | 2024-01-26 12:47:22 | habit | 1 | 28756 | 2 | 0.483 | 59536.2 |
| 1008 | 2024-01-23 01:59:23 | habit | 3 | 83667 | 1048 | 8.953 | 9345.1 |
| 1007 | 2024-01-22 13:30:45 | habit | 3 | 83667 | 1048 | 3.360 | 24900.9 |
| 1006 | 2024-01-08 07:05:47 | habit | 3 | 83667 | 1048 | 3.593 | 23286.1 |
| 1005 | 2024-01-07 15:47:19 | habit | 3 | 83667 | 1048 | 3.716 | 22515.3 |
| 1004 | 2023-12-27 14:39:21 | habit | 2 | 53800 | 68 | 1.906 | 28226.7 |
| 1003 | 2023-12-27 14:39:11 | habit | 3 | 83667 | 1048 | 9.436 | 8866.8 |
| 1002 | 2023-12-24 14:53:04 | habit | 2 | 53800 | 68 | 1.373 | 39184.3 |
| 1001 | 2023-12-21 18:24:39 | habit | 3 | 83667 | 1048 | 4.000 | 20916.8 |
| 1000 | 2023-12-01 03:56:31 | habit | 1 | 28756 | 2 | 0.450 | 63902.2 |
| 999 | 2023-11-20 03:36:18 | habit | 3 | 83667 | 1048 | 3.263 | 25641.1 |
| 998 | 2023-11-20 03:36:16 | habit | 2 | 53800 | 68 | 1.390 | 38705.0 |
| 997 | 2023-11-13 19:58:12 | habit | 1 | 28756 | 2 | 0.500 | 57512.0 |
| 996 | 2023-11-12 03:36:39 | habit | 1 | 28756 | 2 | 0.500 | 57512.0 |
| 995 | 2023-11-03 10:09:43 | habit | 1 | 28756 | 2 | 0.576 | 49923.6 |
| 994 | 2023-10-21 15:20:51 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 993 | 2023-10-18 19:42:09 | habit | 1 | 28756 | 2 | 0.530 | 54256.6 |
| 992 | 2023-10-16 21:41:08 | habit | 3 | 83667 | 1048 | 6.796 | 12311.2 |
| 991 | 2023-10-16 03:00:36 | habit | 3 | 83667 | 1048 | 3.610 | 23176.5 |
| 990 | 2023-10-11 04:57:08 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 989 | 2023-10-03 16:30:31 | habit | 1 | 28756 | 2 | 0.533 | 53951.2 |
| 988 | 2023-09-29 00:44:29 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 987 | 2023-09-28 12:23:25 | habit | 1 | 28756 | 2 | 0.500 | 57512.0 |
| 986 | 2023-09-25 04:38:14 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 985 | 2023-09-15 21:22:24 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 984 | 2023-09-14 09:30:22 | habit | 1 | 28756 | 2 | 0.500 | 57512.0 |
| 983 | 2023-07-26 19:48:10 | habit | 3 | 83667 | 1048 | 3.750 | 22311.2 |
| 982 | 2023-07-12 14:22:46 | habit | 3 | 83667 | 1048 | 3.513 | 23816.4 |
| 981 | 2023-07-01 05:36:01 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 980 | 2023-06-04 17:00:27 | habit | 3 | 83667 | 1048 | 3.326 | 25155.4 |
| 979 | 2023-05-29 08:27:10 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 978 | 2023-04-10 03:17:05 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 977 | 2023-04-05 18:32:49 | habit | 3 | 83667 | 1048 | 3.313 | 25254.2 |
| 976 | 2023-02-09 17:58:33 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 975 | 2023-01-30 23:22:25 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 974 | 2023-01-02 03:29:00 | habit | 3 | 83667 | 1048 | 3.233 | 25879.1 |
| 973 | 2022-11-28 18:37:55 | habit | 1 | 28756 | 2 | 0.483 | 59536.2 |
| 972 | 2022-10-23 05:36:48 | habit | 1 | 28756 | 2 | 0.483 | 59536.2 |
| 971 | 2022-09-09 14:05:12 | habit | 3 | 83667 | 1048 | 3.360 | 24900.9 |
| 970 | 2022-09-06 13:28:13 | habit | 3 | 83667 | 1048 | 3.283 | 25484.9 |
| 969 | 2022-08-14 05:24:29 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 968 | 2022-07-30 05:33:00 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 967 | 2022-07-24 04:38:21 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 966 | 2022-07-21 22:09:47 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 965 | 2022-07-17 17:49:11 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 964 | 2022-07-03 12:14:48 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 963 | 2022-06-29 12:55:28 | habit | 1 | 28756 | 2 | 0.450 | 63902.2 |
| 962 | 2022-06-16 12:12:30 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 961 | 2022-05-26 04:00:21 | habit | 1 | 28756 | 2 | 0.440 | 65354.5 |
| 960 | 2022-03-16 23:25:41 | habit | 1 | 28756 | 2 | 0.670 | 42919.4 |
| 959 | 2022-03-14 20:33:38 | habit | 1 | 28756 | 2 | 0.470 | 61183.0 |
| 958 | 2022-03-09 10:27:20 | habit | 1 | 28756 | 2 | 0.483 | 59536.2 |
| 957 | 2021-12-22 23:31:36 | habit | 1 | 28756 | 2 | 0.530 | 54256.6 |
| 956 | 2021-11-25 18:38:23 | habit | 1 | 28756 | 2 | 0.500 | 57512.0 |
| 955 | 2021-11-11 14:30:44 | habit | 1 | 28756 | 2 | 0.500 | 57512.0 |
| 954 | 2021-10-27 21:13:45 | habit | 1 | 28756 | 2 | 0.516 | 55728.7 |
| 953 | 2021-09-20 09:29:09 | habit | 1 | 28756 | 2 | 0.530 | 54256.6 |
| 952 | 2021-09-18 07:50:27 | habit | 1 | 28756 | 2 | 0.483 | 59536.2 |
| 951 | 2021-08-22 21:33:25 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 950 | 2021-08-18 15:40:10 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 949 | 2021-08-16 11:09:45 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 948 | 2021-07-25 14:03:47 | habit | 1 | 28756 | 2 | 0.483 | 59536.2 |
| 947 | 2021-05-15 20:47:35 | habit | 1 | 28756 | 2 | 0.440 | 65354.5 |
| 946 | 2021-05-12 02:30:51 | habit | 1 | 28756 | 2 | 0.513 | 56054.6 |
| 945 | 2021-04-27 21:43:19 | habit | 3 | 83667 | 1048 | 4.063 | 20592.4 |
| 944 | 2021-02-16 23:01:28 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 943 | 2021-02-15 04:13:12 | habit | 1 | 28756 | 2 | 0.450 | 63902.2 |
| 942 | 2021-02-08 19:59:33 | habit | 3 | 83667 | 1048 | 3.346 | 25005.1 |
| 941 | 2021-02-07 18:01:21 | habit | 1 | 28756 | 2 | 0.453 | 63479.0 |
| 940 | 2021-01-28 10:47:38 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 939 | 2021-01-23 06:07:43 | habit | 3 | 83667 | 1048 | 3.330 | 25125.2 |
| 938 | 2021-01-14 15:06:46 | habit | 3 | 83667 | 1048 | 3.470 | 24111.5 |
| 937 | 2020-11-09 19:12:50 | habit | 3 | 83667 | 1048 | 3.563 | 23482.2 |
| 936 | 2020-11-05 23:56:46 | habit | 1 | 28756 | 2 | 0.500 | 57512.0 |
| 935 | 2020-10-26 22:03:03 | habit | 3 | 83667 | 1048 | 3.860 | 21675.4 |
| 934 | 2020-10-25 20:34:03 | habit | 1 | 28756 | 2 | 0.436 | 65954.1 |
| 933 | 2020-10-21 18:59:49 | habit | 3 | 83667 | 1048 | 3.420 | 24464.0 |