History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lessees"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1239 | 2024-04-28 19:02:49 | lessees | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 1238 | 2024-03-30 23:03:17 | lessees | 1 | 69583 | 3 | 2.126 | 32729.5 |
| 1237 | 2024-03-29 05:15:35 | lessees | 1 | 69583 | 3 | 1.440 | 48321.5 |
| 1236 | 2024-03-28 07:28:58 | lessees | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 1235 | 2024-03-06 04:02:16 | lessees | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 1234 | 2024-02-12 06:22:03 | lessees | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 1233 | 2023-12-10 06:30:22 | lessees | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 1232 | 2023-12-03 16:41:46 | lessees | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 1231 | 2023-11-22 15:36:55 | lessees | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 1230 | 2023-11-19 00:23:17 | lessees | 1 | 69583 | 3 | 1.813 | 38380.0 |
| 1229 | 2023-11-09 03:09:17 | lessees | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 1228 | 2023-10-20 20:17:44 | lessees | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 1227 | 2023-10-19 20:53:09 | lessees | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 1226 | 2023-10-12 08:46:23 | lessees | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 1225 | 2023-09-29 09:56:38 | lessees | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 1224 | 2023-09-24 05:14:43 | lessees | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 1223 | 2023-09-21 22:56:26 | lessees | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 1222 | 2023-07-19 12:55:27 | lessees | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 1221 | 2023-07-03 22:16:25 | lessees | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 1220 | 2023-04-21 20:59:02 | lessees | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 1219 | 2023-03-14 01:01:05 | lessees | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 1218 | 2023-03-10 17:21:54 | lessees | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 1217 | 2023-02-10 15:15:32 | lessees | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 1216 | 2023-01-25 03:47:13 | lessees | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 1215 | 2022-12-10 23:13:54 | lessees | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 1214 | 2022-12-08 03:02:33 | lessees | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 1213 | 2022-11-25 20:50:50 | lessees | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 1212 | 2022-11-25 13:34:33 | lessees | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 1211 | 2022-11-15 11:36:04 | lessees | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 1210 | 2022-11-07 07:34:38 | lessees | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 1209 | 2022-11-07 07:34:36 | lessees | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 1208 | 2022-08-09 00:44:39 | lessees | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 1207 | 2022-07-29 17:03:35 | lessees | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 1206 | 2022-07-26 06:34:20 | lessees | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 1205 | 2022-06-03 13:26:39 | lessees | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 1204 | 2022-04-16 10:44:55 | lessees | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 1203 | 2022-04-04 21:11:33 | lessees | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 1202 | 2022-04-04 05:22:40 | lessees | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 1201 | 2022-03-27 04:50:22 | lessees | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 1200 | 2022-03-12 22:12:42 | lessees | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 1199 | 2022-01-12 20:46:41 | lessees | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 1198 | 2022-01-10 17:22:48 | lessees | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 1197 | 2021-12-17 05:56:26 | lessees | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 1196 | 2021-12-01 07:02:41 | lessees | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 1195 | 2021-11-20 06:05:13 | lessees | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 1194 | 2021-11-08 19:11:22 | lessees | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 1193 | 2021-11-07 18:01:12 | lessees | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 1192 | 2021-11-07 05:25:54 | lessees | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 1191 | 2021-11-06 19:21:43 | lessees | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 1190 | 2021-10-31 11:16:17 | lessees | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 1189 | 2021-09-26 09:45:57 | lessees | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 1188 | 2021-09-24 05:14:00 | lessees | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 1187 | 2021-09-06 18:31:12 | lessees | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 1186 | 2021-09-04 20:02:14 | lessees | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 1185 | 2021-08-25 05:38:59 | lessees | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 1184 | 2021-08-24 16:26:12 | lessees | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 1183 | 2021-07-28 07:36:50 | lessees | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 1182 | 2021-07-10 11:57:14 | lessees | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 1181 | 2021-06-05 18:21:24 | lessees | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 1180 | 2021-05-19 12:13:13 | lessees | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 1179 | 2021-05-15 16:25:15 | lessees | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 1178 | 2021-05-02 03:55:01 | lessees | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 1177 | 2021-04-28 05:12:17 | lessees | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 1176 | 2021-04-19 12:01:57 | lessees | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 1175 | 2021-04-08 20:09:21 | lessees | 3 | 134027 | 421 | 6.656 | 20136.3 |
| 1174 | 2021-03-22 08:39:40 | lessees | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 1173 | 2021-03-03 15:10:46 | lessees | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 1172 | 2021-02-16 08:12:46 | lessees | 3 | 134027 | 421 | 5.873 | 22820.9 |
| 1171 | 2021-01-04 03:52:15 | lessees | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 1170 | 2020-12-25 02:59:26 | lessees | 3 | 134027 | 421 | 6.110 | 21935.7 |
| 1169 | 2020-11-28 03:04:21 | lessees | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 1168 | 2020-11-08 19:56:26 | lessees | 1 | 69583 | 3 | 2.203 | 31585.6 |
| 1167 | 2020-10-24 06:13:38 | lessees | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 1166 | 2020-10-17 20:31:23 | lessees | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 1165 | 2020-09-15 03:13:17 | lessees | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 1164 | 2020-09-01 02:47:12 | lessees | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 1163 | 2020-08-25 03:03:41 | lessees | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 1162 | 2020-08-17 01:28:38 | lessees | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 1161 | 2020-08-14 04:48:58 | lessees | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 1160 | 2020-05-23 17:34:28 | lessees | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 1159 | 2020-05-14 19:54:18 | lessees | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 1158 | 2020-03-30 04:05:17 | lessees | 1 | 69583 | 3 | 1.733 | 40151.8 |
| 1157 | 2020-03-28 12:44:19 | lessees | 1 | 69583 | 3 | 2.376 | 29285.8 |
| 1156 | 2020-03-24 15:10:10 | lessees | 1 | 69583 | 3 | 2.593 | 26834.9 |
| 1155 | 2020-03-22 12:27:37 | lessees | 1 | 69583 | 3 | 1.860 | 37410.2 |
| 1154 | 2020-03-19 21:46:51 | lessees | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 1153 | 2020-03-18 22:04:12 | lessees | 1 | 69583 | 3 | 1.310 | 53116.8 |
| 1152 | 2020-02-28 02:57:12 | lessees | 3 | 134027 | 421 | 6.953 | 19276.1 |
| 1151 | 2020-02-27 00:43:10 | lessees | 1 | 69583 | 3 | 2.766 | 25156.5 |
| 1150 | 2020-02-26 08:58:27 | lessees | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 1149 | 2020-02-25 23:32:38 | lessees | 3 | 134027 | 421 | 8.390 | 15974.6 |
| 1148 | 2020-02-25 18:47:04 | lessees | 1 | 69583 | 3 | 1.356 | 51314.9 |
| 1147 | 2020-02-20 13:30:34 | lessees | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 1146 | 2020-02-17 22:59:24 | lessees | 3 | 134027 | 421 | 8.000 | 16753.4 |
| 1145 | 2020-02-12 12:13:35 | lessees | 1 | 69583 | 3 | 1.516 | 45899.1 |
| 1144 | 2020-02-09 20:32:41 | lessees | 1 | 69583 | 3 | 2.736 | 25432.4 |
| 1143 | 2020-02-09 10:18:19 | lessees | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 1142 | 2020-02-08 18:41:37 | lessees | 3 | 134027 | 421 | 7.236 | 18522.2 |
| 1141 | 2020-02-08 15:15:31 | lessees | 3 | 134027 | 421 | 9.170 | 14615.8 |
| 1140 | 2020-02-07 23:28:45 | lessees | 3 | 134027 | 421 | 13.406 | 9997.5 |