History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"profs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
516 | 2024-05-06 05:46:36 | profs | 2 | 53800 | 148 | 1.593 | 33772.8 |
515 | 2024-04-29 20:35:27 | profs | 1 | 28756 | 12 | 0.546 | 52666.7 |
514 | 2024-04-21 01:10:56 | profs | 1 | 28756 | 12 | 1.343 | 21411.8 |
513 | 2024-04-14 09:32:30 | profs | 2 | 53800 | 148 | 5.700 | 9438.6 |
512 | 2024-04-12 22:27:41 | profs | 2 | 53800 | 148 | 1.906 | 28226.7 |
511 | 2024-04-12 22:27:37 | profs | 1 | 28756 | 12 | 0.826 | 34813.6 |
510 | 2024-04-12 22:27:29 | profs | 2 | 53800 | 148 | 2.033 | 26463.4 |
509 | 2024-04-12 22:27:25 | profs | 1 | 28756 | 12 | 0.656 | 43835.4 |
508 | 2024-04-12 15:38:19 | profs | 1 | 28756 | 12 | 1.330 | 21621.1 |
507 | 2024-04-12 15:24:06 | profs | 1 | 28756 | 12 | 0.576 | 49923.6 |
506 | 2024-04-09 19:55:01 | profs | 1 | 28756 | 12 | 0.860 | 33437.2 |
505 | 2024-04-09 17:54:46 | profs | 1 | 28756 | 12 | 0.513 | 56054.6 |
504 | 2024-04-09 10:41:20 | profs | 1 | 28756 | 12 | 0.530 | 54256.6 |
503 | 2024-04-03 04:46:16 | profs | 2 | 53800 | 148 | 1.970 | 27309.6 |
502 | 2024-04-03 02:36:15 | profs | 1 | 28756 | 12 | 1.750 | 16432.0 |
501 | 2024-03-31 15:43:17 | profs | 1 | 28756 | 12 | 0.513 | 56054.6 |
500 | 2024-03-18 13:34:17 | profs | 1 | 28756 | 12 | 0.860 | 33437.2 |
499 | 2024-03-13 04:33:18 | profs | 2 | 53800 | 148 | 4.813 | 11178.1 |
498 | 2024-03-13 04:32:59 | profs | 1 | 28756 | 12 | 1.783 | 16127.9 |
497 | 2024-03-13 04:32:51 | profs | 2 | 53800 | 148 | 4.546 | 11834.6 |
496 | 2024-03-13 04:29:09 | profs | 1 | 28756 | 12 | 1.440 | 19969.4 |
495 | 2024-03-03 23:30:51 | profs | 2 | 53800 | 148 | 4.906 | 10966.2 |
494 | 2024-03-03 22:14:39 | profs | 1 | 28756 | 12 | 0.423 | 67981.1 |
493 | 2024-02-25 18:32:18 | profs | 1 | 28756 | 12 | 1.576 | 18246.2 |
492 | 2024-02-11 18:16:31 | profs | 1 | 28756 | 12 | 1.330 | 21621.1 |
491 | 2024-01-26 00:46:13 | profs | 1 | 28756 | 12 | 0.500 | 57512.0 |
490 | 2024-01-05 02:22:17 | profs | 1 | 28756 | 12 | 0.483 | 59536.2 |
489 | 2024-01-04 00:12:16 | profs | 2 | 53800 | 148 | 1.673 | 32157.8 |
488 | 2023-12-24 10:07:12 | profs | 2 | 53800 | 148 | 1.390 | 38705.0 |
487 | 2023-12-23 02:56:06 | profs | 1 | 28756 | 12 | 0.440 | 65354.5 |
486 | 2023-12-16 08:43:30 | profs | 1 | 28756 | 12 | 0.516 | 55728.7 |
485 | 2023-11-24 08:57:35 | profs | 2 | 53800 | 148 | 1.596 | 33709.3 |
484 | 2023-11-21 22:51:30 | profs | 1 | 28756 | 12 | 0.483 | 59536.2 |
483 | 2023-11-13 23:17:38 | profs | 1 | 28756 | 12 | 0.500 | 57512.0 |
482 | 2023-10-27 08:12:50 | profs | 1 | 28756 | 12 | 0.453 | 63479.0 |
481 | 2023-10-20 07:03:58 | profs | 1 | 28756 | 12 | 0.560 | 51350.0 |
480 | 2023-10-16 19:17:45 | profs | 2 | 53800 | 148 | 1.423 | 37807.4 |
479 | 2023-10-16 18:09:26 | profs | 1 | 28756 | 12 | 0.453 | 63479.0 |
478 | 2023-10-14 23:08:47 | profs | 1 | 28756 | 12 | 0.436 | 65954.1 |
477 | 2023-10-08 18:47:03 | profs | 1 | 28756 | 12 | 0.436 | 65954.1 |
476 | 2023-10-03 17:14:11 | profs | 1 | 28756 | 12 | 0.546 | 52666.7 |
475 | 2023-09-29 04:47:06 | profs | 1 | 28756 | 12 | 0.453 | 63479.0 |
474 | 2023-09-24 17:40:38 | profs | 2 | 53800 | 148 | 1.546 | 34799.5 |
473 | 2023-08-20 11:54:51 | profs | 1 | 28756 | 12 | 0.450 | 63902.2 |
472 | 2023-07-31 22:40:18 | profs | 1 | 28756 | 12 | 0.453 | 63479.0 |
471 | 2023-07-02 06:26:08 | profs | 2 | 53800 | 148 | 1.703 | 31591.3 |
470 | 2023-04-28 22:54:50 | profs | 1 | 28756 | 12 | 0.500 | 57512.0 |
469 | 2023-04-25 09:36:42 | profs | 1 | 28756 | 12 | 0.436 | 65954.1 |
468 | 2023-04-21 17:09:06 | profs | 1 | 28756 | 12 | 0.436 | 65954.1 |
467 | 2023-03-20 09:58:42 | profs | 2 | 53800 | 148 | 1.356 | 39675.5 |
466 | 2023-02-20 05:22:26 | profs | 1 | 28756 | 12 | 0.440 | 65354.5 |
465 | 2022-12-21 23:07:47 | profs | 2 | 53800 | 148 | 1.343 | 40059.6 |
464 | 2022-12-18 06:04:25 | profs | 1 | 28756 | 12 | 0.436 | 65954.1 |
463 | 2022-12-16 23:53:05 | profs | 1 | 28756 | 12 | 0.440 | 65354.5 |
462 | 2022-09-04 16:33:06 | profs | 1 | 28756 | 12 | 0.440 | 65354.5 |
461 | 2022-08-31 23:56:09 | profs | 1 | 28756 | 12 | 0.486 | 59168.7 |
460 | 2022-08-18 19:57:23 | profs | 2 | 53800 | 148 | 1.356 | 39675.5 |
459 | 2022-08-18 01:07:59 | profs | 1 | 28756 | 12 | 0.440 | 65354.5 |
458 | 2022-04-18 12:32:15 | profs | 1 | 28756 | 12 | 0.610 | 47141.0 |
457 | 2022-04-17 14:53:54 | profs | 1 | 28756 | 12 | 0.483 | 59536.2 |
456 | 2022-03-12 12:29:34 | profs | 2 | 53800 | 148 | 1.516 | 35488.1 |
455 | 2022-01-12 05:18:10 | profs | 1 | 28756 | 12 | 0.453 | 63479.0 |
454 | 2021-12-26 08:52:25 | profs | 1 | 28756 | 12 | 0.513 | 56054.6 |
453 | 2021-11-24 15:23:15 | profs | 1 | 28756 | 12 | 0.533 | 53951.2 |
452 | 2021-11-21 21:27:46 | profs | 1 | 28756 | 12 | 0.450 | 63902.2 |
451 | 2021-10-30 20:36:03 | profs | 1 | 28756 | 12 | 0.420 | 68466.7 |
450 | 2021-09-14 22:42:36 | profs | 1 | 28756 | 12 | 0.546 | 52666.7 |
449 | 2021-09-12 19:21:59 | profs | 1 | 28756 | 12 | 0.530 | 54256.6 |
448 | 2021-09-09 13:01:44 | profs | 1 | 28756 | 12 | 0.453 | 63479.0 |
447 | 2021-08-24 00:34:08 | profs | 1 | 28756 | 12 | 0.516 | 55728.7 |
446 | 2021-06-08 13:13:30 | profs | 1 | 28756 | 12 | 0.440 | 65354.5 |
445 | 2021-05-15 04:37:02 | profs | 1 | 28756 | 12 | 0.530 | 54256.6 |
444 | 2021-04-14 07:46:25 | profs | 1 | 28756 | 12 | 0.436 | 65954.1 |
443 | 2021-03-06 07:15:03 | profs | 1 | 28756 | 12 | 0.466 | 61708.2 |
442 | 2021-03-06 07:01:22 | profs | 1 | 28756 | 12 | 0.486 | 59168.7 |
441 | 2021-03-03 01:27:37 | profs | 1 | 28756 | 12 | 0.483 | 59536.2 |
440 | 2021-02-15 15:09:48 | profs | 1 | 28756 | 12 | 0.486 | 59168.7 |
439 | 2020-12-30 03:32:52 | profs | 1 | 28756 | 12 | 0.436 | 65954.1 |
438 | 2020-11-27 10:54:12 | profs | 1 | 28756 | 12 | 0.453 | 63479.0 |
437 | 2020-11-14 18:56:44 | profs | 1 | 28756 | 12 | 0.453 | 63479.0 |
436 | 2020-08-31 17:57:52 | profs | 1 | 28756 | 12 | 0.483 | 59536.2 |
435 | 2020-08-22 14:13:16 | profs | 1 | 28756 | 12 | 0.593 | 48492.4 |
434 | 2020-08-16 00:22:01 | profs | 1 | 28756 | 12 | 0.530 | 54256.6 |
433 | 2020-08-13 02:16:35 | profs | 1 | 28756 | 12 | 0.516 | 55728.7 |
432 | 2020-08-12 04:02:44 | profs | 1 | 28756 | 12 | 0.500 | 57512.0 |
431 | 2020-07-31 12:33:05 | profs | 1 | 28756 | 12 | 0.453 | 63479.0 |
430 | 2020-05-19 15:12:36 | profs | 1 | 28756 | 12 | 0.516 | 55728.7 |
429 | 2020-05-11 00:06:01 | profs | 1 | 28756 | 12 | 0.500 | 57512.0 |
428 | 2020-03-25 18:59:20 | profs | 1 | 28756 | 12 | 0.453 | 63479.0 |
427 | 2020-03-24 08:29:00 | profs | 1 | 28756 | 12 | 0.483 | 59536.2 |
426 | 2020-03-23 03:12:08 | profs | 1 | 28756 | 12 | 0.530 | 54256.6 |
425 | 2020-03-22 17:06:56 | profs | 1 | 28756 | 12 | 0.436 | 65954.1 |
424 | 2020-03-21 07:11:59 | profs | 1 | 28756 | 12 | 0.516 | 55728.7 |
423 | 2020-03-18 09:28:13 | profs | 1 | 28756 | 12 | 0.500 | 57512.0 |
422 | 2020-02-27 02:15:55 | profs | 1 | 28756 | 12 | 0.843 | 34111.5 |
421 | 2020-02-26 23:22:25 | profs | 1 | 28756 | 12 | 0.576 | 49923.6 |
420 | 2020-02-23 18:06:22 | profs | 1 | 28756 | 12 | 0.500 | 57512.0 |
419 | 2020-02-22 10:07:03 | profs | 1 | 28756 | 12 | 0.530 | 54256.6 |
418 | 2020-02-20 01:12:20 | profs | 1 | 28756 | 12 | 1.110 | 25906.3 |
417 | 2020-02-19 02:34:54 | profs | 1 | 28756 | 12 | 1.123 | 25606.4 |