History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aster"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1063 | 2024-04-18 04:26:05 | aster | 1 | 28756 | 22 | 1.516 | 18968.3 |
1062 | 2024-04-11 13:41:18 | aster | 1 | 28756 | 22 | 0.516 | 55728.7 |
1061 | 2024-04-03 07:16:22 | aster | 1 | 28756 | 22 | 0.546 | 52666.7 |
1060 | 2024-03-31 04:51:41 | aster | 2 | 53800 | 282 | 3.860 | 13937.8 |
1059 | 2024-03-31 04:15:15 | aster | 1 | 28756 | 22 | 0.876 | 32826.5 |
1058 | 2024-03-28 20:04:10 | aster | 1 | 28756 | 22 | 1.046 | 27491.4 |
1057 | 2024-03-10 08:33:24 | aster | 1 | 28756 | 22 | 1.156 | 24875.4 |
1056 | 2024-03-07 18:30:14 | aster | 1 | 28756 | 22 | 0.546 | 52666.7 |
1055 | 2024-03-04 07:38:54 | aster | 2 | 53800 | 282 | 4.296 | 12523.3 |
1054 | 2024-03-04 03:22:49 | aster | 2 | 53800 | 282 | 1.453 | 37026.8 |
1053 | 2024-03-04 03:22:44 | aster | 1 | 28756 | 22 | 0.500 | 57512.0 |
1052 | 2024-03-01 02:25:00 | aster | 1 | 28756 | 22 | 0.576 | 49923.6 |
1051 | 2024-02-28 16:51:48 | aster | 1 | 28756 | 22 | 1.096 | 26237.2 |
1050 | 2024-02-26 07:55:17 | aster | 1 | 28756 | 22 | 0.576 | 49923.6 |
1049 | 2024-02-25 18:47:25 | aster | 2 | 53800 | 282 | 4.936 | 10899.5 |
1048 | 2024-02-23 17:32:48 | aster | 1 | 28756 | 22 | 0.500 | 57512.0 |
1047 | 2024-02-02 22:53:23 | aster | 1 | 28756 | 22 | 0.530 | 54256.6 |
1046 | 2024-01-28 19:07:03 | aster | 1 | 28756 | 22 | 0.500 | 57512.0 |
1045 | 2024-01-27 07:38:01 | aster | 1 | 28756 | 22 | 0.500 | 57512.0 |
1044 | 2024-01-19 15:34:26 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
1043 | 2024-01-02 04:08:27 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
1042 | 2023-12-29 17:33:02 | aster | 1 | 28756 | 22 | 0.440 | 65354.5 |
1041 | 2023-12-27 20:09:10 | aster | 2 | 53800 | 282 | 1.703 | 31591.3 |
1040 | 2023-12-15 13:50:13 | aster | 1 | 28756 | 22 | 0.530 | 54256.6 |
1039 | 2023-12-04 12:25:56 | aster | 2 | 53800 | 282 | 1.436 | 37465.2 |
1038 | 2023-11-20 12:13:30 | aster | 2 | 53800 | 282 | 1.436 | 37465.2 |
1037 | 2023-11-19 11:33:28 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
1036 | 2023-11-19 08:58:00 | aster | 1 | 28756 | 22 | 0.483 | 59536.2 |
1035 | 2023-11-08 20:29:44 | aster | 1 | 28756 | 22 | 0.470 | 61183.0 |
1034 | 2023-10-30 10:36:16 | aster | 2 | 53800 | 282 | 1.983 | 27130.6 |
1033 | 2023-10-28 00:37:59 | aster | 1 | 28756 | 22 | 0.466 | 61708.2 |
1032 | 2023-10-21 23:54:29 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
1031 | 2023-10-20 02:08:55 | aster | 2 | 53800 | 282 | 1.673 | 32157.8 |
1030 | 2023-10-16 21:24:41 | aster | 1 | 28756 | 22 | 0.546 | 52666.7 |
1029 | 2023-10-16 11:58:48 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
1028 | 2023-10-05 19:52:04 | aster | 1 | 28756 | 22 | 0.513 | 56054.6 |
1027 | 2023-10-01 22:57:01 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
1026 | 2023-09-26 17:08:41 | aster | 2 | 53800 | 282 | 1.766 | 30464.3 |
1025 | 2023-09-26 15:56:57 | aster | 1 | 28756 | 22 | 1.046 | 27491.4 |
1024 | 2023-09-25 19:47:04 | aster | 1 | 28756 | 22 | 0.500 | 57512.0 |
1023 | 2023-09-20 05:52:01 | aster | 1 | 28756 | 22 | 0.516 | 55728.7 |
1022 | 2023-09-12 23:53:52 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
1021 | 2023-08-15 09:58:31 | aster | 1 | 28756 | 22 | 0.516 | 55728.7 |
1020 | 2023-08-14 20:20:10 | aster | 1 | 28756 | 22 | 0.470 | 61183.0 |
1019 | 2023-08-10 04:07:44 | aster | 1 | 28756 | 22 | 0.626 | 45936.1 |
1018 | 2023-08-09 04:58:51 | aster | 1 | 28756 | 22 | 0.440 | 65354.5 |
1017 | 2023-07-29 13:12:30 | aster | 1 | 28756 | 22 | 0.483 | 59536.2 |
1016 | 2023-07-03 00:46:55 | aster | 2 | 53800 | 282 | 1.670 | 32215.6 |
1015 | 2023-06-20 07:41:31 | aster | 1 | 28756 | 22 | 0.486 | 59168.7 |
1014 | 2023-06-19 10:37:27 | aster | 1 | 28756 | 22 | 0.486 | 59168.7 |
1013 | 2023-05-09 21:26:44 | aster | 1 | 28756 | 22 | 0.483 | 59536.2 |
1012 | 2023-05-01 20:05:32 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
1011 | 2023-04-29 11:21:24 | aster | 1 | 28756 | 22 | 0.466 | 61708.2 |
1010 | 2023-03-31 13:38:08 | aster | 1 | 28756 | 22 | 0.500 | 57512.0 |
1009 | 2023-03-24 00:41:35 | aster | 2 | 53800 | 282 | 1.500 | 35866.7 |
1008 | 2023-03-17 02:22:27 | aster | 1 | 28756 | 22 | 0.436 | 65954.1 |
1007 | 2023-03-13 19:36:42 | aster | 1 | 28756 | 22 | 0.483 | 59536.2 |
1006 | 2023-03-11 07:20:42 | aster | 1 | 28756 | 22 | 0.440 | 65354.5 |
1005 | 2023-02-20 22:19:54 | aster | 1 | 28756 | 22 | 0.436 | 65954.1 |
1004 | 2023-02-18 17:01:46 | aster | 1 | 28756 | 22 | 0.483 | 59536.2 |
1003 | 2023-01-17 10:55:29 | aster | 1 | 28756 | 22 | 0.483 | 59536.2 |
1002 | 2022-12-31 22:16:13 | aster | 1 | 28756 | 22 | 0.470 | 61183.0 |
1001 | 2022-12-22 19:23:58 | aster | 2 | 53800 | 282 | 1.516 | 35488.1 |
1000 | 2022-12-16 00:15:19 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
999 | 2022-12-05 13:44:39 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
998 | 2022-12-03 14:44:48 | aster | 1 | 28756 | 22 | 0.940 | 30591.5 |
997 | 2022-12-02 05:34:13 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
996 | 2022-11-21 09:08:57 | aster | 1 | 28756 | 22 | 0.516 | 55728.7 |
995 | 2022-11-18 15:25:08 | aster | 1 | 28756 | 22 | 0.470 | 61183.0 |
994 | 2022-11-16 11:35:18 | aster | 1 | 28756 | 22 | 0.546 | 52666.7 |
993 | 2022-10-30 22:11:21 | aster | 1 | 28756 | 22 | 0.450 | 63902.2 |
992 | 2022-10-29 20:33:07 | aster | 1 | 28756 | 22 | 0.483 | 59536.2 |
991 | 2022-10-28 21:15:23 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
990 | 2022-10-27 20:11:36 | aster | 1 | 28756 | 22 | 0.483 | 59536.2 |
989 | 2022-10-25 18:39:23 | aster | 1 | 28756 | 22 | 0.470 | 61183.0 |
988 | 2022-10-24 23:13:12 | aster | 1 | 28756 | 22 | 0.436 | 65954.1 |
987 | 2022-10-23 22:23:17 | aster | 1 | 28756 | 22 | 0.546 | 52666.7 |
986 | 2022-10-22 20:15:37 | aster | 1 | 28756 | 22 | 0.483 | 59536.2 |
985 | 2022-10-19 22:50:49 | aster | 1 | 28756 | 22 | 0.500 | 57512.0 |
984 | 2022-10-13 21:43:05 | aster | 1 | 28756 | 22 | 0.440 | 65354.5 |
983 | 2022-10-11 23:10:17 | aster | 1 | 28756 | 22 | 0.450 | 63902.2 |
982 | 2022-10-08 23:23:16 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
981 | 2022-10-01 09:04:17 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
980 | 2022-09-18 10:27:19 | aster | 1 | 28756 | 22 | 0.516 | 55728.7 |
979 | 2022-09-11 19:30:03 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
978 | 2022-09-10 14:20:49 | aster | 1 | 28756 | 22 | 0.533 | 53951.2 |
977 | 2022-09-09 10:27:37 | aster | 1 | 28756 | 22 | 0.436 | 65954.1 |
976 | 2022-09-04 05:20:02 | aster | 1 | 28756 | 22 | 0.546 | 52666.7 |
975 | 2022-09-03 10:21:52 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
974 | 2022-09-01 22:16:51 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
973 | 2022-09-01 13:15:02 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
972 | 2022-08-30 01:07:22 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
971 | 2022-08-28 21:28:42 | aster | 1 | 28756 | 22 | 0.436 | 65954.1 |
970 | 2022-08-27 21:37:10 | aster | 2 | 53800 | 282 | 1.423 | 37807.4 |
969 | 2022-08-20 04:02:59 | aster | 2 | 53800 | 282 | 1.406 | 38264.6 |
968 | 2022-08-18 07:32:30 | aster | 1 | 28756 | 22 | 0.500 | 57512.0 |
967 | 2022-08-17 15:48:10 | aster | 1 | 28756 | 22 | 0.500 | 57512.0 |
966 | 2022-08-10 12:45:04 | aster | 1 | 28756 | 22 | 0.453 | 63479.0 |
965 | 2022-08-06 15:40:31 | aster | 1 | 28756 | 22 | 0.483 | 59536.2 |
964 | 2022-08-06 04:48:03 | aster | 1 | 28756 | 22 | 0.656 | 43835.4 |