History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"camera"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1290 | 2024-04-27 17:28:34 | camera | 1 | 48755 | 4 | 0.983 | 49598.2 |
1289 | 2024-04-23 17:31:35 | camera | 1 | 48755 | 4 | 0.780 | 62506.4 |
1288 | 2024-04-22 23:18:36 | camera | 1 | 48755 | 4 | 0.843 | 57835.1 |
1287 | 2024-04-13 00:12:41 | camera | 2 | 82551 | 53 | 2.750 | 30018.5 |
1286 | 2024-04-13 00:11:49 | camera | 3 | 112716 | 849 | 6.126 | 18399.6 |
1285 | 2024-04-12 19:27:21 | camera | 2 | 82551 | 53 | 2.266 | 36430.3 |
1284 | 2024-04-12 19:27:17 | camera | 1 | 48755 | 4 | 0.876 | 55656.4 |
1283 | 2024-04-12 19:26:53 | camera | 3 | 112716 | 849 | 6.046 | 18643.1 |
1282 | 2024-04-11 17:09:27 | camera | 3 | 112716 | 849 | 5.640 | 19985.1 |
1281 | 2024-04-04 12:26:39 | camera | 3 | 112716 | 849 | 12.093 | 9320.8 |
1280 | 2024-03-29 17:42:04 | camera | 3 | 112716 | 849 | 4.890 | 23050.3 |
1279 | 2024-03-23 05:41:36 | camera | 1 | 48755 | 4 | 0.796 | 61250.0 |
1278 | 2024-03-20 23:15:35 | camera | 1 | 48755 | 4 | 2.766 | 17626.5 |
1277 | 2024-03-18 22:21:40 | camera | 2 | 82551 | 53 | 3.220 | 25637.0 |
1276 | 2024-03-18 22:20:58 | camera | 3 | 112716 | 849 | 7.016 | 16065.6 |
1275 | 2024-03-18 11:52:15 | camera | 3 | 112716 | 849 | 12.720 | 8861.3 |
1274 | 2024-03-15 04:59:52 | camera | 3 | 112716 | 849 | 19.186 | 5874.9 |
1273 | 2024-03-14 20:18:00 | camera | 3 | 112716 | 849 | 10.170 | 11083.2 |
1272 | 2024-03-13 15:49:20 | camera | 2 | 82551 | 53 | 5.783 | 14274.8 |
1271 | 2024-03-13 15:46:47 | camera | 3 | 112716 | 849 | 7.626 | 14780.5 |
1270 | 2024-03-13 15:46:48 | camera | 2 | 82551 | 53 | 4.720 | 17489.6 |
1269 | 2024-03-13 15:46:37 | camera | 1 | 48755 | 4 | 1.953 | 24964.2 |
1268 | 2024-03-13 15:46:06 | camera | 3 | 112716 | 849 | 7.923 | 14226.4 |
1267 | 2024-03-13 00:09:59 | camera | 3 | 112716 | 849 | 15.390 | 7324.0 |
1266 | 2024-03-06 23:19:06 | camera | 1 | 48755 | 4 | 1.186 | 41108.8 |
1265 | 2024-01-27 04:22:25 | camera | 2 | 82551 | 53 | 2.720 | 30349.6 |
1264 | 2024-01-26 17:44:24 | camera | 2 | 82551 | 53 | 2.826 | 29211.3 |
1263 | 2024-01-17 02:01:03 | camera | 1 | 48755 | 4 | 0.766 | 63648.8 |
1262 | 2023-12-21 05:10:52 | camera | 1 | 48755 | 4 | 0.783 | 62266.9 |
1261 | 2023-12-16 18:50:05 | camera | 1 | 48755 | 4 | 0.860 | 56691.9 |
1260 | 2023-12-10 01:29:46 | camera | 3 | 112716 | 849 | 5.750 | 19602.8 |
1259 | 2023-11-29 12:32:07 | camera | 2 | 82551 | 53 | 2.340 | 35278.2 |
1258 | 2023-11-25 21:20:48 | camera | 2 | 82551 | 53 | 2.890 | 28564.4 |
1257 | 2023-11-25 16:57:21 | camera | 3 | 112716 | 849 | 5.763 | 19558.6 |
1256 | 2023-11-24 16:57:14 | camera | 1 | 48755 | 4 | 0.873 | 55847.7 |
1255 | 2023-11-21 14:27:17 | camera | 2 | 82551 | 53 | 3.376 | 24452.3 |
1254 | 2023-11-17 00:06:29 | camera | 1 | 48755 | 4 | 0.893 | 54596.9 |
1253 | 2023-11-14 19:35:05 | camera | 1 | 48755 | 4 | 0.890 | 54780.9 |
1252 | 2023-11-10 05:26:09 | camera | 3 | 112716 | 849 | 5.580 | 20200.0 |
1251 | 2023-11-09 17:09:24 | camera | 3 | 112716 | 849 | 4.953 | 22757.1 |
1250 | 2023-11-07 14:18:32 | camera | 3 | 112716 | 849 | 4.956 | 22743.3 |
1249 | 2023-11-06 13:19:06 | camera | 3 | 112716 | 849 | 5.546 | 20323.8 |
1248 | 2023-11-06 10:15:45 | camera | 2 | 82551 | 53 | 2.156 | 38289.0 |
1247 | 2023-11-05 20:09:52 | camera | 3 | 112716 | 849 | 7.220 | 15611.6 |
1246 | 2023-11-05 13:28:04 | camera | 3 | 112716 | 849 | 5.170 | 21801.9 |
1245 | 2023-11-04 19:52:44 | camera | 3 | 112716 | 849 | 10.813 | 10424.1 |
1244 | 2023-11-04 13:24:56 | camera | 3 | 112716 | 849 | 6.810 | 16551.5 |
1243 | 2023-11-04 10:49:16 | camera | 1 | 48755 | 4 | 0.890 | 54780.9 |
1242 | 2023-11-04 07:03:37 | camera | 1 | 48755 | 4 | 1.560 | 31253.2 |
1241 | 2023-11-03 19:59:26 | camera | 3 | 112716 | 849 | 4.940 | 22817.0 |
1240 | 2023-11-03 17:35:31 | camera | 1 | 48755 | 4 | 0.860 | 56691.9 |
1239 | 2023-11-03 14:14:14 | camera | 3 | 112716 | 849 | 4.720 | 23880.5 |
1238 | 2023-11-02 20:00:00 | camera | 3 | 112716 | 849 | 5.470 | 20606.2 |
1237 | 2023-11-02 13:19:18 | camera | 3 | 112716 | 849 | 5.546 | 20323.8 |
1236 | 2023-11-01 21:20:45 | camera | 3 | 112716 | 849 | 11.250 | 10019.2 |
1235 | 2023-11-01 07:30:38 | camera | 3 | 112716 | 849 | 4.813 | 23419.1 |
1234 | 2023-10-31 07:29:52 | camera | 3 | 112716 | 849 | 5.580 | 20200.0 |
1233 | 2023-10-30 20:27:25 | camera | 3 | 112716 | 849 | 6.580 | 17130.1 |
1232 | 2023-10-30 07:13:16 | camera | 3 | 112716 | 849 | 4.830 | 23336.6 |
1231 | 2023-10-29 19:36:20 | camera | 3 | 112716 | 849 | 5.030 | 22408.7 |
1230 | 2023-10-29 07:29:31 | camera | 3 | 112716 | 849 | 5.186 | 21734.7 |
1229 | 2023-10-28 07:31:01 | camera | 3 | 112716 | 849 | 15.080 | 7474.5 |
1228 | 2023-10-27 07:06:31 | camera | 3 | 112716 | 849 | 5.453 | 20670.5 |
1227 | 2023-10-26 07:37:55 | camera | 3 | 112716 | 849 | 5.580 | 20200.0 |
1226 | 2023-10-26 04:45:53 | camera | 3 | 112716 | 849 | 11.173 | 10088.2 |
1225 | 2023-10-25 18:52:56 | camera | 3 | 112716 | 849 | 6.110 | 18447.8 |
1224 | 2023-10-25 09:00:32 | camera | 3 | 112716 | 849 | 5.673 | 19868.9 |
1223 | 2023-10-24 18:59:39 | camera | 3 | 112716 | 849 | 6.093 | 18499.3 |
1222 | 2023-10-24 12:36:59 | camera | 3 | 112716 | 849 | 4.906 | 22975.1 |
1221 | 2023-10-23 20:47:11 | camera | 3 | 112716 | 849 | 5.423 | 20784.8 |
1220 | 2023-10-23 09:56:03 | camera | 3 | 112716 | 849 | 12.720 | 8861.3 |
1219 | 2023-10-22 22:38:07 | camera | 3 | 112716 | 849 | 5.250 | 21469.7 |
1218 | 2023-10-22 09:11:39 | camera | 3 | 112716 | 849 | 4.906 | 22975.1 |
1217 | 2023-10-21 20:04:06 | camera | 3 | 112716 | 849 | 4.876 | 23116.5 |
1216 | 2023-10-21 16:45:56 | camera | 1 | 48755 | 4 | 0.923 | 52822.3 |
1215 | 2023-10-21 09:34:47 | camera | 3 | 112716 | 849 | 6.810 | 16551.5 |
1214 | 2023-10-20 19:39:37 | camera | 3 | 112716 | 849 | 5.140 | 21929.2 |
1213 | 2023-10-20 09:55:44 | camera | 3 | 112716 | 849 | 6.106 | 18459.9 |
1212 | 2023-10-19 18:49:52 | camera | 3 | 112716 | 849 | 5.296 | 21283.2 |
1211 | 2023-10-19 18:04:17 | camera | 3 | 112716 | 849 | 9.000 | 12524.0 |
1210 | 2023-10-19 05:23:49 | camera | 1 | 48755 | 4 | 0.860 | 56691.9 |
1209 | 2023-10-19 03:37:08 | camera | 3 | 112716 | 849 | 4.763 | 23664.9 |
1208 | 2023-10-18 18:12:09 | camera | 3 | 112716 | 849 | 5.733 | 19660.9 |
1207 | 2023-10-18 02:21:36 | camera | 3 | 112716 | 849 | 5.873 | 19192.2 |
1206 | 2023-10-17 18:02:10 | camera | 3 | 112716 | 849 | 5.466 | 20621.3 |
1205 | 2023-10-17 14:46:07 | camera | 3 | 112716 | 849 | 5.686 | 19823.4 |
1204 | 2023-10-17 08:05:02 | camera | 3 | 112716 | 849 | 7.576 | 14878.0 |
1203 | 2023-10-16 22:50:21 | camera | 3 | 112716 | 849 | 5.016 | 22471.3 |
1202 | 2023-10-15 23:10:56 | camera | 3 | 112716 | 849 | 5.300 | 21267.2 |
1201 | 2023-10-14 23:31:02 | camera | 3 | 112716 | 849 | 4.970 | 22679.3 |
1200 | 2023-10-14 02:16:05 | camera | 2 | 82551 | 53 | 2.440 | 33832.4 |
1199 | 2023-10-14 01:30:52 | camera | 3 | 112716 | 849 | 5.716 | 19719.4 |
1198 | 2023-10-13 11:30:02 | camera | 1 | 48755 | 4 | 0.843 | 57835.1 |
1197 | 2023-10-13 01:54:37 | camera | 3 | 112716 | 849 | 4.813 | 23419.1 |
1196 | 2023-10-12 11:27:31 | camera | 3 | 112716 | 849 | 5.466 | 20621.3 |
1195 | 2023-10-12 01:21:51 | camera | 3 | 112716 | 849 | 5.826 | 19347.1 |
1194 | 2023-10-11 13:56:06 | camera | 3 | 112716 | 849 | 4.956 | 22743.3 |
1193 | 2023-10-10 22:25:07 | camera | 3 | 112716 | 849 | 5.720 | 19705.6 |
1192 | 2023-10-10 17:15:43 | camera | 3 | 112716 | 849 | 5.296 | 21283.2 |
1191 | 2023-10-09 22:45:11 | camera | 3 | 112716 | 849 | 5.643 | 19974.5 |