History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hornet"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
601 | 2024-04-24 23:51:34 | hornet | 2 | 82551 | 55 | 2.470 | 33421.5 |
600 | 2024-04-24 23:51:01 | hornet | 3 | 112716 | 804 | 7.516 | 14996.8 |
599 | 2024-04-20 19:22:14 | hornet | 3 | 112716 | 804 | 16.986 | 6635.8 |
598 | 2024-04-20 18:54:05 | hornet | 3 | 112716 | 804 | 13.330 | 8455.8 |
597 | 2024-04-20 08:16:30 | hornet | 3 | 112716 | 804 | 4.986 | 22606.5 |
596 | 2024-04-20 04:58:39 | hornet | 1 | 48755 | 4 | 0.780 | 62506.4 |
595 | 2024-03-28 22:51:09 | hornet | 1 | 48755 | 4 | 3.893 | 12523.8 |
594 | 2024-03-05 18:20:19 | hornet | 3 | 112716 | 804 | 10.330 | 10911.5 |
593 | 2024-03-05 06:42:49 | hornet | 3 | 112716 | 804 | 18.893 | 5966.0 |
592 | 2024-03-04 18:36:12 | hornet | 3 | 112716 | 804 | 10.250 | 10996.7 |
591 | 2024-03-04 16:16:25 | hornet | 3 | 112716 | 804 | 7.080 | 15920.3 |
590 | 2024-03-04 13:50:31 | hornet | 3 | 112716 | 804 | 17.016 | 6624.1 |
589 | 2024-02-25 18:21:31 | hornet | 1 | 48755 | 4 | 0.826 | 59025.4 |
588 | 2024-02-01 07:51:39 | hornet | 2 | 82551 | 55 | 2.530 | 32628.9 |
587 | 2024-02-01 07:51:12 | hornet | 3 | 112716 | 804 | 5.673 | 19868.9 |
586 | 2024-02-01 06:00:40 | hornet | 2 | 82551 | 55 | 2.466 | 33475.7 |
585 | 2024-02-01 06:00:00 | hornet | 3 | 112716 | 804 | 5.986 | 18829.9 |
584 | 2024-02-01 03:13:42 | hornet | 3 | 112716 | 804 | 6.033 | 18683.2 |
583 | 2024-01-21 13:33:47 | hornet | 1 | 48755 | 4 | 0.813 | 59969.2 |
582 | 2024-01-12 00:40:22 | hornet | 1 | 48755 | 4 | 0.813 | 59969.2 |
581 | 2024-01-09 20:49:54 | hornet | 3 | 112716 | 804 | 5.453 | 20670.5 |
580 | 2024-01-09 20:49:53 | hornet | 2 | 82551 | 55 | 2.376 | 34743.7 |
579 | 2023-12-17 11:11:51 | hornet | 1 | 48755 | 4 | 0.750 | 65006.7 |
578 | 2023-12-15 11:52:12 | hornet | 1 | 48755 | 4 | 0.873 | 55847.7 |
577 | 2023-12-06 22:12:19 | hornet | 3 | 112716 | 804 | 5.296 | 21283.2 |
576 | 2023-12-06 22:12:17 | hornet | 2 | 82551 | 55 | 2.436 | 33887.9 |
575 | 2023-11-17 21:42:41 | hornet | 1 | 48755 | 4 | 0.813 | 59969.2 |
574 | 2023-11-15 07:28:50 | hornet | 1 | 48755 | 4 | 0.763 | 63899.1 |
573 | 2023-11-11 06:09:20 | hornet | 1 | 48755 | 4 | 0.826 | 59025.4 |
572 | 2023-11-05 20:29:54 | hornet | 1 | 48755 | 4 | 1.220 | 39963.1 |
571 | 2023-10-22 23:30:58 | hornet | 1 | 48755 | 4 | 0.733 | 66514.3 |
570 | 2023-10-17 09:31:31 | hornet | 1 | 48755 | 4 | 0.873 | 55847.7 |
569 | 2023-10-11 15:27:18 | hornet | 1 | 48755 | 4 | 0.750 | 65006.7 |
568 | 2023-10-04 18:38:22 | hornet | 3 | 112716 | 804 | 5.346 | 21084.2 |
567 | 2023-10-03 22:59:22 | hornet | 3 | 112716 | 804 | 6.263 | 17997.1 |
566 | 2023-10-01 15:44:30 | hornet | 3 | 112716 | 804 | 6.033 | 18683.2 |
565 | 2023-09-29 07:58:23 | hornet | 3 | 112716 | 804 | 5.033 | 22395.4 |
564 | 2023-09-25 02:07:52 | hornet | 1 | 48755 | 4 | 0.766 | 63648.8 |
563 | 2023-09-13 16:41:54 | hornet | 1 | 48755 | 4 | 1.470 | 33166.7 |
562 | 2023-09-05 02:04:19 | hornet | 1 | 48755 | 4 | 0.906 | 53813.5 |
561 | 2023-08-24 14:04:50 | hornet | 1 | 48755 | 4 | 0.843 | 57835.1 |
560 | 2023-06-07 01:55:18 | hornet | 1 | 48755 | 4 | 0.733 | 66514.3 |
559 | 2023-05-10 22:24:01 | hornet | 1 | 48755 | 4 | 0.813 | 59969.2 |
558 | 2023-03-27 06:37:26 | hornet | 1 | 48755 | 4 | 0.733 | 66514.3 |
557 | 2023-01-28 18:57:52 | hornet | 1 | 48755 | 4 | 0.846 | 57630.0 |
556 | 2023-01-17 08:51:38 | hornet | 1 | 48755 | 4 | 0.763 | 63899.1 |
555 | 2023-01-11 04:01:25 | hornet | 1 | 48755 | 4 | 0.736 | 66243.2 |
554 | 2022-10-19 18:32:57 | hornet | 1 | 48755 | 4 | 0.813 | 59969.2 |
553 | 2022-10-18 05:45:59 | hornet | 1 | 48755 | 4 | 0.733 | 66514.3 |
552 | 2022-08-16 00:01:39 | hornet | 1 | 48755 | 4 | 0.733 | 66514.3 |
551 | 2022-07-30 09:45:26 | hornet | 1 | 48755 | 4 | 0.766 | 63648.8 |
550 | 2022-06-24 04:22:30 | hornet | 1 | 48755 | 4 | 0.750 | 65006.7 |
549 | 2022-06-07 18:38:16 | hornet | 1 | 48755 | 4 | 0.716 | 68093.6 |
548 | 2022-03-01 07:41:19 | hornet | 1 | 48755 | 4 | 0.860 | 56691.9 |
547 | 2022-02-15 11:45:07 | hornet | 1 | 48755 | 4 | 0.893 | 54596.9 |
546 | 2021-12-08 22:47:42 | hornet | 1 | 48755 | 4 | 0.860 | 56691.9 |
545 | 2021-12-06 20:43:54 | hornet | 1 | 48755 | 4 | 0.873 | 55847.7 |
544 | 2021-12-02 00:24:58 | hornet | 3 | 112716 | 804 | 4.720 | 23880.5 |
543 | 2021-11-21 00:43:54 | hornet | 1 | 48755 | 4 | 0.733 | 66514.3 |
542 | 2021-11-04 04:03:49 | hornet | 1 | 48755 | 4 | 0.750 | 65006.7 |
541 | 2021-10-28 13:43:52 | hornet | 1 | 48755 | 4 | 0.906 | 53813.5 |
540 | 2021-10-26 05:36:39 | hornet | 3 | 112716 | 804 | 5.593 | 20153.0 |
539 | 2021-10-07 01:26:39 | hornet | 3 | 112716 | 804 | 4.733 | 23814.9 |
538 | 2021-09-16 19:09:59 | hornet | 1 | 48755 | 4 | 0.923 | 52822.3 |
537 | 2021-08-18 03:25:10 | hornet | 1 | 48755 | 4 | 0.766 | 63648.8 |
536 | 2021-08-14 19:59:57 | hornet | 1 | 48755 | 4 | 0.906 | 53813.5 |
535 | 2021-08-06 03:04:22 | hornet | 3 | 112716 | 804 | 4.673 | 24120.7 |
534 | 2021-07-30 22:40:27 | hornet | 3 | 112716 | 804 | 4.720 | 23880.5 |
533 | 2021-06-30 03:25:58 | hornet | 3 | 112716 | 804 | 4.750 | 23729.7 |
532 | 2021-06-29 21:08:50 | hornet | 3 | 112716 | 804 | 4.733 | 23814.9 |
531 | 2021-06-29 03:22:58 | hornet | 3 | 112716 | 804 | 5.453 | 20670.5 |
530 | 2021-06-28 08:54:15 | hornet | 3 | 112716 | 804 | 5.780 | 19501.0 |
529 | 2021-06-27 00:14:43 | hornet | 3 | 112716 | 804 | 4.906 | 22975.1 |
528 | 2021-06-24 14:51:32 | hornet | 3 | 112716 | 804 | 6.343 | 17770.1 |
527 | 2021-06-23 15:20:40 | hornet | 3 | 112716 | 804 | 5.190 | 21717.9 |
526 | 2021-06-23 03:23:34 | hornet | 3 | 112716 | 804 | 5.060 | 22275.9 |
525 | 2021-06-22 01:50:00 | hornet | 3 | 112716 | 804 | 5.500 | 20493.8 |
524 | 2021-06-21 07:54:58 | hornet | 3 | 112716 | 804 | 4.736 | 23799.8 |
523 | 2021-06-21 00:48:51 | hornet | 3 | 112716 | 804 | 5.593 | 20153.0 |
522 | 2021-06-18 22:07:09 | hornet | 3 | 112716 | 804 | 4.920 | 22909.8 |
521 | 2021-06-15 02:38:09 | hornet | 3 | 112716 | 804 | 5.393 | 20900.4 |
520 | 2021-06-03 16:05:47 | hornet | 3 | 112716 | 804 | 5.466 | 20621.3 |
519 | 2021-06-02 20:34:04 | hornet | 3 | 112716 | 804 | 5.093 | 22131.6 |
518 | 2021-06-02 11:01:08 | hornet | 3 | 112716 | 804 | 5.236 | 21527.1 |
517 | 2021-06-01 13:23:41 | hornet | 3 | 112716 | 804 | 5.406 | 20850.2 |
516 | 2021-05-29 04:32:02 | hornet | 3 | 112716 | 804 | 6.080 | 18538.8 |
515 | 2021-05-28 04:26:40 | hornet | 3 | 112716 | 804 | 5.733 | 19660.9 |
514 | 2021-05-27 04:28:23 | hornet | 3 | 112716 | 804 | 5.830 | 19333.8 |
513 | 2021-05-23 21:44:08 | hornet | 1 | 48755 | 4 | 0.750 | 65006.7 |
512 | 2021-05-19 02:04:13 | hornet | 1 | 48755 | 4 | 0.893 | 54596.9 |
511 | 2021-05-18 09:46:39 | hornet | 1 | 48755 | 4 | 0.843 | 57835.1 |
510 | 2021-05-14 04:19:21 | hornet | 1 | 48755 | 4 | 0.953 | 51159.5 |
509 | 2021-05-05 23:20:16 | hornet | 3 | 112716 | 804 | 6.156 | 18309.9 |
508 | 2021-05-04 23:59:27 | hornet | 3 | 112716 | 804 | 5.736 | 19650.6 |
507 | 2021-05-03 15:45:29 | hornet | 3 | 112716 | 804 | 5.846 | 19280.9 |
506 | 2021-05-02 23:11:37 | hornet | 3 | 112716 | 804 | 4.966 | 22697.5 |
505 | 2021-05-01 22:30:15 | hornet | 3 | 112716 | 804 | 5.390 | 20912.1 |
504 | 2021-04-26 22:09:40 | hornet | 1 | 48755 | 4 | 0.810 | 60191.4 |
503 | 2021-04-23 09:19:49 | hornet | 3 | 112716 | 804 | 11.300 | 9974.9 |
502 | 2021-04-07 13:55:34 | hornet | 3 | 112716 | 804 | 4.766 | 23650.0 |