History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sonny"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
511 | 2024-04-27 04:53:43 | sonny | 2 | 53800 | 101 | 2.126 | 25305.7 |
510 | 2024-04-26 22:33:16 | sonny | 1 | 28756 | 5 | 1.890 | 15214.8 |
509 | 2024-04-25 14:55:35 | sonny | 2 | 53800 | 101 | 1.826 | 29463.3 |
508 | 2024-04-25 13:44:58 | sonny | 2 | 53800 | 101 | 2.000 | 26900.0 |
507 | 2024-04-25 13:34:54 | sonny | 2 | 53800 | 101 | 4.250 | 12658.8 |
506 | 2024-04-25 12:34:37 | sonny | 2 | 53800 | 101 | 3.313 | 16239.1 |
505 | 2024-04-03 05:52:24 | sonny | 1 | 28756 | 5 | 2.280 | 12612.3 |
504 | 2024-04-03 01:07:46 | sonny | 2 | 53800 | 101 | 6.093 | 8829.8 |
503 | 2024-03-31 08:17:08 | sonny | 1 | 28756 | 5 | 0.626 | 45936.1 |
502 | 2024-03-29 02:40:31 | sonny | 1 | 28756 | 5 | 0.576 | 49923.6 |
501 | 2024-03-27 22:07:53 | sonny | 2 | 53800 | 101 | 1.470 | 36598.6 |
500 | 2024-03-27 00:05:40 | sonny | 1 | 28756 | 5 | 0.563 | 51076.4 |
499 | 2024-03-26 10:22:21 | sonny | 2 | 53800 | 101 | 2.126 | 25305.7 |
498 | 2024-03-06 15:48:15 | sonny | 1 | 28756 | 5 | 1.190 | 24164.7 |
497 | 2024-03-06 15:07:03 | sonny | 2 | 53800 | 101 | 1.500 | 35866.7 |
496 | 2024-03-03 23:50:12 | sonny | 2 | 53800 | 101 | 5.406 | 9951.9 |
495 | 2024-03-03 22:02:39 | sonny | 1 | 28756 | 5 | 0.516 | 55728.7 |
494 | 2024-03-01 09:16:53 | sonny | 1 | 28756 | 5 | 0.563 | 51076.4 |
493 | 2024-02-27 20:03:45 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
492 | 2024-02-22 04:01:05 | sonny | 2 | 53800 | 101 | 3.800 | 14157.9 |
491 | 2024-02-20 16:50:02 | sonny | 2 | 53800 | 101 | 1.876 | 28678.0 |
490 | 2024-01-28 23:16:31 | sonny | 1 | 28756 | 5 | 0.530 | 54256.6 |
489 | 2024-01-28 17:31:49 | sonny | 1 | 28756 | 5 | 0.483 | 59536.2 |
488 | 2024-01-26 10:13:53 | sonny | 2 | 53800 | 101 | 1.643 | 32745.0 |
487 | 2024-01-17 16:36:06 | sonny | 2 | 53800 | 101 | 1.643 | 32745.0 |
486 | 2023-12-29 00:21:24 | sonny | 1 | 28756 | 5 | 0.470 | 61183.0 |
485 | 2023-12-20 01:48:54 | sonny | 1 | 28756 | 5 | 0.466 | 61708.2 |
484 | 2023-12-09 06:54:52 | sonny | 1 | 28756 | 5 | 0.513 | 56054.6 |
483 | 2023-12-05 18:38:29 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
482 | 2023-12-03 07:55:59 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
481 | 2023-12-03 07:55:58 | sonny | 1 | 28756 | 5 | 0.483 | 59536.2 |
480 | 2023-11-19 21:12:56 | sonny | 1 | 28756 | 5 | 0.606 | 47452.1 |
479 | 2023-11-17 12:31:50 | sonny | 2 | 53800 | 101 | 1.483 | 36277.8 |
478 | 2023-11-16 00:02:22 | sonny | 1 | 28756 | 5 | 0.546 | 52666.7 |
477 | 2023-11-15 23:49:11 | sonny | 2 | 53800 | 101 | 1.623 | 33148.5 |
476 | 2023-11-15 20:29:49 | sonny | 1 | 28756 | 5 | 1.063 | 27051.7 |
475 | 2023-11-07 11:17:39 | sonny | 2 | 53800 | 101 | 1.483 | 36277.8 |
474 | 2023-11-06 23:59:46 | sonny | 1 | 28756 | 5 | 0.436 | 65954.1 |
473 | 2023-11-01 03:42:21 | sonny | 1 | 28756 | 5 | 0.500 | 57512.0 |
472 | 2023-10-22 18:50:28 | sonny | 1 | 28756 | 5 | 0.530 | 54256.6 |
471 | 2023-10-19 18:07:02 | sonny | 1 | 28756 | 5 | 0.486 | 59168.7 |
470 | 2023-10-07 04:42:34 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
469 | 2023-10-05 02:37:28 | sonny | 1 | 28756 | 5 | 0.486 | 59168.7 |
468 | 2023-09-26 22:07:27 | sonny | 1 | 28756 | 5 | 0.546 | 52666.7 |
467 | 2023-09-12 20:17:26 | sonny | 1 | 28756 | 5 | 0.513 | 56054.6 |
466 | 2023-08-11 01:44:25 | sonny | 2 | 53800 | 101 | 1.453 | 37026.8 |
465 | 2023-08-06 03:55:00 | sonny | 1 | 28756 | 5 | 0.513 | 56054.6 |
464 | 2023-08-03 12:53:46 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
463 | 2023-05-06 12:45:08 | sonny | 1 | 28756 | 5 | 0.466 | 61708.2 |
462 | 2023-04-21 11:03:08 | sonny | 2 | 53800 | 101 | 1.466 | 36698.5 |
461 | 2023-04-13 21:50:52 | sonny | 1 | 28756 | 5 | 0.466 | 61708.2 |
460 | 2023-03-02 00:56:07 | sonny | 1 | 28756 | 5 | 0.516 | 55728.7 |
459 | 2023-01-25 06:34:41 | sonny | 2 | 53800 | 101 | 1.390 | 38705.0 |
458 | 2022-12-26 10:56:00 | sonny | 1 | 28756 | 5 | 0.516 | 55728.7 |
457 | 2022-12-21 06:53:26 | sonny | 1 | 28756 | 5 | 0.500 | 57512.0 |
456 | 2022-11-07 00:53:06 | sonny | 2 | 53800 | 101 | 1.626 | 33087.3 |
455 | 2022-09-14 21:46:21 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
454 | 2022-08-07 23:06:19 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
453 | 2022-06-28 09:47:33 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
452 | 2022-05-02 23:38:49 | sonny | 2 | 53800 | 101 | 1.626 | 33087.3 |
451 | 2022-04-06 17:10:00 | sonny | 1 | 28756 | 5 | 0.640 | 44931.3 |
450 | 2022-03-05 11:47:52 | sonny | 1 | 28756 | 5 | 0.530 | 54256.6 |
449 | 2021-12-31 14:55:00 | sonny | 2 | 53800 | 101 | 1.453 | 37026.8 |
448 | 2021-12-20 04:32:13 | sonny | 1 | 28756 | 5 | 0.466 | 61708.2 |
447 | 2021-12-16 08:12:27 | sonny | 1 | 28756 | 5 | 0.516 | 55728.7 |
446 | 2021-10-23 04:12:07 | sonny | 1 | 28756 | 5 | 0.466 | 61708.2 |
445 | 2021-10-09 12:45:22 | sonny | 2 | 53800 | 101 | 1.640 | 32804.9 |
444 | 2021-09-28 04:57:08 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
443 | 2021-09-22 08:34:56 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
442 | 2021-09-21 08:08:13 | sonny | 1 | 28756 | 5 | 0.500 | 57512.0 |
441 | 2021-09-15 06:10:36 | sonny | 1 | 28756 | 5 | 0.500 | 57512.0 |
440 | 2021-08-30 06:07:52 | sonny | 1 | 28756 | 5 | 0.436 | 65954.1 |
439 | 2021-08-26 22:47:05 | sonny | 1 | 28756 | 5 | 0.470 | 61183.0 |
438 | 2021-06-05 15:14:23 | sonny | 1 | 28756 | 5 | 0.530 | 54256.6 |
437 | 2021-05-22 23:02:42 | sonny | 1 | 28756 | 5 | 0.533 | 53951.2 |
436 | 2021-05-11 13:42:49 | sonny | 1 | 28756 | 5 | 0.546 | 52666.7 |
435 | 2021-04-10 08:20:48 | sonny | 1 | 28756 | 5 | 0.560 | 51350.0 |
434 | 2021-03-14 10:15:56 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
433 | 2021-02-20 20:13:21 | sonny | 1 | 28756 | 5 | 0.563 | 51076.4 |
432 | 2020-11-29 13:57:14 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
431 | 2020-11-17 10:17:01 | sonny | 1 | 28756 | 5 | 0.530 | 54256.6 |
430 | 2020-11-08 14:30:21 | sonny | 1 | 28756 | 5 | 0.500 | 57512.0 |
429 | 2020-10-31 11:34:02 | sonny | 1 | 28756 | 5 | 0.516 | 55728.7 |
428 | 2020-10-25 22:17:55 | sonny | 1 | 28756 | 5 | 0.516 | 55728.7 |
427 | 2020-10-21 13:41:58 | sonny | 1 | 28756 | 5 | 0.470 | 61183.0 |
426 | 2020-10-17 01:17:27 | sonny | 1 | 28756 | 5 | 0.513 | 56054.6 |
425 | 2020-10-12 23:27:06 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
424 | 2020-08-14 18:54:08 | sonny | 1 | 28756 | 5 | 0.486 | 59168.7 |
423 | 2020-08-09 23:22:28 | sonny | 1 | 28756 | 5 | 0.500 | 57512.0 |
422 | 2020-08-09 07:27:32 | sonny | 1 | 28756 | 5 | 0.470 | 61183.0 |
421 | 2020-06-06 16:37:51 | sonny | 1 | 28756 | 5 | 0.470 | 61183.0 |
420 | 2020-05-23 08:29:30 | sonny | 1 | 28756 | 5 | 0.440 | 65354.5 |
419 | 2020-05-07 15:01:42 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |
418 | 2020-03-30 06:06:56 | sonny | 1 | 28756 | 5 | 0.533 | 53951.2 |
417 | 2020-03-25 07:37:04 | sonny | 1 | 28756 | 5 | 0.686 | 41918.4 |
416 | 2020-03-25 02:16:13 | sonny | 1 | 28756 | 5 | 0.546 | 52666.7 |
415 | 2020-03-23 03:01:43 | sonny | 1 | 28756 | 5 | 0.516 | 55728.7 |
414 | 2020-03-22 16:53:06 | sonny | 1 | 28756 | 5 | 0.516 | 55728.7 |
413 | 2020-03-21 12:53:57 | sonny | 1 | 28756 | 5 | 0.530 | 54256.6 |
412 | 2020-03-18 06:20:54 | sonny | 1 | 28756 | 5 | 0.453 | 63479.0 |