History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gilds"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
645 | 2024-04-30 11:00:20 | gilds | 1 | 28756 | 12 | 1.643 | 17502.1 |
644 | 2024-04-29 16:18:21 | gilds | 1 | 28756 | 12 | 0.800 | 35945.0 |
643 | 2024-04-28 11:07:00 | gilds | 1 | 28756 | 12 | 0.513 | 56054.6 |
642 | 2024-04-28 08:39:38 | gilds | 1 | 28756 | 12 | 1.110 | 25906.3 |
641 | 2024-04-26 20:09:10 | gilds | 1 | 28756 | 12 | 0.500 | 57512.0 |
640 | 2024-04-17 10:45:44 | gilds | 1 | 28756 | 12 | 0.500 | 57512.0 |
639 | 2024-04-02 22:42:22 | gilds | 2 | 53800 | 173 | 5.530 | 9728.8 |
638 | 2024-04-02 21:08:36 | gilds | 1 | 28756 | 12 | 0.423 | 67981.1 |
637 | 2024-03-31 07:27:23 | gilds | 1 | 28756 | 12 | 0.483 | 59536.2 |
636 | 2024-03-27 03:18:56 | gilds | 1 | 28756 | 12 | 1.703 | 16885.5 |
635 | 2024-03-01 02:48:24 | gilds | 1 | 28756 | 12 | 0.483 | 59536.2 |
634 | 2024-02-25 17:59:37 | gilds | 1 | 28756 | 12 | 0.470 | 61183.0 |
633 | 2024-01-24 12:41:30 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
632 | 2023-12-31 10:33:29 | gilds | 2 | 53800 | 173 | 1.390 | 38705.0 |
631 | 2023-12-30 04:42:30 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
630 | 2023-12-29 17:04:16 | gilds | 2 | 53800 | 173 | 1.373 | 39184.3 |
629 | 2023-12-26 15:11:53 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
628 | 2023-12-19 18:31:51 | gilds | 1 | 28756 | 12 | 0.450 | 63902.2 |
627 | 2023-12-19 12:41:47 | gilds | 1 | 28756 | 12 | 0.483 | 59536.2 |
626 | 2023-12-07 16:00:41 | gilds | 1 | 28756 | 12 | 0.500 | 57512.0 |
625 | 2023-12-07 16:00:40 | gilds | 1 | 28756 | 12 | 0.500 | 57512.0 |
624 | 2023-11-13 22:56:13 | gilds | 1 | 28756 | 12 | 0.533 | 53951.2 |
623 | 2023-11-13 15:44:44 | gilds | 1 | 28756 | 12 | 0.483 | 59536.2 |
622 | 2023-10-30 02:02:34 | gilds | 2 | 53800 | 173 | 1.343 | 40059.6 |
621 | 2023-10-29 01:11:20 | gilds | 1 | 28756 | 12 | 0.483 | 59536.2 |
620 | 2023-10-25 22:47:36 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
619 | 2023-10-19 21:59:39 | gilds | 1 | 28756 | 12 | 0.440 | 65354.5 |
618 | 2023-10-19 04:24:31 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
617 | 2023-10-11 09:30:59 | gilds | 1 | 28756 | 12 | 0.486 | 59168.7 |
616 | 2023-10-05 04:15:37 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
615 | 2023-09-28 23:50:59 | gilds | 1 | 28756 | 12 | 1.000 | 28756.0 |
614 | 2023-09-24 14:12:07 | gilds | 1 | 28756 | 12 | 0.483 | 59536.2 |
613 | 2023-09-02 14:24:22 | gilds | 1 | 28756 | 12 | 0.440 | 65354.5 |
612 | 2023-08-14 19:16:12 | gilds | 1 | 28756 | 12 | 0.500 | 57512.0 |
611 | 2023-05-20 04:31:14 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
610 | 2023-05-18 02:08:28 | gilds | 1 | 28756 | 12 | 0.486 | 59168.7 |
609 | 2023-03-13 22:34:07 | gilds | 1 | 28756 | 12 | 0.423 | 67981.1 |
608 | 2023-02-06 22:12:39 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
607 | 2023-01-03 05:32:53 | gilds | 1 | 28756 | 12 | 0.483 | 59536.2 |
606 | 2022-10-16 21:15:37 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
605 | 2022-09-26 01:14:10 | gilds | 1 | 28756 | 12 | 0.500 | 57512.0 |
604 | 2022-06-26 14:01:21 | gilds | 1 | 28756 | 12 | 0.423 | 67981.1 |
603 | 2022-06-22 19:19:18 | gilds | 1 | 28756 | 12 | 0.423 | 67981.1 |
602 | 2022-05-09 22:16:30 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
601 | 2022-03-10 05:39:23 | gilds | 1 | 28756 | 12 | 0.440 | 65354.5 |
600 | 2022-03-06 21:04:41 | gilds | 1 | 28756 | 12 | 0.500 | 57512.0 |
599 | 2022-01-26 20:09:18 | gilds | 1 | 28756 | 12 | 0.533 | 53951.2 |
598 | 2021-11-26 12:50:30 | gilds | 1 | 28756 | 12 | 0.486 | 59168.7 |
597 | 2021-11-20 01:27:33 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
596 | 2021-10-03 15:43:34 | gilds | 1 | 28756 | 12 | 0.500 | 57512.0 |
595 | 2021-10-01 13:10:38 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
594 | 2021-08-25 17:01:04 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
593 | 2021-08-23 13:38:02 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
592 | 2021-08-20 05:29:06 | gilds | 1 | 28756 | 12 | 0.470 | 61183.0 |
591 | 2021-05-30 05:17:53 | gilds | 1 | 28756 | 12 | 0.546 | 52666.7 |
590 | 2021-05-19 12:15:02 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
589 | 2021-05-04 21:07:37 | gilds | 1 | 28756 | 12 | 0.500 | 57512.0 |
588 | 2021-05-04 01:52:13 | gilds | 2 | 53800 | 173 | 1.546 | 34799.5 |
587 | 2021-04-02 23:28:15 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
586 | 2021-02-21 06:20:49 | gilds | 1 | 28756 | 12 | 0.500 | 57512.0 |
585 | 2021-02-16 14:45:50 | gilds | 1 | 28756 | 12 | 0.563 | 51076.4 |
584 | 2021-02-02 05:45:16 | gilds | 1 | 28756 | 12 | 0.466 | 61708.2 |
583 | 2021-01-17 22:26:20 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
582 | 2021-01-17 06:36:06 | gilds | 2 | 53800 | 173 | 1.360 | 39558.8 |
581 | 2020-11-23 14:49:40 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
580 | 2020-11-17 10:05:40 | gilds | 1 | 28756 | 12 | 0.440 | 65354.5 |
579 | 2020-10-28 15:53:28 | gilds | 2 | 53800 | 173 | 1.580 | 34050.6 |
578 | 2020-10-27 11:39:39 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
577 | 2020-10-24 12:17:57 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
576 | 2020-09-26 05:12:19 | gilds | 1 | 28756 | 12 | 0.440 | 65354.5 |
575 | 2020-08-14 18:49:01 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
574 | 2020-08-13 02:41:20 | gilds | 1 | 28756 | 12 | 0.470 | 61183.0 |
573 | 2020-08-09 04:12:44 | gilds | 1 | 28756 | 12 | 1.000 | 28756.0 |
572 | 2020-08-09 01:23:24 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
571 | 2020-08-03 03:32:12 | gilds | 1 | 28756 | 12 | 0.483 | 59536.2 |
570 | 2020-08-02 11:21:59 | gilds | 1 | 28756 | 12 | 0.563 | 51076.4 |
569 | 2020-07-31 10:06:37 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
568 | 2020-07-18 14:29:31 | gilds | 1 | 28756 | 12 | 0.483 | 59536.2 |
567 | 2020-07-17 12:51:29 | gilds | 1 | 28756 | 12 | 0.456 | 63061.4 |
566 | 2020-07-16 12:18:38 | gilds | 1 | 28756 | 12 | 0.466 | 61708.2 |
565 | 2020-07-14 03:30:13 | gilds | 1 | 28756 | 12 | 0.453 | 63479.0 |
564 | 2020-07-13 03:08:21 | gilds | 1 | 28756 | 12 | 0.470 | 61183.0 |
563 | 2020-06-13 18:20:01 | gilds | 1 | 28756 | 12 | 0.440 | 65354.5 |
562 | 2020-05-13 13:58:03 | gilds | 1 | 28756 | 12 | 0.440 | 65354.5 |
561 | 2020-03-26 00:33:24 | gilds | 1 | 28756 | 12 | 0.470 | 61183.0 |
560 | 2020-03-25 09:02:49 | gilds | 1 | 28756 | 12 | 0.516 | 55728.7 |
559 | 2020-03-22 21:00:54 | gilds | 1 | 28756 | 12 | 0.486 | 59168.7 |
558 | 2020-03-22 10:56:18 | gilds | 1 | 28756 | 12 | 0.483 | 59536.2 |
557 | 2020-03-21 13:12:30 | gilds | 1 | 28756 | 12 | 0.516 | 55728.7 |
556 | 2020-03-18 21:20:58 | gilds | 1 | 28756 | 12 | 0.436 | 65954.1 |
555 | 2020-03-18 14:38:32 | gilds | 1 | 28756 | 12 | 0.500 | 57512.0 |
554 | 2020-03-02 22:31:09 | gilds | 2 | 53800 | 173 | 1.656 | 32487.9 |
553 | 2020-02-26 21:37:43 | gilds | 1 | 28756 | 12 | 0.653 | 44036.8 |
552 | 2020-02-26 19:30:22 | gilds | 1 | 28756 | 12 | 0.563 | 51076.4 |
551 | 2020-02-21 12:38:54 | gilds | 1 | 28756 | 12 | 1.486 | 19351.3 |
550 | 2020-02-14 05:17:41 | gilds | 1 | 28756 | 12 | 0.563 | 51076.4 |
549 | 2020-02-11 06:14:05 | gilds | 1 | 28756 | 12 | 0.516 | 55728.7 |
548 | 2020-02-10 23:16:38 | gilds | 1 | 28756 | 12 | 0.533 | 53951.2 |
547 | 2020-02-02 00:40:52 | gilds | 1 | 28756 | 12 | 0.530 | 54256.6 |
546 | 2020-01-31 16:55:23 | gilds | 1 | 28756 | 12 | 1.376 | 20898.3 |