History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"magpie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
599 | 2024-06-03 13:36:57 | magpie | 1 | 48755 | 2 | 0.860 | 56691.9 |
598 | 2024-05-28 09:11:43 | magpie | 1 | 48755 | 2 | 2.953 | 16510.3 |
597 | 2024-05-05 03:31:15 | magpie | 3 | 112716 | 378 | 5.453 | 20670.5 |
596 | 2024-05-02 16:22:55 | magpie | 1 | 48755 | 2 | 1.826 | 26700.4 |
595 | 2024-04-30 23:26:46 | magpie | 3 | 112716 | 378 | 6.436 | 17513.4 |
594 | 2024-04-17 19:00:31 | magpie | 3 | 112716 | 378 | 15.440 | 7300.3 |
593 | 2024-04-17 16:00:21 | magpie | 2 | 82551 | 16 | 2.610 | 31628.7 |
592 | 2024-04-17 16:00:01 | magpie | 3 | 112716 | 378 | 7.983 | 14119.5 |
591 | 2024-04-17 13:35:35 | magpie | 2 | 82551 | 16 | 5.233 | 15775.1 |
590 | 2024-04-17 13:33:49 | magpie | 3 | 112716 | 378 | 6.030 | 18692.5 |
589 | 2024-04-16 04:18:17 | magpie | 2 | 82551 | 16 | 6.153 | 13416.4 |
588 | 2024-04-16 04:17:50 | magpie | 3 | 112716 | 378 | 6.936 | 16250.9 |
587 | 2024-04-16 02:54:24 | magpie | 3 | 112716 | 378 | 9.283 | 12142.2 |
586 | 2024-03-30 08:56:59 | magpie | 1 | 48755 | 2 | 2.300 | 21197.8 |
585 | 2024-03-29 00:16:48 | magpie | 1 | 48755 | 2 | 2.936 | 16605.9 |
584 | 2024-03-18 06:00:57 | magpie | 2 | 82551 | 16 | 2.906 | 28407.1 |
583 | 2024-03-18 05:01:33 | magpie | 3 | 112716 | 378 | 5.593 | 20153.0 |
582 | 2024-03-15 20:18:57 | magpie | 3 | 112716 | 378 | 6.000 | 18786.0 |
581 | 2024-03-11 02:08:25 | magpie | 3 | 112716 | 378 | 11.750 | 9592.9 |
580 | 2024-03-10 21:04:07 | magpie | 3 | 112716 | 378 | 6.546 | 17219.1 |
579 | 2024-03-08 22:04:47 | magpie | 2 | 82551 | 16 | 2.783 | 29662.6 |
578 | 2024-03-08 22:04:37 | magpie | 1 | 48755 | 2 | 0.906 | 53813.5 |
577 | 2024-03-08 22:04:14 | magpie | 3 | 112716 | 378 | 6.126 | 18399.6 |
576 | 2024-03-08 17:29:13 | magpie | 3 | 112716 | 378 | 12.330 | 9141.6 |
575 | 2024-03-02 12:01:02 | magpie | 1 | 48755 | 2 | 1.810 | 26936.5 |
574 | 2024-02-27 19:13:01 | magpie | 1 | 48755 | 2 | 0.830 | 58741.0 |
573 | 2024-02-18 23:10:33 | magpie | 2 | 82551 | 16 | 8.593 | 9606.8 |
572 | 2024-02-18 23:09:35 | magpie | 2 | 82551 | 16 | 3.423 | 24116.6 |
571 | 2024-01-31 21:38:12 | magpie | 2 | 82551 | 16 | 2.500 | 33020.4 |
570 | 2024-01-31 21:37:40 | magpie | 3 | 112716 | 378 | 5.563 | 20261.7 |
569 | 2024-01-31 02:24:31 | magpie | 2 | 82551 | 16 | 2.390 | 34540.2 |
568 | 2024-01-31 02:24:15 | magpie | 3 | 112716 | 378 | 4.920 | 22909.8 |
567 | 2024-01-27 05:50:41 | magpie | 3 | 112716 | 378 | 4.890 | 23050.3 |
566 | 2024-01-25 19:28:24 | magpie | 3 | 112716 | 378 | 5.843 | 19290.8 |
565 | 2024-01-24 18:02:19 | magpie | 3 | 112716 | 378 | 5.016 | 22471.3 |
564 | 2024-01-22 14:45:18 | magpie | 3 | 112716 | 378 | 4.626 | 24365.8 |
563 | 2024-01-21 17:06:04 | magpie | 3 | 112716 | 378 | 6.016 | 18736.0 |
562 | 2024-01-20 12:47:54 | magpie | 3 | 112716 | 378 | 8.110 | 13898.4 |
561 | 2024-01-19 19:48:07 | magpie | 3 | 112716 | 378 | 5.080 | 22188.2 |
560 | 2024-01-18 13:17:47 | magpie | 3 | 112716 | 378 | 5.030 | 22408.7 |
559 | 2024-01-17 18:09:23 | magpie | 3 | 112716 | 378 | 4.593 | 24540.8 |
558 | 2024-01-05 10:59:45 | magpie | 3 | 112716 | 378 | 5.876 | 19182.4 |
557 | 2024-01-05 10:59:44 | magpie | 2 | 82551 | 16 | 2.673 | 30883.3 |
556 | 2024-01-02 12:19:29 | magpie | 1 | 48755 | 2 | 0.766 | 63648.8 |
555 | 2023-12-10 06:57:13 | magpie | 1 | 48755 | 2 | 0.780 | 62506.4 |
554 | 2023-12-06 05:42:17 | magpie | 3 | 112716 | 378 | 5.906 | 19085.0 |
553 | 2023-12-06 05:42:16 | magpie | 2 | 82551 | 16 | 2.623 | 31472.0 |
552 | 2023-12-03 23:24:36 | magpie | 2 | 82551 | 16 | 2.373 | 34787.6 |
551 | 2023-12-03 23:24:33 | magpie | 2 | 82551 | 16 | 2.346 | 35188.0 |
550 | 2023-12-03 13:39:31 | magpie | 1 | 48755 | 2 | 0.936 | 52088.7 |
549 | 2023-12-03 13:39:30 | magpie | 1 | 48755 | 2 | 0.860 | 56691.9 |
548 | 2023-11-27 00:27:52 | magpie | 3 | 112716 | 378 | 5.940 | 18975.8 |
547 | 2023-11-27 00:27:49 | magpie | 2 | 82551 | 16 | 2.453 | 33653.1 |
546 | 2023-11-21 01:14:22 | magpie | 1 | 48755 | 2 | 0.873 | 55847.7 |
545 | 2023-11-18 01:40:42 | magpie | 2 | 82551 | 16 | 2.890 | 28564.4 |
544 | 2023-11-14 08:39:31 | magpie | 1 | 48755 | 2 | 1.080 | 45143.5 |
543 | 2023-11-11 00:31:45 | magpie | 1 | 48755 | 2 | 0.750 | 65006.7 |
542 | 2023-11-10 09:56:44 | magpie | 1 | 48755 | 2 | 0.840 | 58041.7 |
541 | 2023-11-07 21:33:55 | magpie | 1 | 48755 | 2 | 0.750 | 65006.7 |
540 | 2023-10-21 23:15:39 | magpie | 1 | 48755 | 2 | 0.750 | 65006.7 |
539 | 2023-10-17 01:32:57 | magpie | 1 | 48755 | 2 | 0.783 | 62266.9 |
538 | 2023-10-11 11:26:13 | magpie | 1 | 48755 | 2 | 1.983 | 24586.5 |
537 | 2023-10-11 06:08:19 | magpie | 1 | 48755 | 2 | 0.750 | 65006.7 |
536 | 2023-10-08 09:22:38 | magpie | 1 | 48755 | 2 | 0.826 | 59025.4 |
535 | 2023-09-26 13:31:26 | magpie | 1 | 48755 | 2 | 0.856 | 56956.8 |
534 | 2023-09-26 09:03:45 | magpie | 1 | 48755 | 2 | 0.830 | 58741.0 |
533 | 2023-09-15 23:43:32 | magpie | 1 | 48755 | 2 | 0.750 | 65006.7 |
532 | 2023-09-11 06:24:17 | magpie | 3 | 112716 | 378 | 5.563 | 20261.7 |
531 | 2023-09-07 02:19:01 | magpie | 3 | 112716 | 378 | 5.283 | 21335.6 |
530 | 2023-09-06 01:54:54 | magpie | 3 | 112716 | 378 | 4.716 | 23900.8 |
529 | 2023-09-03 16:29:35 | magpie | 3 | 112716 | 378 | 5.313 | 21215.1 |
528 | 2023-09-02 02:07:25 | magpie | 3 | 112716 | 378 | 5.296 | 21283.2 |
527 | 2023-09-01 23:25:27 | magpie | 3 | 112716 | 378 | 5.096 | 22118.5 |
526 | 2023-08-31 00:48:20 | magpie | 3 | 112716 | 378 | 5.016 | 22471.3 |
525 | 2023-08-30 11:29:53 | magpie | 3 | 112716 | 378 | 4.673 | 24120.7 |
524 | 2023-08-30 00:11:09 | magpie | 3 | 112716 | 378 | 5.313 | 21215.1 |
523 | 2023-08-29 06:12:07 | magpie | 3 | 112716 | 378 | 4.640 | 24292.2 |
522 | 2023-08-28 06:22:26 | magpie | 3 | 112716 | 378 | 4.750 | 23729.7 |
521 | 2023-08-24 07:57:11 | magpie | 3 | 112716 | 378 | 5.970 | 18880.4 |
520 | 2023-08-22 12:41:23 | magpie | 3 | 112716 | 378 | 4.690 | 24033.3 |
519 | 2023-08-21 09:39:13 | magpie | 3 | 112716 | 378 | 5.783 | 19490.9 |
518 | 2023-08-20 07:30:28 | magpie | 3 | 112716 | 378 | 5.126 | 21989.1 |
517 | 2023-08-19 12:02:27 | magpie | 2 | 82551 | 16 | 2.450 | 33694.3 |
516 | 2023-08-18 16:24:17 | magpie | 3 | 112716 | 378 | 5.580 | 20200.0 |
515 | 2023-08-16 21:20:25 | magpie | 3 | 112716 | 378 | 5.233 | 21539.5 |
514 | 2023-08-16 20:18:34 | magpie | 3 | 112716 | 378 | 6.750 | 16698.7 |
513 | 2023-08-15 20:15:29 | magpie | 3 | 112716 | 378 | 4.656 | 24208.8 |
512 | 2023-08-15 17:01:28 | magpie | 3 | 112716 | 378 | 5.470 | 20606.2 |
511 | 2023-08-14 02:34:23 | magpie | 3 | 112716 | 378 | 5.140 | 21929.2 |
510 | 2023-08-12 00:38:12 | magpie | 3 | 112716 | 378 | 5.076 | 22205.7 |
509 | 2023-08-10 06:18:25 | magpie | 3 | 112716 | 378 | 5.063 | 22262.7 |
508 | 2023-07-23 05:18:54 | magpie | 1 | 48755 | 2 | 0.780 | 62506.4 |
507 | 2023-07-16 16:38:00 | magpie | 1 | 48755 | 2 | 0.860 | 56691.9 |
506 | 2023-07-15 17:01:51 | magpie | 3 | 112716 | 378 | 5.580 | 20200.0 |
505 | 2023-07-14 19:47:13 | magpie | 3 | 112716 | 378 | 4.610 | 24450.3 |
504 | 2023-07-09 12:11:31 | magpie | 3 | 112716 | 378 | 5.596 | 20142.2 |
503 | 2023-07-08 20:52:32 | magpie | 3 | 112716 | 378 | 4.846 | 23259.6 |
502 | 2023-07-08 01:32:42 | magpie | 3 | 112716 | 378 | 4.623 | 24381.6 |
501 | 2023-07-07 00:54:54 | magpie | 3 | 112716 | 378 | 4.843 | 23274.0 |
500 | 2023-07-05 06:14:37 | magpie | 3 | 112716 | 378 | 4.796 | 23502.1 |