History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shearings"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 523 | 2024-04-10 20:26:38 | shearings | 1 | 81242 | 5 | 2.966 | 27391.1 |
| 522 | 2024-04-08 04:35:36 | shearings | 1 | 81242 | 5 | 1.513 | 53696.0 |
| 521 | 2024-04-06 06:32:36 | shearings | 1 | 81242 | 5 | 2.190 | 37096.8 |
| 520 | 2024-03-28 10:52:34 | shearings | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 519 | 2024-03-01 03:49:33 | shearings | 1 | 81242 | 5 | 3.080 | 26377.3 |
| 518 | 2024-02-28 04:03:20 | shearings | 1 | 81242 | 5 | 1.563 | 51978.2 |
| 517 | 2024-02-27 06:34:02 | shearings | 1 | 81242 | 5 | 1.500 | 54161.3 |
| 516 | 2024-01-29 15:50:02 | shearings | 1 | 81242 | 5 | 1.360 | 59736.8 |
| 515 | 2024-01-21 08:48:34 | shearings | 3 | 148641 | 227 | 6.626 | 22433.0 |
| 514 | 2024-01-21 08:48:34 | shearings | 2 | 121436 | 40 | 3.546 | 34245.9 |
| 513 | 2024-01-06 12:27:38 | shearings | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 512 | 2023-11-28 13:58:50 | shearings | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 511 | 2023-11-22 03:11:19 | shearings | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 510 | 2023-11-17 20:26:39 | shearings | 1 | 81242 | 5 | 1.280 | 63470.3 |
| 509 | 2023-10-29 23:49:41 | shearings | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 508 | 2023-10-13 22:45:35 | shearings | 1 | 81242 | 5 | 1.330 | 61084.2 |
| 507 | 2023-09-26 18:49:16 | shearings | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 506 | 2023-09-14 12:44:52 | shearings | 1 | 81242 | 5 | 1.420 | 57212.7 |
| 505 | 2023-08-24 11:39:27 | shearings | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 504 | 2023-06-16 21:27:46 | shearings | 1 | 81242 | 5 | 1.373 | 59171.2 |
| 503 | 2023-05-27 13:20:27 | shearings | 1 | 81242 | 5 | 1.236 | 65729.8 |
| 502 | 2023-03-24 10:02:48 | shearings | 1 | 81242 | 5 | 1.453 | 55913.3 |
| 501 | 2023-02-18 21:52:25 | shearings | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 500 | 2023-01-08 21:47:38 | shearings | 1 | 81242 | 5 | 1.236 | 65729.8 |
| 499 | 2023-01-02 21:43:02 | shearings | 1 | 81242 | 5 | 1.220 | 66591.8 |
| 498 | 2022-11-20 06:30:24 | shearings | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 497 | 2022-11-02 11:49:42 | shearings | 2 | 121436 | 40 | 3.173 | 38271.7 |
| 496 | 2022-10-22 00:38:57 | shearings | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 495 | 2022-10-15 03:17:03 | shearings | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 494 | 2022-06-24 08:46:22 | shearings | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 493 | 2022-06-06 05:47:23 | shearings | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 492 | 2022-06-05 00:34:54 | shearings | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 491 | 2022-06-03 13:43:00 | shearings | 2 | 121436 | 40 | 3.110 | 39046.9 |
| 490 | 2022-06-02 19:12:55 | shearings | 1 | 81242 | 5 | 1.236 | 65729.8 |
| 489 | 2022-05-12 22:44:59 | shearings | 1 | 81242 | 5 | 1.390 | 58447.5 |
| 488 | 2022-05-04 21:36:06 | shearings | 1 | 81242 | 5 | 2.846 | 28546.0 |
| 487 | 2022-02-12 07:53:41 | shearings | 1 | 81242 | 5 | 1.360 | 59736.8 |
| 486 | 2022-02-10 13:04:04 | shearings | 1 | 81242 | 5 | 1.420 | 57212.7 |
| 485 | 2022-02-08 09:43:58 | shearings | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 484 | 2022-02-03 21:07:04 | shearings | 1 | 81242 | 5 | 1.390 | 58447.5 |
| 483 | 2022-01-10 14:21:23 | shearings | 1 | 81242 | 5 | 1.533 | 52995.4 |
| 482 | 2021-12-02 04:52:15 | shearings | 1 | 81242 | 5 | 1.436 | 56575.2 |
| 481 | 2021-10-28 15:51:06 | shearings | 1 | 81242 | 5 | 1.500 | 54161.3 |
| 480 | 2021-10-25 23:45:34 | shearings | 1 | 81242 | 5 | 1.220 | 66591.8 |
| 479 | 2021-10-13 09:40:49 | shearings | 3 | 148641 | 227 | 7.656 | 19415.0 |
| 478 | 2021-08-28 16:53:13 | shearings | 3 | 148641 | 227 | 6.423 | 23142.0 |
| 477 | 2021-07-22 04:57:13 | shearings | 1 | 81242 | 5 | 1.236 | 65729.8 |
| 476 | 2021-07-14 07:34:30 | shearings | 3 | 148641 | 227 | 6.280 | 23668.9 |
| 475 | 2021-07-09 03:05:28 | shearings | 3 | 148641 | 227 | 7.126 | 20859.0 |
| 474 | 2021-06-21 04:04:57 | shearings | 3 | 148641 | 227 | 7.406 | 20070.3 |
| 473 | 2021-06-15 06:20:38 | shearings | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 472 | 2021-06-13 14:47:27 | shearings | 1 | 81242 | 5 | 1.470 | 55266.7 |
| 471 | 2021-05-23 14:18:43 | shearings | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 470 | 2021-05-19 21:00:56 | shearings | 3 | 148641 | 227 | 7.233 | 20550.4 |
| 469 | 2021-05-13 07:55:18 | shearings | 1 | 81242 | 5 | 1.390 | 58447.5 |
| 468 | 2021-04-23 14:59:41 | shearings | 1 | 81242 | 5 | 1.516 | 53589.7 |
| 467 | 2021-04-19 21:33:27 | shearings | 3 | 148641 | 227 | 7.530 | 19739.8 |
| 466 | 2021-04-19 10:46:09 | shearings | 1 | 81242 | 5 | 1.813 | 44810.8 |
| 465 | 2021-03-15 03:28:37 | shearings | 3 | 148641 | 227 | 6.986 | 21277.0 |
| 464 | 2021-02-01 04:14:16 | shearings | 3 | 148641 | 227 | 7.170 | 20731.0 |
| 463 | 2021-01-08 23:15:23 | shearings | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 462 | 2020-12-29 08:36:55 | shearings | 1 | 81242 | 5 | 1.516 | 53589.7 |
| 461 | 2020-12-04 10:23:13 | shearings | 3 | 148641 | 227 | 6.593 | 22545.3 |
| 460 | 2020-10-23 14:33:17 | shearings | 3 | 148641 | 227 | 7.470 | 19898.4 |
| 459 | 2020-10-21 10:40:35 | shearings | 1 | 81242 | 5 | 1.373 | 59171.2 |
| 458 | 2020-10-21 05:58:01 | shearings | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 457 | 2020-09-26 00:11:25 | shearings | 1 | 81242 | 5 | 1.236 | 65729.8 |
| 456 | 2020-07-29 10:15:51 | shearings | 3 | 148641 | 227 | 7.296 | 20372.9 |
| 455 | 2020-06-14 05:51:30 | shearings | 1 | 81242 | 5 | 1.266 | 64172.2 |
| 454 | 2020-06-12 15:53:39 | shearings | 1 | 81242 | 5 | 1.280 | 63470.3 |
| 453 | 2020-06-06 07:19:31 | shearings | 3 | 148641 | 227 | 6.483 | 22927.8 |
| 452 | 2020-04-11 15:22:39 | shearings | 3 | 148641 | 227 | 14.156 | 10500.2 |
| 451 | 2020-03-21 13:12:48 | shearings | 1 | 81242 | 5 | 1.440 | 56418.1 |
| 450 | 2020-03-17 14:49:13 | shearings | 1 | 81242 | 5 | 1.483 | 54782.2 |
| 449 | 2020-03-09 15:54:35 | shearings | 1 | 81242 | 5 | 1.263 | 64324.6 |
| 448 | 2020-02-27 18:25:52 | shearings | 1 | 81242 | 5 | 1.576 | 51549.5 |
| 447 | 2020-02-25 19:42:07 | shearings | 1 | 81242 | 5 | 1.576 | 51549.5 |
| 446 | 2020-02-23 14:42:38 | shearings | 3 | 148641 | 227 | 9.156 | 16234.3 |
| 445 | 2020-02-15 05:59:58 | shearings | 1 | 81242 | 5 | 1.436 | 56575.2 |
| 444 | 2020-02-13 15:57:44 | shearings | 1 | 81242 | 5 | 4.093 | 19849.0 |
| 443 | 2020-02-09 18:59:39 | shearings | 1 | 81242 | 5 | 1.513 | 53696.0 |
| 442 | 2020-02-07 23:41:27 | shearings | 3 | 148641 | 227 | 13.173 | 11283.8 |
| 441 | 2020-02-07 08:01:10 | shearings | 1 | 81242 | 5 | 1.500 | 54161.3 |
| 440 | 2020-02-03 15:05:56 | shearings | 3 | 148641 | 227 | 10.503 | 14152.2 |
| 439 | 2020-02-01 08:46:28 | shearings | 1 | 81242 | 5 | 1.453 | 55913.3 |
| 438 | 2020-01-28 06:19:00 | shearings | 1 | 81242 | 5 | 1.423 | 57092.1 |
| 437 | 2020-01-25 14:22:51 | shearings | 3 | 148641 | 227 | 15.830 | 9389.8 |
| 436 | 2020-01-25 03:44:25 | shearings | 3 | 148641 | 227 | 9.143 | 16257.4 |
| 435 | 2020-01-24 18:08:44 | shearings | 3 | 148641 | 227 | 10.063 | 14771.0 |
| 434 | 2020-01-24 10:02:56 | shearings | 3 | 148641 | 227 | 9.343 | 15909.3 |
| 433 | 2020-01-22 18:47:03 | shearings | 1 | 81242 | 5 | 1.500 | 54161.3 |
| 432 | 2020-01-22 18:41:55 | shearings | 1 | 81242 | 5 | 3.376 | 24064.6 |
| 431 | 2020-01-19 23:42:51 | shearings | 1 | 81242 | 5 | 1.500 | 54161.3 |
| 430 | 2020-01-14 21:05:11 | shearings | 1 | 81242 | 5 | 3.673 | 22118.7 |
| 429 | 2020-01-07 09:09:22 | shearings | 1 | 81242 | 5 | 1.736 | 46798.4 |
| 428 | 2020-01-07 03:26:54 | shearings | 1 | 81242 | 5 | 2.096 | 38760.5 |
| 427 | 2019-12-29 06:47:41 | shearings | 1 | 81242 | 5 | 1.513 | 53696.0 |
| 426 | 2019-12-28 23:01:55 | shearings | 1 | 81242 | 5 | 1.470 | 55266.7 |
| 425 | 2019-12-06 16:39:05 | shearings | 1 | 81242 | 5 | 1.330 | 61084.2 |
| 424 | 2019-11-22 23:26:19 | shearings | 3 | 148641 | 227 | 6.266 | 23721.8 |