History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"promo"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
557 | 2024-05-01 22:48:16 | promo | 1 | 28756 | 8 | 1.656 | 17364.7 |
556 | 2024-05-01 22:47:12 | promo | 1 | 28756 | 8 | 1.076 | 26724.9 |
555 | 2024-05-01 22:47:08 | promo | 2 | 53800 | 87 | 3.593 | 14973.6 |
554 | 2024-05-01 22:47:04 | promo | 3 | 83667 | 851 | 4.123 | 20292.7 |
553 | 2024-04-30 12:16:35 | promo | 1 | 28756 | 8 | 0.580 | 49579.3 |
552 | 2024-04-29 20:35:01 | promo | 1 | 28756 | 8 | 0.563 | 51076.4 |
551 | 2024-04-29 01:09:54 | promo | 1 | 28756 | 8 | 0.546 | 52666.7 |
550 | 2024-04-27 02:45:21 | promo | 1 | 28756 | 8 | 2.283 | 12595.7 |
549 | 2024-04-06 05:48:05 | promo | 1 | 28756 | 8 | 0.640 | 44931.3 |
548 | 2024-04-01 18:11:09 | promo | 1 | 28756 | 8 | 1.216 | 23648.0 |
547 | 2024-03-31 03:35:29 | promo | 1 | 28756 | 8 | 0.533 | 53951.2 |
546 | 2024-03-28 20:25:59 | promo | 1 | 28756 | 8 | 0.453 | 63479.0 |
545 | 2024-03-07 03:34:54 | promo | 1 | 28756 | 8 | 1.140 | 25224.6 |
544 | 2024-03-02 14:27:32 | promo | 1 | 28756 | 8 | 1.093 | 26309.2 |
543 | 2024-02-28 11:47:56 | promo | 2 | 53800 | 87 | 1.860 | 28924.7 |
542 | 2024-02-28 11:47:29 | promo | 3 | 83667 | 851 | 4.423 | 18916.3 |
541 | 2024-02-28 08:15:41 | promo | 2 | 53800 | 87 | 4.080 | 13186.3 |
540 | 2024-02-28 08:15:19 | promo | 3 | 83667 | 851 | 4.406 | 18989.3 |
539 | 2024-02-27 22:42:35 | promo | 3 | 83667 | 851 | 12.376 | 6760.4 |
538 | 2024-02-27 22:42:34 | promo | 2 | 53800 | 87 | 3.873 | 13891.0 |
537 | 2024-02-26 03:29:52 | promo | 1 | 28756 | 8 | 0.530 | 54256.6 |
536 | 2024-02-12 06:46:13 | promo | 1 | 28756 | 8 | 0.500 | 57512.0 |
535 | 2024-02-03 21:32:07 | promo | 1 | 28756 | 8 | 0.486 | 59168.7 |
534 | 2024-01-28 19:42:43 | promo | 1 | 28756 | 8 | 0.533 | 53951.2 |
533 | 2024-01-26 20:08:01 | promo | 1 | 28756 | 8 | 1.020 | 28192.2 |
532 | 2024-01-25 17:42:40 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
531 | 2024-01-15 06:08:22 | promo | 3 | 83667 | 851 | 3.750 | 22311.2 |
530 | 2024-01-15 06:08:19 | promo | 2 | 53800 | 87 | 1.513 | 35558.5 |
529 | 2024-01-10 09:10:20 | promo | 2 | 53800 | 87 | 1.373 | 39184.3 |
528 | 2024-01-10 08:36:49 | promo | 3 | 83667 | 851 | 3.376 | 24782.9 |
527 | 2023-11-26 15:16:12 | promo | 3 | 83667 | 851 | 3.780 | 22134.1 |
526 | 2023-11-26 15:16:10 | promo | 2 | 53800 | 87 | 1.610 | 33416.1 |
525 | 2023-11-21 06:03:22 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
524 | 2023-11-16 11:06:00 | promo | 1 | 28756 | 8 | 0.470 | 61183.0 |
523 | 2023-11-16 03:49:04 | promo | 1 | 28756 | 8 | 0.533 | 53951.2 |
522 | 2023-10-27 11:18:14 | promo | 1 | 28756 | 8 | 0.466 | 61708.2 |
521 | 2023-10-22 19:11:27 | promo | 1 | 28756 | 8 | 0.500 | 57512.0 |
520 | 2023-10-18 07:41:05 | promo | 1 | 28756 | 8 | 0.470 | 61183.0 |
519 | 2023-10-11 15:11:45 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
518 | 2023-10-06 15:12:30 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
517 | 2023-10-04 09:07:43 | promo | 1 | 28756 | 8 | 0.513 | 56054.6 |
516 | 2023-09-28 16:23:14 | promo | 1 | 28756 | 8 | 0.483 | 59536.2 |
515 | 2023-09-14 03:41:18 | promo | 1 | 28756 | 8 | 0.500 | 57512.0 |
514 | 2023-09-06 04:10:50 | promo | 1 | 28756 | 8 | 0.466 | 61708.2 |
513 | 2023-06-13 04:25:36 | promo | 1 | 28756 | 8 | 0.470 | 61183.0 |
512 | 2023-06-09 10:43:49 | promo | 1 | 28756 | 8 | 0.423 | 67981.1 |
511 | 2023-03-28 23:27:08 | promo | 1 | 28756 | 8 | 0.423 | 67981.1 |
510 | 2023-02-21 20:58:23 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
509 | 2023-01-11 19:45:53 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
508 | 2022-10-25 02:41:26 | promo | 1 | 28756 | 8 | 0.440 | 65354.5 |
507 | 2022-10-16 17:15:34 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
506 | 2022-07-20 02:54:43 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
505 | 2022-07-05 09:59:01 | promo | 1 | 28756 | 8 | 0.453 | 63479.0 |
504 | 2022-06-06 06:10:11 | promo | 1 | 28756 | 8 | 0.500 | 57512.0 |
503 | 2022-03-14 15:31:11 | promo | 1 | 28756 | 8 | 0.626 | 45936.1 |
502 | 2022-02-16 02:05:40 | promo | 1 | 28756 | 8 | 0.500 | 57512.0 |
501 | 2022-02-13 21:28:06 | promo | 1 | 28756 | 8 | 0.516 | 55728.7 |
500 | 2021-12-07 12:36:11 | promo | 1 | 28756 | 8 | 0.530 | 54256.6 |
499 | 2021-11-27 11:30:10 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
498 | 2021-10-23 01:31:23 | promo | 1 | 28756 | 8 | 0.440 | 65354.5 |
497 | 2021-09-08 20:04:34 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
496 | 2021-08-20 00:22:01 | promo | 1 | 28756 | 8 | 0.450 | 63902.2 |
495 | 2021-08-14 13:53:54 | promo | 1 | 28756 | 8 | 0.580 | 49579.3 |
494 | 2021-06-01 02:38:34 | promo | 1 | 28756 | 8 | 0.533 | 53951.2 |
493 | 2021-05-10 08:47:58 | promo | 1 | 28756 | 8 | 0.500 | 57512.0 |
492 | 2021-05-06 22:46:19 | promo | 1 | 28756 | 8 | 0.483 | 59536.2 |
491 | 2021-05-06 21:05:46 | promo | 1 | 28756 | 8 | 0.530 | 54256.6 |
490 | 2021-04-05 04:16:57 | promo | 1 | 28756 | 8 | 0.500 | 57512.0 |
489 | 2021-04-02 05:48:30 | promo | 3 | 83667 | 851 | 4.046 | 20678.9 |
488 | 2021-02-22 02:16:57 | promo | 3 | 83667 | 851 | 3.313 | 25254.2 |
487 | 2021-01-31 19:09:08 | promo | 1 | 28756 | 8 | 0.453 | 63479.0 |
486 | 2021-01-20 11:31:34 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
485 | 2020-12-21 02:24:54 | promo | 1 | 28756 | 8 | 0.483 | 59536.2 |
484 | 2020-10-30 01:43:42 | promo | 1 | 28756 | 8 | 0.466 | 61708.2 |
483 | 2020-10-29 12:35:12 | promo | 1 | 28756 | 8 | 0.453 | 63479.0 |
482 | 2020-10-22 06:48:17 | promo | 1 | 28756 | 8 | 0.436 | 65954.1 |
481 | 2020-10-20 07:31:36 | promo | 1 | 28756 | 8 | 0.500 | 57512.0 |
480 | 2020-09-14 08:25:42 | promo | 1 | 28756 | 8 | 0.440 | 65354.5 |
479 | 2020-08-13 13:27:38 | promo | 1 | 28756 | 8 | 0.500 | 57512.0 |
478 | 2020-08-10 15:20:53 | promo | 1 | 28756 | 8 | 0.453 | 63479.0 |
477 | 2020-07-24 19:21:56 | promo | 1 | 28756 | 8 | 0.546 | 52666.7 |
476 | 2020-05-05 17:20:16 | promo | 1 | 28756 | 8 | 0.500 | 57512.0 |
475 | 2020-04-22 14:34:55 | promo | 1 | 28756 | 8 | 0.453 | 63479.0 |
474 | 2020-03-25 08:03:29 | promo | 1 | 28756 | 8 | 0.483 | 59536.2 |
473 | 2020-03-24 19:09:58 | promo | 1 | 28756 | 8 | 0.503 | 57169.0 |
472 | 2020-03-22 07:51:04 | promo | 1 | 28756 | 8 | 0.876 | 32826.5 |
471 | 2020-03-22 06:59:15 | promo | 1 | 28756 | 8 | 1.033 | 27837.4 |
470 | 2020-03-21 03:03:08 | promo | 1 | 28756 | 8 | 0.440 | 65354.5 |
469 | 2020-03-18 05:56:10 | promo | 1 | 28756 | 8 | 0.450 | 63902.2 |
468 | 2020-02-27 01:45:55 | promo | 1 | 28756 | 8 | 0.516 | 55728.7 |
467 | 2020-02-24 19:49:39 | promo | 3 | 83667 | 851 | 4.110 | 20356.9 |
466 | 2020-02-24 10:03:03 | promo | 3 | 83667 | 851 | 5.690 | 14704.2 |
465 | 2020-02-23 20:50:37 | promo | 1 | 28756 | 8 | 0.516 | 55728.7 |
464 | 2020-02-22 08:05:11 | promo | 1 | 28756 | 8 | 0.580 | 49579.3 |
463 | 2020-02-20 09:20:36 | promo | 1 | 28756 | 8 | 1.126 | 25538.2 |
462 | 2020-02-19 16:07:17 | promo | 1 | 28756 | 8 | 0.500 | 57512.0 |
461 | 2020-02-09 18:53:25 | promo | 1 | 28756 | 8 | 0.563 | 51076.4 |
460 | 2020-02-08 08:13:21 | promo | 3 | 83667 | 851 | 7.423 | 11271.3 |
459 | 2020-02-01 07:02:23 | promo | 3 | 83667 | 851 | 4.110 | 20356.9 |
458 | 2020-01-31 14:21:34 | promo | 3 | 83667 | 851 | 4.330 | 19322.6 |