History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rolf"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
570 | 2024-04-27 22:42:31 | rolf | 2 | 29872 | 170 | 1.110 | 26911.7 |
569 | 2024-04-27 00:06:25 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
568 | 2024-04-10 10:18:44 | rolf | 1 | 13983 | 7 | 0.280 | 49939.3 |
567 | 2024-04-10 05:17:11 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
566 | 2024-04-06 00:54:49 | rolf | 1 | 13983 | 7 | 0.500 | 27966.0 |
565 | 2024-04-02 20:45:27 | rolf | 1 | 13983 | 7 | 0.283 | 49409.9 |
564 | 2024-04-01 16:11:50 | rolf | 1 | 13983 | 7 | 1.110 | 12597.3 |
563 | 2024-03-28 19:17:35 | rolf | 2 | 29872 | 170 | 2.173 | 13746.9 |
562 | 2024-03-28 17:46:56 | rolf | 1 | 13983 | 7 | 0.216 | 64736.1 |
561 | 2024-03-10 20:04:30 | rolf | 1 | 13983 | 7 | 0.266 | 52567.7 |
560 | 2024-03-03 19:41:30 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
559 | 2024-03-02 13:50:29 | rolf | 1 | 13983 | 7 | 0.533 | 26234.5 |
558 | 2024-02-29 22:31:31 | rolf | 2 | 29872 | 170 | 0.826 | 36164.6 |
557 | 2024-02-25 18:58:36 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
556 | 2024-02-08 13:33:20 | rolf | 1 | 13983 | 7 | 0.263 | 53167.3 |
555 | 2024-02-02 17:21:43 | rolf | 1 | 13983 | 7 | 0.203 | 68881.8 |
554 | 2024-02-01 11:03:35 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
553 | 2024-01-26 07:50:45 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
552 | 2024-01-09 12:40:08 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
551 | 2024-01-08 09:38:09 | rolf | 1 | 13983 | 7 | 0.266 | 52567.7 |
550 | 2024-01-04 16:23:44 | rolf | 1 | 13983 | 7 | 0.360 | 38841.7 |
549 | 2023-12-31 04:38:22 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
548 | 2023-12-25 00:58:54 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
547 | 2023-12-16 15:16:00 | rolf | 2 | 29872 | 170 | 0.890 | 33564.0 |
546 | 2023-11-30 22:01:21 | rolf | 2 | 29872 | 170 | 0.873 | 34217.6 |
545 | 2023-11-22 12:28:58 | rolf | 2 | 29872 | 170 | 0.780 | 38297.4 |
544 | 2023-11-21 11:39:26 | rolf | 1 | 13983 | 7 | 0.216 | 64736.1 |
543 | 2023-11-11 21:48:51 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
542 | 2023-10-27 17:33:14 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
541 | 2023-10-20 07:20:36 | rolf | 1 | 13983 | 7 | 0.266 | 52567.7 |
540 | 2023-10-18 18:07:34 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
539 | 2023-10-13 00:29:37 | rolf | 1 | 13983 | 7 | 0.266 | 52567.7 |
538 | 2023-10-12 07:24:07 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
537 | 2023-10-03 17:09:40 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
536 | 2023-09-29 20:16:24 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
535 | 2023-09-02 06:53:57 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
534 | 2023-08-23 13:15:54 | rolf | 2 | 29872 | 170 | 0.780 | 38297.4 |
533 | 2023-08-08 22:19:05 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
532 | 2023-05-08 08:12:46 | rolf | 2 | 29872 | 170 | 0.766 | 38997.4 |
531 | 2023-05-05 19:09:32 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
530 | 2023-05-05 16:54:46 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
529 | 2023-03-03 12:34:25 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
528 | 2023-02-16 01:02:55 | rolf | 2 | 29872 | 170 | 0.766 | 38997.4 |
527 | 2023-01-12 05:11:24 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
526 | 2022-12-27 15:54:43 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
525 | 2022-11-27 01:42:21 | rolf | 2 | 29872 | 170 | 0.783 | 38150.7 |
524 | 2022-09-15 20:11:07 | rolf | 1 | 13983 | 7 | 0.216 | 64736.1 |
523 | 2022-09-06 17:43:38 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
522 | 2022-09-03 09:18:11 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
521 | 2022-07-19 16:38:41 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
520 | 2022-07-18 04:49:39 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
519 | 2022-07-10 07:39:17 | rolf | 1 | 13983 | 7 | 0.216 | 64736.1 |
518 | 2022-06-25 12:43:19 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
517 | 2022-06-01 22:13:53 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
516 | 2022-06-01 17:35:49 | rolf | 1 | 13983 | 7 | 0.236 | 59250.0 |
515 | 2022-04-23 15:56:37 | rolf | 1 | 13983 | 7 | 0.203 | 68881.8 |
514 | 2022-04-17 08:03:24 | rolf | 2 | 29872 | 170 | 0.766 | 38997.4 |
513 | 2022-03-17 03:23:47 | rolf | 1 | 13983 | 7 | 0.266 | 52567.7 |
512 | 2022-03-14 23:49:21 | rolf | 1 | 13983 | 7 | 0.313 | 44674.1 |
511 | 2021-12-31 23:27:31 | rolf | 1 | 13983 | 7 | 0.280 | 49939.3 |
510 | 2021-12-27 08:37:36 | rolf | 1 | 13983 | 7 | 0.236 | 59250.0 |
509 | 2021-11-13 11:13:56 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
508 | 2021-09-18 11:06:36 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
507 | 2021-08-29 16:13:39 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
506 | 2021-08-27 11:39:46 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
505 | 2021-08-12 17:17:50 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
504 | 2021-06-15 06:22:13 | rolf | 1 | 13983 | 7 | 0.216 | 64736.1 |
503 | 2021-03-15 21:22:48 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
502 | 2021-01-10 02:39:32 | rolf | 2 | 29872 | 170 | 0.783 | 38150.7 |
501 | 2020-12-09 04:04:24 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
500 | 2020-11-03 15:38:33 | rolf | 2 | 29872 | 170 | 1.000 | 29872.0 |
499 | 2020-10-31 02:30:02 | rolf | 1 | 13983 | 7 | 0.216 | 64736.1 |
498 | 2020-10-27 20:01:05 | rolf | 1 | 13983 | 7 | 0.236 | 59250.0 |
497 | 2020-10-22 10:52:59 | rolf | 2 | 29872 | 170 | 0.906 | 32971.3 |
496 | 2020-09-14 12:49:50 | rolf | 2 | 29872 | 170 | 0.780 | 38297.4 |
495 | 2020-09-06 02:48:52 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
494 | 2020-09-05 13:11:04 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
493 | 2020-07-26 13:14:55 | rolf | 1 | 13983 | 7 | 0.236 | 59250.0 |
492 | 2020-07-23 06:56:14 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
491 | 2020-06-08 12:39:58 | rolf | 2 | 29872 | 170 | 0.796 | 37527.6 |
490 | 2020-06-06 19:59:27 | rolf | 1 | 13983 | 7 | 0.236 | 59250.0 |
489 | 2020-05-25 15:57:07 | rolf | 1 | 13983 | 7 | 0.220 | 63559.1 |
488 | 2020-04-21 12:34:20 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
487 | 2020-03-26 10:56:01 | rolf | 1 | 13983 | 7 | 0.530 | 26383.0 |
486 | 2020-03-24 18:56:22 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
485 | 2020-03-23 05:35:40 | rolf | 1 | 13983 | 7 | 0.516 | 27098.8 |
484 | 2020-03-22 04:26:12 | rolf | 1 | 13983 | 7 | 0.266 | 52567.7 |
483 | 2020-03-20 22:04:30 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
482 | 2020-03-20 19:12:01 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
481 | 2020-03-17 23:46:47 | rolf | 1 | 13983 | 7 | 0.233 | 60012.9 |
480 | 2020-02-28 22:58:28 | rolf | 2 | 29872 | 170 | 1.080 | 27659.3 |
479 | 2020-02-28 14:33:32 | rolf | 2 | 29872 | 170 | 2.076 | 14389.2 |
478 | 2020-02-28 04:22:40 | rolf | 2 | 29872 | 170 | 0.953 | 31345.2 |
477 | 2020-02-25 07:34:51 | rolf | 1 | 13983 | 7 | 0.486 | 28771.6 |
476 | 2020-02-23 01:17:06 | rolf | 1 | 13983 | 7 | 0.296 | 47239.9 |
475 | 2020-02-16 18:00:50 | rolf | 1 | 13983 | 7 | 0.280 | 49939.3 |
474 | 2020-02-16 13:21:44 | rolf | 1 | 13983 | 7 | 0.203 | 68881.8 |
473 | 2020-02-15 00:47:33 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
472 | 2020-02-14 19:37:15 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |
471 | 2020-02-10 20:19:15 | rolf | 1 | 13983 | 7 | 0.250 | 55932.0 |