History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pilea"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
597 | 2024-12-28 23:57:16 | pilea | 2 | 53800 | 145 | 6.576 | 8181.3 |
596 | 2024-12-28 21:51:09 | pilea | 2 | 53800 | 145 | 4.123 | 13048.8 |
595 | 2024-12-28 21:06:42 | pilea | 2 | 53800 | 145 | 4.356 | 12350.8 |
594 | 2024-12-28 21:06:17 | pilea | 1 | 28756 | 8 | 0.966 | 29768.1 |
593 | 2024-12-27 05:29:19 | pilea | 1 | 28756 | 8 | 0.436 | 65954.1 |
592 | 2024-12-26 19:06:25 | pilea | 1 | 28756 | 8 | 3.263 | 8812.7 |
591 | 2024-12-07 01:40:00 | pilea | 2 | 53800 | 145 | 4.846 | 11101.9 |
590 | 2024-12-06 23:35:29 | pilea | 1 | 28756 | 8 | 3.343 | 8601.9 |
589 | 2024-11-28 20:25:21 | pilea | 2 | 53800 | 145 | 8.006 | 6720.0 |
588 | 2024-11-28 16:22:32 | pilea | 2 | 53800 | 145 | 8.186 | 6572.2 |
587 | 2024-11-28 15:59:33 | pilea | 2 | 53800 | 145 | 7.173 | 7500.3 |
586 | 2024-11-28 15:54:47 | pilea | 1 | 28756 | 8 | 0.533 | 53951.2 |
585 | 2024-11-27 03:05:17 | pilea | 1 | 28756 | 8 | 1.750 | 16432.0 |
584 | 2024-11-26 15:32:38 | pilea | 1 | 28756 | 8 | 1.890 | 15214.8 |
583 | 2024-11-06 22:12:19 | pilea | 1 | 28756 | 8 | 3.873 | 7424.7 |
582 | 2024-10-29 16:30:55 | pilea | 2 | 53800 | 145 | 4.033 | 13339.9 |
581 | 2024-10-29 13:45:03 | pilea | 2 | 53800 | 145 | 7.656 | 7027.2 |
580 | 2024-10-29 12:54:09 | pilea | 2 | 53800 | 145 | 8.826 | 6095.6 |
579 | 2024-10-29 12:51:25 | pilea | 1 | 28756 | 8 | 0.563 | 51076.4 |
578 | 2024-10-28 03:06:03 | pilea | 1 | 28756 | 8 | 1.016 | 28303.1 |
577 | 2024-10-27 05:46:19 | pilea | 1 | 28756 | 8 | 2.610 | 11017.6 |
576 | 2024-10-07 10:52:52 | pilea | 1 | 28756 | 8 | 3.983 | 7219.7 |
575 | 2024-09-29 12:18:27 | pilea | 1 | 28756 | 8 | 1.733 | 16593.2 |
574 | 2024-09-28 01:25:09 | pilea | 1 | 28756 | 8 | 3.546 | 8109.4 |
573 | 2024-09-27 00:51:19 | pilea | 1 | 28756 | 8 | 2.733 | 10521.8 |
572 | 2024-09-07 09:43:14 | pilea | 1 | 28756 | 8 | 2.220 | 12953.2 |
571 | 2024-08-30 10:13:23 | pilea | 1 | 28756 | 8 | 3.953 | 7274.5 |
570 | 2024-08-29 22:04:21 | pilea | 1 | 28756 | 8 | 1.750 | 16432.0 |
569 | 2024-08-29 11:32:08 | pilea | 2 | 53800 | 145 | 17.063 | 3153.0 |
568 | 2024-08-28 23:25:16 | pilea | 2 | 53800 | 145 | 19.800 | 2717.2 |
567 | 2024-08-28 20:44:14 | pilea | 2 | 53800 | 145 | 10.860 | 4954.0 |
566 | 2024-08-28 20:08:43 | pilea | 1 | 28756 | 8 | 0.500 | 57512.0 |
565 | 2024-08-28 14:47:46 | pilea | 1 | 28756 | 8 | 2.703 | 10638.5 |
564 | 2024-08-19 16:04:47 | pilea | 1 | 28756 | 8 | 2.330 | 12341.6 |
563 | 2024-08-12 12:41:48 | pilea | 1 | 28756 | 8 | 3.343 | 8601.9 |
562 | 2024-08-09 12:39:09 | pilea | 1 | 28756 | 8 | 1.263 | 22768.0 |
561 | 2024-08-08 01:14:10 | pilea | 1 | 28756 | 8 | 0.970 | 29645.4 |
560 | 2024-08-07 09:26:08 | pilea | 1 | 28756 | 8 | 1.000 | 28756.0 |
559 | 2024-07-30 17:00:24 | pilea | 1 | 28756 | 8 | 1.406 | 20452.3 |
558 | 2024-07-30 05:46:05 | pilea | 1 | 28756 | 8 | 0.546 | 52666.7 |
557 | 2024-07-29 15:07:24 | pilea | 1 | 28756 | 8 | 0.500 | 57512.0 |
556 | 2024-07-27 15:17:41 | pilea | 1 | 28756 | 8 | 1.030 | 27918.4 |
555 | 2024-07-22 09:41:03 | pilea | 1 | 28756 | 8 | 3.000 | 9585.3 |
554 | 2024-07-10 05:34:12 | pilea | 1 | 28756 | 8 | 3.360 | 8558.3 |
553 | 2024-07-06 23:39:46 | pilea | 1 | 28756 | 8 | 0.906 | 31739.5 |
552 | 2024-07-03 00:09:10 | pilea | 1 | 28756 | 8 | 0.670 | 42919.4 |
551 | 2024-07-01 20:42:22 | pilea | 1 | 28756 | 8 | 1.153 | 24940.2 |
550 | 2024-07-01 20:36:19 | pilea | 1 | 28756 | 8 | 2.860 | 10054.5 |
549 | 2024-06-30 23:25:45 | pilea | 2 | 53800 | 145 | 7.313 | 7356.8 |
548 | 2024-06-30 22:52:31 | pilea | 2 | 53800 | 145 | 1.390 | 38705.0 |
547 | 2024-06-30 15:45:39 | pilea | 1 | 28756 | 8 | 2.846 | 10104.0 |
546 | 2024-06-29 14:07:47 | pilea | 1 | 28756 | 8 | 1.576 | 18246.2 |
545 | 2024-06-27 10:48:26 | pilea | 1 | 28756 | 8 | 2.563 | 11219.7 |
544 | 2024-06-08 21:25:41 | pilea | 1 | 28756 | 8 | 1.420 | 20250.7 |
543 | 2024-06-04 23:42:30 | pilea | 2 | 53800 | 145 | 2.220 | 24234.2 |
542 | 2024-06-03 13:03:51 | pilea | 2 | 53800 | 145 | 6.423 | 8376.1 |
541 | 2024-06-03 12:39:19 | pilea | 1 | 28756 | 8 | 0.563 | 51076.4 |
540 | 2024-05-30 05:40:42 | pilea | 1 | 28756 | 8 | 1.656 | 17364.7 |
539 | 2024-05-28 06:22:53 | pilea | 1 | 28756 | 8 | 1.013 | 28387.0 |
538 | 2024-05-12 22:26:12 | pilea | 1 | 28756 | 8 | 1.686 | 17055.8 |
537 | 2024-05-04 08:34:55 | pilea | 1 | 28756 | 8 | 0.516 | 55728.7 |
536 | 2024-04-27 17:40:02 | pilea | 1 | 28756 | 8 | 0.563 | 51076.4 |
535 | 2024-04-19 02:27:23 | pilea | 1 | 28756 | 8 | 0.516 | 55728.7 |
534 | 2024-04-04 23:25:04 | pilea | 1 | 28756 | 8 | 2.250 | 12780.4 |
533 | 2024-04-03 06:52:11 | pilea | 1 | 28756 | 8 | 0.530 | 54256.6 |
532 | 2024-03-31 03:20:13 | pilea | 1 | 28756 | 8 | 0.516 | 55728.7 |
531 | 2024-03-29 02:22:46 | pilea | 1 | 28756 | 8 | 0.513 | 56054.6 |
530 | 2024-03-29 02:22:41 | pilea | 2 | 53800 | 145 | 1.733 | 31044.4 |
529 | 2024-03-28 18:55:14 | pilea | 2 | 53800 | 145 | 5.640 | 9539.0 |
528 | 2024-03-28 18:12:03 | pilea | 1 | 28756 | 8 | 1.406 | 20452.3 |
527 | 2024-03-03 21:25:52 | pilea | 1 | 28756 | 8 | 1.090 | 26381.7 |
526 | 2024-02-26 14:50:23 | pilea | 2 | 53800 | 145 | 1.733 | 31044.4 |
525 | 2024-02-26 14:50:21 | pilea | 1 | 28756 | 8 | 0.593 | 48492.4 |
524 | 2024-01-27 09:10:21 | pilea | 1 | 28756 | 8 | 0.483 | 59536.2 |
523 | 2024-01-24 14:30:41 | pilea | 2 | 53800 | 145 | 1.406 | 38264.6 |
522 | 2024-01-24 01:08:18 | pilea | 1 | 28756 | 8 | 0.436 | 65954.1 |
521 | 2024-01-06 23:00:17 | pilea | 1 | 28756 | 8 | 0.450 | 63902.2 |
520 | 2024-01-02 13:41:22 | pilea | 2 | 53800 | 145 | 1.563 | 34421.0 |
519 | 2023-12-30 03:43:26 | pilea | 1 | 28756 | 8 | 0.483 | 59536.2 |
518 | 2023-12-26 14:40:09 | pilea | 1 | 28756 | 8 | 0.483 | 59536.2 |
517 | 2023-12-17 10:02:10 | pilea | 2 | 53800 | 145 | 1.420 | 37887.3 |
516 | 2023-12-16 03:50:04 | pilea | 2 | 53800 | 145 | 1.610 | 33416.1 |
515 | 2023-12-14 19:47:22 | pilea | 1 | 28756 | 8 | 0.453 | 63479.0 |
514 | 2023-11-18 12:24:14 | pilea | 1 | 28756 | 8 | 0.563 | 51076.4 |
513 | 2023-11-16 18:11:46 | pilea | 2 | 53800 | 145 | 1.373 | 39184.3 |
512 | 2023-11-14 00:44:50 | pilea | 1 | 28756 | 8 | 0.530 | 54256.6 |
511 | 2023-11-11 20:09:06 | pilea | 1 | 28756 | 8 | 0.453 | 63479.0 |
510 | 2023-11-04 02:36:26 | pilea | 2 | 53800 | 145 | 1.420 | 37887.3 |
509 | 2023-10-29 06:31:39 | pilea | 1 | 28756 | 8 | 0.483 | 59536.2 |
508 | 2023-10-21 11:34:06 | pilea | 1 | 28756 | 8 | 0.486 | 59168.7 |
507 | 2023-10-18 06:49:12 | pilea | 1 | 28756 | 8 | 0.453 | 63479.0 |
506 | 2023-10-17 21:06:11 | pilea | 1 | 28756 | 8 | 1.063 | 27051.7 |
505 | 2023-10-13 23:24:37 | pilea | 1 | 28756 | 8 | 0.483 | 59536.2 |
504 | 2023-10-05 17:36:20 | pilea | 1 | 28756 | 8 | 0.436 | 65954.1 |
503 | 2023-10-04 02:21:31 | pilea | 1 | 28756 | 8 | 0.606 | 47452.1 |
502 | 2023-09-30 21:50:04 | pilea | 1 | 28756 | 8 | 0.533 | 53951.2 |
501 | 2023-09-28 23:50:31 | pilea | 1 | 28756 | 8 | 0.483 | 59536.2 |
500 | 2023-09-26 18:39:18 | pilea | 2 | 53800 | 145 | 2.280 | 23596.5 |
499 | 2023-09-12 18:37:30 | pilea | 1 | 28756 | 8 | 0.486 | 59168.7 |
498 | 2023-08-13 04:37:15 | pilea | 1 | 28756 | 8 | 0.436 | 65954.1 |