History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"apple"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1072 | 2024-04-10 14:53:53 | apple | 1 | 28756 | 7 | 0.873 | 32939.3 |
1071 | 2024-04-04 22:05:26 | apple | 1 | 28756 | 7 | 0.483 | 59536.2 |
1070 | 2024-04-03 07:19:14 | apple | 1 | 28756 | 7 | 0.456 | 63061.4 |
1069 | 2024-03-31 06:41:53 | apple | 1 | 28756 | 7 | 1.220 | 23570.5 |
1068 | 2024-03-29 07:59:08 | apple | 1 | 28756 | 7 | 1.720 | 16718.6 |
1067 | 2024-03-28 08:19:54 | apple | 1 | 28756 | 7 | 0.500 | 57512.0 |
1066 | 2024-03-06 21:57:52 | apple | 3 | 83667 | 887 | 4.766 | 17555.0 |
1065 | 2024-03-05 16:39:24 | apple | 2 | 53800 | 72 | 1.576 | 34137.1 |
1064 | 2024-03-05 16:39:01 | apple | 3 | 83667 | 887 | 5.796 | 14435.3 |
1063 | 2024-03-04 09:15:42 | apple | 3 | 83667 | 887 | 9.843 | 8500.2 |
1062 | 2024-03-04 06:31:44 | apple | 3 | 83667 | 887 | 3.593 | 23286.1 |
1061 | 2024-03-04 06:31:42 | apple | 2 | 53800 | 72 | 1.390 | 38705.0 |
1060 | 2024-03-04 06:31:39 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
1059 | 2024-03-01 03:26:58 | apple | 1 | 28756 | 7 | 1.030 | 27918.4 |
1058 | 2024-02-28 16:51:22 | apple | 1 | 28756 | 7 | 0.550 | 52283.6 |
1057 | 2024-02-28 02:23:52 | apple | 1 | 28756 | 7 | 0.530 | 54256.6 |
1056 | 2024-02-14 16:47:37 | apple | 3 | 83667 | 887 | 11.296 | 7406.8 |
1055 | 2024-02-14 11:35:07 | apple | 3 | 83667 | 887 | 3.420 | 24464.0 |
1054 | 2024-02-05 09:50:13 | apple | 1 | 28756 | 7 | 0.546 | 52666.7 |
1053 | 2024-02-03 02:03:47 | apple | 1 | 28756 | 7 | 0.513 | 56054.6 |
1052 | 2024-01-29 03:52:11 | apple | 1 | 28756 | 7 | 0.500 | 57512.0 |
1051 | 2024-01-28 21:37:49 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
1050 | 2024-01-17 13:41:20 | apple | 3 | 83667 | 887 | 3.326 | 25155.4 |
1049 | 2024-01-12 11:52:41 | apple | 2 | 53800 | 72 | 1.610 | 33416.1 |
1048 | 2023-12-31 10:05:49 | apple | 3 | 83667 | 887 | 8.360 | 10008.0 |
1047 | 2023-12-26 23:54:13 | apple | 3 | 83667 | 887 | 3.780 | 22134.1 |
1046 | 2023-12-25 15:44:01 | apple | 1 | 28756 | 7 | 0.436 | 65954.1 |
1045 | 2023-12-25 07:44:25 | apple | 3 | 83667 | 887 | 3.970 | 21074.8 |
1044 | 2023-12-23 03:00:47 | apple | 3 | 83667 | 887 | 3.406 | 24564.6 |
1043 | 2023-12-23 03:00:45 | apple | 2 | 53800 | 72 | 1.406 | 38264.6 |
1042 | 2023-12-23 01:10:07 | apple | 2 | 53800 | 72 | 1.403 | 38346.4 |
1041 | 2023-12-08 11:44:32 | apple | 1 | 28756 | 7 | 0.546 | 52666.7 |
1040 | 2023-12-08 11:44:31 | apple | 1 | 28756 | 7 | 0.533 | 53951.2 |
1039 | 2023-11-25 01:00:25 | apple | 3 | 83667 | 887 | 3.356 | 24930.6 |
1038 | 2023-11-25 01:00:23 | apple | 2 | 53800 | 72 | 1.436 | 37465.2 |
1037 | 2023-11-16 22:00:49 | apple | 1 | 28756 | 7 | 0.580 | 49579.3 |
1036 | 2023-11-13 02:03:03 | apple | 3 | 83667 | 887 | 4.046 | 20678.9 |
1035 | 2023-11-12 07:32:36 | apple | 1 | 28756 | 7 | 0.516 | 55728.7 |
1034 | 2023-11-03 10:37:16 | apple | 1 | 28756 | 7 | 0.436 | 65954.1 |
1033 | 2023-10-26 10:05:07 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
1032 | 2023-10-21 22:36:56 | apple | 1 | 28756 | 7 | 0.513 | 56054.6 |
1031 | 2023-10-17 15:53:55 | apple | 1 | 28756 | 7 | 1.156 | 24875.4 |
1030 | 2023-10-17 10:45:51 | apple | 1 | 28756 | 7 | 0.546 | 52666.7 |
1029 | 2023-10-14 09:28:33 | apple | 1 | 28756 | 7 | 0.483 | 59536.2 |
1028 | 2023-10-12 20:21:38 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
1027 | 2023-10-12 08:14:59 | apple | 1 | 28756 | 7 | 0.576 | 49923.6 |
1026 | 2023-10-05 03:24:58 | apple | 1 | 28756 | 7 | 0.513 | 56054.6 |
1025 | 2023-09-30 15:27:21 | apple | 2 | 53800 | 72 | 1.610 | 33416.1 |
1024 | 2023-09-29 00:30:23 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
1023 | 2023-09-24 11:33:30 | apple | 2 | 53800 | 72 | 1.610 | 33416.1 |
1022 | 2023-09-22 03:58:48 | apple | 1 | 28756 | 7 | 0.483 | 59536.2 |
1021 | 2023-08-15 16:52:05 | apple | 3 | 83667 | 887 | 3.483 | 24021.5 |
1020 | 2023-08-09 12:15:43 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
1019 | 2023-07-08 01:24:45 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
1018 | 2023-07-05 21:40:30 | apple | 2 | 53800 | 72 | 1.453 | 37026.8 |
1017 | 2023-05-15 06:47:58 | apple | 1 | 28756 | 7 | 0.483 | 59536.2 |
1016 | 2023-05-07 09:16:28 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
1015 | 2023-04-27 13:39:58 | apple | 3 | 83667 | 887 | 5.546 | 15086.0 |
1014 | 2023-03-31 12:49:08 | apple | 1 | 28756 | 7 | 0.500 | 57512.0 |
1013 | 2023-03-29 04:07:07 | apple | 1 | 28756 | 7 | 0.470 | 61183.0 |
1012 | 2023-03-27 17:14:14 | apple | 1 | 28756 | 7 | 0.436 | 65954.1 |
1011 | 2023-03-27 00:40:47 | apple | 2 | 53800 | 72 | 1.403 | 38346.4 |
1010 | 2023-02-28 20:03:03 | apple | 1 | 28756 | 7 | 0.486 | 59168.7 |
1009 | 2023-01-31 06:07:45 | apple | 3 | 83667 | 887 | 3.283 | 25484.9 |
1008 | 2022-12-26 08:12:07 | apple | 1 | 28756 | 7 | 0.500 | 57512.0 |
1007 | 2022-12-25 07:18:48 | apple | 1 | 28756 | 7 | 0.436 | 65954.1 |
1006 | 2022-12-25 00:45:13 | apple | 2 | 53800 | 72 | 1.530 | 35163.4 |
1005 | 2022-12-22 15:47:42 | apple | 1 | 28756 | 7 | 0.436 | 65954.1 |
1004 | 2022-11-12 14:51:54 | apple | 3 | 83667 | 887 | 3.283 | 25484.9 |
1003 | 2022-09-12 19:16:50 | apple | 1 | 28756 | 7 | 0.440 | 65354.5 |
1002 | 2022-09-08 10:49:02 | apple | 1 | 28756 | 7 | 0.483 | 59536.2 |
1001 | 2022-09-03 16:51:09 | apple | 1 | 28756 | 7 | 0.470 | 61183.0 |
1000 | 2022-08-28 03:51:03 | apple | 2 | 53800 | 72 | 1.373 | 39184.3 |
999 | 2022-08-15 16:51:29 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
998 | 2022-08-10 15:40:59 | apple | 1 | 28756 | 7 | 0.563 | 51076.4 |
997 | 2022-08-02 23:44:59 | apple | 1 | 28756 | 7 | 0.436 | 65954.1 |
996 | 2022-07-25 04:45:59 | apple | 1 | 28756 | 7 | 0.483 | 59536.2 |
995 | 2022-07-18 13:53:52 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
994 | 2022-07-18 10:29:06 | apple | 1 | 28756 | 7 | 0.513 | 56054.6 |
993 | 2022-07-16 06:09:26 | apple | 1 | 28756 | 7 | 0.436 | 65954.1 |
992 | 2022-07-15 22:32:24 | apple | 1 | 28756 | 7 | 0.466 | 61708.2 |
991 | 2022-07-03 14:14:55 | apple | 1 | 28756 | 7 | 0.436 | 65954.1 |
990 | 2022-06-17 04:17:48 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
989 | 2022-06-15 07:37:48 | apple | 3 | 83667 | 887 | 3.250 | 25743.7 |
988 | 2022-06-04 03:41:52 | apple | 1 | 28756 | 7 | 0.486 | 59168.7 |
987 | 2022-05-23 18:49:31 | apple | 1 | 28756 | 7 | 0.456 | 63061.4 |
986 | 2022-05-20 08:51:25 | apple | 1 | 28756 | 7 | 0.470 | 61183.0 |
985 | 2022-03-20 23:14:54 | apple | 2 | 53800 | 72 | 1.390 | 38705.0 |
984 | 2022-03-18 04:32:42 | apple | 1 | 28756 | 7 | 0.563 | 51076.4 |
983 | 2022-03-16 01:33:22 | apple | 1 | 28756 | 7 | 0.516 | 55728.7 |
982 | 2022-03-08 19:45:03 | apple | 1 | 28756 | 7 | 0.766 | 37540.5 |
981 | 2022-02-12 04:13:03 | apple | 1 | 28756 | 7 | 0.453 | 63479.0 |
980 | 2022-02-07 16:55:38 | apple | 3 | 83667 | 887 | 4.050 | 20658.5 |
979 | 2021-12-26 08:04:35 | apple | 1 | 28756 | 7 | 0.593 | 48492.4 |
978 | 2021-12-23 00:54:08 | apple | 1 | 28756 | 7 | 0.533 | 53951.2 |
977 | 2021-12-19 12:30:03 | apple | 1 | 28756 | 7 | 0.470 | 61183.0 |
976 | 2021-12-18 22:26:51 | apple | 1 | 28756 | 7 | 0.516 | 55728.7 |
975 | 2021-12-07 23:46:28 | apple | 2 | 53800 | 72 | 1.373 | 39184.3 |
974 | 2021-11-14 06:48:18 | apple | 1 | 28756 | 7 | 0.530 | 54256.6 |
973 | 2021-11-13 05:54:07 | apple | 1 | 28756 | 7 | 0.513 | 56054.6 |