History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sofar"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 846 | 2024-04-03 07:58:45 | sofar | 3 | 83667 | 1073 | 7.780 | 10754.1 |
| 845 | 2024-04-03 07:58:47 | sofar | 2 | 53800 | 80 | 3.923 | 13714.0 |
| 844 | 2024-04-03 07:23:12 | sofar | 1 | 28756 | 9 | 0.546 | 52666.7 |
| 843 | 2024-03-31 05:04:17 | sofar | 3 | 83667 | 1073 | 7.160 | 11685.3 |
| 842 | 2024-03-31 05:04:14 | sofar | 2 | 53800 | 80 | 5.030 | 10695.8 |
| 841 | 2024-03-31 04:17:29 | sofar | 2 | 53800 | 80 | 1.703 | 31591.3 |
| 840 | 2024-03-31 04:17:28 | sofar | 1 | 28756 | 9 | 1.076 | 26724.9 |
| 839 | 2024-03-31 04:16:45 | sofar | 3 | 83667 | 1073 | 8.033 | 10415.4 |
| 838 | 2024-03-31 04:11:05 | sofar | 1 | 28756 | 9 | 1.110 | 25906.3 |
| 837 | 2024-03-30 02:03:59 | sofar | 3 | 83667 | 1073 | 8.470 | 9878.0 |
| 836 | 2024-03-29 16:51:39 | sofar | 3 | 83667 | 1073 | 9.626 | 8691.8 |
| 835 | 2024-03-29 16:51:41 | sofar | 2 | 53800 | 80 | 3.953 | 13609.9 |
| 834 | 2024-03-29 16:49:39 | sofar | 1 | 28756 | 9 | 1.170 | 24577.8 |
| 833 | 2024-03-03 23:04:58 | sofar | 3 | 83667 | 1073 | 10.173 | 8224.4 |
| 832 | 2024-03-03 23:05:00 | sofar | 2 | 53800 | 80 | 5.873 | 9160.6 |
| 831 | 2024-03-03 22:33:14 | sofar | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 830 | 2024-02-28 11:25:01 | sofar | 2 | 53800 | 80 | 1.686 | 31909.8 |
| 829 | 2024-02-28 11:24:36 | sofar | 3 | 83667 | 1073 | 6.686 | 12513.8 |
| 828 | 2024-02-28 09:07:34 | sofar | 3 | 83667 | 1073 | 13.843 | 6044.0 |
| 827 | 2024-02-28 09:07:29 | sofar | 2 | 53800 | 80 | 2.033 | 26463.4 |
| 826 | 2024-02-28 08:08:23 | sofar | 1 | 28756 | 9 | 0.563 | 51076.4 |
| 825 | 2024-02-11 08:32:34 | sofar | 1 | 28756 | 9 | 0.466 | 61708.2 |
| 824 | 2024-01-29 03:34:45 | sofar | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 823 | 2024-01-14 05:48:32 | sofar | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 822 | 2024-01-06 20:47:43 | sofar | 3 | 83667 | 1073 | 3.546 | 23594.8 |
| 821 | 2023-12-19 16:17:54 | sofar | 3 | 83667 | 1073 | 3.373 | 24804.9 |
| 820 | 2023-12-08 07:56:49 | sofar | 3 | 83667 | 1073 | 4.343 | 19264.8 |
| 819 | 2023-12-08 07:56:44 | sofar | 3 | 83667 | 1073 | 4.346 | 19251.5 |
| 818 | 2023-12-07 07:28:56 | sofar | 3 | 83667 | 1073 | 3.686 | 22698.6 |
| 817 | 2023-12-02 11:31:23 | sofar | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 816 | 2023-11-23 20:05:32 | sofar | 1 | 28756 | 9 | 0.533 | 53951.2 |
| 815 | 2023-11-23 02:42:05 | sofar | 1 | 28756 | 9 | 0.440 | 65354.5 |
| 814 | 2023-11-19 18:39:32 | sofar | 3 | 83667 | 1073 | 3.483 | 24021.5 |
| 813 | 2023-11-03 07:26:53 | sofar | 1 | 28756 | 9 | 0.513 | 56054.6 |
| 812 | 2023-10-31 23:01:59 | sofar | 3 | 83667 | 1073 | 4.063 | 20592.4 |
| 811 | 2023-10-31 04:25:08 | sofar | 3 | 83667 | 1073 | 4.390 | 19058.5 |
| 810 | 2023-10-30 06:38:35 | sofar | 3 | 83667 | 1073 | 3.923 | 21327.3 |
| 809 | 2023-10-24 02:27:29 | sofar | 3 | 83667 | 1073 | 9.190 | 9104.1 |
| 808 | 2023-10-20 07:59:43 | sofar | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 807 | 2023-10-20 06:39:04 | sofar | 1 | 28756 | 9 | 0.470 | 61183.0 |
| 806 | 2023-10-19 22:21:29 | sofar | 3 | 83667 | 1073 | 3.893 | 21491.7 |
| 805 | 2023-10-13 17:32:50 | sofar | 1 | 28756 | 9 | 0.513 | 56054.6 |
| 804 | 2023-10-05 04:20:59 | sofar | 1 | 28756 | 9 | 0.483 | 59536.2 |
| 803 | 2023-10-03 21:25:59 | sofar | 3 | 83667 | 1073 | 3.546 | 23594.8 |
| 802 | 2023-09-30 21:47:34 | sofar | 3 | 83667 | 1073 | 4.750 | 17614.1 |
| 801 | 2023-09-27 16:22:26 | sofar | 3 | 83667 | 1073 | 4.123 | 20292.7 |
| 800 | 2023-09-27 16:22:28 | sofar | 2 | 53800 | 80 | 1.826 | 29463.3 |
| 799 | 2023-09-25 07:00:00 | sofar | 1 | 28756 | 9 | 0.486 | 59168.7 |
| 798 | 2023-09-16 08:02:26 | sofar | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 797 | 2023-09-15 19:04:31 | sofar | 1 | 28756 | 9 | 0.550 | 52283.6 |
| 796 | 2023-09-04 02:10:17 | sofar | 1 | 28756 | 9 | 0.440 | 65354.5 |
| 795 | 2023-08-31 20:47:57 | sofar | 1 | 28756 | 9 | 0.516 | 55728.7 |
| 794 | 2023-08-26 09:55:21 | sofar | 3 | 83667 | 1073 | 3.533 | 23681.6 |
| 793 | 2023-07-14 05:01:30 | sofar | 3 | 83667 | 1073 | 3.406 | 24564.6 |
| 792 | 2023-07-05 12:35:20 | sofar | 1 | 28756 | 9 | 0.500 | 57512.0 |
| 791 | 2023-06-05 21:22:30 | sofar | 3 | 83667 | 1073 | 3.250 | 25743.7 |
| 790 | 2023-04-30 08:15:29 | sofar | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 789 | 2023-04-26 13:17:27 | sofar | 3 | 83667 | 1073 | 4.173 | 20049.6 |
| 788 | 2023-04-21 14:29:03 | sofar | 3 | 83667 | 1073 | 3.703 | 22594.4 |
| 787 | 2023-04-17 07:28:58 | sofar | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 786 | 2023-02-07 11:47:42 | sofar | 1 | 28756 | 9 | 0.483 | 59536.2 |
| 785 | 2022-12-30 09:11:51 | sofar | 1 | 28756 | 9 | 1.013 | 28387.0 |
| 784 | 2022-12-06 04:09:00 | sofar | 1 | 28756 | 9 | 0.440 | 65354.5 |
| 783 | 2022-08-26 10:18:16 | sofar | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 782 | 2022-08-19 06:04:44 | sofar | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 781 | 2022-08-17 17:37:40 | sofar | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 780 | 2022-08-04 06:55:35 | sofar | 1 | 28756 | 9 | 0.466 | 61708.2 |
| 779 | 2022-07-29 04:16:37 | sofar | 1 | 28756 | 9 | 0.610 | 47141.0 |
| 778 | 2022-07-19 15:19:54 | sofar | 2 | 53800 | 80 | 1.393 | 38621.7 |
| 777 | 2022-07-04 05:41:33 | sofar | 3 | 83667 | 1073 | 3.343 | 25027.5 |
| 776 | 2022-06-06 01:22:50 | sofar | 3 | 83667 | 1073 | 3.890 | 21508.2 |
| 775 | 2022-05-13 19:58:12 | sofar | 3 | 83667 | 1073 | 4.060 | 20607.6 |
| 774 | 2022-05-05 08:02:41 | sofar | 3 | 83667 | 1073 | 4.063 | 20592.4 |
| 773 | 2022-05-04 07:05:24 | sofar | 3 | 83667 | 1073 | 4.110 | 20356.9 |
| 772 | 2022-05-03 08:55:57 | sofar | 3 | 83667 | 1073 | 4.956 | 16882.0 |
| 771 | 2022-05-02 22:32:21 | sofar | 3 | 83667 | 1073 | 3.576 | 23396.8 |
| 770 | 2022-04-28 23:30:28 | sofar | 3 | 83667 | 1073 | 4.626 | 18086.3 |
| 769 | 2022-04-27 22:40:57 | sofar | 3 | 83667 | 1073 | 4.300 | 19457.4 |
| 768 | 2022-04-02 16:49:00 | sofar | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 767 | 2022-04-01 09:59:42 | sofar | 1 | 28756 | 9 | 0.436 | 65954.1 |
| 766 | 2022-03-31 13:45:40 | sofar | 1 | 28756 | 9 | 0.640 | 44931.3 |
| 765 | 2022-03-26 13:18:49 | sofar | 3 | 83667 | 1073 | 4.033 | 20745.6 |
| 764 | 2022-02-11 18:47:29 | sofar | 3 | 83667 | 1073 | 3.830 | 21845.2 |
| 763 | 2022-01-24 11:44:05 | sofar | 3 | 83667 | 1073 | 3.813 | 21942.6 |
| 762 | 2022-01-23 11:43:39 | sofar | 3 | 83667 | 1073 | 3.860 | 21675.4 |
| 761 | 2022-01-22 11:40:01 | sofar | 3 | 83667 | 1073 | 3.576 | 23396.8 |
| 760 | 2022-01-21 11:36:24 | sofar | 3 | 83667 | 1073 | 3.843 | 21771.3 |
| 759 | 2022-01-20 11:35:18 | sofar | 3 | 83667 | 1073 | 3.876 | 21585.9 |
| 758 | 2022-01-19 11:30:27 | sofar | 3 | 83667 | 1073 | 4.063 | 20592.4 |
| 757 | 2022-01-18 11:29:09 | sofar | 3 | 83667 | 1073 | 3.813 | 21942.6 |
| 756 | 2022-01-06 11:36:12 | sofar | 3 | 83667 | 1073 | 4.593 | 18216.2 |
| 755 | 2022-01-05 22:01:49 | sofar | 3 | 83667 | 1073 | 4.080 | 20506.6 |
| 754 | 2022-01-05 11:35:09 | sofar | 3 | 83667 | 1073 | 8.000 | 10458.4 |
| 753 | 2022-01-04 19:02:15 | sofar | 3 | 83667 | 1073 | 4.893 | 17099.3 |
| 752 | 2022-01-02 04:24:19 | sofar | 1 | 28756 | 9 | 0.453 | 63479.0 |
| 751 | 2021-12-31 08:09:37 | sofar | 3 | 83667 | 1073 | 4.406 | 18989.3 |
| 750 | 2021-12-30 10:02:10 | sofar | 3 | 83667 | 1073 | 4.233 | 19765.4 |
| 749 | 2021-12-29 05:53:21 | sofar | 3 | 83667 | 1073 | 4.610 | 18149.0 |
| 748 | 2021-12-28 08:54:47 | sofar | 3 | 83667 | 1073 | 3.953 | 21165.4 |
| 747 | 2021-12-27 07:14:06 | sofar | 3 | 83667 | 1073 | 3.843 | 21771.3 |