History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"catchments"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 430 | 2025-09-10 07:04:53 | catchments | 4 | 161450 | 186 | 12.016 | 13436.3 |
| 429 | 2025-09-05 23:06:07 | catchments | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 428 | 2025-08-25 14:10:01 | catchments | 4 | 161450 | 186 | 51.816 | 3115.8 |
| 427 | 2025-08-19 10:51:54 | catchments | 4 | 161450 | 186 | 43.940 | 3674.3 |
| 426 | 2025-08-17 14:18:21 | catchments | 2 | 108824 | 5 | 8.016 | 13575.8 |
| 425 | 2025-08-17 04:41:50 | catchments | 4 | 161450 | 186 | 28.253 | 5714.4 |
| 424 | 2025-08-16 04:03:12 | catchments | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 423 | 2025-08-12 10:48:45 | catchments | 3 | 140603 | 23 | 13.970 | 10064.6 |
| 422 | 2025-08-11 22:35:02 | catchments | 2 | 108824 | 5 | 7.876 | 13817.2 |
| 421 | 2025-08-11 21:55:38 | catchments | 3 | 140603 | 23 | 15.220 | 9238.0 |
| 420 | 2025-08-10 14:00:52 | catchments | 3 | 140603 | 23 | 14.843 | 9472.7 |
| 419 | 2025-08-10 10:03:51 | catchments | 2 | 108824 | 5 | 7.876 | 13817.2 |
| 418 | 2025-08-09 09:31:01 | catchments | 1 | 67641 | 3 | 2.343 | 28869.4 |
| 417 | 2025-08-08 22:48:04 | catchments | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 416 | 2025-08-04 23:39:57 | catchments | 1 | 67641 | 3 | 8.530 | 7929.8 |
| 415 | 2025-07-25 07:30:15 | catchments | 1 | 67641 | 3 | 3.033 | 22301.7 |
| 414 | 2025-07-07 21:45:24 | catchments | 2 | 108824 | 5 | 15.530 | 7007.3 |
| 413 | 2025-07-07 05:30:11 | catchments | 1 | 67641 | 3 | 3.170 | 21337.9 |
| 412 | 2025-07-04 04:32:30 | catchments | 3 | 140603 | 23 | 40.393 | 3480.9 |
| 411 | 2025-07-04 03:09:28 | catchments | 2 | 108824 | 5 | 15.533 | 7006.0 |
| 410 | 2025-07-04 00:21:48 | catchments | 3 | 140603 | 23 | 33.663 | 4176.8 |
| 409 | 2025-07-02 22:33:32 | catchments | 1 | 67641 | 3 | 2.766 | 24454.4 |
| 408 | 2025-06-29 04:27:50 | catchments | 3 | 140603 | 23 | 5.796 | 24258.6 |
| 407 | 2025-06-26 16:31:49 | catchments | 1 | 67641 | 3 | 8.266 | 8183.0 |
| 406 | 2025-06-24 17:28:03 | catchments | 1 | 67641 | 3 | 2.780 | 24331.3 |
| 405 | 2025-06-21 21:51:18 | catchments | 1 | 67641 | 3 | 5.720 | 11825.3 |
| 404 | 2025-06-12 09:10:13 | catchments | 1 | 67641 | 3 | 2.233 | 30291.5 |
| 403 | 2025-06-01 10:18:03 | catchments | 1 | 67641 | 3 | 3.360 | 20131.3 |
| 402 | 2025-05-27 00:07:14 | catchments | 1 | 67641 | 3 | 4.456 | 15179.8 |
| 401 | 2025-05-26 05:29:21 | catchments | 3 | 140603 | 23 | 36.453 | 3857.1 |
| 400 | 2025-05-26 03:10:26 | catchments | 2 | 108824 | 5 | 14.656 | 7425.2 |
| 399 | 2025-05-26 01:07:29 | catchments | 3 | 140603 | 23 | 33.330 | 4218.5 |
| 398 | 2025-05-24 22:23:26 | catchments | 1 | 67641 | 3 | 5.733 | 11798.5 |
| 397 | 2025-05-20 03:56:35 | catchments | 1 | 67641 | 3 | 6.466 | 10461.0 |
| 396 | 2025-05-14 15:44:01 | catchments | 3 | 140603 | 23 | 23.596 | 5958.8 |
| 395 | 2025-05-14 08:07:39 | catchments | 3 | 140603 | 23 | 24.500 | 5738.9 |
| 394 | 2025-05-14 04:44:09 | catchments | 1 | 67641 | 3 | 6.050 | 11180.3 |
| 393 | 2025-05-03 07:59:48 | catchments | 3 | 140603 | 23 | 30.250 | 4648.0 |
| 392 | 2025-05-02 13:03:47 | catchments | 3 | 140603 | 23 | 26.643 | 5277.3 |
| 391 | 2025-05-01 04:24:04 | catchments | 3 | 140603 | 23 | 31.173 | 4510.4 |
| 390 | 2025-04-30 15:17:30 | catchments | 1 | 67641 | 3 | 5.516 | 12262.7 |
| 389 | 2025-04-28 09:06:54 | catchments | 1 | 67641 | 3 | 3.123 | 21659.0 |
| 388 | 2025-04-27 17:07:25 | catchments | 3 | 140603 | 23 | 11.453 | 12276.5 |
| 387 | 2025-04-25 01:05:12 | catchments | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 386 | 2025-04-21 08:07:06 | catchments | 1 | 67641 | 3 | 5.360 | 12619.6 |
| 385 | 2025-03-10 08:05:51 | catchments | 3 | 140603 | 23 | 32.236 | 4361.7 |
| 384 | 2025-03-10 08:05:49 | catchments | 2 | 108824 | 5 | 7.846 | 13870.0 |
| 383 | 2025-03-05 07:29:44 | catchments | 3 | 140603 | 23 | 31.626 | 4445.8 |
| 382 | 2025-02-26 00:37:30 | catchments | 1 | 67641 | 3 | 5.250 | 12884.0 |
| 381 | 2025-02-24 15:54:02 | catchments | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 380 | 2025-02-21 08:47:29 | catchments | 3 | 140603 | 23 | 34.706 | 4051.3 |
| 379 | 2025-02-18 08:00:12 | catchments | 1 | 67641 | 3 | 5.393 | 12542.4 |
| 378 | 2025-02-17 11:07:05 | catchments | 3 | 140603 | 23 | 32.156 | 4372.5 |
| 377 | 2025-02-11 10:45:39 | catchments | 1 | 67641 | 3 | 6.033 | 11211.8 |
| 376 | 2025-02-05 22:57:19 | catchments | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 375 | 2025-01-18 08:31:33 | catchments | 3 | 140603 | 23 | 46.426 | 3028.5 |
| 374 | 2025-01-15 03:11:30 | catchments | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 373 | 2025-01-08 21:55:49 | catchments | 3 | 140603 | 23 | 37.270 | 3772.6 |
| 372 | 2025-01-07 14:46:13 | catchments | 4 | 161450 | 186 | 75.036 | 2151.6 |
| 371 | 2025-01-05 12:15:40 | catchments | 1 | 67641 | 3 | 2.483 | 27241.6 |
| 370 | 2025-01-04 21:09:24 | catchments | 4 | 161450 | 186 | 60.003 | 2690.7 |
| 369 | 2025-01-02 16:36:49 | catchments | 4 | 161450 | 186 | 49.763 | 3244.4 |
| 368 | 2025-01-01 22:45:29 | catchments | 4 | 161450 | 186 | 45.910 | 3516.7 |
| 367 | 2025-01-01 22:45:32 | catchments | 2 | 108824 | 5 | 15.656 | 6950.9 |
| 366 | 2024-12-21 00:40:26 | catchments | 1 | 67641 | 3 | 2.690 | 25145.4 |
| 365 | 2024-12-08 05:37:56 | catchments | 3 | 140603 | 23 | 27.610 | 5092.5 |
| 364 | 2024-12-08 05:34:02 | catchments | 1 | 67641 | 3 | 4.453 | 15190.0 |
| 363 | 2024-12-07 02:13:00 | catchments | 3 | 140603 | 23 | 32.503 | 4325.8 |
| 362 | 2024-12-05 16:50:55 | catchments | 3 | 140603 | 23 | 38.453 | 3656.5 |
| 361 | 2024-12-05 16:27:12 | catchments | 1 | 67641 | 3 | 8.453 | 8002.0 |
| 360 | 2024-12-04 01:13:06 | catchments | 3 | 140603 | 23 | 5.923 | 23738.5 |
| 359 | 2024-11-28 10:59:28 | catchments | 1 | 67641 | 3 | 2.296 | 29460.4 |
| 358 | 2024-11-19 07:50:38 | catchments | 2 | 108824 | 5 | 14.540 | 7484.5 |
| 357 | 2024-11-19 07:19:37 | catchments | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 356 | 2024-11-04 03:01:06 | catchments | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 355 | 2024-10-28 17:33:09 | catchments | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 354 | 2024-10-28 13:10:15 | catchments | 3 | 140603 | 23 | 42.176 | 3333.7 |
| 353 | 2024-10-25 19:11:59 | catchments | 3 | 140603 | 23 | 29.203 | 4814.7 |
| 352 | 2024-10-25 19:11:50 | catchments | 2 | 108824 | 5 | 17.156 | 6343.2 |
| 351 | 2024-10-25 19:04:59 | catchments | 1 | 67641 | 3 | 3.280 | 20622.3 |
| 350 | 2024-10-10 06:39:25 | catchments | 2 | 108824 | 5 | 15.250 | 7136.0 |
| 349 | 2024-10-05 12:20:51 | catchments | 1 | 67641 | 3 | 9.546 | 7085.8 |
| 348 | 2024-09-30 20:37:02 | catchments | 2 | 108824 | 5 | 16.500 | 6595.4 |
| 347 | 2024-09-30 20:34:27 | catchments | 1 | 67641 | 3 | 7.860 | 8605.7 |
| 346 | 2024-09-18 05:00:44 | catchments | 3 | 140603 | 23 | 64.740 | 2171.8 |
| 345 | 2024-09-11 08:33:10 | catchments | 3 | 140603 | 23 | 52.563 | 2674.9 |
| 344 | 2024-08-23 02:42:17 | catchments | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 343 | 2024-08-13 14:28:23 | catchments | 3 | 140603 | 23 | 44.503 | 3159.4 |
| 342 | 2024-08-13 14:27:20 | catchments | 3 | 140603 | 23 | 50.190 | 2801.4 |
| 341 | 2024-08-10 02:21:33 | catchments | 1 | 67641 | 3 | 3.626 | 18654.4 |
| 340 | 2024-07-31 02:35:54 | catchments | 3 | 140603 | 23 | 29.296 | 4799.4 |
| 339 | 2024-07-31 02:35:52 | catchments | 2 | 108824 | 5 | 12.546 | 8674.0 |
| 338 | 2024-07-31 02:35:47 | catchments | 3 | 140603 | 23 | 15.623 | 8999.7 |
| 337 | 2024-07-31 02:13:36 | catchments | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 336 | 2024-07-22 23:58:33 | catchments | 3 | 140603 | 23 | 42.533 | 3305.7 |
| 335 | 2024-07-22 06:11:15 | catchments | 3 | 140603 | 23 | 20.546 | 6843.3 |
| 333 | 2024-07-22 06:11:12 | catchments | 3 | 140603 | 23 | 23.953 | 5870.0 |
| 332 | 2024-07-22 06:11:13 | catchments | 2 | 108824 | 5 | 12.500 | 8705.9 |
| 331 | 2024-07-22 06:07:20 | catchments | 1 | 67641 | 3 | 2.170 | 31171.0 |