History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"photo"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
510 | 2024-04-03 02:55:50 | photo | 1 | 28756 | 7 | 1.563 | 18398.0 |
509 | 2024-03-31 03:23:52 | photo | 1 | 28756 | 7 | 1.703 | 16885.5 |
508 | 2024-03-29 09:22:39 | photo | 1 | 28756 | 7 | 0.440 | 65354.5 |
507 | 2024-03-07 04:50:13 | photo | 1 | 28756 | 7 | 0.580 | 49579.3 |
506 | 2024-03-04 01:03:26 | photo | 3 | 83667 | 813 | 3.906 | 21420.1 |
505 | 2024-03-04 01:03:24 | photo | 2 | 53800 | 62 | 2.000 | 26900.0 |
504 | 2024-03-04 01:02:12 | photo | 1 | 28756 | 7 | 0.516 | 55728.7 |
503 | 2024-02-28 13:05:16 | photo | 3 | 83667 | 813 | 9.470 | 8835.0 |
502 | 2024-02-28 11:57:33 | photo | 2 | 53800 | 62 | 1.720 | 31279.1 |
501 | 2024-02-28 11:57:11 | photo | 3 | 83667 | 813 | 3.983 | 21006.0 |
500 | 2024-02-28 03:35:38 | photo | 3 | 83667 | 813 | 4.016 | 20833.4 |
499 | 2024-02-28 03:35:37 | photo | 2 | 53800 | 62 | 1.656 | 32487.9 |
498 | 2024-02-28 03:35:35 | photo | 1 | 28756 | 7 | 0.500 | 57512.0 |
497 | 2024-02-10 10:06:27 | photo | 1 | 28756 | 7 | 0.530 | 54256.6 |
496 | 2024-01-28 21:15:49 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
495 | 2024-01-26 21:14:46 | photo | 1 | 28756 | 7 | 0.486 | 59168.7 |
494 | 2024-01-16 17:41:39 | photo | 3 | 83667 | 813 | 3.266 | 25617.6 |
493 | 2024-01-16 17:41:36 | photo | 2 | 53800 | 62 | 1.390 | 38705.0 |
492 | 2024-01-16 08:31:12 | photo | 3 | 83667 | 813 | 3.280 | 25508.2 |
491 | 2024-01-16 08:31:11 | photo | 2 | 53800 | 62 | 1.376 | 39098.8 |
490 | 2024-01-03 22:28:21 | photo | 2 | 53800 | 62 | 1.750 | 30742.9 |
489 | 2024-01-03 22:28:16 | photo | 3 | 83667 | 813 | 3.626 | 23074.2 |
488 | 2023-12-18 21:13:06 | photo | 1 | 28756 | 7 | 1.033 | 27837.4 |
487 | 2023-12-08 06:36:06 | photo | 1 | 28756 | 7 | 0.486 | 59168.7 |
486 | 2023-12-08 06:36:05 | photo | 1 | 28756 | 7 | 0.470 | 61183.0 |
485 | 2023-12-03 09:15:33 | photo | 1 | 28756 | 7 | 0.513 | 56054.6 |
484 | 2023-12-03 09:15:32 | photo | 1 | 28756 | 7 | 0.500 | 57512.0 |
483 | 2023-12-01 19:44:29 | photo | 1 | 28756 | 7 | 0.516 | 55728.7 |
482 | 2023-11-28 17:23:12 | photo | 3 | 83667 | 813 | 3.686 | 22698.6 |
481 | 2023-11-28 17:23:07 | photo | 2 | 53800 | 62 | 1.436 | 37465.2 |
480 | 2023-11-21 00:10:00 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
479 | 2023-11-17 16:17:43 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
478 | 2023-11-17 15:52:19 | photo | 1 | 28756 | 7 | 0.440 | 65354.5 |
477 | 2023-11-13 23:15:21 | photo | 1 | 28756 | 7 | 0.440 | 65354.5 |
476 | 2023-11-02 04:41:30 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
475 | 2023-10-22 02:52:42 | photo | 1 | 28756 | 7 | 0.483 | 59536.2 |
474 | 2023-10-20 11:07:01 | photo | 1 | 28756 | 7 | 0.486 | 59168.7 |
473 | 2023-10-11 11:51:02 | photo | 1 | 28756 | 7 | 0.420 | 68466.7 |
472 | 2023-10-07 08:04:39 | photo | 1 | 28756 | 7 | 0.423 | 67981.1 |
471 | 2023-09-26 19:31:50 | photo | 1 | 28756 | 7 | 0.420 | 68466.7 |
470 | 2023-09-16 15:16:54 | photo | 1 | 28756 | 7 | 0.876 | 32826.5 |
469 | 2023-09-14 03:18:30 | photo | 1 | 28756 | 7 | 0.500 | 57512.0 |
468 | 2023-07-24 00:29:19 | photo | 1 | 28756 | 7 | 0.500 | 57512.0 |
467 | 2023-07-11 08:41:17 | photo | 1 | 28756 | 7 | 0.500 | 57512.0 |
466 | 2023-04-16 11:11:01 | photo | 1 | 28756 | 7 | 0.873 | 32939.3 |
465 | 2023-04-04 21:51:18 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
464 | 2023-02-10 06:05:59 | photo | 1 | 28756 | 7 | 0.470 | 61183.0 |
463 | 2022-12-16 09:12:24 | photo | 1 | 28756 | 7 | 0.983 | 29253.3 |
462 | 2022-12-07 11:13:44 | photo | 1 | 28756 | 7 | 0.423 | 67981.1 |
461 | 2022-08-19 13:11:50 | photo | 1 | 28756 | 7 | 0.546 | 52666.7 |
460 | 2022-08-15 02:13:42 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
459 | 2022-08-06 18:34:47 | photo | 1 | 28756 | 7 | 0.483 | 59536.2 |
458 | 2022-07-10 11:04:36 | photo | 1 | 28756 | 7 | 0.453 | 63479.0 |
457 | 2022-07-02 20:14:09 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
456 | 2022-04-12 01:02:26 | photo | 1 | 28756 | 7 | 0.483 | 59536.2 |
455 | 2022-04-07 03:21:59 | photo | 1 | 28756 | 7 | 0.453 | 63479.0 |
454 | 2022-01-02 06:29:56 | photo | 1 | 28756 | 7 | 0.453 | 63479.0 |
453 | 2021-12-24 12:23:15 | photo | 1 | 28756 | 7 | 0.470 | 61183.0 |
452 | 2021-11-02 16:48:03 | photo | 1 | 28756 | 7 | 0.533 | 53951.2 |
451 | 2021-10-31 15:04:58 | photo | 1 | 28756 | 7 | 0.453 | 63479.0 |
450 | 2021-09-20 13:23:45 | photo | 1 | 28756 | 7 | 0.440 | 65354.5 |
449 | 2021-09-17 21:32:06 | photo | 1 | 28756 | 7 | 0.466 | 61708.2 |
448 | 2021-09-15 17:51:20 | photo | 1 | 28756 | 7 | 0.500 | 57512.0 |
447 | 2021-08-24 20:17:04 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
446 | 2021-07-25 01:34:21 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
445 | 2021-06-17 10:15:37 | photo | 1 | 28756 | 7 | 0.453 | 63479.0 |
444 | 2021-06-13 22:30:58 | photo | 1 | 28756 | 7 | 0.516 | 55728.7 |
443 | 2021-05-15 05:12:50 | photo | 1 | 28756 | 7 | 0.486 | 59168.7 |
442 | 2021-05-02 14:39:03 | photo | 1 | 28756 | 7 | 0.606 | 47452.1 |
441 | 2021-03-11 02:38:24 | photo | 1 | 28756 | 7 | 0.470 | 61183.0 |
440 | 2021-02-20 21:43:08 | photo | 1 | 28756 | 7 | 0.733 | 39230.6 |
439 | 2021-01-18 04:48:57 | photo | 1 | 28756 | 7 | 0.483 | 59536.2 |
438 | 2020-12-30 04:22:03 | photo | 1 | 28756 | 7 | 0.483 | 59536.2 |
437 | 2020-12-03 17:50:50 | photo | 1 | 28756 | 7 | 0.486 | 59168.7 |
436 | 2020-11-17 02:57:26 | photo | 1 | 28756 | 7 | 0.483 | 59536.2 |
435 | 2020-10-28 16:57:09 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
434 | 2020-10-23 01:33:26 | photo | 1 | 28756 | 7 | 0.423 | 67981.1 |
433 | 2020-10-16 17:13:28 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
432 | 2020-09-22 14:02:58 | photo | 1 | 28756 | 7 | 0.436 | 65954.1 |
431 | 2020-08-25 23:59:26 | photo | 1 | 28756 | 7 | 0.420 | 68466.7 |
430 | 2020-08-22 20:10:50 | photo | 1 | 28756 | 7 | 0.453 | 63479.0 |
429 | 2020-08-01 10:50:39 | photo | 1 | 28756 | 7 | 0.453 | 63479.0 |
428 | 2020-05-21 12:45:29 | photo | 1 | 28756 | 7 | 0.483 | 59536.2 |
427 | 2020-05-16 08:55:39 | photo | 1 | 28756 | 7 | 0.486 | 59168.7 |
426 | 2020-05-07 07:31:51 | photo | 1 | 28756 | 7 | 0.500 | 57512.0 |
425 | 2020-03-25 00:23:29 | photo | 1 | 28756 | 7 | 0.500 | 57512.0 |
424 | 2020-03-24 17:51:15 | photo | 1 | 28756 | 7 | 0.500 | 57512.0 |
423 | 2020-03-22 20:48:46 | photo | 1 | 28756 | 7 | 0.466 | 61708.2 |
422 | 2020-03-22 05:38:29 | photo | 1 | 28756 | 7 | 0.513 | 56054.6 |
421 | 2020-03-21 11:15:34 | photo | 1 | 28756 | 7 | 0.500 | 57512.0 |
420 | 2020-03-17 22:23:10 | photo | 1 | 28756 | 7 | 0.453 | 63479.0 |
419 | 2020-03-15 06:44:13 | photo | 1 | 28756 | 7 | 0.486 | 59168.7 |
418 | 2020-02-24 12:59:30 | photo | 1 | 28756 | 7 | 1.046 | 27491.4 |
417 | 2020-02-23 01:32:29 | photo | 1 | 28756 | 7 | 0.530 | 54256.6 |
416 | 2020-02-22 20:47:17 | photo | 1 | 28756 | 7 | 1.076 | 26724.9 |
415 | 2020-02-18 10:45:36 | photo | 1 | 28756 | 7 | 1.093 | 26309.2 |
414 | 2020-02-15 04:59:32 | photo | 1 | 28756 | 7 | 0.530 | 54256.6 |
413 | 2020-02-11 06:06:48 | photo | 1 | 28756 | 7 | 0.576 | 49923.6 |
412 | 2020-01-31 04:12:31 | photo | 1 | 28756 | 7 | 0.580 | 49579.3 |
411 | 2020-01-31 03:16:00 | photo | 1 | 28756 | 7 | 0.486 | 59168.7 |