History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spotting"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 710 | 2025-11-13 17:22:11 | spotting | 1 | 82945 | 10 | 2.046 | 40540.1 |
| 709 | 2025-11-05 01:52:49 | spotting | 1 | 82945 | 10 | 1.516 | 54713.1 |
| 708 | 2025-11-03 04:40:30 | spotting | 1 | 82945 | 10 | 1.546 | 53651.4 |
| 707 | 2025-10-27 03:46:47 | spotting | 1 | 82945 | 10 | 1.500 | 55296.7 |
| 706 | 2025-10-21 16:12:47 | spotting | 1 | 82945 | 10 | 7.016 | 11822.3 |
| 705 | 2025-10-16 02:48:10 | spotting | 1 | 82945 | 10 | 1.343 | 61761.0 |
| 704 | 2025-10-02 12:17:03 | spotting | 1 | 82945 | 10 | 1.530 | 54212.4 |
| 703 | 2025-09-24 12:54:39 | spotting | 1 | 82945 | 10 | 1.343 | 61761.0 |
| 702 | 2025-09-17 19:59:27 | spotting | 1 | 82945 | 10 | 1.453 | 57085.3 |
| 701 | 2025-09-17 02:37:16 | spotting | 1 | 82945 | 10 | 1.330 | 62364.7 |
| 700 | 2025-09-12 00:00:19 | spotting | 1 | 82945 | 10 | 1.530 | 54212.4 |
| 699 | 2025-09-06 19:03:03 | spotting | 3 | 146162 | 479 | 7.813 | 18707.5 |
| 698 | 2025-09-04 08:46:49 | spotting | 1 | 82945 | 10 | 1.310 | 63316.8 |
| 697 | 2025-08-23 11:13:09 | spotting | 1 | 82945 | 10 | 6.046 | 13719.0 |
| 696 | 2025-08-10 23:47:22 | spotting | 1 | 82945 | 10 | 6.686 | 12405.8 |
| 695 | 2025-08-06 08:04:38 | spotting | 1 | 82945 | 10 | 10.640 | 7795.6 |
| 694 | 2025-08-05 13:43:40 | spotting | 1 | 82945 | 10 | 3.233 | 25655.7 |
| 693 | 2025-08-05 11:50:04 | spotting | 1 | 82945 | 10 | 3.656 | 22687.4 |
| 692 | 2025-08-05 09:20:50 | spotting | 1 | 82945 | 10 | 3.890 | 21322.6 |
| 691 | 2025-08-04 06:02:51 | spotting | 1 | 82945 | 10 | 3.076 | 26965.2 |
| 690 | 2025-07-29 14:23:21 | spotting | 1 | 82945 | 10 | 3.140 | 26415.6 |
| 689 | 2025-07-29 02:45:37 | spotting | 3 | 146162 | 479 | 34.766 | 4204.2 |
| 688 | 2025-07-28 09:39:08 | spotting | 3 | 146162 | 479 | 17.330 | 8434.0 |
| 687 | 2025-07-27 23:59:24 | spotting | 2 | 121059 | 72 | 17.610 | 6874.4 |
| 686 | 2025-07-27 16:08:24 | spotting | 1 | 82945 | 10 | 3.390 | 24467.6 |
| 685 | 2025-07-26 19:41:08 | spotting | 1 | 82945 | 10 | 10.033 | 8267.2 |
| 684 | 2025-07-25 22:05:24 | spotting | 3 | 146162 | 479 | 6.910 | 21152.2 |
| 683 | 2025-07-25 04:01:53 | spotting | 1 | 82945 | 10 | 3.656 | 22687.4 |
| 682 | 2025-07-23 05:19:52 | spotting | 1 | 82945 | 10 | 3.406 | 24352.6 |
| 681 | 2025-07-22 22:32:31 | spotting | 1 | 82945 | 10 | 3.686 | 22502.7 |
| 680 | 2025-07-21 15:12:48 | spotting | 3 | 146162 | 479 | 7.313 | 19986.6 |
| 679 | 2025-07-20 14:37:26 | spotting | 1 | 82945 | 10 | 1.343 | 61761.0 |
| 678 | 2025-07-18 04:44:25 | spotting | 3 | 146162 | 479 | 32.363 | 4516.3 |
| 677 | 2025-07-04 04:14:13 | spotting | 3 | 146162 | 479 | 34.003 | 4298.5 |
| 676 | 2025-07-03 07:49:52 | spotting | 2 | 121059 | 72 | 3.953 | 30624.6 |
| 675 | 2025-07-02 06:20:17 | spotting | 1 | 82945 | 10 | 10.580 | 7839.8 |
| 674 | 2025-07-02 01:51:24 | spotting | 3 | 146162 | 479 | 30.596 | 4777.2 |
| 673 | 2025-07-01 14:24:04 | spotting | 2 | 121059 | 72 | 3.843 | 31501.2 |
| 672 | 2025-06-29 12:02:19 | spotting | 1 | 82945 | 10 | 4.140 | 20035.0 |
| 671 | 2025-06-29 11:02:36 | spotting | 2 | 121059 | 72 | 3.406 | 35542.9 |
| 670 | 2025-06-28 17:22:58 | spotting | 2 | 121059 | 72 | 8.046 | 15045.9 |
| 669 | 2025-06-27 15:19:28 | spotting | 1 | 82945 | 10 | 10.360 | 8006.3 |
| 668 | 2025-06-27 14:18:00 | spotting | 1 | 82945 | 10 | 7.280 | 11393.5 |
| 667 | 2025-06-27 01:53:42 | spotting | 3 | 146162 | 479 | 36.593 | 3994.3 |
| 666 | 2025-06-26 23:03:14 | spotting | 2 | 121059 | 72 | 20.080 | 6028.8 |
| 665 | 2025-06-26 07:52:31 | spotting | 3 | 146162 | 479 | 27.156 | 5382.3 |
| 664 | 2025-06-25 20:09:12 | spotting | 3 | 146162 | 479 | 7.326 | 19951.1 |
| 663 | 2025-06-24 12:25:46 | spotting | 3 | 146162 | 479 | 40.410 | 3617.0 |
| 662 | 2025-06-24 10:11:26 | spotting | 2 | 121059 | 72 | 15.580 | 7770.2 |
| 661 | 2025-06-23 04:42:11 | spotting | 1 | 82945 | 10 | 4.220 | 19655.2 |
| 660 | 2025-06-20 17:32:33 | spotting | 1 | 82945 | 10 | 8.436 | 9832.3 |
| 659 | 2025-06-20 14:27:01 | spotting | 1 | 82945 | 10 | 6.160 | 13465.1 |
| 658 | 2025-06-19 06:45:55 | spotting | 2 | 121059 | 72 | 3.826 | 31641.1 |
| 657 | 2025-06-04 03:00:52 | spotting | 1 | 82945 | 10 | 5.753 | 14417.7 |
| 656 | 2025-05-26 20:56:09 | spotting | 1 | 82945 | 10 | 5.063 | 16382.6 |
| 655 | 2025-05-26 12:16:43 | spotting | 1 | 82945 | 10 | 7.063 | 11743.6 |
| 654 | 2025-05-22 05:07:41 | spotting | 1 | 82945 | 10 | 5.470 | 15163.6 |
| 653 | 2025-05-20 12:34:02 | spotting | 1 | 82945 | 10 | 7.236 | 11462.8 |
| 652 | 2025-05-15 19:17:35 | spotting | 1 | 82945 | 10 | 1.533 | 54106.3 |
| 651 | 2025-05-01 02:09:42 | spotting | 1 | 82945 | 10 | 7.936 | 10451.7 |
| 650 | 2025-04-30 05:02:14 | spotting | 1 | 82945 | 10 | 7.436 | 11154.5 |
| 649 | 2025-04-29 03:07:14 | spotting | 1 | 82945 | 10 | 1.436 | 57761.1 |
| 648 | 2025-04-26 13:18:55 | spotting | 1 | 82945 | 10 | 4.673 | 17749.8 |
| 647 | 2025-04-21 16:33:12 | spotting | 2 | 121059 | 72 | 18.923 | 6397.5 |
| 646 | 2025-04-20 11:28:25 | spotting | 1 | 82945 | 10 | 1.470 | 56425.2 |
| 645 | 2025-04-20 10:31:58 | spotting | 1 | 82945 | 10 | 1.440 | 57600.7 |
| 644 | 2025-04-11 09:27:46 | spotting | 2 | 121059 | 72 | 10.736 | 11276.0 |
| 643 | 2025-04-11 00:40:41 | spotting | 3 | 146162 | 479 | 26.690 | 5476.3 |
| 642 | 2025-04-09 21:35:19 | spotting | 1 | 82945 | 10 | 3.280 | 25288.1 |
| 641 | 2025-04-09 06:09:51 | spotting | 3 | 146162 | 479 | 41.936 | 3485.4 |
| 640 | 2025-04-08 22:46:38 | spotting | 2 | 121059 | 72 | 19.283 | 6278.0 |
| 639 | 2025-03-31 03:27:12 | spotting | 1 | 82945 | 10 | 10.500 | 7899.5 |
| 638 | 2025-03-29 08:57:12 | spotting | 2 | 121059 | 72 | 10.906 | 11100.2 |
| 637 | 2025-03-27 07:00:33 | spotting | 1 | 82945 | 10 | 7.266 | 11415.5 |
| 636 | 2025-03-26 22:25:11 | spotting | 2 | 121059 | 72 | 17.470 | 6929.5 |
| 635 | 2025-03-26 21:37:10 | spotting | 3 | 146162 | 479 | 30.033 | 4866.7 |
| 634 | 2025-03-26 15:11:21 | spotting | 1 | 82945 | 10 | 3.016 | 27501.7 |
| 633 | 2025-03-20 14:26:54 | spotting | 1 | 82945 | 10 | 6.343 | 13076.6 |
| 632 | 2025-03-20 06:02:56 | spotting | 1 | 82945 | 10 | 7.953 | 10429.4 |
| 631 | 2025-03-03 00:05:02 | spotting | 3 | 146162 | 479 | 42.093 | 3472.4 |
| 630 | 2025-02-25 20:15:52 | spotting | 1 | 82945 | 10 | 10.373 | 7996.2 |
| 629 | 2025-02-24 14:14:34 | spotting | 1 | 82945 | 10 | 6.860 | 12091.1 |
| 628 | 2025-02-24 14:14:23 | spotting | 2 | 121059 | 72 | 9.483 | 12765.9 |
| 627 | 2025-02-19 05:43:04 | spotting | 3 | 146162 | 479 | 34.500 | 4236.6 |
| 626 | 2025-02-19 05:43:01 | spotting | 2 | 121059 | 72 | 18.186 | 6656.7 |
| 625 | 2025-02-18 17:56:12 | spotting | 3 | 146162 | 479 | 44.563 | 3279.9 |
| 624 | 2025-02-18 13:47:49 | spotting | 2 | 121059 | 72 | 16.720 | 7240.4 |
| 623 | 2025-02-18 09:46:51 | spotting | 2 | 121059 | 72 | 34.656 | 3493.2 |
| 622 | 2025-02-18 09:46:51 | spotting | 3 | 146162 | 479 | 31.436 | 4649.5 |
| 621 | 2025-02-18 09:45:57 | spotting | 1 | 82945 | 10 | 6.703 | 12374.3 |
| 620 | 2025-02-17 14:19:26 | spotting | 1 | 82945 | 10 | 10.580 | 7839.8 |
| 619 | 2025-02-09 08:57:24 | spotting | 1 | 82945 | 10 | 1.440 | 57600.7 |
| 618 | 2025-01-20 18:39:06 | spotting | 1 | 82945 | 10 | 4.123 | 20117.6 |
| 617 | 2025-01-18 12:59:18 | spotting | 1 | 82945 | 10 | 7.000 | 11849.3 |
| 616 | 2025-01-15 00:02:46 | spotting | 2 | 121059 | 72 | 3.983 | 30393.9 |
| 615 | 2025-01-14 19:06:55 | spotting | 3 | 146162 | 479 | 32.596 | 4484.0 |
| 614 | 2025-01-14 10:40:59 | spotting | 2 | 121059 | 72 | 15.970 | 7580.4 |
| 613 | 2025-01-14 09:01:21 | spotting | 3 | 146162 | 479 | 27.720 | 5272.8 |
| 612 | 2025-01-14 09:01:20 | spotting | 2 | 121059 | 72 | 11.796 | 10262.7 |
| 611 | 2025-01-13 21:25:18 | spotting | 3 | 146162 | 479 | 32.643 | 4477.6 |