History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"solar"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
614 | 2024-04-27 01:25:09 | solar | 1 | 28756 | 12 | 0.750 | 38341.3 |
613 | 2024-04-13 15:56:28 | solar | 1 | 28756 | 12 | 0.533 | 53951.2 |
612 | 2024-04-03 05:38:47 | solar | 1 | 28756 | 12 | 1.733 | 16593.2 |
611 | 2024-03-31 10:25:48 | solar | 2 | 53800 | 148 | 5.813 | 9255.1 |
610 | 2024-03-31 08:13:16 | solar | 1 | 28756 | 12 | 0.546 | 52666.7 |
609 | 2024-03-26 22:33:40 | solar | 1 | 28756 | 12 | 1.800 | 15975.6 |
608 | 2024-03-01 03:07:14 | solar | 1 | 28756 | 12 | 0.530 | 54256.6 |
607 | 2024-02-25 18:11:13 | solar | 1 | 28756 | 12 | 0.783 | 36725.4 |
606 | 2024-02-12 07:27:15 | solar | 1 | 28756 | 12 | 0.516 | 55728.7 |
605 | 2024-02-07 22:16:05 | solar | 1 | 28756 | 12 | 1.076 | 26724.9 |
604 | 2024-02-04 02:55:02 | solar | 1 | 28756 | 12 | 0.580 | 49579.3 |
603 | 2024-02-02 19:50:43 | solar | 1 | 28756 | 12 | 0.513 | 56054.6 |
602 | 2024-01-26 05:55:21 | solar | 1 | 28756 | 12 | 0.500 | 57512.0 |
601 | 2024-01-20 08:40:30 | solar | 1 | 28756 | 12 | 0.516 | 55728.7 |
600 | 2023-12-21 21:08:54 | solar | 2 | 53800 | 148 | 1.690 | 31834.3 |
599 | 2023-12-05 21:57:07 | solar | 2 | 53800 | 148 | 1.876 | 28678.0 |
598 | 2023-12-01 14:24:05 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
597 | 2023-12-01 10:40:14 | solar | 2 | 53800 | 148 | 1.440 | 37361.1 |
596 | 2023-11-12 04:26:41 | solar | 1 | 28756 | 12 | 0.530 | 54256.6 |
595 | 2023-11-10 13:12:43 | solar | 1 | 28756 | 12 | 0.500 | 57512.0 |
594 | 2023-11-08 11:50:27 | solar | 1 | 28756 | 12 | 0.470 | 61183.0 |
593 | 2023-10-28 03:13:27 | solar | 1 | 28756 | 12 | 0.470 | 61183.0 |
592 | 2023-10-20 06:39:09 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
591 | 2023-10-18 01:55:35 | solar | 1 | 28756 | 12 | 0.450 | 63902.2 |
590 | 2023-10-17 14:08:06 | solar | 2 | 53800 | 148 | 1.560 | 34487.2 |
589 | 2023-10-11 00:14:13 | solar | 1 | 28756 | 12 | 0.466 | 61708.2 |
588 | 2023-10-09 03:22:15 | solar | 1 | 28756 | 12 | 0.450 | 63902.2 |
587 | 2023-10-04 13:51:23 | solar | 1 | 28756 | 12 | 0.500 | 57512.0 |
586 | 2023-09-29 01:17:28 | solar | 2 | 53800 | 148 | 1.470 | 36598.6 |
585 | 2023-09-25 06:59:56 | solar | 2 | 53800 | 148 | 1.610 | 33416.1 |
584 | 2023-09-24 09:14:19 | solar | 1 | 28756 | 12 | 0.580 | 49579.3 |
583 | 2023-09-19 13:30:55 | solar | 1 | 28756 | 12 | 0.483 | 59536.2 |
582 | 2023-09-16 09:32:46 | solar | 1 | 28756 | 12 | 0.500 | 57512.0 |
581 | 2023-07-07 12:49:10 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
580 | 2023-06-15 16:15:28 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
579 | 2023-02-24 09:39:40 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
578 | 2023-02-21 01:24:57 | solar | 1 | 28756 | 12 | 0.436 | 65954.1 |
577 | 2023-01-17 08:22:22 | solar | 1 | 28756 | 12 | 0.546 | 52666.7 |
576 | 2022-10-27 19:48:35 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
575 | 2022-10-24 06:07:54 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
574 | 2022-07-29 08:52:52 | solar | 1 | 28756 | 12 | 0.486 | 59168.7 |
573 | 2022-07-04 11:54:00 | solar | 1 | 28756 | 12 | 0.516 | 55728.7 |
572 | 2022-05-27 07:02:59 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
571 | 2022-04-26 06:22:37 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
570 | 2022-03-13 20:01:34 | solar | 1 | 28756 | 12 | 0.546 | 52666.7 |
569 | 2022-02-01 17:44:24 | solar | 1 | 28756 | 12 | 0.530 | 54256.6 |
568 | 2021-12-22 22:50:57 | solar | 1 | 28756 | 12 | 0.486 | 59168.7 |
567 | 2021-11-26 16:51:44 | solar | 1 | 28756 | 12 | 0.513 | 56054.6 |
566 | 2021-10-27 20:22:06 | solar | 1 | 28756 | 12 | 0.640 | 44931.3 |
565 | 2021-10-25 19:28:35 | solar | 1 | 28756 | 12 | 0.516 | 55728.7 |
564 | 2021-09-13 22:05:48 | solar | 1 | 28756 | 12 | 0.533 | 53951.2 |
563 | 2021-08-25 03:03:30 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
562 | 2021-08-20 09:32:20 | solar | 1 | 28756 | 12 | 0.466 | 61708.2 |
561 | 2021-06-16 21:10:58 | solar | 1 | 28756 | 12 | 0.500 | 57512.0 |
560 | 2021-05-19 17:26:15 | solar | 1 | 28756 | 12 | 0.470 | 61183.0 |
559 | 2021-03-29 09:09:50 | solar | 1 | 28756 | 12 | 0.516 | 55728.7 |
558 | 2021-02-16 20:29:06 | solar | 1 | 28756 | 12 | 0.470 | 61183.0 |
557 | 2021-01-10 21:55:19 | solar | 1 | 28756 | 12 | 0.470 | 61183.0 |
556 | 2020-11-17 15:12:39 | solar | 1 | 28756 | 12 | 0.466 | 61708.2 |
555 | 2020-11-05 02:09:10 | solar | 1 | 28756 | 12 | 0.876 | 32826.5 |
554 | 2020-11-03 00:12:13 | solar | 1 | 28756 | 12 | 0.546 | 52666.7 |
553 | 2020-09-29 01:48:57 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
552 | 2020-09-20 04:07:56 | solar | 1 | 28756 | 12 | 0.440 | 65354.5 |
551 | 2020-08-07 20:11:31 | solar | 1 | 28756 | 12 | 0.470 | 61183.0 |
550 | 2020-08-02 20:01:21 | solar | 1 | 28756 | 12 | 0.580 | 49579.3 |
549 | 2020-07-20 08:06:59 | solar | 1 | 28756 | 12 | 0.546 | 52666.7 |
548 | 2020-07-18 11:20:46 | solar | 1 | 28756 | 12 | 0.500 | 57512.0 |
547 | 2020-07-17 11:28:18 | solar | 1 | 28756 | 12 | 0.483 | 59536.2 |
546 | 2020-06-18 11:31:01 | solar | 1 | 28756 | 12 | 0.483 | 59536.2 |
545 | 2020-06-12 03:08:07 | solar | 1 | 28756 | 12 | 0.533 | 53951.2 |
544 | 2020-06-06 06:11:27 | solar | 1 | 28756 | 12 | 0.466 | 61708.2 |
543 | 2020-05-04 12:55:27 | solar | 1 | 28756 | 12 | 0.466 | 61708.2 |
542 | 2020-03-29 23:32:26 | solar | 1 | 28756 | 12 | 0.500 | 57512.0 |
541 | 2020-03-26 00:29:01 | solar | 1 | 28756 | 12 | 0.530 | 54256.6 |
540 | 2020-03-24 12:01:38 | solar | 1 | 28756 | 12 | 0.533 | 53951.2 |
539 | 2020-03-23 14:39:06 | solar | 1 | 28756 | 12 | 0.550 | 52283.6 |
538 | 2020-03-22 09:07:22 | solar | 1 | 28756 | 12 | 0.533 | 53951.2 |
537 | 2020-03-22 04:36:27 | solar | 1 | 28756 | 12 | 0.560 | 51350.0 |
536 | 2020-03-20 17:01:56 | solar | 1 | 28756 | 12 | 0.453 | 63479.0 |
535 | 2020-03-19 00:29:28 | solar | 1 | 28756 | 12 | 0.466 | 61708.2 |
534 | 2020-03-18 19:30:43 | solar | 1 | 28756 | 12 | 0.486 | 59168.7 |
533 | 2020-03-17 22:44:23 | solar | 1 | 28756 | 12 | 0.500 | 57512.0 |
532 | 2020-03-16 16:29:58 | solar | 1 | 28756 | 12 | 0.513 | 56054.6 |
531 | 2020-03-13 13:46:57 | solar | 1 | 28756 | 12 | 0.470 | 61183.0 |
530 | 2020-02-29 10:21:35 | solar | 1 | 28756 | 12 | 1.093 | 26309.2 |
529 | 2020-02-21 12:27:34 | solar | 1 | 28756 | 12 | 1.063 | 27051.7 |
528 | 2020-02-21 12:24:59 | solar | 1 | 28756 | 12 | 0.546 | 52666.7 |
527 | 2020-02-20 10:32:11 | solar | 1 | 28756 | 12 | 0.576 | 49923.6 |
526 | 2020-02-16 23:23:07 | solar | 1 | 28756 | 12 | 1.203 | 23903.6 |
525 | 2020-02-12 10:58:55 | solar | 1 | 28756 | 12 | 0.610 | 47141.0 |
524 | 2020-02-09 08:38:08 | solar | 1 | 28756 | 12 | 0.576 | 49923.6 |
523 | 2020-02-07 01:09:34 | solar | 1 | 28756 | 12 | 1.123 | 25606.4 |
522 | 2020-02-05 22:13:01 | solar | 1 | 28756 | 12 | 0.563 | 51076.4 |
521 | 2020-02-02 07:28:55 | solar | 1 | 28756 | 12 | 0.533 | 53951.2 |
520 | 2020-01-28 08:01:48 | solar | 1 | 28756 | 12 | 0.516 | 55728.7 |
519 | 2020-01-28 03:33:19 | solar | 1 | 28756 | 12 | 0.610 | 47141.0 |
518 | 2020-01-27 08:41:52 | solar | 1 | 28756 | 12 | 1.140 | 25224.6 |
517 | 2020-01-21 00:18:03 | solar | 1 | 28756 | 12 | 0.576 | 49923.6 |
516 | 2020-01-20 22:15:10 | solar | 1 | 28756 | 12 | 0.673 | 42728.1 |
515 | 2020-01-20 10:50:54 | solar | 1 | 28756 | 12 | 1.450 | 19831.7 |