History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"airmen"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 892 | 2024-04-11 05:15:22 | airmen | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 891 | 2024-01-29 20:01:54 | airmen | 2 | 82551 | 47 | 2.796 | 29524.7 |
| 890 | 2024-01-29 19:55:50 | airmen | 3 | 112716 | 562 | 5.843 | 19290.8 |
| 889 | 2024-01-29 07:59:57 | airmen | 3 | 112716 | 562 | 6.156 | 18309.9 |
| 888 | 2024-01-29 07:59:53 | airmen | 2 | 82551 | 47 | 2.300 | 35891.7 |
| 887 | 2024-01-29 07:59:49 | airmen | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 886 | 2024-01-29 05:07:08 | airmen | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 885 | 2024-01-02 19:10:41 | airmen | 3 | 112716 | 562 | 5.266 | 21404.5 |
| 884 | 2024-01-02 19:10:39 | airmen | 2 | 82551 | 47 | 2.533 | 32590.2 |
| 883 | 2023-12-27 16:42:04 | airmen | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 882 | 2023-12-27 08:17:28 | airmen | 2 | 82551 | 47 | 2.216 | 37252.3 |
| 881 | 2023-11-23 22:21:03 | airmen | 3 | 112716 | 562 | 5.873 | 19192.2 |
| 880 | 2023-11-23 22:21:05 | airmen | 2 | 82551 | 47 | 2.720 | 30349.6 |
| 879 | 2023-11-21 13:39:42 | airmen | 3 | 112716 | 562 | 5.310 | 21227.1 |
| 878 | 2023-11-21 13:39:44 | airmen | 2 | 82551 | 47 | 2.516 | 32810.4 |
| 877 | 2023-11-15 07:54:38 | airmen | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 876 | 2023-11-14 16:52:04 | airmen | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 875 | 2023-11-09 03:46:40 | airmen | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 874 | 2023-10-26 07:51:28 | airmen | 1 | 48755 | 3 | 1.733 | 28133.3 |
| 873 | 2023-10-21 19:13:37 | airmen | 1 | 48755 | 3 | 1.700 | 28679.4 |
| 872 | 2023-10-18 17:24:18 | airmen | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 871 | 2023-10-17 13:58:18 | airmen | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 870 | 2023-10-16 07:24:33 | airmen | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 869 | 2023-10-14 04:22:43 | airmen | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 868 | 2023-10-13 17:06:46 | airmen | 1 | 48755 | 3 | 1.783 | 27344.4 |
| 867 | 2023-10-05 04:51:09 | airmen | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 866 | 2023-09-29 05:01:33 | airmen | 2 | 82551 | 47 | 2.300 | 35891.7 |
| 865 | 2023-09-25 02:04:34 | airmen | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 864 | 2023-09-12 17:45:38 | airmen | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 863 | 2023-08-12 18:58:43 | airmen | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 862 | 2023-07-10 06:11:36 | airmen | 2 | 82551 | 47 | 2.423 | 34069.7 |
| 861 | 2023-07-08 10:24:46 | airmen | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 860 | 2023-05-13 03:16:43 | airmen | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 859 | 2023-04-04 15:16:48 | airmen | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 858 | 2023-03-31 19:40:14 | airmen | 2 | 82551 | 47 | 2.500 | 33020.4 |
| 857 | 2023-03-31 14:06:05 | airmen | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 856 | 2023-03-07 01:05:12 | airmen | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 855 | 2022-12-30 16:10:10 | airmen | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 854 | 2022-12-28 18:10:24 | airmen | 2 | 82551 | 47 | 2.156 | 38289.0 |
| 853 | 2022-12-26 17:12:20 | airmen | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 852 | 2022-09-19 03:24:13 | airmen | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 851 | 2022-09-12 09:15:05 | airmen | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 850 | 2022-08-28 18:58:20 | airmen | 2 | 82551 | 47 | 2.216 | 37252.3 |
| 849 | 2022-07-01 07:34:57 | airmen | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 848 | 2022-06-29 02:19:42 | airmen | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 847 | 2022-05-24 02:42:24 | airmen | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 846 | 2022-05-20 16:54:06 | airmen | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 845 | 2022-03-01 21:25:45 | airmen | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 844 | 2022-02-08 23:37:01 | airmen | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 843 | 2021-12-14 14:50:40 | airmen | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 842 | 2021-11-23 05:45:35 | airmen | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 841 | 2021-11-04 17:11:43 | airmen | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 840 | 2021-10-19 16:50:07 | airmen | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 839 | 2021-09-09 16:22:42 | airmen | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 838 | 2021-08-18 15:56:04 | airmen | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 837 | 2021-08-16 11:43:26 | airmen | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 836 | 2021-08-04 23:19:38 | airmen | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 835 | 2021-07-25 06:52:58 | airmen | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 834 | 2021-06-07 14:09:30 | airmen | 3 | 112716 | 562 | 11.236 | 10031.7 |
| 833 | 2021-05-15 13:05:25 | airmen | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 832 | 2021-05-04 07:48:04 | airmen | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 831 | 2021-04-30 18:05:42 | airmen | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 830 | 2021-04-15 03:10:40 | airmen | 1 | 48755 | 3 | 1.000 | 48755.0 |
| 829 | 2021-02-25 02:04:19 | airmen | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 828 | 2021-02-19 10:14:24 | airmen | 3 | 112716 | 562 | 5.406 | 20850.2 |
| 827 | 2021-01-28 06:35:42 | airmen | 1 | 48755 | 3 | 1.076 | 45311.3 |
| 826 | 2021-01-28 06:25:11 | airmen | 1 | 48755 | 3 | 0.893 | 54596.9 |
| 825 | 2021-01-26 04:14:33 | airmen | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 824 | 2020-12-30 12:42:37 | airmen | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 823 | 2020-11-12 17:30:35 | airmen | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 822 | 2020-11-02 18:12:11 | airmen | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 821 | 2020-10-25 11:20:45 | airmen | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 820 | 2020-10-21 21:35:38 | airmen | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 819 | 2020-10-16 19:05:41 | airmen | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 818 | 2020-10-08 10:27:46 | airmen | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 817 | 2020-09-03 14:59:49 | airmen | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 816 | 2020-09-01 01:23:48 | airmen | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 815 | 2020-08-11 20:59:23 | airmen | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 814 | 2020-08-08 15:07:45 | airmen | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 813 | 2020-08-05 13:40:44 | airmen | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 812 | 2020-07-22 01:50:42 | airmen | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 811 | 2020-07-18 20:36:17 | airmen | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 810 | 2020-04-27 00:24:56 | airmen | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 809 | 2020-04-20 03:21:53 | airmen | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 808 | 2020-03-26 15:17:54 | airmen | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 807 | 2020-03-25 18:44:18 | airmen | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 806 | 2020-03-24 20:06:37 | airmen | 1 | 48755 | 3 | 1.796 | 27146.4 |
| 805 | 2020-03-23 12:23:46 | airmen | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 804 | 2020-03-22 18:22:02 | airmen | 1 | 48755 | 3 | 0.893 | 54596.9 |
| 803 | 2020-03-18 20:41:09 | airmen | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 802 | 2020-03-06 00:09:53 | airmen | 2 | 82551 | 47 | 2.813 | 29346.2 |
| 801 | 2020-03-03 17:55:31 | airmen | 3 | 112716 | 562 | 5.436 | 20735.1 |
| 800 | 2020-03-03 17:55:23 | airmen | 2 | 82551 | 47 | 2.220 | 37185.1 |
| 799 | 2020-03-03 17:55:16 | airmen | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 798 | 2020-02-28 22:36:18 | airmen | 3 | 112716 | 562 | 6.690 | 16848.4 |
| 797 | 2020-02-27 07:09:55 | airmen | 1 | 48755 | 3 | 1.013 | 48129.3 |
| 796 | 2020-02-26 18:28:28 | airmen | 1 | 48755 | 3 | 0.983 | 49598.2 |
| 795 | 2020-02-21 11:47:48 | airmen | 2 | 82551 | 47 | 2.393 | 34496.9 |
| 794 | 2020-02-21 02:29:15 | airmen | 1 | 48755 | 3 | 1.313 | 37132.5 |
| 793 | 2020-02-19 12:39:50 | airmen | 2 | 82551 | 47 | 2.860 | 28864.0 |