History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"emitters"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
614 | 2024-05-04 22:02:13 | emitters | 1 | 82945 | 5 | 1.626 | 51011.7 |
613 | 2024-05-04 10:37:01 | emitters | 2 | 121059 | 50 | 4.143 | 29220.1 |
612 | 2024-05-04 10:36:41 | emitters | 3 | 146162 | 358 | 7.860 | 18595.7 |
611 | 2024-05-01 23:08:38 | emitters | 2 | 121059 | 50 | 3.606 | 33571.5 |
610 | 2024-05-01 00:22:10 | emitters | 2 | 121059 | 50 | 7.876 | 15370.6 |
609 | 2024-04-30 08:07:53 | emitters | 3 | 146162 | 358 | 10.283 | 14213.9 |
608 | 2024-04-28 16:05:34 | emitters | 2 | 121059 | 50 | 4.203 | 28803.0 |
607 | 2024-04-28 16:05:09 | emitters | 3 | 146162 | 358 | 7.936 | 18417.6 |
606 | 2024-04-27 21:32:08 | emitters | 2 | 121059 | 50 | 8.986 | 13472.0 |
605 | 2024-04-27 21:30:22 | emitters | 1 | 82945 | 5 | 2.483 | 33405.2 |
604 | 2024-04-27 15:02:22 | emitters | 3 | 146162 | 358 | 7.623 | 19173.8 |
603 | 2024-04-27 13:53:10 | emitters | 3 | 146162 | 358 | 12.970 | 11269.2 |
602 | 2024-04-27 08:59:46 | emitters | 3 | 146162 | 358 | 9.766 | 14966.4 |
601 | 2024-04-06 10:27:29 | emitters | 1 | 82945 | 5 | 3.953 | 20982.8 |
600 | 2024-03-29 23:45:40 | emitters | 2 | 121059 | 50 | 4.420 | 27388.9 |
599 | 2024-03-29 21:55:45 | emitters | 1 | 82945 | 5 | 2.953 | 28088.4 |
598 | 2024-03-29 05:50:24 | emitters | 2 | 121059 | 50 | 15.126 | 8003.4 |
597 | 2024-03-28 22:11:00 | emitters | 3 | 146162 | 358 | 12.140 | 12039.7 |
596 | 2024-03-28 11:26:09 | emitters | 1 | 82945 | 5 | 1.533 | 54106.3 |
595 | 2024-03-28 11:25:47 | emitters | 3 | 146162 | 358 | 7.530 | 19410.6 |
594 | 2024-03-28 11:25:47 | emitters | 2 | 121059 | 50 | 3.766 | 32145.2 |
593 | 2024-03-28 11:25:42 | emitters | 1 | 82945 | 5 | 1.483 | 55930.5 |
592 | 2024-03-03 15:26:11 | emitters | 1 | 82945 | 5 | 4.763 | 17414.4 |
591 | 2024-02-28 12:35:50 | emitters | 1 | 82945 | 5 | 2.170 | 38223.5 |
590 | 2024-02-08 09:56:09 | emitters | 2 | 121059 | 50 | 11.110 | 10896.4 |
589 | 2024-02-05 04:12:14 | emitters | 2 | 121059 | 50 | 7.860 | 15401.9 |
588 | 2024-02-05 04:11:53 | emitters | 3 | 146162 | 358 | 8.076 | 18098.3 |
587 | 2024-02-04 21:19:50 | emitters | 2 | 121059 | 50 | 4.016 | 30144.2 |
586 | 2024-02-04 06:46:42 | emitters | 2 | 121059 | 50 | 6.436 | 18809.7 |
585 | 2024-02-03 16:56:54 | emitters | 3 | 146162 | 358 | 6.736 | 21698.6 |
584 | 2024-01-21 12:07:05 | emitters | 3 | 146162 | 358 | 6.483 | 22545.4 |
583 | 2024-01-15 01:21:59 | emitters | 1 | 82945 | 5 | 1.516 | 54713.1 |
582 | 2023-12-22 14:25:32 | emitters | 3 | 146162 | 358 | 7.406 | 19735.6 |
581 | 2023-12-22 14:25:33 | emitters | 2 | 121059 | 50 | 3.720 | 32542.7 |
580 | 2023-11-22 13:19:20 | emitters | 1 | 82945 | 5 | 1.483 | 55930.5 |
579 | 2023-11-21 20:27:46 | emitters | 1 | 82945 | 5 | 1.440 | 57600.7 |
578 | 2023-11-12 04:45:14 | emitters | 1 | 82945 | 5 | 1.393 | 59544.1 |
577 | 2023-11-11 00:38:22 | emitters | 1 | 82945 | 5 | 1.360 | 60989.0 |
576 | 2023-11-05 12:09:51 | emitters | 1 | 82945 | 5 | 1.826 | 45424.4 |
575 | 2023-10-19 06:13:22 | emitters | 1 | 82945 | 5 | 2.953 | 28088.4 |
574 | 2023-08-30 10:14:08 | emitters | 1 | 82945 | 5 | 1.310 | 63316.8 |
573 | 2023-07-27 17:38:06 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
572 | 2023-07-27 08:17:16 | emitters | 3 | 146162 | 358 | 7.423 | 19690.4 |
571 | 2023-07-13 07:00:56 | emitters | 3 | 146162 | 358 | 12.156 | 12023.9 |
570 | 2023-06-04 02:30:27 | emitters | 1 | 82945 | 5 | 1.236 | 67107.6 |
569 | 2023-05-29 13:46:19 | emitters | 3 | 146162 | 358 | 6.563 | 22270.6 |
568 | 2023-05-01 05:20:32 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
567 | 2023-04-26 20:37:32 | emitters | 1 | 82945 | 5 | 1.406 | 58993.6 |
566 | 2023-03-28 09:37:43 | emitters | 1 | 82945 | 5 | 1.236 | 67107.6 |
565 | 2023-03-20 01:55:23 | emitters | 1 | 82945 | 5 | 1.393 | 59544.1 |
564 | 2023-03-13 21:19:16 | emitters | 3 | 146162 | 358 | 7.453 | 19611.2 |
563 | 2023-03-04 13:59:08 | emitters | 3 | 146162 | 358 | 6.123 | 23871.0 |
562 | 2023-01-19 23:21:59 | emitters | 3 | 146162 | 358 | 6.546 | 22328.4 |
561 | 2023-01-14 12:06:17 | emitters | 1 | 82945 | 5 | 1.423 | 58288.8 |
560 | 2023-01-11 09:03:46 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
559 | 2023-01-10 11:42:20 | emitters | 3 | 146162 | 358 | 6.220 | 23498.7 |
558 | 2023-01-05 09:44:26 | emitters | 3 | 146162 | 358 | 6.843 | 21359.3 |
557 | 2022-12-18 15:19:14 | emitters | 3 | 146162 | 358 | 6.186 | 23627.9 |
556 | 2022-12-10 10:53:52 | emitters | 3 | 146162 | 358 | 7.186 | 20339.8 |
555 | 2022-12-05 23:18:08 | emitters | 3 | 146162 | 358 | 6.483 | 22545.4 |
554 | 2022-11-12 19:54:34 | emitters | 3 | 146162 | 358 | 6.140 | 23804.9 |
553 | 2022-10-29 05:06:39 | emitters | 3 | 146162 | 358 | 7.580 | 19282.6 |
552 | 2022-10-25 13:18:24 | emitters | 3 | 146162 | 358 | 6.533 | 22372.9 |
551 | 2022-10-20 00:40:28 | emitters | 3 | 146162 | 358 | 7.123 | 20519.7 |
550 | 2022-10-19 01:12:44 | emitters | 1 | 82945 | 5 | 1.266 | 65517.4 |
549 | 2022-10-01 11:25:08 | emitters | 3 | 146162 | 358 | 6.436 | 22710.1 |
548 | 2022-09-30 12:40:54 | emitters | 1 | 82945 | 5 | 1.280 | 64800.8 |
547 | 2022-09-26 21:44:54 | emitters | 1 | 82945 | 5 | 1.393 | 59544.1 |
546 | 2022-09-18 01:30:51 | emitters | 3 | 146162 | 358 | 6.250 | 23385.9 |
545 | 2022-09-06 07:58:43 | emitters | 3 | 146162 | 358 | 6.766 | 21602.4 |
544 | 2022-08-18 04:46:27 | emitters | 3 | 146162 | 358 | 6.750 | 21653.6 |
543 | 2022-08-14 05:25:48 | emitters | 3 | 146162 | 358 | 6.203 | 23563.1 |
542 | 2022-08-13 10:35:17 | emitters | 3 | 146162 | 358 | 6.360 | 22981.4 |
541 | 2022-07-28 10:00:40 | emitters | 3 | 146162 | 358 | 7.143 | 20462.3 |
540 | 2022-06-28 08:15:52 | emitters | 3 | 146162 | 358 | 6.423 | 22756.0 |
539 | 2022-06-19 03:04:37 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
538 | 2022-06-18 19:36:00 | emitters | 1 | 82945 | 5 | 1.220 | 67987.7 |
537 | 2022-06-09 22:34:59 | emitters | 1 | 82945 | 5 | 1.330 | 62364.7 |
536 | 2022-06-06 16:33:22 | emitters | 1 | 82945 | 5 | 1.310 | 63316.8 |
535 | 2022-06-02 08:52:16 | emitters | 1 | 82945 | 5 | 1.406 | 58993.6 |
534 | 2022-05-06 14:29:00 | emitters | 1 | 82945 | 5 | 1.453 | 57085.3 |
533 | 2022-02-26 09:28:31 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
532 | 2022-02-22 23:32:59 | emitters | 1 | 82945 | 5 | 1.313 | 63172.1 |
531 | 2022-02-16 14:06:12 | emitters | 1 | 82945 | 5 | 1.313 | 63172.1 |
530 | 2021-12-05 20:52:26 | emitters | 1 | 82945 | 5 | 1.343 | 61761.0 |
529 | 2021-12-03 19:03:58 | emitters | 1 | 82945 | 5 | 1.470 | 56425.2 |
528 | 2021-11-18 03:56:05 | emitters | 1 | 82945 | 5 | 1.376 | 60279.8 |
527 | 2021-10-29 14:45:12 | emitters | 1 | 82945 | 5 | 1.390 | 59672.7 |
526 | 2021-09-03 14:16:57 | emitters | 1 | 82945 | 5 | 1.436 | 57761.1 |
525 | 2021-08-18 15:36:59 | emitters | 1 | 82945 | 5 | 1.470 | 56425.2 |
524 | 2021-07-28 11:19:07 | emitters | 1 | 82945 | 5 | 1.453 | 57085.3 |
523 | 2021-07-23 06:25:54 | emitters | 3 | 146162 | 358 | 7.233 | 20207.7 |
522 | 2021-06-26 18:20:02 | emitters | 1 | 82945 | 5 | 1.643 | 50483.9 |
521 | 2021-05-15 15:41:01 | emitters | 1 | 82945 | 5 | 1.250 | 66356.0 |
520 | 2021-05-14 16:29:43 | emitters | 1 | 82945 | 5 | 1.266 | 65517.4 |
519 | 2021-05-13 08:13:21 | emitters | 3 | 146162 | 358 | 7.140 | 20470.9 |
518 | 2021-05-09 12:38:02 | emitters | 1 | 82945 | 5 | 1.233 | 67270.9 |
517 | 2021-02-25 03:53:27 | emitters | 1 | 82945 | 5 | 1.283 | 64649.3 |
516 | 2021-02-21 06:45:11 | emitters | 1 | 82945 | 5 | 1.390 | 59672.7 |
515 | 2021-02-19 02:35:04 | emitters | 3 | 146162 | 358 | 8.110 | 18022.4 |