History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sphere"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 787 | 2024-04-26 07:22:14 | sphere | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 786 | 2024-04-18 05:02:27 | sphere | 1 | 48755 | 5 | 2.236 | 21804.6 |
| 785 | 2024-04-10 23:34:07 | sphere | 3 | 112716 | 576 | 8.266 | 13636.1 |
| 784 | 2024-04-10 06:17:30 | sphere | 3 | 112716 | 576 | 5.406 | 20850.2 |
| 783 | 2024-04-06 06:46:33 | sphere | 3 | 112716 | 576 | 11.796 | 9555.4 |
| 782 | 2024-04-06 06:46:38 | sphere | 2 | 82551 | 47 | 5.470 | 15091.6 |
| 781 | 2024-04-06 06:46:30 | sphere | 1 | 48755 | 5 | 1.826 | 26700.4 |
| 780 | 2024-03-31 14:52:50 | sphere | 2 | 82551 | 47 | 8.470 | 9746.3 |
| 779 | 2024-03-31 09:32:10 | sphere | 2 | 82551 | 47 | 2.673 | 30883.3 |
| 778 | 2024-03-31 09:31:40 | sphere | 3 | 112716 | 576 | 8.393 | 13429.8 |
| 777 | 2024-03-30 19:39:54 | sphere | 3 | 112716 | 576 | 15.720 | 7170.2 |
| 776 | 2024-03-30 00:13:36 | sphere | 2 | 82551 | 47 | 6.893 | 11976.1 |
| 775 | 2024-03-30 00:12:35 | sphere | 3 | 112716 | 576 | 7.486 | 15056.9 |
| 774 | 2024-03-29 21:38:54 | sphere | 3 | 112716 | 576 | 7.123 | 15824.2 |
| 773 | 2024-03-29 21:38:53 | sphere | 2 | 82551 | 47 | 2.796 | 29524.7 |
| 772 | 2024-03-29 21:38:49 | sphere | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 771 | 2024-03-07 03:17:32 | sphere | 1 | 48755 | 5 | 2.970 | 16415.8 |
| 770 | 2024-03-03 03:35:09 | sphere | 1 | 48755 | 5 | 2.016 | 24184.0 |
| 769 | 2024-02-18 16:12:48 | sphere | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 768 | 2024-01-12 19:43:18 | sphere | 3 | 112716 | 576 | 5.110 | 22057.9 |
| 767 | 2024-01-12 19:43:16 | sphere | 2 | 82551 | 47 | 2.453 | 33653.1 |
| 766 | 2024-01-05 07:50:56 | sphere | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 765 | 2024-01-03 03:10:15 | sphere | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 764 | 2023-12-24 19:19:47 | sphere | 2 | 82551 | 47 | 2.406 | 34310.5 |
| 763 | 2023-12-11 04:05:43 | sphere | 3 | 112716 | 576 | 4.580 | 24610.5 |
| 762 | 2023-12-06 06:31:45 | sphere | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 761 | 2023-11-22 04:23:41 | sphere | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 760 | 2023-11-17 02:50:40 | sphere | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 759 | 2023-11-13 08:17:01 | sphere | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 758 | 2023-11-06 10:36:17 | sphere | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 757 | 2023-10-27 02:47:34 | sphere | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 756 | 2023-10-24 22:09:02 | sphere | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 755 | 2023-10-23 19:17:56 | sphere | 1 | 48755 | 5 | 1.766 | 27607.6 |
| 754 | 2023-10-15 01:27:24 | sphere | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 753 | 2023-10-06 10:07:40 | sphere | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 752 | 2023-09-24 12:33:08 | sphere | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 751 | 2023-09-23 11:36:46 | sphere | 2 | 82551 | 47 | 2.123 | 38884.1 |
| 750 | 2023-09-14 08:58:32 | sphere | 2 | 82551 | 47 | 2.190 | 37694.5 |
| 749 | 2023-09-13 22:21:39 | sphere | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 748 | 2023-09-10 14:16:11 | sphere | 3 | 112716 | 576 | 6.406 | 17595.4 |
| 747 | 2023-09-08 13:42:10 | sphere | 3 | 112716 | 576 | 4.580 | 24610.5 |
| 746 | 2023-08-21 03:55:34 | sphere | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 745 | 2023-08-06 15:54:11 | sphere | 3 | 112716 | 576 | 4.750 | 23729.7 |
| 744 | 2023-07-14 07:40:46 | sphere | 3 | 112716 | 576 | 7.170 | 15720.5 |
| 743 | 2023-07-11 07:06:12 | sphere | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 742 | 2023-07-08 22:58:12 | sphere | 3 | 112716 | 576 | 4.580 | 24610.5 |
| 741 | 2023-06-27 09:29:41 | sphere | 3 | 112716 | 576 | 4.593 | 24540.8 |
| 740 | 2023-06-24 09:37:50 | sphere | 2 | 82551 | 47 | 2.126 | 38829.3 |
| 739 | 2023-05-27 04:49:10 | sphere | 3 | 112716 | 576 | 4.546 | 24794.5 |
| 738 | 2023-05-22 09:33:21 | sphere | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 737 | 2023-03-19 16:48:38 | sphere | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 736 | 2023-03-17 22:18:09 | sphere | 2 | 82551 | 47 | 2.093 | 39441.5 |
| 735 | 2023-03-17 04:52:51 | sphere | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 734 | 2023-03-13 21:58:32 | sphere | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 733 | 2023-03-05 13:32:55 | sphere | 3 | 112716 | 576 | 4.530 | 24882.1 |
| 732 | 2023-01-31 18:46:43 | sphere | 3 | 112716 | 576 | 5.110 | 22057.9 |
| 731 | 2023-01-23 23:49:58 | sphere | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 730 | 2023-01-06 22:39:29 | sphere | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 729 | 2022-12-18 22:59:50 | sphere | 2 | 82551 | 47 | 2.110 | 39123.7 |
| 728 | 2022-12-16 02:16:45 | sphere | 3 | 112716 | 576 | 5.330 | 21147.5 |
| 727 | 2022-12-12 11:10:47 | sphere | 3 | 112716 | 576 | 5.156 | 21861.1 |
| 726 | 2022-12-02 01:21:08 | sphere | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 725 | 2022-11-29 09:45:03 | sphere | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 724 | 2022-11-15 07:59:02 | sphere | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 723 | 2022-11-12 09:27:52 | sphere | 3 | 112716 | 576 | 4.950 | 22770.9 |
| 722 | 2022-11-09 06:48:49 | sphere | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 721 | 2022-11-06 13:20:26 | sphere | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 720 | 2022-11-06 13:20:24 | sphere | 1 | 48755 | 5 | 1.656 | 29441.4 |
| 719 | 2022-11-05 00:19:57 | sphere | 3 | 112716 | 576 | 4.576 | 24632.0 |
| 718 | 2022-11-04 00:03:35 | sphere | 3 | 112716 | 576 | 5.110 | 22057.9 |
| 717 | 2022-10-31 15:05:00 | sphere | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 716 | 2022-10-29 14:04:11 | sphere | 3 | 112716 | 576 | 4.516 | 24959.3 |
| 715 | 2022-10-29 02:25:41 | sphere | 3 | 112716 | 576 | 4.580 | 24610.5 |
| 714 | 2022-10-24 04:52:17 | sphere | 3 | 112716 | 576 | 4.513 | 24975.8 |
| 713 | 2022-10-20 14:54:31 | sphere | 3 | 112716 | 576 | 5.156 | 21861.1 |
| 712 | 2022-10-05 08:36:27 | sphere | 1 | 48755 | 5 | 1.516 | 32160.3 |
| 711 | 2022-09-15 16:34:32 | sphere | 3 | 112716 | 576 | 4.596 | 24524.8 |
| 710 | 2022-09-07 02:06:32 | sphere | 3 | 112716 | 576 | 5.016 | 22471.3 |
| 709 | 2022-08-30 01:27:06 | sphere | 3 | 112716 | 576 | 4.483 | 25143.0 |
| 708 | 2022-08-20 09:23:54 | sphere | 3 | 112716 | 576 | 4.643 | 24276.5 |
| 707 | 2022-08-14 00:57:14 | sphere | 2 | 82551 | 47 | 2.110 | 39123.7 |
| 706 | 2022-07-29 22:17:37 | sphere | 3 | 112716 | 576 | 4.610 | 24450.3 |
| 705 | 2022-07-29 04:43:26 | sphere | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 704 | 2022-07-18 18:26:03 | sphere | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 703 | 2022-05-25 06:23:38 | sphere | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 702 | 2022-03-28 04:02:01 | sphere | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 701 | 2022-03-07 04:28:39 | sphere | 3 | 112716 | 576 | 5.216 | 21609.7 |
| 700 | 2022-02-06 13:17:18 | sphere | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 699 | 2021-12-07 10:35:24 | sphere | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 698 | 2021-11-30 09:23:51 | sphere | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 697 | 2021-10-09 21:50:48 | sphere | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 696 | 2021-10-07 20:13:47 | sphere | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 695 | 2021-09-16 13:25:11 | sphere | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 694 | 2021-08-24 10:53:28 | sphere | 1 | 48755 | 5 | 0.753 | 64747.7 |
| 693 | 2021-08-13 14:50:06 | sphere | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 692 | 2021-07-18 21:09:02 | sphere | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 691 | 2021-06-03 12:12:11 | sphere | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 690 | 2021-05-17 02:22:18 | sphere | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 689 | 2021-05-10 15:38:09 | sphere | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 688 | 2021-05-09 07:19:58 | sphere | 1 | 48755 | 5 | 0.860 | 56691.9 |