History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nellie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
393 | 2024-04-06 10:00:35 | nellie | 1 | 48755 | 3 | 2.063 | 23633.1 |
392 | 2024-03-31 20:25:58 | nellie | 1 | 48755 | 3 | 1.876 | 25988.8 |
391 | 2024-03-28 12:32:17 | nellie | 1 | 48755 | 3 | 0.906 | 53813.5 |
390 | 2024-03-02 09:01:44 | nellie | 2 | 82551 | 37 | 2.406 | 34310.5 |
389 | 2024-03-02 09:01:16 | nellie | 3 | 112716 | 495 | 5.643 | 19974.5 |
388 | 2024-02-28 13:26:38 | nellie | 2 | 82551 | 37 | 2.593 | 31836.1 |
387 | 2024-02-28 13:26:18 | nellie | 3 | 112716 | 495 | 6.126 | 18399.6 |
386 | 2024-02-28 04:03:52 | nellie | 3 | 112716 | 495 | 8.860 | 12721.9 |
385 | 2024-02-28 04:03:50 | nellie | 2 | 82551 | 37 | 2.796 | 29524.7 |
384 | 2024-02-28 03:56:32 | nellie | 3 | 112716 | 495 | 6.703 | 16815.8 |
383 | 2024-02-28 03:56:29 | nellie | 2 | 82551 | 37 | 3.046 | 27101.4 |
382 | 2024-02-28 03:56:27 | nellie | 1 | 48755 | 3 | 0.873 | 55847.7 |
381 | 2024-02-14 18:48:42 | nellie | 1 | 48755 | 3 | 0.893 | 54596.9 |
380 | 2024-01-23 17:28:42 | nellie | 3 | 112716 | 495 | 10.876 | 10363.7 |
379 | 2024-01-21 08:15:51 | nellie | 3 | 112716 | 495 | 5.766 | 19548.4 |
378 | 2024-01-21 08:15:50 | nellie | 2 | 82551 | 37 | 2.593 | 31836.1 |
377 | 2024-01-05 14:40:55 | nellie | 3 | 112716 | 495 | 5.346 | 21084.2 |
376 | 2024-01-05 14:40:54 | nellie | 2 | 82551 | 37 | 2.343 | 35233.0 |
375 | 2024-01-02 04:07:34 | nellie | 2 | 82551 | 37 | 2.156 | 38289.0 |
374 | 2023-12-01 01:13:26 | nellie | 1 | 48755 | 3 | 0.830 | 58741.0 |
373 | 2023-11-18 03:09:56 | nellie | 1 | 48755 | 3 | 0.843 | 57835.1 |
372 | 2023-11-14 03:34:56 | nellie | 1 | 48755 | 3 | 1.580 | 30857.6 |
371 | 2023-11-04 09:37:56 | nellie | 1 | 48755 | 3 | 0.813 | 59969.2 |
370 | 2023-10-23 21:23:49 | nellie | 1 | 48755 | 3 | 0.736 | 66243.2 |
369 | 2023-10-22 14:19:13 | nellie | 1 | 48755 | 3 | 0.750 | 65006.7 |
368 | 2023-10-19 18:11:01 | nellie | 1 | 48755 | 3 | 0.826 | 59025.4 |
367 | 2023-10-11 06:09:43 | nellie | 1 | 48755 | 3 | 0.873 | 55847.7 |
366 | 2023-10-06 10:58:48 | nellie | 2 | 82551 | 37 | 8.236 | 10023.2 |
365 | 2023-10-06 03:22:04 | nellie | 1 | 48755 | 3 | 1.750 | 27860.0 |
364 | 2023-09-26 07:40:23 | nellie | 1 | 48755 | 3 | 0.750 | 65006.7 |
363 | 2023-09-16 12:07:36 | nellie | 1 | 48755 | 3 | 0.936 | 52088.7 |
362 | 2023-09-15 22:33:40 | nellie | 1 | 48755 | 3 | 0.826 | 59025.4 |
361 | 2023-07-18 10:25:28 | nellie | 2 | 82551 | 37 | 2.173 | 37989.4 |
360 | 2023-06-29 12:06:24 | nellie | 1 | 48755 | 3 | 0.750 | 65006.7 |
359 | 2023-06-27 03:39:32 | nellie | 1 | 48755 | 3 | 0.780 | 62506.4 |
358 | 2023-05-28 15:42:40 | nellie | 1 | 48755 | 3 | 0.733 | 66514.3 |
357 | 2023-04-06 13:15:04 | nellie | 1 | 48755 | 3 | 0.750 | 65006.7 |
356 | 2023-04-02 11:42:31 | nellie | 2 | 82551 | 37 | 2.420 | 34112.0 |
355 | 2023-03-13 11:10:40 | nellie | 1 | 48755 | 3 | 0.813 | 59969.2 |
354 | 2023-01-26 17:57:49 | nellie | 3 | 112716 | 495 | 4.673 | 24120.7 |
353 | 2023-01-26 17:57:47 | nellie | 2 | 82551 | 37 | 2.093 | 39441.5 |
352 | 2023-01-26 16:59:30 | nellie | 1 | 48755 | 3 | 0.720 | 67715.3 |
351 | 2023-01-20 03:39:55 | nellie | 1 | 48755 | 3 | 0.783 | 62266.9 |
350 | 2022-12-30 03:02:27 | nellie | 2 | 82551 | 37 | 2.200 | 37523.2 |
349 | 2022-11-18 09:31:32 | nellie | 1 | 48755 | 3 | 0.813 | 59969.2 |
348 | 2022-11-17 23:27:46 | nellie | 1 | 48755 | 3 | 0.733 | 66514.3 |
347 | 2022-09-02 04:10:45 | nellie | 2 | 82551 | 37 | 2.440 | 33832.4 |
346 | 2022-07-25 15:19:21 | nellie | 1 | 48755 | 3 | 0.750 | 65006.7 |
345 | 2022-07-08 15:35:53 | nellie | 1 | 48755 | 3 | 0.736 | 66243.2 |
344 | 2022-03-31 03:45:11 | nellie | 1 | 48755 | 3 | 1.200 | 40629.2 |
343 | 2022-03-13 10:10:41 | nellie | 1 | 48755 | 3 | 0.750 | 65006.7 |
342 | 2022-03-11 06:17:26 | nellie | 1 | 48755 | 3 | 0.750 | 65006.7 |
341 | 2022-02-04 13:05:18 | nellie | 1 | 48755 | 3 | 0.750 | 65006.7 |
340 | 2022-01-05 11:52:29 | nellie | 1 | 48755 | 3 | 0.843 | 57835.1 |
339 | 2021-12-13 11:04:18 | nellie | 1 | 48755 | 3 | 0.830 | 58741.0 |
338 | 2021-09-26 19:48:28 | nellie | 3 | 112716 | 495 | 5.203 | 21663.7 |
337 | 2021-09-22 13:17:45 | nellie | 3 | 112716 | 495 | 5.390 | 20912.1 |
336 | 2021-09-22 08:16:22 | nellie | 1 | 48755 | 3 | 0.783 | 62266.9 |
335 | 2021-09-15 02:33:57 | nellie | 1 | 48755 | 3 | 0.843 | 57835.1 |
334 | 2021-09-02 21:44:13 | nellie | 1 | 48755 | 3 | 0.830 | 58741.0 |
333 | 2021-05-29 21:38:42 | nellie | 1 | 48755 | 3 | 0.890 | 54780.9 |
332 | 2021-05-29 15:18:49 | nellie | 1 | 48755 | 3 | 0.813 | 59969.2 |
331 | 2021-05-04 03:37:59 | nellie | 1 | 48755 | 3 | 0.826 | 59025.4 |
330 | 2021-03-26 02:43:01 | nellie | 2 | 82551 | 37 | 2.143 | 38521.2 |
329 | 2021-03-26 02:35:48 | nellie | 1 | 48755 | 3 | 0.780 | 62506.4 |
328 | 2021-02-27 05:47:07 | nellie | 1 | 48755 | 3 | 0.733 | 66514.3 |
327 | 2021-01-17 06:47:56 | nellie | 1 | 48755 | 3 | 0.736 | 66243.2 |
326 | 2020-12-18 03:09:41 | nellie | 1 | 48755 | 3 | 0.733 | 66514.3 |
325 | 2020-11-22 17:06:31 | nellie | 1 | 48755 | 3 | 0.733 | 66514.3 |
324 | 2020-11-22 12:30:04 | nellie | 1 | 48755 | 3 | 0.750 | 65006.7 |
323 | 2020-10-28 22:35:23 | nellie | 1 | 48755 | 3 | 0.843 | 57835.1 |
322 | 2020-10-04 22:11:02 | nellie | 1 | 48755 | 3 | 0.843 | 57835.1 |
321 | 2020-09-09 14:38:25 | nellie | 1 | 48755 | 3 | 0.750 | 65006.7 |
320 | 2020-09-07 08:15:43 | nellie | 1 | 48755 | 3 | 0.720 | 67715.3 |
319 | 2020-09-01 19:51:18 | nellie | 1 | 48755 | 3 | 0.830 | 58741.0 |
318 | 2020-08-12 01:44:46 | nellie | 1 | 48755 | 3 | 0.750 | 65006.7 |
317 | 2020-07-28 14:00:37 | nellie | 1 | 48755 | 3 | 0.813 | 59969.2 |
316 | 2020-06-20 21:21:05 | nellie | 1 | 48755 | 3 | 1.123 | 43415.0 |
315 | 2020-05-07 22:38:53 | nellie | 1 | 48755 | 3 | 0.920 | 52994.6 |
314 | 2020-03-29 22:16:01 | nellie | 1 | 48755 | 3 | 1.783 | 27344.4 |
313 | 2020-03-27 21:34:06 | nellie | 1 | 48755 | 3 | 0.843 | 57835.1 |
312 | 2020-03-24 20:19:55 | nellie | 1 | 48755 | 3 | 1.876 | 25988.8 |
311 | 2020-03-24 02:39:59 | nellie | 1 | 48755 | 3 | 0.890 | 54780.9 |
310 | 2020-03-22 16:29:00 | nellie | 1 | 48755 | 3 | 0.860 | 56691.9 |
309 | 2020-03-19 20:14:06 | nellie | 1 | 48755 | 3 | 0.826 | 59025.4 |
308 | 2020-03-19 13:35:26 | nellie | 1 | 48755 | 3 | 0.986 | 49447.3 |
307 | 2020-02-23 10:18:05 | nellie | 1 | 48755 | 3 | 0.936 | 52088.7 |
306 | 2020-02-20 15:55:40 | nellie | 1 | 48755 | 3 | 0.860 | 56691.9 |
305 | 2020-02-14 07:01:56 | nellie | 1 | 48755 | 3 | 0.966 | 50471.0 |
304 | 2020-02-06 10:27:55 | nellie | 1 | 48755 | 3 | 0.830 | 58741.0 |
303 | 2020-02-05 08:45:07 | nellie | 1 | 48755 | 3 | 0.843 | 57835.1 |
302 | 2020-02-04 07:01:35 | nellie | 1 | 48755 | 3 | 1.453 | 33554.7 |
301 | 2020-02-01 04:28:56 | nellie | 1 | 48755 | 3 | 0.923 | 52822.3 |
300 | 2020-01-31 12:50:39 | nellie | 1 | 48755 | 3 | 2.313 | 21078.7 |
299 | 2020-01-27 00:19:59 | nellie | 1 | 48755 | 3 | 1.593 | 30605.8 |
298 | 2020-01-23 04:15:47 | nellie | 1 | 48755 | 3 | 1.906 | 25579.7 |
297 | 2020-01-23 00:24:32 | nellie | 1 | 48755 | 3 | 2.190 | 22262.6 |
296 | 2020-01-15 15:13:14 | nellie | 1 | 48755 | 3 | 0.970 | 50262.9 |
295 | 2020-01-15 07:14:45 | nellie | 1 | 48755 | 3 | 0.860 | 56691.9 |
294 | 2020-01-11 20:36:47 | nellie | 1 | 48755 | 3 | 0.810 | 60191.4 |