History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"summa"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
564 | 2024-04-27 22:36:19 | summa | 1 | 28756 | 4 | 0.593 | 48492.4 |
563 | 2024-04-03 05:49:42 | summa | 1 | 28756 | 4 | 1.280 | 22465.6 |
562 | 2024-04-03 01:16:24 | summa | 3 | 83667 | 618 | 13.890 | 6023.5 |
561 | 2024-04-01 23:03:35 | summa | 2 | 53800 | 56 | 1.783 | 30173.9 |
560 | 2024-04-01 23:03:33 | summa | 1 | 28756 | 4 | 0.546 | 52666.7 |
559 | 2024-04-01 23:03:09 | summa | 3 | 83667 | 618 | 7.406 | 11297.2 |
558 | 2024-03-31 18:05:07 | summa | 3 | 83667 | 618 | 19.876 | 4209.4 |
557 | 2024-03-31 10:24:22 | summa | 3 | 83667 | 618 | 13.420 | 6234.5 |
556 | 2024-03-31 10:24:17 | summa | 2 | 53800 | 56 | 3.190 | 16865.2 |
555 | 2024-03-31 08:14:28 | summa | 1 | 28756 | 4 | 1.016 | 28303.1 |
554 | 2024-03-29 09:44:28 | summa | 1 | 28756 | 4 | 0.516 | 55728.7 |
553 | 2024-03-03 21:08:11 | summa | 1 | 28756 | 4 | 0.546 | 52666.7 |
552 | 2024-03-01 06:35:59 | summa | 1 | 28756 | 4 | 0.733 | 39230.6 |
551 | 2024-02-28 02:30:35 | summa | 1 | 28756 | 4 | 0.546 | 52666.7 |
550 | 2024-01-29 00:46:33 | summa | 1 | 28756 | 4 | 0.516 | 55728.7 |
549 | 2024-01-28 20:41:27 | summa | 1 | 28756 | 4 | 0.470 | 61183.0 |
548 | 2024-01-26 21:22:34 | summa | 1 | 28756 | 4 | 0.440 | 65354.5 |
547 | 2024-01-21 15:36:28 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
546 | 2024-01-14 08:33:48 | summa | 3 | 83667 | 618 | 3.453 | 24230.2 |
545 | 2024-01-14 08:33:46 | summa | 2 | 53800 | 56 | 1.453 | 37026.8 |
544 | 2024-01-02 21:45:20 | summa | 3 | 83667 | 618 | 4.000 | 20916.8 |
543 | 2023-12-31 17:43:28 | summa | 2 | 53800 | 56 | 1.453 | 37026.8 |
542 | 2023-11-30 19:54:55 | summa | 3 | 83667 | 618 | 3.876 | 21585.9 |
541 | 2023-11-30 19:54:57 | summa | 2 | 53800 | 56 | 1.656 | 32487.9 |
540 | 2023-11-21 14:33:51 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
539 | 2023-11-17 14:37:34 | summa | 1 | 28756 | 4 | 1.030 | 27918.4 |
538 | 2023-11-13 16:14:26 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
537 | 2023-11-03 07:18:08 | summa | 1 | 28756 | 4 | 0.470 | 61183.0 |
536 | 2023-10-22 03:48:36 | summa | 1 | 28756 | 4 | 0.516 | 55728.7 |
535 | 2023-10-18 12:28:56 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
534 | 2023-10-13 09:06:36 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
533 | 2023-10-05 02:31:28 | summa | 1 | 28756 | 4 | 0.533 | 53951.2 |
532 | 2023-09-28 23:09:29 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
531 | 2023-09-13 13:52:32 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
530 | 2023-09-07 17:43:46 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
529 | 2023-09-04 01:36:22 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
528 | 2023-08-31 20:30:07 | summa | 1 | 28756 | 4 | 0.483 | 59536.2 |
527 | 2023-06-12 14:52:16 | summa | 1 | 28756 | 4 | 0.436 | 65954.1 |
526 | 2023-05-04 01:00:57 | summa | 1 | 28756 | 4 | 1.346 | 21364.0 |
525 | 2023-03-29 17:03:57 | summa | 1 | 28756 | 4 | 0.486 | 59168.7 |
524 | 2023-01-13 23:58:55 | summa | 1 | 28756 | 4 | 0.513 | 56054.6 |
523 | 2023-01-03 02:20:21 | summa | 1 | 28756 | 4 | 1.033 | 27837.4 |
522 | 2022-11-02 04:12:02 | summa | 1 | 28756 | 4 | 0.436 | 65954.1 |
521 | 2022-08-22 19:09:26 | summa | 1 | 28756 | 4 | 0.450 | 63902.2 |
520 | 2022-07-31 01:25:44 | summa | 1 | 28756 | 4 | 0.906 | 31739.5 |
519 | 2022-07-29 04:20:23 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
518 | 2022-07-14 11:03:03 | summa | 2 | 53800 | 56 | 1.390 | 38705.0 |
517 | 2022-06-21 19:36:25 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
516 | 2022-06-19 14:22:28 | summa | 1 | 28756 | 4 | 0.466 | 61708.2 |
515 | 2022-04-08 06:46:22 | summa | 1 | 28756 | 4 | 0.513 | 56054.6 |
514 | 2022-02-22 17:42:30 | summa | 1 | 28756 | 4 | 0.516 | 55728.7 |
513 | 2021-12-08 04:06:10 | summa | 1 | 28756 | 4 | 0.546 | 52666.7 |
512 | 2021-12-07 16:54:44 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
511 | 2021-12-05 13:48:44 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
510 | 2021-10-14 23:39:20 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
509 | 2021-09-08 23:47:06 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
508 | 2021-08-22 09:00:55 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
507 | 2021-08-15 03:04:11 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
506 | 2021-08-11 18:46:40 | summa | 1 | 28756 | 4 | 0.440 | 65354.5 |
505 | 2021-06-22 04:23:36 | summa | 2 | 53800 | 56 | 1.373 | 39184.3 |
504 | 2021-05-20 23:52:08 | summa | 1 | 28756 | 4 | 0.530 | 54256.6 |
503 | 2021-04-27 00:13:15 | summa | 1 | 28756 | 4 | 0.516 | 55728.7 |
502 | 2021-04-02 17:28:02 | summa | 2 | 53800 | 56 | 1.390 | 38705.0 |
501 | 2021-03-28 05:12:19 | summa | 1 | 28756 | 4 | 0.470 | 61183.0 |
500 | 2021-03-27 12:59:37 | summa | 1 | 28756 | 4 | 0.530 | 54256.6 |
499 | 2021-03-24 06:45:17 | summa | 1 | 28756 | 4 | 0.516 | 55728.7 |
498 | 2021-03-23 20:05:03 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
497 | 2021-03-23 01:04:06 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
496 | 2021-03-21 19:15:40 | summa | 1 | 28756 | 4 | 0.483 | 59536.2 |
495 | 2021-03-14 13:31:42 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
494 | 2021-03-11 04:06:59 | summa | 1 | 28756 | 4 | 0.436 | 65954.1 |
493 | 2021-03-09 05:32:15 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
492 | 2021-03-07 07:11:00 | summa | 2 | 53800 | 56 | 1.390 | 38705.0 |
491 | 2021-03-05 05:11:49 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
490 | 2021-03-03 03:57:20 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
489 | 2021-03-01 04:43:57 | summa | 1 | 28756 | 4 | 0.450 | 63902.2 |
488 | 2021-02-27 04:32:57 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
487 | 2021-02-26 01:23:27 | summa | 1 | 28756 | 4 | 0.483 | 59536.2 |
486 | 2021-02-20 14:33:43 | summa | 2 | 53800 | 56 | 1.576 | 34137.1 |
485 | 2021-02-11 06:05:37 | summa | 2 | 53800 | 56 | 1.406 | 38264.6 |
484 | 2021-02-05 12:46:01 | summa | 1 | 28756 | 4 | 0.513 | 56054.6 |
483 | 2021-02-04 14:11:45 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
482 | 2021-02-02 13:48:39 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
481 | 2021-02-02 01:24:37 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
480 | 2021-01-31 18:46:26 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
479 | 2021-01-31 02:11:19 | summa | 1 | 28756 | 4 | 0.466 | 61708.2 |
478 | 2021-01-29 02:32:23 | summa | 1 | 28756 | 4 | 0.593 | 48492.4 |
477 | 2021-01-28 16:48:49 | summa | 1 | 28756 | 4 | 0.456 | 63061.4 |
476 | 2021-01-28 00:58:29 | summa | 1 | 28756 | 4 | 0.516 | 55728.7 |
475 | 2021-01-27 01:28:49 | summa | 1 | 28756 | 4 | 0.436 | 65954.1 |
474 | 2021-01-25 04:54:23 | summa | 1 | 28756 | 4 | 0.483 | 59536.2 |
473 | 2021-01-24 04:31:23 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
472 | 2021-01-22 12:17:10 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
471 | 2021-01-20 10:35:26 | summa | 1 | 28756 | 4 | 0.530 | 54256.6 |
470 | 2021-01-20 03:53:06 | summa | 1 | 28756 | 4 | 0.453 | 63479.0 |
469 | 2021-01-14 01:49:10 | summa | 1 | 28756 | 4 | 0.483 | 59536.2 |
468 | 2021-01-12 02:39:59 | summa | 1 | 28756 | 4 | 0.436 | 65954.1 |
467 | 2021-01-10 05:18:58 | summa | 1 | 28756 | 4 | 0.500 | 57512.0 |
466 | 2021-01-08 01:48:39 | summa | 1 | 28756 | 4 | 0.466 | 61708.2 |
465 | 2021-01-06 04:07:06 | summa | 1 | 28756 | 4 | 0.513 | 56054.6 |