History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subpar"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
626 | 2024-03-31 19:08:45 | subpar | 2 | 82551 | 18 | 4.373 | 18877.4 |
625 | 2024-03-31 19:08:13 | subpar | 1 | 48755 | 2 | 2.093 | 23294.3 |
624 | 2024-03-31 17:57:27 | subpar | 1 | 48755 | 2 | 0.860 | 56691.9 |
623 | 2024-03-30 02:29:51 | subpar | 2 | 82551 | 18 | 4.783 | 17259.3 |
622 | 2024-03-30 02:29:50 | subpar | 1 | 48755 | 2 | 1.050 | 46433.3 |
621 | 2024-03-28 17:27:55 | subpar | 1 | 48755 | 2 | 1.013 | 48129.3 |
620 | 2024-03-25 10:23:27 | subpar | 2 | 82551 | 18 | 2.533 | 32590.2 |
619 | 2024-03-25 10:22:50 | subpar | 3 | 112716 | 313 | 5.516 | 20434.4 |
618 | 2024-03-23 11:41:21 | subpar | 1 | 48755 | 2 | 0.766 | 63648.8 |
617 | 2024-03-23 07:58:31 | subpar | 2 | 82551 | 18 | 2.546 | 32423.8 |
616 | 2024-03-23 07:58:30 | subpar | 1 | 48755 | 2 | 0.923 | 52822.3 |
615 | 2024-03-23 07:58:10 | subpar | 3 | 112716 | 313 | 5.003 | 22529.7 |
614 | 2024-03-22 06:50:10 | subpar | 3 | 112716 | 313 | 11.250 | 10019.2 |
613 | 2024-03-20 09:17:05 | subpar | 3 | 112716 | 313 | 4.753 | 23714.7 |
612 | 2024-03-05 23:05:46 | subpar | 1 | 48755 | 2 | 1.890 | 25796.3 |
611 | 2024-01-22 19:12:52 | subpar | 2 | 82551 | 18 | 9.360 | 8819.6 |
610 | 2024-01-22 19:07:43 | subpar | 3 | 112716 | 313 | 8.456 | 13329.7 |
609 | 2024-01-22 11:26:38 | subpar | 3 | 112716 | 313 | 9.720 | 11596.3 |
608 | 2024-01-19 22:06:27 | subpar | 3 | 112716 | 313 | 6.030 | 18692.5 |
607 | 2024-01-19 22:06:25 | subpar | 2 | 82551 | 18 | 3.500 | 23586.0 |
606 | 2024-01-10 08:10:33 | subpar | 1 | 48755 | 2 | 0.906 | 53813.5 |
605 | 2023-12-14 17:12:52 | subpar | 1 | 48755 | 2 | 0.750 | 65006.7 |
604 | 2023-12-12 04:33:38 | subpar | 1 | 48755 | 2 | 0.906 | 53813.5 |
603 | 2023-12-03 17:07:44 | subpar | 1 | 48755 | 2 | 0.846 | 57630.0 |
602 | 2023-12-03 17:07:43 | subpar | 1 | 48755 | 2 | 0.890 | 54780.9 |
601 | 2023-11-27 03:53:18 | subpar | 3 | 112716 | 313 | 4.643 | 24276.5 |
600 | 2023-11-19 06:17:08 | subpar | 1 | 48755 | 2 | 0.766 | 63648.8 |
599 | 2023-11-03 08:38:20 | subpar | 1 | 48755 | 2 | 0.763 | 63899.1 |
598 | 2023-10-20 17:26:39 | subpar | 1 | 48755 | 2 | 1.423 | 34262.1 |
597 | 2023-10-19 11:09:53 | subpar | 1 | 48755 | 2 | 0.796 | 61250.0 |
596 | 2023-10-15 17:44:17 | subpar | 1 | 48755 | 2 | 0.826 | 59025.4 |
595 | 2023-09-30 21:46:53 | subpar | 3 | 112716 | 313 | 6.003 | 18776.6 |
594 | 2023-09-30 21:40:29 | subpar | 1 | 48755 | 2 | 0.970 | 50262.9 |
593 | 2023-09-29 07:02:03 | subpar | 1 | 48755 | 2 | 0.843 | 57835.1 |
592 | 2023-09-27 15:58:08 | subpar | 3 | 112716 | 313 | 5.826 | 19347.1 |
591 | 2023-09-27 15:58:11 | subpar | 2 | 82551 | 18 | 2.563 | 32208.7 |
590 | 2023-09-15 19:03:16 | subpar | 1 | 48755 | 2 | 0.843 | 57835.1 |
589 | 2023-08-28 08:53:17 | subpar | 3 | 112716 | 313 | 4.703 | 23966.8 |
588 | 2023-08-28 08:39:22 | subpar | 1 | 48755 | 2 | 0.780 | 62506.4 |
587 | 2023-07-27 15:13:22 | subpar | 1 | 48755 | 2 | 0.733 | 66514.3 |
586 | 2023-05-13 11:52:55 | subpar | 3 | 112716 | 313 | 4.610 | 24450.3 |
585 | 2023-04-29 14:02:11 | subpar | 1 | 48755 | 2 | 0.750 | 65006.7 |
584 | 2023-04-22 19:03:31 | subpar | 1 | 48755 | 2 | 0.766 | 63648.8 |
583 | 2023-02-22 01:02:15 | subpar | 3 | 112716 | 313 | 4.546 | 24794.5 |
582 | 2023-02-20 20:42:45 | subpar | 1 | 48755 | 2 | 0.766 | 63648.8 |
581 | 2022-12-19 04:56:25 | subpar | 1 | 48755 | 2 | 0.876 | 55656.4 |
580 | 2022-12-18 18:58:45 | subpar | 1 | 48755 | 2 | 0.813 | 59969.2 |
579 | 2022-12-02 08:02:56 | subpar | 3 | 112716 | 313 | 4.503 | 25031.3 |
578 | 2022-09-01 17:45:30 | subpar | 1 | 48755 | 2 | 0.780 | 62506.4 |
577 | 2022-08-30 10:15:43 | subpar | 1 | 48755 | 2 | 0.843 | 57835.1 |
576 | 2022-08-09 07:06:14 | subpar | 1 | 48755 | 2 | 0.876 | 55656.4 |
575 | 2022-07-18 19:01:05 | subpar | 1 | 48755 | 2 | 0.750 | 65006.7 |
574 | 2022-07-09 12:15:09 | subpar | 3 | 112716 | 313 | 4.873 | 23130.7 |
573 | 2022-07-04 08:19:04 | subpar | 1 | 48755 | 2 | 0.956 | 50999.0 |
572 | 2022-04-12 18:47:07 | subpar | 1 | 48755 | 2 | 1.046 | 46610.9 |
571 | 2022-03-25 08:53:42 | subpar | 1 | 48755 | 2 | 0.923 | 52822.3 |
570 | 2022-03-20 01:18:46 | subpar | 2 | 82551 | 18 | 2.143 | 38521.2 |
569 | 2022-03-19 03:19:00 | subpar | 2 | 82551 | 18 | 2.140 | 38575.2 |
568 | 2022-03-18 08:10:54 | subpar | 2 | 82551 | 18 | 2.423 | 34069.7 |
567 | 2022-03-17 14:28:41 | subpar | 2 | 82551 | 18 | 3.093 | 26689.6 |
566 | 2022-03-16 14:04:56 | subpar | 2 | 82551 | 18 | 4.330 | 19064.9 |
565 | 2022-03-15 14:00:19 | subpar | 2 | 82551 | 18 | 2.796 | 29524.7 |
564 | 2022-03-13 12:13:01 | subpar | 2 | 82551 | 18 | 2.186 | 37763.5 |
563 | 2022-03-12 16:26:16 | subpar | 2 | 82551 | 18 | 2.436 | 33887.9 |
562 | 2022-03-11 09:21:36 | subpar | 2 | 82551 | 18 | 2.203 | 37472.1 |
561 | 2022-03-11 01:23:43 | subpar | 2 | 82551 | 18 | 2.686 | 30733.8 |
560 | 2022-03-10 10:16:39 | subpar | 2 | 82551 | 18 | 2.970 | 27794.9 |
559 | 2022-03-09 12:37:46 | subpar | 2 | 82551 | 18 | 2.780 | 29694.6 |
558 | 2022-03-08 19:50:23 | subpar | 2 | 82551 | 18 | 2.733 | 30205.3 |
557 | 2022-03-08 06:05:21 | subpar | 2 | 82551 | 18 | 2.156 | 38289.0 |
556 | 2022-03-07 11:50:28 | subpar | 2 | 82551 | 18 | 2.423 | 34069.7 |
555 | 2022-03-06 17:15:21 | subpar | 2 | 82551 | 18 | 2.423 | 34069.7 |
554 | 2022-03-05 23:38:22 | subpar | 2 | 82551 | 18 | 2.220 | 37185.1 |
553 | 2022-03-05 08:23:05 | subpar | 2 | 82551 | 18 | 2.390 | 34540.2 |
552 | 2022-03-04 17:17:58 | subpar | 2 | 82551 | 18 | 2.216 | 37252.3 |
551 | 2022-03-04 08:04:58 | subpar | 2 | 82551 | 18 | 2.156 | 38289.0 |
550 | 2022-03-03 16:25:47 | subpar | 2 | 82551 | 18 | 3.173 | 26016.7 |
549 | 2022-03-03 01:39:22 | subpar | 2 | 82551 | 18 | 2.250 | 36689.3 |
548 | 2022-03-02 14:37:09 | subpar | 2 | 82551 | 18 | 2.923 | 28241.9 |
547 | 2022-02-07 14:31:49 | subpar | 2 | 82551 | 18 | 2.466 | 33475.7 |
546 | 2022-01-12 19:01:46 | subpar | 1 | 48755 | 2 | 0.843 | 57835.1 |
545 | 2021-12-31 22:01:15 | subpar | 2 | 82551 | 18 | 2.626 | 31436.0 |
544 | 2021-12-31 12:42:45 | subpar | 2 | 82551 | 18 | 2.623 | 31472.0 |
543 | 2021-12-30 21:24:14 | subpar | 2 | 82551 | 18 | 2.516 | 32810.4 |
542 | 2021-12-30 05:08:55 | subpar | 2 | 82551 | 18 | 2.296 | 35954.3 |
541 | 2021-12-29 20:33:10 | subpar | 2 | 82551 | 18 | 2.220 | 37185.1 |
540 | 2021-12-29 13:29:45 | subpar | 2 | 82551 | 18 | 2.500 | 33020.4 |
539 | 2021-12-28 18:54:09 | subpar | 2 | 82551 | 18 | 2.173 | 37989.4 |
538 | 2021-12-28 03:26:15 | subpar | 2 | 82551 | 18 | 5.093 | 16208.7 |
537 | 2021-12-27 18:27:07 | subpar | 2 | 82551 | 18 | 2.466 | 33475.7 |
536 | 2021-12-27 09:39:31 | subpar | 2 | 82551 | 18 | 2.330 | 35429.6 |
535 | 2021-12-26 17:55:57 | subpar | 2 | 82551 | 18 | 2.253 | 36640.5 |
534 | 2021-12-26 06:54:40 | subpar | 2 | 82551 | 18 | 2.250 | 36689.3 |
533 | 2021-12-25 18:54:06 | subpar | 2 | 82551 | 18 | 2.470 | 33421.5 |
532 | 2021-12-25 08:58:58 | subpar | 2 | 82551 | 18 | 2.236 | 36919.1 |
531 | 2021-12-24 22:14:00 | subpar | 2 | 82551 | 18 | 2.440 | 33832.4 |
530 | 2021-12-24 09:05:35 | subpar | 2 | 82551 | 18 | 2.436 | 33887.9 |
529 | 2021-12-05 17:45:04 | subpar | 1 | 48755 | 2 | 0.906 | 53813.5 |
528 | 2021-12-03 16:01:45 | subpar | 1 | 48755 | 2 | 0.750 | 65006.7 |
527 | 2021-12-01 08:42:19 | subpar | 1 | 48755 | 2 | 0.843 | 57835.1 |