History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"advisements"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
346 | 2024-04-10 22:39:32 | advisements | 1 | 49908 | 2 | 0.876 | 56972.6 |
345 | 2024-04-02 07:48:38 | advisements | 4 | 148819 | 91 | 10.253 | 14514.7 |
344 | 2024-04-01 09:19:19 | advisements | 1 | 49908 | 2 | 0.940 | 53093.6 |
343 | 2024-03-21 16:13:58 | advisements | 4 | 148819 | 91 | 29.300 | 5079.1 |
342 | 2024-03-20 19:50:19 | advisements | 4 | 148819 | 91 | 29.376 | 5066.0 |
341 | 2024-03-17 19:50:19 | advisements | 4 | 148819 | 91 | 34.410 | 4324.9 |
340 | 2024-03-17 19:04:17 | advisements | 4 | 148819 | 91 | 19.516 | 7625.5 |
339 | 2024-03-16 12:44:00 | advisements | 4 | 148819 | 91 | 27.483 | 5414.9 |
338 | 2024-03-16 00:54:56 | advisements | 5 | 164607 | 385 | 54.583 | 3015.7 |
337 | 2024-03-15 04:25:42 | advisements | 5 | 164607 | 385 | 32.863 | 5008.9 |
336 | 2024-03-13 21:40:07 | advisements | 5 | 164607 | 385 | 44.970 | 3660.4 |
335 | 2024-03-13 19:29:00 | advisements | 5 | 164607 | 385 | 29.813 | 5521.3 |
334 | 2024-03-13 09:02:55 | advisements | 4 | 148819 | 91 | 10.110 | 14720.0 |
333 | 2024-03-13 09:03:04 | advisements | 1 | 49908 | 2 | 0.860 | 58032.6 |
332 | 2024-03-13 09:02:53 | advisements | 3 | 121633 | 11 | 5.580 | 21798.0 |
331 | 2024-03-13 09:02:55 | advisements | 2 | 86808 | 2 | 3.046 | 28499.0 |
330 | 2024-03-13 09:02:19 | advisements | 5 | 164607 | 385 | 15.046 | 10940.2 |
329 | 2024-03-13 09:01:23 | advisements | 1 | 49908 | 2 | 0.813 | 61387.5 |
328 | 2024-02-14 00:49:05 | advisements | 1 | 49908 | 2 | 1.080 | 46211.1 |
327 | 2024-02-12 14:41:44 | advisements | 4 | 148819 | 91 | 17.190 | 8657.3 |
326 | 2024-02-11 15:07:35 | advisements | 2 | 86808 | 2 | 5.263 | 16494.0 |
325 | 2024-02-11 14:51:04 | advisements | 1 | 49908 | 2 | 0.826 | 60421.3 |
324 | 2024-02-11 13:31:55 | advisements | 4 | 148819 | 91 | 16.220 | 9175.0 |
323 | 2024-02-11 13:31:51 | advisements | 3 | 121633 | 11 | 13.733 | 8857.0 |
322 | 2024-02-10 07:40:48 | advisements | 4 | 148819 | 91 | 11.890 | 12516.3 |
321 | 2024-02-10 04:35:21 | advisements | 3 | 121633 | 11 | 11.436 | 10636.0 |
320 | 2024-02-10 04:35:21 | advisements | 2 | 86808 | 2 | 8.110 | 10703.8 |
319 | 2024-02-10 04:33:33 | advisements | 5 | 164607 | 385 | 39.190 | 4200.2 |
318 | 2024-02-10 04:33:33 | advisements | 4 | 148819 | 91 | 23.063 | 6452.7 |
317 | 2024-02-10 03:04:36 | advisements | 1 | 49908 | 2 | 0.750 | 66544.0 |
316 | 2024-02-07 20:45:17 | advisements | 1 | 49908 | 2 | 0.860 | 58032.6 |
315 | 2024-02-07 19:15:56 | advisements | 2 | 86808 | 2 | 5.283 | 16431.6 |
314 | 2024-02-07 19:15:50 | advisements | 3 | 121633 | 11 | 10.703 | 11364.4 |
313 | 2024-02-07 18:17:30 | advisements | 2 | 86808 | 2 | 5.656 | 15347.9 |
312 | 2024-02-07 16:06:04 | advisements | 1 | 49908 | 2 | 0.826 | 60421.3 |
311 | 2024-02-07 16:05:49 | advisements | 1 | 49908 | 2 | 1.483 | 33653.4 |
310 | 2024-02-07 16:05:39 | advisements | 3 | 121633 | 11 | 5.453 | 22305.7 |
309 | 2024-01-12 15:25:29 | advisements | 4 | 148819 | 91 | 9.076 | 16397.0 |
308 | 2024-01-12 15:25:21 | advisements | 5 | 164607 | 385 | 15.220 | 10815.2 |
307 | 2024-01-12 15:25:26 | advisements | 2 | 86808 | 2 | 2.453 | 35388.5 |
306 | 2024-01-12 15:25:22 | advisements | 3 | 121633 | 11 | 5.203 | 23377.5 |
305 | 2023-12-23 17:51:30 | advisements | 2 | 86808 | 2 | 1.953 | 44448.5 |
304 | 2023-12-21 02:53:12 | advisements | 3 | 121633 | 11 | 4.140 | 29380.0 |
303 | 2023-12-07 04:15:41 | advisements | 4 | 148819 | 91 | 8.220 | 18104.5 |
302 | 2023-12-04 11:40:00 | advisements | 1 | 49908 | 2 | 0.736 | 67809.8 |
301 | 2023-11-28 10:05:33 | advisements | 1 | 49908 | 2 | 0.830 | 60130.1 |
300 | 2023-11-15 20:24:13 | advisements | 1 | 49908 | 2 | 0.826 | 60421.3 |
299 | 2023-10-31 04:07:53 | advisements | 1 | 49908 | 2 | 0.843 | 59202.8 |
298 | 2023-10-27 20:31:01 | advisements | 1 | 49908 | 2 | 0.766 | 65154.0 |
297 | 2023-10-13 00:32:37 | advisements | 1 | 49908 | 2 | 0.720 | 69316.7 |
296 | 2023-09-24 22:18:59 | advisements | 2 | 86808 | 2 | 2.000 | 43404.0 |
295 | 2023-09-22 09:29:04 | advisements | 3 | 121633 | 11 | 4.096 | 29695.6 |
294 | 2023-09-13 19:00:30 | advisements | 1 | 49908 | 2 | 0.873 | 57168.4 |
293 | 2023-09-05 12:03:52 | advisements | 4 | 148819 | 91 | 15.046 | 9890.9 |
292 | 2023-07-07 15:57:55 | advisements | 1 | 49908 | 2 | 0.716 | 69703.9 |
291 | 2023-07-04 14:06:34 | advisements | 2 | 86808 | 2 | 2.343 | 37049.9 |
290 | 2023-07-01 14:28:34 | advisements | 3 | 121633 | 11 | 4.156 | 29266.8 |
289 | 2023-06-19 17:07:17 | advisements | 1 | 49908 | 2 | 0.813 | 61387.5 |
288 | 2023-04-02 09:29:44 | advisements | 1 | 49908 | 2 | 0.720 | 69316.7 |
287 | 2023-03-25 17:38:11 | advisements | 2 | 86808 | 2 | 1.906 | 45544.6 |
286 | 2023-03-22 13:17:59 | advisements | 3 | 121633 | 11 | 4.143 | 29358.7 |
285 | 2023-03-14 01:07:02 | advisements | 1 | 49908 | 2 | 0.720 | 69316.7 |
284 | 2023-03-10 17:26:05 | advisements | 1 | 49908 | 2 | 0.796 | 62698.5 |
283 | 2023-02-07 02:10:32 | advisements | 4 | 148819 | 91 | 7.546 | 19721.6 |
282 | 2023-01-15 13:09:37 | advisements | 1 | 49908 | 2 | 0.813 | 61387.5 |
281 | 2022-12-22 18:05:54 | advisements | 2 | 86808 | 2 | 1.906 | 45544.6 |
280 | 2022-12-22 00:12:03 | advisements | 3 | 121633 | 11 | 4.123 | 29501.1 |
279 | 2022-12-07 19:47:06 | advisements | 5 | 164607 | 385 | 12.250 | 13437.3 |
278 | 2022-11-19 16:25:13 | advisements | 4 | 148819 | 91 | 8.673 | 17158.9 |
277 | 2022-11-11 18:10:33 | advisements | 1 | 49908 | 2 | 0.810 | 61614.8 |
276 | 2022-11-06 03:37:45 | advisements | 1 | 49908 | 2 | 0.720 | 69316.7 |
275 | 2022-08-22 06:25:23 | advisements | 2 | 86808 | 2 | 1.920 | 45212.5 |
274 | 2022-08-19 08:39:47 | advisements | 3 | 121633 | 11 | 4.140 | 29380.0 |
273 | 2022-07-22 14:34:06 | advisements | 1 | 49908 | 2 | 0.750 | 66544.0 |
272 | 2022-06-26 10:13:55 | advisements | 1 | 49908 | 2 | 0.720 | 69316.7 |
271 | 2022-06-23 10:30:41 | advisements | 4 | 148819 | 91 | 8.766 | 16976.8 |
270 | 2022-04-03 21:22:54 | advisements | 5 | 164607 | 385 | 12.750 | 12910.4 |
269 | 2022-03-28 07:24:31 | advisements | 1 | 49908 | 2 | 0.876 | 56972.6 |
268 | 2022-03-01 10:15:53 | advisements | 1 | 49908 | 2 | 0.830 | 60130.1 |
267 | 2022-02-27 06:59:24 | advisements | 1 | 49908 | 2 | 0.753 | 66278.9 |
266 | 2022-02-25 02:04:19 | advisements | 1 | 49908 | 2 | 0.750 | 66544.0 |
265 | 2021-12-17 09:14:01 | advisements | 5 | 164607 | 385 | 15.296 | 10761.4 |
264 | 2021-12-09 22:48:32 | advisements | 1 | 49908 | 2 | 0.826 | 60421.3 |
263 | 2021-12-07 13:39:54 | advisements | 1 | 49908 | 2 | 0.766 | 65154.0 |
262 | 2021-10-25 10:24:30 | advisements | 1 | 49908 | 2 | 0.720 | 69316.7 |
261 | 2021-10-23 09:58:07 | advisements | 1 | 49908 | 2 | 0.890 | 56076.4 |
260 | 2021-10-02 17:25:20 | advisements | 1 | 49908 | 2 | 0.813 | 61387.5 |
259 | 2021-09-30 14:03:32 | advisements | 1 | 49908 | 2 | 0.796 | 62698.5 |
258 | 2021-09-14 09:53:26 | advisements | 1 | 49908 | 2 | 0.876 | 56972.6 |
257 | 2021-08-24 14:19:20 | advisements | 1 | 49908 | 2 | 0.750 | 66544.0 |
256 | 2021-08-18 01:28:21 | advisements | 1 | 49908 | 2 | 0.736 | 67809.8 |
255 | 2021-07-03 05:47:40 | advisements | 1 | 49908 | 2 | 0.733 | 68087.3 |
254 | 2021-05-20 13:40:08 | advisements | 1 | 49908 | 2 | 0.843 | 59202.8 |
253 | 2021-05-17 12:05:45 | advisements | 1 | 49908 | 2 | 1.030 | 48454.4 |
252 | 2021-04-17 12:51:40 | advisements | 1 | 49908 | 2 | 1.673 | 29831.4 |
251 | 2021-03-20 09:50:11 | advisements | 1 | 49908 | 2 | 0.843 | 59202.8 |
250 | 2021-02-17 23:36:27 | advisements | 1 | 49908 | 2 | 0.750 | 66544.0 |
249 | 2021-01-01 19:43:17 | advisements | 1 | 49908 | 2 | 0.750 | 66544.0 |
248 | 2020-12-05 09:18:08 | advisements | 1 | 49908 | 2 | 0.750 | 66544.0 |
247 | 2020-11-13 18:58:14 | advisements | 1 | 49908 | 2 | 0.720 | 69316.7 |