History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roster"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1307 | 2024-04-17 06:48:15 | roster | 1 | 48755 | 17 | 0.906 | 53813.5 |
1306 | 2024-04-01 22:57:31 | roster | 1 | 48755 | 17 | 0.970 | 50262.9 |
1305 | 2024-03-18 21:46:15 | roster | 2 | 82551 | 220 | 4.326 | 19082.5 |
1304 | 2024-03-18 21:46:07 | roster | 1 | 48755 | 17 | 2.873 | 16970.1 |
1303 | 2024-03-18 21:45:59 | roster | 2 | 82551 | 220 | 2.923 | 28241.9 |
1302 | 2024-03-18 13:25:20 | roster | 2 | 82551 | 220 | 12.436 | 6638.1 |
1301 | 2024-02-29 22:47:32 | roster | 1 | 48755 | 17 | 0.860 | 56691.9 |
1300 | 2024-02-29 00:23:34 | roster | 1 | 48755 | 17 | 1.716 | 28412.0 |
1299 | 2024-02-28 05:52:53 | roster | 1 | 48755 | 17 | 1.670 | 29194.6 |
1298 | 2024-02-27 15:01:33 | roster | 1 | 48755 | 17 | 0.856 | 56956.8 |
1297 | 2024-02-26 15:59:26 | roster | 1 | 48755 | 17 | 1.076 | 45311.3 |
1296 | 2024-02-25 06:59:41 | roster | 1 | 48755 | 17 | 1.060 | 45995.3 |
1295 | 2024-02-24 03:48:09 | roster | 1 | 48755 | 17 | 0.860 | 56691.9 |
1294 | 2024-02-23 10:34:40 | roster | 1 | 48755 | 17 | 1.733 | 28133.3 |
1293 | 2024-02-08 17:41:41 | roster | 1 | 48755 | 17 | 0.766 | 63648.8 |
1292 | 2024-02-03 09:12:55 | roster | 1 | 48755 | 17 | 0.750 | 65006.7 |
1291 | 2024-02-02 16:45:42 | roster | 1 | 48755 | 17 | 0.876 | 55656.4 |
1290 | 2024-02-01 16:15:45 | roster | 1 | 48755 | 17 | 0.750 | 65006.7 |
1289 | 2024-01-31 22:34:53 | roster | 1 | 48755 | 17 | 0.876 | 55656.4 |
1288 | 2024-01-31 04:53:58 | roster | 2 | 82551 | 220 | 2.953 | 27955.0 |
1287 | 2024-01-30 16:27:37 | roster | 1 | 48755 | 17 | 0.923 | 52822.3 |
1286 | 2024-01-29 21:36:46 | roster | 1 | 48755 | 17 | 0.906 | 53813.5 |
1285 | 2024-01-29 18:23:37 | roster | 1 | 48755 | 17 | 0.873 | 55847.7 |
1284 | 2024-01-28 15:11:56 | roster | 1 | 48755 | 17 | 0.876 | 55656.4 |
1283 | 2024-01-27 04:38:19 | roster | 1 | 48755 | 17 | 0.936 | 52088.7 |
1282 | 2024-01-26 13:33:43 | roster | 1 | 48755 | 17 | 0.923 | 52822.3 |
1281 | 2024-01-26 01:43:26 | roster | 1 | 48755 | 17 | 0.876 | 55656.4 |
1280 | 2024-01-24 09:27:44 | roster | 1 | 48755 | 17 | 0.826 | 59025.4 |
1279 | 2024-01-23 07:06:57 | roster | 1 | 48755 | 17 | 0.953 | 51159.5 |
1278 | 2024-01-14 06:44:36 | roster | 2 | 82551 | 220 | 2.220 | 37185.1 |
1277 | 2024-01-10 14:50:21 | roster | 2 | 82551 | 220 | 2.220 | 37185.1 |
1276 | 2024-01-01 23:14:50 | roster | 1 | 48755 | 17 | 0.843 | 57835.1 |
1275 | 2023-12-31 18:10:44 | roster | 1 | 48755 | 17 | 0.766 | 63648.8 |
1274 | 2023-12-29 16:03:29 | roster | 1 | 48755 | 17 | 0.750 | 65006.7 |
1273 | 2023-12-28 03:07:25 | roster | 1 | 48755 | 17 | 1.953 | 24964.2 |
1272 | 2023-12-27 08:05:12 | roster | 1 | 48755 | 17 | 0.796 | 61250.0 |
1271 | 2023-12-25 23:47:40 | roster | 1 | 48755 | 17 | 0.873 | 55847.7 |
1270 | 2023-12-25 07:34:06 | roster | 1 | 48755 | 17 | 0.763 | 63899.1 |
1269 | 2023-12-25 02:58:57 | roster | 1 | 48755 | 17 | 0.970 | 50262.9 |
1268 | 2023-12-23 09:50:58 | roster | 1 | 48755 | 17 | 0.830 | 58741.0 |
1267 | 2023-12-21 16:05:29 | roster | 1 | 48755 | 17 | 0.766 | 63648.8 |
1266 | 2023-12-20 06:03:14 | roster | 1 | 48755 | 17 | 0.796 | 61250.0 |
1265 | 2023-12-20 01:46:47 | roster | 1 | 48755 | 17 | 0.826 | 59025.4 |
1264 | 2023-12-16 09:26:51 | roster | 2 | 82551 | 220 | 2.220 | 37185.1 |
1263 | 2023-12-16 05:27:46 | roster | 1 | 48755 | 17 | 0.766 | 63648.8 |
1262 | 2023-12-13 00:10:35 | roster | 2 | 82551 | 220 | 2.780 | 29694.6 |
1261 | 2023-12-11 23:12:58 | roster | 1 | 48755 | 17 | 0.860 | 56691.9 |
1260 | 2023-11-30 04:07:14 | roster | 1 | 48755 | 17 | 0.763 | 63899.1 |
1259 | 2023-11-18 11:26:02 | roster | 1 | 48755 | 17 | 0.766 | 63648.8 |
1258 | 2023-11-15 13:22:31 | roster | 1 | 48755 | 17 | 0.860 | 56691.9 |
1257 | 2023-11-12 22:43:11 | roster | 1 | 48755 | 17 | 0.906 | 53813.5 |
1256 | 2023-11-06 12:19:00 | roster | 1 | 48755 | 17 | 0.843 | 57835.1 |
1255 | 2023-11-05 12:49:41 | roster | 1 | 48755 | 17 | 0.826 | 59025.4 |
1254 | 2023-10-23 05:08:50 | roster | 2 | 82551 | 220 | 2.720 | 30349.6 |
1253 | 2023-10-22 19:27:26 | roster | 1 | 48755 | 17 | 0.830 | 58741.0 |
1252 | 2023-10-19 15:19:56 | roster | 2 | 82551 | 220 | 2.280 | 36206.6 |
1251 | 2023-10-18 08:19:23 | roster | 2 | 82551 | 220 | 3.093 | 26689.6 |
1250 | 2023-10-18 08:01:38 | roster | 1 | 48755 | 17 | 0.893 | 54596.9 |
1249 | 2023-10-17 08:16:53 | roster | 2 | 82551 | 220 | 2.656 | 31080.9 |
1248 | 2023-10-14 15:43:15 | roster | 2 | 82551 | 220 | 2.673 | 30883.3 |
1247 | 2023-10-12 22:59:47 | roster | 1 | 48755 | 17 | 0.830 | 58741.0 |
1246 | 2023-10-08 18:51:11 | roster | 1 | 48755 | 17 | 0.890 | 54780.9 |
1245 | 2023-10-08 11:44:39 | roster | 2 | 82551 | 220 | 2.250 | 36689.3 |
1244 | 2023-10-06 00:59:15 | roster | 2 | 82551 | 220 | 2.170 | 38041.9 |
1243 | 2023-09-27 00:06:34 | roster | 2 | 82551 | 220 | 2.576 | 32046.2 |
1242 | 2023-09-25 18:44:34 | roster | 2 | 82551 | 220 | 2.673 | 30883.3 |
1241 | 2023-09-25 17:10:58 | roster | 1 | 48755 | 17 | 0.843 | 57835.1 |
1240 | 2023-09-25 05:34:06 | roster | 2 | 82551 | 220 | 2.516 | 32810.4 |
1239 | 2023-09-23 23:46:39 | roster | 1 | 48755 | 17 | 0.890 | 54780.9 |
1238 | 2023-09-18 15:28:26 | roster | 2 | 82551 | 220 | 2.156 | 38289.0 |
1237 | 2023-09-17 05:19:26 | roster | 2 | 82551 | 220 | 5.580 | 14794.1 |
1236 | 2023-09-16 23:08:20 | roster | 2 | 82551 | 220 | 2.580 | 31996.5 |
1235 | 2023-09-14 17:14:40 | roster | 1 | 48755 | 17 | 0.750 | 65006.7 |
1234 | 2023-09-14 04:00:19 | roster | 2 | 82551 | 220 | 2.703 | 30540.5 |
1233 | 2023-09-13 04:21:55 | roster | 2 | 82551 | 220 | 2.296 | 35954.3 |
1232 | 2023-09-11 11:02:25 | roster | 2 | 82551 | 220 | 2.686 | 30733.8 |
1231 | 2023-09-11 03:07:13 | roster | 2 | 82551 | 220 | 2.623 | 31472.0 |
1230 | 2023-09-09 13:17:38 | roster | 2 | 82551 | 220 | 2.563 | 32208.7 |
1229 | 2023-09-07 23:58:05 | roster | 2 | 82551 | 220 | 2.236 | 36919.1 |
1228 | 2023-09-06 00:25:50 | roster | 2 | 82551 | 220 | 2.530 | 32628.9 |
1227 | 2023-09-05 08:58:24 | roster | 1 | 48755 | 17 | 0.856 | 56956.8 |
1226 | 2023-09-03 09:42:13 | roster | 2 | 82551 | 220 | 2.500 | 33020.4 |
1225 | 2023-09-02 02:10:13 | roster | 2 | 82551 | 220 | 2.826 | 29211.3 |
1224 | 2023-08-31 03:25:01 | roster | 2 | 82551 | 220 | 2.220 | 37185.1 |
1223 | 2023-08-29 02:10:57 | roster | 2 | 82551 | 220 | 2.393 | 34496.9 |
1222 | 2023-08-27 07:17:37 | roster | 2 | 82551 | 220 | 2.203 | 37472.1 |
1221 | 2023-08-26 10:17:09 | roster | 2 | 82551 | 220 | 2.263 | 36478.6 |
1220 | 2023-08-25 09:32:31 | roster | 2 | 82551 | 220 | 2.250 | 36689.3 |
1219 | 2023-08-24 11:37:59 | roster | 2 | 82551 | 220 | 2.250 | 36689.3 |
1218 | 2023-08-24 09:13:39 | roster | 1 | 48755 | 17 | 0.843 | 57835.1 |
1217 | 2023-08-22 14:15:05 | roster | 1 | 48755 | 17 | 0.843 | 57835.1 |
1216 | 2023-08-22 09:16:19 | roster | 2 | 82551 | 220 | 2.330 | 35429.6 |
1215 | 2023-08-21 23:22:11 | roster | 1 | 48755 | 17 | 0.796 | 61250.0 |
1214 | 2023-08-21 12:16:40 | roster | 2 | 82551 | 220 | 2.420 | 34112.0 |
1213 | 2023-08-20 13:03:30 | roster | 2 | 82551 | 220 | 2.513 | 32849.6 |
1212 | 2023-08-19 14:43:22 | roster | 2 | 82551 | 220 | 2.220 | 37185.1 |
1211 | 2023-08-18 08:49:44 | roster | 2 | 82551 | 220 | 2.533 | 32590.2 |
1210 | 2023-08-17 03:30:24 | roster | 1 | 48755 | 17 | 0.876 | 55656.4 |
1209 | 2023-08-16 16:53:51 | roster | 2 | 82551 | 220 | 2.500 | 33020.4 |
1208 | 2023-08-15 15:51:21 | roster | 1 | 48755 | 17 | 0.766 | 63648.8 |