History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"turner"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
371 | 2024-05-04 23:43:16 | turner | 1 | 48755 | 6 | 1.890 | 25796.3 |
370 | 2024-04-26 22:24:09 | turner | 1 | 48755 | 6 | 0.923 | 52822.3 |
369 | 2024-04-12 23:08:55 | turner | 1 | 48755 | 6 | 0.876 | 55656.4 |
368 | 2024-04-10 01:37:25 | turner | 2 | 82551 | 103 | 2.436 | 33887.9 |
367 | 2024-03-31 18:53:48 | turner | 1 | 48755 | 6 | 0.893 | 54596.9 |
366 | 2024-03-31 17:59:28 | turner | 1 | 48755 | 6 | 2.986 | 16327.9 |
365 | 2024-01-20 20:55:19 | turner | 2 | 82551 | 103 | 2.080 | 39688.0 |
364 | 2024-01-12 11:25:27 | turner | 1 | 48755 | 6 | 0.783 | 62266.9 |
363 | 2023-12-29 12:57:33 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
362 | 2023-12-10 14:01:14 | turner | 2 | 82551 | 103 | 2.640 | 31269.3 |
361 | 2023-11-28 23:38:24 | turner | 2 | 82551 | 103 | 2.343 | 35233.0 |
360 | 2023-11-17 12:05:07 | turner | 1 | 48755 | 6 | 1.516 | 32160.3 |
359 | 2023-11-10 09:57:44 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
358 | 2023-11-05 04:25:06 | turner | 1 | 48755 | 6 | 0.813 | 59969.2 |
357 | 2023-10-29 16:26:57 | turner | 1 | 48755 | 6 | 0.813 | 59969.2 |
356 | 2023-10-19 02:16:43 | turner | 1 | 48755 | 6 | 0.890 | 54780.9 |
355 | 2023-10-17 07:58:22 | turner | 1 | 48755 | 6 | 0.813 | 59969.2 |
354 | 2023-10-12 01:45:27 | turner | 1 | 48755 | 6 | 0.826 | 59025.4 |
353 | 2023-10-05 06:12:21 | turner | 1 | 48755 | 6 | 0.810 | 60191.4 |
352 | 2023-09-25 04:25:11 | turner | 1 | 48755 | 6 | 1.236 | 39445.8 |
351 | 2023-09-20 13:51:19 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
350 | 2023-09-14 15:01:30 | turner | 2 | 82551 | 103 | 2.720 | 30349.6 |
349 | 2023-09-08 23:43:01 | turner | 2 | 82551 | 103 | 2.126 | 38829.3 |
348 | 2023-09-02 13:24:44 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
347 | 2023-08-13 00:16:19 | turner | 1 | 48755 | 6 | 0.736 | 66243.2 |
346 | 2023-05-29 12:09:37 | turner | 2 | 82551 | 103 | 2.093 | 39441.5 |
345 | 2023-05-14 15:07:03 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
344 | 2023-04-24 21:27:07 | turner | 1 | 48755 | 6 | 0.843 | 57835.1 |
343 | 2023-03-10 12:13:59 | turner | 1 | 48755 | 6 | 0.800 | 60943.8 |
342 | 2023-03-09 09:23:31 | turner | 2 | 82551 | 103 | 2.343 | 35233.0 |
341 | 2022-12-31 13:56:06 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
340 | 2022-12-28 15:09:02 | turner | 1 | 48755 | 6 | 0.843 | 57835.1 |
339 | 2022-12-13 17:41:28 | turner | 2 | 82551 | 103 | 2.076 | 39764.5 |
338 | 2022-12-02 11:47:47 | turner | 2 | 82551 | 103 | 2.280 | 36206.6 |
337 | 2022-11-07 10:58:30 | turner | 2 | 82551 | 103 | 2.173 | 37989.4 |
336 | 2022-10-07 11:16:55 | turner | 2 | 82551 | 103 | 2.173 | 37989.4 |
335 | 2022-09-23 08:00:56 | turner | 1 | 48755 | 6 | 0.733 | 66514.3 |
334 | 2022-08-28 02:46:50 | turner | 2 | 82551 | 103 | 2.110 | 39123.7 |
333 | 2022-08-17 14:21:35 | turner | 1 | 48755 | 6 | 0.733 | 66514.3 |
332 | 2022-08-15 03:31:31 | turner | 1 | 48755 | 6 | 0.736 | 66243.2 |
331 | 2022-08-01 15:09:25 | turner | 2 | 82551 | 103 | 2.123 | 38884.1 |
330 | 2022-07-29 10:57:51 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
329 | 2022-05-16 10:02:23 | turner | 1 | 48755 | 6 | 0.813 | 59969.2 |
328 | 2022-05-06 23:03:46 | turner | 1 | 48755 | 6 | 0.843 | 57835.1 |
327 | 2022-04-03 05:37:58 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
326 | 2022-03-03 07:10:14 | turner | 2 | 82551 | 103 | 2.560 | 32246.5 |
325 | 2022-01-21 14:26:38 | turner | 1 | 48755 | 6 | 0.860 | 56691.9 |
324 | 2022-01-19 11:56:20 | turner | 1 | 48755 | 6 | 0.876 | 55656.4 |
323 | 2021-12-06 14:32:40 | turner | 1 | 48755 | 6 | 0.733 | 66514.3 |
322 | 2021-11-27 03:48:14 | turner | 2 | 82551 | 103 | 2.390 | 34540.2 |
321 | 2021-11-17 04:39:18 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
320 | 2021-09-30 19:39:08 | turner | 1 | 48755 | 6 | 0.813 | 59969.2 |
319 | 2021-09-21 20:35:35 | turner | 2 | 82551 | 103 | 2.143 | 38521.2 |
318 | 2021-09-21 19:22:08 | turner | 2 | 82551 | 103 | 2.410 | 34253.5 |
317 | 2021-09-13 16:06:14 | turner | 1 | 48755 | 6 | 0.766 | 63648.8 |
316 | 2021-08-20 04:45:06 | turner | 1 | 48755 | 6 | 0.733 | 66514.3 |
315 | 2021-05-28 08:37:11 | turner | 1 | 48755 | 6 | 0.876 | 55656.4 |
314 | 2021-05-09 07:12:01 | turner | 1 | 48755 | 6 | 0.860 | 56691.9 |
313 | 2021-05-02 12:56:51 | turner | 1 | 48755 | 6 | 0.763 | 63899.1 |
312 | 2021-03-31 19:14:42 | turner | 1 | 48755 | 6 | 0.763 | 63899.1 |
311 | 2021-02-19 13:38:09 | turner | 1 | 48755 | 6 | 1.656 | 29441.4 |
310 | 2021-02-09 12:55:40 | turner | 1 | 48755 | 6 | 0.780 | 62506.4 |
309 | 2021-01-15 13:33:52 | turner | 1 | 48755 | 6 | 0.810 | 60191.4 |
308 | 2021-01-12 18:50:29 | turner | 1 | 48755 | 6 | 0.736 | 66243.2 |
307 | 2020-12-16 18:29:27 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
306 | 2020-11-18 17:19:25 | turner | 1 | 48755 | 6 | 0.736 | 66243.2 |
305 | 2020-10-23 14:22:41 | turner | 1 | 48755 | 6 | 0.860 | 56691.9 |
304 | 2020-10-02 17:27:43 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
303 | 2020-09-10 23:26:58 | turner | 1 | 48755 | 6 | 0.733 | 66514.3 |
302 | 2020-08-15 09:46:17 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
301 | 2020-08-08 01:56:49 | turner | 1 | 48755 | 6 | 0.766 | 63648.8 |
300 | 2020-08-06 08:48:38 | turner | 1 | 48755 | 6 | 0.796 | 61250.0 |
299 | 2020-08-04 05:18:29 | turner | 1 | 48755 | 6 | 0.780 | 62506.4 |
298 | 2020-08-03 03:52:20 | turner | 1 | 48755 | 6 | 0.843 | 57835.1 |
297 | 2020-07-30 03:45:10 | turner | 1 | 48755 | 6 | 0.893 | 54596.9 |
296 | 2020-07-10 17:26:20 | turner | 1 | 48755 | 6 | 0.796 | 61250.0 |
295 | 2020-06-12 22:33:03 | turner | 1 | 48755 | 6 | 0.860 | 56691.9 |
294 | 2020-05-07 15:40:19 | turner | 1 | 48755 | 6 | 0.890 | 54780.9 |
293 | 2020-03-28 21:19:48 | turner | 1 | 48755 | 6 | 0.860 | 56691.9 |
292 | 2020-03-27 15:08:38 | turner | 1 | 48755 | 6 | 0.860 | 56691.9 |
291 | 2020-03-26 20:44:14 | turner | 1 | 48755 | 6 | 0.856 | 56956.8 |
290 | 2020-03-23 16:51:53 | turner | 1 | 48755 | 6 | 1.860 | 26212.4 |
289 | 2020-03-23 06:54:18 | turner | 1 | 48755 | 6 | 0.893 | 54596.9 |
288 | 2020-03-18 08:31:42 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |
287 | 2020-03-05 12:09:33 | turner | 1 | 48755 | 6 | 0.783 | 62266.9 |
286 | 2020-02-25 15:16:16 | turner | 1 | 48755 | 6 | 0.860 | 56691.9 |
285 | 2020-02-19 23:37:56 | turner | 1 | 48755 | 6 | 1.173 | 41564.4 |
284 | 2020-02-13 22:16:06 | turner | 1 | 48755 | 6 | 1.860 | 26212.4 |
283 | 2020-02-07 03:21:26 | turner | 1 | 48755 | 6 | 0.873 | 55847.7 |
282 | 2020-02-04 23:38:04 | turner | 1 | 48755 | 6 | 0.920 | 52994.6 |
281 | 2020-02-03 09:19:38 | turner | 1 | 48755 | 6 | 1.016 | 47987.2 |
280 | 2020-01-31 00:55:47 | turner | 1 | 48755 | 6 | 1.313 | 37132.5 |
279 | 2020-01-28 12:28:04 | turner | 1 | 48755 | 6 | 0.733 | 66514.3 |
278 | 2020-01-27 07:14:15 | turner | 1 | 48755 | 6 | 0.906 | 53813.5 |
277 | 2020-01-22 10:55:39 | turner | 1 | 48755 | 6 | 1.843 | 26454.2 |
276 | 2020-01-15 02:46:28 | turner | 1 | 48755 | 6 | 0.843 | 57835.1 |
275 | 2020-01-14 02:39:51 | turner | 1 | 48755 | 6 | 2.953 | 16510.3 |
274 | 2020-01-11 18:16:52 | turner | 1 | 48755 | 6 | 0.940 | 51867.0 |
273 | 2020-01-11 14:11:30 | turner | 1 | 48755 | 6 | 0.843 | 57835.1 |
272 | 2020-01-09 14:55:54 | turner | 1 | 48755 | 6 | 0.750 | 65006.7 |