History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"waste"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
557 | 2024-04-27 17:27:57 | waste | 1 | 28756 | 11 | 0.593 | 48492.4 |
556 | 2024-04-24 12:37:11 | waste | 1 | 28756 | 11 | 1.516 | 18968.3 |
555 | 2024-04-24 12:08:40 | waste | 1 | 28756 | 11 | 2.466 | 11661.0 |
554 | 2024-04-03 06:33:41 | waste | 2 | 53800 | 173 | 5.640 | 9539.0 |
553 | 2024-04-03 06:19:19 | waste | 1 | 28756 | 11 | 1.126 | 25538.2 |
552 | 2024-03-31 03:14:21 | waste | 1 | 28756 | 11 | 1.500 | 19170.7 |
551 | 2024-03-28 19:11:15 | waste | 1 | 28756 | 11 | 1.656 | 17364.7 |
550 | 2024-03-04 19:29:23 | waste | 2 | 53800 | 173 | 5.203 | 10340.2 |
549 | 2024-03-04 19:29:14 | waste | 1 | 28756 | 11 | 1.406 | 20452.3 |
548 | 2024-03-04 19:29:06 | waste | 2 | 53800 | 173 | 3.686 | 14595.8 |
547 | 2024-03-03 23:16:34 | waste | 2 | 53800 | 173 | 3.796 | 14172.8 |
546 | 2024-03-03 22:22:38 | waste | 1 | 28756 | 11 | 0.516 | 55728.7 |
545 | 2024-02-25 17:16:22 | waste | 1 | 28756 | 11 | 0.486 | 59168.7 |
544 | 2024-02-01 07:24:30 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
543 | 2024-01-28 22:42:32 | waste | 2 | 53800 | 173 | 1.530 | 35163.4 |
542 | 2024-01-28 21:28:23 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
541 | 2024-01-25 21:35:25 | waste | 1 | 28756 | 11 | 0.466 | 61708.2 |
540 | 2024-01-04 10:40:19 | waste | 1 | 28756 | 11 | 0.486 | 59168.7 |
539 | 2023-12-14 01:07:03 | waste | 1 | 28756 | 11 | 0.500 | 57512.0 |
538 | 2023-12-06 16:01:21 | waste | 2 | 53800 | 173 | 1.390 | 38705.0 |
537 | 2023-12-05 01:32:59 | waste | 2 | 53800 | 173 | 1.546 | 34799.5 |
536 | 2023-11-27 07:38:29 | waste | 1 | 28756 | 11 | 0.440 | 65354.5 |
535 | 2023-11-26 03:56:59 | waste | 2 | 53800 | 173 | 1.550 | 34709.7 |
534 | 2023-11-11 05:30:58 | waste | 1 | 28756 | 11 | 0.500 | 57512.0 |
533 | 2023-11-10 12:30:53 | waste | 1 | 28756 | 11 | 0.470 | 61183.0 |
532 | 2023-11-06 10:29:01 | waste | 2 | 53800 | 173 | 1.610 | 33416.1 |
531 | 2023-10-27 10:30:02 | waste | 1 | 28756 | 11 | 1.110 | 25906.3 |
530 | 2023-10-19 23:42:34 | waste | 1 | 28756 | 11 | 0.533 | 53951.2 |
529 | 2023-10-17 18:45:53 | waste | 1 | 28756 | 11 | 0.953 | 30174.2 |
528 | 2023-10-17 01:53:07 | waste | 2 | 53800 | 173 | 1.720 | 31279.1 |
527 | 2023-10-11 01:08:21 | waste | 1 | 28756 | 11 | 0.503 | 57169.0 |
526 | 2023-10-09 11:51:41 | waste | 1 | 28756 | 11 | 0.440 | 65354.5 |
525 | 2023-10-08 09:47:08 | waste | 2 | 53800 | 173 | 1.486 | 36204.6 |
524 | 2023-10-03 14:16:01 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
523 | 2023-09-22 18:32:59 | waste | 1 | 28756 | 11 | 0.483 | 59536.2 |
522 | 2023-09-12 22:20:36 | waste | 1 | 28756 | 11 | 0.440 | 65354.5 |
521 | 2023-09-12 09:10:43 | waste | 1 | 28756 | 11 | 0.440 | 65354.5 |
520 | 2023-08-11 19:09:25 | waste | 2 | 53800 | 173 | 1.516 | 35488.1 |
519 | 2023-07-02 03:57:28 | waste | 1 | 28756 | 11 | 1.033 | 27837.4 |
518 | 2023-06-09 10:59:52 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
517 | 2023-04-23 07:13:10 | waste | 2 | 53800 | 173 | 1.343 | 40059.6 |
516 | 2023-04-11 02:40:47 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
515 | 2023-02-11 04:04:15 | waste | 1 | 28756 | 11 | 0.423 | 67981.1 |
514 | 2023-02-04 05:05:57 | waste | 1 | 28756 | 11 | 0.486 | 59168.7 |
513 | 2023-01-31 14:45:41 | waste | 2 | 53800 | 173 | 1.423 | 37807.4 |
512 | 2023-01-16 23:21:26 | waste | 2 | 53800 | 173 | 1.313 | 40974.9 |
511 | 2023-01-10 09:27:33 | waste | 1 | 28756 | 11 | 0.466 | 61708.2 |
510 | 2022-12-31 04:02:10 | waste | 2 | 53800 | 173 | 1.326 | 40573.2 |
509 | 2022-12-11 13:11:26 | waste | 2 | 53800 | 173 | 1.330 | 40451.1 |
508 | 2022-12-03 06:24:45 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
507 | 2022-11-12 20:58:12 | waste | 2 | 53800 | 173 | 1.546 | 34799.5 |
506 | 2022-10-13 17:52:27 | waste | 1 | 28756 | 11 | 0.500 | 57512.0 |
505 | 2022-08-10 13:45:14 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
504 | 2022-08-06 19:02:57 | waste | 1 | 28756 | 11 | 0.453 | 63479.0 |
503 | 2022-08-02 23:08:33 | waste | 1 | 28756 | 11 | 0.483 | 59536.2 |
502 | 2022-08-02 00:00:35 | waste | 1 | 28756 | 11 | 0.450 | 63902.2 |
501 | 2022-07-30 00:04:02 | waste | 1 | 28756 | 11 | 0.483 | 59536.2 |
500 | 2022-07-03 06:55:00 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
499 | 2022-07-02 20:36:25 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
498 | 2022-06-19 15:53:27 | waste | 1 | 28756 | 11 | 0.486 | 59168.7 |
497 | 2022-06-16 06:57:07 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
496 | 2022-06-14 12:46:22 | waste | 2 | 53800 | 173 | 1.343 | 40059.6 |
495 | 2022-06-07 11:14:42 | waste | 1 | 28756 | 11 | 0.453 | 63479.0 |
494 | 2022-03-31 14:17:59 | waste | 1 | 28756 | 11 | 0.656 | 43835.4 |
493 | 2022-03-29 12:15:03 | waste | 1 | 28756 | 11 | 0.546 | 52666.7 |
492 | 2022-03-27 08:00:41 | waste | 1 | 28756 | 11 | 0.440 | 65354.5 |
491 | 2022-02-27 03:51:11 | waste | 1 | 28756 | 11 | 0.466 | 61708.2 |
490 | 2022-02-11 08:39:59 | waste | 1 | 28756 | 11 | 0.500 | 57512.0 |
489 | 2022-02-07 21:10:58 | waste | 1 | 28756 | 11 | 0.516 | 55728.7 |
488 | 2021-12-28 23:28:25 | waste | 1 | 28756 | 11 | 0.483 | 59536.2 |
487 | 2021-11-02 15:35:11 | waste | 1 | 28756 | 11 | 0.470 | 61183.0 |
486 | 2021-10-14 22:25:13 | waste | 1 | 28756 | 11 | 0.453 | 63479.0 |
485 | 2021-09-27 11:28:07 | waste | 1 | 28756 | 11 | 0.483 | 59536.2 |
484 | 2021-09-26 09:56:14 | waste | 1 | 28756 | 11 | 0.423 | 67981.1 |
483 | 2021-09-24 05:43:51 | waste | 1 | 28756 | 11 | 0.453 | 63479.0 |
482 | 2021-09-22 18:20:24 | waste | 1 | 28756 | 11 | 0.453 | 63479.0 |
481 | 2021-09-07 01:46:10 | waste | 1 | 28756 | 11 | 0.453 | 63479.0 |
480 | 2021-07-10 04:22:47 | waste | 1 | 28756 | 11 | 0.500 | 57512.0 |
479 | 2021-05-04 17:46:26 | waste | 1 | 28756 | 11 | 0.516 | 55728.7 |
478 | 2021-04-06 08:09:01 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
477 | 2021-04-02 19:31:23 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
476 | 2021-04-02 04:30:01 | waste | 1 | 28756 | 11 | 0.486 | 59168.7 |
475 | 2021-03-07 09:09:39 | waste | 1 | 28756 | 11 | 0.453 | 63479.0 |
474 | 2020-12-18 16:09:26 | waste | 1 | 28756 | 11 | 0.440 | 65354.5 |
473 | 2020-12-17 11:04:21 | waste | 1 | 28756 | 11 | 0.453 | 63479.0 |
472 | 2020-11-10 11:28:34 | waste | 1 | 28756 | 11 | 0.513 | 56054.6 |
471 | 2020-11-05 04:41:04 | waste | 1 | 28756 | 11 | 0.530 | 54256.6 |
470 | 2020-11-02 11:14:58 | waste | 1 | 28756 | 11 | 0.546 | 52666.7 |
469 | 2020-10-30 08:38:00 | waste | 1 | 28756 | 11 | 0.500 | 57512.0 |
468 | 2020-10-22 09:19:43 | waste | 1 | 28756 | 11 | 0.470 | 61183.0 |
467 | 2020-10-10 16:36:14 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
466 | 2020-10-03 19:55:38 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
465 | 2020-09-13 13:51:39 | waste | 1 | 28756 | 11 | 0.483 | 59536.2 |
464 | 2020-09-07 03:29:29 | waste | 1 | 28756 | 11 | 0.436 | 65954.1 |
463 | 2020-08-24 11:46:59 | waste | 1 | 28756 | 11 | 0.420 | 68466.7 |
462 | 2020-06-11 02:18:55 | waste | 1 | 28756 | 11 | 0.466 | 61708.2 |
461 | 2020-05-20 06:41:40 | waste | 1 | 28756 | 11 | 0.563 | 51076.4 |
460 | 2020-03-27 22:48:45 | waste | 1 | 28756 | 11 | 0.453 | 63479.0 |
459 | 2020-03-25 14:33:18 | waste | 1 | 28756 | 11 | 0.466 | 61708.2 |
458 | 2020-03-25 05:26:39 | waste | 1 | 28756 | 11 | 0.546 | 52666.7 |