History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bobby"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1083 | 2024-04-03 04:31:00 | bobby | 1 | 28756 | 8 | 1.736 | 16564.5 |
| 1082 | 2024-03-31 04:22:43 | bobby | 1 | 28756 | 8 | 1.143 | 25158.4 |
| 1081 | 2024-03-30 19:52:27 | bobby | 2 | 53800 | 81 | 1.906 | 28226.7 |
| 1080 | 2024-03-30 07:01:32 | bobby | 2 | 53800 | 81 | 5.610 | 9590.0 |
| 1079 | 2024-03-30 07:01:05 | bobby | 3 | 83667 | 796 | 4.500 | 18592.7 |
| 1078 | 2024-03-30 04:29:22 | bobby | 1 | 28756 | 8 | 1.343 | 21411.8 |
| 1077 | 2024-03-29 01:08:39 | bobby | 1 | 28756 | 8 | 1.216 | 23648.0 |
| 1076 | 2024-03-28 19:26:05 | bobby | 2 | 53800 | 81 | 1.903 | 28271.2 |
| 1075 | 2024-03-28 19:26:04 | bobby | 1 | 28756 | 8 | 0.640 | 44931.3 |
| 1074 | 2024-03-28 19:25:30 | bobby | 3 | 83667 | 796 | 8.296 | 10085.2 |
| 1073 | 2024-03-28 19:12:59 | bobby | 3 | 83667 | 796 | 13.220 | 6328.8 |
| 1072 | 2024-03-28 19:13:01 | bobby | 2 | 53800 | 81 | 1.903 | 28271.2 |
| 1071 | 2024-03-28 19:10:01 | bobby | 1 | 28756 | 8 | 1.126 | 25538.2 |
| 1070 | 2024-03-04 20:19:28 | bobby | 1 | 28756 | 8 | 0.563 | 51076.4 |
| 1069 | 2024-03-04 03:12:27 | bobby | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 1068 | 2024-03-03 21:46:58 | bobby | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 1067 | 2024-02-26 07:44:20 | bobby | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 1066 | 2024-02-12 12:14:52 | bobby | 2 | 53800 | 81 | 1.923 | 27977.1 |
| 1065 | 2024-02-01 07:58:12 | bobby | 2 | 53800 | 81 | 2.190 | 24566.2 |
| 1064 | 2024-02-01 07:57:40 | bobby | 3 | 83667 | 796 | 8.390 | 9972.2 |
| 1063 | 2024-01-31 19:25:16 | bobby | 2 | 53800 | 81 | 1.656 | 32487.9 |
| 1062 | 2024-01-31 19:24:44 | bobby | 3 | 83667 | 796 | 3.716 | 22515.3 |
| 1061 | 2024-01-30 04:43:15 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 1060 | 2024-01-29 01:02:59 | bobby | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 1059 | 2024-01-27 07:25:45 | bobby | 3 | 83667 | 796 | 5.530 | 15129.7 |
| 1058 | 2024-01-27 07:25:17 | bobby | 1 | 28756 | 8 | 1.080 | 26625.9 |
| 1057 | 2024-01-14 20:20:57 | bobby | 3 | 83667 | 796 | 3.360 | 24900.9 |
| 1056 | 2024-01-02 16:56:25 | bobby | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 1055 | 2023-12-11 06:20:25 | bobby | 2 | 53800 | 81 | 1.373 | 39184.3 |
| 1054 | 2023-12-07 11:45:01 | bobby | 3 | 83667 | 796 | 3.733 | 22412.8 |
| 1053 | 2023-11-30 16:25:35 | bobby | 2 | 53800 | 81 | 1.390 | 38705.0 |
| 1052 | 2023-11-27 23:55:50 | bobby | 1 | 28756 | 8 | 0.593 | 48492.4 |
| 1051 | 2023-11-22 21:21:40 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 1050 | 2023-11-15 08:33:26 | bobby | 2 | 53800 | 81 | 1.546 | 34799.5 |
| 1049 | 2023-11-13 00:23:49 | bobby | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 1048 | 2023-11-10 18:41:38 | bobby | 3 | 83667 | 796 | 3.466 | 24139.4 |
| 1047 | 2023-11-10 18:41:35 | bobby | 2 | 53800 | 81 | 1.516 | 35488.1 |
| 1046 | 2023-11-08 01:53:21 | bobby | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 1045 | 2023-11-01 00:20:18 | bobby | 3 | 83667 | 796 | 4.016 | 20833.4 |
| 1044 | 2023-10-31 16:26:53 | bobby | 3 | 83667 | 796 | 3.373 | 24804.9 |
| 1043 | 2023-10-31 16:26:55 | bobby | 2 | 53800 | 81 | 1.610 | 33416.1 |
| 1042 | 2023-10-27 17:14:03 | bobby | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 1041 | 2023-10-26 11:44:16 | bobby | 3 | 83667 | 796 | 8.436 | 9917.9 |
| 1040 | 2023-10-25 06:19:28 | bobby | 3 | 83667 | 796 | 3.436 | 24350.1 |
| 1039 | 2023-10-20 20:26:29 | bobby | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 1038 | 2023-10-18 04:45:05 | bobby | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 1037 | 2023-10-11 18:48:31 | bobby | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 1036 | 2023-10-04 09:21:51 | bobby | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 1035 | 2023-09-25 22:32:14 | bobby | 1 | 28756 | 8 | 0.890 | 32310.1 |
| 1034 | 2023-09-24 02:19:22 | bobby | 1 | 28756 | 8 | 0.766 | 37540.5 |
| 1033 | 2023-09-09 08:22:15 | bobby | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 1032 | 2023-08-16 14:01:21 | bobby | 3 | 83667 | 796 | 3.233 | 25879.1 |
| 1031 | 2023-08-16 07:39:48 | bobby | 2 | 53800 | 81 | 1.390 | 38705.0 |
| 1030 | 2023-08-08 16:16:46 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 1029 | 2023-08-05 08:48:58 | bobby | 3 | 83667 | 796 | 3.686 | 22698.6 |
| 1028 | 2023-07-03 02:59:17 | bobby | 1 | 28756 | 8 | 0.466 | 61708.2 |
| 1027 | 2023-06-15 17:41:30 | bobby | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 1026 | 2023-05-01 03:07:09 | bobby | 2 | 53800 | 81 | 1.390 | 38705.0 |
| 1025 | 2023-05-01 01:29:48 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 1024 | 2023-04-17 16:33:20 | bobby | 3 | 83667 | 796 | 3.766 | 22216.4 |
| 1023 | 2023-04-02 17:30:01 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 1022 | 2023-03-31 17:56:53 | bobby | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 1021 | 2023-02-06 18:14:32 | bobby | 2 | 53800 | 81 | 1.516 | 35488.1 |
| 1020 | 2023-01-24 02:35:30 | bobby | 3 | 83667 | 796 | 3.233 | 25879.1 |
| 1019 | 2023-01-18 18:51:04 | bobby | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 1018 | 2023-01-14 09:35:33 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 1017 | 2022-11-19 14:44:52 | bobby | 2 | 53800 | 81 | 1.360 | 39558.8 |
| 1016 | 2022-11-04 17:26:40 | bobby | 3 | 83667 | 796 | 3.216 | 26015.9 |
| 1015 | 2022-10-31 02:18:16 | bobby | 1 | 28756 | 8 | 0.456 | 63061.4 |
| 1014 | 2022-10-01 02:25:47 | bobby | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 1013 | 2022-09-18 22:33:53 | bobby | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 1012 | 2022-07-10 06:47:32 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 1011 | 2022-06-19 05:30:22 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 1010 | 2022-06-07 08:22:46 | bobby | 3 | 83667 | 796 | 3.453 | 24230.2 |
| 1009 | 2022-06-06 20:55:18 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 1008 | 2022-06-05 04:06:54 | bobby | 3 | 83667 | 796 | 3.280 | 25508.2 |
| 1007 | 2022-05-15 01:21:04 | bobby | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 1006 | 2022-04-25 17:24:57 | bobby | 2 | 53800 | 81 | 1.653 | 32546.9 |
| 1005 | 2022-04-01 01:25:20 | bobby | 1 | 28756 | 8 | 0.720 | 39938.9 |
| 1004 | 2022-02-24 14:38:46 | bobby | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 1003 | 2022-02-20 01:06:08 | bobby | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 1002 | 2022-01-22 04:01:41 | bobby | 3 | 83667 | 796 | 3.423 | 24442.6 |
| 1001 | 2021-12-15 17:11:31 | bobby | 1 | 28756 | 8 | 0.500 | 57512.0 |
| 1000 | 2021-11-08 17:28:50 | bobby | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 999 | 2021-11-05 02:43:51 | bobby | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 998 | 2021-11-03 07:47:17 | bobby | 3 | 83667 | 796 | 3.610 | 23176.5 |
| 997 | 2021-10-20 20:32:23 | bobby | 1 | 28756 | 8 | 0.470 | 61183.0 |
| 996 | 2021-09-29 04:28:30 | bobby | 1 | 28756 | 8 | 0.516 | 55728.7 |
| 995 | 2021-09-28 05:43:55 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 994 | 2021-09-24 16:14:20 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 993 | 2021-09-12 23:29:52 | bobby | 1 | 28756 | 8 | 0.546 | 52666.7 |
| 992 | 2021-09-03 07:11:02 | bobby | 3 | 83667 | 796 | 3.263 | 25641.1 |
| 991 | 2021-08-24 04:33:18 | bobby | 1 | 28756 | 8 | 0.453 | 63479.0 |
| 990 | 2021-08-16 08:43:52 | bobby | 1 | 28756 | 8 | 0.483 | 59536.2 |
| 989 | 2021-08-15 23:05:03 | bobby | 1 | 28756 | 8 | 0.486 | 59168.7 |
| 988 | 2021-08-09 02:24:34 | bobby | 1 | 28756 | 8 | 0.436 | 65954.1 |
| 987 | 2021-07-21 04:37:14 | bobby | 3 | 83667 | 796 | 3.283 | 25484.9 |
| 986 | 2021-07-10 15:49:00 | bobby | 1 | 28756 | 8 | 0.503 | 57169.0 |
| 985 | 2021-06-26 00:01:10 | bobby | 3 | 83667 | 796 | 3.953 | 21165.4 |
| 984 | 2021-06-24 11:21:02 | bobby | 3 | 83667 | 796 | 3.720 | 22491.1 |