History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ice"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1349 | 2024-04-20 18:35:59 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1348 | 2024-04-20 18:35:45 | ice | 2 | 14084 | 337 | 0.483 | 29159.4 |
1347 | 2024-04-20 18:35:37 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1346 | 2024-04-20 04:38:01 | ice | 1 | 5146 | 18 | 0.190 | 27084.2 |
1345 | 2024-04-18 23:48:58 | ice | 1 | 5146 | 18 | 0.173 | 29745.7 |
1344 | 2024-04-18 21:20:41 | ice | 1 | 5146 | 18 | 0.140 | 36757.1 |
1343 | 2024-04-17 09:54:15 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1342 | 2024-04-02 17:16:09 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1341 | 2024-04-01 16:09:45 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1340 | 2024-03-31 16:19:09 | ice | 2 | 14084 | 337 | 0.750 | 18778.7 |
1339 | 2024-03-31 01:34:09 | ice | 2 | 14084 | 337 | 1.390 | 10132.4 |
1338 | 2024-03-30 23:12:10 | ice | 1 | 5146 | 18 | 0.173 | 29745.7 |
1337 | 2024-03-27 16:42:00 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1336 | 2024-03-26 17:17:23 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1335 | 2024-03-20 02:24:17 | ice | 1 | 5146 | 18 | 0.186 | 27666.7 |
1334 | 2024-03-05 10:30:26 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1333 | 2024-03-02 16:25:28 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1332 | 2024-03-02 13:10:26 | ice | 1 | 5146 | 18 | 0.313 | 16440.9 |
1331 | 2024-02-29 17:55:26 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1330 | 2024-02-25 16:24:13 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1329 | 2024-02-25 15:36:43 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1328 | 2024-02-18 20:23:20 | ice | 1 | 5146 | 18 | 0.186 | 27666.7 |
1327 | 2024-02-01 09:51:15 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1326 | 2024-01-28 12:18:47 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1325 | 2024-01-25 17:27:33 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1324 | 2024-01-25 07:13:47 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1323 | 2024-01-16 23:07:39 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1322 | 2024-01-16 14:25:39 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1321 | 2023-12-28 17:02:03 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1320 | 2023-11-12 00:03:15 | ice | 2 | 14084 | 337 | 0.390 | 36112.8 |
1319 | 2023-11-11 12:14:08 | ice | 2 | 14084 | 337 | 0.376 | 37457.4 |
1318 | 2023-11-11 08:28:33 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1317 | 2023-11-10 03:59:22 | ice | 2 | 14084 | 337 | 0.373 | 37758.7 |
1316 | 2023-11-09 02:01:28 | ice | 2 | 14084 | 337 | 0.393 | 35837.2 |
1315 | 2023-11-08 11:59:52 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1314 | 2023-11-07 23:07:58 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1313 | 2023-11-07 20:36:24 | ice | 2 | 14084 | 337 | 0.410 | 34351.2 |
1312 | 2023-11-07 07:32:32 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1311 | 2023-11-06 15:28:04 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1310 | 2023-10-27 03:57:47 | ice | 2 | 14084 | 337 | 0.436 | 32302.8 |
1309 | 2023-10-25 20:04:46 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1308 | 2023-10-24 00:05:59 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1307 | 2023-10-19 15:37:45 | ice | 2 | 14084 | 337 | 0.390 | 36112.8 |
1306 | 2023-10-19 14:10:54 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1305 | 2023-10-16 19:33:18 | ice | 2 | 14084 | 337 | 0.796 | 17693.5 |
1304 | 2023-10-16 18:10:33 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1303 | 2023-10-13 23:50:21 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1302 | 2023-10-11 04:47:01 | ice | 2 | 14084 | 337 | 0.343 | 41061.2 |
1301 | 2023-10-10 09:59:13 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1300 | 2023-10-04 06:36:53 | ice | 2 | 14084 | 337 | 0.343 | 41061.2 |
1299 | 2023-10-03 08:48:28 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1298 | 2023-09-25 13:53:35 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1297 | 2023-09-23 15:30:57 | ice | 2 | 14084 | 337 | 0.343 | 41061.2 |
1296 | 2023-09-18 23:10:20 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1295 | 2023-09-12 08:13:14 | ice | 2 | 14084 | 337 | 0.376 | 37457.4 |
1294 | 2023-09-10 12:47:17 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1293 | 2023-08-31 08:40:34 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1292 | 2023-07-23 10:10:34 | ice | 1 | 5146 | 18 | 0.153 | 33634.0 |
1291 | 2023-07-16 19:46:26 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1290 | 2023-07-08 05:33:58 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1289 | 2023-06-30 02:28:08 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1288 | 2023-06-03 15:46:37 | ice | 1 | 5146 | 18 | 0.063 | 81682.5 |
1287 | 2023-03-31 12:26:30 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1286 | 2023-03-28 00:32:51 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1285 | 2023-03-25 23:27:09 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1284 | 2023-03-12 12:06:37 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1283 | 2023-01-17 08:35:14 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1282 | 2023-01-09 21:55:27 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1281 | 2022-12-22 20:25:17 | ice | 1 | 5146 | 18 | 0.063 | 81682.5 |
1280 | 2022-11-24 18:51:10 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1279 | 2022-10-13 16:46:53 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1278 | 2022-09-19 17:14:13 | ice | 1 | 5146 | 18 | 0.090 | 57177.8 |
1277 | 2022-09-18 12:53:36 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1276 | 2022-09-12 04:41:00 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1275 | 2022-09-04 06:53:39 | ice | 2 | 14084 | 337 | 0.326 | 43202.5 |
1274 | 2022-09-03 17:34:42 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1273 | 2022-09-02 09:33:03 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1272 | 2022-09-01 21:57:29 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1271 | 2022-08-31 12:08:59 | ice | 1 | 5146 | 18 | 0.170 | 30270.6 |
1270 | 2022-08-29 08:15:22 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1269 | 2022-08-23 18:35:06 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1268 | 2022-08-22 23:34:45 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1267 | 2022-08-17 13:37:44 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1266 | 2022-08-15 00:05:09 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1265 | 2022-08-09 06:45:57 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1264 | 2022-08-06 19:14:16 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1263 | 2022-07-30 00:14:28 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1262 | 2022-07-17 19:03:17 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1261 | 2022-07-10 04:00:04 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1260 | 2022-07-03 07:01:48 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1259 | 2022-07-02 15:44:31 | ice | 1 | 5146 | 18 | 0.063 | 81682.5 |
1258 | 2022-06-30 22:12:03 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1257 | 2022-06-29 12:17:18 | ice | 2 | 14084 | 337 | 0.330 | 42678.8 |
1256 | 2022-06-25 18:09:26 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |
1255 | 2022-06-25 13:01:53 | ice | 2 | 14084 | 337 | 0.330 | 42678.8 |
1254 | 2022-06-16 07:03:50 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1253 | 2022-06-08 18:23:20 | ice | 1 | 5146 | 18 | 0.080 | 64325.0 |
1252 | 2022-06-03 13:02:26 | ice | 1 | 5146 | 18 | 0.156 | 32987.2 |
1251 | 2022-06-01 20:35:12 | ice | 1 | 5146 | 18 | 0.093 | 55333.3 |
1250 | 2022-05-30 11:19:47 | ice | 1 | 5146 | 18 | 0.076 | 67710.5 |