History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"barny"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1001 | 2025-07-13 10:57:51 | barny | 2 | 53800 | 156 | 1.686 | 31909.8 |
1000 | 2025-07-09 20:46:19 | barny | 2 | 53800 | 156 | 8.436 | 6377.4 |
999 | 2025-07-09 16:21:40 | barny | 1 | 28756 | 8 | 0.533 | 53951.2 |
998 | 2025-07-08 16:01:16 | barny | 1 | 28756 | 8 | 1.563 | 18398.0 |
997 | 2025-07-04 14:42:02 | barny | 2 | 53800 | 156 | 7.670 | 7014.3 |
996 | 2025-07-01 08:11:02 | barny | 1 | 28756 | 8 | 0.513 | 56054.6 |
995 | 2025-06-26 02:11:20 | barny | 1 | 28756 | 8 | 3.626 | 7930.5 |
994 | 2025-06-22 09:47:25 | barny | 1 | 28756 | 8 | 2.356 | 12205.4 |
993 | 2025-06-21 02:44:08 | barny | 1 | 28756 | 8 | 0.516 | 55728.7 |
992 | 2025-06-19 10:49:27 | barny | 1 | 28756 | 8 | 3.466 | 8296.6 |
991 | 2025-06-14 08:50:11 | barny | 1 | 28756 | 8 | 1.423 | 20208.0 |
990 | 2025-06-10 03:36:56 | barny | 1 | 28756 | 8 | 1.560 | 18433.3 |
989 | 2025-05-22 10:59:19 | barny | 1 | 28756 | 8 | 2.610 | 11017.6 |
988 | 2025-05-22 10:15:11 | barny | 1 | 28756 | 8 | 2.736 | 10510.2 |
987 | 2025-05-21 15:26:00 | barny | 1 | 28756 | 8 | 0.563 | 51076.4 |
986 | 2025-05-20 13:48:09 | barny | 1 | 28756 | 8 | 1.500 | 19170.7 |
985 | 2025-05-19 02:32:24 | barny | 1 | 28756 | 8 | 1.203 | 23903.6 |
984 | 2025-05-11 08:10:51 | barny | 1 | 28756 | 8 | 0.513 | 56054.6 |
983 | 2025-05-07 21:04:01 | barny | 2 | 53800 | 156 | 5.830 | 9228.1 |
982 | 2025-05-06 23:19:41 | barny | 2 | 53800 | 156 | 1.720 | 31279.1 |
981 | 2025-05-05 21:40:40 | barny | 1 | 28756 | 8 | 1.576 | 18246.2 |
980 | 2025-05-01 15:28:14 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
979 | 2025-04-30 00:37:38 | barny | 1 | 28756 | 8 | 1.313 | 21901.0 |
978 | 2025-04-28 11:01:51 | barny | 1 | 28756 | 8 | 2.156 | 13337.7 |
977 | 2025-04-26 00:59:12 | barny | 1 | 28756 | 8 | 2.453 | 11722.8 |
976 | 2025-04-24 13:26:24 | barny | 1 | 28756 | 8 | 1.063 | 27051.7 |
975 | 2025-04-23 08:03:19 | barny | 1 | 28756 | 8 | 3.453 | 8327.8 |
974 | 2025-04-22 15:28:19 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
973 | 2025-04-21 13:33:29 | barny | 2 | 53800 | 156 | 12.190 | 4413.5 |
972 | 2025-04-20 13:01:59 | barny | 1 | 28756 | 8 | 1.110 | 25906.3 |
971 | 2025-04-20 08:43:29 | barny | 1 | 28756 | 8 | 2.703 | 10638.5 |
970 | 2025-04-19 22:08:35 | barny | 2 | 53800 | 156 | 4.376 | 12294.3 |
969 | 2025-04-07 20:30:54 | barny | 2 | 53800 | 156 | 1.453 | 37026.8 |
968 | 2025-04-07 15:51:25 | barny | 1 | 28756 | 8 | 0.486 | 59168.7 |
967 | 2025-03-30 17:59:15 | barny | 1 | 28756 | 8 | 0.530 | 54256.6 |
966 | 2025-03-29 01:11:14 | barny | 1 | 28756 | 8 | 1.610 | 17860.9 |
965 | 2025-03-24 19:49:28 | barny | 1 | 28756 | 8 | 0.986 | 29164.3 |
964 | 2025-03-22 08:49:08 | barny | 2 | 53800 | 156 | 8.253 | 6518.8 |
963 | 2025-03-20 10:32:07 | barny | 1 | 28756 | 8 | 2.340 | 12288.9 |
962 | 2025-03-07 20:47:22 | barny | 1 | 28756 | 8 | 1.000 | 28756.0 |
961 | 2025-03-07 20:46:24 | barny | 2 | 53800 | 156 | 8.736 | 6158.4 |
960 | 2025-03-03 05:40:19 | barny | 1 | 28756 | 8 | 2.673 | 10757.9 |
959 | 2025-03-03 03:29:53 | barny | 2 | 53800 | 156 | 4.763 | 11295.4 |
958 | 2025-03-02 18:34:40 | barny | 2 | 53800 | 156 | 12.830 | 4193.3 |
957 | 2025-02-27 21:53:47 | barny | 2 | 53800 | 156 | 4.173 | 12892.4 |
956 | 2025-02-27 21:36:32 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
955 | 2025-02-26 03:10:31 | barny | 1 | 28756 | 8 | 1.483 | 19390.4 |
954 | 2025-02-24 02:53:27 | barny | 1 | 28756 | 8 | 1.406 | 20452.3 |
953 | 2025-02-11 01:34:08 | barny | 1 | 28756 | 8 | 3.140 | 9158.0 |
952 | 2025-02-05 12:17:40 | barny | 1 | 28756 | 8 | 2.360 | 12184.7 |
951 | 2025-01-28 19:23:16 | barny | 2 | 53800 | 156 | 4.796 | 11217.7 |
950 | 2025-01-28 13:52:24 | barny | 2 | 53800 | 156 | 6.360 | 8459.1 |
949 | 2025-01-28 08:15:31 | barny | 1 | 28756 | 8 | 2.610 | 11017.6 |
948 | 2025-01-26 12:16:19 | barny | 2 | 53800 | 156 | 4.376 | 12294.3 |
947 | 2025-01-26 11:53:03 | barny | 1 | 28756 | 8 | 0.483 | 59536.2 |
946 | 2025-01-24 17:09:30 | barny | 1 | 28756 | 8 | 2.186 | 13154.6 |
945 | 2025-01-06 15:39:36 | barny | 1 | 28756 | 8 | 0.960 | 29954.2 |
944 | 2025-01-06 04:26:08 | barny | 1 | 28756 | 8 | 2.936 | 9794.3 |
943 | 2024-12-29 18:14:01 | barny | 2 | 53800 | 156 | 8.220 | 6545.0 |
942 | 2024-12-29 08:59:03 | barny | 2 | 53800 | 156 | 6.423 | 8376.1 |
941 | 2024-12-29 08:10:02 | barny | 1 | 28756 | 8 | 0.440 | 65354.5 |
940 | 2024-12-27 17:04:04 | barny | 2 | 53800 | 156 | 8.250 | 6521.2 |
939 | 2024-12-27 06:30:58 | barny | 2 | 53800 | 156 | 7.376 | 7293.9 |
938 | 2024-12-27 06:24:07 | barny | 1 | 28756 | 8 | 0.516 | 55728.7 |
937 | 2024-12-25 16:48:57 | barny | 1 | 28756 | 8 | 2.360 | 12184.7 |
936 | 2024-12-07 00:26:58 | barny | 2 | 53800 | 156 | 8.140 | 6609.3 |
935 | 2024-12-07 00:26:56 | barny | 1 | 28756 | 8 | 2.436 | 11804.6 |
934 | 2024-11-29 01:56:08 | barny | 2 | 53800 | 156 | 8.640 | 6226.9 |
933 | 2024-11-29 01:51:00 | barny | 1 | 28756 | 8 | 1.530 | 18794.8 |
932 | 2024-11-27 04:25:23 | barny | 2 | 53800 | 156 | 11.420 | 4711.0 |
931 | 2024-11-27 03:17:54 | barny | 1 | 28756 | 8 | 0.513 | 56054.6 |
930 | 2024-11-25 11:05:47 | barny | 1 | 28756 | 8 | 2.110 | 13628.4 |
929 | 2024-11-06 21:30:41 | barny | 1 | 28756 | 8 | 2.576 | 11163.0 |
928 | 2024-10-31 11:01:27 | barny | 2 | 53800 | 156 | 7.093 | 7584.9 |
927 | 2024-10-30 01:48:27 | barny | 2 | 53800 | 156 | 4.436 | 12128.0 |
926 | 2024-10-30 01:38:45 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
925 | 2024-10-28 03:33:11 | barny | 1 | 28756 | 8 | 2.970 | 9682.2 |
924 | 2024-10-27 11:47:12 | barny | 1 | 28756 | 8 | 1.406 | 20452.3 |
923 | 2024-10-26 00:12:03 | barny | 1 | 28756 | 8 | 1.580 | 18200.0 |
922 | 2024-10-08 23:01:45 | barny | 1 | 28756 | 8 | 1.470 | 19561.9 |
921 | 2024-10-02 04:33:17 | barny | 2 | 53800 | 156 | 12.936 | 4158.9 |
920 | 2024-09-30 01:03:28 | barny | 2 | 53800 | 156 | 12.923 | 4163.1 |
919 | 2024-09-30 00:11:31 | barny | 1 | 28756 | 8 | 0.500 | 57512.0 |
918 | 2024-09-28 00:41:03 | barny | 1 | 28756 | 8 | 0.470 | 61183.0 |
917 | 2024-09-25 16:42:12 | barny | 1 | 28756 | 8 | 2.940 | 9781.0 |
916 | 2024-09-07 15:08:31 | barny | 1 | 28756 | 8 | 1.343 | 21411.8 |
915 | 2024-08-30 22:01:55 | barny | 2 | 53800 | 156 | 15.626 | 3443.0 |
914 | 2024-08-30 20:45:42 | barny | 2 | 53800 | 156 | 15.220 | 3534.8 |
913 | 2024-08-30 20:39:44 | barny | 1 | 28756 | 8 | 0.533 | 53951.2 |
912 | 2024-08-29 22:58:15 | barny | 1 | 28756 | 8 | 5.456 | 5270.5 |
911 | 2024-08-28 21:48:58 | barny | 1 | 28756 | 8 | 0.483 | 59536.2 |
910 | 2024-08-27 19:51:12 | barny | 1 | 28756 | 8 | 0.466 | 61708.2 |
909 | 2024-08-26 13:17:14 | barny | 1 | 28756 | 8 | 4.623 | 6220.2 |
908 | 2024-08-09 06:04:08 | barny | 2 | 53800 | 156 | 3.236 | 16625.5 |
907 | 2024-08-09 05:02:35 | barny | 1 | 28756 | 8 | 0.563 | 51076.4 |
906 | 2024-08-08 01:46:58 | barny | 1 | 28756 | 8 | 1.656 | 17364.7 |
905 | 2024-07-31 09:53:01 | barny | 2 | 53800 | 156 | 1.623 | 33148.5 |
904 | 2024-07-31 03:32:13 | barny | 2 | 53800 | 156 | 6.923 | 7771.2 |
903 | 2024-07-31 03:00:26 | barny | 1 | 28756 | 8 | 0.563 | 51076.4 |
902 | 2024-07-30 00:20:16 | barny | 1 | 28756 | 8 | 0.606 | 47452.1 |