History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sisal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1234 | 2024-04-21 15:32:58 | sisal | 1 | 28756 | 3 | 2.466 | 11661.0 |
1233 | 2024-04-11 16:36:56 | sisal | 3 | 83667 | 1098 | 4.966 | 16848.0 |
1232 | 2024-04-11 04:18:23 | sisal | 3 | 83667 | 1098 | 3.970 | 21074.8 |
1231 | 2024-04-09 19:13:49 | sisal | 3 | 83667 | 1098 | 4.733 | 17677.4 |
1230 | 2024-04-08 08:37:46 | sisal | 2 | 53800 | 64 | 2.436 | 22085.4 |
1229 | 2024-04-08 08:37:15 | sisal | 3 | 83667 | 1098 | 6.486 | 12899.6 |
1228 | 2024-04-05 23:33:04 | sisal | 2 | 53800 | 64 | 3.873 | 13891.0 |
1227 | 2024-04-05 23:32:58 | sisal | 3 | 83667 | 1098 | 5.500 | 15212.2 |
1226 | 2024-04-05 23:30:25 | sisal | 1 | 28756 | 3 | 0.500 | 57512.0 |
1225 | 2024-03-30 22:22:35 | sisal | 2 | 53800 | 64 | 4.830 | 11138.7 |
1224 | 2024-03-30 22:22:30 | sisal | 1 | 28756 | 3 | 1.140 | 25224.6 |
1223 | 2024-03-29 09:28:38 | sisal | 1 | 28756 | 3 | 0.563 | 51076.4 |
1222 | 2024-03-10 18:04:05 | sisal | 3 | 83667 | 1098 | 9.453 | 8850.8 |
1221 | 2024-03-10 13:31:38 | sisal | 3 | 83667 | 1098 | 4.920 | 17005.5 |
1220 | 2024-03-08 18:53:50 | sisal | 3 | 83667 | 1098 | 8.593 | 9736.6 |
1219 | 2024-03-08 18:53:50 | sisal | 2 | 53800 | 64 | 3.923 | 13714.0 |
1218 | 2024-03-08 18:52:38 | sisal | 1 | 28756 | 3 | 0.466 | 61708.2 |
1217 | 2024-03-08 18:52:30 | sisal | 2 | 53800 | 64 | 1.750 | 30742.9 |
1216 | 2024-03-08 18:51:37 | sisal | 3 | 83667 | 1098 | 3.906 | 21420.1 |
1215 | 2024-03-06 19:49:40 | sisal | 3 | 83667 | 1098 | 15.173 | 5514.2 |
1214 | 2024-03-06 19:49:41 | sisal | 2 | 53800 | 64 | 4.343 | 12387.8 |
1213 | 2024-03-06 19:28:36 | sisal | 1 | 28756 | 3 | 0.483 | 59536.2 |
1212 | 2024-02-28 02:47:33 | sisal | 1 | 28756 | 3 | 0.533 | 53951.2 |
1211 | 2024-02-20 09:06:26 | sisal | 2 | 53800 | 64 | 1.500 | 35866.7 |
1210 | 2024-02-03 19:43:47 | sisal | 1 | 28756 | 3 | 0.516 | 55728.7 |
1209 | 2024-01-30 07:14:26 | sisal | 3 | 83667 | 1098 | 3.813 | 21942.6 |
1208 | 2024-01-29 09:57:32 | sisal | 1 | 28756 | 3 | 0.500 | 57512.0 |
1207 | 2024-01-29 01:17:49 | sisal | 1 | 28756 | 3 | 0.500 | 57512.0 |
1206 | 2024-01-15 09:23:10 | sisal | 2 | 53800 | 64 | 1.610 | 33416.1 |
1205 | 2024-01-07 11:51:22 | sisal | 3 | 83667 | 1098 | 4.236 | 19751.4 |
1204 | 2023-12-31 17:37:25 | sisal | 1 | 28756 | 3 | 0.466 | 61708.2 |
1203 | 2023-12-28 02:27:46 | sisal | 1 | 28756 | 3 | 0.453 | 63479.0 |
1202 | 2023-12-24 19:21:05 | sisal | 3 | 83667 | 1098 | 3.533 | 23681.6 |
1201 | 2023-12-24 19:21:06 | sisal | 2 | 53800 | 64 | 1.576 | 34137.1 |
1200 | 2023-12-13 01:55:41 | sisal | 3 | 83667 | 1098 | 3.393 | 24658.7 |
1199 | 2023-11-19 02:27:05 | sisal | 1 | 28756 | 3 | 0.500 | 57512.0 |
1198 | 2023-11-17 15:33:47 | sisal | 2 | 53800 | 64 | 1.406 | 38264.6 |
1197 | 2023-11-15 18:28:04 | sisal | 3 | 83667 | 1098 | 4.280 | 19548.4 |
1196 | 2023-11-15 18:28:05 | sisal | 2 | 53800 | 64 | 1.780 | 30224.7 |
1195 | 2023-11-12 07:45:27 | sisal | 1 | 28756 | 3 | 0.530 | 54256.6 |
1194 | 2023-11-03 15:16:41 | sisal | 1 | 28756 | 3 | 0.450 | 63902.2 |
1193 | 2023-11-02 05:32:06 | sisal | 1 | 28756 | 3 | 0.516 | 55728.7 |
1192 | 2023-10-23 03:49:47 | sisal | 1 | 28756 | 3 | 0.890 | 32310.1 |
1191 | 2023-10-21 10:52:12 | sisal | 1 | 28756 | 3 | 0.533 | 53951.2 |
1190 | 2023-10-13 01:13:16 | sisal | 1 | 28756 | 3 | 0.436 | 65954.1 |
1189 | 2023-10-05 04:20:56 | sisal | 1 | 28756 | 3 | 0.516 | 55728.7 |
1188 | 2023-10-03 19:05:16 | sisal | 3 | 83667 | 1098 | 4.360 | 19189.7 |
1187 | 2023-10-01 08:00:21 | sisal | 3 | 83667 | 1098 | 7.360 | 11367.8 |
1186 | 2023-09-28 03:53:13 | sisal | 3 | 83667 | 1098 | 4.263 | 19626.3 |
1185 | 2023-09-28 03:53:14 | sisal | 2 | 53800 | 64 | 1.860 | 28924.7 |
1184 | 2023-09-26 08:33:31 | sisal | 1 | 28756 | 3 | 0.500 | 57512.0 |
1183 | 2023-09-22 10:35:07 | sisal | 1 | 28756 | 3 | 0.450 | 63902.2 |
1182 | 2023-08-23 11:33:20 | sisal | 3 | 83667 | 1098 | 3.610 | 23176.5 |
1181 | 2023-08-19 16:19:23 | sisal | 1 | 28756 | 3 | 0.453 | 63479.0 |
1180 | 2023-08-19 01:02:58 | sisal | 1 | 28756 | 3 | 0.453 | 63479.0 |
1179 | 2023-08-18 09:20:54 | sisal | 2 | 53800 | 64 | 1.423 | 37807.4 |
1178 | 2023-05-23 05:45:03 | sisal | 1 | 28756 | 3 | 0.436 | 65954.1 |
1177 | 2023-05-02 11:24:30 | sisal | 2 | 53800 | 64 | 1.453 | 37026.8 |
1176 | 2023-04-20 02:14:30 | sisal | 1 | 28756 | 3 | 0.436 | 65954.1 |
1175 | 2023-03-18 06:14:39 | sisal | 1 | 28756 | 3 | 0.483 | 59536.2 |
1174 | 2023-02-07 18:35:03 | sisal | 2 | 53800 | 64 | 1.390 | 38705.0 |
1173 | 2023-01-05 19:22:07 | sisal | 1 | 28756 | 3 | 0.453 | 63479.0 |
1172 | 2022-12-27 12:13:34 | sisal | 1 | 28756 | 3 | 0.436 | 65954.1 |
1171 | 2022-11-19 15:33:48 | sisal | 2 | 53800 | 64 | 1.376 | 39098.8 |
1170 | 2022-10-01 02:49:40 | sisal | 1 | 28756 | 3 | 0.533 | 53951.2 |
1169 | 2022-10-01 00:32:52 | sisal | 1 | 28756 | 3 | 0.436 | 65954.1 |
1168 | 2022-09-10 14:09:24 | sisal | 1 | 28756 | 3 | 0.440 | 65354.5 |
1167 | 2022-08-31 11:12:47 | sisal | 1 | 28756 | 3 | 0.466 | 61708.2 |
1166 | 2022-08-20 00:49:18 | sisal | 1 | 28756 | 3 | 0.453 | 63479.0 |
1165 | 2022-08-15 14:21:24 | sisal | 1 | 28756 | 3 | 0.890 | 32310.1 |
1164 | 2022-08-14 14:10:58 | sisal | 1 | 28756 | 3 | 0.453 | 63479.0 |
1163 | 2022-08-06 02:58:35 | sisal | 1 | 28756 | 3 | 0.453 | 63479.0 |
1162 | 2022-07-18 09:00:39 | sisal | 1 | 28756 | 3 | 0.516 | 55728.7 |
1161 | 2022-07-02 08:44:47 | sisal | 1 | 28756 | 3 | 0.466 | 61708.2 |
1160 | 2022-06-22 06:58:40 | sisal | 2 | 53800 | 64 | 1.500 | 35866.7 |
1159 | 2022-06-16 19:24:03 | sisal | 1 | 28756 | 3 | 0.453 | 63479.0 |
1158 | 2022-06-15 19:20:50 | sisal | 1 | 28756 | 3 | 0.470 | 61183.0 |
1157 | 2022-06-08 14:03:22 | sisal | 1 | 28756 | 3 | 0.466 | 61708.2 |
1156 | 2022-06-01 17:48:21 | sisal | 1 | 28756 | 3 | 0.453 | 63479.0 |
1155 | 2022-06-01 11:56:24 | sisal | 1 | 28756 | 3 | 0.456 | 63061.4 |
1154 | 2022-05-25 15:18:55 | sisal | 1 | 28756 | 3 | 0.543 | 52957.6 |
1153 | 2022-05-18 15:30:19 | sisal | 1 | 28756 | 3 | 0.486 | 59168.7 |
1152 | 2022-04-24 15:10:01 | sisal | 1 | 28756 | 3 | 0.500 | 57512.0 |
1151 | 2022-04-22 09:38:26 | sisal | 1 | 28756 | 3 | 0.780 | 36866.7 |
1150 | 2022-04-05 15:33:19 | sisal | 1 | 28756 | 3 | 0.733 | 39230.6 |
1149 | 2022-02-01 14:34:26 | sisal | 2 | 53800 | 64 | 3.033 | 17738.2 |
1148 | 2022-01-15 23:58:48 | sisal | 1 | 28756 | 3 | 0.516 | 55728.7 |
1147 | 2021-12-27 06:45:06 | sisal | 1 | 28756 | 3 | 0.466 | 61708.2 |
1146 | 2021-12-18 12:36:09 | sisal | 1 | 28756 | 3 | 0.486 | 59168.7 |
1145 | 2021-12-16 17:09:48 | sisal | 3 | 83667 | 1098 | 3.703 | 22594.4 |
1144 | 2021-11-13 20:44:55 | sisal | 1 | 28756 | 3 | 0.500 | 57512.0 |
1143 | 2021-11-13 17:31:56 | sisal | 1 | 28756 | 3 | 0.500 | 57512.0 |
1142 | 2021-10-31 07:57:43 | sisal | 3 | 83667 | 1098 | 3.733 | 22412.8 |
1141 | 2021-10-01 13:53:32 | sisal | 1 | 28756 | 3 | 0.500 | 57512.0 |
1140 | 2021-09-14 10:55:32 | sisal | 3 | 83667 | 1098 | 3.403 | 24586.2 |
1139 | 2021-09-12 08:00:14 | sisal | 1 | 28756 | 3 | 0.580 | 49579.3 |
1138 | 2021-09-01 12:34:53 | sisal | 1 | 28756 | 3 | 0.453 | 63479.0 |
1137 | 2021-08-26 05:41:38 | sisal | 3 | 83667 | 1098 | 3.500 | 23904.9 |
1136 | 2021-07-28 06:48:01 | sisal | 3 | 83667 | 1098 | 4.046 | 20678.9 |
1135 | 2021-07-20 10:26:22 | sisal | 1 | 28756 | 3 | 0.453 | 63479.0 |