History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"phone"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
582 | 2024-05-06 08:51:04 | phone | 2 | 53800 | 130 | 3.580 | 15027.9 |
581 | 2024-05-06 08:50:51 | phone | 1 | 28756 | 12 | 0.593 | 48492.4 |
580 | 2024-05-06 08:50:47 | phone | 2 | 53800 | 130 | 1.733 | 31044.4 |
579 | 2024-05-06 08:50:43 | phone | 1 | 28756 | 12 | 0.593 | 48492.4 |
578 | 2024-05-03 22:36:10 | phone | 1 | 28756 | 12 | 0.516 | 55728.7 |
577 | 2024-05-03 20:20:25 | phone | 1 | 28756 | 12 | 1.373 | 20943.9 |
576 | 2024-04-06 06:53:11 | phone | 2 | 53800 | 130 | 1.486 | 36204.6 |
575 | 2024-04-06 06:53:07 | phone | 1 | 28756 | 12 | 0.466 | 61708.2 |
574 | 2024-03-31 03:22:22 | phone | 1 | 28756 | 12 | 0.513 | 56054.6 |
573 | 2024-03-29 02:24:17 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
572 | 2024-03-12 23:13:05 | phone | 1 | 28756 | 12 | 1.126 | 25538.2 |
571 | 2024-03-07 00:03:31 | phone | 1 | 28756 | 12 | 1.140 | 25224.6 |
570 | 2024-02-27 21:41:28 | phone | 2 | 53800 | 130 | 5.360 | 10037.3 |
569 | 2024-02-27 21:12:19 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
568 | 2024-02-03 21:30:15 | phone | 1 | 28756 | 12 | 0.440 | 65354.5 |
567 | 2024-01-28 21:05:37 | phone | 1 | 28756 | 12 | 0.766 | 37540.5 |
566 | 2024-01-28 19:03:07 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
565 | 2024-01-04 16:07:26 | phone | 2 | 53800 | 130 | 1.326 | 40573.2 |
564 | 2023-12-17 10:41:18 | phone | 1 | 28756 | 12 | 0.483 | 59536.2 |
563 | 2023-12-13 03:20:46 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
562 | 2023-12-09 09:55:15 | phone | 2 | 53800 | 130 | 1.546 | 34799.5 |
561 | 2023-12-08 07:57:53 | phone | 1 | 28756 | 12 | 0.843 | 34111.5 |
560 | 2023-12-08 07:57:52 | phone | 1 | 28756 | 12 | 1.046 | 27491.4 |
559 | 2023-11-18 10:54:09 | phone | 1 | 28756 | 12 | 0.513 | 56054.6 |
558 | 2023-11-16 23:27:07 | phone | 1 | 28756 | 12 | 0.466 | 61708.2 |
557 | 2023-11-15 19:06:54 | phone | 1 | 28756 | 12 | 0.483 | 59536.2 |
556 | 2023-11-14 00:45:26 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
555 | 2023-11-02 04:53:54 | phone | 1 | 28756 | 12 | 0.923 | 31154.9 |
554 | 2023-10-28 04:12:50 | phone | 2 | 53800 | 130 | 1.456 | 36950.5 |
553 | 2023-10-19 20:39:50 | phone | 1 | 28756 | 12 | 0.546 | 52666.7 |
552 | 2023-10-18 07:02:21 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
551 | 2023-10-13 04:21:29 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
550 | 2023-10-07 07:36:20 | phone | 1 | 28756 | 12 | 0.873 | 32939.3 |
549 | 2023-09-28 16:43:11 | phone | 1 | 28756 | 12 | 0.483 | 59536.2 |
548 | 2023-09-28 02:11:35 | phone | 1 | 28756 | 12 | 0.516 | 55728.7 |
547 | 2023-09-24 07:09:28 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
546 | 2023-09-23 10:50:01 | phone | 1 | 28756 | 12 | 0.983 | 29253.3 |
545 | 2023-08-03 14:31:21 | phone | 1 | 28756 | 12 | 0.453 | 63479.0 |
544 | 2023-07-25 20:33:00 | phone | 1 | 28756 | 12 | 0.440 | 65354.5 |
543 | 2023-07-21 21:00:29 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
542 | 2023-04-23 06:02:23 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
541 | 2023-04-02 19:37:19 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
540 | 2023-02-13 17:24:21 | phone | 1 | 28756 | 12 | 0.423 | 67981.1 |
539 | 2022-12-14 14:01:21 | phone | 1 | 28756 | 12 | 0.423 | 67981.1 |
538 | 2022-12-11 10:04:42 | phone | 1 | 28756 | 12 | 0.483 | 59536.2 |
537 | 2022-12-10 14:34:01 | phone | 1 | 28756 | 12 | 0.470 | 61183.0 |
536 | 2022-08-29 20:04:53 | phone | 1 | 28756 | 12 | 0.486 | 59168.7 |
535 | 2022-08-12 09:52:08 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
534 | 2022-08-11 04:40:01 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
533 | 2022-08-10 00:28:39 | phone | 1 | 28756 | 12 | 0.420 | 68466.7 |
532 | 2022-04-13 22:24:08 | phone | 1 | 28756 | 12 | 0.483 | 59536.2 |
531 | 2022-04-13 14:33:23 | phone | 1 | 28756 | 12 | 0.530 | 54256.6 |
530 | 2022-03-30 09:25:43 | phone | 1 | 28756 | 12 | 0.530 | 54256.6 |
529 | 2022-03-28 05:26:45 | phone | 1 | 28756 | 12 | 0.440 | 65354.5 |
528 | 2022-02-25 06:45:29 | phone | 1 | 28756 | 12 | 0.466 | 61708.2 |
527 | 2022-02-24 03:15:18 | phone | 1 | 28756 | 12 | 0.653 | 44036.8 |
526 | 2022-02-23 13:37:40 | phone | 1 | 28756 | 12 | 0.453 | 63479.0 |
525 | 2022-02-22 11:41:02 | phone | 1 | 28756 | 12 | 0.486 | 59168.7 |
524 | 2022-02-21 04:16:04 | phone | 1 | 28756 | 12 | 0.453 | 63479.0 |
523 | 2022-02-20 06:40:19 | phone | 1 | 28756 | 12 | 0.453 | 63479.0 |
522 | 2022-02-19 05:45:26 | phone | 1 | 28756 | 12 | 0.483 | 59536.2 |
521 | 2022-02-18 05:52:48 | phone | 1 | 28756 | 12 | 0.423 | 67981.1 |
520 | 2022-02-17 06:47:46 | phone | 1 | 28756 | 12 | 0.953 | 30174.2 |
519 | 2022-02-16 10:26:38 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
518 | 2022-02-15 06:19:56 | phone | 1 | 28756 | 12 | 0.546 | 52666.7 |
517 | 2022-02-14 09:54:02 | phone | 1 | 28756 | 12 | 0.420 | 68466.7 |
516 | 2022-02-06 17:54:12 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
515 | 2022-02-05 13:48:49 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
514 | 2022-02-05 04:43:52 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
513 | 2022-02-04 14:53:33 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
512 | 2022-02-03 11:04:13 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
511 | 2022-02-02 08:17:20 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
510 | 2022-02-01 09:49:32 | phone | 1 | 28756 | 12 | 0.483 | 59536.2 |
509 | 2022-01-31 09:58:05 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
508 | 2022-01-30 16:04:29 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
507 | 2022-01-29 16:15:40 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
506 | 2022-01-23 23:55:21 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
505 | 2022-01-03 15:40:17 | phone | 1 | 28756 | 12 | 0.533 | 53951.2 |
504 | 2021-12-29 20:21:01 | phone | 1 | 28756 | 12 | 0.530 | 54256.6 |
503 | 2021-12-25 22:40:58 | phone | 1 | 28756 | 12 | 0.453 | 63479.0 |
502 | 2021-12-06 23:58:41 | phone | 1 | 28756 | 12 | 0.530 | 54256.6 |
501 | 2021-11-29 22:45:19 | phone | 1 | 28756 | 12 | 0.486 | 59168.7 |
500 | 2021-11-27 04:05:00 | phone | 1 | 28756 | 12 | 0.453 | 63479.0 |
499 | 2021-11-26 18:09:52 | phone | 1 | 28756 | 12 | 0.533 | 53951.2 |
498 | 2021-11-26 06:20:24 | phone | 1 | 28756 | 12 | 0.423 | 67981.1 |
497 | 2021-11-25 14:28:21 | phone | 1 | 28756 | 12 | 0.970 | 29645.4 |
496 | 2021-10-30 11:56:53 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
495 | 2021-10-30 10:01:58 | phone | 1 | 28756 | 12 | 0.533 | 53951.2 |
494 | 2021-10-29 10:38:03 | phone | 1 | 28756 | 12 | 0.516 | 55728.7 |
493 | 2021-10-28 23:17:49 | phone | 1 | 28756 | 12 | 0.440 | 65354.5 |
492 | 2021-10-28 09:14:09 | phone | 1 | 28756 | 12 | 0.563 | 51076.4 |
491 | 2021-10-27 19:06:59 | phone | 1 | 28756 | 12 | 0.483 | 59536.2 |
490 | 2021-09-18 17:49:08 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
489 | 2021-09-12 08:09:33 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
488 | 2021-08-31 17:59:43 | phone | 1 | 28756 | 12 | 0.436 | 65954.1 |
487 | 2021-08-27 21:19:46 | phone | 1 | 28756 | 12 | 0.483 | 59536.2 |
486 | 2021-08-12 08:39:59 | phone | 1 | 28756 | 12 | 0.440 | 65354.5 |
485 | 2021-08-11 14:20:27 | phone | 1 | 28756 | 12 | 0.500 | 57512.0 |
484 | 2021-08-09 23:20:05 | phone | 1 | 28756 | 12 | 0.453 | 63479.0 |
483 | 2021-07-24 04:04:37 | phone | 1 | 28756 | 12 | 0.483 | 59536.2 |