History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roles"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1172 | 2024-04-03 03:13:27 | roles | 1 | 28756 | 29 | 1.266 | 22714.1 |
1171 | 2024-03-31 02:55:16 | roles | 1 | 28756 | 29 | 0.500 | 57512.0 |
1170 | 2024-03-28 18:26:36 | roles | 1 | 28756 | 29 | 1.546 | 18600.3 |
1169 | 2024-03-28 10:58:48 | roles | 1 | 28756 | 29 | 0.500 | 57512.0 |
1168 | 2024-03-27 22:11:59 | roles | 1 | 28756 | 29 | 0.546 | 52666.7 |
1167 | 2024-03-26 03:52:48 | roles | 1 | 28756 | 29 | 0.576 | 49923.6 |
1166 | 2024-03-03 21:49:44 | roles | 1 | 28756 | 29 | 0.606 | 47452.1 |
1165 | 2024-02-27 09:35:41 | roles | 2 | 53800 | 437 | 1.703 | 31591.3 |
1164 | 2024-02-26 22:49:33 | roles | 2 | 53800 | 437 | 2.360 | 22796.6 |
1163 | 2024-02-26 19:34:28 | roles | 1 | 28756 | 29 | 0.576 | 49923.6 |
1162 | 2024-02-04 21:43:02 | roles | 1 | 28756 | 29 | 0.546 | 52666.7 |
1161 | 2024-02-03 23:57:37 | roles | 1 | 28756 | 29 | 0.546 | 52666.7 |
1160 | 2024-01-27 18:05:33 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1159 | 2024-01-27 01:08:21 | roles | 1 | 28756 | 29 | 0.563 | 51076.4 |
1158 | 2023-12-21 23:36:03 | roles | 2 | 53800 | 437 | 1.466 | 36698.5 |
1157 | 2023-12-17 05:43:41 | roles | 1 | 28756 | 29 | 0.470 | 61183.0 |
1156 | 2023-12-08 14:06:45 | roles | 2 | 53800 | 437 | 3.296 | 16322.8 |
1155 | 2023-12-07 23:10:22 | roles | 1 | 28756 | 29 | 0.516 | 55728.7 |
1154 | 2023-12-07 23:10:21 | roles | 1 | 28756 | 29 | 0.513 | 56054.6 |
1153 | 2023-12-04 22:13:09 | roles | 2 | 53800 | 437 | 1.423 | 37807.4 |
1152 | 2023-11-26 23:44:35 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1151 | 2023-11-14 02:54:03 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1150 | 2023-11-14 00:57:27 | roles | 1 | 28756 | 29 | 0.516 | 55728.7 |
1149 | 2023-11-10 22:48:25 | roles | 2 | 53800 | 437 | 1.610 | 33416.1 |
1148 | 2023-10-29 17:21:35 | roles | 1 | 28756 | 29 | 0.530 | 54256.6 |
1147 | 2023-10-21 08:59:32 | roles | 1 | 28756 | 29 | 0.513 | 56054.6 |
1146 | 2023-10-19 07:10:44 | roles | 1 | 28756 | 29 | 1.080 | 26625.9 |
1145 | 2023-10-17 18:40:26 | roles | 2 | 53800 | 437 | 3.313 | 16239.1 |
1144 | 2023-10-11 00:49:10 | roles | 1 | 28756 | 29 | 0.500 | 57512.0 |
1143 | 2023-10-07 23:02:27 | roles | 1 | 28756 | 29 | 0.516 | 55728.7 |
1142 | 2023-09-25 06:10:04 | roles | 1 | 28756 | 29 | 0.486 | 59168.7 |
1141 | 2023-09-12 19:51:49 | roles | 1 | 28756 | 29 | 0.513 | 56054.6 |
1140 | 2023-07-25 09:55:27 | roles | 1 | 28756 | 29 | 0.500 | 57512.0 |
1139 | 2023-06-24 20:33:03 | roles | 1 | 28756 | 29 | 0.436 | 65954.1 |
1138 | 2023-04-13 13:53:01 | roles | 1 | 28756 | 29 | 0.436 | 65954.1 |
1137 | 2023-04-09 23:23:01 | roles | 1 | 28756 | 29 | 0.500 | 57512.0 |
1136 | 2023-04-05 20:10:35 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1135 | 2023-01-21 00:19:01 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1134 | 2023-01-01 00:51:55 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1133 | 2022-11-16 20:39:05 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1132 | 2022-09-13 22:28:04 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1131 | 2022-08-06 21:12:40 | roles | 1 | 28756 | 29 | 0.560 | 51350.0 |
1130 | 2022-07-08 03:37:07 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1129 | 2022-06-15 02:16:13 | roles | 1 | 28756 | 29 | 0.436 | 65954.1 |
1128 | 2022-06-09 07:24:21 | roles | 1 | 28756 | 29 | 0.470 | 61183.0 |
1127 | 2022-05-22 02:18:01 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1126 | 2022-05-18 16:39:21 | roles | 1 | 28756 | 29 | 0.530 | 54256.6 |
1125 | 2022-05-02 07:04:57 | roles | 1 | 28756 | 29 | 0.500 | 57512.0 |
1124 | 2022-05-01 12:40:24 | roles | 1 | 28756 | 29 | 0.513 | 56054.6 |
1123 | 2022-04-30 09:53:51 | roles | 1 | 28756 | 29 | 0.550 | 52283.6 |
1122 | 2022-04-29 15:16:43 | roles | 1 | 28756 | 29 | 0.546 | 52666.7 |
1121 | 2022-04-29 01:28:14 | roles | 1 | 28756 | 29 | 0.846 | 33990.5 |
1120 | 2022-04-28 17:08:47 | roles | 1 | 28756 | 29 | 0.686 | 41918.4 |
1119 | 2022-04-27 17:10:48 | roles | 1 | 28756 | 29 | 0.673 | 42728.1 |
1118 | 2022-04-12 18:42:07 | roles | 1 | 28756 | 29 | 0.750 | 38341.3 |
1117 | 2022-04-10 01:02:18 | roles | 1 | 28756 | 29 | 0.470 | 61183.0 |
1116 | 2022-03-25 13:25:18 | roles | 1 | 28756 | 29 | 0.656 | 43835.4 |
1115 | 2022-03-24 16:55:49 | roles | 1 | 28756 | 29 | 1.046 | 27491.4 |
1114 | 2022-03-23 17:02:56 | roles | 1 | 28756 | 29 | 0.703 | 40904.7 |
1113 | 2022-03-23 04:28:26 | roles | 1 | 28756 | 29 | 0.546 | 52666.7 |
1112 | 2022-03-22 11:23:13 | roles | 1 | 28756 | 29 | 0.703 | 40904.7 |
1111 | 2022-03-22 10:14:03 | roles | 1 | 28756 | 29 | 0.580 | 49579.3 |
1110 | 2022-03-19 20:31:22 | roles | 1 | 28756 | 29 | 0.516 | 55728.7 |
1109 | 2022-03-19 02:09:28 | roles | 1 | 28756 | 29 | 0.470 | 61183.0 |
1108 | 2022-03-18 07:12:53 | roles | 1 | 28756 | 29 | 0.516 | 55728.7 |
1107 | 2022-03-17 13:27:55 | roles | 1 | 28756 | 29 | 0.576 | 49923.6 |
1106 | 2022-03-16 13:41:16 | roles | 1 | 28756 | 29 | 0.500 | 57512.0 |
1105 | 2022-03-06 09:19:18 | roles | 1 | 28756 | 29 | 0.450 | 63902.2 |
1104 | 2022-02-07 01:31:39 | roles | 1 | 28756 | 29 | 0.436 | 65954.1 |
1103 | 2022-01-23 11:40:49 | roles | 1 | 28756 | 29 | 0.440 | 65354.5 |
1102 | 2022-01-22 14:33:54 | roles | 1 | 28756 | 29 | 0.610 | 47141.0 |
1101 | 2022-01-09 18:44:07 | roles | 1 | 28756 | 29 | 0.546 | 52666.7 |
1100 | 2022-01-07 20:11:49 | roles | 1 | 28756 | 29 | 0.470 | 61183.0 |
1099 | 2022-01-06 20:46:53 | roles | 1 | 28756 | 29 | 0.640 | 44931.3 |
1098 | 2021-12-23 16:22:40 | roles | 1 | 28756 | 29 | 0.503 | 57169.0 |
1097 | 2021-12-22 18:05:31 | roles | 1 | 28756 | 29 | 0.470 | 61183.0 |
1096 | 2021-12-21 19:35:43 | roles | 1 | 28756 | 29 | 0.516 | 55728.7 |
1095 | 2021-12-20 18:40:11 | roles | 1 | 28756 | 29 | 0.516 | 55728.7 |
1094 | 2021-12-19 00:43:33 | roles | 1 | 28756 | 29 | 0.530 | 54256.6 |
1093 | 2021-11-09 00:24:27 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1092 | 2021-11-04 11:04:26 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1091 | 2021-11-02 18:35:08 | roles | 1 | 28756 | 29 | 0.483 | 59536.2 |
1090 | 2021-10-30 15:42:57 | roles | 1 | 28756 | 29 | 0.530 | 54256.6 |
1089 | 2021-10-29 14:22:39 | roles | 1 | 28756 | 29 | 0.500 | 57512.0 |
1088 | 2021-10-27 22:50:32 | roles | 1 | 28756 | 29 | 0.470 | 61183.0 |
1087 | 2021-10-26 02:16:00 | roles | 1 | 28756 | 29 | 0.450 | 63902.2 |
1086 | 2021-09-16 07:44:10 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1085 | 2021-09-14 04:23:32 | roles | 1 | 28756 | 29 | 0.436 | 65954.1 |
1084 | 2021-09-08 22:40:24 | roles | 1 | 28756 | 29 | 0.656 | 43835.4 |
1083 | 2021-08-30 23:52:16 | roles | 1 | 28756 | 29 | 0.516 | 55728.7 |
1082 | 2021-08-27 14:10:01 | roles | 1 | 28756 | 29 | 0.436 | 65954.1 |
1081 | 2021-08-12 17:17:49 | roles | 1 | 28756 | 29 | 0.533 | 53951.2 |
1080 | 2021-08-02 23:24:24 | roles | 1 | 28756 | 29 | 0.450 | 63902.2 |
1079 | 2021-04-25 02:13:37 | roles | 1 | 28756 | 29 | 0.530 | 54256.6 |
1078 | 2021-01-24 03:29:35 | roles | 1 | 28756 | 29 | 0.453 | 63479.0 |
1077 | 2021-01-12 20:10:47 | roles | 1 | 28756 | 29 | 0.516 | 55728.7 |
1076 | 2020-12-22 05:02:19 | roles | 2 | 53800 | 437 | 1.483 | 36277.8 |
1075 | 2020-11-11 09:52:34 | roles | 2 | 53800 | 437 | 1.533 | 35094.6 |
1074 | 2020-10-28 12:48:03 | roles | 1 | 28756 | 29 | 0.530 | 54256.6 |
1073 | 2020-10-23 12:17:34 | roles | 1 | 28756 | 29 | 0.483 | 59536.2 |