History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"basil"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
501 | 2024-04-27 16:13:30 | basil | 1 | 28756 | 8 | 0.783 | 36725.4 |
500 | 2024-04-08 04:46:08 | basil | 1 | 28756 | 8 | 0.593 | 48492.4 |
499 | 2024-04-02 22:00:39 | basil | 3 | 83667 | 1189 | 11.533 | 7254.6 |
498 | 2024-04-02 21:54:44 | basil | 3 | 83667 | 1189 | 3.610 | 23176.5 |
497 | 2024-04-02 21:54:42 | basil | 2 | 53800 | 87 | 1.623 | 33148.5 |
496 | 2024-04-02 21:54:39 | basil | 1 | 28756 | 8 | 0.596 | 48248.3 |
495 | 2024-03-31 06:38:58 | basil | 1 | 28756 | 8 | 0.530 | 54256.6 |
494 | 2024-03-30 20:08:48 | basil | 3 | 83667 | 1189 | 8.033 | 10415.4 |
493 | 2024-03-30 01:39:34 | basil | 3 | 83667 | 1189 | 9.330 | 8967.5 |
492 | 2024-03-30 01:39:35 | basil | 2 | 53800 | 87 | 4.076 | 13199.2 |
491 | 2024-03-29 10:11:41 | basil | 2 | 53800 | 87 | 1.796 | 29955.5 |
490 | 2024-03-29 10:11:21 | basil | 1 | 28756 | 8 | 1.013 | 28387.0 |
489 | 2024-03-29 10:10:59 | basil | 3 | 83667 | 1189 | 5.406 | 15476.7 |
488 | 2024-03-29 09:00:35 | basil | 3 | 83667 | 1189 | 11.410 | 7332.8 |
487 | 2024-03-29 09:00:34 | basil | 2 | 53800 | 87 | 2.670 | 20149.8 |
486 | 2024-03-29 08:59:14 | basil | 1 | 28756 | 8 | 1.686 | 17055.8 |
485 | 2024-03-25 04:22:31 | basil | 1 | 28756 | 8 | 0.483 | 59536.2 |
484 | 2024-03-11 08:22:00 | basil | 1 | 28756 | 8 | 0.576 | 49923.6 |
483 | 2024-03-03 20:48:48 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
482 | 2024-03-01 03:51:05 | basil | 1 | 28756 | 8 | 0.500 | 57512.0 |
481 | 2024-02-28 13:21:56 | basil | 2 | 53800 | 87 | 1.763 | 30516.2 |
480 | 2024-02-28 13:21:40 | basil | 3 | 83667 | 1189 | 5.703 | 14670.7 |
479 | 2024-02-28 07:40:56 | basil | 3 | 83667 | 1189 | 9.250 | 9045.1 |
478 | 2024-02-28 07:18:42 | basil | 3 | 83667 | 1189 | 14.953 | 5595.3 |
477 | 2024-02-28 07:18:48 | basil | 2 | 53800 | 87 | 3.673 | 14647.4 |
476 | 2024-02-28 07:18:15 | basil | 1 | 28756 | 8 | 1.033 | 27837.4 |
475 | 2024-02-09 15:45:14 | basil | 2 | 53800 | 87 | 1.813 | 29674.6 |
474 | 2024-02-02 20:06:23 | basil | 1 | 28756 | 8 | 0.533 | 53951.2 |
473 | 2024-01-29 03:59:41 | basil | 1 | 28756 | 8 | 0.483 | 59536.2 |
472 | 2024-01-09 12:46:07 | basil | 3 | 83667 | 1189 | 3.360 | 24900.9 |
471 | 2024-01-09 12:46:00 | basil | 2 | 53800 | 87 | 1.670 | 32215.6 |
470 | 2023-12-28 21:51:06 | basil | 1 | 28756 | 8 | 0.530 | 54256.6 |
469 | 2023-12-24 14:15:16 | basil | 3 | 83667 | 1189 | 3.903 | 21436.6 |
468 | 2023-12-24 14:15:12 | basil | 2 | 53800 | 87 | 1.670 | 32215.6 |
467 | 2023-12-23 12:35:37 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
466 | 2023-12-06 12:41:28 | basil | 1 | 28756 | 8 | 0.436 | 65954.1 |
465 | 2023-12-04 08:07:52 | basil | 2 | 53800 | 87 | 1.436 | 37465.2 |
464 | 2023-12-04 08:07:40 | basil | 3 | 83667 | 1189 | 3.440 | 24321.8 |
463 | 2023-11-12 10:35:47 | basil | 2 | 53800 | 87 | 1.393 | 38621.7 |
462 | 2023-11-12 07:36:56 | basil | 1 | 28756 | 8 | 0.440 | 65354.5 |
461 | 2023-11-10 18:52:05 | basil | 1 | 28756 | 8 | 1.080 | 26625.9 |
460 | 2023-10-31 23:05:35 | basil | 1 | 28756 | 8 | 0.530 | 54256.6 |
459 | 2023-10-20 13:42:33 | basil | 1 | 28756 | 8 | 0.593 | 48492.4 |
458 | 2023-10-20 07:28:38 | basil | 1 | 28756 | 8 | 0.923 | 31154.9 |
457 | 2023-10-17 06:45:10 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
456 | 2023-10-14 14:18:44 | basil | 1 | 28756 | 8 | 0.530 | 54256.6 |
455 | 2023-10-03 16:29:53 | basil | 1 | 28756 | 8 | 0.700 | 41080.0 |
454 | 2023-09-23 19:03:01 | basil | 1 | 28756 | 8 | 0.516 | 55728.7 |
453 | 2023-09-13 17:12:50 | basil | 1 | 28756 | 8 | 0.500 | 57512.0 |
452 | 2023-09-11 10:37:02 | basil | 1 | 28756 | 8 | 0.500 | 57512.0 |
451 | 2023-08-14 08:45:25 | basil | 2 | 53800 | 87 | 1.563 | 34421.0 |
450 | 2023-08-12 15:50:10 | basil | 1 | 28756 | 8 | 0.500 | 57512.0 |
449 | 2023-07-16 11:40:55 | basil | 1 | 28756 | 8 | 0.516 | 55728.7 |
448 | 2023-06-06 11:50:38 | basil | 1 | 28756 | 8 | 0.486 | 59168.7 |
447 | 2023-06-03 05:23:33 | basil | 1 | 28756 | 8 | 0.393 | 73170.5 |
446 | 2023-05-10 02:24:53 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
445 | 2023-04-23 10:21:14 | basil | 2 | 53800 | 87 | 1.390 | 38705.0 |
444 | 2023-03-26 22:26:35 | basil | 1 | 28756 | 8 | 0.500 | 57512.0 |
443 | 2023-03-05 15:52:19 | basil | 1 | 28756 | 8 | 0.436 | 65954.1 |
442 | 2023-02-21 18:36:31 | basil | 1 | 28756 | 8 | 0.436 | 65954.1 |
441 | 2023-01-28 08:08:07 | basil | 2 | 53800 | 87 | 1.373 | 39184.3 |
440 | 2022-12-28 15:40:45 | basil | 1 | 28756 | 8 | 0.440 | 65354.5 |
439 | 2022-11-18 23:13:33 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
438 | 2022-11-10 08:25:25 | basil | 2 | 53800 | 87 | 1.420 | 37887.3 |
437 | 2022-09-16 18:27:24 | basil | 1 | 28756 | 8 | 0.436 | 65954.1 |
436 | 2022-08-31 13:19:41 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
435 | 2022-08-18 12:25:13 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
434 | 2022-08-15 14:52:38 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
433 | 2022-08-06 04:18:29 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
432 | 2022-07-18 09:22:37 | basil | 1 | 28756 | 8 | 0.470 | 61183.0 |
431 | 2022-07-02 09:48:52 | basil | 3 | 83667 | 1189 | 3.310 | 25277.0 |
430 | 2022-06-26 02:29:16 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
429 | 2022-06-09 01:45:19 | basil | 2 | 53800 | 87 | 1.423 | 37807.4 |
428 | 2022-05-12 22:23:53 | basil | 1 | 28756 | 8 | 0.716 | 40162.0 |
427 | 2022-04-23 04:00:34 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
426 | 2022-02-08 05:58:40 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
425 | 2022-01-18 22:05:26 | basil | 1 | 28756 | 8 | 0.500 | 57512.0 |
424 | 2021-11-14 15:02:22 | basil | 1 | 28756 | 8 | 0.500 | 57512.0 |
423 | 2021-11-07 07:33:03 | basil | 1 | 28756 | 8 | 0.513 | 56054.6 |
422 | 2021-10-04 11:26:52 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
421 | 2021-09-04 09:26:49 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
420 | 2021-08-17 20:09:22 | basil | 1 | 28756 | 8 | 0.436 | 65954.1 |
419 | 2021-08-04 05:37:48 | basil | 1 | 28756 | 8 | 0.466 | 61708.2 |
418 | 2021-05-03 12:37:19 | basil | 1 | 28756 | 8 | 0.546 | 52666.7 |
417 | 2021-04-29 21:01:14 | basil | 1 | 28756 | 8 | 0.516 | 55728.7 |
416 | 2021-01-25 10:11:01 | basil | 1 | 28756 | 8 | 0.466 | 61708.2 |
415 | 2020-10-24 06:03:08 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
414 | 2020-10-22 16:25:29 | basil | 1 | 28756 | 8 | 1.030 | 27918.4 |
413 | 2020-10-12 23:24:27 | basil | 1 | 28756 | 8 | 0.466 | 61708.2 |
412 | 2020-09-20 21:18:59 | basil | 1 | 28756 | 8 | 0.516 | 55728.7 |
411 | 2020-09-10 01:14:54 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
410 | 2020-08-24 20:25:25 | basil | 1 | 28756 | 8 | 0.533 | 53951.2 |
409 | 2020-07-21 09:02:27 | basil | 1 | 28756 | 8 | 0.466 | 61708.2 |
408 | 2020-07-18 01:06:36 | basil | 1 | 28756 | 8 | 0.483 | 59536.2 |
407 | 2020-04-16 05:54:40 | basil | 1 | 28756 | 8 | 0.453 | 63479.0 |
406 | 2020-03-29 23:12:25 | basil | 1 | 28756 | 8 | 0.640 | 44931.3 |
405 | 2020-03-24 21:28:23 | basil | 1 | 28756 | 8 | 1.093 | 26309.2 |
404 | 2020-03-24 16:25:22 | basil | 1 | 28756 | 8 | 0.563 | 51076.4 |
403 | 2020-03-23 11:45:48 | basil | 1 | 28756 | 8 | 0.533 | 53951.2 |
402 | 2020-03-22 07:58:38 | basil | 1 | 28756 | 8 | 0.516 | 55728.7 |