History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smile"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
581 | 2024-05-08 00:15:40 | smile | 1 | 28756 | 10 | 1.093 | 26309.2 |
580 | 2024-05-05 10:13:58 | smile | 1 | 28756 | 10 | 1.186 | 24246.2 |
579 | 2024-05-04 05:49:16 | smile | 1 | 28756 | 10 | 0.546 | 52666.7 |
578 | 2024-05-01 02:42:39 | smile | 1 | 28756 | 10 | 0.563 | 51076.4 |
577 | 2024-04-30 03:23:32 | smile | 2 | 53800 | 163 | 1.860 | 28924.7 |
576 | 2024-04-30 02:03:01 | smile | 1 | 28756 | 10 | 0.610 | 47141.0 |
575 | 2024-04-28 02:42:19 | smile | 1 | 28756 | 10 | 0.563 | 51076.4 |
574 | 2024-04-06 14:23:32 | smile | 1 | 28756 | 10 | 0.563 | 51076.4 |
573 | 2024-04-03 03:20:09 | smile | 1 | 28756 | 10 | 1.513 | 19005.9 |
572 | 2024-03-31 18:11:05 | smile | 1 | 28756 | 10 | 0.533 | 53951.2 |
571 | 2024-03-27 06:12:59 | smile | 1 | 28756 | 10 | 0.530 | 54256.6 |
570 | 2024-03-03 21:21:02 | smile | 1 | 28756 | 10 | 0.560 | 51350.0 |
569 | 2024-03-01 13:00:03 | smile | 1 | 28756 | 10 | 0.580 | 49579.3 |
568 | 2024-02-25 18:20:30 | smile | 1 | 28756 | 10 | 1.220 | 23570.5 |
567 | 2024-02-03 03:42:35 | smile | 1 | 28756 | 10 | 0.500 | 57512.0 |
566 | 2024-01-26 00:30:05 | smile | 1 | 28756 | 10 | 0.516 | 55728.7 |
565 | 2023-12-26 02:57:04 | smile | 1 | 28756 | 10 | 0.436 | 65954.1 |
564 | 2023-12-07 01:22:55 | smile | 1 | 28756 | 10 | 0.483 | 59536.2 |
563 | 2023-12-07 01:22:54 | smile | 1 | 28756 | 10 | 0.470 | 61183.0 |
562 | 2023-11-21 15:03:05 | smile | 2 | 53800 | 163 | 1.640 | 32804.9 |
561 | 2023-11-17 02:36:38 | smile | 2 | 53800 | 163 | 1.343 | 40059.6 |
560 | 2023-11-14 11:28:20 | smile | 2 | 53800 | 163 | 1.390 | 38705.0 |
559 | 2023-11-09 02:42:21 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
558 | 2023-11-07 22:38:20 | smile | 1 | 28756 | 10 | 0.436 | 65954.1 |
557 | 2023-10-29 05:18:46 | smile | 1 | 28756 | 10 | 0.483 | 59536.2 |
556 | 2023-10-27 04:26:43 | smile | 1 | 28756 | 10 | 0.500 | 57512.0 |
555 | 2023-10-19 16:41:39 | smile | 2 | 53800 | 163 | 1.686 | 31909.8 |
554 | 2023-10-19 16:09:35 | smile | 1 | 28756 | 10 | 0.440 | 65354.5 |
553 | 2023-10-18 23:22:44 | smile | 2 | 53800 | 163 | 1.360 | 39558.8 |
552 | 2023-10-16 19:53:38 | smile | 1 | 28756 | 10 | 0.486 | 59168.7 |
551 | 2023-10-15 12:13:08 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
550 | 2023-10-13 05:59:07 | smile | 1 | 28756 | 10 | 0.533 | 53951.2 |
549 | 2023-10-04 06:55:44 | smile | 1 | 28756 | 10 | 0.500 | 57512.0 |
548 | 2023-09-25 16:27:29 | smile | 1 | 28756 | 10 | 0.533 | 53951.2 |
547 | 2023-09-23 15:15:11 | smile | 1 | 28756 | 10 | 0.436 | 65954.1 |
546 | 2023-09-12 07:44:18 | smile | 1 | 28756 | 10 | 0.513 | 56054.6 |
545 | 2023-08-10 23:48:48 | smile | 1 | 28756 | 10 | 0.483 | 59536.2 |
544 | 2023-07-05 11:20:04 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
543 | 2023-05-09 20:45:55 | smile | 1 | 28756 | 10 | 0.546 | 52666.7 |
542 | 2023-03-18 15:39:03 | smile | 1 | 28756 | 10 | 0.470 | 61183.0 |
541 | 2023-03-04 13:30:54 | smile | 1 | 28756 | 10 | 0.436 | 65954.1 |
540 | 2022-12-28 09:54:55 | smile | 1 | 28756 | 10 | 0.423 | 67981.1 |
539 | 2022-11-24 00:08:24 | smile | 1 | 28756 | 10 | 0.483 | 59536.2 |
538 | 2022-09-17 14:39:20 | smile | 1 | 28756 | 10 | 0.516 | 55728.7 |
537 | 2022-08-10 17:09:34 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
536 | 2022-08-03 00:55:34 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
535 | 2022-07-29 08:55:38 | smile | 1 | 28756 | 10 | 0.500 | 57512.0 |
534 | 2022-07-25 07:01:57 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
533 | 2022-07-19 06:25:19 | smile | 2 | 53800 | 163 | 1.360 | 39558.8 |
532 | 2022-07-16 17:05:20 | smile | 1 | 28756 | 10 | 0.483 | 59536.2 |
531 | 2022-07-15 23:29:55 | smile | 1 | 28756 | 10 | 0.466 | 61708.2 |
530 | 2022-07-03 15:35:40 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
529 | 2022-06-17 05:04:55 | smile | 1 | 28756 | 10 | 0.450 | 63902.2 |
528 | 2022-06-14 16:51:41 | smile | 1 | 28756 | 10 | 0.440 | 65354.5 |
527 | 2022-06-04 04:34:44 | smile | 1 | 28756 | 10 | 0.436 | 65954.1 |
526 | 2022-04-26 06:55:31 | smile | 1 | 28756 | 10 | 0.500 | 57512.0 |
525 | 2022-03-12 13:28:41 | smile | 1 | 28756 | 10 | 0.516 | 55728.7 |
524 | 2022-01-17 14:03:48 | smile | 1 | 28756 | 10 | 0.890 | 32310.1 |
523 | 2021-11-28 20:56:52 | smile | 1 | 28756 | 10 | 0.483 | 59536.2 |
522 | 2021-11-13 09:02:13 | smile | 1 | 28756 | 10 | 0.500 | 57512.0 |
521 | 2021-10-03 03:55:57 | smile | 1 | 28756 | 10 | 0.533 | 53951.2 |
520 | 2021-09-13 23:08:27 | smile | 1 | 28756 | 10 | 0.546 | 52666.7 |
519 | 2021-08-15 22:10:09 | smile | 1 | 28756 | 10 | 0.436 | 65954.1 |
518 | 2021-05-22 05:10:21 | smile | 1 | 28756 | 10 | 0.470 | 61183.0 |
517 | 2021-05-05 00:34:31 | smile | 1 | 28756 | 10 | 0.546 | 52666.7 |
516 | 2021-03-25 05:48:07 | smile | 1 | 28756 | 10 | 0.466 | 61708.2 |
515 | 2021-02-14 18:24:25 | smile | 2 | 53800 | 163 | 1.393 | 38621.7 |
514 | 2021-02-10 21:16:24 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
513 | 2021-02-02 11:14:56 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
512 | 2021-01-21 15:49:37 | smile | 2 | 53800 | 163 | 1.580 | 34050.6 |
511 | 2021-01-08 06:04:47 | smile | 1 | 28756 | 10 | 0.530 | 54256.6 |
510 | 2020-11-20 10:28:13 | smile | 2 | 53800 | 163 | 1.373 | 39184.3 |
509 | 2020-11-20 01:57:50 | smile | 1 | 28756 | 10 | 0.486 | 59168.7 |
508 | 2020-10-31 13:46:24 | smile | 1 | 28756 | 10 | 0.500 | 57512.0 |
507 | 2020-10-26 08:48:46 | smile | 1 | 28756 | 10 | 0.986 | 29164.3 |
506 | 2020-10-25 19:06:25 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
505 | 2020-10-24 08:06:54 | smile | 1 | 28756 | 10 | 0.516 | 55728.7 |
504 | 2020-10-21 00:13:18 | smile | 1 | 28756 | 10 | 0.470 | 61183.0 |
503 | 2020-10-13 01:07:51 | smile | 2 | 53800 | 163 | 1.406 | 38264.6 |
502 | 2020-10-07 08:53:57 | smile | 2 | 53800 | 163 | 1.423 | 37807.4 |
501 | 2020-09-24 18:12:06 | smile | 2 | 53800 | 163 | 1.360 | 39558.8 |
500 | 2020-09-15 08:46:16 | smile | 2 | 53800 | 163 | 1.390 | 38705.0 |
499 | 2020-08-24 02:31:55 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
498 | 2020-08-11 17:16:44 | smile | 1 | 28756 | 10 | 0.470 | 61183.0 |
497 | 2020-08-08 13:17:18 | smile | 1 | 28756 | 10 | 0.450 | 63902.2 |
496 | 2020-08-05 07:09:06 | smile | 1 | 28756 | 10 | 0.470 | 61183.0 |
495 | 2020-08-01 15:21:00 | smile | 1 | 28756 | 10 | 0.516 | 55728.7 |
494 | 2020-07-21 18:33:56 | smile | 2 | 53800 | 163 | 1.580 | 34050.6 |
493 | 2020-07-13 13:29:46 | smile | 1 | 28756 | 10 | 0.470 | 61183.0 |
492 | 2020-06-16 12:38:51 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
491 | 2020-04-30 04:03:40 | smile | 1 | 28756 | 10 | 0.436 | 65954.1 |
490 | 2020-04-26 22:09:48 | smile | 1 | 28756 | 10 | 0.500 | 57512.0 |
489 | 2020-03-29 22:37:11 | smile | 1 | 28756 | 10 | 1.110 | 25906.3 |
488 | 2020-03-26 06:28:36 | smile | 1 | 28756 | 10 | 0.500 | 57512.0 |
487 | 2020-03-22 21:44:42 | smile | 1 | 28756 | 10 | 0.453 | 63479.0 |
486 | 2020-03-22 21:31:48 | smile | 1 | 28756 | 10 | 0.483 | 59536.2 |
485 | 2020-03-20 22:30:28 | smile | 1 | 28756 | 10 | 0.546 | 52666.7 |
484 | 2020-03-18 07:02:06 | smile | 1 | 28756 | 10 | 0.516 | 55728.7 |
483 | 2020-02-26 20:32:17 | smile | 1 | 28756 | 10 | 1.030 | 27918.4 |
482 | 2020-02-24 09:06:23 | smile | 1 | 28756 | 10 | 0.563 | 51076.4 |