History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"photogs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
522 | 2024-04-16 15:44:49 | photogs | 2 | 107671 | 16 | 3.266 | 32967.2 |
521 | 2024-04-13 05:41:57 | photogs | 1 | 69583 | 4 | 1.263 | 55093.4 |
520 | 2024-04-12 19:29:28 | photogs | 2 | 107671 | 16 | 5.623 | 19148.3 |
519 | 2024-04-12 19:29:16 | photogs | 3 | 134027 | 168 | 8.203 | 16338.8 |
518 | 2024-04-11 04:07:55 | photogs | 2 | 107671 | 16 | 3.423 | 31455.2 |
517 | 2024-04-11 04:07:43 | photogs | 3 | 134027 | 168 | 6.940 | 19312.2 |
516 | 2024-04-09 02:58:36 | photogs | 2 | 107671 | 16 | 3.580 | 30075.7 |
515 | 2024-04-09 02:58:36 | photogs | 1 | 69583 | 4 | 2.220 | 31343.7 |
514 | 2024-04-09 02:58:18 | photogs | 3 | 134027 | 168 | 8.876 | 15099.9 |
513 | 2024-04-08 03:12:39 | photogs | 3 | 134027 | 168 | 24.283 | 5519.4 |
512 | 2024-04-07 20:03:47 | photogs | 3 | 134027 | 168 | 16.486 | 8129.7 |
511 | 2024-04-07 20:02:42 | photogs | 3 | 134027 | 168 | 24.630 | 5441.6 |
510 | 2024-03-06 00:04:56 | photogs | 3 | 134027 | 168 | 20.000 | 6701.4 |
509 | 2024-03-05 15:08:59 | photogs | 2 | 107671 | 16 | 3.250 | 33129.5 |
508 | 2024-03-05 15:08:41 | photogs | 3 | 134027 | 168 | 6.860 | 19537.5 |
507 | 2024-03-02 18:17:25 | photogs | 3 | 134027 | 168 | 15.330 | 8742.8 |
506 | 2024-03-02 06:51:48 | photogs | 2 | 107671 | 16 | 4.593 | 23442.4 |
505 | 2024-03-02 06:51:05 | photogs | 3 | 134027 | 168 | 18.063 | 7420.0 |
504 | 2024-03-01 19:40:17 | photogs | 3 | 134027 | 168 | 19.690 | 6806.9 |
503 | 2024-03-01 19:40:18 | photogs | 2 | 107671 | 16 | 9.660 | 11146.1 |
502 | 2024-03-01 19:40:14 | photogs | 1 | 69583 | 4 | 1.440 | 48321.5 |
501 | 2024-02-27 21:39:45 | photogs | 1 | 69583 | 4 | 2.640 | 26357.2 |
500 | 2023-12-24 18:40:50 | photogs | 1 | 69583 | 4 | 1.076 | 64668.2 |
499 | 2023-12-15 04:21:55 | photogs | 2 | 107671 | 16 | 2.843 | 37872.3 |
498 | 2023-12-10 11:45:55 | photogs | 3 | 134027 | 168 | 5.576 | 24036.4 |
497 | 2023-12-08 14:49:42 | photogs | 1 | 69583 | 4 | 1.046 | 66522.9 |
496 | 2023-11-23 12:57:55 | photogs | 1 | 69583 | 4 | 2.156 | 32274.1 |
495 | 2023-10-17 12:26:19 | photogs | 1 | 69583 | 4 | 1.186 | 58670.3 |
494 | 2023-10-13 03:16:28 | photogs | 1 | 69583 | 4 | 1.110 | 62687.4 |
493 | 2023-10-06 23:20:05 | photogs | 1 | 69583 | 4 | 1.110 | 62687.4 |
492 | 2023-09-29 11:51:53 | photogs | 1 | 69583 | 4 | 1.156 | 60192.9 |
491 | 2023-09-26 15:42:30 | photogs | 1 | 69583 | 4 | 1.203 | 57841.2 |
490 | 2023-09-23 23:26:45 | photogs | 1 | 69583 | 4 | 1.123 | 61961.7 |
489 | 2023-09-15 05:50:00 | photogs | 3 | 134027 | 168 | 6.123 | 21889.1 |
488 | 2023-09-14 04:38:00 | photogs | 3 | 134027 | 168 | 5.843 | 22938.0 |
487 | 2023-09-13 09:50:33 | photogs | 2 | 107671 | 16 | 2.766 | 38926.6 |
486 | 2023-09-08 22:00:53 | photogs | 3 | 134027 | 168 | 5.783 | 23176.0 |
485 | 2023-08-15 13:33:01 | photogs | 1 | 69583 | 4 | 1.016 | 68487.2 |
484 | 2023-07-22 04:06:34 | photogs | 1 | 69583 | 4 | 1.033 | 67360.1 |
483 | 2023-06-07 02:52:49 | photogs | 2 | 107671 | 16 | 2.703 | 39833.9 |
482 | 2023-05-27 23:31:12 | photogs | 3 | 134027 | 168 | 5.546 | 24166.4 |
481 | 2023-04-25 03:06:12 | photogs | 1 | 69583 | 4 | 1.160 | 59985.3 |
480 | 2023-04-23 16:06:22 | photogs | 1 | 69583 | 4 | 1.046 | 66522.9 |
479 | 2023-03-11 16:58:50 | photogs | 2 | 107671 | 16 | 2.720 | 39584.9 |
478 | 2023-03-06 03:58:25 | photogs | 3 | 134027 | 168 | 5.546 | 24166.4 |
477 | 2023-03-02 04:01:07 | photogs | 3 | 134027 | 168 | 5.720 | 23431.3 |
476 | 2023-02-15 03:04:01 | photogs | 1 | 69583 | 4 | 1.033 | 67360.1 |
475 | 2023-02-07 14:47:06 | photogs | 3 | 134027 | 168 | 6.003 | 22326.7 |
474 | 2022-12-31 01:50:46 | photogs | 1 | 69583 | 4 | 1.080 | 64428.7 |
473 | 2022-12-23 21:39:23 | photogs | 3 | 134027 | 168 | 6.500 | 20619.5 |
472 | 2022-12-22 02:37:59 | photogs | 3 | 134027 | 168 | 6.406 | 20922.1 |
471 | 2022-12-15 07:33:10 | photogs | 2 | 107671 | 16 | 2.750 | 39153.1 |
470 | 2022-12-12 22:44:12 | photogs | 3 | 134027 | 168 | 6.266 | 21389.6 |
469 | 2022-12-11 15:09:43 | photogs | 1 | 69583 | 4 | 1.203 | 57841.2 |
468 | 2022-11-13 12:52:16 | photogs | 3 | 134027 | 168 | 5.686 | 23571.4 |
467 | 2022-11-07 01:35:18 | photogs | 3 | 134027 | 168 | 6.140 | 21828.5 |
466 | 2022-11-06 23:48:05 | photogs | 3 | 134027 | 168 | 5.953 | 22514.2 |
465 | 2022-10-13 15:27:08 | photogs | 3 | 134027 | 168 | 5.563 | 24092.6 |
464 | 2022-10-04 20:12:14 | photogs | 3 | 134027 | 168 | 5.670 | 23637.9 |
463 | 2022-09-02 18:48:53 | photogs | 3 | 134027 | 168 | 5.796 | 23124.1 |
462 | 2022-08-30 08:39:17 | photogs | 1 | 69583 | 4 | 1.186 | 58670.3 |
461 | 2022-08-15 22:27:12 | photogs | 1 | 69583 | 4 | 1.063 | 65459.1 |
460 | 2022-08-04 10:13:43 | photogs | 2 | 107671 | 16 | 3.030 | 35535.0 |
459 | 2022-08-03 10:34:25 | photogs | 3 | 134027 | 168 | 6.343 | 21129.9 |
458 | 2022-07-31 10:25:03 | photogs | 1 | 69583 | 4 | 1.063 | 65459.1 |
457 | 2022-07-29 08:38:38 | photogs | 1 | 69583 | 4 | 1.220 | 57035.2 |
456 | 2022-04-22 18:52:25 | photogs | 1 | 69583 | 4 | 1.076 | 64668.2 |
455 | 2022-04-16 03:56:22 | photogs | 3 | 134027 | 168 | 6.356 | 21086.7 |
454 | 2022-04-08 23:59:42 | photogs | 1 | 69583 | 4 | 1.080 | 64428.7 |
453 | 2022-03-11 10:11:09 | photogs | 3 | 134027 | 168 | 5.516 | 24297.9 |
452 | 2022-03-10 04:39:02 | photogs | 2 | 107671 | 16 | 3.203 | 33615.7 |
451 | 2022-01-13 08:38:09 | photogs | 1 | 69583 | 4 | 1.110 | 62687.4 |
450 | 2022-01-12 16:56:07 | photogs | 1 | 69583 | 4 | 1.156 | 60192.9 |
449 | 2022-01-12 08:51:27 | photogs | 1 | 69583 | 4 | 1.186 | 58670.3 |
448 | 2022-01-11 12:26:16 | photogs | 1 | 69583 | 4 | 1.330 | 52318.0 |
447 | 2022-01-10 14:04:59 | photogs | 1 | 69583 | 4 | 1.250 | 55666.4 |
446 | 2022-01-06 14:10:23 | photogs | 1 | 69583 | 4 | 1.266 | 54962.9 |
445 | 2022-01-04 09:33:01 | photogs | 1 | 69583 | 4 | 1.093 | 63662.4 |
444 | 2022-01-03 17:58:24 | photogs | 1 | 69583 | 4 | 1.250 | 55666.4 |
443 | 2022-01-03 10:11:18 | photogs | 1 | 69583 | 4 | 1.186 | 58670.3 |
442 | 2021-12-31 19:08:45 | photogs | 1 | 69583 | 4 | 1.140 | 61037.7 |
441 | 2021-12-31 09:48:23 | photogs | 1 | 69583 | 4 | 1.266 | 54962.9 |
440 | 2021-12-30 18:30:03 | photogs | 1 | 69583 | 4 | 1.123 | 61961.7 |
439 | 2021-12-30 02:15:31 | photogs | 1 | 69583 | 4 | 1.233 | 56433.9 |
438 | 2021-12-29 17:38:30 | photogs | 1 | 69583 | 4 | 1.343 | 51811.6 |
437 | 2021-12-29 10:35:02 | photogs | 1 | 69583 | 4 | 1.343 | 51811.6 |
436 | 2021-12-28 15:59:38 | photogs | 1 | 69583 | 4 | 1.203 | 57841.2 |
435 | 2021-12-28 00:32:14 | photogs | 1 | 69583 | 4 | 1.250 | 55666.4 |
434 | 2021-12-27 15:32:15 | photogs | 1 | 69583 | 4 | 1.170 | 59472.6 |
433 | 2021-12-27 06:45:58 | photogs | 1 | 69583 | 4 | 1.170 | 59472.6 |
432 | 2021-12-26 15:01:20 | photogs | 1 | 69583 | 4 | 1.203 | 57841.2 |
431 | 2021-12-26 04:00:00 | photogs | 1 | 69583 | 4 | 1.233 | 56433.9 |
430 | 2021-12-25 15:59:29 | photogs | 1 | 69583 | 4 | 1.123 | 61961.7 |
429 | 2021-12-25 06:06:22 | photogs | 1 | 69583 | 4 | 2.626 | 26497.7 |
428 | 2021-12-24 19:21:11 | photogs | 1 | 69583 | 4 | 1.203 | 57841.2 |
427 | 2021-12-24 06:10:29 | photogs | 1 | 69583 | 4 | 1.203 | 57841.2 |
426 | 2021-12-23 23:39:47 | photogs | 1 | 69583 | 4 | 1.280 | 54361.7 |
425 | 2021-12-18 11:20:38 | photogs | 2 | 107671 | 16 | 3.516 | 30623.2 |
424 | 2021-12-16 10:57:42 | photogs | 1 | 69583 | 4 | 1.236 | 56296.9 |
423 | 2021-12-04 23:26:25 | photogs | 3 | 134027 | 168 | 6.766 | 19808.9 |