History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clupeids"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 380 | 2024-05-08 05:08:15 | clupeids | 4 | 161609 | 683 | 26.906 | 6006.4 |
| 379 | 2024-05-07 14:39:00 | clupeids | 1 | 82945 | 3 | 1.736 | 47779.4 |
| 378 | 2024-05-05 20:02:36 | clupeids | 4 | 161609 | 683 | 16.610 | 9729.6 |
| 377 | 2024-05-05 19:22:57 | clupeids | 4 | 161609 | 683 | 16.470 | 9812.3 |
| 376 | 2024-05-05 18:52:08 | clupeids | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 375 | 2024-05-05 18:49:48 | clupeids | 3 | 146162 | 39 | 7.750 | 18859.6 |
| 374 | 2024-05-05 18:46:28 | clupeids | 1 | 82945 | 3 | 2.076 | 39954.2 |
| 373 | 2024-05-05 18:46:08 | clupeids | 4 | 161609 | 683 | 13.190 | 12252.4 |
| 372 | 2024-05-05 18:46:11 | clupeids | 2 | 121059 | 5 | 3.876 | 31233.0 |
| 371 | 2024-05-02 01:31:09 | clupeids | 1 | 82945 | 3 | 4.813 | 17233.5 |
| 370 | 2024-04-29 21:45:23 | clupeids | 3 | 146162 | 39 | 7.233 | 20207.7 |
| 369 | 2024-04-29 21:45:16 | clupeids | 2 | 121059 | 5 | 5.296 | 22858.6 |
| 368 | 2024-04-25 19:22:53 | clupeids | 2 | 121059 | 5 | 4.830 | 25064.0 |
| 367 | 2024-04-25 19:22:20 | clupeids | 1 | 82945 | 3 | 1.780 | 46598.3 |
| 366 | 2024-04-11 11:16:28 | clupeids | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 365 | 2024-04-11 11:16:00 | clupeids | 3 | 146162 | 39 | 9.203 | 15882.0 |
| 364 | 2024-04-11 11:16:01 | clupeids | 2 | 121059 | 5 | 3.936 | 30756.9 |
| 363 | 2024-04-10 15:00:39 | clupeids | 1 | 82945 | 3 | 5.203 | 15941.8 |
| 362 | 2024-04-09 18:17:15 | clupeids | 4 | 161609 | 683 | 16.063 | 10060.9 |
| 361 | 2024-04-07 19:05:16 | clupeids | 4 | 161609 | 683 | 31.456 | 5137.6 |
| 360 | 2024-04-07 19:05:26 | clupeids | 2 | 121059 | 5 | 8.550 | 14158.9 |
| 359 | 2024-04-07 19:05:14 | clupeids | 3 | 146162 | 39 | 13.953 | 10475.3 |
| 358 | 2024-04-05 00:39:37 | clupeids | 4 | 161609 | 683 | 33.330 | 4848.8 |
| 357 | 2024-04-05 00:39:39 | clupeids | 3 | 146162 | 39 | 19.080 | 7660.5 |
| 356 | 2024-04-05 00:39:32 | clupeids | 4 | 161609 | 683 | 22.220 | 7273.1 |
| 355 | 2024-04-05 00:39:35 | clupeids | 3 | 146162 | 39 | 16.360 | 8934.1 |
| 354 | 2024-04-05 00:39:47 | clupeids | 1 | 82945 | 3 | 3.360 | 24686.0 |
| 353 | 2024-04-05 00:39:40 | clupeids | 1 | 82945 | 3 | 3.376 | 24569.0 |
| 352 | 2024-04-05 00:39:38 | clupeids | 2 | 121059 | 5 | 5.140 | 23552.3 |
| 351 | 2024-04-05 00:39:34 | clupeids | 2 | 121059 | 5 | 4.483 | 27004.0 |
| 350 | 2024-04-05 00:39:31 | clupeids | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 349 | 2024-03-24 17:05:58 | clupeids | 1 | 82945 | 3 | 3.016 | 27501.7 |
| 348 | 2024-03-12 02:51:22 | clupeids | 3 | 146162 | 39 | 23.250 | 6286.5 |
| 347 | 2024-03-12 02:51:17 | clupeids | 2 | 121059 | 5 | 4.393 | 27557.3 |
| 346 | 2024-03-12 02:51:03 | clupeids | 1 | 82945 | 3 | 3.533 | 23477.2 |
| 345 | 2024-03-11 03:34:45 | clupeids | 3 | 146162 | 39 | 7.186 | 20339.8 |
| 344 | 2024-03-11 03:34:46 | clupeids | 2 | 121059 | 5 | 3.780 | 32026.2 |
| 343 | 2024-03-11 03:34:40 | clupeids | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 342 | 2024-03-08 02:43:24 | clupeids | 4 | 161609 | 683 | 13.796 | 11714.2 |
| 341 | 2024-03-05 20:11:33 | clupeids | 3 | 146162 | 39 | 16.580 | 8815.6 |
| 340 | 2024-03-05 13:16:02 | clupeids | 2 | 121059 | 5 | 3.906 | 30993.1 |
| 339 | 2024-03-05 13:06:57 | clupeids | 3 | 146162 | 39 | 7.783 | 18779.6 |
| 338 | 2024-03-05 02:47:03 | clupeids | 4 | 161609 | 683 | 28.750 | 5621.2 |
| 337 | 2024-03-05 00:19:58 | clupeids | 1 | 82945 | 3 | 3.610 | 22976.5 |
| 336 | 2024-03-04 11:26:14 | clupeids | 3 | 146162 | 39 | 12.703 | 11506.1 |
| 335 | 2024-03-04 07:44:36 | clupeids | 4 | 161609 | 683 | 20.783 | 7776.0 |
| 334 | 2024-03-03 20:37:21 | clupeids | 4 | 161609 | 683 | 19.533 | 8273.6 |
| 333 | 2024-03-03 20:37:22 | clupeids | 3 | 146162 | 39 | 15.126 | 9663.0 |
| 332 | 2024-03-03 20:37:33 | clupeids | 1 | 82945 | 3 | 3.030 | 27374.6 |
| 331 | 2024-03-03 20:37:23 | clupeids | 2 | 121059 | 5 | 4.250 | 28484.5 |
| 330 | 2024-02-19 22:30:27 | clupeids | 1 | 82945 | 3 | 3.830 | 21656.7 |
| 329 | 2024-02-15 20:21:22 | clupeids | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 328 | 2024-02-15 20:21:12 | clupeids | 2 | 121059 | 5 | 4.160 | 29100.7 |
| 327 | 2024-02-07 09:02:38 | clupeids | 3 | 146162 | 39 | 8.483 | 17230.0 |
| 326 | 2024-02-07 09:02:42 | clupeids | 2 | 121059 | 5 | 3.953 | 30624.6 |
| 325 | 2024-02-07 09:02:34 | clupeids | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 324 | 2024-02-04 13:18:40 | clupeids | 4 | 161609 | 683 | 23.516 | 6872.3 |
| 323 | 2024-02-04 06:39:59 | clupeids | 3 | 146162 | 39 | 7.970 | 18339.0 |
| 322 | 2024-02-01 00:49:31 | clupeids | 3 | 146162 | 39 | 6.843 | 21359.3 |
| 321 | 2024-02-01 00:49:27 | clupeids | 2 | 121059 | 5 | 3.686 | 32842.9 |
| 320 | 2024-02-01 00:48:48 | clupeids | 1 | 82945 | 3 | 3.063 | 27079.7 |
| 319 | 2024-01-31 19:21:48 | clupeids | 4 | 161609 | 683 | 12.110 | 13345.1 |
| 318 | 2024-01-31 12:05:23 | clupeids | 4 | 161609 | 683 | 12.686 | 12739.2 |
| 317 | 2024-01-31 09:03:48 | clupeids | 1 | 82945 | 3 | 3.080 | 26930.2 |
| 316 | 2024-01-31 05:39:35 | clupeids | 4 | 161609 | 683 | 17.406 | 9284.7 |
| 315 | 2024-01-31 05:39:39 | clupeids | 3 | 146162 | 39 | 8.860 | 16496.8 |
| 314 | 2024-01-31 05:39:43 | clupeids | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 313 | 2024-01-31 05:39:31 | clupeids | 2 | 121059 | 5 | 7.423 | 16308.6 |
| 312 | 2024-01-30 19:07:43 | clupeids | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 311 | 2023-11-30 05:23:05 | clupeids | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 310 | 2023-11-25 03:20:06 | clupeids | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 309 | 2023-11-06 22:35:30 | clupeids | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 308 | 2023-11-06 01:10:15 | clupeids | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 307 | 2023-10-13 10:11:52 | clupeids | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 306 | 2023-10-07 17:42:02 | clupeids | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 305 | 2023-09-10 11:52:52 | clupeids | 4 | 161609 | 683 | 13.656 | 11834.3 |
| 304 | 2023-09-10 11:52:48 | clupeids | 3 | 146162 | 39 | 7.406 | 19735.6 |
| 303 | 2023-09-10 11:52:49 | clupeids | 2 | 121059 | 5 | 3.750 | 32282.4 |
| 302 | 2023-09-10 11:04:22 | clupeids | 1 | 82945 | 3 | 1.750 | 47397.1 |
| 301 | 2023-09-10 10:52:10 | clupeids | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 300 | 2023-06-19 16:53:53 | clupeids | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 299 | 2023-06-10 22:55:25 | clupeids | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 298 | 2023-04-03 00:52:14 | clupeids | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 297 | 2023-02-22 21:15:37 | clupeids | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 296 | 2023-01-15 14:30:41 | clupeids | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 295 | 2022-11-12 14:22:52 | clupeids | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 294 | 2022-10-22 16:55:24 | clupeids | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 293 | 2022-07-04 14:55:09 | clupeids | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 292 | 2022-06-17 14:25:09 | clupeids | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 291 | 2022-03-07 06:05:20 | clupeids | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 290 | 2022-03-05 03:00:27 | clupeids | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 289 | 2022-02-05 23:36:54 | clupeids | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 288 | 2021-12-19 20:09:51 | clupeids | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 287 | 2021-11-12 07:48:48 | clupeids | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 286 | 2021-10-09 21:37:06 | clupeids | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 285 | 2021-07-07 23:56:04 | clupeids | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 284 | 2021-06-05 12:45:59 | clupeids | 3 | 146162 | 39 | 6.003 | 24348.2 |
| 283 | 2021-05-11 12:08:26 | clupeids | 3 | 146162 | 39 | 7.063 | 20694.0 |
| 282 | 2021-05-08 20:15:54 | clupeids | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 281 | 2021-04-08 04:38:32 | clupeids | 1 | 82945 | 3 | 1.513 | 54821.5 |