History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lodging"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1009 | 2024-03-14 07:00:49 | lodging | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 1008 | 2024-03-11 22:34:02 | lodging | 1 | 69583 | 5 | 2.156 | 32274.1 |
| 1007 | 2024-01-22 21:50:40 | lodging | 2 | 107671 | 104 | 3.296 | 32667.2 |
| 1006 | 2024-01-21 23:22:25 | lodging | 2 | 107671 | 104 | 3.640 | 29579.9 |
| 1005 | 2023-12-20 21:06:32 | lodging | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 1004 | 2023-12-15 03:12:02 | lodging | 2 | 107671 | 104 | 3.063 | 35152.1 |
| 1003 | 2023-12-13 09:58:22 | lodging | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 1002 | 2023-12-03 10:28:10 | lodging | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 1001 | 2023-12-03 10:28:09 | lodging | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 1000 | 2023-11-26 13:17:24 | lodging | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 999 | 2023-11-17 00:06:37 | lodging | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 998 | 2023-11-11 21:13:14 | lodging | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 997 | 2023-11-11 11:05:09 | lodging | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 996 | 2023-11-09 11:57:22 | lodging | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 995 | 2023-11-05 04:17:41 | lodging | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 994 | 2023-11-01 18:03:41 | lodging | 2 | 107671 | 104 | 7.326 | 14697.1 |
| 993 | 2023-10-20 04:07:30 | lodging | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 992 | 2023-10-11 20:14:56 | lodging | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 991 | 2023-10-06 21:54:25 | lodging | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 990 | 2023-09-30 08:25:36 | lodging | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 989 | 2023-09-29 11:25:28 | lodging | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 988 | 2023-09-22 04:50:46 | lodging | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 987 | 2023-08-10 02:41:33 | lodging | 2 | 107671 | 104 | 3.140 | 34290.1 |
| 986 | 2023-07-28 18:57:17 | lodging | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 985 | 2023-07-17 08:48:49 | lodging | 1 | 69583 | 5 | 1.050 | 66269.5 |
| 984 | 2023-04-27 17:17:25 | lodging | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 983 | 2023-04-22 13:35:51 | lodging | 2 | 107671 | 104 | 2.720 | 39584.9 |
| 982 | 2023-03-29 10:31:49 | lodging | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 981 | 2023-03-25 18:11:02 | lodging | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 980 | 2023-02-19 07:20:08 | lodging | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 979 | 2023-01-24 12:47:17 | lodging | 2 | 107671 | 104 | 3.156 | 34116.3 |
| 978 | 2022-12-16 14:15:33 | lodging | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 977 | 2022-12-07 13:44:22 | lodging | 1 | 69583 | 5 | 1.030 | 67556.3 |
| 976 | 2022-11-04 22:23:39 | lodging | 2 | 107671 | 104 | 2.830 | 38046.3 |
| 975 | 2022-09-19 05:55:14 | lodging | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 974 | 2022-08-28 14:01:59 | lodging | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 973 | 2022-08-10 14:39:21 | lodging | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 972 | 2022-08-06 22:46:39 | lodging | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 971 | 2022-07-03 09:06:30 | lodging | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 970 | 2022-06-25 20:45:58 | lodging | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 969 | 2022-06-16 09:04:33 | lodging | 1 | 69583 | 5 | 1.030 | 67556.3 |
| 968 | 2022-06-08 19:15:13 | lodging | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 967 | 2022-05-26 01:50:53 | lodging | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 966 | 2022-05-24 00:52:39 | lodging | 2 | 107671 | 104 | 2.830 | 38046.3 |
| 965 | 2022-04-17 14:56:49 | lodging | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 964 | 2022-04-09 12:41:36 | lodging | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 963 | 2022-02-15 12:32:02 | lodging | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 962 | 2022-01-17 15:20:37 | lodging | 1 | 69583 | 5 | 1.206 | 57697.3 |
| 961 | 2022-01-15 11:28:26 | lodging | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 960 | 2021-12-25 09:29:29 | lodging | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 959 | 2021-11-09 06:33:20 | lodging | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 958 | 2021-09-26 20:47:26 | lodging | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 957 | 2021-09-24 17:01:06 | lodging | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 956 | 2021-09-14 23:40:07 | lodging | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 955 | 2021-09-07 12:16:31 | lodging | 1 | 69583 | 5 | 2.390 | 29114.2 |
| 954 | 2021-09-03 01:39:08 | lodging | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 953 | 2021-06-22 20:50:18 | lodging | 2 | 107671 | 104 | 3.156 | 34116.3 |
| 952 | 2021-06-14 23:21:48 | lodging | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 951 | 2021-05-31 00:03:27 | lodging | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 950 | 2021-05-05 17:50:40 | lodging | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 949 | 2021-04-03 15:58:32 | lodging | 2 | 107671 | 104 | 2.826 | 38100.1 |
| 948 | 2021-03-15 13:47:34 | lodging | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 947 | 2021-02-12 00:48:01 | lodging | 2 | 107671 | 104 | 3.016 | 35699.9 |
| 946 | 2021-01-18 22:07:02 | lodging | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 945 | 2020-12-04 12:11:22 | lodging | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 944 | 2020-11-30 13:12:22 | lodging | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 943 | 2020-11-24 10:41:31 | lodging | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 942 | 2020-10-19 10:56:42 | lodging | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 941 | 2020-09-13 05:04:57 | lodging | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 940 | 2020-08-20 12:15:46 | lodging | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 939 | 2020-07-28 14:17:25 | lodging | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 938 | 2020-07-25 05:12:58 | lodging | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 937 | 2020-06-18 22:39:25 | lodging | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 936 | 2020-05-07 00:45:27 | lodging | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 935 | 2020-03-28 13:00:24 | lodging | 1 | 69583 | 5 | 1.643 | 42351.2 |
| 934 | 2020-03-28 10:22:50 | lodging | 1 | 69583 | 5 | 1.300 | 53525.4 |
| 933 | 2020-03-27 19:41:52 | lodging | 1 | 69583 | 5 | 1.453 | 47889.2 |
| 932 | 2020-03-25 08:26:38 | lodging | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 931 | 2020-03-25 01:53:16 | lodging | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 930 | 2020-03-23 23:43:27 | lodging | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 929 | 2020-03-20 14:06:24 | lodging | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 928 | 2020-03-05 21:35:41 | lodging | 2 | 107671 | 104 | 3.390 | 31761.4 |
| 927 | 2020-03-02 11:20:39 | lodging | 2 | 107671 | 104 | 3.016 | 35699.9 |
| 926 | 2020-03-01 08:04:57 | lodging | 2 | 107671 | 104 | 3.000 | 35890.3 |
| 925 | 2020-02-23 19:13:04 | lodging | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 924 | 2020-02-22 06:01:08 | lodging | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 923 | 2020-02-18 09:28:11 | lodging | 1 | 69583 | 5 | 1.330 | 52318.0 |
| 922 | 2020-02-07 03:24:17 | lodging | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 921 | 2020-02-05 06:12:52 | lodging | 1 | 69583 | 5 | 1.406 | 49490.0 |
| 920 | 2020-02-04 12:57:56 | lodging | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 919 | 2020-02-04 10:09:58 | lodging | 1 | 69583 | 5 | 1.393 | 49951.9 |
| 918 | 2020-02-01 12:57:20 | lodging | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 917 | 2020-01-28 21:06:12 | lodging | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 916 | 2020-01-25 02:36:14 | lodging | 1 | 69583 | 5 | 2.530 | 27503.2 |
| 915 | 2020-01-15 18:44:08 | lodging | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 914 | 2020-01-15 09:05:50 | lodging | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 913 | 2020-01-12 09:24:09 | lodging | 2 | 107671 | 104 | 3.313 | 32499.5 |
| 912 | 2020-01-12 06:53:20 | lodging | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 911 | 2020-01-07 14:55:21 | lodging | 1 | 69583 | 5 | 2.733 | 25460.3 |
| 910 | 2019-12-30 09:46:29 | lodging | 1 | 69583 | 5 | 1.343 | 51811.6 |