History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roysters"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
627 | 2024-04-16 20:21:46 | roysters | 1 | 82945 | 8 | 5.936 | 13973.2 |
626 | 2024-04-11 04:58:48 | roysters | 3 | 146162 | 353 | 8.173 | 17883.5 |
625 | 2024-04-07 15:34:17 | roysters | 3 | 146162 | 353 | 22.280 | 6560.2 |
624 | 2024-04-07 15:34:16 | roysters | 2 | 121059 | 44 | 9.093 | 13313.4 |
623 | 2024-04-07 15:34:16 | roysters | 1 | 82945 | 8 | 3.296 | 25165.4 |
622 | 2024-04-06 15:29:18 | roysters | 1 | 82945 | 8 | 3.236 | 25632.0 |
621 | 2024-03-31 23:59:43 | roysters | 3 | 146162 | 353 | 22.907 | 6380.7 |
620 | 2024-03-30 21:12:28 | roysters | 3 | 146162 | 353 | 22.876 | 6389.3 |
619 | 2024-03-30 19:48:40 | roysters | 3 | 146162 | 353 | 24.206 | 6038.3 |
618 | 2024-03-30 18:35:22 | roysters | 1 | 82945 | 8 | 4.970 | 16689.1 |
617 | 2024-03-30 18:35:09 | roysters | 2 | 121059 | 44 | 4.436 | 27290.1 |
616 | 2024-03-30 06:53:37 | roysters | 3 | 146162 | 353 | 14.576 | 10027.6 |
615 | 2024-03-30 05:58:16 | roysters | 3 | 146162 | 353 | 21.516 | 6793.2 |
614 | 2024-03-30 05:58:12 | roysters | 2 | 121059 | 44 | 7.033 | 17213.0 |
613 | 2024-03-30 05:49:34 | roysters | 1 | 82945 | 8 | 1.623 | 51106.0 |
612 | 2024-02-28 10:44:56 | roysters | 1 | 82945 | 8 | 1.546 | 53651.4 |
611 | 2024-02-28 05:28:08 | roysters | 1 | 82945 | 8 | 4.030 | 20581.9 |
610 | 2024-02-18 07:12:26 | roysters | 3 | 146162 | 353 | 25.843 | 5655.8 |
609 | 2024-02-15 05:41:35 | roysters | 3 | 146162 | 353 | 6.453 | 22650.2 |
608 | 2024-02-05 06:27:55 | roysters | 3 | 146162 | 353 | 14.423 | 10134.0 |
607 | 2024-02-04 20:25:04 | roysters | 3 | 146162 | 353 | 14.266 | 10245.5 |
606 | 2024-01-28 10:42:45 | roysters | 1 | 82945 | 8 | 1.453 | 57085.3 |
605 | 2024-01-27 17:43:46 | roysters | 3 | 146162 | 353 | 12.033 | 12146.8 |
604 | 2024-01-26 20:22:57 | roysters | 1 | 82945 | 8 | 1.313 | 63172.1 |
603 | 2024-01-23 07:14:19 | roysters | 3 | 146162 | 353 | 8.550 | 17095.0 |
602 | 2024-01-16 12:02:56 | roysters | 2 | 121059 | 44 | 3.516 | 34430.9 |
601 | 2024-01-16 12:02:51 | roysters | 3 | 146162 | 353 | 7.110 | 20557.2 |
600 | 2024-01-15 07:24:56 | roysters | 3 | 146162 | 353 | 7.186 | 20339.8 |
599 | 2024-01-09 16:43:52 | roysters | 1 | 82945 | 8 | 1.483 | 55930.5 |
598 | 2023-12-26 07:38:07 | roysters | 1 | 82945 | 8 | 1.296 | 64000.8 |
597 | 2023-12-22 07:22:18 | roysters | 1 | 82945 | 8 | 1.390 | 59672.7 |
596 | 2023-11-18 23:10:15 | roysters | 1 | 82945 | 8 | 1.483 | 55930.5 |
595 | 2023-11-16 17:16:56 | roysters | 1 | 82945 | 8 | 1.296 | 64000.8 |
594 | 2023-11-16 16:31:53 | roysters | 1 | 82945 | 8 | 1.390 | 59672.7 |
593 | 2023-11-02 11:49:54 | roysters | 3 | 146162 | 353 | 17.563 | 8322.2 |
592 | 2023-10-25 08:15:24 | roysters | 3 | 146162 | 353 | 6.326 | 23105.0 |
591 | 2023-10-24 23:05:05 | roysters | 1 | 82945 | 8 | 1.716 | 48336.2 |
590 | 2023-10-17 06:35:13 | roysters | 1 | 82945 | 8 | 1.313 | 63172.1 |
589 | 2023-09-25 00:47:11 | roysters | 1 | 82945 | 8 | 1.516 | 54713.1 |
588 | 2023-09-04 00:59:42 | roysters | 3 | 146162 | 353 | 6.220 | 23498.7 |
587 | 2023-08-23 10:59:47 | roysters | 1 | 82945 | 8 | 1.436 | 57761.1 |
586 | 2023-08-16 06:56:29 | roysters | 1 | 82945 | 8 | 1.436 | 57761.1 |
585 | 2023-08-11 12:21:41 | roysters | 3 | 146162 | 353 | 6.956 | 21012.4 |
584 | 2023-08-03 17:31:53 | roysters | 3 | 146162 | 353 | 6.310 | 23163.5 |
583 | 2023-04-20 21:42:33 | roysters | 3 | 146162 | 353 | 6.656 | 21959.4 |
582 | 2023-04-20 18:01:13 | roysters | 1 | 82945 | 8 | 1.280 | 64800.8 |
581 | 2023-04-15 20:30:42 | roysters | 3 | 146162 | 353 | 6.096 | 23976.7 |
580 | 2023-03-21 04:10:48 | roysters | 3 | 146162 | 353 | 7.330 | 19940.2 |
579 | 2023-03-20 04:52:15 | roysters | 1 | 82945 | 8 | 1.250 | 66356.0 |
578 | 2023-03-19 02:59:34 | roysters | 1 | 82945 | 8 | 1.250 | 66356.0 |
577 | 2023-02-03 04:26:53 | roysters | 3 | 146162 | 353 | 6.373 | 22934.6 |
576 | 2023-01-29 07:23:51 | roysters | 1 | 82945 | 8 | 1.610 | 51518.6 |
575 | 2023-01-23 02:25:50 | roysters | 3 | 146162 | 353 | 6.156 | 23743.0 |
574 | 2023-01-06 14:11:47 | roysters | 3 | 146162 | 353 | 7.313 | 19986.6 |
573 | 2022-12-24 11:20:18 | roysters | 1 | 82945 | 8 | 1.376 | 60279.8 |
572 | 2022-12-14 11:34:16 | roysters | 1 | 82945 | 8 | 1.483 | 55930.5 |
571 | 2022-11-25 12:52:46 | roysters | 3 | 146162 | 353 | 7.516 | 19446.8 |
570 | 2022-11-23 23:27:50 | roysters | 1 | 82945 | 8 | 1.280 | 64800.8 |
569 | 2022-11-22 12:25:11 | roysters | 3 | 146162 | 353 | 7.110 | 20557.2 |
568 | 2022-11-09 21:54:42 | roysters | 1 | 82945 | 8 | 1.266 | 65517.4 |
567 | 2022-11-03 22:24:28 | roysters | 3 | 146162 | 353 | 6.343 | 23043.0 |
566 | 2022-10-31 01:52:28 | roysters | 3 | 146162 | 353 | 6.906 | 21164.5 |
565 | 2022-10-29 07:43:34 | roysters | 3 | 146162 | 353 | 7.093 | 20606.5 |
564 | 2022-10-29 07:09:59 | roysters | 3 | 146162 | 353 | 6.313 | 23152.5 |
563 | 2022-08-26 14:19:33 | roysters | 3 | 146162 | 353 | 7.500 | 19488.3 |
562 | 2022-08-17 05:41:53 | roysters | 1 | 82945 | 8 | 1.420 | 58412.0 |
561 | 2022-08-13 01:43:57 | roysters | 1 | 82945 | 8 | 1.313 | 63172.1 |
560 | 2022-07-28 22:36:28 | roysters | 3 | 146162 | 353 | 6.186 | 23627.9 |
559 | 2022-06-28 00:04:06 | roysters | 1 | 82945 | 8 | 1.343 | 61761.0 |
558 | 2022-06-26 19:16:03 | roysters | 3 | 146162 | 353 | 6.843 | 21359.3 |
557 | 2022-06-13 07:09:28 | roysters | 3 | 146162 | 353 | 6.423 | 22756.0 |
556 | 2022-06-05 06:32:26 | roysters | 3 | 146162 | 353 | 6.406 | 22816.4 |
555 | 2022-05-10 04:41:30 | roysters | 1 | 82945 | 8 | 1.936 | 42843.5 |
554 | 2022-04-22 14:19:50 | roysters | 1 | 82945 | 8 | 2.080 | 39877.4 |
553 | 2022-04-09 17:01:39 | roysters | 1 | 82945 | 8 | 1.466 | 56579.1 |
552 | 2022-04-02 03:25:50 | roysters | 1 | 82945 | 8 | 1.266 | 65517.4 |
551 | 2022-03-30 22:53:55 | roysters | 1 | 82945 | 8 | 1.436 | 57761.1 |
550 | 2022-01-26 14:06:02 | roysters | 3 | 146162 | 353 | 7.063 | 20694.0 |
549 | 2022-01-03 17:47:26 | roysters | 1 | 82945 | 8 | 1.360 | 60989.0 |
548 | 2021-12-23 09:49:31 | roysters | 3 | 146162 | 353 | 7.716 | 18942.7 |
547 | 2021-12-19 03:11:05 | roysters | 1 | 82945 | 8 | 1.346 | 61623.3 |
546 | 2021-12-17 06:19:23 | roysters | 1 | 82945 | 8 | 1.326 | 62552.8 |
545 | 2021-12-04 20:48:46 | roysters | 3 | 146162 | 353 | 7.126 | 20511.1 |
544 | 2021-12-01 03:44:23 | roysters | 3 | 146162 | 353 | 7.123 | 20519.7 |
543 | 2021-11-23 10:02:57 | roysters | 1 | 82945 | 8 | 1.436 | 57761.1 |
542 | 2021-11-15 16:17:10 | roysters | 3 | 146162 | 353 | 8.673 | 16852.5 |
541 | 2021-11-15 07:58:21 | roysters | 3 | 146162 | 353 | 6.406 | 22816.4 |
540 | 2021-11-14 15:43:10 | roysters | 3 | 146162 | 353 | 13.326 | 10968.2 |
539 | 2021-11-14 07:26:19 | roysters | 3 | 146162 | 353 | 7.203 | 20291.8 |
538 | 2021-11-13 17:15:08 | roysters | 3 | 146162 | 353 | 7.220 | 20244.0 |
537 | 2021-11-13 08:56:32 | roysters | 3 | 146162 | 353 | 7.876 | 18557.9 |
536 | 2021-11-12 19:50:27 | roysters | 3 | 146162 | 353 | 13.766 | 10617.6 |
535 | 2021-11-12 06:21:23 | roysters | 3 | 146162 | 353 | 6.390 | 22873.6 |
534 | 2021-11-11 12:57:13 | roysters | 3 | 146162 | 353 | 7.326 | 19951.1 |
533 | 2021-11-08 05:22:38 | roysters | 1 | 82945 | 8 | 1.280 | 64800.8 |
532 | 2021-11-07 10:49:01 | roysters | 3 | 146162 | 353 | 6.843 | 21359.3 |
531 | 2021-11-06 04:01:34 | roysters | 1 | 82945 | 8 | 1.423 | 58288.8 |
530 | 2021-11-05 00:12:02 | roysters | 3 | 146162 | 353 | 7.140 | 20470.9 |
529 | 2021-11-01 21:18:09 | roysters | 3 | 146162 | 353 | 11.000 | 13287.5 |
528 | 2021-10-30 16:52:10 | roysters | 3 | 146162 | 353 | 6.343 | 23043.0 |