History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"movies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
622 | 2024-04-27 20:46:48 | movies | 1 | 48755 | 7 | 2.280 | 21383.8 |
621 | 2024-04-27 13:55:33 | movies | 1 | 48755 | 7 | 2.906 | 16777.4 |
620 | 2024-04-23 00:07:21 | movies | 1 | 48755 | 7 | 0.750 | 65006.7 |
619 | 2024-04-15 13:06:59 | movies | 1 | 48755 | 7 | 1.046 | 46610.9 |
618 | 2024-02-09 03:21:02 | movies | 1 | 48755 | 7 | 0.856 | 56956.8 |
617 | 2024-01-31 20:42:08 | movies | 2 | 82551 | 96 | 2.110 | 39123.7 |
616 | 2024-01-31 20:36:23 | movies | 3 | 112716 | 1346 | 5.826 | 19347.1 |
615 | 2024-01-31 01:57:04 | movies | 2 | 82551 | 96 | 2.076 | 39764.5 |
614 | 2024-01-31 01:56:20 | movies | 3 | 112716 | 1346 | 5.516 | 20434.4 |
613 | 2024-01-30 23:46:11 | movies | 2 | 82551 | 96 | 2.560 | 32246.5 |
612 | 2024-01-30 23:45:51 | movies | 3 | 112716 | 1346 | 5.376 | 20966.5 |
611 | 2024-01-26 15:54:11 | movies | 1 | 48755 | 7 | 0.893 | 54596.9 |
610 | 2024-01-13 10:13:39 | movies | 1 | 48755 | 7 | 0.750 | 65006.7 |
609 | 2024-01-13 07:20:46 | movies | 3 | 112716 | 1346 | 4.703 | 23966.8 |
608 | 2024-01-08 12:17:36 | movies | 3 | 112716 | 1346 | 4.670 | 24136.2 |
607 | 2023-12-31 19:51:10 | movies | 3 | 112716 | 1346 | 10.923 | 10319.1 |
606 | 2023-12-31 19:51:08 | movies | 2 | 82551 | 96 | 2.563 | 32208.7 |
605 | 2023-12-30 01:50:27 | movies | 3 | 112716 | 1346 | 5.516 | 20434.4 |
604 | 2023-12-30 01:50:29 | movies | 2 | 82551 | 96 | 2.466 | 33475.7 |
603 | 2023-12-07 17:10:01 | movies | 1 | 48755 | 7 | 0.890 | 54780.9 |
602 | 2023-12-07 17:10:00 | movies | 1 | 48755 | 7 | 0.893 | 54596.9 |
601 | 2023-11-30 01:07:01 | movies | 1 | 48755 | 7 | 0.780 | 62506.4 |
600 | 2023-11-25 06:02:22 | movies | 3 | 112716 | 1346 | 4.576 | 24632.0 |
599 | 2023-11-25 06:02:20 | movies | 2 | 82551 | 96 | 2.156 | 38289.0 |
598 | 2023-11-14 02:08:21 | movies | 1 | 48755 | 7 | 0.750 | 65006.7 |
597 | 2023-11-13 22:56:07 | movies | 1 | 48755 | 7 | 0.923 | 52822.3 |
596 | 2023-11-11 13:00:09 | movies | 1 | 48755 | 7 | 0.813 | 59969.2 |
595 | 2023-10-21 21:34:53 | movies | 1 | 48755 | 7 | 0.813 | 59969.2 |
594 | 2023-10-18 11:51:57 | movies | 1 | 48755 | 7 | 0.736 | 66243.2 |
593 | 2023-10-16 20:59:20 | movies | 3 | 112716 | 1346 | 13.110 | 8597.7 |
592 | 2023-10-15 05:11:09 | movies | 3 | 112716 | 1346 | 6.706 | 16808.2 |
591 | 2023-10-11 18:55:14 | movies | 1 | 48755 | 7 | 0.906 | 53813.5 |
590 | 2023-10-11 13:31:41 | movies | 1 | 48755 | 7 | 0.763 | 63899.1 |
589 | 2023-09-28 23:43:53 | movies | 1 | 48755 | 7 | 0.750 | 65006.7 |
588 | 2023-09-23 14:00:06 | movies | 1 | 48755 | 7 | 0.733 | 66514.3 |
587 | 2023-09-22 02:40:38 | movies | 1 | 48755 | 7 | 0.826 | 59025.4 |
586 | 2023-09-15 11:27:17 | movies | 1 | 48755 | 7 | 0.736 | 66243.2 |
585 | 2023-08-21 03:01:05 | movies | 1 | 48755 | 7 | 0.750 | 65006.7 |
584 | 2023-07-25 16:53:57 | movies | 3 | 112716 | 1346 | 5.140 | 21929.2 |
583 | 2023-06-29 22:18:57 | movies | 3 | 112716 | 1346 | 4.656 | 24208.8 |
582 | 2023-06-22 12:02:10 | movies | 1 | 48755 | 7 | 0.813 | 59969.2 |
581 | 2023-06-09 17:58:29 | movies | 1 | 48755 | 7 | 0.733 | 66514.3 |
580 | 2023-06-06 11:14:20 | movies | 1 | 48755 | 7 | 0.750 | 65006.7 |
579 | 2023-04-04 21:03:48 | movies | 3 | 112716 | 1346 | 5.216 | 21609.7 |
578 | 2023-04-03 19:20:15 | movies | 1 | 48755 | 7 | 0.800 | 60943.8 |
577 | 2023-03-12 11:55:52 | movies | 1 | 48755 | 7 | 0.876 | 55656.4 |
576 | 2023-02-18 07:40:31 | movies | 1 | 48755 | 7 | 0.826 | 59025.4 |
575 | 2023-02-14 19:58:06 | movies | 1 | 48755 | 7 | 0.733 | 66514.3 |
574 | 2023-02-13 14:46:06 | movies | 3 | 112716 | 1346 | 6.000 | 18786.0 |
573 | 2023-01-18 14:22:19 | movies | 1 | 48755 | 7 | 0.720 | 67715.3 |
572 | 2023-01-17 19:45:32 | movies | 1 | 48755 | 7 | 0.733 | 66514.3 |
571 | 2023-01-03 13:00:57 | movies | 3 | 112716 | 1346 | 4.576 | 24632.0 |
570 | 2022-12-25 11:59:52 | movies | 3 | 112716 | 1346 | 4.623 | 24381.6 |
569 | 2022-12-04 17:22:14 | movies | 1 | 48755 | 7 | 0.843 | 57835.1 |
568 | 2022-11-28 00:16:11 | movies | 1 | 48755 | 7 | 0.783 | 62266.9 |
567 | 2022-11-19 20:53:58 | movies | 1 | 48755 | 7 | 0.796 | 61250.0 |
566 | 2022-11-14 22:20:40 | movies | 3 | 112716 | 1346 | 4.736 | 23799.8 |
565 | 2022-11-14 15:14:48 | movies | 1 | 48755 | 7 | 0.733 | 66514.3 |
564 | 2022-11-13 00:38:05 | movies | 1 | 48755 | 7 | 0.733 | 66514.3 |
563 | 2022-11-08 18:24:25 | movies | 3 | 112716 | 1346 | 4.810 | 23433.7 |
562 | 2022-11-07 11:47:27 | movies | 1 | 48755 | 7 | 0.813 | 59969.2 |
561 | 2022-11-01 04:39:28 | movies | 1 | 48755 | 7 | 0.733 | 66514.3 |
560 | 2022-10-22 20:56:26 | movies | 3 | 112716 | 1346 | 9.736 | 11577.2 |
559 | 2022-10-14 09:02:00 | movies | 2 | 82551 | 96 | 2.360 | 34979.2 |
558 | 2022-10-13 23:17:07 | movies | 3 | 112716 | 1346 | 4.720 | 23880.5 |
557 | 2022-09-30 11:20:52 | movies | 3 | 112716 | 1346 | 4.610 | 24450.3 |
556 | 2022-09-19 20:39:58 | movies | 1 | 48755 | 7 | 0.766 | 63648.8 |
555 | 2022-09-18 15:19:09 | movies | 1 | 48755 | 7 | 0.763 | 63899.1 |
554 | 2022-09-10 00:21:06 | movies | 3 | 112716 | 1346 | 4.703 | 23966.8 |
553 | 2022-09-04 08:26:49 | movies | 3 | 112716 | 1346 | 4.670 | 24136.2 |
552 | 2022-09-01 20:12:48 | movies | 1 | 48755 | 7 | 0.813 | 59969.2 |
551 | 2022-08-31 19:40:18 | movies | 2 | 82551 | 96 | 2.626 | 31436.0 |
550 | 2022-08-15 00:35:45 | movies | 1 | 48755 | 7 | 0.780 | 62506.4 |
549 | 2022-08-14 05:55:50 | movies | 1 | 48755 | 7 | 0.826 | 59025.4 |
548 | 2022-08-09 17:10:08 | movies | 2 | 82551 | 96 | 2.126 | 38829.3 |
547 | 2022-08-07 05:32:20 | movies | 1 | 48755 | 7 | 0.860 | 56691.9 |
546 | 2022-08-06 15:58:53 | movies | 2 | 82551 | 96 | 2.063 | 40015.0 |
545 | 2022-08-05 22:25:51 | movies | 1 | 48755 | 7 | 0.843 | 57835.1 |
544 | 2022-08-04 06:38:04 | movies | 2 | 82551 | 96 | 2.563 | 32208.7 |
543 | 2022-07-21 14:05:15 | movies | 3 | 112716 | 1346 | 4.720 | 23880.5 |
542 | 2022-07-18 19:28:26 | movies | 1 | 48755 | 7 | 0.750 | 65006.7 |
541 | 2022-07-18 02:56:52 | movies | 2 | 82551 | 96 | 2.140 | 38575.2 |
540 | 2022-07-11 03:01:54 | movies | 3 | 112716 | 1346 | 4.640 | 24292.2 |
539 | 2022-07-10 05:52:41 | movies | 2 | 82551 | 96 | 2.170 | 38041.9 |
538 | 2022-07-10 04:56:42 | movies | 1 | 48755 | 7 | 0.826 | 59025.4 |
537 | 2022-07-04 17:15:40 | movies | 1 | 48755 | 7 | 0.736 | 66243.2 |
536 | 2022-07-02 16:23:25 | movies | 1 | 48755 | 7 | 0.860 | 56691.9 |
535 | 2022-07-01 07:36:04 | movies | 3 | 112716 | 1346 | 4.596 | 24524.8 |
534 | 2022-06-25 10:56:04 | movies | 2 | 82551 | 96 | 2.173 | 37989.4 |
533 | 2022-06-19 22:03:53 | movies | 3 | 112716 | 1346 | 4.656 | 24208.8 |
532 | 2022-05-08 21:54:46 | movies | 3 | 112716 | 1346 | 5.033 | 22395.4 |
531 | 2022-05-08 15:07:23 | movies | 3 | 112716 | 1346 | 5.063 | 22262.7 |
530 | 2022-05-08 00:59:04 | movies | 1 | 48755 | 7 | 0.763 | 63899.1 |
529 | 2022-04-06 19:18:33 | movies | 3 | 112716 | 1346 | 5.500 | 20493.8 |
528 | 2022-03-24 19:24:30 | movies | 1 | 48755 | 7 | 1.203 | 40527.8 |
527 | 2022-03-07 09:26:32 | movies | 1 | 48755 | 7 | 0.843 | 57835.1 |
526 | 2022-02-17 20:11:33 | movies | 1 | 48755 | 7 | 0.763 | 63899.1 |
525 | 2021-12-31 18:11:16 | movies | 1 | 48755 | 7 | 0.906 | 53813.5 |
524 | 2021-12-17 20:23:16 | movies | 1 | 48755 | 7 | 0.860 | 56691.9 |
523 | 2021-12-10 17:38:00 | movies | 1 | 48755 | 7 | 0.843 | 57835.1 |