History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sunniness"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
634 | 2024-05-30 16:14:28 | sunniness | 1 | 81242 | 3 | 1.470 | 55266.7 |
633 | 2024-05-30 14:59:09 | sunniness | 1 | 81242 | 3 | 1.393 | 58321.6 |
632 | 2024-05-07 13:18:51 | sunniness | 1 | 81242 | 3 | 1.703 | 47705.2 |
631 | 2024-04-29 19:11:01 | sunniness | 1 | 81242 | 3 | 2.283 | 35585.6 |
630 | 2024-04-27 17:17:03 | sunniness | 1 | 81242 | 3 | 2.346 | 34630.0 |
629 | 2024-04-22 18:21:23 | sunniness | 3 | 148641 | 189 | 26.563 | 5595.8 |
628 | 2024-04-20 16:24:49 | sunniness | 2 | 121436 | 20 | 8.800 | 13799.5 |
627 | 2024-04-20 12:57:55 | sunniness | 3 | 148641 | 189 | 29.126 | 5103.4 |
626 | 2024-04-19 20:52:43 | sunniness | 3 | 148641 | 189 | 15.940 | 9325.0 |
625 | 2024-04-18 09:53:00 | sunniness | 2 | 121436 | 20 | 4.406 | 27561.5 |
624 | 2024-04-18 09:50:09 | sunniness | 3 | 148641 | 189 | 8.906 | 16690.0 |
623 | 2024-04-18 09:50:01 | sunniness | 1 | 81242 | 3 | 1.906 | 42624.3 |
622 | 2024-04-10 21:20:58 | sunniness | 1 | 81242 | 3 | 1.486 | 54671.6 |
621 | 2024-04-02 16:49:37 | sunniness | 1 | 81242 | 3 | 1.250 | 64993.6 |
620 | 2024-03-30 13:25:40 | sunniness | 1 | 81242 | 3 | 3.123 | 26014.1 |
619 | 2024-03-28 06:22:59 | sunniness | 1 | 81242 | 3 | 1.330 | 61084.2 |
618 | 2024-03-07 13:31:29 | sunniness | 1 | 81242 | 3 | 1.500 | 54161.3 |
617 | 2024-03-06 14:21:48 | sunniness | 1 | 81242 | 3 | 1.846 | 44009.8 |
616 | 2024-02-29 11:04:47 | sunniness | 1 | 81242 | 3 | 2.953 | 27511.7 |
615 | 2024-02-27 07:11:58 | sunniness | 1 | 81242 | 3 | 1.560 | 52078.2 |
614 | 2024-02-10 01:39:00 | sunniness | 2 | 121436 | 20 | 5.966 | 20354.7 |
613 | 2024-02-05 23:23:01 | sunniness | 2 | 121436 | 20 | 3.920 | 30978.6 |
612 | 2024-02-05 21:13:09 | sunniness | 3 | 148641 | 189 | 6.813 | 21817.3 |
611 | 2024-02-05 04:25:39 | sunniness | 3 | 148641 | 189 | 8.236 | 18047.7 |
610 | 2024-01-30 07:17:18 | sunniness | 1 | 81242 | 3 | 3.000 | 27080.7 |
609 | 2024-01-27 19:14:04 | sunniness | 1 | 81242 | 3 | 1.236 | 65729.8 |
608 | 2024-01-05 05:28:07 | sunniness | 1 | 81242 | 3 | 1.406 | 57782.4 |
607 | 2023-12-29 00:04:21 | sunniness | 3 | 148641 | 189 | 9.203 | 16151.4 |
606 | 2023-12-22 00:24:40 | sunniness | 1 | 81242 | 3 | 1.250 | 64993.6 |
605 | 2023-12-18 14:56:16 | sunniness | 1 | 81242 | 3 | 1.266 | 64172.2 |
604 | 2023-12-18 03:54:50 | sunniness | 3 | 148641 | 189 | 7.000 | 21234.4 |
603 | 2023-12-17 06:22:01 | sunniness | 1 | 81242 | 3 | 1.296 | 62686.7 |
602 | 2023-12-13 22:34:49 | sunniness | 3 | 148641 | 189 | 8.563 | 17358.5 |
601 | 2023-11-14 23:45:59 | sunniness | 3 | 148641 | 189 | 7.686 | 19339.2 |
600 | 2023-11-11 16:03:40 | sunniness | 3 | 148641 | 189 | 7.013 | 21195.1 |
599 | 2023-11-06 20:30:59 | sunniness | 1 | 81242 | 3 | 1.280 | 63470.3 |
598 | 2023-10-18 07:26:35 | sunniness | 1 | 81242 | 3 | 1.390 | 58447.5 |
597 | 2023-10-09 06:07:07 | sunniness | 1 | 81242 | 3 | 1.250 | 64993.6 |
596 | 2023-10-01 03:05:25 | sunniness | 1 | 81242 | 3 | 2.690 | 30201.5 |
595 | 2023-08-30 13:05:39 | sunniness | 1 | 81242 | 3 | 1.376 | 59042.2 |
594 | 2023-08-27 10:41:27 | sunniness | 3 | 148641 | 189 | 7.653 | 19422.6 |
593 | 2023-08-26 13:46:26 | sunniness | 3 | 148641 | 189 | 7.313 | 20325.6 |
592 | 2023-08-25 13:20:33 | sunniness | 3 | 148641 | 189 | 6.580 | 22589.8 |
591 | 2023-08-24 14:09:48 | sunniness | 3 | 148641 | 189 | 6.206 | 23951.2 |
590 | 2023-08-22 17:54:32 | sunniness | 3 | 148641 | 189 | 6.890 | 21573.4 |
589 | 2023-08-21 15:09:01 | sunniness | 3 | 148641 | 189 | 6.656 | 22331.9 |
588 | 2023-08-06 20:57:40 | sunniness | 3 | 148641 | 189 | 6.720 | 22119.2 |
587 | 2023-08-06 04:18:57 | sunniness | 1 | 81242 | 3 | 1.233 | 65889.7 |
586 | 2023-08-05 09:17:08 | sunniness | 3 | 148641 | 189 | 7.033 | 21134.8 |
585 | 2023-08-05 02:35:12 | sunniness | 3 | 148641 | 189 | 7.093 | 20956.0 |
584 | 2023-08-03 02:11:14 | sunniness | 3 | 148641 | 189 | 6.720 | 22119.2 |
583 | 2023-07-17 11:03:39 | sunniness | 3 | 148641 | 189 | 11.956 | 12432.3 |
582 | 2023-07-15 05:54:56 | sunniness | 3 | 148641 | 189 | 7.673 | 19372.0 |
581 | 2023-07-13 00:35:54 | sunniness | 3 | 148641 | 189 | 7.236 | 20541.9 |
580 | 2023-06-28 04:24:35 | sunniness | 3 | 148641 | 189 | 6.123 | 24275.8 |
579 | 2023-06-23 10:30:17 | sunniness | 3 | 148641 | 189 | 7.440 | 19978.6 |
578 | 2023-06-15 23:46:31 | sunniness | 3 | 148641 | 189 | 6.046 | 24585.0 |
577 | 2023-06-13 23:09:37 | sunniness | 3 | 148641 | 189 | 7.063 | 21045.0 |
576 | 2023-05-03 15:15:33 | sunniness | 1 | 81242 | 3 | 1.266 | 64172.2 |
575 | 2023-05-02 11:56:44 | sunniness | 1 | 81242 | 3 | 1.313 | 61875.1 |
574 | 2023-02-23 17:26:31 | sunniness | 1 | 81242 | 3 | 1.220 | 66591.8 |
573 | 2023-01-07 22:12:23 | sunniness | 3 | 148641 | 189 | 7.156 | 20771.5 |
572 | 2023-01-03 19:39:42 | sunniness | 3 | 148641 | 189 | 8.170 | 18193.5 |
571 | 2023-01-02 22:43:44 | sunniness | 3 | 148641 | 189 | 6.936 | 21430.4 |
570 | 2023-01-01 15:24:15 | sunniness | 3 | 148641 | 189 | 6.156 | 24145.7 |
569 | 2023-01-01 12:46:05 | sunniness | 1 | 81242 | 3 | 2.830 | 28707.4 |
568 | 2022-12-27 22:02:58 | sunniness | 3 | 148641 | 189 | 6.156 | 24145.7 |
567 | 2022-12-24 20:27:53 | sunniness | 3 | 148641 | 189 | 7.406 | 20070.3 |
566 | 2022-12-20 23:43:00 | sunniness | 1 | 81242 | 3 | 1.233 | 65889.7 |
565 | 2022-08-31 19:06:40 | sunniness | 1 | 81242 | 3 | 1.250 | 64993.6 |
564 | 2022-08-24 22:39:01 | sunniness | 1 | 81242 | 3 | 3.016 | 26937.0 |
563 | 2022-07-15 07:30:21 | sunniness | 3 | 148641 | 189 | 6.283 | 23657.6 |
562 | 2022-06-29 11:57:07 | sunniness | 3 | 148641 | 189 | 6.110 | 24327.5 |
561 | 2022-06-07 15:57:34 | sunniness | 3 | 148641 | 189 | 14.796 | 10046.0 |
560 | 2022-06-06 06:47:21 | sunniness | 3 | 148641 | 189 | 7.860 | 18911.1 |
559 | 2022-06-05 09:51:20 | sunniness | 3 | 148641 | 189 | 9.906 | 15005.1 |
558 | 2022-06-04 06:16:41 | sunniness | 3 | 148641 | 189 | 7.906 | 18801.0 |
557 | 2022-06-03 04:51:26 | sunniness | 3 | 148641 | 189 | 7.626 | 19491.3 |
556 | 2022-06-02 13:40:07 | sunniness | 3 | 148641 | 189 | 6.110 | 24327.5 |
555 | 2022-04-24 04:45:59 | sunniness | 1 | 81242 | 3 | 1.263 | 64324.6 |
554 | 2022-04-15 21:31:35 | sunniness | 3 | 148641 | 189 | 6.156 | 24145.7 |
553 | 2022-04-14 22:15:28 | sunniness | 3 | 148641 | 189 | 7.893 | 18832.0 |
552 | 2022-04-14 00:24:47 | sunniness | 1 | 81242 | 3 | 1.343 | 60492.9 |
551 | 2022-02-11 19:06:37 | sunniness | 3 | 148641 | 189 | 6.970 | 21325.8 |
550 | 2022-01-30 09:33:38 | sunniness | 3 | 148641 | 189 | 7.310 | 20333.9 |
549 | 2022-01-26 22:27:15 | sunniness | 3 | 148641 | 189 | 7.296 | 20372.9 |
548 | 2022-01-23 19:18:11 | sunniness | 3 | 148641 | 189 | 7.516 | 19776.6 |
547 | 2022-01-22 23:34:54 | sunniness | 3 | 148641 | 189 | 6.220 | 23897.3 |
546 | 2022-01-16 04:38:44 | sunniness | 1 | 81242 | 3 | 1.453 | 55913.3 |
545 | 2021-12-31 22:55:43 | sunniness | 3 | 148641 | 189 | 7.000 | 21234.4 |
544 | 2021-12-30 23:34:00 | sunniness | 3 | 148641 | 189 | 7.250 | 20502.2 |
543 | 2021-12-29 21:42:49 | sunniness | 3 | 148641 | 189 | 7.440 | 19978.6 |
542 | 2021-12-29 06:20:31 | sunniness | 1 | 81242 | 3 | 1.436 | 56575.2 |
541 | 2021-12-28 22:38:13 | sunniness | 3 | 148641 | 189 | 13.470 | 11035.0 |
540 | 2021-12-27 20:49:04 | sunniness | 3 | 148641 | 189 | 6.813 | 21817.3 |
539 | 2021-12-26 20:30:27 | sunniness | 3 | 148641 | 189 | 6.593 | 22545.3 |
538 | 2021-12-25 15:26:18 | sunniness | 3 | 148641 | 189 | 7.516 | 19776.6 |
537 | 2021-12-24 15:56:28 | sunniness | 3 | 148641 | 189 | 7.373 | 20160.2 |
536 | 2021-12-09 11:28:20 | sunniness | 3 | 148641 | 189 | 6.516 | 22811.7 |
535 | 2021-12-08 11:24:17 | sunniness | 3 | 148641 | 189 | 6.750 | 22020.9 |