History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"music"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1198 | 2024-04-02 20:41:58 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1197 | 2024-03-31 06:49:20 | music | 3 | 83667 | 723 | 13.500 | 6197.6 |
1196 | 2024-03-31 06:49:19 | music | 2 | 53800 | 67 | 3.123 | 17227.0 |
1195 | 2024-03-31 06:43:53 | music | 1 | 28756 | 4 | 1.110 | 25906.3 |
1194 | 2024-03-29 23:49:31 | music | 1 | 28756 | 4 | 0.516 | 55728.7 |
1193 | 2024-03-29 21:30:18 | music | 3 | 83667 | 723 | 14.156 | 5910.4 |
1192 | 2024-03-29 21:30:20 | music | 2 | 53800 | 67 | 7.030 | 7652.9 |
1191 | 2024-03-29 20:56:21 | music | 2 | 53800 | 67 | 1.576 | 34137.1 |
1190 | 2024-03-29 20:55:57 | music | 3 | 83667 | 723 | 8.750 | 9561.9 |
1189 | 2024-03-29 05:28:54 | music | 3 | 83667 | 723 | 6.236 | 13416.8 |
1188 | 2024-03-28 23:07:43 | music | 2 | 53800 | 67 | 2.546 | 21131.2 |
1187 | 2024-03-28 23:07:41 | music | 1 | 28756 | 4 | 1.110 | 25906.3 |
1186 | 2024-03-28 23:07:11 | music | 3 | 83667 | 723 | 7.733 | 10819.5 |
1185 | 2024-03-28 23:06:33 | music | 3 | 83667 | 723 | 3.593 | 23286.1 |
1184 | 2024-03-02 18:21:43 | music | 3 | 83667 | 723 | 13.656 | 6126.8 |
1183 | 2024-03-02 18:20:39 | music | 2 | 53800 | 67 | 5.626 | 9562.7 |
1182 | 2024-03-02 18:20:24 | music | 1 | 28756 | 4 | 1.673 | 17188.3 |
1181 | 2024-03-01 05:00:12 | music | 1 | 28756 | 4 | 1.000 | 28756.0 |
1180 | 2024-02-28 19:47:04 | music | 1 | 28756 | 4 | 0.516 | 55728.7 |
1179 | 2024-02-17 12:30:26 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1178 | 2024-01-29 06:54:01 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1177 | 2024-01-29 03:37:15 | music | 1 | 28756 | 4 | 0.483 | 59536.2 |
1176 | 2024-01-02 19:22:33 | music | 3 | 83667 | 723 | 3.546 | 23594.8 |
1175 | 2023-12-31 03:09:42 | music | 2 | 53800 | 67 | 1.470 | 36598.6 |
1174 | 2023-12-26 20:47:07 | music | 3 | 83667 | 723 | 4.190 | 19968.3 |
1173 | 2023-12-26 12:59:10 | music | 3 | 83667 | 723 | 4.106 | 20376.8 |
1172 | 2023-12-21 22:15:10 | music | 1 | 28756 | 4 | 0.500 | 57512.0 |
1171 | 2023-12-18 09:02:35 | music | 2 | 53800 | 67 | 1.626 | 33087.3 |
1170 | 2023-12-17 10:50:25 | music | 2 | 53800 | 67 | 1.530 | 35163.4 |
1169 | 2023-12-17 10:50:22 | music | 3 | 83667 | 723 | 3.750 | 22311.2 |
1168 | 2023-12-08 04:10:56 | music | 1 | 28756 | 4 | 0.453 | 63479.0 |
1167 | 2023-12-08 04:10:55 | music | 1 | 28756 | 4 | 0.440 | 65354.5 |
1166 | 2023-12-04 22:07:59 | music | 3 | 83667 | 723 | 3.813 | 21942.6 |
1165 | 2023-12-04 03:48:28 | music | 1 | 28756 | 4 | 0.486 | 59168.7 |
1164 | 2023-11-17 04:06:01 | music | 1 | 28756 | 4 | 0.483 | 59536.2 |
1163 | 2023-11-15 15:53:05 | music | 1 | 28756 | 4 | 0.440 | 65354.5 |
1162 | 2023-11-14 23:17:34 | music | 1 | 28756 | 4 | 0.420 | 68466.7 |
1161 | 2023-11-13 18:51:39 | music | 3 | 83667 | 723 | 3.720 | 22491.1 |
1160 | 2023-11-13 18:51:41 | music | 2 | 53800 | 67 | 1.640 | 32804.9 |
1159 | 2023-11-12 01:47:43 | music | 1 | 28756 | 4 | 0.483 | 59536.2 |
1158 | 2023-11-04 13:30:52 | music | 1 | 28756 | 4 | 0.500 | 57512.0 |
1157 | 2023-11-03 08:01:46 | music | 1 | 28756 | 4 | 0.533 | 53951.2 |
1156 | 2023-10-21 09:30:16 | music | 1 | 28756 | 4 | 0.466 | 61708.2 |
1155 | 2023-10-18 19:59:07 | music | 1 | 28756 | 4 | 0.500 | 57512.0 |
1154 | 2023-10-12 22:30:22 | music | 1 | 28756 | 4 | 0.516 | 55728.7 |
1153 | 2023-10-05 01:08:53 | music | 1 | 28756 | 4 | 0.486 | 59168.7 |
1152 | 2023-09-26 09:49:08 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1151 | 2023-09-23 14:43:07 | music | 2 | 53800 | 67 | 1.576 | 34137.1 |
1150 | 2023-09-19 01:19:37 | music | 1 | 28756 | 4 | 0.423 | 67981.1 |
1149 | 2023-09-18 13:15:31 | music | 2 | 53800 | 67 | 1.516 | 35488.1 |
1148 | 2023-09-13 13:51:11 | music | 1 | 28756 | 4 | 0.470 | 61183.0 |
1147 | 2023-09-02 21:34:44 | music | 3 | 83667 | 723 | 3.560 | 23502.0 |
1146 | 2023-08-22 12:53:11 | music | 3 | 83667 | 723 | 3.376 | 24782.9 |
1145 | 2023-07-21 16:54:27 | music | 1 | 28756 | 4 | 0.423 | 67981.1 |
1144 | 2023-07-12 23:23:14 | music | 1 | 28756 | 4 | 0.483 | 59536.2 |
1143 | 2023-06-24 13:14:49 | music | 2 | 53800 | 67 | 1.310 | 41068.7 |
1142 | 2023-05-19 02:57:52 | music | 3 | 83667 | 723 | 3.220 | 25983.5 |
1141 | 2023-05-06 21:15:21 | music | 3 | 83667 | 723 | 4.200 | 19920.7 |
1140 | 2023-04-17 20:55:39 | music | 1 | 28756 | 4 | 0.486 | 59168.7 |
1139 | 2023-03-29 22:13:27 | music | 1 | 28756 | 4 | 0.483 | 59536.2 |
1138 | 2023-03-22 08:42:23 | music | 2 | 53800 | 67 | 1.343 | 40059.6 |
1137 | 2023-02-24 15:35:31 | music | 3 | 83667 | 723 | 3.156 | 26510.5 |
1136 | 2023-02-07 03:31:29 | music | 1 | 28756 | 4 | 0.440 | 65354.5 |
1135 | 2022-12-21 20:19:59 | music | 2 | 53800 | 67 | 1.356 | 39675.5 |
1134 | 2022-12-21 18:07:49 | music | 1 | 28756 | 4 | 0.470 | 61183.0 |
1133 | 2022-12-07 23:34:54 | music | 1 | 28756 | 4 | 0.423 | 67981.1 |
1132 | 2022-12-05 11:23:29 | music | 3 | 83667 | 723 | 3.640 | 22985.4 |
1131 | 2022-12-04 16:56:40 | music | 1 | 28756 | 4 | 0.483 | 59536.2 |
1130 | 2022-11-05 06:54:32 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1129 | 2022-09-19 21:10:01 | music | 1 | 28756 | 4 | 0.440 | 65354.5 |
1128 | 2022-09-18 15:42:24 | music | 1 | 28756 | 4 | 0.450 | 63902.2 |
1127 | 2022-09-03 12:57:08 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1126 | 2022-08-19 20:04:06 | music | 2 | 53800 | 67 | 1.343 | 40059.6 |
1125 | 2022-08-15 11:35:13 | music | 1 | 28756 | 4 | 0.440 | 65354.5 |
1124 | 2022-08-14 05:58:34 | music | 1 | 28756 | 4 | 0.486 | 59168.7 |
1123 | 2022-08-10 14:44:31 | music | 1 | 28756 | 4 | 0.516 | 55728.7 |
1122 | 2022-08-05 22:28:35 | music | 1 | 28756 | 4 | 0.423 | 67981.1 |
1121 | 2022-08-04 12:09:45 | music | 1 | 28756 | 4 | 0.546 | 52666.7 |
1120 | 2022-08-01 01:29:52 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1119 | 2022-07-30 06:03:36 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1118 | 2022-07-25 03:29:33 | music | 1 | 28756 | 4 | 0.440 | 65354.5 |
1117 | 2022-07-23 00:31:16 | music | 3 | 83667 | 723 | 3.310 | 25277.0 |
1116 | 2022-07-18 03:59:10 | music | 3 | 83667 | 723 | 3.360 | 24900.9 |
1115 | 2022-07-17 19:32:12 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1114 | 2022-07-11 15:38:27 | music | 3 | 83667 | 723 | 3.263 | 25641.1 |
1113 | 2022-07-10 06:49:42 | music | 3 | 83667 | 723 | 3.516 | 23796.1 |
1112 | 2022-07-10 05:05:19 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1111 | 2022-07-03 12:33:14 | music | 1 | 28756 | 4 | 0.483 | 59536.2 |
1110 | 2022-07-02 16:28:46 | music | 1 | 28756 | 4 | 0.423 | 67981.1 |
1109 | 2022-07-02 07:15:22 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1108 | 2022-07-01 06:23:18 | music | 3 | 83667 | 723 | 3.593 | 23286.1 |
1107 | 2022-06-25 11:55:38 | music | 3 | 83667 | 723 | 3.280 | 25508.2 |
1106 | 2022-06-21 05:41:17 | music | 3 | 83667 | 723 | 3.233 | 25879.1 |
1105 | 2022-06-17 03:48:46 | music | 1 | 28756 | 4 | 0.440 | 65354.5 |
1104 | 2022-06-16 12:31:26 | music | 1 | 28756 | 4 | 0.453 | 63479.0 |
1103 | 2022-06-15 18:26:24 | music | 1 | 28756 | 4 | 0.456 | 63061.4 |
1102 | 2022-06-10 09:26:36 | music | 1 | 28756 | 4 | 0.466 | 61708.2 |
1101 | 2022-06-08 13:12:25 | music | 1 | 28756 | 4 | 0.486 | 59168.7 |
1100 | 2022-06-04 03:09:59 | music | 1 | 28756 | 4 | 0.436 | 65954.1 |
1099 | 2022-06-01 22:23:44 | music | 3 | 83667 | 723 | 3.156 | 26510.5 |