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 |
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 |
548 | 2025-02-18 19:50:11 | sightings | 1 | 81242 | 4 | 5.953 | 13647.2 |
547 | 2025-02-18 04:47:56 | sightings | 1 | 81242 | 4 | 6.500 | 12498.8 |
546 | 2025-02-15 10:21:07 | sightings | 3 | 148641 | 93 | 30.563 | 4863.4 |
545 | 2025-02-14 04:05:04 | sightings | 3 | 148641 | 93 | 46.923 | 3167.8 |
544 | 2025-02-13 22:38:15 | sightings | 3 | 148641 | 93 | 35.593 | 4176.1 |
543 | 2025-02-13 08:51:31 | sightings | 3 | 148641 | 93 | 35.036 | 4242.5 |
542 | 2025-02-13 08:51:23 | sightings | 2 | 121436 | 16 | 16.706 | 7269.0 |
541 | 2025-02-13 08:48:03 | sightings | 1 | 81242 | 4 | 1.406 | 57782.4 |
540 | 2025-02-11 17:17:21 | sightings | 4 | 165329 | 761 | 61.723 | 2678.6 |
539 | 2025-02-11 10:52:09 | sightings | 4 | 165329 | 761 | 61.630 | 2682.6 |
538 | 2025-02-10 12:00:50 | sightings | 4 | 165329 | 761 | 138.206 | 1196.3 |
537 | 2025-02-10 06:30:58 | sightings | 4 | 165329 | 761 | 16.156 | 10233.3 |
536 | 2025-02-09 00:35:28 | sightings | 4 | 165329 | 761 | 59.830 | 2763.3 |
535 | 2025-01-24 06:55:02 | sightings | 1 | 81242 | 4 | 7.283 | 11155.0 |
534 | 2025-01-19 06:00:01 | sightings | 2 | 121436 | 16 | 17.973 | 6756.6 |
533 | 2025-01-19 05:58:47 | sightings | 1 | 81242 | 4 | 4.550 | 17855.4 |
532 | 2025-01-14 13:37:10 | sightings | 3 | 148641 | 93 | 18.783 | 7913.6 |
531 | 2025-01-14 02:52:21 | sightings | 3 | 148641 | 93 | 40.813 | 3642.0 |
530 | 2025-01-13 05:09:39 | sightings | 3 | 148641 | 93 | 35.830 | 4148.5 |
529 | 2025-01-13 05:09:41 | sightings | 2 | 121436 | 16 | 9.266 | 13105.5 |
528 | 2025-01-13 05:09:07 | sightings | 1 | 81242 | 4 | 4.096 | 19834.5 |