History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"locust"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
574 | 2024-04-28 02:16:28 | locust | 1 | 48755 | 4 | 1.280 | 38089.8 |
573 | 2024-04-05 21:13:02 | locust | 1 | 48755 | 4 | 1.843 | 26454.2 |
572 | 2024-04-03 09:36:18 | locust | 1 | 48755 | 4 | 2.376 | 20519.8 |
571 | 2024-03-02 09:28:38 | locust | 3 | 112716 | 390 | 14.796 | 7618.0 |
570 | 2024-03-02 01:57:29 | locust | 2 | 82551 | 31 | 3.593 | 22975.5 |
569 | 2024-03-01 19:21:43 | locust | 3 | 112716 | 390 | 21.080 | 5347.1 |
568 | 2024-02-28 12:42:41 | locust | 3 | 112716 | 390 | 10.783 | 10453.1 |
567 | 2024-02-27 21:41:15 | locust | 2 | 82551 | 31 | 2.733 | 30205.3 |
566 | 2024-02-27 21:41:01 | locust | 3 | 112716 | 390 | 6.356 | 17733.8 |
565 | 2024-02-27 21:40:21 | locust | 3 | 112716 | 390 | 8.346 | 13505.4 |
564 | 2024-02-27 21:40:22 | locust | 2 | 82551 | 31 | 2.923 | 28241.9 |
563 | 2024-02-27 21:40:18 | locust | 1 | 48755 | 4 | 0.936 | 52088.7 |
562 | 2024-02-07 00:00:50 | locust | 2 | 82551 | 31 | 2.610 | 31628.7 |
561 | 2024-01-18 22:20:09 | locust | 1 | 48755 | 4 | 0.906 | 53813.5 |
560 | 2024-01-07 05:54:38 | locust | 3 | 112716 | 390 | 5.280 | 21347.7 |
559 | 2023-12-26 17:17:15 | locust | 1 | 48755 | 4 | 0.750 | 65006.7 |
558 | 2023-12-18 16:04:08 | locust | 2 | 82551 | 31 | 2.640 | 31269.3 |
557 | 2023-12-14 16:50:06 | locust | 2 | 82551 | 31 | 2.890 | 28564.4 |
556 | 2023-11-22 17:26:15 | locust | 3 | 112716 | 390 | 5.643 | 19974.5 |
555 | 2023-11-18 11:01:16 | locust | 1 | 48755 | 4 | 0.733 | 66514.3 |
554 | 2023-11-14 23:21:13 | locust | 1 | 48755 | 4 | 0.796 | 61250.0 |
553 | 2023-11-11 13:38:40 | locust | 2 | 82551 | 31 | 6.140 | 13444.8 |
552 | 2023-11-04 18:41:38 | locust | 1 | 48755 | 4 | 0.856 | 56956.8 |
551 | 2023-10-22 23:07:31 | locust | 1 | 48755 | 4 | 0.843 | 57835.1 |
550 | 2023-10-18 13:58:39 | locust | 1 | 48755 | 4 | 0.783 | 62266.9 |
549 | 2023-10-14 13:39:19 | locust | 1 | 48755 | 4 | 0.873 | 55847.7 |
548 | 2023-10-11 15:28:02 | locust | 1 | 48755 | 4 | 0.750 | 65006.7 |
547 | 2023-09-25 08:44:45 | locust | 1 | 48755 | 4 | 0.826 | 59025.4 |
546 | 2023-09-15 10:15:02 | locust | 1 | 48755 | 4 | 0.830 | 58741.0 |
545 | 2023-09-05 02:36:43 | locust | 1 | 48755 | 4 | 0.736 | 66243.2 |
544 | 2023-08-23 13:36:52 | locust | 3 | 112716 | 390 | 5.140 | 21929.2 |
543 | 2023-08-15 01:19:09 | locust | 2 | 82551 | 31 | 2.343 | 35233.0 |
542 | 2023-08-10 07:42:04 | locust | 1 | 48755 | 4 | 0.843 | 57835.1 |
541 | 2023-05-12 16:37:35 | locust | 1 | 48755 | 4 | 0.750 | 65006.7 |
540 | 2023-05-09 21:19:10 | locust | 3 | 112716 | 390 | 4.640 | 24292.2 |
539 | 2023-05-05 03:41:54 | locust | 1 | 48755 | 4 | 0.813 | 59969.2 |
538 | 2023-04-30 00:53:59 | locust | 2 | 82551 | 31 | 2.093 | 39441.5 |
537 | 2023-03-08 22:18:39 | locust | 1 | 48755 | 4 | 0.826 | 59025.4 |
536 | 2023-03-04 08:43:49 | locust | 1 | 48755 | 4 | 0.826 | 59025.4 |
535 | 2023-02-17 10:11:27 | locust | 3 | 112716 | 390 | 4.610 | 24450.3 |
534 | 2023-02-05 23:57:48 | locust | 2 | 82551 | 31 | 2.610 | 31628.7 |
533 | 2023-01-11 15:56:24 | locust | 1 | 48755 | 4 | 0.860 | 56691.9 |
532 | 2022-12-31 18:58:19 | locust | 1 | 48755 | 4 | 0.750 | 65006.7 |
531 | 2022-11-29 08:45:42 | locust | 3 | 112716 | 390 | 4.546 | 24794.5 |
530 | 2022-11-18 12:45:44 | locust | 2 | 82551 | 31 | 2.203 | 37472.1 |
529 | 2022-09-19 23:42:06 | locust | 1 | 48755 | 4 | 0.733 | 66514.3 |
528 | 2022-09-13 08:37:19 | locust | 1 | 48755 | 4 | 0.750 | 65006.7 |
527 | 2022-07-07 01:43:46 | locust | 3 | 112716 | 390 | 4.626 | 24365.8 |
526 | 2022-06-21 08:39:44 | locust | 2 | 82551 | 31 | 2.106 | 39198.0 |
525 | 2022-05-16 06:44:54 | locust | 1 | 48755 | 4 | 0.750 | 65006.7 |
524 | 2022-05-04 01:03:51 | locust | 1 | 48755 | 4 | 0.750 | 65006.7 |
523 | 2022-04-29 07:48:53 | locust | 1 | 48755 | 4 | 0.780 | 62506.4 |
522 | 2022-02-04 23:04:07 | locust | 2 | 82551 | 31 | 2.453 | 33653.1 |
521 | 2022-02-02 19:07:41 | locust | 2 | 82551 | 31 | 2.796 | 29524.7 |
520 | 2022-01-22 16:27:32 | locust | 1 | 48755 | 4 | 0.873 | 55847.7 |
519 | 2022-01-15 09:42:12 | locust | 1 | 48755 | 4 | 0.860 | 56691.9 |
518 | 2022-01-10 04:11:37 | locust | 1 | 48755 | 4 | 0.783 | 62266.9 |
517 | 2021-12-12 02:33:25 | locust | 1 | 48755 | 4 | 1.576 | 30935.9 |
516 | 2021-11-22 09:47:44 | locust | 1 | 48755 | 4 | 0.750 | 65006.7 |
515 | 2021-11-08 02:58:50 | locust | 2 | 82551 | 31 | 2.533 | 32590.2 |
514 | 2021-10-06 01:55:39 | locust | 1 | 48755 | 4 | 0.750 | 65006.7 |
513 | 2021-09-30 18:11:54 | locust | 1 | 48755 | 4 | 0.873 | 55847.7 |
512 | 2021-09-21 10:21:14 | locust | 2 | 82551 | 31 | 2.530 | 32628.9 |
511 | 2021-09-03 19:32:01 | locust | 1 | 48755 | 4 | 0.893 | 54596.9 |
510 | 2021-08-19 10:58:44 | locust | 1 | 48755 | 4 | 0.763 | 63899.1 |
509 | 2021-07-29 05:39:01 | locust | 2 | 82551 | 31 | 2.076 | 39764.5 |
508 | 2021-07-28 01:50:48 | locust | 2 | 82551 | 31 | 2.440 | 33832.4 |
507 | 2021-07-27 05:04:14 | locust | 2 | 82551 | 31 | 2.156 | 38289.0 |
506 | 2021-07-26 09:09:00 | locust | 2 | 82551 | 31 | 2.203 | 37472.1 |
505 | 2021-07-24 01:49:32 | locust | 2 | 82551 | 31 | 2.373 | 34787.6 |
504 | 2021-07-22 17:19:06 | locust | 2 | 82551 | 31 | 2.250 | 36689.3 |
503 | 2021-07-22 07:08:35 | locust | 2 | 82551 | 31 | 2.110 | 39123.7 |
502 | 2021-07-20 02:48:25 | locust | 2 | 82551 | 31 | 2.360 | 34979.2 |
501 | 2021-07-18 21:04:05 | locust | 2 | 82551 | 31 | 2.390 | 34540.2 |
500 | 2021-07-18 10:54:23 | locust | 2 | 82551 | 31 | 2.126 | 38829.3 |
499 | 2021-07-15 16:01:02 | locust | 2 | 82551 | 31 | 2.186 | 37763.5 |
498 | 2021-07-01 08:50:43 | locust | 1 | 48755 | 4 | 0.750 | 65006.7 |
497 | 2021-06-21 01:29:55 | locust | 2 | 82551 | 31 | 2.593 | 31836.1 |
496 | 2021-06-16 04:43:51 | locust | 2 | 82551 | 31 | 2.156 | 38289.0 |
495 | 2021-06-06 19:58:23 | locust | 2 | 82551 | 31 | 2.486 | 33206.4 |
494 | 2021-06-06 01:07:20 | locust | 2 | 82551 | 31 | 2.483 | 33246.5 |
493 | 2021-06-05 12:54:19 | locust | 2 | 82551 | 31 | 2.453 | 33653.1 |
492 | 2021-06-04 21:26:11 | locust | 2 | 82551 | 31 | 2.516 | 32810.4 |
491 | 2021-06-04 03:02:59 | locust | 2 | 82551 | 31 | 2.580 | 31996.5 |
490 | 2021-06-03 15:16:11 | locust | 2 | 82551 | 31 | 2.576 | 32046.2 |
489 | 2021-06-02 18:24:54 | locust | 2 | 82551 | 31 | 2.173 | 37989.4 |
488 | 2021-06-02 03:09:00 | locust | 2 | 82551 | 31 | 2.436 | 33887.9 |
487 | 2021-05-30 07:25:58 | locust | 2 | 82551 | 31 | 2.580 | 31996.5 |
486 | 2021-05-29 17:49:58 | locust | 2 | 82551 | 31 | 2.796 | 29524.7 |
485 | 2021-05-29 04:04:51 | locust | 2 | 82551 | 31 | 2.546 | 32423.8 |
484 | 2021-05-29 01:30:10 | locust | 2 | 82551 | 31 | 2.156 | 38289.0 |
483 | 2021-05-29 01:20:14 | locust | 2 | 82551 | 31 | 2.423 | 34069.7 |
482 | 2021-05-25 21:01:39 | locust | 1 | 48755 | 4 | 0.843 | 57835.1 |
481 | 2021-05-12 00:53:48 | locust | 2 | 82551 | 31 | 2.360 | 34979.2 |
480 | 2021-05-11 05:41:31 | locust | 2 | 82551 | 31 | 2.453 | 33653.1 |
479 | 2021-05-11 02:09:48 | locust | 2 | 82551 | 31 | 2.733 | 30205.3 |
478 | 2021-05-11 00:53:55 | locust | 2 | 82551 | 31 | 2.750 | 30018.5 |
477 | 2021-05-10 22:22:59 | locust | 2 | 82551 | 31 | 2.626 | 31436.0 |
476 | 2021-05-10 14:25:18 | locust | 2 | 82551 | 31 | 2.563 | 32208.7 |
475 | 2021-05-09 23:46:35 | locust | 2 | 82551 | 31 | 2.470 | 33421.5 |