History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chair"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
575 | 2024-04-25 21:24:57 | chair | 1 | 28756 | 9 | 0.970 | 29645.4 |
574 | 2024-04-03 00:48:17 | chair | 1 | 28756 | 9 | 0.733 | 39230.6 |
573 | 2024-03-31 00:39:41 | chair | 1 | 28756 | 9 | 2.280 | 12612.3 |
572 | 2024-03-27 02:56:33 | chair | 1 | 28756 | 9 | 1.156 | 24875.4 |
571 | 2024-02-25 17:47:50 | chair | 1 | 28756 | 9 | 0.453 | 63479.0 |
570 | 2024-02-21 06:01:05 | chair | 1 | 28756 | 9 | 0.470 | 61183.0 |
569 | 2024-02-06 22:46:28 | chair | 1 | 28756 | 9 | 0.486 | 59168.7 |
568 | 2024-01-26 03:05:33 | chair | 1 | 28756 | 9 | 1.060 | 27128.3 |
567 | 2024-01-15 03:55:42 | chair | 1 | 28756 | 9 | 0.516 | 55728.7 |
566 | 2024-01-10 18:15:11 | chair | 2 | 53800 | 113 | 1.340 | 40149.3 |
565 | 2023-12-08 07:21:13 | chair | 2 | 53800 | 113 | 1.346 | 39970.3 |
564 | 2023-11-28 00:53:26 | chair | 2 | 53800 | 113 | 1.453 | 37026.8 |
563 | 2023-11-23 22:59:41 | chair | 2 | 53800 | 113 | 1.766 | 30464.3 |
562 | 2023-11-10 23:51:04 | chair | 1 | 28756 | 9 | 0.470 | 61183.0 |
561 | 2023-11-09 14:57:22 | chair | 1 | 28756 | 9 | 0.486 | 59168.7 |
560 | 2023-11-02 05:35:48 | chair | 2 | 53800 | 113 | 1.360 | 39558.8 |
559 | 2023-10-27 14:15:59 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
558 | 2023-10-20 11:26:50 | chair | 2 | 53800 | 113 | 1.360 | 39558.8 |
557 | 2023-10-20 01:19:11 | chair | 1 | 28756 | 9 | 1.356 | 21206.5 |
556 | 2023-10-17 22:33:06 | chair | 1 | 28756 | 9 | 0.483 | 59536.2 |
555 | 2023-10-16 19:45:08 | chair | 2 | 53800 | 113 | 1.653 | 32546.9 |
554 | 2023-10-13 19:16:38 | chair | 2 | 53800 | 113 | 1.623 | 33148.5 |
553 | 2023-10-10 16:06:10 | chair | 1 | 28756 | 9 | 0.533 | 53951.2 |
552 | 2023-10-04 08:39:34 | chair | 1 | 28756 | 9 | 0.440 | 65354.5 |
551 | 2023-10-01 13:21:48 | chair | 1 | 28756 | 9 | 0.440 | 65354.5 |
550 | 2023-09-28 11:10:42 | chair | 1 | 28756 | 9 | 0.486 | 59168.7 |
549 | 2023-09-28 07:41:03 | chair | 1 | 28756 | 9 | 0.516 | 55728.7 |
548 | 2023-09-28 01:04:28 | chair | 2 | 53800 | 113 | 1.593 | 33772.8 |
547 | 2023-09-27 19:38:02 | chair | 2 | 53800 | 113 | 1.516 | 35488.1 |
546 | 2023-09-21 00:45:34 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
545 | 2023-09-19 18:43:52 | chair | 1 | 28756 | 9 | 0.970 | 29645.4 |
544 | 2023-07-28 10:59:28 | chair | 2 | 53800 | 113 | 1.390 | 38705.0 |
543 | 2023-06-20 23:39:22 | chair | 1 | 28756 | 9 | 0.513 | 56054.6 |
542 | 2023-06-17 19:11:30 | chair | 1 | 28756 | 9 | 0.420 | 68466.7 |
541 | 2023-04-23 22:35:26 | chair | 1 | 28756 | 9 | 0.440 | 65354.5 |
540 | 2023-04-06 11:34:13 | chair | 2 | 53800 | 113 | 1.736 | 30990.8 |
539 | 2023-03-31 12:19:18 | chair | 1 | 28756 | 9 | 0.440 | 65354.5 |
538 | 2023-03-15 10:55:59 | chair | 1 | 28756 | 9 | 0.440 | 65354.5 |
537 | 2023-01-04 10:48:33 | chair | 2 | 53800 | 113 | 1.343 | 40059.6 |
536 | 2022-12-10 12:00:21 | chair | 1 | 28756 | 9 | 0.483 | 59536.2 |
535 | 2022-09-21 13:25:34 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
534 | 2022-09-09 12:44:05 | chair | 2 | 53800 | 113 | 1.516 | 35488.1 |
533 | 2022-08-30 12:51:16 | chair | 1 | 28756 | 9 | 0.456 | 63061.4 |
532 | 2022-05-30 18:07:36 | chair | 1 | 28756 | 9 | 0.470 | 61183.0 |
531 | 2022-05-14 13:32:05 | chair | 1 | 28756 | 9 | 0.516 | 55728.7 |
530 | 2022-05-04 09:34:37 | chair | 1 | 28756 | 9 | 0.500 | 57512.0 |
529 | 2022-04-04 04:11:33 | chair | 2 | 53800 | 113 | 1.343 | 40059.6 |
528 | 2022-02-09 18:01:50 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
527 | 2022-01-25 13:21:53 | chair | 1 | 28756 | 9 | 0.500 | 57512.0 |
526 | 2021-11-20 23:05:36 | chair | 1 | 28756 | 9 | 0.516 | 55728.7 |
525 | 2021-11-11 08:22:54 | chair | 1 | 28756 | 9 | 0.500 | 57512.0 |
524 | 2021-11-08 20:22:51 | chair | 1 | 28756 | 9 | 0.483 | 59536.2 |
523 | 2021-10-08 19:20:40 | chair | 1 | 28756 | 9 | 0.483 | 59536.2 |
522 | 2021-09-04 13:43:19 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
521 | 2021-09-02 07:15:48 | chair | 1 | 28756 | 9 | 0.656 | 43835.4 |
520 | 2021-08-15 19:06:01 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
519 | 2021-08-09 05:36:54 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
518 | 2021-08-05 18:31:37 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
517 | 2021-06-09 06:29:46 | chair | 1 | 28756 | 9 | 0.893 | 32201.6 |
516 | 2021-05-01 17:36:26 | chair | 1 | 28756 | 9 | 0.530 | 54256.6 |
515 | 2021-04-21 20:49:51 | chair | 1 | 28756 | 9 | 0.440 | 65354.5 |
514 | 2021-04-14 15:22:23 | chair | 1 | 28756 | 9 | 0.516 | 55728.7 |
513 | 2021-01-29 07:46:14 | chair | 1 | 28756 | 9 | 0.453 | 63479.0 |
512 | 2021-01-27 06:17:43 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
511 | 2021-01-27 05:42:23 | chair | 1 | 28756 | 9 | 0.486 | 59168.7 |
510 | 2020-12-30 10:17:10 | chair | 1 | 28756 | 9 | 0.453 | 63479.0 |
509 | 2020-11-19 13:35:05 | chair | 1 | 28756 | 9 | 0.453 | 63479.0 |
508 | 2020-10-30 18:55:22 | chair | 1 | 28756 | 9 | 0.563 | 51076.4 |
507 | 2020-10-26 13:22:44 | chair | 1 | 28756 | 9 | 0.686 | 41918.4 |
506 | 2020-10-20 08:46:39 | chair | 1 | 28756 | 9 | 0.453 | 63479.0 |
505 | 2020-10-16 16:31:16 | chair | 1 | 28756 | 9 | 0.640 | 44931.3 |
504 | 2020-10-12 19:04:48 | chair | 1 | 28756 | 9 | 0.450 | 63902.2 |
503 | 2020-10-08 04:53:03 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
502 | 2020-08-21 20:21:29 | chair | 1 | 28756 | 9 | 0.440 | 65354.5 |
501 | 2020-08-20 11:28:20 | chair | 1 | 28756 | 9 | 0.453 | 63479.0 |
500 | 2020-07-29 08:24:59 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
499 | 2020-07-28 17:42:24 | chair | 1 | 28756 | 9 | 0.530 | 54256.6 |
498 | 2020-07-22 19:41:28 | chair | 1 | 28756 | 9 | 0.546 | 52666.7 |
497 | 2020-07-20 03:53:44 | chair | 1 | 28756 | 9 | 0.470 | 61183.0 |
496 | 2020-07-19 03:55:04 | chair | 1 | 28756 | 9 | 0.470 | 61183.0 |
495 | 2020-07-15 02:54:41 | chair | 1 | 28756 | 9 | 0.453 | 63479.0 |
494 | 2020-07-12 14:16:16 | chair | 1 | 28756 | 9 | 0.470 | 61183.0 |
493 | 2020-06-21 11:03:45 | chair | 1 | 28756 | 9 | 0.500 | 57512.0 |
492 | 2020-06-14 06:41:14 | chair | 1 | 28756 | 9 | 0.453 | 63479.0 |
491 | 2020-06-13 05:58:55 | chair | 1 | 28756 | 9 | 0.483 | 59536.2 |
490 | 2020-06-02 15:30:40 | chair | 1 | 28756 | 9 | 0.513 | 56054.6 |
489 | 2020-06-01 15:58:41 | chair | 1 | 28756 | 9 | 0.470 | 61183.0 |
488 | 2020-05-29 08:28:48 | chair | 1 | 28756 | 9 | 0.516 | 55728.7 |
487 | 2020-05-28 08:39:59 | chair | 1 | 28756 | 9 | 0.500 | 57512.0 |
486 | 2020-05-27 08:01:24 | chair | 1 | 28756 | 9 | 0.450 | 63902.2 |
485 | 2020-05-24 06:48:44 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
484 | 2020-05-23 07:21:50 | chair | 1 | 28756 | 9 | 0.420 | 68466.7 |
483 | 2020-05-19 08:16:14 | chair | 1 | 28756 | 9 | 0.450 | 63902.2 |
482 | 2020-05-16 07:36:39 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
481 | 2020-05-15 05:18:26 | chair | 1 | 28756 | 9 | 0.453 | 63479.0 |
480 | 2020-05-14 09:14:50 | chair | 1 | 28756 | 9 | 0.453 | 63479.0 |
479 | 2020-05-13 13:57:17 | chair | 1 | 28756 | 9 | 0.483 | 59536.2 |
478 | 2020-05-12 14:46:39 | chair | 1 | 28756 | 9 | 0.453 | 63479.0 |
477 | 2020-05-11 15:25:41 | chair | 1 | 28756 | 9 | 0.436 | 65954.1 |
476 | 2020-05-10 14:40:45 | chair | 1 | 28756 | 9 | 0.440 | 65354.5 |