History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canola"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1364 | 2026-03-02 03:57:03 | canola | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 1363 | 2026-03-01 06:54:56 | canola | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 1362 | 2026-02-24 01:46:32 | canola | 3 | 112716 | 514 | 7.796 | 14458.2 |
| 1361 | 2026-02-20 09:52:18 | canola | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 1360 | 2026-02-14 22:02:58 | canola | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 1359 | 2026-02-07 13:46:48 | canola | 2 | 82551 | 45 | 10.470 | 7884.5 |
| 1358 | 2026-02-05 04:35:30 | canola | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 1357 | 2026-02-05 04:25:41 | canola | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 1356 | 2026-02-02 06:21:05 | canola | 3 | 112716 | 514 | 11.393 | 9893.4 |
| 1355 | 2026-01-30 13:40:13 | canola | 1 | 48755 | 3 | 2.080 | 23439.9 |
| 1354 | 2026-01-28 09:20:24 | canola | 1 | 48755 | 3 | 3.906 | 12482.1 |
| 1353 | 2026-01-28 08:57:54 | canola | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 1352 | 2026-01-22 19:18:49 | canola | 1 | 48755 | 3 | 2.233 | 21833.9 |
| 1351 | 2026-01-22 19:18:43 | canola | 1 | 48755 | 3 | 2.373 | 20545.7 |
| 1350 | 2026-01-14 09:44:42 | canola | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 1349 | 2026-01-14 01:19:37 | canola | 1 | 48755 | 3 | 4.406 | 11065.6 |
| 1348 | 2026-01-04 22:14:41 | canola | 3 | 112716 | 514 | 5.750 | 19602.8 |
| 1347 | 2026-01-04 04:12:58 | canola | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 1346 | 2026-01-03 16:00:42 | canola | 1 | 48755 | 3 | 3.516 | 13866.6 |
| 1345 | 2025-12-22 16:29:47 | canola | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 1344 | 2025-12-06 03:35:58 | canola | 3 | 112716 | 514 | 6.313 | 17854.6 |
| 1343 | 2025-12-01 03:41:17 | canola | 3 | 112716 | 514 | 5.420 | 20796.3 |
| 1342 | 2025-11-29 22:44:17 | canola | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 1341 | 2025-11-28 16:20:49 | canola | 3 | 112716 | 514 | 5.720 | 19705.6 |
| 1340 | 2025-11-28 12:01:47 | canola | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 1339 | 2025-11-17 02:05:17 | canola | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 1338 | 2025-11-07 08:08:59 | canola | 3 | 112716 | 514 | 5.733 | 19660.9 |
| 1337 | 2025-10-30 03:40:28 | canola | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 1336 | 2025-10-25 23:27:28 | canola | 1 | 48755 | 3 | 0.983 | 49598.2 |
| 1335 | 2025-10-24 02:18:03 | canola | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 1334 | 2025-10-18 23:11:37 | canola | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 1333 | 2025-10-05 04:28:43 | canola | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 1332 | 2025-09-26 16:50:46 | canola | 1 | 48755 | 3 | 0.893 | 54596.9 |
| 1331 | 2025-09-18 06:25:10 | canola | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 1330 | 2025-09-12 14:18:35 | canola | 3 | 112716 | 514 | 5.563 | 20261.7 |
| 1329 | 2025-08-26 00:46:31 | canola | 1 | 48755 | 3 | 3.046 | 16006.2 |
| 1328 | 2025-08-24 12:02:53 | canola | 1 | 48755 | 3 | 2.080 | 23439.9 |
| 1327 | 2025-08-09 08:52:27 | canola | 1 | 48755 | 3 | 3.110 | 15676.8 |
| 1326 | 2025-08-05 15:07:17 | canola | 3 | 112716 | 514 | 24.066 | 4683.6 |
| 1325 | 2025-08-04 23:45:19 | canola | 3 | 112716 | 514 | 14.796 | 7618.0 |
| 1324 | 2025-08-01 01:42:50 | canola | 3 | 112716 | 514 | 14.623 | 7708.1 |
| 1323 | 2025-07-31 18:45:55 | canola | 1 | 48755 | 3 | 1.733 | 28133.3 |
| 1322 | 2025-07-31 12:40:09 | canola | 1 | 48755 | 3 | 0.893 | 54596.9 |
| 1321 | 2025-07-27 11:30:03 | canola | 3 | 112716 | 514 | 15.360 | 7338.3 |
| 1320 | 2025-07-26 23:19:54 | canola | 3 | 112716 | 514 | 37.970 | 2968.6 |
| 1319 | 2025-07-25 09:46:02 | canola | 1 | 48755 | 3 | 1.750 | 27860.0 |
| 1318 | 2025-07-25 06:10:25 | canola | 3 | 112716 | 514 | 15.406 | 7316.4 |
| 1317 | 2025-07-25 02:06:37 | canola | 3 | 112716 | 514 | 22.500 | 5009.6 |
| 1316 | 2025-07-24 18:49:09 | canola | 1 | 48755 | 3 | 2.156 | 22613.6 |
| 1315 | 2025-07-24 12:50:51 | canola | 3 | 112716 | 514 | 16.020 | 7036.0 |
| 1314 | 2025-07-24 06:11:45 | canola | 3 | 112716 | 514 | 27.630 | 4079.5 |
| 1313 | 2025-07-23 12:31:00 | canola | 1 | 48755 | 3 | 3.736 | 13050.1 |
| 1312 | 2025-07-20 08:40:00 | canola | 3 | 112716 | 514 | 11.876 | 9491.1 |
| 1311 | 2025-07-13 07:16:30 | canola | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 1310 | 2025-07-12 04:41:29 | canola | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 1309 | 2025-07-10 14:48:44 | canola | 1 | 48755 | 3 | 5.186 | 9401.3 |
| 1308 | 2025-07-08 08:05:24 | canola | 1 | 48755 | 3 | 2.813 | 17332.0 |
| 1307 | 2025-06-20 15:38:56 | canola | 1 | 48755 | 3 | 6.750 | 7223.0 |
| 1306 | 2025-06-18 17:13:44 | canola | 1 | 48755 | 3 | 1.906 | 25579.7 |
| 1305 | 2025-06-15 06:40:52 | canola | 2 | 82551 | 45 | 14.593 | 5656.9 |
| 1304 | 2025-06-14 17:41:14 | canola | 3 | 112716 | 514 | 27.063 | 4164.9 |
| 1303 | 2025-06-14 06:02:43 | canola | 3 | 112716 | 514 | 21.140 | 5331.9 |
| 1302 | 2025-06-13 22:42:39 | canola | 2 | 82551 | 45 | 17.656 | 4675.5 |
| 1301 | 2025-06-13 22:26:47 | canola | 3 | 112716 | 514 | 26.936 | 4184.6 |
| 1300 | 2025-06-13 20:35:56 | canola | 1 | 48755 | 3 | 4.216 | 11564.3 |
| 1299 | 2025-06-13 09:53:00 | canola | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 1298 | 2025-06-13 06:14:50 | canola | 1 | 48755 | 3 | 1.280 | 38089.8 |
| 1297 | 2025-06-12 10:09:22 | canola | 2 | 82551 | 45 | 14.016 | 5889.8 |
| 1296 | 2025-06-12 09:18:14 | canola | 3 | 112716 | 514 | 29.516 | 3818.8 |
| 1295 | 2025-06-11 01:41:57 | canola | 1 | 48755 | 3 | 0.966 | 50471.0 |
| 1294 | 2025-06-10 19:14:45 | canola | 1 | 48755 | 3 | 4.750 | 10264.2 |
| 1293 | 2025-06-10 12:33:39 | canola | 1 | 48755 | 3 | 4.356 | 11192.6 |
| 1292 | 2025-06-08 19:50:46 | canola | 2 | 82551 | 45 | 13.656 | 6045.0 |
| 1291 | 2025-06-08 07:56:06 | canola | 1 | 48755 | 3 | 2.750 | 17729.1 |
| 1290 | 2025-05-29 02:31:46 | canola | 1 | 48755 | 3 | 2.703 | 18037.4 |
| 1289 | 2025-05-28 10:47:05 | canola | 1 | 48755 | 3 | 2.046 | 23829.4 |
| 1288 | 2025-05-21 05:52:15 | canola | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 1287 | 2025-05-20 13:05:04 | canola | 1 | 48755 | 3 | 4.390 | 11105.9 |
| 1286 | 2025-05-18 17:36:30 | canola | 1 | 48755 | 3 | 2.486 | 19611.8 |
| 1285 | 2025-05-17 02:02:19 | canola | 2 | 82551 | 45 | 20.000 | 4127.6 |
| 1284 | 2025-05-15 00:14:04 | canola | 1 | 48755 | 3 | 7.296 | 6682.4 |
| 1283 | 2025-05-14 06:35:56 | canola | 3 | 112716 | 514 | 46.283 | 2435.4 |
| 1282 | 2025-05-14 06:02:28 | canola | 3 | 112716 | 514 | 22.766 | 4951.1 |
| 1281 | 2025-05-13 22:30:49 | canola | 2 | 82551 | 45 | 7.233 | 11413.1 |
| 1280 | 2025-05-13 22:24:20 | canola | 3 | 112716 | 514 | 19.750 | 5707.1 |
| 1279 | 2025-05-13 06:54:25 | canola | 1 | 48755 | 3 | 2.733 | 17839.4 |
| 1278 | 2025-05-12 10:20:33 | canola | 3 | 112716 | 514 | 18.420 | 6119.2 |
| 1277 | 2025-05-12 10:12:05 | canola | 2 | 82551 | 45 | 12.813 | 6442.8 |
| 1276 | 2025-05-12 03:10:23 | canola | 2 | 82551 | 45 | 11.126 | 7419.6 |
| 1275 | 2025-05-11 02:00:13 | canola | 1 | 48755 | 3 | 2.186 | 22303.3 |
| 1274 | 2025-05-10 18:09:32 | canola | 2 | 82551 | 45 | 8.810 | 9370.1 |
| 1273 | 2025-05-10 17:37:14 | canola | 1 | 48755 | 3 | 5.796 | 8411.8 |
| 1272 | 2025-05-08 21:48:47 | canola | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 1271 | 2025-05-08 07:38:29 | canola | 1 | 48755 | 3 | 6.313 | 7723.0 |
| 1270 | 2025-04-26 17:23:00 | canola | 3 | 112716 | 514 | 36.753 | 3066.9 |
| 1269 | 2025-04-23 13:14:37 | canola | 2 | 82551 | 45 | 17.613 | 4686.9 |
| 1268 | 2025-04-22 13:53:07 | canola | 3 | 112716 | 514 | 5.500 | 20493.8 |
| 1267 | 2025-04-21 09:31:40 | canola | 3 | 112716 | 514 | 49.346 | 2284.2 |
| 1266 | 2025-04-21 04:22:21 | canola | 2 | 82551 | 45 | 13.940 | 5921.9 |
| 1265 | 2025-04-20 11:50:23 | canola | 1 | 48755 | 3 | 2.593 | 18802.5 |