History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"phots"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
535 | 2024-05-04 12:52:55 | phots | 1 | 28756 | 10 | 0.516 | 55728.7 |
534 | 2024-04-29 16:15:17 | phots | 1 | 28756 | 10 | 1.546 | 18600.3 |
533 | 2024-04-20 08:58:08 | phots | 1 | 28756 | 10 | 0.453 | 63479.0 |
532 | 2024-04-10 22:29:51 | phots | 2 | 53800 | 181 | 1.720 | 31279.1 |
531 | 2024-04-03 04:37:48 | phots | 2 | 53800 | 181 | 3.106 | 17321.3 |
530 | 2024-04-03 04:16:44 | phots | 1 | 28756 | 10 | 1.266 | 22714.1 |
529 | 2024-03-31 03:21:56 | phots | 1 | 28756 | 10 | 0.766 | 37540.5 |
528 | 2024-03-29 02:55:06 | phots | 1 | 28756 | 10 | 0.513 | 56054.6 |
527 | 2024-03-27 04:34:27 | phots | 1 | 28756 | 10 | 0.516 | 55728.7 |
526 | 2024-02-26 01:40:48 | phots | 2 | 53800 | 181 | 3.563 | 15099.6 |
525 | 2024-02-25 22:19:06 | phots | 2 | 53800 | 181 | 3.720 | 14462.4 |
524 | 2024-02-25 22:15:44 | phots | 1 | 28756 | 10 | 1.720 | 16718.6 |
523 | 2024-02-02 19:05:55 | phots | 1 | 28756 | 10 | 0.453 | 63479.0 |
522 | 2024-01-28 19:02:43 | phots | 1 | 28756 | 10 | 0.486 | 59168.7 |
521 | 2024-01-26 20:20:25 | phots | 1 | 28756 | 10 | 0.530 | 54256.6 |
520 | 2024-01-24 02:24:30 | phots | 1 | 28756 | 10 | 0.423 | 67981.1 |
519 | 2024-01-14 14:33:42 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
518 | 2024-01-01 20:12:33 | phots | 2 | 53800 | 181 | 1.343 | 40059.6 |
517 | 2023-12-29 12:18:22 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
516 | 2023-12-07 16:00:12 | phots | 2 | 53800 | 181 | 1.516 | 35488.1 |
515 | 2023-12-04 07:23:09 | phots | 2 | 53800 | 181 | 1.326 | 40573.2 |
514 | 2023-11-23 01:09:49 | phots | 1 | 28756 | 10 | 0.420 | 68466.7 |
513 | 2023-11-19 10:56:12 | phots | 1 | 28756 | 10 | 0.516 | 55728.7 |
512 | 2023-11-19 01:31:28 | phots | 1 | 28756 | 10 | 0.466 | 61708.2 |
511 | 2023-11-13 23:13:02 | phots | 1 | 28756 | 10 | 0.440 | 65354.5 |
510 | 2023-10-28 04:11:56 | phots | 2 | 53800 | 181 | 1.390 | 38705.0 |
509 | 2023-10-28 00:27:56 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
508 | 2023-10-19 20:39:47 | phots | 1 | 28756 | 10 | 0.500 | 57512.0 |
507 | 2023-10-18 07:38:16 | phots | 1 | 28756 | 10 | 0.483 | 59536.2 |
506 | 2023-10-11 11:51:38 | phots | 1 | 28756 | 10 | 0.486 | 59168.7 |
505 | 2023-10-04 11:49:44 | phots | 1 | 28756 | 10 | 0.423 | 67981.1 |
504 | 2023-09-24 06:55:47 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
503 | 2023-09-22 07:08:56 | phots | 1 | 28756 | 10 | 0.500 | 57512.0 |
502 | 2023-09-18 03:26:10 | phots | 1 | 28756 | 10 | 0.500 | 57512.0 |
501 | 2023-09-05 14:00:10 | phots | 1 | 28756 | 10 | 0.500 | 57512.0 |
500 | 2023-09-04 21:58:55 | phots | 2 | 53800 | 181 | 1.500 | 35866.7 |
499 | 2023-06-08 07:56:54 | phots | 1 | 28756 | 10 | 0.440 | 65354.5 |
498 | 2023-06-04 07:20:01 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
497 | 2023-05-18 06:50:50 | phots | 2 | 53800 | 181 | 1.356 | 39675.5 |
496 | 2023-03-30 07:37:41 | phots | 1 | 28756 | 10 | 0.440 | 65354.5 |
495 | 2023-02-27 09:43:46 | phots | 2 | 53800 | 181 | 1.546 | 34799.5 |
494 | 2023-02-26 01:35:05 | phots | 1 | 28756 | 10 | 0.470 | 61183.0 |
493 | 2023-01-12 19:24:25 | phots | 1 | 28756 | 10 | 0.453 | 63479.0 |
492 | 2022-12-09 05:27:07 | phots | 2 | 53800 | 181 | 1.500 | 35866.7 |
491 | 2022-11-05 21:06:30 | phots | 1 | 28756 | 10 | 0.470 | 61183.0 |
490 | 2022-10-20 06:15:37 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
489 | 2022-07-23 15:20:52 | phots | 1 | 28756 | 10 | 0.500 | 57512.0 |
488 | 2022-07-22 01:25:58 | phots | 2 | 53800 | 181 | 1.346 | 39970.3 |
487 | 2022-07-18 07:05:20 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
486 | 2022-07-10 09:47:05 | phots | 1 | 28756 | 10 | 0.440 | 65354.5 |
485 | 2022-06-25 14:53:30 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
484 | 2022-06-11 09:49:06 | phots | 1 | 28756 | 10 | 0.440 | 65354.5 |
483 | 2022-06-01 18:58:30 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
482 | 2022-03-29 07:44:30 | phots | 1 | 28756 | 10 | 0.470 | 61183.0 |
481 | 2022-02-16 19:04:25 | phots | 1 | 28756 | 10 | 0.513 | 56054.6 |
480 | 2021-12-21 08:53:01 | phots | 1 | 28756 | 10 | 0.470 | 61183.0 |
479 | 2021-12-04 00:42:23 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
478 | 2021-10-19 14:47:07 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
477 | 2021-09-14 03:50:36 | phots | 1 | 28756 | 10 | 0.483 | 59536.2 |
476 | 2021-09-11 17:53:10 | phots | 1 | 28756 | 10 | 0.500 | 57512.0 |
475 | 2021-09-10 23:00:22 | phots | 1 | 28756 | 10 | 0.466 | 61708.2 |
474 | 2021-09-09 13:43:45 | phots | 1 | 28756 | 10 | 0.546 | 52666.7 |
473 | 2021-08-25 02:21:10 | phots | 1 | 28756 | 10 | 0.483 | 59536.2 |
472 | 2021-07-25 02:58:33 | phots | 1 | 28756 | 10 | 0.440 | 65354.5 |
471 | 2021-06-10 01:52:46 | phots | 1 | 28756 | 10 | 0.500 | 57512.0 |
470 | 2021-05-15 08:09:37 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
469 | 2021-05-02 14:41:22 | phots | 1 | 28756 | 10 | 0.530 | 54256.6 |
468 | 2021-03-07 15:24:32 | phots | 1 | 28756 | 10 | 0.500 | 57512.0 |
467 | 2021-02-21 01:17:27 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
466 | 2021-01-28 01:34:35 | phots | 1 | 28756 | 10 | 0.486 | 59168.7 |
465 | 2020-12-30 08:13:11 | phots | 1 | 28756 | 10 | 0.500 | 57512.0 |
464 | 2020-12-03 20:13:24 | phots | 1 | 28756 | 10 | 0.453 | 63479.0 |
463 | 2020-10-22 07:14:27 | phots | 1 | 28756 | 10 | 0.453 | 63479.0 |
462 | 2020-10-21 07:25:40 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
461 | 2020-10-16 00:17:50 | phots | 1 | 28756 | 10 | 0.423 | 67981.1 |
460 | 2020-08-26 01:23:04 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
459 | 2020-08-22 21:52:36 | phots | 1 | 28756 | 10 | 0.546 | 52666.7 |
458 | 2020-06-21 06:14:16 | phots | 1 | 28756 | 10 | 0.453 | 63479.0 |
457 | 2020-06-17 01:03:27 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
456 | 2020-06-14 02:44:46 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
455 | 2020-06-13 02:46:26 | phots | 1 | 28756 | 10 | 0.436 | 65954.1 |
454 | 2020-06-05 10:10:12 | phots | 1 | 28756 | 10 | 0.453 | 63479.0 |
453 | 2020-05-21 14:11:28 | phots | 1 | 28756 | 10 | 0.423 | 67981.1 |
452 | 2020-03-25 10:34:27 | phots | 1 | 28756 | 10 | 0.516 | 55728.7 |
451 | 2020-03-24 17:51:16 | phots | 1 | 28756 | 10 | 0.503 | 57169.0 |
450 | 2020-03-22 05:13:04 | phots | 1 | 28756 | 10 | 0.516 | 55728.7 |
449 | 2020-03-21 12:50:03 | phots | 1 | 28756 | 10 | 0.516 | 55728.7 |
448 | 2020-03-21 10:08:36 | phots | 1 | 28756 | 10 | 0.470 | 61183.0 |
447 | 2020-03-18 02:14:32 | phots | 1 | 28756 | 10 | 0.423 | 67981.1 |
446 | 2020-03-01 02:25:41 | phots | 1 | 28756 | 10 | 0.593 | 48492.4 |
445 | 2020-02-26 20:25:16 | phots | 1 | 28756 | 10 | 0.503 | 57169.0 |
444 | 2020-02-24 21:42:50 | phots | 1 | 28756 | 10 | 0.640 | 44931.3 |
443 | 2020-02-19 09:23:24 | phots | 1 | 28756 | 10 | 0.453 | 63479.0 |
442 | 2020-02-19 01:03:00 | phots | 1 | 28756 | 10 | 1.673 | 17188.3 |
441 | 2020-02-18 12:08:51 | phots | 1 | 28756 | 10 | 0.530 | 54256.6 |
440 | 2020-02-18 07:27:53 | phots | 1 | 28756 | 10 | 0.530 | 54256.6 |
439 | 2020-02-17 12:10:09 | phots | 1 | 28756 | 10 | 0.546 | 52666.7 |
438 | 2020-02-16 17:23:39 | phots | 1 | 28756 | 10 | 0.453 | 63479.0 |
437 | 2020-02-12 05:19:02 | phots | 1 | 28756 | 10 | 0.470 | 61183.0 |
436 | 2020-02-11 00:59:45 | phots | 1 | 28756 | 10 | 0.530 | 54256.6 |