History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spanner"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 649 | 2025-11-21 00:12:58 | spanner | 1 | 69583 | 8 | 1.606 | 43326.9 |
| 648 | 2025-11-19 19:47:05 | spanner | 3 | 134027 | 637 | 5.966 | 22465.1 |
| 647 | 2025-11-15 03:39:46 | spanner | 3 | 134027 | 637 | 7.033 | 19056.9 |
| 646 | 2025-10-25 16:17:33 | spanner | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 645 | 2025-10-24 05:26:00 | spanner | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 644 | 2025-10-22 16:56:29 | spanner | 3 | 134027 | 637 | 21.906 | 6118.3 |
| 643 | 2025-10-19 22:57:54 | spanner | 1 | 69583 | 8 | 1.500 | 46388.7 |
| 642 | 2025-10-17 14:28:34 | spanner | 1 | 69583 | 8 | 1.106 | 62914.1 |
| 641 | 2025-10-11 13:00:05 | spanner | 1 | 69583 | 8 | 1.110 | 62687.4 |
| 640 | 2025-10-10 17:36:00 | spanner | 3 | 134027 | 637 | 7.063 | 18975.9 |
| 639 | 2025-10-04 01:41:22 | spanner | 1 | 69583 | 8 | 1.140 | 61037.7 |
| 638 | 2025-09-19 01:13:24 | spanner | 1 | 69583 | 8 | 1.313 | 52995.4 |
| 637 | 2025-09-15 12:24:14 | spanner | 3 | 134027 | 637 | 8.736 | 15341.9 |
| 636 | 2025-09-14 14:46:21 | spanner | 3 | 134027 | 637 | 12.750 | 10511.9 |
| 635 | 2025-09-02 18:47:57 | spanner | 2 | 107671 | 74 | 3.390 | 31761.4 |
| 634 | 2025-09-01 14:15:37 | spanner | 1 | 69583 | 8 | 1.200 | 57985.8 |
| 633 | 2025-08-27 13:48:15 | spanner | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 632 | 2025-08-27 07:24:17 | spanner | 1 | 69583 | 8 | 1.143 | 60877.5 |
| 631 | 2025-08-26 10:28:08 | spanner | 1 | 69583 | 8 | 2.936 | 23699.9 |
| 630 | 2025-08-25 03:56:08 | spanner | 1 | 69583 | 8 | 3.923 | 17737.2 |
| 629 | 2025-08-10 09:56:01 | spanner | 1 | 69583 | 8 | 5.436 | 12800.4 |
| 628 | 2025-07-26 09:24:55 | spanner | 1 | 69583 | 8 | 5.906 | 11781.7 |
| 627 | 2025-07-25 08:40:00 | spanner | 1 | 69583 | 8 | 8.233 | 8451.7 |
| 626 | 2025-07-23 06:15:47 | spanner | 1 | 69583 | 8 | 8.626 | 8066.7 |
| 625 | 2025-07-11 16:37:10 | spanner | 2 | 107671 | 74 | 15.533 | 6931.8 |
| 624 | 2025-07-11 09:36:47 | spanner | 1 | 69583 | 8 | 9.503 | 7322.2 |
| 623 | 2025-07-10 09:37:27 | spanner | 1 | 69583 | 8 | 1.283 | 54234.6 |
| 622 | 2025-06-30 14:52:55 | spanner | 1 | 69583 | 8 | 6.263 | 11110.2 |
| 621 | 2025-06-30 02:33:17 | spanner | 1 | 69583 | 8 | 5.203 | 13373.6 |
| 620 | 2025-06-27 12:04:08 | spanner | 2 | 107671 | 74 | 8.326 | 12931.9 |
| 619 | 2025-06-26 14:50:29 | spanner | 1 | 69583 | 8 | 7.810 | 8909.5 |
| 618 | 2025-06-26 13:35:35 | spanner | 2 | 107671 | 74 | 13.593 | 7921.1 |
| 617 | 2025-06-24 13:19:21 | spanner | 2 | 107671 | 74 | 15.813 | 6809.0 |
| 616 | 2025-06-24 05:30:12 | spanner | 1 | 69583 | 8 | 4.423 | 15732.1 |
| 615 | 2025-06-21 08:07:31 | spanner | 1 | 69583 | 8 | 3.500 | 19880.9 |
| 614 | 2025-06-20 18:37:13 | spanner | 1 | 69583 | 8 | 4.596 | 15139.9 |
| 613 | 2025-06-14 21:01:20 | spanner | 1 | 69583 | 8 | 6.126 | 11358.6 |
| 612 | 2025-06-12 09:42:14 | spanner | 1 | 69583 | 8 | 6.640 | 10479.4 |
| 611 | 2025-06-10 18:17:34 | spanner | 1 | 69583 | 8 | 5.920 | 11753.9 |
| 610 | 2025-06-10 08:21:49 | spanner | 1 | 69583 | 8 | 6.500 | 10705.1 |
| 609 | 2025-05-12 11:51:59 | spanner | 1 | 69583 | 8 | 7.643 | 9104.1 |
| 608 | 2025-05-10 08:12:10 | spanner | 1 | 69583 | 8 | 6.983 | 9964.6 |
| 607 | 2025-05-08 21:14:26 | spanner | 1 | 69583 | 8 | 8.970 | 7757.3 |
| 606 | 2025-04-27 12:07:06 | spanner | 1 | 69583 | 8 | 1.266 | 54962.9 |
| 605 | 2025-04-26 17:08:23 | spanner | 1 | 69583 | 8 | 3.780 | 18408.2 |
| 604 | 2025-04-20 13:11:33 | spanner | 2 | 107671 | 74 | 17.860 | 6028.6 |
| 603 | 2025-04-20 12:53:51 | spanner | 1 | 69583 | 8 | 1.110 | 62687.4 |
| 602 | 2025-04-20 06:45:36 | spanner | 1 | 69583 | 8 | 6.716 | 10360.8 |
| 601 | 2025-04-19 18:54:43 | spanner | 1 | 69583 | 8 | 1.233 | 56433.9 |
| 600 | 2025-04-18 12:51:35 | spanner | 2 | 107671 | 74 | 11.423 | 9425.8 |
| 599 | 2025-04-18 12:33:29 | spanner | 1 | 69583 | 8 | 6.876 | 10119.7 |
| 598 | 2025-04-17 19:07:04 | spanner | 1 | 69583 | 8 | 1.156 | 60192.9 |
| 597 | 2025-04-17 10:23:23 | spanner | 3 | 134027 | 637 | 7.046 | 19021.7 |
| 596 | 2025-04-16 13:51:13 | spanner | 3 | 134027 | 637 | 34.066 | 3934.3 |
| 595 | 2025-04-16 05:43:44 | spanner | 3 | 134027 | 637 | 37.753 | 3550.1 |
| 594 | 2025-04-14 09:25:15 | spanner | 3 | 134027 | 637 | 35.250 | 3802.2 |
| 593 | 2025-04-14 07:56:42 | spanner | 3 | 134027 | 637 | 34.943 | 3835.6 |
| 592 | 2025-04-14 02:47:34 | spanner | 3 | 134027 | 637 | 25.423 | 5271.9 |
| 591 | 2025-04-12 02:05:33 | spanner | 3 | 134027 | 637 | 41.126 | 3258.9 |
| 590 | 2025-04-02 04:24:16 | spanner | 1 | 69583 | 8 | 2.466 | 28217.0 |
| 589 | 2025-04-01 18:42:45 | spanner | 1 | 69583 | 8 | 1.670 | 41666.5 |
| 588 | 2025-03-27 15:15:16 | spanner | 1 | 69583 | 8 | 6.016 | 11566.3 |
| 587 | 2025-03-23 12:43:24 | spanner | 1 | 69583 | 8 | 3.216 | 21636.5 |
| 586 | 2025-03-21 14:55:05 | spanner | 1 | 69583 | 8 | 3.123 | 22280.8 |
| 585 | 2025-03-20 16:07:31 | spanner | 1 | 69583 | 8 | 4.253 | 16360.9 |
| 584 | 2025-03-08 06:08:06 | spanner | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 583 | 2025-03-03 22:35:04 | spanner | 2 | 107671 | 74 | 19.080 | 5643.1 |
| 582 | 2025-03-03 10:22:57 | spanner | 2 | 107671 | 74 | 16.970 | 6344.8 |
| 581 | 2025-03-02 15:17:22 | spanner | 1 | 69583 | 8 | 6.500 | 10705.1 |
| 580 | 2025-03-02 12:42:10 | spanner | 2 | 107671 | 74 | 8.546 | 12599.0 |
| 579 | 2025-02-27 21:42:19 | spanner | 3 | 134027 | 637 | 42.000 | 3191.1 |
| 578 | 2025-02-27 07:43:54 | spanner | 3 | 134027 | 637 | 46.736 | 2867.7 |
| 577 | 2025-02-21 13:53:21 | spanner | 3 | 134027 | 637 | 28.016 | 4783.9 |
| 576 | 2025-02-21 00:12:27 | spanner | 2 | 107671 | 74 | 19.690 | 5468.3 |
| 575 | 2025-02-19 21:27:22 | spanner | 3 | 134027 | 637 | 34.643 | 3868.8 |
| 574 | 2025-02-19 01:36:44 | spanner | 3 | 134027 | 637 | 20.500 | 6537.9 |
| 573 | 2025-02-19 01:36:42 | spanner | 2 | 107671 | 74 | 16.813 | 6404.0 |
| 572 | 2025-02-19 01:36:24 | spanner | 1 | 69583 | 8 | 7.486 | 9295.1 |
| 571 | 2025-02-11 09:44:25 | spanner | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 570 | 2025-02-08 15:08:23 | spanner | 1 | 69583 | 8 | 7.470 | 9315.0 |
| 569 | 2025-02-08 05:57:41 | spanner | 1 | 69583 | 8 | 5.876 | 11841.9 |
| 568 | 2025-02-05 09:38:42 | spanner | 1 | 69583 | 8 | 5.843 | 11908.8 |
| 567 | 2025-01-31 13:44:38 | spanner | 3 | 134027 | 637 | 19.940 | 6721.5 |
| 566 | 2025-01-26 05:09:33 | spanner | 1 | 69583 | 8 | 3.470 | 20052.7 |
| 565 | 2025-01-23 07:17:45 | spanner | 1 | 69583 | 8 | 6.236 | 11158.3 |
| 564 | 2025-01-15 03:56:23 | spanner | 1 | 69583 | 8 | 7.860 | 8852.8 |
| 563 | 2025-01-15 01:58:18 | spanner | 3 | 134027 | 637 | 34.306 | 3906.8 |
| 562 | 2025-01-14 04:10:25 | spanner | 3 | 134027 | 637 | 23.566 | 5687.3 |
| 561 | 2025-01-12 04:12:34 | spanner | 3 | 134027 | 637 | 29.376 | 4562.5 |
| 560 | 2025-01-11 23:03:46 | spanner | 3 | 134027 | 637 | 28.890 | 4639.2 |
| 559 | 2025-01-08 09:34:46 | spanner | 2 | 107671 | 74 | 4.516 | 23842.1 |
| 558 | 2025-01-08 09:34:36 | spanner | 1 | 69583 | 8 | 2.893 | 24052.2 |
| 557 | 2025-01-07 18:04:00 | spanner | 3 | 134027 | 637 | 28.610 | 4684.6 |
| 556 | 2024-12-25 10:43:44 | spanner | 1 | 69583 | 8 | 7.156 | 9723.7 |
| 555 | 2024-12-19 17:18:36 | spanner | 1 | 69583 | 8 | 4.750 | 14649.1 |
| 554 | 2024-12-13 12:37:37 | spanner | 3 | 134027 | 637 | 30.530 | 4390.0 |
| 553 | 2024-12-13 08:44:57 | spanner | 3 | 134027 | 637 | 23.250 | 5764.6 |
| 552 | 2024-12-12 05:33:40 | spanner | 3 | 134027 | 637 | 35.250 | 3802.2 |
| 551 | 2024-12-12 05:00:14 | spanner | 3 | 134027 | 637 | 33.753 | 3970.8 |
| 550 | 2024-12-12 05:00:11 | spanner | 2 | 107671 | 74 | 16.920 | 6363.5 |