History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"valour"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
624 | 2024-04-26 07:00:37 | valour | 3 | 112716 | 327 | 11.173 | 10088.2 |
623 | 2024-04-19 15:31:44 | valour | 1 | 48755 | 5 | 0.813 | 59969.2 |
622 | 2024-04-07 00:49:33 | valour | 3 | 112716 | 327 | 12.343 | 9132.0 |
621 | 2024-04-06 13:47:36 | valour | 3 | 112716 | 327 | 15.953 | 7065.5 |
620 | 2024-04-05 00:18:51 | valour | 3 | 112716 | 327 | 8.470 | 13307.7 |
619 | 2024-04-05 00:18:50 | valour | 2 | 82551 | 29 | 5.983 | 13797.6 |
618 | 2024-04-05 00:18:43 | valour | 1 | 48755 | 5 | 2.843 | 17149.1 |
617 | 2024-03-31 05:55:07 | valour | 3 | 112716 | 327 | 14.503 | 7771.9 |
616 | 2024-03-30 05:12:45 | valour | 1 | 48755 | 5 | 0.843 | 57835.1 |
615 | 2024-03-29 22:28:31 | valour | 2 | 82551 | 29 | 3.156 | 26156.8 |
614 | 2024-03-29 22:28:13 | valour | 3 | 112716 | 327 | 6.593 | 17096.3 |
613 | 2024-03-28 19:47:08 | valour | 2 | 82551 | 29 | 8.610 | 9587.8 |
612 | 2024-03-28 19:47:08 | valour | 1 | 48755 | 5 | 1.876 | 25988.8 |
611 | 2024-03-28 19:05:45 | valour | 3 | 112716 | 327 | 12.423 | 9073.2 |
610 | 2024-03-28 17:47:17 | valour | 1 | 48755 | 5 | 0.826 | 59025.4 |
609 | 2024-03-28 17:47:10 | valour | 3 | 112716 | 327 | 5.923 | 19030.2 |
608 | 2024-03-28 17:47:11 | valour | 2 | 82551 | 29 | 2.626 | 31436.0 |
607 | 2024-03-28 17:47:05 | valour | 1 | 48755 | 5 | 0.843 | 57835.1 |
606 | 2024-03-04 04:12:40 | valour | 1 | 48755 | 5 | 3.140 | 15527.1 |
605 | 2024-02-29 00:07:53 | valour | 1 | 48755 | 5 | 0.826 | 59025.4 |
604 | 2024-02-28 23:50:45 | valour | 2 | 82551 | 29 | 2.643 | 31233.8 |
603 | 2024-02-28 23:50:28 | valour | 3 | 112716 | 327 | 5.983 | 18839.4 |
602 | 2024-02-28 11:15:55 | valour | 2 | 82551 | 29 | 2.626 | 31436.0 |
601 | 2024-02-28 11:15:36 | valour | 3 | 112716 | 327 | 5.766 | 19548.4 |
600 | 2024-02-27 10:18:30 | valour | 2 | 82551 | 29 | 4.796 | 17212.5 |
599 | 2024-02-27 08:22:50 | valour | 3 | 112716 | 327 | 12.703 | 8873.2 |
598 | 2024-02-26 09:03:03 | valour | 3 | 112716 | 327 | 15.610 | 7220.8 |
597 | 2024-02-26 09:03:02 | valour | 2 | 82551 | 29 | 2.576 | 32046.2 |
596 | 2024-02-26 09:02:55 | valour | 1 | 48755 | 5 | 0.906 | 53813.5 |
595 | 2024-01-27 02:05:57 | valour | 1 | 48755 | 5 | 0.830 | 58741.0 |
594 | 2023-12-21 13:34:21 | valour | 1 | 48755 | 5 | 0.750 | 65006.7 |
593 | 2023-12-21 07:38:32 | valour | 1 | 48755 | 5 | 0.766 | 63648.8 |
592 | 2023-12-20 04:06:29 | valour | 3 | 112716 | 327 | 4.906 | 22975.1 |
591 | 2023-12-06 01:16:31 | valour | 3 | 112716 | 327 | 5.423 | 20784.8 |
590 | 2023-12-06 01:16:33 | valour | 2 | 82551 | 29 | 2.593 | 31836.1 |
589 | 2023-12-03 05:16:01 | valour | 1 | 48755 | 5 | 1.826 | 26700.4 |
588 | 2023-12-03 05:15:55 | valour | 1 | 48755 | 5 | 1.860 | 26212.4 |
587 | 2023-11-30 05:58:12 | valour | 3 | 112716 | 327 | 5.343 | 21096.0 |
586 | 2023-11-30 05:58:03 | valour | 2 | 82551 | 29 | 2.156 | 38289.0 |
585 | 2023-11-10 14:04:03 | valour | 1 | 48755 | 5 | 0.733 | 66514.3 |
584 | 2023-11-02 07:35:47 | valour | 1 | 48755 | 5 | 1.720 | 28345.9 |
583 | 2023-11-02 02:02:24 | valour | 3 | 112716 | 327 | 9.456 | 11920.1 |
582 | 2023-11-02 02:02:26 | valour | 2 | 82551 | 29 | 2.436 | 33887.9 |
581 | 2023-10-28 03:30:45 | valour | 1 | 48755 | 5 | 0.843 | 57835.1 |
580 | 2023-10-20 22:00:29 | valour | 1 | 48755 | 5 | 0.856 | 56956.8 |
579 | 2023-10-18 02:16:13 | valour | 1 | 48755 | 5 | 0.796 | 61250.0 |
578 | 2023-10-17 08:53:27 | valour | 2 | 82551 | 29 | 4.546 | 18159.0 |
577 | 2023-10-17 08:53:24 | valour | 3 | 112716 | 327 | 5.470 | 20606.2 |
576 | 2023-10-10 23:26:32 | valour | 1 | 48755 | 5 | 0.783 | 62266.9 |
575 | 2023-10-09 09:50:27 | valour | 1 | 48755 | 5 | 0.783 | 62266.9 |
574 | 2023-10-04 14:00:17 | valour | 1 | 48755 | 5 | 0.736 | 66243.2 |
573 | 2023-09-28 06:17:45 | valour | 3 | 112716 | 327 | 7.453 | 15123.6 |
572 | 2023-09-25 12:39:16 | valour | 2 | 82551 | 29 | 2.470 | 33421.5 |
571 | 2023-09-25 12:33:07 | valour | 3 | 112716 | 327 | 13.360 | 8436.8 |
570 | 2023-09-24 03:00:45 | valour | 1 | 48755 | 5 | 0.780 | 62506.4 |
569 | 2023-09-21 12:42:58 | valour | 3 | 112716 | 327 | 4.813 | 23419.1 |
568 | 2023-09-19 13:52:48 | valour | 1 | 48755 | 5 | 0.953 | 51159.5 |
567 | 2023-09-12 07:00:25 | valour | 1 | 48755 | 5 | 0.750 | 65006.7 |
566 | 2023-08-05 16:04:34 | valour | 1 | 48755 | 5 | 0.750 | 65006.7 |
565 | 2023-07-19 17:45:27 | valour | 3 | 112716 | 327 | 4.686 | 24053.8 |
564 | 2023-06-30 13:54:14 | valour | 3 | 112716 | 327 | 5.203 | 21663.7 |
563 | 2023-05-14 19:29:02 | valour | 1 | 48755 | 5 | 0.733 | 66514.3 |
562 | 2023-05-07 00:48:05 | valour | 1 | 48755 | 5 | 0.733 | 66514.3 |
561 | 2023-03-31 13:07:23 | valour | 3 | 112716 | 327 | 4.610 | 24450.3 |
560 | 2023-03-26 09:41:03 | valour | 3 | 112716 | 327 | 4.626 | 24365.8 |
559 | 2023-02-28 12:35:53 | valour | 1 | 48755 | 5 | 0.716 | 68093.6 |
558 | 2023-01-02 22:32:31 | valour | 1 | 48755 | 5 | 0.826 | 59025.4 |
557 | 2022-12-25 03:50:55 | valour | 1 | 48755 | 5 | 0.783 | 62266.9 |
556 | 2022-12-24 04:51:58 | valour | 3 | 112716 | 327 | 4.656 | 24208.8 |
555 | 2022-12-19 20:22:57 | valour | 3 | 112716 | 327 | 5.140 | 21929.2 |
554 | 2022-11-20 06:54:46 | valour | 3 | 112716 | 327 | 5.670 | 19879.4 |
553 | 2022-11-02 13:56:32 | valour | 3 | 112716 | 327 | 10.000 | 11271.6 |
552 | 2022-11-02 04:25:16 | valour | 3 | 112716 | 327 | 5.063 | 22262.7 |
551 | 2022-10-30 01:29:32 | valour | 3 | 112716 | 327 | 5.030 | 22408.7 |
550 | 2022-09-25 20:06:51 | valour | 3 | 112716 | 327 | 4.640 | 24292.2 |
549 | 2022-09-13 08:23:05 | valour | 1 | 48755 | 5 | 0.720 | 67715.3 |
548 | 2022-09-12 05:20:50 | valour | 1 | 48755 | 5 | 0.750 | 65006.7 |
547 | 2022-08-23 04:45:47 | valour | 3 | 112716 | 327 | 4.826 | 23356.0 |
546 | 2022-08-12 13:45:03 | valour | 1 | 48755 | 5 | 0.766 | 63648.8 |
545 | 2022-07-17 09:36:46 | valour | 1 | 48755 | 5 | 0.843 | 57835.1 |
544 | 2022-07-11 15:11:55 | valour | 1 | 48755 | 5 | 0.736 | 66243.2 |
543 | 2022-07-09 23:54:07 | valour | 1 | 48755 | 5 | 0.750 | 65006.7 |
542 | 2022-07-02 10:51:32 | valour | 1 | 48755 | 5 | 0.750 | 65006.7 |
541 | 2022-03-19 05:49:23 | valour | 1 | 48755 | 5 | 0.736 | 66243.2 |
540 | 2022-03-15 02:05:35 | valour | 1 | 48755 | 5 | 0.843 | 57835.1 |
539 | 2021-12-29 10:37:22 | valour | 1 | 48755 | 5 | 0.846 | 57630.0 |
538 | 2021-12-27 08:07:58 | valour | 1 | 48755 | 5 | 0.783 | 62266.9 |
537 | 2021-11-14 13:37:23 | valour | 1 | 48755 | 5 | 0.950 | 51321.1 |
536 | 2021-10-28 01:05:49 | valour | 1 | 48755 | 5 | 0.796 | 61250.0 |
535 | 2021-10-01 03:32:45 | valour | 1 | 48755 | 5 | 0.813 | 59969.2 |
534 | 2021-09-29 00:24:04 | valour | 1 | 48755 | 5 | 0.733 | 66514.3 |
533 | 2021-07-22 05:11:09 | valour | 1 | 48755 | 5 | 0.813 | 59969.2 |
532 | 2021-05-23 17:30:04 | valour | 1 | 48755 | 5 | 0.796 | 61250.0 |
531 | 2021-04-26 17:57:38 | valour | 1 | 48755 | 5 | 0.890 | 54780.9 |
530 | 2021-04-19 10:48:13 | valour | 1 | 48755 | 5 | 0.890 | 54780.9 |
529 | 2021-03-26 22:16:10 | valour | 1 | 48755 | 5 | 0.750 | 65006.7 |
528 | 2021-01-10 05:02:12 | valour | 1 | 48755 | 5 | 0.736 | 66243.2 |
527 | 2020-12-22 05:56:11 | valour | 1 | 48755 | 5 | 0.750 | 65006.7 |
526 | 2020-12-12 00:25:30 | valour | 1 | 48755 | 5 | 0.733 | 66514.3 |
525 | 2020-11-16 07:51:22 | valour | 1 | 48755 | 5 | 0.813 | 59969.2 |