History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sprier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
399 | 2024-04-27 00:57:46 | sprier | 1 | 48755 | 5 | 3.220 | 15141.3 |
398 | 2024-04-22 05:33:34 | sprier | 1 | 48755 | 5 | 0.936 | 52088.7 |
397 | 2024-04-22 05:33:27 | sprier | 2 | 82551 | 124 | 2.983 | 27673.8 |
396 | 2024-04-03 10:32:56 | sprier | 1 | 48755 | 5 | 2.983 | 16344.3 |
395 | 2024-03-27 10:24:44 | sprier | 1 | 48755 | 5 | 1.110 | 43923.4 |
394 | 2024-03-04 11:54:33 | sprier | 1 | 48755 | 5 | 0.873 | 55847.7 |
393 | 2024-03-04 11:54:25 | sprier | 2 | 82551 | 124 | 3.173 | 26016.7 |
392 | 2024-03-04 09:26:22 | sprier | 2 | 82551 | 124 | 2.733 | 30205.3 |
391 | 2024-03-04 09:26:23 | sprier | 1 | 48755 | 5 | 1.843 | 26454.2 |
390 | 2024-02-25 23:11:10 | sprier | 1 | 48755 | 5 | 0.923 | 52822.3 |
389 | 2024-02-22 04:06:10 | sprier | 2 | 82551 | 124 | 5.783 | 14274.8 |
388 | 2024-01-14 11:50:23 | sprier | 2 | 82551 | 124 | 2.440 | 33832.4 |
387 | 2023-12-20 15:33:04 | sprier | 1 | 48755 | 5 | 0.780 | 62506.4 |
386 | 2023-12-09 11:52:39 | sprier | 2 | 82551 | 124 | 2.406 | 34310.5 |
385 | 2023-11-25 04:21:13 | sprier | 1 | 48755 | 5 | 0.830 | 58741.0 |
384 | 2023-11-18 13:13:08 | sprier | 1 | 48755 | 5 | 0.890 | 54780.9 |
383 | 2023-11-09 05:18:19 | sprier | 1 | 48755 | 5 | 0.890 | 54780.9 |
382 | 2023-11-05 21:03:22 | sprier | 1 | 48755 | 5 | 0.830 | 58741.0 |
381 | 2023-10-28 10:45:41 | sprier | 1 | 48755 | 5 | 0.830 | 58741.0 |
380 | 2023-10-24 02:54:41 | sprier | 1 | 48755 | 5 | 0.860 | 56691.9 |
379 | 2023-10-17 16:03:36 | sprier | 1 | 48755 | 5 | 0.983 | 49598.2 |
378 | 2023-10-14 02:42:12 | sprier | 1 | 48755 | 5 | 0.843 | 57835.1 |
377 | 2023-10-07 17:07:16 | sprier | 1 | 48755 | 5 | 0.766 | 63648.8 |
376 | 2023-10-07 00:52:20 | sprier | 1 | 48755 | 5 | 0.906 | 53813.5 |
375 | 2023-09-26 19:26:07 | sprier | 1 | 48755 | 5 | 0.860 | 56691.9 |
374 | 2023-09-22 15:45:32 | sprier | 1 | 48755 | 5 | 0.750 | 65006.7 |
373 | 2023-08-03 18:00:47 | sprier | 1 | 48755 | 5 | 0.766 | 63648.8 |
372 | 2023-07-06 18:26:30 | sprier | 1 | 48755 | 5 | 0.830 | 58741.0 |
371 | 2023-05-01 22:30:13 | sprier | 1 | 48755 | 5 | 0.856 | 56956.8 |
370 | 2023-03-13 06:22:44 | sprier | 1 | 48755 | 5 | 0.750 | 65006.7 |
369 | 2023-02-22 12:52:58 | sprier | 1 | 48755 | 5 | 0.766 | 63648.8 |
368 | 2022-12-20 01:18:04 | sprier | 1 | 48755 | 5 | 0.750 | 65006.7 |
367 | 2022-11-14 14:29:38 | sprier | 1 | 48755 | 5 | 0.936 | 52088.7 |
366 | 2022-09-15 02:19:41 | sprier | 1 | 48755 | 5 | 0.780 | 62506.4 |
365 | 2022-09-01 18:27:49 | sprier | 1 | 48755 | 5 | 0.750 | 65006.7 |
364 | 2022-09-01 08:25:59 | sprier | 1 | 48755 | 5 | 0.830 | 58741.0 |
363 | 2022-07-25 10:28:26 | sprier | 1 | 48755 | 5 | 0.763 | 63899.1 |
362 | 2022-07-18 01:20:32 | sprier | 1 | 48755 | 5 | 0.750 | 65006.7 |
361 | 2022-07-03 05:53:03 | sprier | 1 | 48755 | 5 | 0.766 | 63648.8 |
360 | 2022-06-09 02:06:09 | sprier | 1 | 48755 | 5 | 0.750 | 65006.7 |
359 | 2022-04-12 10:47:56 | sprier | 1 | 48755 | 5 | 0.983 | 49598.2 |
358 | 2022-04-10 05:10:57 | sprier | 1 | 48755 | 5 | 0.766 | 63648.8 |
357 | 2022-04-08 18:19:06 | sprier | 1 | 48755 | 5 | 0.763 | 63899.1 |
356 | 2022-03-30 22:34:06 | sprier | 1 | 48755 | 5 | 0.830 | 58741.0 |
355 | 2022-01-06 02:16:38 | sprier | 1 | 48755 | 5 | 0.813 | 59969.2 |
354 | 2022-01-03 23:25:40 | sprier | 1 | 48755 | 5 | 0.890 | 54780.9 |
353 | 2021-12-10 00:25:36 | sprier | 1 | 48755 | 5 | 0.846 | 57630.0 |
352 | 2021-12-06 17:57:53 | sprier | 1 | 48755 | 5 | 0.860 | 56691.9 |
351 | 2021-11-18 17:51:07 | sprier | 1 | 48755 | 5 | 1.016 | 47987.2 |
350 | 2021-11-12 08:21:25 | sprier | 1 | 48755 | 5 | 1.656 | 29441.4 |
349 | 2021-08-30 09:41:55 | sprier | 1 | 48755 | 5 | 0.843 | 57835.1 |
348 | 2021-08-08 12:09:53 | sprier | 1 | 48755 | 5 | 0.830 | 58741.0 |
347 | 2021-05-29 16:59:22 | sprier | 1 | 48755 | 5 | 0.890 | 54780.9 |
346 | 2021-05-24 22:22:21 | sprier | 1 | 48755 | 5 | 0.890 | 54780.9 |
345 | 2021-04-28 07:46:56 | sprier | 1 | 48755 | 5 | 0.873 | 55847.7 |
344 | 2021-04-18 10:41:26 | sprier | 1 | 48755 | 5 | 0.876 | 55656.4 |
343 | 2021-03-28 04:53:16 | sprier | 1 | 48755 | 5 | 0.860 | 56691.9 |
342 | 2021-02-26 22:38:33 | sprier | 1 | 48755 | 5 | 0.810 | 60191.4 |
341 | 2021-02-01 09:40:13 | sprier | 1 | 48755 | 5 | 0.763 | 63899.1 |
340 | 2021-01-11 11:33:07 | sprier | 1 | 48755 | 5 | 0.796 | 61250.0 |
339 | 2020-11-22 05:27:02 | sprier | 1 | 48755 | 5 | 0.750 | 65006.7 |
338 | 2020-10-23 06:45:42 | sprier | 1 | 48755 | 5 | 0.766 | 63648.8 |
337 | 2020-10-23 00:04:37 | sprier | 1 | 48755 | 5 | 0.830 | 58741.0 |
336 | 2020-09-29 09:30:22 | sprier | 1 | 48755 | 5 | 0.783 | 62266.9 |
335 | 2020-09-06 07:31:40 | sprier | 1 | 48755 | 5 | 0.843 | 57835.1 |
334 | 2020-08-31 15:33:35 | sprier | 1 | 48755 | 5 | 0.780 | 62506.4 |
333 | 2020-08-14 21:56:01 | sprier | 1 | 48755 | 5 | 0.780 | 62506.4 |
332 | 2020-08-14 15:29:13 | sprier | 1 | 48755 | 5 | 0.796 | 61250.0 |
331 | 2020-06-09 18:46:33 | sprier | 1 | 48755 | 5 | 0.826 | 59025.4 |
330 | 2020-05-07 18:33:36 | sprier | 1 | 48755 | 5 | 0.810 | 60191.4 |
329 | 2020-03-28 02:17:03 | sprier | 1 | 48755 | 5 | 1.016 | 47987.2 |
328 | 2020-03-24 09:40:50 | sprier | 1 | 48755 | 5 | 0.893 | 54596.9 |
327 | 2020-03-22 20:16:27 | sprier | 1 | 48755 | 5 | 0.876 | 55656.4 |
326 | 2020-03-18 19:44:17 | sprier | 1 | 48755 | 5 | 0.750 | 65006.7 |
325 | 2020-03-13 10:41:13 | sprier | 1 | 48755 | 5 | 0.856 | 56956.8 |
324 | 2020-02-26 17:34:55 | sprier | 1 | 48755 | 5 | 1.750 | 27860.0 |
323 | 2020-02-25 17:47:33 | sprier | 1 | 48755 | 5 | 1.030 | 47335.0 |
322 | 2020-02-23 15:34:32 | sprier | 1 | 48755 | 5 | 0.953 | 51159.5 |
321 | 2020-02-19 01:59:03 | sprier | 1 | 48755 | 5 | 0.903 | 53992.2 |
320 | 2020-02-16 18:38:48 | sprier | 1 | 48755 | 5 | 1.733 | 28133.3 |
319 | 2020-02-11 03:21:50 | sprier | 1 | 48755 | 5 | 0.890 | 54780.9 |
318 | 2020-02-05 04:36:42 | sprier | 1 | 48755 | 5 | 0.920 | 52994.6 |
317 | 2020-01-30 19:49:34 | sprier | 1 | 48755 | 5 | 0.923 | 52822.3 |
316 | 2020-01-30 19:13:37 | sprier | 1 | 48755 | 5 | 2.906 | 16777.4 |
315 | 2020-01-30 07:26:11 | sprier | 1 | 48755 | 5 | 0.953 | 51159.5 |
314 | 2020-01-26 20:54:35 | sprier | 1 | 48755 | 5 | 0.906 | 53813.5 |
313 | 2020-01-26 12:42:07 | sprier | 1 | 48755 | 5 | 0.890 | 54780.9 |
312 | 2020-01-22 17:25:20 | sprier | 1 | 48755 | 5 | 2.720 | 17924.6 |
311 | 2020-01-12 23:08:24 | sprier | 1 | 48755 | 5 | 1.923 | 25353.6 |
310 | 2020-01-12 08:44:48 | sprier | 1 | 48755 | 5 | 0.890 | 54780.9 |
309 | 2020-01-10 20:09:52 | sprier | 1 | 48755 | 5 | 1.250 | 39004.0 |
308 | 2020-01-03 15:34:44 | sprier | 1 | 48755 | 5 | 0.890 | 54780.9 |
307 | 2019-12-26 16:44:02 | sprier | 1 | 48755 | 5 | 0.966 | 50471.0 |
306 | 2019-12-26 11:20:18 | sprier | 1 | 48755 | 5 | 0.813 | 59969.2 |
305 | 2019-12-26 09:19:41 | sprier | 1 | 48755 | 5 | 0.923 | 52822.3 |
304 | 2019-12-26 05:39:01 | sprier | 1 | 48755 | 5 | 1.846 | 26411.2 |
303 | 2019-12-24 23:23:51 | sprier | 1 | 48755 | 5 | 0.750 | 65006.7 |
302 | 2019-11-15 18:14:47 | sprier | 1 | 48755 | 5 | 0.890 | 54780.9 |
301 | 2019-11-13 03:00:26 | sprier | 1 | 48755 | 5 | 0.733 | 66514.3 |
300 | 2019-11-04 11:51:27 | sprier | 1 | 48755 | 5 | 0.826 | 59025.4 |