History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"visit"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
526 | 2024-05-01 13:57:39 | visit | 1 | 28756 | 2 | 0.576 | 49923.6 |
525 | 2024-05-01 03:31:22 | visit | 1 | 28756 | 2 | 1.030 | 27918.4 |
524 | 2024-04-30 07:34:05 | visit | 1 | 28756 | 2 | 0.500 | 57512.0 |
523 | 2024-04-27 00:49:29 | visit | 1 | 28756 | 2 | 1.046 | 27491.4 |
522 | 2024-04-06 05:54:24 | visit | 1 | 28756 | 2 | 0.533 | 53951.2 |
521 | 2024-03-31 15:33:57 | visit | 1 | 28756 | 2 | 0.530 | 54256.6 |
520 | 2024-03-29 23:50:23 | visit | 3 | 83667 | 735 | 4.123 | 20292.7 |
519 | 2024-03-29 23:49:59 | visit | 1 | 28756 | 2 | 0.670 | 42919.4 |
518 | 2024-03-10 18:44:06 | visit | 2 | 53800 | 51 | 3.266 | 16472.7 |
517 | 2024-03-10 18:02:24 | visit | 3 | 83667 | 735 | 7.453 | 11225.9 |
516 | 2024-03-10 17:37:00 | visit | 3 | 83667 | 735 | 4.296 | 19475.6 |
515 | 2024-03-08 22:16:08 | visit | 2 | 53800 | 51 | 1.796 | 29955.5 |
514 | 2024-03-08 22:15:30 | visit | 3 | 83667 | 735 | 4.050 | 20658.5 |
513 | 2024-03-08 22:03:09 | visit | 2 | 53800 | 51 | 3.343 | 16093.3 |
512 | 2024-03-08 22:02:36 | visit | 3 | 83667 | 735 | 4.156 | 20131.6 |
511 | 2024-03-07 05:25:48 | visit | 3 | 83667 | 735 | 9.030 | 9265.4 |
510 | 2024-03-07 05:25:54 | visit | 2 | 53800 | 51 | 1.766 | 30464.3 |
509 | 2024-03-07 04:31:01 | visit | 1 | 28756 | 2 | 0.500 | 57512.0 |
508 | 2024-03-01 12:50:21 | visit | 1 | 28756 | 2 | 0.440 | 65354.5 |
507 | 2024-02-28 22:40:34 | visit | 2 | 53800 | 51 | 1.530 | 35163.4 |
506 | 2024-02-28 22:40:32 | visit | 1 | 28756 | 2 | 0.470 | 61183.0 |
505 | 2024-02-23 16:53:31 | visit | 1 | 28756 | 2 | 0.546 | 52666.7 |
504 | 2024-02-04 12:43:36 | visit | 3 | 83667 | 735 | 10.610 | 7885.7 |
503 | 2024-02-04 02:12:05 | visit | 2 | 53800 | 51 | 1.580 | 34050.6 |
502 | 2024-02-04 02:11:41 | visit | 3 | 83667 | 735 | 3.856 | 21697.9 |
501 | 2024-02-04 00:35:19 | visit | 2 | 53800 | 51 | 1.470 | 36598.6 |
500 | 2024-02-04 00:35:15 | visit | 3 | 83667 | 735 | 3.750 | 22311.2 |
499 | 2024-02-04 00:35:11 | visit | 1 | 28756 | 2 | 0.483 | 59536.2 |
498 | 2024-01-29 07:27:01 | visit | 1 | 28756 | 2 | 0.466 | 61708.2 |
497 | 2024-01-29 06:36:07 | visit | 1 | 28756 | 2 | 0.436 | 65954.1 |
496 | 2024-01-23 17:27:36 | visit | 1 | 28756 | 2 | 1.063 | 27051.7 |
495 | 2024-01-10 23:54:10 | visit | 3 | 83667 | 735 | 3.326 | 25155.4 |
494 | 2024-01-10 23:54:08 | visit | 2 | 53800 | 51 | 1.513 | 35558.5 |
493 | 2024-01-04 17:28:46 | visit | 3 | 83667 | 735 | 4.266 | 19612.5 |
492 | 2024-01-04 17:28:49 | visit | 2 | 53800 | 51 | 1.610 | 33416.1 |
491 | 2023-12-13 18:04:43 | visit | 1 | 28756 | 2 | 0.420 | 68466.7 |
490 | 2023-12-06 01:29:03 | visit | 1 | 28756 | 2 | 0.470 | 61183.0 |
489 | 2023-11-20 14:35:23 | visit | 2 | 53800 | 51 | 1.703 | 31591.3 |
488 | 2023-11-20 14:35:20 | visit | 3 | 83667 | 735 | 4.126 | 20278.0 |
487 | 2023-11-17 17:14:48 | visit | 1 | 28756 | 2 | 0.436 | 65954.1 |
486 | 2023-11-14 16:38:37 | visit | 1 | 28756 | 2 | 0.440 | 65354.5 |
485 | 2023-11-04 01:41:50 | visit | 1 | 28756 | 2 | 0.423 | 67981.1 |
484 | 2023-10-22 08:50:40 | visit | 3 | 83667 | 735 | 3.720 | 22491.1 |
483 | 2023-10-22 08:50:39 | visit | 2 | 53800 | 51 | 1.533 | 35094.6 |
482 | 2023-10-21 15:55:25 | visit | 1 | 28756 | 2 | 0.466 | 61708.2 |
481 | 2023-10-17 00:35:28 | visit | 1 | 28756 | 2 | 0.500 | 57512.0 |
480 | 2023-10-11 05:02:39 | visit | 1 | 28756 | 2 | 0.436 | 65954.1 |
479 | 2023-10-05 05:21:00 | visit | 1 | 28756 | 2 | 0.483 | 59536.2 |
478 | 2023-09-29 10:27:18 | visit | 1 | 28756 | 2 | 1.156 | 24875.4 |
477 | 2023-09-20 01:41:52 | visit | 1 | 28756 | 2 | 0.470 | 61183.0 |
476 | 2023-09-12 02:03:36 | visit | 1 | 28756 | 2 | 0.470 | 61183.0 |
475 | 2023-07-30 10:19:07 | visit | 1 | 28756 | 2 | 0.436 | 65954.1 |
474 | 2023-07-12 15:38:18 | visit | 1 | 28756 | 2 | 1.003 | 28670.0 |
473 | 2023-04-16 00:42:27 | visit | 1 | 28756 | 2 | 0.423 | 67981.1 |
472 | 2023-03-27 06:23:29 | visit | 1 | 28756 | 2 | 0.420 | 68466.7 |
471 | 2023-02-06 06:40:07 | visit | 1 | 28756 | 2 | 0.920 | 31256.5 |
470 | 2022-12-04 21:04:49 | visit | 1 | 28756 | 2 | 0.423 | 67981.1 |
469 | 2022-11-18 20:29:28 | visit | 1 | 28756 | 2 | 0.423 | 67981.1 |
468 | 2022-09-18 15:41:54 | visit | 1 | 28756 | 2 | 0.453 | 63479.0 |
467 | 2022-08-14 05:55:34 | visit | 1 | 28756 | 2 | 0.420 | 68466.7 |
466 | 2022-08-01 23:12:55 | visit | 1 | 28756 | 2 | 0.423 | 67981.1 |
465 | 2022-07-30 06:00:15 | visit | 1 | 28756 | 2 | 0.420 | 68466.7 |
464 | 2022-07-28 14:34:34 | visit | 1 | 28756 | 2 | 0.486 | 59168.7 |
463 | 2022-07-14 22:54:59 | visit | 1 | 28756 | 2 | 0.436 | 65954.1 |
462 | 2022-07-10 05:04:52 | visit | 1 | 28756 | 2 | 0.436 | 65954.1 |
461 | 2022-07-03 12:31:02 | visit | 1 | 28756 | 2 | 0.440 | 65354.5 |
460 | 2022-07-02 16:28:26 | visit | 1 | 28756 | 2 | 0.483 | 59536.2 |
459 | 2022-06-16 12:29:07 | visit | 1 | 28756 | 2 | 0.423 | 67981.1 |
458 | 2022-06-12 08:43:39 | visit | 1 | 28756 | 2 | 0.470 | 61183.0 |
457 | 2022-05-26 04:11:42 | visit | 1 | 28756 | 2 | 0.436 | 65954.1 |
456 | 2022-04-17 02:27:11 | visit | 1 | 28756 | 2 | 0.423 | 67981.1 |
455 | 2022-03-04 05:30:18 | visit | 1 | 28756 | 2 | 0.466 | 61708.2 |
454 | 2022-02-28 19:36:21 | visit | 1 | 28756 | 2 | 0.686 | 41918.4 |
453 | 2022-02-28 18:51:43 | visit | 1 | 28756 | 2 | 0.453 | 63479.0 |
452 | 2021-10-24 20:29:18 | visit | 1 | 28756 | 2 | 0.483 | 59536.2 |
451 | 2021-07-10 11:36:10 | visit | 1 | 28756 | 2 | 0.453 | 63479.0 |
450 | 2021-06-13 09:59:24 | visit | 1 | 28756 | 2 | 0.470 | 61183.0 |
449 | 2021-04-10 23:36:01 | visit | 1 | 28756 | 2 | 0.483 | 59536.2 |
448 | 2021-03-23 10:33:16 | visit | 1 | 28756 | 2 | 0.500 | 57512.0 |
447 | 2021-03-11 02:42:32 | visit | 3 | 83667 | 735 | 3.440 | 24321.8 |
446 | 2021-02-26 16:51:18 | visit | 3 | 83667 | 735 | 3.453 | 24230.2 |
445 | 2021-02-18 23:11:06 | visit | 3 | 83667 | 735 | 4.126 | 20278.0 |
444 | 2021-02-04 21:38:48 | visit | 1 | 28756 | 2 | 0.453 | 63479.0 |
443 | 2021-01-22 00:49:42 | visit | 3 | 83667 | 735 | 3.343 | 25027.5 |
442 | 2021-01-05 10:16:40 | visit | 1 | 28756 | 2 | 0.470 | 61183.0 |
441 | 2020-12-23 18:55:47 | visit | 2 | 53800 | 51 | 1.813 | 29674.6 |
440 | 2020-12-23 02:01:49 | visit | 3 | 83667 | 735 | 3.186 | 26260.8 |
439 | 2020-12-21 11:44:43 | visit | 1 | 28756 | 2 | 0.500 | 57512.0 |
438 | 2020-11-06 09:48:12 | visit | 3 | 83667 | 735 | 3.626 | 23074.2 |
437 | 2020-11-04 16:54:22 | visit | 2 | 53800 | 51 | 1.783 | 30173.9 |
436 | 2020-11-01 13:07:25 | visit | 3 | 83667 | 735 | 3.656 | 22884.8 |
435 | 2020-10-23 16:58:01 | visit | 1 | 28756 | 2 | 0.470 | 61183.0 |
434 | 2020-10-22 02:38:10 | visit | 3 | 83667 | 735 | 3.516 | 23796.1 |
433 | 2020-10-20 06:09:51 | visit | 1 | 28756 | 2 | 0.483 | 59536.2 |
432 | 2020-10-16 16:35:51 | visit | 3 | 83667 | 735 | 3.250 | 25743.7 |
431 | 2020-10-16 10:20:10 | visit | 1 | 28756 | 2 | 0.436 | 65954.1 |
430 | 2020-10-05 03:00:51 | visit | 1 | 28756 | 2 | 0.483 | 59536.2 |
429 | 2020-09-13 19:18:12 | visit | 1 | 28756 | 2 | 0.420 | 68466.7 |
428 | 2020-08-21 03:09:08 | visit | 1 | 28756 | 2 | 0.436 | 65954.1 |
427 | 2020-08-04 05:54:38 | visit | 3 | 83667 | 735 | 3.703 | 22594.4 |