History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"offer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
526 | 2024-04-25 20:41:49 | offer | 3 | 83667 | 1102 | 11.533 | 7254.6 |
525 | 2024-04-24 14:29:23 | offer | 1 | 28756 | 7 | 0.560 | 51350.0 |
524 | 2024-04-02 21:58:08 | offer | 1 | 28756 | 7 | 0.546 | 52666.7 |
523 | 2024-03-31 06:03:18 | offer | 3 | 83667 | 1102 | 4.466 | 18734.2 |
522 | 2024-03-31 06:03:20 | offer | 2 | 53800 | 81 | 1.766 | 30464.3 |
521 | 2024-03-31 06:03:06 | offer | 3 | 83667 | 1102 | 8.576 | 9755.9 |
520 | 2024-03-31 06:03:11 | offer | 1 | 28756 | 7 | 0.580 | 49579.3 |
519 | 2024-03-31 06:03:02 | offer | 2 | 53800 | 81 | 1.750 | 30742.9 |
518 | 2024-03-31 04:47:19 | offer | 2 | 53800 | 81 | 5.670 | 9488.5 |
517 | 2024-03-31 04:47:17 | offer | 3 | 83667 | 1102 | 4.580 | 18267.9 |
516 | 2024-03-31 04:16:12 | offer | 1 | 28756 | 7 | 1.093 | 26309.2 |
515 | 2024-03-29 09:22:18 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
514 | 2024-03-23 04:56:29 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
513 | 2024-03-03 23:19:53 | offer | 2 | 53800 | 81 | 4.860 | 11070.0 |
512 | 2024-03-03 22:20:34 | offer | 1 | 28756 | 7 | 0.483 | 59536.2 |
511 | 2024-03-01 02:24:25 | offer | 1 | 28756 | 7 | 0.640 | 44931.3 |
510 | 2024-02-29 12:00:58 | offer | 2 | 53800 | 81 | 1.670 | 32215.6 |
509 | 2024-02-29 12:00:34 | offer | 3 | 83667 | 1102 | 4.060 | 20607.6 |
508 | 2024-02-29 02:44:55 | offer | 1 | 28756 | 7 | 0.483 | 59536.2 |
507 | 2024-02-28 07:07:23 | offer | 2 | 53800 | 81 | 3.736 | 14400.4 |
506 | 2024-02-28 07:07:21 | offer | 3 | 83667 | 1102 | 4.110 | 20356.9 |
505 | 2024-02-28 07:07:19 | offer | 1 | 28756 | 7 | 0.516 | 55728.7 |
504 | 2024-02-03 12:06:58 | offer | 1 | 28756 | 7 | 0.483 | 59536.2 |
503 | 2024-01-29 11:36:54 | offer | 2 | 53800 | 81 | 1.610 | 33416.1 |
502 | 2024-01-29 11:36:10 | offer | 3 | 83667 | 1102 | 8.173 | 10237.0 |
501 | 2024-01-29 03:18:37 | offer | 1 | 28756 | 7 | 0.500 | 57512.0 |
500 | 2024-01-28 19:14:03 | offer | 1 | 28756 | 7 | 1.013 | 28387.0 |
499 | 2024-01-18 09:49:38 | offer | 2 | 53800 | 81 | 1.360 | 39558.8 |
498 | 2024-01-15 19:42:54 | offer | 3 | 83667 | 1102 | 3.826 | 21868.0 |
497 | 2024-01-15 19:42:56 | offer | 2 | 53800 | 81 | 1.610 | 33416.1 |
496 | 2024-01-08 20:37:42 | offer | 1 | 28756 | 7 | 0.500 | 57512.0 |
495 | 2023-12-13 05:29:10 | offer | 2 | 53800 | 81 | 1.360 | 39558.8 |
494 | 2023-11-26 18:34:45 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
493 | 2023-11-22 05:00:06 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
492 | 2023-11-16 02:54:13 | offer | 1 | 28756 | 7 | 0.470 | 61183.0 |
491 | 2023-11-05 21:04:57 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
490 | 2023-10-28 11:52:59 | offer | 2 | 53800 | 81 | 1.310 | 41068.7 |
489 | 2023-10-22 18:56:55 | offer | 1 | 28756 | 7 | 0.486 | 59168.7 |
488 | 2023-10-22 15:11:30 | offer | 1 | 28756 | 7 | 0.470 | 61183.0 |
487 | 2023-10-18 04:57:08 | offer | 1 | 28756 | 7 | 0.516 | 55728.7 |
486 | 2023-10-16 01:26:02 | offer | 1 | 28756 | 7 | 0.470 | 61183.0 |
485 | 2023-10-08 17:42:24 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
484 | 2023-09-29 15:48:00 | offer | 1 | 28756 | 7 | 0.440 | 65354.5 |
483 | 2023-09-22 18:10:32 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
482 | 2023-09-11 13:09:43 | offer | 1 | 28756 | 7 | 0.890 | 32310.1 |
481 | 2023-08-06 08:48:00 | offer | 2 | 53800 | 81 | 1.360 | 39558.8 |
480 | 2023-06-19 00:57:18 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
479 | 2023-06-11 11:11:09 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
478 | 2023-06-10 01:22:56 | offer | 1 | 28756 | 7 | 0.440 | 65354.5 |
477 | 2023-04-21 16:06:49 | offer | 1 | 28756 | 7 | 0.453 | 63479.0 |
476 | 2023-04-20 10:55:16 | offer | 2 | 53800 | 81 | 1.330 | 40451.1 |
475 | 2023-04-02 11:13:56 | offer | 1 | 28756 | 7 | 0.466 | 61708.2 |
474 | 2023-03-14 16:56:28 | offer | 1 | 28756 | 7 | 0.453 | 63479.0 |
473 | 2023-03-13 17:00:51 | offer | 1 | 28756 | 7 | 0.486 | 59168.7 |
472 | 2023-02-27 10:21:23 | offer | 1 | 28756 | 7 | 0.423 | 67981.1 |
471 | 2023-02-13 04:58:53 | offer | 1 | 28756 | 7 | 0.513 | 56054.6 |
470 | 2023-01-24 10:48:20 | offer | 2 | 53800 | 81 | 1.296 | 41512.3 |
469 | 2023-01-19 19:22:00 | offer | 1 | 28756 | 7 | 0.483 | 59536.2 |
468 | 2023-01-14 18:42:49 | offer | 1 | 28756 | 7 | 0.420 | 68466.7 |
467 | 2023-01-07 13:40:31 | offer | 1 | 28756 | 7 | 0.466 | 61708.2 |
466 | 2022-12-05 19:26:51 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
465 | 2022-11-23 08:47:31 | offer | 1 | 28756 | 7 | 0.516 | 55728.7 |
464 | 2022-11-07 14:21:27 | offer | 2 | 53800 | 81 | 1.360 | 39558.8 |
463 | 2022-11-05 05:41:02 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
462 | 2022-10-19 21:00:42 | offer | 1 | 28756 | 7 | 0.466 | 61708.2 |
461 | 2022-10-12 06:31:46 | offer | 1 | 28756 | 7 | 0.453 | 63479.0 |
460 | 2022-10-07 04:21:51 | offer | 1 | 28756 | 7 | 0.576 | 49923.6 |
459 | 2022-09-18 16:37:46 | offer | 1 | 28756 | 7 | 0.456 | 63061.4 |
458 | 2022-09-18 13:25:59 | offer | 2 | 53800 | 81 | 1.373 | 39184.3 |
457 | 2022-09-12 04:18:21 | offer | 1 | 28756 | 7 | 0.486 | 59168.7 |
456 | 2022-09-06 03:36:02 | offer | 1 | 28756 | 7 | 0.466 | 61708.2 |
455 | 2022-08-25 05:08:59 | offer | 1 | 28756 | 7 | 0.453 | 63479.0 |
454 | 2022-08-23 15:40:01 | offer | 2 | 53800 | 81 | 1.330 | 40451.1 |
453 | 2022-08-06 21:28:20 | offer | 1 | 28756 | 7 | 0.453 | 63479.0 |
452 | 2022-07-19 08:24:43 | offer | 3 | 83667 | 1102 | 3.313 | 25254.2 |
451 | 2022-07-15 06:14:15 | offer | 1 | 28756 | 7 | 0.423 | 67981.1 |
450 | 2022-07-11 09:23:38 | offer | 2 | 53800 | 81 | 1.406 | 38264.6 |
449 | 2022-07-05 00:16:05 | offer | 1 | 28756 | 7 | 0.483 | 59536.2 |
448 | 2022-07-03 08:23:28 | offer | 1 | 28756 | 7 | 0.453 | 63479.0 |
447 | 2022-06-25 22:08:31 | offer | 2 | 53800 | 81 | 1.533 | 35094.6 |
446 | 2022-06-25 19:50:48 | offer | 1 | 28756 | 7 | 0.483 | 59536.2 |
445 | 2022-06-25 06:06:19 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
444 | 2022-06-16 08:23:43 | offer | 1 | 28756 | 7 | 0.466 | 61708.2 |
443 | 2022-06-09 16:42:15 | offer | 2 | 53800 | 81 | 1.440 | 37361.1 |
442 | 2022-06-08 18:58:15 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
441 | 2022-06-07 05:19:53 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
440 | 2022-05-28 04:05:39 | offer | 1 | 28756 | 7 | 0.483 | 59536.2 |
439 | 2022-05-17 06:47:10 | offer | 1 | 28756 | 7 | 0.453 | 63479.0 |
438 | 2022-04-09 17:32:32 | offer | 1 | 28756 | 7 | 0.593 | 48492.4 |
437 | 2022-03-29 01:27:37 | offer | 1 | 28756 | 7 | 0.423 | 67981.1 |
436 | 2022-02-21 19:50:21 | offer | 1 | 28756 | 7 | 0.563 | 51076.4 |
435 | 2022-02-19 14:40:00 | offer | 1 | 28756 | 7 | 0.453 | 63479.0 |
434 | 2022-02-06 13:14:02 | offer | 1 | 28756 | 7 | 0.483 | 59536.2 |
433 | 2022-01-03 06:41:24 | offer | 1 | 28756 | 7 | 0.466 | 61708.2 |
432 | 2021-12-02 14:10:26 | offer | 1 | 28756 | 7 | 0.513 | 56054.6 |
431 | 2021-11-29 13:45:02 | offer | 1 | 28756 | 7 | 0.576 | 49923.6 |
430 | 2021-10-20 05:41:20 | offer | 1 | 28756 | 7 | 0.423 | 67981.1 |
429 | 2021-10-13 15:00:11 | offer | 1 | 28756 | 7 | 0.593 | 48492.4 |
428 | 2021-09-20 23:35:17 | offer | 1 | 28756 | 7 | 0.436 | 65954.1 |
427 | 2021-07-26 09:09:41 | offer | 3 | 83667 | 1102 | 4.500 | 18592.7 |