History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sightings"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 648 | 2025-11-07 06:25:58 | sightings | 1 | 81242 | 4 | 1.420 | 57212.7 |
| 647 | 2025-11-01 20:50:46 | sightings | 1 | 81242 | 4 | 1.500 | 54161.3 |
| 646 | 2025-10-31 03:54:53 | sightings | 1 | 81242 | 4 | 2.906 | 27956.6 |
| 645 | 2025-10-29 16:39:02 | sightings | 4 | 165329 | 761 | 19.610 | 8430.9 |
| 644 | 2025-10-28 18:43:00 | sightings | 1 | 81242 | 4 | 1.343 | 60492.9 |
| 643 | 2025-10-27 20:31:08 | sightings | 1 | 81242 | 4 | 1.516 | 53589.7 |
| 642 | 2025-10-26 14:33:38 | sightings | 1 | 81242 | 4 | 2.750 | 29542.5 |
| 641 | 2025-10-25 04:49:21 | sightings | 1 | 81242 | 4 | 1.640 | 49537.8 |
| 640 | 2025-10-25 00:27:11 | sightings | 1 | 81242 | 4 | 1.420 | 57212.7 |
| 639 | 2025-10-21 08:35:21 | sightings | 1 | 81242 | 4 | 4.766 | 17046.2 |
| 638 | 2025-10-10 20:53:11 | sightings | 1 | 81242 | 4 | 1.373 | 59171.2 |
| 637 | 2025-10-10 12:03:59 | sightings | 1 | 81242 | 4 | 1.313 | 61875.1 |
| 636 | 2025-10-08 15:20:23 | sightings | 1 | 81242 | 4 | 1.263 | 64324.6 |
| 635 | 2025-10-06 05:19:11 | sightings | 1 | 81242 | 4 | 1.360 | 59736.8 |
| 634 | 2025-09-29 07:15:02 | sightings | 1 | 81242 | 4 | 1.470 | 55266.7 |
| 633 | 2025-09-27 14:07:05 | sightings | 1 | 81242 | 4 | 1.483 | 54782.2 |
| 632 | 2025-09-27 03:21:19 | sightings | 1 | 81242 | 4 | 1.406 | 57782.4 |
| 631 | 2025-09-21 15:05:00 | sightings | 1 | 81242 | 4 | 1.450 | 56029.0 |
| 630 | 2025-09-15 14:44:32 | sightings | 1 | 81242 | 4 | 1.313 | 61875.1 |
| 629 | 2025-09-15 03:38:32 | sightings | 1 | 81242 | 4 | 1.466 | 55417.5 |
| 628 | 2025-09-15 03:37:53 | sightings | 1 | 81242 | 4 | 1.533 | 52995.4 |
| 627 | 2025-09-08 20:06:13 | sightings | 1 | 81242 | 4 | 1.280 | 63470.3 |
| 626 | 2025-09-06 21:08:45 | sightings | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 625 | 2025-08-29 17:55:05 | sightings | 1 | 81242 | 4 | 1.313 | 61875.1 |
| 624 | 2025-08-27 14:30:41 | sightings | 1 | 81242 | 4 | 1.376 | 59042.2 |
| 623 | 2025-08-27 03:40:24 | sightings | 1 | 81242 | 4 | 1.326 | 61268.5 |
| 622 | 2025-08-26 15:42:40 | sightings | 4 | 165329 | 761 | 11.050 | 14961.9 |
| 621 | 2025-08-24 12:33:42 | sightings | 4 | 165329 | 761 | 12.983 | 12734.3 |
| 620 | 2025-08-19 01:16:21 | sightings | 1 | 81242 | 4 | 2.783 | 29192.2 |
| 619 | 2025-08-18 05:22:45 | sightings | 1 | 81242 | 4 | 1.486 | 54671.6 |
| 618 | 2025-08-17 17:22:23 | sightings | 4 | 165329 | 761 | 55.283 | 2990.6 |
| 617 | 2025-08-14 20:58:56 | sightings | 4 | 165329 | 761 | 32.190 | 5136.0 |
| 616 | 2025-08-12 00:44:54 | sightings | 2 | 121436 | 16 | 8.690 | 13974.2 |
| 615 | 2025-08-11 10:41:40 | sightings | 1 | 81242 | 4 | 1.483 | 54782.2 |
| 614 | 2025-08-10 04:22:57 | sightings | 1 | 81242 | 4 | 3.143 | 25848.6 |
| 613 | 2025-08-09 16:32:45 | sightings | 1 | 81242 | 4 | 1.470 | 55266.7 |
| 612 | 2025-08-02 05:27:08 | sightings | 1 | 81242 | 4 | 3.923 | 20709.2 |
| 611 | 2025-07-29 00:17:58 | sightings | 4 | 165329 | 761 | 32.546 | 5079.9 |
| 610 | 2025-07-27 16:00:43 | sightings | 1 | 81242 | 4 | 6.516 | 12468.1 |
| 609 | 2025-07-24 08:28:57 | sightings | 1 | 81242 | 4 | 7.016 | 11579.5 |
| 608 | 2025-07-22 23:58:43 | sightings | 1 | 81242 | 4 | 7.143 | 11373.7 |
| 607 | 2025-07-21 17:11:22 | sightings | 4 | 165329 | 761 | 52.723 | 3135.8 |
| 606 | 2025-07-19 08:24:06 | sightings | 1 | 81242 | 4 | 1.393 | 58321.6 |
| 605 | 2025-07-18 20:15:52 | sightings | 4 | 165329 | 761 | 68.303 | 2420.5 |
| 604 | 2025-07-16 14:27:39 | sightings | 1 | 81242 | 4 | 5.563 | 14604.0 |
| 603 | 2025-07-14 00:03:06 | sightings | 4 | 165329 | 761 | 43.956 | 3761.2 |
| 602 | 2025-07-13 02:58:25 | sightings | 1 | 81242 | 4 | 1.533 | 52995.4 |
| 601 | 2025-07-12 13:39:25 | sightings | 4 | 165329 | 761 | 16.220 | 10192.9 |
| 600 | 2025-07-11 13:19:10 | sightings | 4 | 165329 | 761 | 31.830 | 5194.1 |
| 599 | 2025-07-11 13:05:11 | sightings | 3 | 148641 | 93 | 19.346 | 7683.3 |
| 598 | 2025-07-11 09:32:57 | sightings | 3 | 148641 | 93 | 34.796 | 4271.8 |
| 597 | 2025-07-10 02:48:32 | sightings | 2 | 121436 | 16 | 9.560 | 12702.5 |
| 596 | 2025-07-09 23:42:51 | sightings | 1 | 81242 | 4 | 5.893 | 13786.2 |
| 595 | 2025-07-09 21:08:30 | sightings | 2 | 121436 | 16 | 18.343 | 6620.3 |
| 594 | 2025-07-07 07:04:45 | sightings | 3 | 148641 | 93 | 30.810 | 4824.4 |
| 593 | 2025-07-07 04:04:30 | sightings | 2 | 121436 | 16 | 10.596 | 11460.6 |
| 592 | 2025-07-07 00:47:14 | sightings | 4 | 165329 | 761 | 49.706 | 3326.1 |
| 591 | 2025-07-06 07:41:46 | sightings | 1 | 81242 | 4 | 4.500 | 18053.8 |
| 590 | 2025-06-26 15:17:58 | sightings | 1 | 81242 | 4 | 3.406 | 23852.6 |
| 589 | 2025-06-06 03:59:50 | sightings | 1 | 81242 | 4 | 6.923 | 11735.1 |
| 588 | 2025-06-06 01:30:45 | sightings | 1 | 81242 | 4 | 4.406 | 18438.9 |
| 587 | 2025-05-31 01:55:00 | sightings | 4 | 165329 | 761 | 67.240 | 2458.8 |
| 586 | 2025-05-28 06:40:59 | sightings | 1 | 81242 | 4 | 1.470 | 55266.7 |
| 585 | 2025-05-27 23:41:56 | sightings | 4 | 165329 | 761 | 11.750 | 14070.6 |
| 584 | 2025-05-27 15:20:53 | sightings | 4 | 165329 | 761 | 55.113 | 2999.8 |
| 583 | 2025-05-27 07:07:37 | sightings | 1 | 81242 | 4 | 6.986 | 11629.3 |
| 582 | 2025-05-27 06:08:26 | sightings | 4 | 165329 | 761 | 46.566 | 3550.4 |
| 581 | 2025-05-26 23:13:10 | sightings | 4 | 165329 | 761 | 42.190 | 3918.7 |
| 580 | 2025-05-26 16:10:17 | sightings | 1 | 81242 | 4 | 5.000 | 16248.4 |
| 579 | 2025-05-26 03:12:28 | sightings | 4 | 165329 | 761 | 76.583 | 2158.8 |
| 578 | 2025-05-26 01:14:10 | sightings | 4 | 165329 | 761 | 43.333 | 3815.3 |
| 577 | 2025-05-25 08:23:38 | sightings | 4 | 165329 | 761 | 10.500 | 15745.6 |
| 576 | 2025-05-18 07:40:24 | sightings | 1 | 81242 | 4 | 5.313 | 15291.2 |
| 575 | 2025-05-13 11:15:43 | sightings | 1 | 81242 | 4 | 8.686 | 9353.2 |
| 574 | 2025-05-09 14:52:36 | sightings | 3 | 148641 | 93 | 24.313 | 6113.6 |
| 573 | 2025-05-06 01:12:52 | sightings | 1 | 81242 | 4 | 7.470 | 10875.8 |
| 572 | 2025-05-02 18:25:41 | sightings | 1 | 81242 | 4 | 1.533 | 52995.4 |
| 571 | 2025-04-23 15:27:01 | sightings | 1 | 81242 | 4 | 7.346 | 11059.4 |
| 570 | 2025-04-19 00:16:40 | sightings | 2 | 121436 | 16 | 3.546 | 34245.9 |
| 569 | 2025-04-16 06:41:48 | sightings | 1 | 81242 | 4 | 7.300 | 11129.0 |
| 568 | 2025-04-13 12:09:59 | sightings | 1 | 81242 | 4 | 1.440 | 56418.1 |
| 567 | 2025-04-05 23:47:45 | sightings | 3 | 148641 | 93 | 28.053 | 5298.6 |
| 566 | 2025-04-03 23:24:30 | sightings | 3 | 148641 | 93 | 41.673 | 3566.8 |
| 565 | 2025-03-29 03:23:22 | sightings | 3 | 148641 | 93 | 33.533 | 4432.7 |
| 564 | 2025-03-27 22:55:56 | sightings | 3 | 148641 | 93 | 6.216 | 23912.6 |
| 563 | 2025-03-27 08:38:09 | sightings | 3 | 148641 | 93 | 34.936 | 4254.7 |
| 562 | 2025-03-27 00:21:00 | sightings | 2 | 121436 | 16 | 20.656 | 5879.0 |
| 561 | 2025-03-25 06:44:13 | sightings | 2 | 121436 | 16 | 18.110 | 6705.5 |
| 560 | 2025-03-25 02:24:34 | sightings | 3 | 148641 | 93 | 28.893 | 5144.5 |
| 559 | 2025-03-22 16:07:02 | sightings | 1 | 81242 | 4 | 3.753 | 21647.2 |
| 558 | 2025-03-20 08:42:46 | sightings | 1 | 81242 | 4 | 4.560 | 17816.2 |
| 557 | 2025-03-17 18:27:14 | sightings | 1 | 81242 | 4 | 6.673 | 12174.7 |
| 556 | 2025-03-17 01:05:25 | sightings | 2 | 121436 | 16 | 14.393 | 8437.2 |
| 555 | 2025-03-03 03:55:32 | sightings | 1 | 81242 | 4 | 6.126 | 13261.8 |
| 554 | 2025-02-26 14:46:19 | sightings | 3 | 148641 | 93 | 34.796 | 4271.8 |
| 553 | 2025-02-25 17:20:14 | sightings | 1 | 81242 | 4 | 1.263 | 64324.6 |
| 552 | 2025-02-24 08:03:27 | sightings | 2 | 121436 | 16 | 26.486 | 4584.9 |
| 551 | 2025-02-24 08:01:41 | sightings | 1 | 81242 | 4 | 4.533 | 17922.3 |
| 550 | 2025-02-18 19:51:49 | sightings | 3 | 148641 | 93 | 26.596 | 5588.8 |
| 549 | 2025-02-18 19:51:39 | sightings | 2 | 121436 | 16 | 9.610 | 12636.4 |