History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clerk"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1318 | 2025-11-04 20:14:22 | clerk | 3 | 83667 | 996 | 14.236 | 5877.1 |
| 1317 | 2025-11-03 15:20:07 | clerk | 3 | 83667 | 996 | 4.110 | 20356.9 |
| 1316 | 2025-11-02 10:34:48 | clerk | 3 | 83667 | 996 | 3.406 | 24564.6 |
| 1315 | 2025-11-01 09:44:48 | clerk | 3 | 83667 | 996 | 3.953 | 21165.4 |
| 1314 | 2025-10-31 07:35:39 | clerk | 3 | 83667 | 996 | 3.876 | 21585.9 |
| 1313 | 2025-10-30 02:02:40 | clerk | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1312 | 2025-10-29 19:32:32 | clerk | 3 | 83667 | 996 | 4.110 | 20356.9 |
| 1311 | 2025-10-29 19:13:10 | clerk | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1310 | 2025-10-29 03:04:44 | clerk | 3 | 83667 | 996 | 3.483 | 24021.5 |
| 1309 | 2025-10-28 17:33:59 | clerk | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1308 | 2025-10-26 22:44:37 | clerk | 1 | 28756 | 3 | 0.560 | 51350.0 |
| 1307 | 2025-10-26 19:32:29 | clerk | 3 | 83667 | 996 | 3.893 | 21491.7 |
| 1306 | 2025-10-26 01:39:38 | clerk | 1 | 28756 | 3 | 0.450 | 63902.2 |
| 1305 | 2025-10-24 19:32:18 | clerk | 3 | 83667 | 996 | 3.830 | 21845.2 |
| 1304 | 2025-10-22 03:57:31 | clerk | 1 | 28756 | 3 | 2.423 | 11867.9 |
| 1303 | 2025-10-21 01:05:21 | clerk | 3 | 83667 | 996 | 9.563 | 8749.0 |
| 1302 | 2025-10-19 22:13:22 | clerk | 1 | 28756 | 3 | 1.623 | 17717.8 |
| 1301 | 2025-10-19 16:11:08 | clerk | 3 | 83667 | 996 | 14.326 | 5840.2 |
| 1300 | 2025-10-18 09:13:35 | clerk | 3 | 83667 | 996 | 3.920 | 21343.6 |
| 1299 | 2025-10-17 05:04:07 | clerk | 3 | 83667 | 996 | 4.236 | 19751.4 |
| 1298 | 2025-10-15 21:52:11 | clerk | 3 | 83667 | 996 | 4.170 | 20064.0 |
| 1297 | 2025-10-14 04:39:12 | clerk | 3 | 83667 | 996 | 3.390 | 24680.5 |
| 1296 | 2025-10-13 21:10:34 | clerk | 3 | 83667 | 996 | 6.513 | 12846.2 |
| 1295 | 2025-10-12 13:56:38 | clerk | 3 | 83667 | 996 | 3.890 | 21508.2 |
| 1294 | 2025-09-27 20:27:05 | clerk | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1293 | 2025-09-27 11:36:11 | clerk | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 1292 | 2025-09-27 11:26:05 | clerk | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1291 | 2025-09-27 06:04:06 | clerk | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 1290 | 2025-09-26 11:53:38 | clerk | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 1289 | 2025-09-25 21:56:14 | clerk | 1 | 28756 | 3 | 0.560 | 51350.0 |
| 1288 | 2025-09-24 19:44:16 | clerk | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1287 | 2025-09-23 20:55:51 | clerk | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 1286 | 2025-09-22 14:57:39 | clerk | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1285 | 2025-09-16 21:49:53 | clerk | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1284 | 2025-09-16 14:23:36 | clerk | 3 | 83667 | 996 | 3.906 | 21420.1 |
| 1283 | 2025-09-14 03:38:08 | clerk | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1282 | 2025-09-12 18:25:18 | clerk | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1281 | 2025-09-12 16:36:28 | clerk | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1280 | 2025-09-04 09:59:50 | clerk | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1279 | 2025-09-01 18:55:52 | clerk | 2 | 53800 | 61 | 1.796 | 29955.5 |
| 1278 | 2025-09-01 17:56:05 | clerk | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1277 | 2025-08-27 11:19:44 | clerk | 1 | 28756 | 3 | 0.533 | 53951.2 |
| 1276 | 2025-08-25 23:51:12 | clerk | 3 | 83667 | 996 | 7.830 | 10685.4 |
| 1275 | 2025-08-25 12:01:42 | clerk | 1 | 28756 | 3 | 1.190 | 24164.7 |
| 1274 | 2025-08-25 09:34:29 | clerk | 3 | 83667 | 996 | 22.626 | 3697.8 |
| 1273 | 2025-08-25 04:48:38 | clerk | 3 | 83667 | 996 | 12.283 | 6811.6 |
| 1272 | 2025-08-24 17:07:05 | clerk | 3 | 83667 | 996 | 3.436 | 24350.1 |
| 1271 | 2025-08-24 13:53:11 | clerk | 3 | 83667 | 996 | 19.860 | 4212.8 |
| 1270 | 2025-08-23 01:37:47 | clerk | 3 | 83667 | 996 | 19.673 | 4252.9 |
| 1269 | 2025-08-22 08:32:59 | clerk | 3 | 83667 | 996 | 3.796 | 22040.8 |
| 1268 | 2025-08-14 09:16:43 | clerk | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 1267 | 2025-08-14 09:16:15 | clerk | 3 | 83667 | 996 | 3.783 | 22116.6 |
| 1266 | 2025-08-10 00:10:28 | clerk | 1 | 28756 | 3 | 1.060 | 27128.3 |
| 1265 | 2025-08-09 06:58:38 | clerk | 1 | 28756 | 3 | 1.830 | 15713.7 |
| 1264 | 2025-08-05 00:31:36 | clerk | 1 | 28756 | 3 | 1.513 | 19005.9 |
| 1263 | 2025-07-31 21:52:12 | clerk | 1 | 28756 | 3 | 2.110 | 13628.4 |
| 1262 | 2025-07-31 16:44:00 | clerk | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1261 | 2025-07-30 23:56:41 | clerk | 1 | 28756 | 3 | 2.203 | 13053.1 |
| 1260 | 2025-07-26 18:30:35 | clerk | 1 | 28756 | 3 | 2.263 | 12707.0 |
| 1259 | 2025-07-26 07:00:20 | clerk | 2 | 53800 | 61 | 7.376 | 7293.9 |
| 1258 | 2025-07-26 06:50:42 | clerk | 3 | 83667 | 996 | 15.500 | 5397.9 |
| 1257 | 2025-07-25 11:00:57 | clerk | 2 | 53800 | 61 | 6.796 | 7916.4 |
| 1256 | 2025-07-25 11:00:32 | clerk | 3 | 83667 | 996 | 19.076 | 4386.0 |
| 1255 | 2025-07-24 16:46:16 | clerk | 1 | 28756 | 3 | 1.280 | 22465.6 |
| 1254 | 2025-07-23 18:49:49 | clerk | 1 | 28756 | 3 | 1.110 | 25906.3 |
| 1253 | 2025-07-23 16:58:59 | clerk | 3 | 83667 | 996 | 10.140 | 8251.2 |
| 1252 | 2025-07-21 14:25:02 | clerk | 2 | 53800 | 61 | 1.653 | 32546.9 |
| 1251 | 2025-07-21 14:04:15 | clerk | 3 | 83667 | 996 | 4.623 | 18098.0 |
| 1250 | 2025-07-20 13:46:48 | clerk | 3 | 83667 | 996 | 4.283 | 19534.7 |
| 1249 | 2025-07-19 07:33:25 | clerk | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1248 | 2025-07-18 08:42:24 | clerk | 1 | 28756 | 3 | 4.856 | 5921.7 |
| 1247 | 2025-07-15 05:41:03 | clerk | 1 | 28756 | 3 | 1.483 | 19390.4 |
| 1246 | 2025-07-10 02:05:09 | clerk | 1 | 28756 | 3 | 2.470 | 11642.1 |
| 1245 | 2025-07-08 13:19:16 | clerk | 1 | 28756 | 3 | 1.376 | 20898.3 |
| 1244 | 2025-07-07 11:25:53 | clerk | 1 | 28756 | 3 | 1.360 | 21144.1 |
| 1243 | 2025-07-07 06:31:27 | clerk | 1 | 28756 | 3 | 1.280 | 22465.6 |
| 1242 | 2025-07-01 23:33:22 | clerk | 1 | 28756 | 3 | 0.993 | 28958.7 |
| 1241 | 2025-06-29 23:25:03 | clerk | 1 | 28756 | 3 | 3.280 | 8767.1 |
| 1240 | 2025-06-22 20:15:31 | clerk | 1 | 28756 | 3 | 1.013 | 28387.0 |
| 1239 | 2025-06-22 11:58:21 | clerk | 1 | 28756 | 3 | 2.280 | 12612.3 |
| 1238 | 2025-06-19 11:08:38 | clerk | 1 | 28756 | 3 | 1.953 | 14724.0 |
| 1237 | 2025-06-13 15:20:54 | clerk | 2 | 53800 | 61 | 1.470 | 36598.6 |
| 1236 | 2025-06-09 22:38:34 | clerk | 1 | 28756 | 3 | 1.953 | 14724.0 |
| 1235 | 2025-06-04 06:15:13 | clerk | 1 | 28756 | 3 | 1.250 | 23004.8 |
| 1234 | 2025-06-01 22:54:11 | clerk | 1 | 28756 | 3 | 1.343 | 21411.8 |
| 1233 | 2025-06-01 02:31:12 | clerk | 1 | 28756 | 3 | 1.373 | 20943.9 |
| 1232 | 2025-05-31 18:53:52 | clerk | 1 | 28756 | 3 | 1.033 | 27837.4 |
| 1231 | 2025-05-28 22:35:32 | clerk | 1 | 28756 | 3 | 2.720 | 10572.1 |
| 1230 | 2025-05-24 10:03:31 | clerk | 3 | 83667 | 996 | 29.520 | 2834.2 |
| 1229 | 2025-05-23 12:18:59 | clerk | 3 | 83667 | 996 | 12.893 | 6489.3 |
| 1228 | 2025-05-20 15:36:58 | clerk | 1 | 28756 | 3 | 2.733 | 10521.8 |
| 1227 | 2025-05-20 12:42:24 | clerk | 1 | 28756 | 3 | 2.046 | 14054.7 |
| 1226 | 2025-05-19 21:03:59 | clerk | 3 | 83667 | 996 | 10.076 | 8303.6 |
| 1225 | 2025-05-18 07:46:11 | clerk | 2 | 53800 | 61 | 3.830 | 14047.0 |
| 1224 | 2025-05-17 11:29:25 | clerk | 1 | 28756 | 3 | 2.216 | 12976.5 |
| 1223 | 2025-05-17 08:36:11 | clerk | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 1222 | 2025-05-17 04:43:52 | clerk | 2 | 53800 | 61 | 1.656 | 32487.9 |
| 1221 | 2025-05-07 15:30:03 | clerk | 2 | 53800 | 61 | 1.783 | 30173.9 |
| 1220 | 2025-05-05 10:21:49 | clerk | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1219 | 2025-05-04 06:15:28 | clerk | 1 | 28756 | 3 | 1.686 | 17055.8 |