History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"photographs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
643 | 2024-03-26 14:11:38 | photographs | 4 | 148819 | 149 | 41.473 | 3588.3 |
642 | 2024-03-26 14:11:34 | photographs | 3 | 121633 | 46 | 15.080 | 8065.8 |
641 | 2024-03-26 14:11:32 | photographs | 2 | 86808 | 17 | 3.733 | 23254.2 |
640 | 2024-03-26 12:38:01 | photographs | 1 | 49908 | 4 | 1.733 | 28798.6 |
639 | 2024-03-21 11:09:12 | photographs | 1 | 49908 | 4 | 1.936 | 25778.9 |
638 | 2024-03-15 00:21:28 | photographs | 4 | 148819 | 149 | 33.266 | 4473.6 |
637 | 2024-03-14 23:17:06 | photographs | 1 | 49908 | 4 | 0.983 | 50771.1 |
636 | 2024-03-12 20:27:52 | photographs | 4 | 148819 | 149 | 29.596 | 5028.3 |
635 | 2024-03-12 11:46:13 | photographs | 1 | 49908 | 4 | 0.843 | 59202.8 |
634 | 2024-03-10 01:17:22 | photographs | 4 | 148819 | 149 | 33.346 | 4462.9 |
633 | 2024-03-10 01:17:27 | photographs | 3 | 121633 | 46 | 14.406 | 8443.2 |
632 | 2024-03-10 01:17:26 | photographs | 2 | 86808 | 17 | 8.283 | 10480.3 |
631 | 2024-03-10 01:16:59 | photographs | 1 | 49908 | 4 | 1.860 | 26832.3 |
630 | 2024-03-02 18:55:39 | photographs | 3 | 121633 | 46 | 17.686 | 6877.4 |
629 | 2024-03-02 18:55:38 | photographs | 2 | 86808 | 17 | 6.640 | 13073.5 |
628 | 2024-03-02 18:54:35 | photographs | 4 | 148819 | 149 | 33.126 | 4492.5 |
627 | 2024-03-02 06:53:52 | photographs | 4 | 148819 | 149 | 23.066 | 6451.9 |
626 | 2024-03-02 06:53:47 | photographs | 3 | 121633 | 46 | 13.156 | 9245.4 |
625 | 2024-03-02 06:53:49 | photographs | 2 | 86808 | 17 | 7.500 | 11574.4 |
624 | 2024-03-02 06:52:32 | photographs | 1 | 49908 | 4 | 1.796 | 27788.4 |
623 | 2024-02-21 06:09:30 | photographs | 4 | 148819 | 149 | 11.860 | 12548.0 |
622 | 2024-02-20 20:05:17 | photographs | 2 | 86808 | 17 | 7.483 | 11600.7 |
621 | 2024-02-20 20:05:19 | photographs | 3 | 121633 | 46 | 5.953 | 20432.2 |
620 | 2024-02-20 20:05:06 | photographs | 1 | 49908 | 4 | 0.763 | 65410.2 |
619 | 2024-02-20 04:41:40 | photographs | 3 | 121633 | 46 | 13.983 | 8698.6 |
618 | 2024-02-20 04:41:42 | photographs | 2 | 86808 | 17 | 2.830 | 30674.2 |
617 | 2024-02-19 15:43:46 | photographs | 1 | 49908 | 4 | 2.000 | 24954.0 |
616 | 2024-02-10 04:26:51 | photographs | 4 | 148819 | 149 | 28.673 | 5190.2 |
615 | 2024-02-09 23:25:05 | photographs | 1 | 49908 | 4 | 2.830 | 17635.3 |
614 | 2024-02-06 06:54:21 | photographs | 1 | 49908 | 4 | 0.873 | 57168.4 |
613 | 2024-01-31 23:05:20 | photographs | 1 | 49908 | 4 | 0.826 | 60421.3 |
612 | 2024-01-20 10:21:02 | photographs | 1 | 49908 | 4 | 0.830 | 60130.1 |
611 | 2024-01-04 00:49:13 | photographs | 3 | 121633 | 46 | 4.530 | 26850.6 |
610 | 2023-12-29 15:50:33 | photographs | 2 | 86808 | 17 | 2.063 | 42078.5 |
609 | 2023-12-26 22:04:45 | photographs | 1 | 49908 | 4 | 0.860 | 58032.6 |
608 | 2023-12-23 18:11:36 | photographs | 1 | 49908 | 4 | 0.796 | 62698.5 |
607 | 2023-12-20 02:18:18 | photographs | 4 | 148819 | 149 | 8.813 | 16886.3 |
606 | 2023-12-18 06:45:04 | photographs | 3 | 121633 | 46 | 4.860 | 25027.4 |
605 | 2023-12-18 06:45:06 | photographs | 2 | 86808 | 17 | 2.280 | 38073.7 |
604 | 2023-12-12 21:20:23 | photographs | 1 | 49908 | 4 | 1.030 | 48454.4 |
603 | 2023-12-05 23:49:16 | photographs | 4 | 148819 | 149 | 9.453 | 15743.0 |
602 | 2023-12-05 23:49:21 | photographs | 2 | 86808 | 17 | 2.500 | 34723.2 |
601 | 2023-12-05 23:49:13 | photographs | 3 | 121633 | 46 | 4.906 | 24792.7 |
600 | 2023-11-17 06:00:54 | photographs | 1 | 49908 | 4 | 0.766 | 65154.0 |
599 | 2023-11-12 08:36:40 | photographs | 1 | 49908 | 4 | 0.826 | 60421.3 |
598 | 2023-11-10 14:26:02 | photographs | 1 | 49908 | 4 | 0.766 | 65154.0 |
597 | 2023-11-02 09:27:02 | photographs | 1 | 49908 | 4 | 0.890 | 56076.4 |
596 | 2023-10-17 02:23:54 | photographs | 1 | 49908 | 4 | 2.843 | 17554.7 |
595 | 2023-10-15 06:44:55 | photographs | 1 | 49908 | 4 | 0.860 | 58032.6 |
594 | 2023-10-15 05:59:02 | photographs | 3 | 121633 | 46 | 6.796 | 17897.7 |
593 | 2023-10-10 06:19:35 | photographs | 3 | 121633 | 46 | 4.983 | 24409.6 |
592 | 2023-10-01 15:48:10 | photographs | 2 | 86808 | 17 | 2.030 | 42762.6 |
591 | 2023-09-04 06:09:23 | photographs | 1 | 49908 | 4 | 0.830 | 60130.1 |
590 | 2023-08-28 01:36:15 | photographs | 1 | 49908 | 4 | 0.750 | 66544.0 |
589 | 2023-07-20 15:12:27 | photographs | 3 | 121633 | 46 | 4.330 | 28090.8 |
588 | 2023-07-12 17:07:03 | photographs | 2 | 86808 | 17 | 2.030 | 42762.6 |
587 | 2023-07-09 06:02:18 | photographs | 1 | 49908 | 4 | 0.736 | 67809.8 |
586 | 2023-05-14 11:53:14 | photographs | 1 | 49908 | 4 | 0.813 | 61387.5 |
585 | 2023-04-03 04:30:39 | photographs | 3 | 121633 | 46 | 4.936 | 24642.0 |
584 | 2023-03-30 20:29:56 | photographs | 2 | 86808 | 17 | 2.173 | 39948.5 |
583 | 2023-02-05 10:35:25 | photographs | 1 | 49908 | 4 | 0.750 | 66544.0 |
582 | 2023-02-01 02:07:54 | photographs | 1 | 49908 | 4 | 0.783 | 63739.5 |
581 | 2022-12-31 10:52:27 | photographs | 3 | 121633 | 46 | 4.516 | 26933.8 |
580 | 2022-12-26 03:20:18 | photographs | 2 | 86808 | 17 | 1.983 | 43776.1 |
579 | 2022-12-04 10:11:30 | photographs | 1 | 49908 | 4 | 0.720 | 69316.7 |
578 | 2022-10-14 08:57:21 | photographs | 1 | 49908 | 4 | 0.733 | 68087.3 |
577 | 2022-09-03 00:39:33 | photographs | 3 | 121633 | 46 | 5.063 | 24023.9 |
576 | 2022-08-25 03:48:41 | photographs | 2 | 86808 | 17 | 2.330 | 37256.7 |
575 | 2022-07-30 21:04:02 | photographs | 1 | 49908 | 4 | 0.923 | 54071.5 |
574 | 2022-07-28 12:33:52 | photographs | 1 | 49908 | 4 | 0.750 | 66544.0 |
573 | 2022-06-24 01:05:27 | photographs | 1 | 49908 | 4 | 0.766 | 65154.0 |
572 | 2022-04-10 18:17:47 | photographs | 1 | 49908 | 4 | 0.750 | 66544.0 |
571 | 2022-04-09 07:40:05 | photographs | 1 | 49908 | 4 | 0.733 | 68087.3 |
570 | 2022-03-01 03:47:00 | photographs | 1 | 49908 | 4 | 0.830 | 60130.1 |
569 | 2022-02-25 21:55:03 | photographs | 2 | 86808 | 17 | 2.220 | 39102.7 |
568 | 2022-02-25 17:53:52 | photographs | 1 | 49908 | 4 | 0.766 | 65154.0 |
567 | 2022-02-06 19:55:51 | photographs | 2 | 86808 | 17 | 2.593 | 33477.8 |
566 | 2022-02-05 15:48:27 | photographs | 2 | 86808 | 17 | 2.690 | 32270.6 |
565 | 2022-02-04 16:54:54 | photographs | 2 | 86808 | 17 | 2.296 | 37808.4 |
564 | 2022-02-03 13:02:42 | photographs | 2 | 86808 | 17 | 2.186 | 39710.9 |
563 | 2022-02-02 10:17:16 | photographs | 2 | 86808 | 17 | 2.266 | 38308.9 |
562 | 2022-02-01 11:47:25 | photographs | 2 | 86808 | 17 | 2.110 | 41141.2 |
561 | 2022-01-31 11:57:57 | photographs | 2 | 86808 | 17 | 2.190 | 39638.4 |
560 | 2022-01-30 18:03:07 | photographs | 2 | 86808 | 17 | 2.390 | 36321.3 |
559 | 2022-01-29 18:15:39 | photographs | 2 | 86808 | 17 | 2.110 | 41141.2 |
558 | 2022-01-02 15:51:05 | photographs | 2 | 86808 | 17 | 2.466 | 35201.9 |
557 | 2022-01-02 13:45:24 | photographs | 2 | 86808 | 17 | 2.266 | 38308.9 |
556 | 2022-01-01 19:45:59 | photographs | 2 | 86808 | 17 | 2.830 | 30674.2 |
555 | 2022-01-01 17:40:25 | photographs | 2 | 86808 | 17 | 2.156 | 40263.5 |
554 | 2022-01-01 10:02:01 | photographs | 2 | 86808 | 17 | 2.483 | 34960.9 |
553 | 2022-01-01 07:58:17 | photographs | 2 | 86808 | 17 | 2.406 | 36079.8 |
552 | 2021-12-23 21:30:45 | photographs | 2 | 86808 | 17 | 2.283 | 38023.7 |
551 | 2021-12-23 16:44:31 | photographs | 2 | 86808 | 17 | 2.313 | 37530.5 |
550 | 2021-12-23 16:24:21 | photographs | 3 | 121633 | 46 | 5.483 | 22183.7 |
549 | 2021-12-23 13:34:12 | photographs | 2 | 86808 | 17 | 2.423 | 35826.7 |
548 | 2021-12-23 08:49:23 | photographs | 3 | 121633 | 46 | 8.953 | 13585.7 |
547 | 2021-12-23 06:16:41 | photographs | 2 | 86808 | 17 | 3.360 | 25835.7 |
546 | 2021-12-23 02:20:10 | photographs | 2 | 86808 | 17 | 2.516 | 34502.4 |
545 | 2021-12-22 22:40:45 | photographs | 2 | 86808 | 17 | 2.266 | 38308.9 |
544 | 2021-12-22 20:59:03 | photographs | 3 | 121633 | 46 | 4.313 | 28201.5 |