History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shearer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 509 | 2025-10-09 18:02:03 | shearer | 1 | 69583 | 10 | 1.203 | 57841.2 |
| 508 | 2025-10-05 18:54:53 | shearer | 1 | 69583 | 10 | 1.170 | 59472.6 |
| 507 | 2025-10-01 21:26:09 | shearer | 1 | 69583 | 10 | 1.233 | 56433.9 |
| 506 | 2025-09-16 17:39:00 | shearer | 1 | 69583 | 10 | 1.236 | 56296.9 |
| 505 | 2025-09-07 19:01:08 | shearer | 1 | 69583 | 10 | 1.250 | 55666.4 |
| 504 | 2025-08-27 02:10:30 | shearer | 1 | 69583 | 10 | 1.296 | 53690.6 |
| 503 | 2025-08-26 19:27:46 | shearer | 1 | 69583 | 10 | 1.296 | 53690.6 |
| 502 | 2025-08-23 03:46:53 | shearer | 1 | 69583 | 10 | 2.906 | 23944.6 |
| 501 | 2025-08-01 17:39:59 | shearer | 2 | 107671 | 79 | 9.580 | 11239.1 |
| 500 | 2025-08-01 03:07:21 | shearer | 1 | 69583 | 10 | 7.140 | 9745.5 |
| 499 | 2025-07-31 02:41:00 | shearer | 1 | 69583 | 10 | 2.126 | 32729.5 |
| 498 | 2025-07-29 16:17:56 | shearer | 1 | 69583 | 10 | 6.143 | 11327.2 |
| 497 | 2025-07-24 04:04:24 | shearer | 1 | 69583 | 10 | 6.750 | 10308.6 |
| 496 | 2025-07-23 18:47:39 | shearer | 1 | 69583 | 10 | 6.216 | 11194.2 |
| 495 | 2025-07-23 07:00:47 | shearer | 1 | 69583 | 10 | 6.306 | 11034.4 |
| 494 | 2025-07-22 23:43:23 | shearer | 1 | 69583 | 10 | 4.703 | 14795.4 |
| 493 | 2025-07-22 22:37:23 | shearer | 1 | 69583 | 10 | 2.780 | 25029.9 |
| 492 | 2025-07-22 14:52:55 | shearer | 1 | 69583 | 10 | 5.533 | 12576.0 |
| 491 | 2025-07-22 12:57:48 | shearer | 1 | 69583 | 10 | 5.846 | 11902.7 |
| 490 | 2025-07-21 12:40:47 | shearer | 1 | 69583 | 10 | 1.313 | 52995.4 |
| 489 | 2025-07-20 12:17:13 | shearer | 2 | 107671 | 79 | 13.830 | 7785.3 |
| 488 | 2025-07-11 00:58:13 | shearer | 1 | 69583 | 10 | 8.373 | 8310.4 |
| 487 | 2025-07-10 18:59:32 | shearer | 1 | 69583 | 10 | 8.906 | 7813.0 |
| 486 | 2025-07-02 12:40:09 | shearer | 2 | 107671 | 79 | 9.346 | 11520.5 |
| 485 | 2025-07-01 02:44:35 | shearer | 1 | 69583 | 10 | 1.376 | 50569.0 |
| 484 | 2025-06-30 22:29:09 | shearer | 1 | 69583 | 10 | 1.280 | 54361.7 |
| 483 | 2025-06-29 19:01:06 | shearer | 1 | 69583 | 10 | 1.280 | 54361.7 |
| 482 | 2025-06-20 16:35:09 | shearer | 1 | 69583 | 10 | 4.673 | 14890.4 |
| 481 | 2025-06-20 04:12:54 | shearer | 1 | 69583 | 10 | 6.186 | 11248.5 |
| 480 | 2025-06-20 03:52:55 | shearer | 1 | 69583 | 10 | 3.970 | 17527.2 |
| 479 | 2025-06-20 03:30:34 | shearer | 1 | 69583 | 10 | 6.203 | 11217.6 |
| 478 | 2025-06-15 10:43:36 | shearer | 1 | 69583 | 10 | 1.373 | 50679.5 |
| 477 | 2025-06-14 20:17:13 | shearer | 1 | 69583 | 10 | 8.780 | 7925.2 |
| 476 | 2025-06-14 09:49:15 | shearer | 3 | 134027 | 662 | 36.000 | 3723.0 |
| 475 | 2025-06-13 22:24:17 | shearer | 3 | 134027 | 662 | 22.283 | 6014.8 |
| 474 | 2025-06-13 13:56:57 | shearer | 2 | 107671 | 79 | 3.453 | 31181.9 |
| 473 | 2025-06-13 08:56:22 | shearer | 3 | 134027 | 662 | 29.020 | 4618.4 |
| 472 | 2025-06-12 21:44:12 | shearer | 1 | 69583 | 10 | 7.750 | 8978.5 |
| 471 | 2025-06-11 19:59:16 | shearer | 1 | 69583 | 10 | 5.876 | 11841.9 |
| 470 | 2025-05-20 13:29:02 | shearer | 1 | 69583 | 10 | 4.063 | 17126.0 |
| 469 | 2025-05-20 04:19:45 | shearer | 1 | 69583 | 10 | 4.766 | 14599.9 |
| 468 | 2025-05-11 20:14:42 | shearer | 1 | 69583 | 10 | 3.046 | 22844.1 |
| 467 | 2025-05-09 09:19:16 | shearer | 1 | 69583 | 10 | 1.250 | 55666.4 |
| 466 | 2025-04-30 02:34:04 | shearer | 1 | 69583 | 10 | 6.220 | 11187.0 |
| 465 | 2025-04-26 09:40:43 | shearer | 3 | 134027 | 662 | 23.876 | 5613.5 |
| 464 | 2025-04-24 08:30:08 | shearer | 3 | 134027 | 662 | 38.703 | 3463.0 |
| 463 | 2025-04-23 05:28:14 | shearer | 3 | 134027 | 662 | 26.110 | 5133.2 |
| 462 | 2025-04-22 22:16:42 | shearer | 3 | 134027 | 662 | 24.953 | 5371.2 |
| 461 | 2025-04-22 11:09:08 | shearer | 1 | 69583 | 10 | 1.186 | 58670.3 |
| 460 | 2025-04-21 17:56:32 | shearer | 3 | 134027 | 662 | 40.406 | 3317.0 |
| 459 | 2025-04-20 12:07:39 | shearer | 1 | 69583 | 10 | 7.923 | 8782.4 |
| 458 | 2025-04-20 03:17:02 | shearer | 1 | 69583 | 10 | 5.300 | 13128.9 |
| 457 | 2025-04-20 02:37:08 | shearer | 1 | 69583 | 10 | 3.046 | 22844.1 |
| 456 | 2025-04-20 02:05:50 | shearer | 1 | 69583 | 10 | 6.050 | 11501.3 |
| 455 | 2025-04-10 20:27:47 | shearer | 1 | 69583 | 10 | 2.936 | 23699.9 |
| 454 | 2025-03-29 04:20:49 | shearer | 1 | 69583 | 10 | 6.030 | 11539.5 |
| 453 | 2025-03-20 14:52:30 | shearer | 1 | 69583 | 10 | 3.016 | 23071.3 |
| 452 | 2025-03-20 05:21:20 | shearer | 1 | 69583 | 10 | 3.906 | 17814.4 |
| 451 | 2025-03-20 03:28:51 | shearer | 1 | 69583 | 10 | 4.783 | 14548.0 |
| 450 | 2025-03-19 22:53:11 | shearer | 2 | 107671 | 79 | 8.343 | 12905.5 |
| 449 | 2025-03-19 03:49:09 | shearer | 1 | 69583 | 10 | 1.280 | 54361.7 |
| 448 | 2025-03-14 12:16:12 | shearer | 1 | 69583 | 10 | 1.063 | 65459.1 |
| 447 | 2025-03-10 17:10:11 | shearer | 3 | 134027 | 662 | 30.250 | 4430.6 |
| 446 | 2025-03-10 04:03:00 | shearer | 2 | 107671 | 79 | 21.110 | 5100.5 |
| 445 | 2025-03-09 06:48:57 | shearer | 2 | 107671 | 79 | 16.236 | 6631.6 |
| 444 | 2025-03-09 06:05:18 | shearer | 3 | 134027 | 662 | 33.676 | 3979.9 |
| 443 | 2025-03-08 22:08:15 | shearer | 2 | 107671 | 79 | 14.406 | 7474.0 |
| 442 | 2025-03-08 20:58:09 | shearer | 3 | 134027 | 662 | 38.033 | 3524.0 |
| 441 | 2025-03-08 09:42:10 | shearer | 3 | 134027 | 662 | 35.783 | 3745.5 |
| 440 | 2025-03-08 07:33:44 | shearer | 1 | 69583 | 10 | 7.140 | 9745.5 |
| 439 | 2025-03-08 07:33:16 | shearer | 3 | 134027 | 662 | 26.326 | 5091.1 |
| 438 | 2025-03-08 07:33:14 | shearer | 2 | 107671 | 79 | 14.783 | 7283.4 |
| 437 | 2025-03-04 10:18:25 | shearer | 1 | 69583 | 10 | 3.030 | 22964.7 |
| 436 | 2025-02-23 00:03:33 | shearer | 1 | 69583 | 10 | 3.110 | 22374.0 |
| 435 | 2025-02-14 18:37:30 | shearer | 1 | 69583 | 10 | 6.203 | 11217.6 |
| 434 | 2025-02-02 16:54:08 | shearer | 1 | 69583 | 10 | 6.453 | 10783.0 |
| 433 | 2025-01-28 13:52:07 | shearer | 1 | 69583 | 10 | 4.263 | 16322.5 |
| 432 | 2025-01-19 12:06:48 | shearer | 1 | 69583 | 10 | 3.373 | 20629.4 |
| 431 | 2025-01-14 05:13:32 | shearer | 1 | 69583 | 10 | 5.686 | 12237.6 |
| 430 | 2024-12-29 03:28:31 | shearer | 1 | 69583 | 10 | 6.813 | 10213.3 |
| 429 | 2024-12-28 12:38:51 | shearer | 1 | 69583 | 10 | 3.126 | 22259.4 |
| 428 | 2024-12-11 00:52:19 | shearer | 1 | 69583 | 10 | 3.530 | 19711.9 |
| 427 | 2024-11-28 21:58:49 | shearer | 1 | 69583 | 10 | 7.313 | 9515.0 |
| 426 | 2024-11-11 04:15:14 | shearer | 1 | 69583 | 10 | 6.000 | 11597.2 |
| 425 | 2024-10-28 10:11:40 | shearer | 1 | 69583 | 10 | 6.000 | 11597.2 |
| 424 | 2024-10-13 20:26:51 | shearer | 3 | 134027 | 662 | 32.046 | 4182.3 |
| 423 | 2024-10-13 11:41:47 | shearer | 3 | 134027 | 662 | 20.406 | 6568.0 |
| 422 | 2024-10-13 06:44:35 | shearer | 3 | 134027 | 662 | 44.860 | 2987.7 |
| 421 | 2024-10-11 04:58:09 | shearer | 3 | 134027 | 662 | 28.423 | 4715.4 |
| 420 | 2024-10-11 04:58:08 | shearer | 2 | 107671 | 79 | 16.406 | 6562.9 |
| 419 | 2024-10-11 04:58:03 | shearer | 1 | 69583 | 10 | 3.060 | 22739.5 |
| 418 | 2024-10-08 05:06:41 | shearer | 1 | 69583 | 10 | 9.453 | 7360.9 |
| 417 | 2024-10-07 00:15:33 | shearer | 1 | 69583 | 10 | 4.953 | 14048.7 |
| 416 | 2024-10-07 00:15:14 | shearer | 1 | 69583 | 10 | 9.126 | 7624.7 |
| 415 | 2024-10-06 23:57:00 | shearer | 1 | 69583 | 10 | 4.390 | 15850.3 |
| 414 | 2024-10-03 00:07:48 | shearer | 1 | 69583 | 10 | 6.110 | 11388.4 |
| 413 | 2024-09-24 08:05:44 | shearer | 1 | 69583 | 10 | 9.110 | 7638.1 |
| 412 | 2024-09-09 01:51:00 | shearer | 1 | 69583 | 10 | 1.143 | 60877.5 |
| 411 | 2024-09-08 10:54:01 | shearer | 1 | 69583 | 10 | 4.436 | 15686.0 |
| 410 | 2024-09-06 03:17:53 | shearer | 1 | 69583 | 10 | 9.593 | 7253.5 |