History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bacca"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
510 | 2024-05-09 23:49:29 | bacca | 1 | 28756 | 3 | 0.533 | 53951.2 |
509 | 2024-05-08 03:52:04 | bacca | 1 | 28756 | 3 | 0.580 | 49579.3 |
508 | 2024-05-07 16:12:57 | bacca | 1 | 28756 | 3 | 2.173 | 13233.3 |
507 | 2024-05-07 00:50:27 | bacca | 1 | 28756 | 3 | 0.576 | 49923.6 |
506 | 2024-05-06 16:36:04 | bacca | 3 | 83667 | 698 | 7.250 | 11540.3 |
505 | 2024-05-06 16:36:08 | bacca | 2 | 53800 | 36 | 1.983 | 27130.6 |
504 | 2024-05-06 16:35:48 | bacca | 1 | 28756 | 3 | 0.516 | 55728.7 |
503 | 2024-05-06 16:35:43 | bacca | 2 | 53800 | 36 | 1.640 | 32804.9 |
502 | 2024-05-06 16:35:39 | bacca | 1 | 28756 | 3 | 0.453 | 63479.0 |
501 | 2024-05-01 23:14:42 | bacca | 1 | 28756 | 3 | 1.190 | 24164.7 |
500 | 2024-05-01 00:16:55 | bacca | 1 | 28756 | 3 | 0.533 | 53951.2 |
499 | 2024-04-30 08:43:14 | bacca | 3 | 83667 | 698 | 8.720 | 9594.8 |
498 | 2024-04-30 01:20:35 | bacca | 3 | 83667 | 698 | 8.530 | 9808.6 |
497 | 2024-04-30 01:20:37 | bacca | 2 | 53800 | 36 | 4.513 | 11921.1 |
496 | 2024-04-30 01:19:38 | bacca | 1 | 28756 | 3 | 1.436 | 20025.1 |
495 | 2024-04-26 02:14:26 | bacca | 2 | 53800 | 36 | 1.393 | 38621.7 |
494 | 2024-04-24 10:29:58 | bacca | 1 | 28756 | 3 | 1.156 | 24875.4 |
493 | 2024-04-06 12:46:59 | bacca | 3 | 83667 | 698 | 10.940 | 7647.8 |
492 | 2024-04-06 12:47:07 | bacca | 2 | 53800 | 36 | 1.843 | 29191.5 |
491 | 2024-04-06 12:46:54 | bacca | 1 | 28756 | 3 | 1.593 | 18051.5 |
490 | 2024-03-31 16:12:58 | bacca | 1 | 28756 | 3 | 0.546 | 52666.7 |
489 | 2024-03-31 04:16:35 | bacca | 2 | 53800 | 36 | 1.626 | 33087.3 |
488 | 2024-03-31 04:16:09 | bacca | 3 | 83667 | 698 | 6.110 | 13693.5 |
487 | 2024-03-30 04:21:40 | bacca | 2 | 53800 | 36 | 1.890 | 28465.6 |
486 | 2024-03-30 04:21:15 | bacca | 3 | 83667 | 698 | 4.376 | 19119.5 |
485 | 2024-03-29 23:56:30 | bacca | 2 | 53800 | 36 | 4.860 | 11070.0 |
484 | 2024-03-29 23:56:25 | bacca | 3 | 83667 | 698 | 4.830 | 17322.4 |
483 | 2024-03-28 20:06:23 | bacca | 1 | 28756 | 3 | 0.530 | 54256.6 |
482 | 2024-03-28 09:21:02 | bacca | 1 | 28756 | 3 | 0.530 | 54256.6 |
481 | 2024-03-13 03:04:01 | bacca | 2 | 53800 | 36 | 1.640 | 32804.9 |
480 | 2024-03-07 06:13:40 | bacca | 1 | 28756 | 3 | 1.156 | 24875.4 |
479 | 2024-03-01 12:17:10 | bacca | 1 | 28756 | 3 | 0.513 | 56054.6 |
478 | 2024-02-29 11:01:29 | bacca | 1 | 28756 | 3 | 1.203 | 23903.6 |
477 | 2024-02-25 19:18:11 | bacca | 1 | 28756 | 3 | 0.470 | 61183.0 |
476 | 2024-02-03 23:05:55 | bacca | 1 | 28756 | 3 | 0.513 | 56054.6 |
475 | 2024-01-29 08:49:17 | bacca | 2 | 53800 | 36 | 1.516 | 35488.1 |
474 | 2024-01-29 06:15:27 | bacca | 1 | 28756 | 3 | 0.983 | 29253.3 |
473 | 2024-01-26 05:57:21 | bacca | 1 | 28756 | 3 | 0.513 | 56054.6 |
472 | 2024-01-22 06:35:03 | bacca | 1 | 28756 | 3 | 0.436 | 65954.1 |
471 | 2024-01-21 02:58:37 | bacca | 1 | 28756 | 3 | 0.440 | 65354.5 |
470 | 2024-01-20 21:12:22 | bacca | 1 | 28756 | 3 | 0.436 | 65954.1 |
469 | 2023-12-17 22:58:24 | bacca | 2 | 53800 | 36 | 1.390 | 38705.0 |
468 | 2023-12-09 06:36:23 | bacca | 2 | 53800 | 36 | 1.610 | 33416.1 |
467 | 2023-12-08 10:11:21 | bacca | 3 | 83667 | 698 | 4.140 | 20209.4 |
466 | 2023-11-30 21:53:35 | bacca | 1 | 28756 | 3 | 0.533 | 53951.2 |
465 | 2023-11-30 15:47:40 | bacca | 2 | 53800 | 36 | 1.436 | 37465.2 |
464 | 2023-11-30 15:47:37 | bacca | 3 | 83667 | 698 | 3.453 | 24230.2 |
463 | 2023-11-18 11:11:11 | bacca | 1 | 28756 | 3 | 0.436 | 65954.1 |
462 | 2023-11-11 21:39:33 | bacca | 1 | 28756 | 3 | 0.453 | 63479.0 |
461 | 2023-11-11 17:40:41 | bacca | 1 | 28756 | 3 | 0.470 | 61183.0 |
460 | 2023-11-10 18:06:21 | bacca | 3 | 83667 | 698 | 4.030 | 20761.0 |
459 | 2023-11-10 18:06:23 | bacca | 2 | 53800 | 36 | 1.720 | 31279.1 |
458 | 2023-11-08 01:47:36 | bacca | 1 | 28756 | 3 | 0.516 | 55728.7 |
457 | 2023-10-31 23:38:10 | bacca | 3 | 83667 | 698 | 3.920 | 21343.6 |
456 | 2023-10-31 16:22:02 | bacca | 3 | 83667 | 698 | 3.576 | 23396.8 |
455 | 2023-10-31 16:21:58 | bacca | 2 | 53800 | 36 | 1.673 | 32157.8 |
454 | 2023-10-27 17:12:55 | bacca | 1 | 28756 | 3 | 1.096 | 26237.2 |
453 | 2023-10-20 20:25:55 | bacca | 1 | 28756 | 3 | 0.456 | 63061.4 |
452 | 2023-10-18 04:43:57 | bacca | 1 | 28756 | 3 | 0.500 | 57512.0 |
451 | 2023-10-13 15:36:11 | bacca | 1 | 28756 | 3 | 0.500 | 57512.0 |
450 | 2023-10-11 04:05:06 | bacca | 1 | 28756 | 3 | 0.453 | 63479.0 |
449 | 2023-10-04 09:21:16 | bacca | 1 | 28756 | 3 | 0.483 | 59536.2 |
448 | 2023-09-25 10:17:52 | bacca | 1 | 28756 | 3 | 0.516 | 55728.7 |
447 | 2023-09-24 02:41:59 | bacca | 2 | 53800 | 36 | 1.546 | 34799.5 |
446 | 2023-09-22 09:34:23 | bacca | 1 | 28756 | 3 | 0.500 | 57512.0 |
445 | 2023-09-18 01:14:17 | bacca | 2 | 53800 | 36 | 1.376 | 39098.8 |
444 | 2023-09-05 22:50:27 | bacca | 1 | 28756 | 3 | 0.470 | 61183.0 |
443 | 2023-07-11 21:04:00 | bacca | 2 | 53800 | 36 | 1.656 | 32487.9 |
442 | 2023-07-01 10:41:46 | bacca | 1 | 28756 | 3 | 0.453 | 63479.0 |
441 | 2023-06-18 17:41:32 | bacca | 2 | 53800 | 36 | 1.390 | 38705.0 |
440 | 2023-06-10 04:41:06 | bacca | 1 | 28756 | 3 | 0.500 | 57512.0 |
439 | 2023-03-31 13:47:14 | bacca | 2 | 53800 | 36 | 1.403 | 38346.4 |
438 | 2023-03-29 15:50:32 | bacca | 1 | 28756 | 3 | 0.436 | 65954.1 |
437 | 2023-03-26 22:14:07 | bacca | 1 | 28756 | 3 | 0.436 | 65954.1 |
436 | 2023-03-25 01:02:30 | bacca | 1 | 28756 | 3 | 0.453 | 63479.0 |
435 | 2023-03-16 15:00:21 | bacca | 2 | 53800 | 36 | 1.360 | 39558.8 |
434 | 2023-01-12 15:04:47 | bacca | 1 | 28756 | 3 | 0.483 | 59536.2 |
433 | 2022-12-18 03:26:57 | bacca | 2 | 53800 | 36 | 1.593 | 33772.8 |
432 | 2022-12-16 14:26:44 | bacca | 1 | 28756 | 3 | 0.453 | 63479.0 |
431 | 2022-11-25 04:11:06 | bacca | 1 | 28756 | 3 | 0.470 | 61183.0 |
430 | 2022-10-29 15:40:48 | bacca | 1 | 28756 | 3 | 0.486 | 59168.7 |
429 | 2022-08-30 06:04:39 | bacca | 1 | 28756 | 3 | 0.483 | 59536.2 |
428 | 2022-08-27 19:29:03 | bacca | 1 | 28756 | 3 | 0.500 | 57512.0 |
427 | 2022-08-12 00:50:29 | bacca | 2 | 53800 | 36 | 1.373 | 39184.3 |
426 | 2022-08-09 14:23:11 | bacca | 2 | 53800 | 36 | 1.373 | 39184.3 |
425 | 2022-06-17 14:21:50 | bacca | 1 | 28756 | 3 | 0.453 | 63479.0 |
424 | 2022-05-14 05:01:24 | bacca | 1 | 28756 | 3 | 0.436 | 65954.1 |
423 | 2022-03-08 10:49:35 | bacca | 2 | 53800 | 36 | 1.826 | 29463.3 |
422 | 2022-02-25 00:08:35 | bacca | 1 | 28756 | 3 | 0.500 | 57512.0 |
421 | 2022-02-06 00:39:58 | bacca | 1 | 28756 | 3 | 0.453 | 63479.0 |
420 | 2021-12-14 16:44:22 | bacca | 2 | 53800 | 36 | 1.580 | 34050.6 |
419 | 2021-12-09 20:50:32 | bacca | 1 | 28756 | 3 | 0.453 | 63479.0 |
418 | 2021-11-01 18:39:34 | bacca | 1 | 28756 | 3 | 0.546 | 52666.7 |
417 | 2021-10-19 04:50:28 | bacca | 1 | 28756 | 3 | 0.456 | 63061.4 |
416 | 2021-09-13 09:45:40 | bacca | 1 | 28756 | 3 | 0.453 | 63479.0 |
415 | 2021-08-22 11:10:03 | bacca | 1 | 28756 | 3 | 0.436 | 65954.1 |
414 | 2021-08-01 23:20:27 | bacca | 1 | 28756 | 3 | 0.453 | 63479.0 |
413 | 2021-06-14 04:15:09 | bacca | 1 | 28756 | 3 | 0.440 | 65354.5 |
412 | 2021-05-27 15:28:27 | bacca | 2 | 53800 | 36 | 1.610 | 33416.1 |
411 | 2021-05-01 22:19:05 | bacca | 2 | 53800 | 36 | 1.406 | 38264.6 |