History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ralph"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
507 | 2024-04-17 00:00:14 | ralph | 1 | 28756 | 2 | 0.500 | 57512.0 |
506 | 2024-04-06 10:57:20 | ralph | 1 | 28756 | 2 | 1.690 | 17015.4 |
505 | 2024-03-31 16:30:00 | ralph | 1 | 28756 | 2 | 0.576 | 49923.6 |
504 | 2024-03-29 23:51:59 | ralph | 1 | 28756 | 2 | 0.533 | 53951.2 |
503 | 2024-03-29 02:09:48 | ralph | 1 | 28756 | 2 | 0.500 | 57512.0 |
502 | 2024-03-07 06:21:13 | ralph | 3 | 83667 | 812 | 4.920 | 17005.5 |
501 | 2024-03-07 06:21:14 | ralph | 2 | 53800 | 41 | 4.063 | 13241.4 |
500 | 2024-03-07 05:30:17 | ralph | 1 | 28756 | 2 | 0.533 | 53951.2 |
499 | 2024-03-01 12:33:54 | ralph | 1 | 28756 | 2 | 0.513 | 56054.6 |
498 | 2024-02-28 19:51:11 | ralph | 1 | 28756 | 2 | 1.076 | 26724.9 |
497 | 2024-02-22 01:02:01 | ralph | 3 | 83667 | 812 | 8.686 | 9632.4 |
496 | 2024-02-20 22:03:06 | ralph | 3 | 83667 | 812 | 4.406 | 18989.3 |
495 | 2024-02-04 00:09:15 | ralph | 2 | 53800 | 41 | 4.233 | 12709.7 |
494 | 2024-02-04 00:09:11 | ralph | 3 | 83667 | 812 | 3.420 | 24464.0 |
493 | 2024-02-04 00:08:55 | ralph | 1 | 28756 | 2 | 0.500 | 57512.0 |
492 | 2024-01-29 05:47:43 | ralph | 1 | 28756 | 2 | 0.456 | 63061.4 |
491 | 2024-01-29 04:40:53 | ralph | 1 | 28756 | 2 | 0.436 | 65954.1 |
490 | 2024-01-22 02:34:31 | ralph | 3 | 83667 | 812 | 3.436 | 24350.1 |
489 | 2024-01-19 16:36:30 | ralph | 3 | 83667 | 812 | 4.406 | 18989.3 |
488 | 2024-01-19 16:36:27 | ralph | 2 | 53800 | 41 | 1.686 | 31909.8 |
487 | 2024-01-16 08:40:55 | ralph | 2 | 53800 | 41 | 1.700 | 31647.1 |
486 | 2024-01-16 08:40:52 | ralph | 3 | 83667 | 812 | 4.050 | 20658.5 |
485 | 2024-01-11 05:05:16 | ralph | 2 | 53800 | 41 | 1.610 | 33416.1 |
484 | 2023-12-21 16:03:04 | ralph | 1 | 28756 | 2 | 0.456 | 63061.4 |
483 | 2023-11-18 08:31:15 | ralph | 1 | 28756 | 2 | 0.486 | 59168.7 |
482 | 2023-11-18 00:24:53 | ralph | 1 | 28756 | 2 | 0.516 | 55728.7 |
481 | 2023-11-08 02:13:23 | ralph | 1 | 28756 | 2 | 0.533 | 53951.2 |
480 | 2023-11-04 21:43:16 | ralph | 1 | 28756 | 2 | 0.486 | 59168.7 |
479 | 2023-11-04 09:26:10 | ralph | 1 | 28756 | 2 | 0.453 | 63479.0 |
478 | 2023-11-03 17:40:57 | ralph | 1 | 28756 | 2 | 0.453 | 63479.0 |
477 | 2023-10-20 08:36:29 | ralph | 2 | 53800 | 41 | 1.420 | 37887.3 |
476 | 2023-10-20 08:08:29 | ralph | 1 | 28756 | 2 | 0.453 | 63479.0 |
475 | 2023-10-19 08:19:14 | ralph | 2 | 53800 | 41 | 1.546 | 34799.5 |
474 | 2023-10-11 16:30:50 | ralph | 1 | 28756 | 2 | 0.513 | 56054.6 |
473 | 2023-10-08 07:48:47 | ralph | 1 | 28756 | 2 | 0.513 | 56054.6 |
472 | 2023-10-05 19:34:44 | ralph | 1 | 28756 | 2 | 0.533 | 53951.2 |
471 | 2023-10-01 03:38:16 | ralph | 1 | 28756 | 2 | 0.453 | 63479.0 |
470 | 2023-09-27 08:37:16 | ralph | 1 | 28756 | 2 | 0.500 | 57512.0 |
469 | 2023-09-15 11:54:07 | ralph | 1 | 28756 | 2 | 0.466 | 61708.2 |
468 | 2023-08-05 13:32:24 | ralph | 1 | 28756 | 2 | 0.500 | 57512.0 |
467 | 2023-07-29 10:37:19 | ralph | 2 | 53800 | 41 | 1.483 | 36277.8 |
466 | 2023-07-11 17:03:40 | ralph | 3 | 83667 | 812 | 3.936 | 21256.9 |
465 | 2023-04-28 21:22:33 | ralph | 1 | 28756 | 2 | 0.470 | 61183.0 |
464 | 2023-04-05 03:01:26 | ralph | 2 | 53800 | 41 | 1.530 | 35163.4 |
463 | 2023-03-31 12:23:46 | ralph | 3 | 83667 | 812 | 3.703 | 22594.4 |
462 | 2023-03-27 18:49:36 | ralph | 1 | 28756 | 2 | 0.483 | 59536.2 |
461 | 2023-02-20 21:09:08 | ralph | 1 | 28756 | 2 | 0.436 | 65954.1 |
460 | 2022-12-31 06:13:25 | ralph | 2 | 53800 | 41 | 1.590 | 33836.5 |
459 | 2022-12-17 00:08:15 | ralph | 1 | 28756 | 2 | 0.436 | 65954.1 |
458 | 2022-09-02 09:00:04 | ralph | 2 | 53800 | 41 | 1.500 | 35866.7 |
457 | 2022-08-31 19:34:26 | ralph | 1 | 28756 | 2 | 0.466 | 61708.2 |
456 | 2022-08-24 18:06:55 | ralph | 1 | 28756 | 2 | 0.453 | 63479.0 |
455 | 2022-04-14 03:14:54 | ralph | 1 | 28756 | 2 | 0.936 | 30722.2 |
454 | 2022-04-11 21:54:57 | ralph | 1 | 28756 | 2 | 0.653 | 44036.8 |
453 | 2022-01-18 19:58:20 | ralph | 1 | 28756 | 2 | 0.466 | 61708.2 |
452 | 2021-05-13 12:19:52 | ralph | 1 | 28756 | 2 | 0.466 | 61708.2 |
451 | 2021-02-18 21:38:24 | ralph | 1 | 28756 | 2 | 0.516 | 55728.7 |
450 | 2021-01-25 09:50:55 | ralph | 1 | 28756 | 2 | 0.453 | 63479.0 |
449 | 2020-11-06 11:02:49 | ralph | 1 | 28756 | 2 | 0.516 | 55728.7 |
448 | 2020-10-16 14:08:03 | ralph | 1 | 28756 | 2 | 0.436 | 65954.1 |
447 | 2020-10-11 00:10:42 | ralph | 1 | 28756 | 2 | 0.453 | 63479.0 |
446 | 2020-09-30 00:09:41 | ralph | 1 | 28756 | 2 | 0.440 | 65354.5 |
445 | 2020-07-18 09:17:25 | ralph | 1 | 28756 | 2 | 0.483 | 59536.2 |
444 | 2020-05-14 00:47:31 | ralph | 3 | 83667 | 812 | 3.500 | 23904.9 |
443 | 2020-03-29 21:42:51 | ralph | 3 | 83667 | 812 | 4.170 | 20064.0 |
442 | 2020-03-28 16:39:02 | ralph | 3 | 83667 | 812 | 4.936 | 16950.4 |
441 | 2020-03-28 08:15:47 | ralph | 3 | 83667 | 812 | 3.640 | 22985.4 |
440 | 2020-03-28 01:03:52 | ralph | 3 | 83667 | 812 | 7.190 | 11636.6 |
439 | 2020-03-27 16:47:05 | ralph | 3 | 83667 | 812 | 4.250 | 19686.4 |
438 | 2020-03-26 06:13:14 | ralph | 1 | 28756 | 2 | 0.530 | 54256.6 |
437 | 2020-03-25 15:42:41 | ralph | 1 | 28756 | 2 | 0.500 | 57512.0 |
436 | 2020-03-23 18:34:01 | ralph | 1 | 28756 | 2 | 0.513 | 56054.6 |
435 | 2020-03-22 06:33:33 | ralph | 1 | 28756 | 2 | 0.576 | 49923.6 |
434 | 2020-03-22 05:19:23 | ralph | 1 | 28756 | 2 | 1.373 | 20943.9 |
433 | 2020-03-21 23:07:57 | ralph | 3 | 83667 | 812 | 4.250 | 19686.4 |
432 | 2020-03-21 11:24:05 | ralph | 1 | 28756 | 2 | 0.533 | 53951.2 |
431 | 2020-03-20 10:27:06 | ralph | 3 | 83667 | 812 | 4.250 | 19686.4 |
430 | 2020-03-19 23:40:29 | ralph | 3 | 83667 | 812 | 8.046 | 10398.6 |
429 | 2020-03-19 22:52:30 | ralph | 3 | 83667 | 812 | 8.546 | 9790.2 |
428 | 2020-03-18 18:17:33 | ralph | 3 | 83667 | 812 | 4.003 | 20901.1 |
427 | 2020-03-17 23:40:25 | ralph | 1 | 28756 | 2 | 0.500 | 57512.0 |
426 | 2020-03-15 14:11:23 | ralph | 3 | 83667 | 812 | 3.580 | 23370.7 |
425 | 2020-03-14 08:30:02 | ralph | 1 | 28756 | 2 | 0.483 | 59536.2 |
424 | 2020-03-06 09:38:18 | ralph | 3 | 83667 | 812 | 3.953 | 21165.4 |
423 | 2020-03-05 06:53:47 | ralph | 3 | 83667 | 812 | 3.610 | 23176.5 |
422 | 2020-03-01 02:24:21 | ralph | 1 | 28756 | 2 | 0.533 | 53951.2 |
421 | 2020-03-01 00:37:23 | ralph | 1 | 28756 | 2 | 0.546 | 52666.7 |
420 | 2020-02-28 15:21:49 | ralph | 3 | 83667 | 812 | 9.110 | 9184.1 |
419 | 2020-02-27 16:45:28 | ralph | 1 | 28756 | 2 | 0.513 | 56054.6 |
418 | 2020-02-26 02:59:17 | ralph | 1 | 28756 | 2 | 0.903 | 31845.0 |
417 | 2020-02-23 16:51:06 | ralph | 3 | 83667 | 812 | 4.703 | 17790.1 |
416 | 2020-02-23 15:46:06 | ralph | 1 | 28756 | 2 | 0.580 | 49579.3 |
415 | 2020-02-23 05:24:12 | ralph | 3 | 83667 | 812 | 4.953 | 16892.2 |
414 | 2020-02-22 15:03:36 | ralph | 3 | 83667 | 812 | 4.860 | 17215.4 |
413 | 2020-02-20 23:38:59 | ralph | 3 | 83667 | 812 | 3.936 | 21256.9 |
412 | 2020-02-17 23:02:08 | ralph | 3 | 83667 | 812 | 4.343 | 19264.8 |
411 | 2020-02-17 17:03:51 | ralph | 3 | 83667 | 812 | 10.046 | 8328.4 |
410 | 2020-02-17 04:11:05 | ralph | 3 | 83667 | 812 | 4.093 | 20441.5 |
409 | 2020-02-16 17:34:27 | ralph | 3 | 83667 | 812 | 4.750 | 17614.1 |
408 | 2020-02-15 12:53:02 | ralph | 3 | 83667 | 812 | 4.640 | 18031.7 |