History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"counties"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
598 | 2024-04-03 10:51:58 | counties | 3 | 146162 | 337 | 18.876 | 7743.3 |
597 | 2024-03-30 01:04:18 | counties | 3 | 146162 | 337 | 25.656 | 5697.0 |
596 | 2024-03-30 00:27:24 | counties | 1 | 82945 | 4 | 3.233 | 25655.7 |
595 | 2024-03-28 17:28:50 | counties | 3 | 146162 | 337 | 6.560 | 22280.8 |
594 | 2024-03-08 22:07:10 | counties | 2 | 121059 | 28 | 4.000 | 30264.8 |
593 | 2024-03-08 22:06:05 | counties | 3 | 146162 | 337 | 8.876 | 16467.1 |
592 | 2024-03-08 03:24:05 | counties | 2 | 121059 | 28 | 3.753 | 32256.6 |
591 | 2024-03-08 03:23:34 | counties | 3 | 146162 | 337 | 7.656 | 19091.2 |
590 | 2024-03-07 03:39:43 | counties | 3 | 146162 | 337 | 9.626 | 15184.1 |
589 | 2024-03-06 23:16:36 | counties | 3 | 146162 | 337 | 10.690 | 13672.8 |
588 | 2024-03-03 08:07:53 | counties | 1 | 82945 | 4 | 8.500 | 9758.2 |
587 | 2024-02-07 19:55:57 | counties | 2 | 121059 | 28 | 10.893 | 11113.5 |
586 | 2024-02-05 02:36:22 | counties | 3 | 146162 | 337 | 8.110 | 18022.4 |
585 | 2024-01-31 06:44:08 | counties | 3 | 146162 | 337 | 7.936 | 18417.6 |
584 | 2024-01-30 06:32:36 | counties | 2 | 121059 | 28 | 3.640 | 33258.0 |
583 | 2024-01-30 01:04:53 | counties | 2 | 121059 | 28 | 3.923 | 30858.8 |
582 | 2024-01-30 01:04:05 | counties | 3 | 146162 | 337 | 7.843 | 18636.0 |
581 | 2024-01-29 16:40:56 | counties | 3 | 146162 | 337 | 12.983 | 11258.0 |
580 | 2024-01-29 09:07:18 | counties | 3 | 146162 | 337 | 8.063 | 18127.5 |
579 | 2024-01-28 09:02:17 | counties | 1 | 82945 | 4 | 1.420 | 58412.0 |
578 | 2024-01-21 06:10:51 | counties | 1 | 82945 | 4 | 1.296 | 64000.8 |
577 | 2024-01-10 09:51:38 | counties | 3 | 146162 | 337 | 7.436 | 19656.0 |
576 | 2024-01-10 09:51:37 | counties | 2 | 121059 | 28 | 3.873 | 31257.2 |
575 | 2023-12-03 19:11:52 | counties | 3 | 146162 | 337 | 6.876 | 21256.8 |
574 | 2023-11-22 06:47:14 | counties | 1 | 82945 | 4 | 3.063 | 27079.7 |
573 | 2023-11-19 17:05:08 | counties | 1 | 82945 | 4 | 1.440 | 57600.7 |
572 | 2023-11-18 03:49:05 | counties | 1 | 82945 | 4 | 1.390 | 59672.7 |
571 | 2023-11-17 11:39:41 | counties | 1 | 82945 | 4 | 1.326 | 62552.8 |
570 | 2023-11-15 13:06:06 | counties | 1 | 82945 | 4 | 1.453 | 57085.3 |
569 | 2023-10-22 19:21:25 | counties | 1 | 82945 | 4 | 1.563 | 53067.8 |
568 | 2023-10-19 20:03:37 | counties | 1 | 82945 | 4 | 1.310 | 63316.8 |
567 | 2023-10-16 23:48:45 | counties | 1 | 82945 | 4 | 1.453 | 57085.3 |
566 | 2023-10-15 01:44:16 | counties | 1 | 82945 | 4 | 1.330 | 62364.7 |
565 | 2023-10-01 05:56:15 | counties | 2 | 121059 | 28 | 7.923 | 15279.4 |
564 | 2023-10-01 05:56:14 | counties | 3 | 146162 | 337 | 7.906 | 18487.5 |
563 | 2023-09-29 07:44:01 | counties | 1 | 82945 | 4 | 1.470 | 56425.2 |
562 | 2023-09-12 04:59:39 | counties | 1 | 82945 | 4 | 1.296 | 64000.8 |
561 | 2023-09-05 00:15:07 | counties | 1 | 82945 | 4 | 1.423 | 58288.8 |
560 | 2023-09-01 10:29:44 | counties | 3 | 146162 | 337 | 6.343 | 23043.0 |
559 | 2023-07-07 13:11:47 | counties | 1 | 82945 | 4 | 1.516 | 54713.1 |
558 | 2023-06-10 13:29:33 | counties | 1 | 82945 | 4 | 1.280 | 64800.8 |
557 | 2023-05-20 19:10:42 | counties | 3 | 146162 | 337 | 6.406 | 22816.4 |
556 | 2023-03-30 03:00:39 | counties | 1 | 82945 | 4 | 1.283 | 64649.3 |
555 | 2023-03-27 08:07:09 | counties | 1 | 82945 | 4 | 1.420 | 58412.0 |
554 | 2023-03-22 11:18:09 | counties | 1 | 82945 | 4 | 1.420 | 58412.0 |
553 | 2023-03-01 12:37:58 | counties | 3 | 146162 | 337 | 7.626 | 19166.3 |
552 | 2023-01-11 06:41:28 | counties | 1 | 82945 | 4 | 1.263 | 65673.0 |
551 | 2022-12-15 09:47:27 | counties | 1 | 82945 | 4 | 1.296 | 64000.8 |
550 | 2022-12-10 10:36:45 | counties | 3 | 146162 | 337 | 6.733 | 21708.3 |
549 | 2022-10-26 04:13:50 | counties | 1 | 82945 | 4 | 1.423 | 58288.8 |
548 | 2022-09-04 12:18:04 | counties | 1 | 82945 | 4 | 1.296 | 64000.8 |
547 | 2022-07-16 11:37:03 | counties | 3 | 146162 | 337 | 6.466 | 22604.7 |
546 | 2022-07-13 00:06:27 | counties | 2 | 121059 | 28 | 3.203 | 37795.5 |
545 | 2022-06-16 12:11:29 | counties | 1 | 82945 | 4 | 1.313 | 63172.1 |
544 | 2022-05-23 08:15:22 | counties | 1 | 82945 | 4 | 1.406 | 58993.6 |
543 | 2022-05-19 22:12:06 | counties | 1 | 82945 | 4 | 1.466 | 56579.1 |
542 | 2022-02-26 23:57:45 | counties | 3 | 146162 | 337 | 7.406 | 19735.6 |
541 | 2022-02-19 16:32:56 | counties | 1 | 82945 | 4 | 1.296 | 64000.8 |
540 | 2022-02-15 06:09:20 | counties | 1 | 82945 | 4 | 1.610 | 51518.6 |
539 | 2022-02-11 17:20:27 | counties | 1 | 82945 | 4 | 1.296 | 64000.8 |
538 | 2021-12-08 21:34:51 | counties | 1 | 82945 | 4 | 1.483 | 55930.5 |
537 | 2021-12-06 19:24:30 | counties | 1 | 82945 | 4 | 2.876 | 28840.4 |
536 | 2021-11-22 23:46:01 | counties | 3 | 146162 | 337 | 6.513 | 22441.6 |
535 | 2021-11-20 04:57:21 | counties | 1 | 82945 | 4 | 1.343 | 61761.0 |
534 | 2021-11-10 16:27:11 | counties | 1 | 82945 | 4 | 1.296 | 64000.8 |
533 | 2021-09-19 16:28:17 | counties | 3 | 146162 | 337 | 6.343 | 23043.0 |
532 | 2021-09-05 21:58:04 | counties | 1 | 82945 | 4 | 1.296 | 64000.8 |
531 | 2021-09-03 15:57:22 | counties | 1 | 82945 | 4 | 1.453 | 57085.3 |
530 | 2021-08-19 07:00:21 | counties | 1 | 82945 | 4 | 1.343 | 61761.0 |
529 | 2021-08-07 16:06:44 | counties | 1 | 82945 | 4 | 1.486 | 55817.6 |
528 | 2021-05-16 01:39:55 | counties | 1 | 82945 | 4 | 3.076 | 26965.2 |
527 | 2021-05-03 11:49:23 | counties | 1 | 82945 | 4 | 1.420 | 58412.0 |
526 | 2021-04-29 20:03:35 | counties | 1 | 82945 | 4 | 1.453 | 57085.3 |
525 | 2021-04-15 14:41:38 | counties | 1 | 82945 | 4 | 1.953 | 42470.6 |
524 | 2021-01-28 16:30:43 | counties | 1 | 82945 | 4 | 1.546 | 53651.4 |
523 | 2021-01-28 11:08:49 | counties | 1 | 82945 | 4 | 1.376 | 60279.8 |
522 | 2021-01-25 09:21:40 | counties | 1 | 82945 | 4 | 1.360 | 60989.0 |
521 | 2020-12-31 01:27:52 | counties | 1 | 82945 | 4 | 1.296 | 64000.8 |
520 | 2020-10-29 07:00:36 | counties | 1 | 82945 | 4 | 1.420 | 58412.0 |
519 | 2020-10-27 01:55:48 | counties | 1 | 82945 | 4 | 1.453 | 57085.3 |
518 | 2020-10-24 04:56:03 | counties | 1 | 82945 | 4 | 1.326 | 62552.8 |
517 | 2020-10-04 06:50:51 | counties | 1 | 82945 | 4 | 1.580 | 52496.8 |
516 | 2020-09-12 23:35:45 | counties | 1 | 82945 | 4 | 1.533 | 54106.3 |
515 | 2020-09-01 10:22:47 | counties | 1 | 82945 | 4 | 1.326 | 62552.8 |
514 | 2020-08-27 08:47:17 | counties | 1 | 82945 | 4 | 1.280 | 64800.8 |
513 | 2020-08-21 08:59:46 | counties | 1 | 82945 | 4 | 1.343 | 61761.0 |
512 | 2020-08-06 10:54:29 | counties | 1 | 82945 | 4 | 1.376 | 60279.8 |
511 | 2020-07-28 16:58:44 | counties | 1 | 82945 | 4 | 1.563 | 53067.8 |
510 | 2020-07-24 16:09:01 | counties | 1 | 82945 | 4 | 1.373 | 60411.5 |
509 | 2020-07-12 11:38:18 | counties | 1 | 82945 | 4 | 1.436 | 57761.1 |
508 | 2020-04-22 11:33:48 | counties | 1 | 82945 | 4 | 1.483 | 55930.5 |
507 | 2020-04-10 22:45:50 | counties | 1 | 82945 | 4 | 1.296 | 64000.8 |
506 | 2020-03-29 03:11:07 | counties | 1 | 82945 | 4 | 1.563 | 53067.8 |
505 | 2020-03-25 02:14:31 | counties | 1 | 82945 | 4 | 1.546 | 53651.4 |
504 | 2020-03-24 13:51:39 | counties | 1 | 82945 | 4 | 2.550 | 32527.5 |
503 | 2020-03-20 23:29:53 | counties | 1 | 82945 | 4 | 1.420 | 58412.0 |
502 | 2020-02-25 13:54:29 | counties | 1 | 82945 | 4 | 1.530 | 54212.4 |
501 | 2020-02-24 15:04:19 | counties | 1 | 82945 | 4 | 1.940 | 42755.2 |
500 | 2020-02-23 08:47:03 | counties | 1 | 82945 | 4 | 1.483 | 55930.5 |
499 | 2020-02-06 19:53:18 | counties | 1 | 82945 | 4 | 1.546 | 53651.4 |