History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opera"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
570 | 2024-04-15 23:00:03 | opera | 2 | 53800 | 67 | 4.936 | 10899.5 |
569 | 2024-04-15 21:39:31 | opera | 3 | 83667 | 1050 | 5.046 | 16580.9 |
568 | 2024-04-13 08:33:09 | opera | 2 | 53800 | 67 | 1.623 | 33148.5 |
567 | 2024-04-13 08:32:53 | opera | 3 | 83667 | 1050 | 3.843 | 21771.3 |
566 | 2024-04-13 08:32:49 | opera | 1 | 28756 | 2 | 1.013 | 28387.0 |
565 | 2024-04-13 08:32:48 | opera | 2 | 53800 | 67 | 1.703 | 31591.3 |
564 | 2024-04-13 08:32:28 | opera | 3 | 83667 | 1050 | 3.923 | 21327.3 |
563 | 2024-04-13 06:35:27 | opera | 3 | 83667 | 1050 | 3.826 | 21868.0 |
562 | 2024-04-06 12:11:03 | opera | 1 | 28756 | 2 | 1.910 | 15055.5 |
561 | 2024-03-31 16:10:15 | opera | 1 | 28756 | 2 | 0.516 | 55728.7 |
560 | 2024-03-30 08:45:49 | opera | 1 | 28756 | 2 | 0.546 | 52666.7 |
559 | 2024-03-29 09:11:37 | opera | 1 | 28756 | 2 | 1.750 | 16432.0 |
558 | 2024-03-07 06:33:42 | opera | 3 | 83667 | 1050 | 7.190 | 11636.6 |
557 | 2024-03-07 06:33:43 | opera | 2 | 53800 | 67 | 3.673 | 14647.4 |
556 | 2024-03-07 05:07:18 | opera | 1 | 28756 | 2 | 1.640 | 17534.1 |
555 | 2024-03-01 12:12:40 | opera | 1 | 28756 | 2 | 0.423 | 67981.1 |
554 | 2024-02-28 19:10:52 | opera | 2 | 53800 | 67 | 1.500 | 35866.7 |
553 | 2024-02-28 18:35:09 | opera | 2 | 53800 | 67 | 1.376 | 39098.8 |
552 | 2024-02-28 18:23:14 | opera | 3 | 83667 | 1050 | 3.313 | 25254.2 |
551 | 2024-02-28 17:58:57 | opera | 3 | 83667 | 1050 | 3.313 | 25254.2 |
550 | 2024-02-28 09:51:26 | opera | 3 | 83667 | 1050 | 8.343 | 10028.4 |
549 | 2024-02-28 09:51:24 | opera | 2 | 53800 | 67 | 2.766 | 19450.5 |
548 | 2024-02-28 08:01:46 | opera | 1 | 28756 | 2 | 1.110 | 25906.3 |
547 | 2024-02-07 02:27:19 | opera | 1 | 28756 | 2 | 0.546 | 52666.7 |
546 | 2024-02-03 23:21:31 | opera | 1 | 28756 | 2 | 0.423 | 67981.1 |
545 | 2024-02-03 07:11:18 | opera | 1 | 28756 | 2 | 0.500 | 57512.0 |
544 | 2024-01-29 08:04:03 | opera | 1 | 28756 | 2 | 0.436 | 65954.1 |
543 | 2024-01-29 03:02:53 | opera | 1 | 28756 | 2 | 0.483 | 59536.2 |
542 | 2024-01-23 15:28:52 | opera | 3 | 83667 | 1050 | 7.766 | 10773.5 |
541 | 2024-01-23 11:40:02 | opera | 3 | 83667 | 1050 | 9.140 | 9153.9 |
540 | 2024-01-11 04:50:42 | opera | 2 | 53800 | 67 | 1.576 | 34137.1 |
539 | 2023-12-29 17:18:17 | opera | 3 | 83667 | 1050 | 3.893 | 21491.7 |
538 | 2023-12-27 03:27:09 | opera | 3 | 83667 | 1050 | 3.783 | 22116.6 |
537 | 2023-12-27 03:27:10 | opera | 2 | 53800 | 67 | 1.610 | 33416.1 |
536 | 2023-12-20 19:46:41 | opera | 1 | 28756 | 2 | 0.466 | 61708.2 |
535 | 2023-12-16 21:22:02 | opera | 3 | 83667 | 1050 | 9.263 | 9032.4 |
534 | 2023-12-16 21:22:05 | opera | 2 | 53800 | 67 | 3.813 | 14109.6 |
533 | 2023-12-12 00:54:11 | opera | 3 | 83667 | 1050 | 3.266 | 25617.6 |
532 | 2023-11-13 23:12:34 | opera | 1 | 28756 | 2 | 0.436 | 65954.1 |
531 | 2023-11-11 22:01:24 | opera | 1 | 28756 | 2 | 0.486 | 59168.7 |
530 | 2023-11-03 07:00:22 | opera | 1 | 28756 | 2 | 0.420 | 68466.7 |
529 | 2023-11-01 23:25:55 | opera | 1 | 28756 | 2 | 0.423 | 67981.1 |
528 | 2023-10-30 07:19:45 | opera | 3 | 83667 | 1050 | 4.330 | 19322.6 |
527 | 2023-10-22 19:15:24 | opera | 1 | 28756 | 2 | 1.063 | 27051.7 |
526 | 2023-10-19 23:20:43 | opera | 3 | 83667 | 1050 | 4.343 | 19264.8 |
525 | 2023-10-19 23:20:42 | opera | 2 | 53800 | 67 | 2.096 | 25667.9 |
524 | 2023-10-19 22:20:33 | opera | 2 | 53800 | 67 | 1.406 | 38264.6 |
523 | 2023-10-16 21:17:38 | opera | 1 | 28756 | 2 | 0.436 | 65954.1 |
522 | 2023-10-13 01:12:51 | opera | 1 | 28756 | 2 | 0.576 | 49923.6 |
521 | 2023-10-08 08:03:10 | opera | 1 | 28756 | 2 | 0.466 | 61708.2 |
520 | 2023-10-07 09:52:30 | opera | 1 | 28756 | 2 | 0.500 | 57512.0 |
519 | 2023-09-29 00:30:43 | opera | 1 | 28756 | 2 | 1.033 | 27837.4 |
518 | 2023-09-20 09:35:10 | opera | 2 | 53800 | 67 | 1.376 | 39098.8 |
517 | 2023-09-14 07:03:25 | opera | 1 | 28756 | 2 | 0.500 | 57512.0 |
516 | 2023-09-10 18:21:32 | opera | 3 | 83667 | 1050 | 4.076 | 20526.7 |
515 | 2023-09-09 17:04:44 | opera | 3 | 83667 | 1050 | 3.720 | 22491.1 |
514 | 2023-08-28 14:52:37 | opera | 3 | 83667 | 1050 | 3.733 | 22412.8 |
513 | 2023-08-04 05:05:25 | opera | 1 | 28756 | 2 | 0.483 | 59536.2 |
512 | 2023-07-31 13:20:52 | opera | 2 | 53800 | 67 | 1.373 | 39184.3 |
511 | 2023-07-13 13:14:05 | opera | 1 | 28756 | 2 | 0.436 | 65954.1 |
510 | 2023-05-27 07:10:31 | opera | 3 | 83667 | 1050 | 3.283 | 25484.9 |
509 | 2023-05-05 05:11:44 | opera | 1 | 28756 | 2 | 0.420 | 68466.7 |
508 | 2023-04-07 10:31:37 | opera | 2 | 53800 | 67 | 1.513 | 35558.5 |
507 | 2023-03-29 11:39:37 | opera | 1 | 28756 | 2 | 0.470 | 61183.0 |
506 | 2023-03-05 17:57:03 | opera | 3 | 83667 | 1050 | 3.280 | 25508.2 |
505 | 2023-02-27 02:30:35 | opera | 1 | 28756 | 2 | 0.423 | 67981.1 |
504 | 2023-01-29 23:11:29 | opera | 2 | 53800 | 67 | 1.343 | 40059.6 |
503 | 2023-01-03 10:58:11 | opera | 2 | 53800 | 67 | 1.326 | 40573.2 |
502 | 2022-12-30 11:15:38 | opera | 3 | 83667 | 1050 | 3.923 | 21327.3 |
501 | 2022-12-25 03:08:11 | opera | 1 | 28756 | 2 | 0.500 | 57512.0 |
500 | 2022-12-15 06:39:24 | opera | 2 | 53800 | 67 | 1.656 | 32487.9 |
499 | 2022-12-12 12:07:32 | opera | 3 | 83667 | 1050 | 3.233 | 25879.1 |
498 | 2022-12-07 19:45:16 | opera | 3 | 83667 | 1050 | 3.690 | 22674.0 |
497 | 2022-12-07 14:19:11 | opera | 1 | 28756 | 2 | 0.436 | 65954.1 |
496 | 2022-10-30 11:18:48 | opera | 2 | 53800 | 67 | 2.750 | 19563.6 |
495 | 2022-10-28 22:33:43 | opera | 3 | 83667 | 1050 | 3.233 | 25879.1 |
494 | 2022-10-01 03:41:24 | opera | 1 | 28756 | 2 | 0.436 | 65954.1 |
493 | 2022-09-19 20:04:54 | opera | 1 | 28756 | 2 | 0.436 | 65954.1 |
492 | 2022-09-18 05:27:50 | opera | 2 | 53800 | 67 | 1.356 | 39675.5 |
491 | 2022-09-18 05:25:37 | opera | 3 | 83667 | 1050 | 3.280 | 25508.2 |
490 | 2022-09-12 03:17:05 | opera | 1 | 28756 | 2 | 0.436 | 65954.1 |
489 | 2022-09-10 01:07:58 | opera | 1 | 28756 | 2 | 0.420 | 68466.7 |
488 | 2022-09-06 20:31:14 | opera | 2 | 53800 | 67 | 1.343 | 40059.6 |
487 | 2022-09-01 13:34:47 | opera | 1 | 28756 | 2 | 0.500 | 57512.0 |
486 | 2022-08-23 09:47:00 | opera | 2 | 53800 | 67 | 1.466 | 36698.5 |
485 | 2022-08-23 09:45:44 | opera | 3 | 83667 | 1050 | 3.906 | 21420.1 |
484 | 2022-08-14 02:08:30 | opera | 1 | 28756 | 2 | 0.436 | 65954.1 |
483 | 2022-08-10 15:39:22 | opera | 1 | 28756 | 2 | 0.450 | 63902.2 |
482 | 2022-08-06 20:27:01 | opera | 1 | 28756 | 2 | 0.423 | 67981.1 |
481 | 2022-07-28 13:48:52 | opera | 3 | 83667 | 1050 | 3.310 | 25277.0 |
480 | 2022-07-17 19:08:28 | opera | 1 | 28756 | 2 | 0.440 | 65354.5 |
479 | 2022-07-10 23:26:44 | opera | 2 | 53800 | 67 | 1.346 | 39970.3 |
478 | 2022-07-10 23:25:48 | opera | 3 | 83667 | 1050 | 3.470 | 24111.5 |
477 | 2022-07-03 07:47:43 | opera | 1 | 28756 | 2 | 0.453 | 63479.0 |
476 | 2022-07-02 08:05:10 | opera | 3 | 83667 | 1050 | 3.233 | 25879.1 |
475 | 2022-07-02 07:03:42 | opera | 1 | 28756 | 2 | 0.440 | 65354.5 |
474 | 2022-06-25 17:33:28 | opera | 2 | 53800 | 67 | 1.393 | 38621.7 |
473 | 2022-06-25 17:33:06 | opera | 3 | 83667 | 1050 | 3.343 | 25027.5 |
472 | 2022-06-16 07:48:23 | opera | 1 | 28756 | 2 | 0.436 | 65954.1 |
471 | 2022-06-15 18:16:52 | opera | 1 | 28756 | 2 | 0.453 | 63479.0 |