History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"group"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1087 | 2024-04-28 01:04:32 | group | 1 | 28756 | 5 | 1.940 | 14822.7 |
1086 | 2024-04-27 08:25:14 | group | 1 | 28756 | 5 | 0.530 | 54256.6 |
1085 | 2024-04-18 08:54:41 | group | 1 | 28756 | 5 | 2.033 | 14144.6 |
1084 | 2024-04-16 06:54:57 | group | 1 | 28756 | 5 | 0.486 | 59168.7 |
1083 | 2024-04-14 09:37:18 | group | 3 | 83667 | 787 | 11.093 | 7542.3 |
1082 | 2024-04-14 09:30:55 | group | 2 | 53800 | 74 | 3.610 | 14903.0 |
1081 | 2024-04-12 23:43:29 | group | 3 | 83667 | 787 | 8.096 | 10334.4 |
1080 | 2024-04-12 23:43:33 | group | 1 | 28756 | 5 | 1.123 | 25606.4 |
1079 | 2024-04-12 23:43:25 | group | 2 | 53800 | 74 | 3.483 | 15446.5 |
1078 | 2024-04-06 06:42:21 | group | 3 | 83667 | 787 | 9.376 | 8923.5 |
1077 | 2024-04-06 06:42:14 | group | 2 | 53800 | 74 | 6.063 | 8873.5 |
1076 | 2024-04-06 06:42:11 | group | 1 | 28756 | 5 | 1.000 | 28756.0 |
1075 | 2024-03-27 01:13:15 | group | 1 | 28756 | 5 | 0.546 | 52666.7 |
1074 | 2024-03-19 08:50:10 | group | 1 | 28756 | 5 | 0.436 | 65954.1 |
1073 | 2024-03-07 05:14:31 | group | 1 | 28756 | 5 | 0.513 | 56054.6 |
1072 | 2024-03-06 21:39:13 | group | 3 | 83667 | 787 | 6.000 | 13944.5 |
1071 | 2024-03-06 13:34:10 | group | 3 | 83667 | 787 | 9.126 | 9168.0 |
1070 | 2024-03-05 22:00:05 | group | 3 | 83667 | 787 | 7.143 | 11713.1 |
1069 | 2024-03-05 21:50:42 | group | 3 | 83667 | 787 | 7.610 | 10994.3 |
1068 | 2024-03-05 21:50:41 | group | 2 | 53800 | 74 | 3.720 | 14462.4 |
1067 | 2024-03-05 21:50:33 | group | 1 | 28756 | 5 | 0.500 | 57512.0 |
1066 | 2024-02-25 18:34:09 | group | 1 | 28756 | 5 | 0.546 | 52666.7 |
1065 | 2024-02-18 02:21:26 | group | 1 | 28756 | 5 | 0.516 | 55728.7 |
1064 | 2024-02-08 05:01:57 | group | 1 | 28756 | 5 | 0.500 | 57512.0 |
1063 | 2024-02-03 18:16:51 | group | 1 | 28756 | 5 | 0.483 | 59536.2 |
1062 | 2024-01-16 09:58:39 | group | 1 | 28756 | 5 | 0.440 | 65354.5 |
1061 | 2024-01-01 10:35:23 | group | 1 | 28756 | 5 | 0.420 | 68466.7 |
1060 | 2023-12-10 20:17:01 | group | 3 | 83667 | 787 | 4.280 | 19548.4 |
1059 | 2023-12-04 18:08:09 | group | 1 | 28756 | 5 | 0.483 | 59536.2 |
1058 | 2023-12-04 18:08:08 | group | 1 | 28756 | 5 | 0.500 | 57512.0 |
1057 | 2023-11-29 09:54:56 | group | 2 | 53800 | 74 | 1.360 | 39558.8 |
1056 | 2023-11-29 09:17:37 | group | 3 | 83667 | 787 | 3.173 | 26368.4 |
1055 | 2023-11-27 05:54:01 | group | 3 | 83667 | 787 | 3.513 | 23816.4 |
1054 | 2023-11-25 05:33:32 | group | 3 | 83667 | 787 | 3.236 | 25855.1 |
1053 | 2023-11-25 05:33:28 | group | 2 | 53800 | 74 | 1.830 | 29398.9 |
1052 | 2023-11-24 06:55:07 | group | 3 | 83667 | 787 | 3.970 | 21074.8 |
1051 | 2023-11-24 06:55:06 | group | 2 | 53800 | 74 | 1.643 | 32745.0 |
1050 | 2023-11-21 11:42:07 | group | 1 | 28756 | 5 | 0.546 | 52666.7 |
1049 | 2023-11-15 14:14:50 | group | 1 | 28756 | 5 | 0.436 | 65954.1 |
1048 | 2023-11-09 19:50:39 | group | 2 | 53800 | 74 | 1.640 | 32804.9 |
1047 | 2023-11-09 19:50:36 | group | 3 | 83667 | 787 | 3.906 | 21420.1 |
1046 | 2023-10-27 08:08:44 | group | 1 | 28756 | 5 | 0.466 | 61708.2 |
1045 | 2023-10-21 22:50:56 | group | 1 | 28756 | 5 | 0.546 | 52666.7 |
1044 | 2023-10-21 08:58:42 | group | 1 | 28756 | 5 | 0.486 | 59168.7 |
1043 | 2023-10-19 12:11:43 | group | 1 | 28756 | 5 | 0.466 | 61708.2 |
1042 | 2023-10-13 16:40:24 | group | 1 | 28756 | 5 | 0.483 | 59536.2 |
1041 | 2023-10-08 18:46:56 | group | 1 | 28756 | 5 | 0.436 | 65954.1 |
1040 | 2023-10-06 02:06:50 | group | 1 | 28756 | 5 | 0.486 | 59168.7 |
1039 | 2023-09-25 07:29:41 | group | 1 | 28756 | 5 | 0.466 | 61708.2 |
1038 | 2023-09-14 01:35:14 | group | 1 | 28756 | 5 | 0.486 | 59168.7 |
1037 | 2023-08-17 02:55:49 | group | 1 | 28756 | 5 | 0.423 | 67981.1 |
1036 | 2023-06-19 03:25:19 | group | 1 | 28756 | 5 | 0.470 | 61183.0 |
1035 | 2023-05-16 17:02:19 | group | 1 | 28756 | 5 | 0.436 | 65954.1 |
1034 | 2023-05-04 02:53:23 | group | 1 | 28756 | 5 | 0.420 | 68466.7 |
1033 | 2023-03-29 13:21:09 | group | 1 | 28756 | 5 | 0.420 | 68466.7 |
1032 | 2023-03-09 21:38:21 | group | 1 | 28756 | 5 | 0.423 | 67981.1 |
1031 | 2023-03-03 14:07:57 | group | 1 | 28756 | 5 | 0.483 | 59536.2 |
1030 | 2023-01-19 15:07:30 | group | 1 | 28756 | 5 | 0.423 | 67981.1 |
1029 | 2022-12-30 23:25:03 | group | 1 | 28756 | 5 | 0.423 | 67981.1 |
1028 | 2022-12-05 15:16:33 | group | 1 | 28756 | 5 | 0.436 | 65954.1 |
1027 | 2022-11-11 04:36:15 | group | 1 | 28756 | 5 | 0.516 | 55728.7 |
1026 | 2022-11-08 16:31:48 | group | 1 | 28756 | 5 | 0.500 | 57512.0 |
1025 | 2022-09-19 21:16:51 | group | 1 | 28756 | 5 | 0.420 | 68466.7 |
1024 | 2022-09-18 15:46:08 | group | 1 | 28756 | 5 | 0.470 | 61183.0 |
1023 | 2022-09-18 11:34:24 | group | 1 | 28756 | 5 | 0.420 | 68466.7 |
1022 | 2022-09-12 12:36:10 | group | 1 | 28756 | 5 | 0.500 | 57512.0 |
1021 | 2022-08-23 00:26:15 | group | 1 | 28756 | 5 | 0.423 | 67981.1 |
1020 | 2022-08-14 05:59:07 | group | 1 | 28756 | 5 | 0.483 | 59536.2 |
1019 | 2022-08-07 05:33:09 | group | 1 | 28756 | 5 | 0.423 | 67981.1 |
1018 | 2022-08-05 22:29:06 | group | 1 | 28756 | 5 | 0.420 | 68466.7 |
1017 | 2022-07-22 00:31:35 | group | 1 | 28756 | 5 | 0.466 | 61708.2 |
1016 | 2022-05-23 00:15:26 | group | 1 | 28756 | 5 | 0.486 | 59168.7 |
1015 | 2022-04-28 01:28:27 | group | 1 | 28756 | 5 | 0.766 | 37540.5 |
1014 | 2022-03-27 18:08:01 | group | 1 | 28756 | 5 | 1.013 | 28387.0 |
1013 | 2022-01-23 14:36:23 | group | 1 | 28756 | 5 | 0.546 | 52666.7 |
1012 | 2021-12-10 07:11:34 | group | 1 | 28756 | 5 | 0.483 | 59536.2 |
1011 | 2021-11-14 23:41:59 | group | 1 | 28756 | 5 | 0.486 | 59168.7 |
1010 | 2021-11-08 13:27:19 | group | 1 | 28756 | 5 | 0.423 | 67981.1 |
1009 | 2021-10-26 23:37:00 | group | 1 | 28756 | 5 | 0.516 | 55728.7 |
1008 | 2021-09-28 13:17:05 | group | 1 | 28756 | 5 | 0.500 | 57512.0 |
1007 | 2021-09-25 03:24:49 | group | 1 | 28756 | 5 | 0.470 | 61183.0 |
1006 | 2021-09-11 09:54:31 | group | 1 | 28756 | 5 | 0.486 | 59168.7 |
1005 | 2021-08-30 16:05:27 | group | 1 | 28756 | 5 | 0.483 | 59536.2 |
1004 | 2021-06-30 14:53:29 | group | 1 | 28756 | 5 | 0.500 | 57512.0 |
1003 | 2021-05-29 23:10:21 | group | 1 | 28756 | 5 | 0.500 | 57512.0 |
1002 | 2021-04-20 11:54:45 | group | 1 | 28756 | 5 | 0.440 | 65354.5 |
1001 | 2021-04-03 22:19:17 | group | 1 | 28756 | 5 | 0.483 | 59536.2 |
1000 | 2021-02-27 07:32:21 | group | 1 | 28756 | 5 | 0.470 | 61183.0 |
999 | 2021-02-25 12:05:15 | group | 1 | 28756 | 5 | 0.420 | 68466.7 |
998 | 2021-02-18 02:48:09 | group | 1 | 28756 | 5 | 0.436 | 65954.1 |
997 | 2021-01-25 08:38:20 | group | 1 | 28756 | 5 | 0.486 | 59168.7 |
996 | 2020-11-27 09:52:33 | group | 1 | 28756 | 5 | 0.436 | 65954.1 |
995 | 2020-10-30 12:37:14 | group | 1 | 28756 | 5 | 0.560 | 51350.0 |
994 | 2020-10-23 11:36:29 | group | 1 | 28756 | 5 | 0.500 | 57512.0 |
993 | 2020-10-19 11:32:46 | group | 1 | 28756 | 5 | 0.436 | 65954.1 |
992 | 2020-09-20 12:40:52 | group | 1 | 28756 | 5 | 0.436 | 65954.1 |
991 | 2020-09-09 01:19:42 | group | 1 | 28756 | 5 | 0.440 | 65354.5 |
990 | 2020-08-31 12:43:22 | group | 1 | 28756 | 5 | 0.453 | 63479.0 |
989 | 2020-08-27 19:15:56 | group | 1 | 28756 | 5 | 0.436 | 65954.1 |
988 | 2020-07-22 13:26:57 | group | 1 | 28756 | 5 | 0.453 | 63479.0 |