History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"staff"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
498 | 2024-04-22 23:13:46 | staff | 2 | 53800 | 80 | 1.500 | 35866.7 |
497 | 2024-04-22 23:05:56 | staff | 3 | 83667 | 804 | 3.796 | 22040.8 |
496 | 2024-04-22 23:00:21 | staff | 2 | 53800 | 80 | 1.576 | 34137.1 |
495 | 2024-04-22 23:00:18 | staff | 3 | 83667 | 804 | 4.126 | 20278.0 |
494 | 2024-04-22 23:00:15 | staff | 1 | 28756 | 4 | 0.500 | 57512.0 |
493 | 2024-04-22 22:59:24 | staff | 1 | 28756 | 4 | 0.453 | 63479.0 |
492 | 2024-04-20 18:36:53 | staff | 3 | 83667 | 804 | 13.390 | 6248.5 |
491 | 2024-04-12 04:23:17 | staff | 1 | 28756 | 4 | 0.940 | 30591.5 |
490 | 2024-04-06 06:49:36 | staff | 1 | 28756 | 4 | 0.593 | 48492.4 |
489 | 2024-03-31 16:36:01 | staff | 1 | 28756 | 4 | 0.546 | 52666.7 |
488 | 2024-03-30 00:01:36 | staff | 1 | 28756 | 4 | 0.546 | 52666.7 |
487 | 2024-03-08 21:26:50 | staff | 2 | 53800 | 80 | 1.780 | 30224.7 |
486 | 2024-03-08 21:26:10 | staff | 3 | 83667 | 804 | 3.970 | 21074.8 |
485 | 2024-03-08 06:54:46 | staff | 3 | 83667 | 804 | 14.156 | 5910.4 |
484 | 2024-03-07 18:54:37 | staff | 3 | 83667 | 804 | 4.343 | 19264.8 |
483 | 2024-03-07 08:38:39 | staff | 3 | 83667 | 804 | 6.610 | 12657.6 |
482 | 2024-03-07 08:38:40 | staff | 2 | 53800 | 80 | 3.716 | 14477.9 |
481 | 2024-03-07 03:29:14 | staff | 1 | 28756 | 4 | 1.203 | 23903.6 |
480 | 2024-03-01 12:53:02 | staff | 1 | 28756 | 4 | 0.453 | 63479.0 |
479 | 2024-02-28 22:31:27 | staff | 1 | 28756 | 4 | 0.530 | 54256.6 |
478 | 2024-02-03 17:30:27 | staff | 1 | 28756 | 4 | 1.063 | 27051.7 |
477 | 2024-02-01 01:34:08 | staff | 2 | 53800 | 80 | 1.500 | 35866.7 |
476 | 2024-02-01 01:33:44 | staff | 3 | 83667 | 804 | 3.703 | 22594.4 |
475 | 2024-01-31 02:26:47 | staff | 2 | 53800 | 80 | 1.516 | 35488.1 |
474 | 2024-01-31 02:26:19 | staff | 3 | 83667 | 804 | 4.343 | 19264.8 |
473 | 2024-01-29 11:39:31 | staff | 2 | 53800 | 80 | 2.170 | 24792.6 |
472 | 2024-01-29 11:39:28 | staff | 3 | 83667 | 804 | 4.390 | 19058.5 |
471 | 2024-01-29 11:39:15 | staff | 1 | 28756 | 4 | 0.516 | 55728.7 |
470 | 2024-01-29 08:32:53 | staff | 1 | 28756 | 4 | 0.516 | 55728.7 |
469 | 2023-12-30 23:37:52 | staff | 1 | 28756 | 4 | 0.470 | 61183.0 |
468 | 2023-12-28 01:23:11 | staff | 3 | 83667 | 804 | 3.466 | 24139.4 |
467 | 2023-12-28 01:23:08 | staff | 2 | 53800 | 80 | 1.500 | 35866.7 |
466 | 2023-12-25 07:54:38 | staff | 1 | 28756 | 4 | 0.450 | 63902.2 |
465 | 2023-12-17 04:37:55 | staff | 3 | 83667 | 804 | 3.440 | 24321.8 |
464 | 2023-11-22 04:48:46 | staff | 2 | 53800 | 80 | 1.483 | 36277.8 |
463 | 2023-11-19 12:55:37 | staff | 1 | 28756 | 4 | 0.483 | 59536.2 |
462 | 2023-11-19 07:26:13 | staff | 3 | 83667 | 804 | 3.296 | 25384.4 |
461 | 2023-11-13 00:15:20 | staff | 1 | 28756 | 4 | 0.500 | 57512.0 |
460 | 2023-11-03 08:32:35 | staff | 1 | 28756 | 4 | 0.483 | 59536.2 |
459 | 2023-10-23 04:26:53 | staff | 1 | 28756 | 4 | 0.500 | 57512.0 |
458 | 2023-10-21 15:42:50 | staff | 3 | 83667 | 804 | 7.173 | 11664.2 |
457 | 2023-10-21 15:42:49 | staff | 2 | 53800 | 80 | 1.830 | 29398.9 |
456 | 2023-10-19 03:39:44 | staff | 1 | 28756 | 4 | 0.516 | 55728.7 |
455 | 2023-10-16 23:59:14 | staff | 1 | 28756 | 4 | 0.500 | 57512.0 |
454 | 2023-10-15 00:29:15 | staff | 1 | 28756 | 4 | 0.890 | 32310.1 |
453 | 2023-10-06 02:53:18 | staff | 2 | 53800 | 80 | 1.830 | 29398.9 |
452 | 2023-10-05 19:51:23 | staff | 1 | 28756 | 4 | 0.483 | 59536.2 |
451 | 2023-09-28 07:40:08 | staff | 2 | 53800 | 80 | 1.390 | 38705.0 |
450 | 2023-09-28 03:23:46 | staff | 3 | 83667 | 804 | 3.720 | 22491.1 |
449 | 2023-09-26 05:38:00 | staff | 1 | 28756 | 4 | 0.516 | 55728.7 |
448 | 2023-09-24 23:30:05 | staff | 1 | 28756 | 4 | 0.530 | 54256.6 |
447 | 2023-09-19 19:54:19 | staff | 3 | 83667 | 804 | 7.656 | 10928.3 |
446 | 2023-09-17 18:56:24 | staff | 3 | 83667 | 804 | 3.703 | 22594.4 |
445 | 2023-08-18 16:55:02 | staff | 3 | 83667 | 804 | 3.283 | 25484.9 |
444 | 2023-08-16 02:52:22 | staff | 1 | 28756 | 4 | 0.470 | 61183.0 |
443 | 2023-08-14 10:26:24 | staff | 1 | 28756 | 4 | 0.436 | 65954.1 |
442 | 2023-06-24 07:23:58 | staff | 3 | 83667 | 804 | 4.016 | 20833.4 |
441 | 2023-05-14 18:09:41 | staff | 1 | 28756 | 4 | 0.453 | 63479.0 |
440 | 2023-04-13 06:05:59 | staff | 1 | 28756 | 4 | 0.893 | 32201.6 |
439 | 2023-03-20 03:18:11 | staff | 3 | 83667 | 804 | 3.280 | 25508.2 |
438 | 2023-03-11 14:29:57 | staff | 1 | 28756 | 4 | 0.466 | 61708.2 |
437 | 2023-01-24 21:55:32 | staff | 3 | 83667 | 804 | 3.376 | 24782.9 |
436 | 2022-12-31 12:25:39 | staff | 1 | 28756 | 4 | 0.890 | 32310.1 |
435 | 2022-12-20 09:47:13 | staff | 3 | 83667 | 804 | 3.250 | 25743.7 |
434 | 2022-12-16 11:22:38 | staff | 3 | 83667 | 804 | 3.310 | 25277.0 |
433 | 2022-12-14 00:47:49 | staff | 1 | 28756 | 4 | 0.440 | 65354.5 |
432 | 2022-12-10 20:45:55 | staff | 1 | 28756 | 4 | 0.453 | 63479.0 |
431 | 2022-12-10 17:25:05 | staff | 3 | 83667 | 804 | 3.873 | 21602.6 |
430 | 2022-11-18 21:34:58 | staff | 3 | 83667 | 804 | 3.296 | 25384.4 |
429 | 2022-11-06 15:26:07 | staff | 3 | 83667 | 804 | 3.250 | 25743.7 |
428 | 2022-11-06 15:00:04 | staff | 3 | 83667 | 804 | 3.920 | 21343.6 |
427 | 2022-11-03 00:48:47 | staff | 3 | 83667 | 804 | 3.580 | 23370.7 |
426 | 2022-10-24 11:12:41 | staff | 3 | 83667 | 804 | 3.296 | 25384.4 |
425 | 2022-09-26 23:34:52 | staff | 3 | 83667 | 804 | 3.313 | 25254.2 |
424 | 2022-09-22 19:43:34 | staff | 3 | 83667 | 804 | 3.606 | 23202.2 |
423 | 2022-09-18 20:32:35 | staff | 1 | 28756 | 4 | 0.436 | 65954.1 |
422 | 2022-08-15 16:59:43 | staff | 3 | 83667 | 804 | 3.733 | 22412.8 |
421 | 2022-08-15 06:39:01 | staff | 3 | 83667 | 804 | 3.263 | 25641.1 |
420 | 2022-08-07 19:28:00 | staff | 1 | 28756 | 4 | 0.453 | 63479.0 |
419 | 2022-07-29 06:16:58 | staff | 1 | 28756 | 4 | 0.453 | 63479.0 |
418 | 2022-07-24 14:34:13 | staff | 1 | 28756 | 4 | 0.436 | 65954.1 |
417 | 2022-07-23 16:06:26 | staff | 3 | 83667 | 804 | 3.436 | 24350.1 |
416 | 2022-07-19 08:32:09 | staff | 3 | 83667 | 804 | 3.516 | 23796.1 |
415 | 2022-07-19 08:31:51 | staff | 2 | 53800 | 80 | 1.423 | 37807.4 |
414 | 2022-07-17 23:02:54 | staff | 1 | 28756 | 4 | 0.500 | 57512.0 |
413 | 2022-07-03 02:53:02 | staff | 1 | 28756 | 4 | 0.436 | 65954.1 |
412 | 2022-06-17 03:12:22 | staff | 1 | 28756 | 4 | 0.453 | 63479.0 |
411 | 2022-06-08 23:00:26 | staff | 1 | 28756 | 4 | 0.436 | 65954.1 |
410 | 2022-04-27 03:33:49 | staff | 1 | 28756 | 4 | 0.470 | 61183.0 |
409 | 2022-04-24 23:37:32 | staff | 1 | 28756 | 4 | 0.466 | 61708.2 |
408 | 2022-03-02 20:18:32 | staff | 1 | 28756 | 4 | 0.470 | 61183.0 |
407 | 2022-01-14 03:02:09 | staff | 1 | 28756 | 4 | 0.453 | 63479.0 |
406 | 2021-11-12 01:53:05 | staff | 1 | 28756 | 4 | 0.450 | 63902.2 |
405 | 2021-10-26 17:18:51 | staff | 1 | 28756 | 4 | 0.500 | 57512.0 |
404 | 2021-10-14 09:35:34 | staff | 1 | 28756 | 4 | 0.483 | 59536.2 |
403 | 2021-10-12 07:23:37 | staff | 1 | 28756 | 4 | 0.500 | 57512.0 |
402 | 2021-07-16 06:05:14 | staff | 1 | 28756 | 4 | 0.486 | 59168.7 |
401 | 2021-06-24 03:09:23 | staff | 1 | 28756 | 4 | 0.500 | 57512.0 |
400 | 2021-05-14 22:55:35 | staff | 1 | 28756 | 4 | 0.516 | 55728.7 |
399 | 2021-05-07 23:50:22 | staff | 3 | 83667 | 804 | 3.843 | 21771.3 |