History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"carer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
958 | 2024-05-09 13:59:20 | carer | 1 | 28756 | 28 | 0.580 | 49579.3 |
957 | 2024-05-07 16:13:41 | carer | 1 | 28756 | 28 | 3.830 | 7508.1 |
956 | 2024-05-03 13:23:06 | carer | 1 | 28756 | 28 | 0.436 | 65954.1 |
955 | 2024-04-30 09:50:59 | carer | 1 | 28756 | 28 | 0.593 | 48492.4 |
954 | 2024-04-30 03:04:16 | carer | 1 | 28756 | 28 | 1.076 | 26724.9 |
953 | 2024-04-30 02:39:51 | carer | 2 | 53800 | 414 | 3.403 | 15809.6 |
952 | 2024-04-29 11:28:21 | carer | 1 | 28756 | 28 | 0.546 | 52666.7 |
951 | 2024-04-28 22:39:15 | carer | 2 | 53800 | 414 | 1.860 | 28924.7 |
950 | 2024-04-28 22:39:11 | carer | 1 | 28756 | 28 | 0.610 | 47141.0 |
949 | 2024-04-28 22:38:57 | carer | 1 | 28756 | 28 | 0.516 | 55728.7 |
948 | 2024-04-28 22:38:52 | carer | 2 | 53800 | 414 | 1.500 | 35866.7 |
947 | 2024-04-17 12:56:45 | carer | 1 | 28756 | 28 | 0.593 | 48492.4 |
946 | 2024-04-03 04:54:37 | carer | 1 | 28756 | 28 | 1.656 | 17364.7 |
945 | 2024-03-31 05:07:50 | carer | 2 | 53800 | 414 | 4.110 | 13090.0 |
944 | 2024-03-31 04:09:59 | carer | 1 | 28756 | 28 | 0.640 | 44931.3 |
943 | 2024-03-27 06:38:35 | carer | 1 | 28756 | 28 | 0.486 | 59168.7 |
942 | 2024-03-25 22:40:12 | carer | 1 | 28756 | 28 | 0.546 | 52666.7 |
941 | 2024-03-22 14:19:19 | carer | 1 | 28756 | 28 | 0.533 | 53951.2 |
940 | 2024-03-22 11:08:22 | carer | 1 | 28756 | 28 | 0.623 | 46157.3 |
939 | 2024-02-26 01:42:54 | carer | 2 | 53800 | 414 | 2.860 | 18811.2 |
938 | 2024-02-25 18:39:55 | carer | 1 | 28756 | 28 | 1.140 | 25224.6 |
937 | 2024-02-10 11:35:48 | carer | 1 | 28756 | 28 | 1.173 | 24514.9 |
936 | 2024-02-02 20:55:18 | carer | 1 | 28756 | 28 | 0.530 | 54256.6 |
935 | 2024-01-25 22:38:29 | carer | 1 | 28756 | 28 | 0.563 | 51076.4 |
934 | 2024-01-23 10:29:56 | carer | 1 | 28756 | 28 | 1.470 | 19561.9 |
933 | 2024-01-07 01:43:23 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
932 | 2024-01-05 10:46:01 | carer | 2 | 53800 | 414 | 1.610 | 33416.1 |
931 | 2023-12-20 11:36:49 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
930 | 2023-12-04 14:09:50 | carer | 1 | 28756 | 28 | 0.563 | 51076.4 |
929 | 2023-12-03 10:43:24 | carer | 1 | 28756 | 28 | 0.533 | 53951.2 |
928 | 2023-12-03 10:43:23 | carer | 1 | 28756 | 28 | 0.530 | 54256.6 |
927 | 2023-11-29 08:27:55 | carer | 2 | 53800 | 414 | 1.530 | 35163.4 |
926 | 2023-11-24 18:48:42 | carer | 1 | 28756 | 28 | 0.610 | 47141.0 |
925 | 2023-11-24 16:16:27 | carer | 2 | 53800 | 414 | 1.516 | 35488.1 |
924 | 2023-11-23 05:17:04 | carer | 2 | 53800 | 414 | 1.623 | 33148.5 |
923 | 2023-11-10 05:52:16 | carer | 1 | 28756 | 28 | 1.126 | 25538.2 |
922 | 2023-11-09 03:12:08 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
921 | 2023-10-30 13:46:49 | carer | 2 | 53800 | 414 | 1.640 | 32804.9 |
920 | 2023-10-27 08:27:20 | carer | 1 | 28756 | 28 | 0.560 | 51350.0 |
919 | 2023-10-26 08:29:51 | carer | 1 | 28756 | 28 | 0.516 | 55728.7 |
918 | 2023-10-20 09:46:52 | carer | 1 | 28756 | 28 | 0.486 | 59168.7 |
917 | 2023-10-20 04:31:05 | carer | 2 | 53800 | 414 | 1.750 | 30742.9 |
916 | 2023-10-20 01:04:05 | carer | 1 | 28756 | 28 | 0.483 | 59536.2 |
915 | 2023-10-18 02:55:13 | carer | 1 | 28756 | 28 | 0.530 | 54256.6 |
914 | 2023-10-15 15:02:55 | carer | 2 | 53800 | 414 | 1.530 | 35163.4 |
913 | 2023-10-11 00:29:20 | carer | 1 | 28756 | 28 | 0.483 | 59536.2 |
912 | 2023-10-10 17:34:45 | carer | 2 | 53800 | 414 | 1.593 | 33772.8 |
911 | 2023-10-07 00:00:42 | carer | 1 | 28756 | 28 | 0.450 | 63902.2 |
910 | 2023-10-04 08:23:34 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
909 | 2023-09-28 05:55:22 | carer | 2 | 53800 | 414 | 1.780 | 30224.7 |
908 | 2023-09-20 21:34:25 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
907 | 2023-09-19 19:46:23 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
906 | 2023-09-14 05:18:30 | carer | 1 | 28756 | 28 | 0.530 | 54256.6 |
905 | 2023-09-01 08:28:39 | carer | 1 | 28756 | 28 | 0.470 | 61183.0 |
904 | 2023-08-04 12:19:37 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
903 | 2023-07-21 07:03:10 | carer | 2 | 53800 | 414 | 1.516 | 35488.1 |
902 | 2023-07-09 00:25:26 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
901 | 2023-05-28 21:18:34 | carer | 1 | 28756 | 28 | 0.906 | 31739.5 |
900 | 2023-04-29 20:48:35 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
899 | 2023-04-28 17:54:35 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
898 | 2023-04-04 18:04:57 | carer | 2 | 53800 | 414 | 1.483 | 36277.8 |
897 | 2023-03-26 23:20:39 | carer | 1 | 28756 | 28 | 0.486 | 59168.7 |
896 | 2023-03-12 12:25:52 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
895 | 2023-02-26 05:59:28 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
894 | 2023-02-21 00:02:21 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
893 | 2022-12-31 02:09:30 | carer | 2 | 53800 | 414 | 1.393 | 38621.7 |
892 | 2022-12-18 09:34:49 | carer | 1 | 28756 | 28 | 0.436 | 65954.1 |
891 | 2022-11-25 17:04:14 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
890 | 2022-11-23 18:07:26 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
889 | 2022-09-14 09:17:12 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
888 | 2022-09-01 16:42:07 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
887 | 2022-09-01 14:48:22 | carer | 2 | 53800 | 414 | 1.546 | 34799.5 |
886 | 2022-08-28 10:14:25 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
885 | 2022-08-28 05:59:15 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
884 | 2022-08-19 18:38:54 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
883 | 2022-08-14 20:11:16 | carer | 1 | 28756 | 28 | 0.530 | 54256.6 |
882 | 2022-08-12 02:25:29 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
881 | 2022-08-09 14:30:10 | carer | 1 | 28756 | 28 | 0.440 | 65354.5 |
880 | 2022-08-06 13:23:04 | carer | 1 | 28756 | 28 | 0.466 | 61708.2 |
879 | 2022-07-04 01:08:15 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
878 | 2022-05-14 04:45:12 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
877 | 2022-05-10 19:43:43 | carer | 1 | 28756 | 28 | 0.470 | 61183.0 |
876 | 2022-04-17 11:10:42 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
875 | 2022-02-06 00:31:19 | carer | 1 | 28756 | 28 | 0.513 | 56054.6 |
874 | 2022-01-11 00:54:19 | carer | 1 | 28756 | 28 | 0.516 | 55728.7 |
873 | 2021-11-11 07:44:36 | carer | 1 | 28756 | 28 | 0.516 | 55728.7 |
872 | 2021-11-11 04:21:33 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
871 | 2021-11-09 03:09:30 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
870 | 2021-11-01 18:28:20 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
869 | 2021-09-20 07:42:02 | carer | 1 | 28756 | 28 | 0.513 | 56054.6 |
868 | 2021-09-18 03:28:35 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
867 | 2021-08-18 13:19:55 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
866 | 2021-08-16 09:23:41 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |
865 | 2021-08-01 23:16:53 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
864 | 2021-07-28 18:10:45 | carer | 1 | 28756 | 28 | 0.470 | 61183.0 |
863 | 2021-06-05 07:42:25 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
862 | 2021-05-20 07:04:38 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
861 | 2021-05-01 08:55:28 | carer | 1 | 28756 | 28 | 0.500 | 57512.0 |
860 | 2021-03-18 10:53:19 | carer | 2 | 53800 | 414 | 1.456 | 36950.5 |
859 | 2021-03-14 01:12:51 | carer | 1 | 28756 | 28 | 0.453 | 63479.0 |