History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"phial"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 872 | 2024-04-26 16:01:41 | phial | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 871 | 2024-04-09 10:59:45 | phial | 1 | 28756 | 3 | 0.970 | 29645.4 |
| 870 | 2024-04-06 06:52:37 | phial | 2 | 53800 | 62 | 3.813 | 14109.6 |
| 869 | 2024-04-06 06:52:36 | phial | 3 | 83667 | 1008 | 4.576 | 18283.9 |
| 868 | 2024-04-06 06:52:35 | phial | 1 | 28756 | 3 | 1.013 | 28387.0 |
| 867 | 2024-03-31 15:52:39 | phial | 1 | 28756 | 3 | 0.936 | 30722.2 |
| 866 | 2024-03-28 20:43:36 | phial | 1 | 28756 | 3 | 0.420 | 68466.7 |
| 865 | 2024-03-07 04:34:25 | phial | 1 | 28756 | 3 | 1.033 | 27837.4 |
| 864 | 2024-03-01 13:31:55 | phial | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 863 | 2024-02-29 04:38:06 | phial | 2 | 53800 | 62 | 1.626 | 33087.3 |
| 862 | 2024-02-29 04:37:43 | phial | 3 | 83667 | 1008 | 3.626 | 23074.2 |
| 861 | 2024-02-27 09:41:04 | phial | 2 | 53800 | 62 | 3.440 | 15639.5 |
| 860 | 2024-02-27 09:40:33 | phial | 3 | 83667 | 1008 | 4.330 | 19322.6 |
| 859 | 2024-02-26 12:47:53 | phial | 3 | 83667 | 1008 | 3.513 | 23816.4 |
| 858 | 2024-02-26 12:47:51 | phial | 2 | 53800 | 62 | 1.590 | 33836.5 |
| 857 | 2024-02-26 12:47:46 | phial | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 856 | 2024-02-12 19:22:55 | phial | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 855 | 2024-02-03 22:45:03 | phial | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 854 | 2024-01-29 08:09:59 | phial | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 853 | 2024-01-27 10:18:41 | phial | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 852 | 2024-01-19 06:59:11 | phial | 3 | 83667 | 1008 | 3.796 | 22040.8 |
| 851 | 2024-01-14 15:55:32 | phial | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 850 | 2024-01-11 03:49:22 | phial | 3 | 83667 | 1008 | 3.660 | 22859.8 |
| 849 | 2024-01-01 12:54:10 | phial | 3 | 83667 | 1008 | 3.436 | 24350.1 |
| 848 | 2024-01-01 12:54:05 | phial | 2 | 53800 | 62 | 1.343 | 40059.6 |
| 847 | 2023-12-24 15:10:09 | phial | 2 | 53800 | 62 | 1.533 | 35094.6 |
| 846 | 2023-12-24 15:10:04 | phial | 3 | 83667 | 1008 | 4.656 | 17969.7 |
| 845 | 2023-12-17 08:34:57 | phial | 3 | 83667 | 1008 | 7.203 | 11615.6 |
| 844 | 2023-12-17 08:35:00 | phial | 2 | 53800 | 62 | 1.623 | 33148.5 |
| 843 | 2023-12-08 11:28:02 | phial | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 842 | 2023-12-08 11:28:01 | phial | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 841 | 2023-11-14 10:54:20 | phial | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 840 | 2023-11-12 07:43:59 | phial | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 839 | 2023-11-10 16:23:21 | phial | 1 | 28756 | 3 | 0.873 | 32939.3 |
| 838 | 2023-11-10 06:38:19 | phial | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 837 | 2023-10-29 06:12:19 | phial | 1 | 28756 | 3 | 0.873 | 32939.3 |
| 836 | 2023-10-24 15:11:18 | phial | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 835 | 2023-10-24 08:37:33 | phial | 3 | 83667 | 1008 | 3.470 | 24111.5 |
| 834 | 2023-10-23 10:00:32 | phial | 3 | 83667 | 1008 | 4.156 | 20131.6 |
| 833 | 2023-10-20 00:54:46 | phial | 3 | 83667 | 1008 | 4.050 | 20658.5 |
| 832 | 2023-10-19 00:30:12 | phial | 3 | 83667 | 1008 | 3.263 | 25641.1 |
| 831 | 2023-10-18 12:28:20 | phial | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 830 | 2023-10-13 00:45:30 | phial | 3 | 83667 | 1008 | 4.186 | 19987.3 |
| 829 | 2023-10-11 16:49:33 | phial | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 828 | 2023-10-05 17:30:27 | phial | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 827 | 2023-09-24 14:17:51 | phial | 1 | 28756 | 3 | 0.423 | 67981.1 |
| 826 | 2023-09-24 11:16:46 | phial | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 825 | 2023-08-29 07:41:43 | phial | 1 | 28756 | 3 | 0.856 | 33593.5 |
| 824 | 2023-07-29 10:46:47 | phial | 3 | 83667 | 1008 | 3.906 | 21420.1 |
| 823 | 2023-07-15 22:51:33 | phial | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 822 | 2023-07-13 17:17:13 | phial | 1 | 28756 | 3 | 0.420 | 68466.7 |
| 821 | 2023-07-02 06:59:29 | phial | 3 | 83667 | 1008 | 3.203 | 26121.4 |
| 820 | 2023-06-04 01:22:17 | phial | 1 | 28756 | 3 | 0.423 | 67981.1 |
| 819 | 2023-04-08 18:40:45 | phial | 3 | 83667 | 1008 | 3.173 | 26368.4 |
| 818 | 2023-03-28 07:20:39 | phial | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 817 | 2023-03-28 02:13:18 | phial | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 816 | 2023-01-11 08:50:32 | phial | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 815 | 2023-01-06 06:16:21 | phial | 3 | 83667 | 1008 | 3.203 | 26121.4 |
| 814 | 2022-12-06 08:37:01 | phial | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 813 | 2022-10-24 11:52:15 | phial | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 812 | 2022-10-23 12:37:03 | phial | 3 | 83667 | 1008 | 3.220 | 25983.5 |
| 811 | 2022-10-06 12:45:33 | phial | 3 | 83667 | 1008 | 3.300 | 25353.6 |
| 810 | 2022-10-05 19:27:08 | phial | 3 | 83667 | 1008 | 3.763 | 22234.1 |
| 809 | 2022-10-04 22:27:15 | phial | 3 | 83667 | 1008 | 3.560 | 23502.0 |
| 808 | 2022-10-03 03:55:24 | phial | 3 | 83667 | 1008 | 3.266 | 25617.6 |
| 807 | 2022-10-02 09:30:53 | phial | 3 | 83667 | 1008 | 3.266 | 25617.6 |
| 806 | 2022-10-01 13:57:23 | phial | 3 | 83667 | 1008 | 3.203 | 26121.4 |
| 805 | 2022-09-30 20:29:09 | phial | 3 | 83667 | 1008 | 3.220 | 25983.5 |
| 804 | 2022-09-29 08:39:40 | phial | 3 | 83667 | 1008 | 3.250 | 25743.7 |
| 803 | 2022-09-28 15:49:15 | phial | 3 | 83667 | 1008 | 3.220 | 25983.5 |
| 802 | 2022-09-27 22:22:06 | phial | 3 | 83667 | 1008 | 3.203 | 26121.4 |
| 801 | 2022-09-27 02:23:29 | phial | 3 | 83667 | 1008 | 3.170 | 26393.4 |
| 800 | 2022-09-25 12:56:36 | phial | 3 | 83667 | 1008 | 3.203 | 26121.4 |
| 799 | 2022-09-24 13:25:43 | phial | 3 | 83667 | 1008 | 3.233 | 25879.1 |
| 798 | 2022-09-23 08:27:38 | phial | 3 | 83667 | 1008 | 3.640 | 22985.4 |
| 797 | 2022-09-22 12:42:10 | phial | 3 | 83667 | 1008 | 3.360 | 24900.9 |
| 796 | 2022-09-21 18:43:27 | phial | 3 | 83667 | 1008 | 3.236 | 25855.1 |
| 795 | 2022-09-20 12:21:34 | phial | 3 | 83667 | 1008 | 3.203 | 26121.4 |
| 794 | 2022-09-19 19:55:00 | phial | 3 | 83667 | 1008 | 3.360 | 24900.9 |
| 793 | 2022-09-18 23:02:23 | phial | 3 | 83667 | 1008 | 3.170 | 26393.4 |
| 792 | 2022-09-17 17:18:53 | phial | 3 | 83667 | 1008 | 3.296 | 25384.4 |
| 791 | 2022-09-09 04:19:28 | phial | 3 | 83667 | 1008 | 3.250 | 25743.7 |
| 790 | 2022-08-06 04:05:39 | phial | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 789 | 2022-07-16 16:39:36 | phial | 3 | 83667 | 1008 | 3.203 | 26121.4 |
| 788 | 2022-06-25 09:58:21 | phial | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 787 | 2022-06-14 17:39:28 | phial | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 786 | 2022-06-10 21:22:20 | phial | 3 | 83667 | 1008 | 3.296 | 25384.4 |
| 785 | 2022-06-03 22:20:45 | phial | 3 | 83667 | 1008 | 3.343 | 25027.5 |
| 784 | 2022-05-29 16:06:50 | phial | 3 | 83667 | 1008 | 3.236 | 25855.1 |
| 783 | 2022-05-18 16:46:44 | phial | 3 | 83667 | 1008 | 3.826 | 21868.0 |
| 782 | 2022-05-18 01:56:24 | phial | 3 | 83667 | 1008 | 3.516 | 23796.1 |
| 781 | 2022-05-17 10:42:45 | phial | 3 | 83667 | 1008 | 4.486 | 18650.7 |
| 780 | 2022-05-16 13:21:04 | phial | 3 | 83667 | 1008 | 3.843 | 21771.3 |
| 779 | 2022-05-15 05:12:43 | phial | 3 | 83667 | 1008 | 3.843 | 21771.3 |
| 778 | 2022-05-14 05:46:27 | phial | 3 | 83667 | 1008 | 3.283 | 25484.9 |
| 777 | 2022-05-13 17:29:55 | phial | 3 | 83667 | 1008 | 4.593 | 18216.2 |
| 776 | 2022-05-13 08:08:35 | phial | 3 | 83667 | 1008 | 3.733 | 22412.8 |
| 775 | 2022-05-12 14:44:34 | phial | 3 | 83667 | 1008 | 3.483 | 24021.5 |
| 774 | 2022-05-11 18:33:55 | phial | 3 | 83667 | 1008 | 3.610 | 23176.5 |
| 773 | 2022-05-11 09:25:18 | phial | 3 | 83667 | 1008 | 4.280 | 19548.4 |