History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bikie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
642 | 2024-04-28 04:00:38 | bikie | 3 | 83667 | 964 | 3.810 | 21959.8 |
641 | 2024-04-27 02:33:09 | bikie | 1 | 28756 | 4 | 1.096 | 26237.2 |
640 | 2024-04-25 13:11:30 | bikie | 3 | 83667 | 964 | 5.596 | 14951.2 |
639 | 2024-04-24 05:22:36 | bikie | 3 | 83667 | 964 | 15.456 | 5413.2 |
638 | 2024-04-17 17:56:25 | bikie | 1 | 28756 | 4 | 0.453 | 63479.0 |
637 | 2024-04-11 04:34:47 | bikie | 1 | 28756 | 4 | 0.513 | 56054.6 |
636 | 2024-04-04 19:54:49 | bikie | 3 | 83667 | 964 | 9.660 | 8661.2 |
635 | 2024-04-04 11:18:45 | bikie | 3 | 83667 | 964 | 4.233 | 19765.4 |
634 | 2024-04-03 19:41:41 | bikie | 2 | 53800 | 58 | 5.423 | 9920.7 |
633 | 2024-04-03 19:14:21 | bikie | 3 | 83667 | 964 | 4.453 | 18788.9 |
632 | 2024-04-03 08:05:33 | bikie | 3 | 83667 | 964 | 8.393 | 9968.7 |
631 | 2024-04-03 08:05:35 | bikie | 2 | 53800 | 58 | 5.563 | 9671.0 |
630 | 2024-04-03 08:05:20 | bikie | 1 | 28756 | 4 | 1.140 | 25224.6 |
629 | 2024-03-30 22:21:06 | bikie | 1 | 28756 | 4 | 0.546 | 52666.7 |
628 | 2024-03-28 20:53:45 | bikie | 2 | 53800 | 58 | 3.376 | 15936.0 |
627 | 2024-03-28 20:53:42 | bikie | 3 | 83667 | 964 | 4.186 | 19987.3 |
626 | 2024-03-28 20:53:32 | bikie | 3 | 83667 | 964 | 8.076 | 10360.0 |
625 | 2024-03-28 20:53:39 | bikie | 1 | 28756 | 4 | 0.516 | 55728.7 |
624 | 2024-03-28 20:53:33 | bikie | 2 | 53800 | 58 | 1.720 | 31279.1 |
623 | 2024-03-28 20:53:31 | bikie | 1 | 28756 | 4 | 0.530 | 54256.6 |
622 | 2024-03-12 19:23:44 | bikie | 1 | 28756 | 4 | 0.450 | 63902.2 |
621 | 2024-03-04 01:10:37 | bikie | 2 | 53800 | 58 | 3.233 | 16640.9 |
620 | 2024-03-04 01:10:26 | bikie | 1 | 28756 | 4 | 0.593 | 48492.4 |
619 | 2024-03-02 18:27:05 | bikie | 3 | 83667 | 964 | 13.660 | 6125.0 |
618 | 2024-03-01 05:44:23 | bikie | 1 | 28756 | 4 | 0.513 | 56054.6 |
617 | 2024-03-01 01:36:37 | bikie | 2 | 53800 | 58 | 3.076 | 17490.2 |
616 | 2024-03-01 01:36:09 | bikie | 3 | 83667 | 964 | 4.173 | 20049.6 |
615 | 2024-02-27 09:48:30 | bikie | 2 | 53800 | 58 | 1.750 | 30742.9 |
614 | 2024-02-27 09:48:04 | bikie | 3 | 83667 | 964 | 4.126 | 20278.0 |
613 | 2024-02-26 10:31:19 | bikie | 3 | 83667 | 964 | 3.890 | 21508.2 |
612 | 2024-02-26 10:31:21 | bikie | 2 | 53800 | 58 | 1.656 | 32487.9 |
611 | 2024-02-26 10:31:18 | bikie | 1 | 28756 | 4 | 0.516 | 55728.7 |
610 | 2024-02-03 00:18:02 | bikie | 1 | 28756 | 4 | 0.516 | 55728.7 |
609 | 2024-01-27 05:21:09 | bikie | 1 | 28756 | 4 | 0.483 | 59536.2 |
608 | 2024-01-24 06:36:49 | bikie | 3 | 83667 | 964 | 3.266 | 25617.6 |
607 | 2024-01-18 02:49:19 | bikie | 2 | 53800 | 58 | 1.423 | 37807.4 |
606 | 2024-01-16 19:25:04 | bikie | 3 | 83667 | 964 | 3.703 | 22594.4 |
605 | 2024-01-16 07:44:54 | bikie | 3 | 83667 | 964 | 3.203 | 26121.4 |
604 | 2024-01-07 17:17:22 | bikie | 1 | 28756 | 4 | 0.453 | 63479.0 |
603 | 2023-12-16 13:04:49 | bikie | 2 | 53800 | 58 | 1.563 | 34421.0 |
602 | 2023-12-10 10:42:57 | bikie | 3 | 83667 | 964 | 3.530 | 23701.7 |
601 | 2023-12-10 10:42:55 | bikie | 2 | 53800 | 58 | 1.406 | 38264.6 |
600 | 2023-12-07 04:05:26 | bikie | 3 | 83667 | 964 | 3.830 | 21845.2 |
599 | 2023-11-26 17:32:19 | bikie | 1 | 28756 | 4 | 0.436 | 65954.1 |
598 | 2023-11-24 15:08:24 | bikie | 1 | 28756 | 4 | 0.453 | 63479.0 |
597 | 2023-11-20 05:24:32 | bikie | 1 | 28756 | 4 | 0.436 | 65954.1 |
596 | 2023-11-15 18:27:01 | bikie | 2 | 53800 | 58 | 1.593 | 33772.8 |
595 | 2023-11-15 18:26:54 | bikie | 3 | 83667 | 964 | 3.670 | 22797.5 |
594 | 2023-11-12 18:45:34 | bikie | 3 | 83667 | 964 | 3.420 | 24464.0 |
593 | 2023-11-12 18:45:33 | bikie | 2 | 53800 | 58 | 1.390 | 38705.0 |
592 | 2023-11-11 08:21:25 | bikie | 1 | 28756 | 4 | 0.453 | 63479.0 |
591 | 2023-11-08 02:36:31 | bikie | 1 | 28756 | 4 | 0.533 | 53951.2 |
590 | 2023-10-29 05:38:30 | bikie | 1 | 28756 | 4 | 0.486 | 59168.7 |
589 | 2023-10-28 20:03:04 | bikie | 2 | 53800 | 58 | 3.203 | 16796.8 |
588 | 2023-10-26 06:38:42 | bikie | 3 | 83667 | 964 | 3.780 | 22134.1 |
587 | 2023-10-25 05:28:13 | bikie | 3 | 83667 | 964 | 3.360 | 24900.9 |
586 | 2023-10-24 04:49:50 | bikie | 3 | 83667 | 964 | 3.766 | 22216.4 |
585 | 2023-10-22 09:45:15 | bikie | 3 | 83667 | 964 | 3.610 | 23176.5 |
584 | 2023-10-22 09:45:11 | bikie | 2 | 53800 | 58 | 1.546 | 34799.5 |
583 | 2023-10-22 05:36:54 | bikie | 1 | 28756 | 4 | 0.436 | 65954.1 |
582 | 2023-10-21 09:06:18 | bikie | 1 | 28756 | 4 | 0.453 | 63479.0 |
581 | 2023-10-17 00:37:33 | bikie | 1 | 28756 | 4 | 0.470 | 61183.0 |
580 | 2023-10-13 17:30:00 | bikie | 1 | 28756 | 4 | 0.500 | 57512.0 |
579 | 2023-10-05 04:13:52 | bikie | 1 | 28756 | 4 | 0.500 | 57512.0 |
578 | 2023-09-26 05:33:06 | bikie | 1 | 28756 | 4 | 0.453 | 63479.0 |
577 | 2023-09-24 15:24:31 | bikie | 1 | 28756 | 4 | 0.500 | 57512.0 |
576 | 2023-09-22 16:52:53 | bikie | 1 | 28756 | 4 | 0.436 | 65954.1 |
575 | 2023-09-12 01:36:21 | bikie | 1 | 28756 | 4 | 0.500 | 57512.0 |
574 | 2023-09-05 00:06:31 | bikie | 3 | 83667 | 964 | 3.876 | 21585.9 |
573 | 2023-09-01 13:00:54 | bikie | 3 | 83667 | 964 | 3.343 | 25027.5 |
572 | 2023-08-06 20:35:27 | bikie | 1 | 28756 | 4 | 0.483 | 59536.2 |
571 | 2023-08-06 05:20:50 | bikie | 2 | 53800 | 58 | 1.423 | 37807.4 |
570 | 2023-07-18 04:05:56 | bikie | 3 | 83667 | 964 | 3.360 | 24900.9 |
569 | 2023-07-16 19:25:33 | bikie | 1 | 28756 | 4 | 0.486 | 59168.7 |
568 | 2023-07-12 22:18:04 | bikie | 1 | 28756 | 4 | 0.436 | 65954.1 |
567 | 2023-07-01 13:41:49 | bikie | 1 | 28756 | 4 | 0.436 | 65954.1 |
566 | 2023-06-27 01:52:12 | bikie | 1 | 28756 | 4 | 0.436 | 65954.1 |
565 | 2023-05-25 08:29:42 | bikie | 3 | 83667 | 964 | 3.903 | 21436.6 |
564 | 2023-05-20 15:01:27 | bikie | 3 | 83667 | 964 | 3.203 | 26121.4 |
563 | 2023-05-18 00:23:03 | bikie | 3 | 83667 | 964 | 3.626 | 23074.2 |
562 | 2023-04-30 21:34:01 | bikie | 3 | 83667 | 964 | 3.236 | 25855.1 |
561 | 2023-04-18 01:55:26 | bikie | 2 | 53800 | 58 | 1.310 | 41068.7 |
560 | 2023-04-06 04:17:06 | bikie | 1 | 28756 | 4 | 0.420 | 68466.7 |
559 | 2023-04-05 08:53:11 | bikie | 1 | 28756 | 4 | 0.436 | 65954.1 |
558 | 2023-04-02 16:23:09 | bikie | 1 | 28756 | 4 | 0.453 | 63479.0 |
557 | 2023-03-28 07:30:59 | bikie | 3 | 83667 | 964 | 3.906 | 21420.1 |
556 | 2023-03-15 15:24:06 | bikie | 3 | 83667 | 964 | 3.280 | 25508.2 |
555 | 2023-02-27 13:34:13 | bikie | 3 | 83667 | 964 | 3.173 | 26368.4 |
554 | 2023-02-11 21:00:54 | bikie | 3 | 83667 | 964 | 3.343 | 25027.5 |
553 | 2023-01-26 08:48:19 | bikie | 2 | 53800 | 58 | 1.516 | 35488.1 |
552 | 2023-01-21 12:12:28 | bikie | 3 | 83667 | 964 | 3.623 | 23093.3 |
551 | 2023-01-21 10:24:44 | bikie | 1 | 28756 | 4 | 0.440 | 65354.5 |
550 | 2023-01-20 03:54:38 | bikie | 3 | 83667 | 964 | 3.703 | 22594.4 |
549 | 2023-01-18 11:02:52 | bikie | 2 | 53800 | 58 | 1.343 | 40059.6 |
548 | 2023-01-16 13:53:37 | bikie | 3 | 83667 | 964 | 3.466 | 24139.4 |
547 | 2022-12-27 10:12:10 | bikie | 1 | 28756 | 4 | 0.440 | 65354.5 |
546 | 2022-12-15 08:16:47 | bikie | 2 | 53800 | 58 | 1.373 | 39184.3 |
545 | 2022-12-06 13:55:39 | bikie | 3 | 83667 | 964 | 3.220 | 25983.5 |
544 | 2022-11-25 04:56:49 | bikie | 1 | 28756 | 4 | 0.483 | 59536.2 |
543 | 2022-11-18 22:39:30 | bikie | 1 | 28756 | 4 | 0.486 | 59168.7 |