History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pillar"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 679 | 2024-05-09 16:43:27 | pillar | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 678 | 2024-05-04 07:43:21 | pillar | 1 | 48755 | 4 | 1.936 | 25183.4 |
| 677 | 2024-05-04 07:42:24 | pillar | 1 | 48755 | 4 | 0.923 | 52822.3 |
| 676 | 2024-05-02 01:38:36 | pillar | 3 | 112716 | 572 | 10.440 | 10796.6 |
| 675 | 2024-04-30 14:05:31 | pillar | 3 | 112716 | 572 | 10.843 | 10395.3 |
| 674 | 2024-04-23 14:59:06 | pillar | 1 | 48755 | 4 | 3.623 | 13457.1 |
| 673 | 2024-04-23 14:21:09 | pillar | 1 | 48755 | 4 | 1.720 | 28345.9 |
| 672 | 2024-04-23 02:33:38 | pillar | 3 | 112716 | 572 | 9.720 | 11596.3 |
| 671 | 2024-04-23 01:46:12 | pillar | 2 | 82551 | 50 | 5.626 | 14673.1 |
| 670 | 2024-04-23 01:45:49 | pillar | 3 | 112716 | 572 | 6.000 | 18786.0 |
| 669 | 2024-04-20 21:23:35 | pillar | 3 | 112716 | 572 | 8.076 | 13956.9 |
| 668 | 2024-04-20 14:59:16 | pillar | 3 | 112716 | 572 | 10.253 | 10993.5 |
| 667 | 2024-04-19 07:02:48 | pillar | 2 | 82551 | 50 | 5.483 | 15055.8 |
| 666 | 2024-04-19 07:02:20 | pillar | 3 | 112716 | 572 | 7.170 | 15720.5 |
| 665 | 2024-04-19 03:10:52 | pillar | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 664 | 2024-04-16 16:23:33 | pillar | 3 | 112716 | 572 | 15.906 | 7086.4 |
| 663 | 2024-04-16 16:23:22 | pillar | 2 | 82551 | 50 | 6.046 | 13653.8 |
| 662 | 2024-04-14 09:11:05 | pillar | 2 | 82551 | 50 | 2.500 | 33020.4 |
| 661 | 2024-04-03 08:10:24 | pillar | 1 | 48755 | 4 | 1.953 | 24964.2 |
| 660 | 2024-03-31 10:27:31 | pillar | 1 | 48755 | 4 | 2.610 | 18680.1 |
| 659 | 2024-03-28 18:53:02 | pillar | 1 | 48755 | 4 | 0.950 | 51321.1 |
| 658 | 2024-03-26 00:12:28 | pillar | 1 | 48755 | 4 | 1.986 | 24549.3 |
| 657 | 2024-01-25 20:02:07 | pillar | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 656 | 2024-01-20 01:00:44 | pillar | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 655 | 2024-01-12 21:16:39 | pillar | 1 | 48755 | 4 | 0.783 | 62266.9 |
| 654 | 2023-12-31 21:09:48 | pillar | 3 | 112716 | 572 | 5.173 | 21789.3 |
| 653 | 2023-12-31 21:09:44 | pillar | 2 | 82551 | 50 | 2.250 | 36689.3 |
| 652 | 2023-12-15 00:02:18 | pillar | 3 | 112716 | 572 | 5.280 | 21347.7 |
| 651 | 2023-12-15 00:02:10 | pillar | 2 | 82551 | 50 | 2.436 | 33887.9 |
| 650 | 2023-12-14 22:07:12 | pillar | 3 | 112716 | 572 | 5.640 | 19985.1 |
| 649 | 2023-12-08 03:57:19 | pillar | 2 | 82551 | 50 | 2.220 | 37185.1 |
| 648 | 2023-12-08 03:57:16 | pillar | 2 | 82551 | 50 | 2.453 | 33653.1 |
| 647 | 2023-12-07 02:29:41 | pillar | 2 | 82551 | 50 | 2.530 | 32628.9 |
| 646 | 2023-11-22 08:20:45 | pillar | 1 | 48755 | 4 | 1.720 | 28345.9 |
| 645 | 2023-11-14 03:23:38 | pillar | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 644 | 2023-11-11 11:29:33 | pillar | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 643 | 2023-11-03 05:19:16 | pillar | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 642 | 2023-11-02 01:57:19 | pillar | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 641 | 2023-10-19 01:54:03 | pillar | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 640 | 2023-10-11 21:47:05 | pillar | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 639 | 2023-10-05 17:38:28 | pillar | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 638 | 2023-09-26 22:43:36 | pillar | 3 | 112716 | 572 | 10.610 | 10623.6 |
| 637 | 2023-09-26 22:43:39 | pillar | 2 | 82551 | 50 | 2.546 | 32423.8 |
| 636 | 2023-09-24 23:02:19 | pillar | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 635 | 2023-09-21 08:07:04 | pillar | 3 | 112716 | 572 | 4.783 | 23566.0 |
| 634 | 2023-09-19 21:23:10 | pillar | 1 | 48755 | 4 | 0.810 | 60191.4 |
| 633 | 2023-09-14 22:48:12 | pillar | 3 | 112716 | 572 | 4.813 | 23419.1 |
| 632 | 2023-09-12 18:46:24 | pillar | 1 | 48755 | 4 | 0.873 | 55847.7 |
| 631 | 2023-09-08 13:07:19 | pillar | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 630 | 2023-09-05 01:58:05 | pillar | 2 | 82551 | 50 | 2.156 | 38289.0 |
| 629 | 2023-06-30 05:34:13 | pillar | 3 | 112716 | 572 | 11.110 | 10145.5 |
| 628 | 2023-06-20 06:17:21 | pillar | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 627 | 2023-06-18 17:44:58 | pillar | 3 | 112716 | 572 | 4.640 | 24292.2 |
| 626 | 2023-06-02 16:10:58 | pillar | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 625 | 2023-05-26 05:39:33 | pillar | 2 | 82551 | 50 | 2.110 | 39123.7 |
| 624 | 2023-05-13 16:44:44 | pillar | 2 | 82551 | 50 | 2.203 | 37472.1 |
| 623 | 2023-04-08 15:47:38 | pillar | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 622 | 2023-04-01 03:28:50 | pillar | 2 | 82551 | 50 | 2.373 | 34787.6 |
| 621 | 2023-03-19 07:08:35 | pillar | 3 | 112716 | 572 | 5.406 | 20850.2 |
| 620 | 2023-03-07 01:22:46 | pillar | 2 | 82551 | 50 | 2.110 | 39123.7 |
| 619 | 2023-02-21 05:18:57 | pillar | 1 | 48755 | 4 | 0.733 | 66514.3 |
| 618 | 2023-02-02 16:05:59 | pillar | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 617 | 2022-12-19 21:13:46 | pillar | 3 | 112716 | 572 | 4.610 | 24450.3 |
| 616 | 2022-12-13 19:09:07 | pillar | 2 | 82551 | 50 | 2.393 | 34496.9 |
| 615 | 2022-11-30 23:46:06 | pillar | 1 | 48755 | 4 | 0.856 | 56956.8 |
| 614 | 2022-10-28 00:46:07 | pillar | 1 | 48755 | 4 | 1.686 | 28917.6 |
| 613 | 2022-08-25 20:43:23 | pillar | 3 | 112716 | 572 | 4.656 | 24208.8 |
| 612 | 2022-08-20 20:07:49 | pillar | 3 | 112716 | 572 | 4.673 | 24120.7 |
| 611 | 2022-08-05 01:16:31 | pillar | 2 | 82551 | 50 | 2.140 | 38575.2 |
| 610 | 2022-07-26 12:55:05 | pillar | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 609 | 2022-07-14 10:14:18 | pillar | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 608 | 2022-05-22 15:52:45 | pillar | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 607 | 2022-05-20 09:47:22 | pillar | 1 | 48755 | 4 | 0.796 | 61250.0 |
| 606 | 2022-05-01 14:59:23 | pillar | 1 | 48755 | 4 | 0.830 | 58741.0 |
| 605 | 2022-03-20 20:28:05 | pillar | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 604 | 2022-03-17 09:57:18 | pillar | 1 | 48755 | 4 | 1.063 | 45865.5 |
| 603 | 2022-02-03 23:19:05 | pillar | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 602 | 2022-02-01 20:12:49 | pillar | 1 | 48755 | 4 | 0.843 | 57835.1 |
| 601 | 2021-11-30 06:33:47 | pillar | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 600 | 2021-11-23 17:10:12 | pillar | 1 | 48755 | 4 | 0.906 | 53813.5 |
| 599 | 2021-10-07 10:32:45 | pillar | 1 | 48755 | 4 | 0.860 | 56691.9 |
| 598 | 2021-08-31 18:44:56 | pillar | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 597 | 2021-08-27 06:53:51 | pillar | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 596 | 2021-08-23 23:33:30 | pillar | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 595 | 2021-08-16 12:18:16 | pillar | 1 | 48755 | 4 | 0.736 | 66243.2 |
| 594 | 2021-07-05 13:59:47 | pillar | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 593 | 2021-05-30 12:22:07 | pillar | 3 | 112716 | 572 | 5.330 | 21147.5 |
| 592 | 2021-05-19 22:35:26 | pillar | 1 | 48755 | 4 | 0.953 | 51159.5 |
| 591 | 2021-04-19 15:28:21 | pillar | 1 | 48755 | 4 | 0.780 | 62506.4 |
| 590 | 2021-03-22 12:55:48 | pillar | 1 | 48755 | 4 | 1.486 | 32809.6 |
| 589 | 2021-02-17 02:36:25 | pillar | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 588 | 2021-02-09 12:29:12 | pillar | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 587 | 2021-01-04 07:49:21 | pillar | 1 | 48755 | 4 | 0.750 | 65006.7 |
| 586 | 2020-11-18 07:26:22 | pillar | 1 | 48755 | 4 | 0.890 | 54780.9 |
| 585 | 2020-11-07 19:39:16 | pillar | 1 | 48755 | 4 | 0.813 | 59969.2 |
| 584 | 2020-11-03 07:22:00 | pillar | 1 | 48755 | 4 | 0.936 | 52088.7 |
| 583 | 2020-11-02 09:33:50 | pillar | 1 | 48755 | 4 | 0.906 | 53813.5 |
| 582 | 2020-10-29 22:01:34 | pillar | 1 | 48755 | 4 | 0.766 | 63648.8 |
| 581 | 2020-10-19 03:11:41 | pillar | 2 | 82551 | 50 | 2.173 | 37989.4 |
| 580 | 2020-10-19 00:12:03 | pillar | 1 | 48755 | 4 | 0.763 | 63899.1 |