History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparky"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
419 | 2024-05-04 01:53:57 | sparky | 1 | 48755 | 7 | 0.890 | 54780.9 |
418 | 2024-04-25 22:21:27 | sparky | 1 | 48755 | 7 | 0.940 | 51867.0 |
417 | 2024-04-19 05:34:32 | sparky | 1 | 48755 | 7 | 1.016 | 47987.2 |
416 | 2024-04-03 11:20:02 | sparky | 1 | 48755 | 7 | 2.940 | 16583.3 |
415 | 2024-03-31 17:56:18 | sparky | 1 | 48755 | 7 | 2.173 | 22436.7 |
414 | 2024-03-13 09:51:59 | sparky | 1 | 48755 | 7 | 0.953 | 51159.5 |
413 | 2024-03-05 18:54:18 | sparky | 3 | 112716 | 658 | 33.550 | 3359.6 |
412 | 2024-03-05 17:53:34 | sparky | 2 | 82551 | 72 | 6.140 | 13444.8 |
411 | 2024-03-05 03:39:51 | sparky | 2 | 82551 | 72 | 7.016 | 11766.1 |
410 | 2024-03-05 03:31:54 | sparky | 3 | 112716 | 658 | 6.310 | 17863.1 |
409 | 2024-03-04 14:25:47 | sparky | 3 | 112716 | 658 | 11.860 | 9503.9 |
408 | 2024-03-04 14:25:48 | sparky | 2 | 82551 | 72 | 6.220 | 13271.9 |
407 | 2024-03-04 14:17:35 | sparky | 2 | 82551 | 72 | 2.920 | 28270.9 |
406 | 2024-03-04 14:17:23 | sparky | 1 | 48755 | 7 | 0.970 | 50262.9 |
405 | 2024-03-04 14:14:57 | sparky | 3 | 112716 | 658 | 7.173 | 15713.9 |
404 | 2024-03-04 09:35:56 | sparky | 3 | 112716 | 658 | 15.703 | 7178.0 |
403 | 2024-03-04 09:35:55 | sparky | 2 | 82551 | 72 | 7.986 | 10337.0 |
402 | 2024-03-04 09:35:54 | sparky | 1 | 48755 | 7 | 1.986 | 24549.3 |
401 | 2024-02-12 19:30:30 | sparky | 1 | 48755 | 7 | 0.766 | 63648.8 |
400 | 2024-01-20 08:56:45 | sparky | 3 | 112716 | 658 | 5.296 | 21283.2 |
399 | 2024-01-20 08:56:46 | sparky | 2 | 82551 | 72 | 2.500 | 33020.4 |
398 | 2024-01-08 21:47:03 | sparky | 2 | 82551 | 72 | 2.453 | 33653.1 |
397 | 2023-12-13 12:06:37 | sparky | 1 | 48755 | 7 | 0.766 | 63648.8 |
396 | 2023-12-01 14:31:24 | sparky | 3 | 112716 | 658 | 5.156 | 21861.1 |
395 | 2023-12-01 14:31:11 | sparky | 2 | 82551 | 72 | 2.343 | 35233.0 |
394 | 2023-11-28 02:34:31 | sparky | 1 | 48755 | 7 | 0.873 | 55847.7 |
393 | 2023-11-18 05:16:13 | sparky | 1 | 48755 | 7 | 0.766 | 63648.8 |
392 | 2023-11-10 03:09:14 | sparky | 1 | 48755 | 7 | 0.830 | 58741.0 |
391 | 2023-11-04 00:48:52 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
390 | 2023-11-01 02:20:49 | sparky | 1 | 48755 | 7 | 0.843 | 57835.1 |
389 | 2023-10-31 18:33:03 | sparky | 1 | 48755 | 7 | 0.936 | 52088.7 |
388 | 2023-10-20 16:50:26 | sparky | 1 | 48755 | 7 | 0.876 | 55656.4 |
387 | 2023-10-15 01:58:11 | sparky | 2 | 82551 | 72 | 2.156 | 38289.0 |
386 | 2023-10-14 00:42:39 | sparky | 1 | 48755 | 7 | 0.840 | 58041.7 |
385 | 2023-10-08 04:42:22 | sparky | 1 | 48755 | 7 | 0.846 | 57630.0 |
384 | 2023-09-30 10:30:29 | sparky | 1 | 48755 | 7 | 0.763 | 63899.1 |
383 | 2023-09-26 11:43:30 | sparky | 1 | 48755 | 7 | 0.826 | 59025.4 |
382 | 2023-09-26 01:01:19 | sparky | 1 | 48755 | 7 | 0.936 | 52088.7 |
381 | 2023-07-27 18:08:50 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
380 | 2023-07-25 08:30:50 | sparky | 2 | 82551 | 72 | 2.143 | 38521.2 |
379 | 2023-06-27 01:50:34 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
378 | 2023-04-24 03:40:43 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
377 | 2023-04-04 09:13:41 | sparky | 2 | 82551 | 72 | 2.143 | 38521.2 |
376 | 2023-03-04 10:18:12 | sparky | 3 | 112716 | 658 | 4.593 | 24540.8 |
375 | 2023-03-04 08:01:45 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
374 | 2023-02-19 00:02:36 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
373 | 2023-02-16 12:47:17 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
372 | 2022-12-30 19:23:59 | sparky | 2 | 82551 | 72 | 2.110 | 39123.7 |
371 | 2022-12-15 18:50:18 | sparky | 1 | 48755 | 7 | 0.890 | 54780.9 |
370 | 2022-10-07 10:43:30 | sparky | 1 | 48755 | 7 | 0.766 | 63648.8 |
369 | 2022-10-03 21:36:42 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
368 | 2022-09-03 20:38:17 | sparky | 1 | 48755 | 7 | 0.796 | 61250.0 |
367 | 2022-08-31 22:21:22 | sparky | 2 | 82551 | 72 | 2.533 | 32590.2 |
366 | 2022-08-25 22:00:23 | sparky | 1 | 48755 | 7 | 0.763 | 63899.1 |
365 | 2022-08-23 12:46:53 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
364 | 2022-06-30 10:33:18 | sparky | 1 | 48755 | 7 | 0.766 | 63648.8 |
363 | 2022-06-18 13:24:42 | sparky | 1 | 48755 | 7 | 0.810 | 60191.4 |
362 | 2022-05-24 00:25:11 | sparky | 1 | 48755 | 7 | 0.783 | 62266.9 |
361 | 2022-05-17 02:38:14 | sparky | 1 | 48755 | 7 | 0.906 | 53813.5 |
360 | 2022-05-16 03:28:26 | sparky | 1 | 48755 | 7 | 0.953 | 51159.5 |
359 | 2022-04-13 00:19:35 | sparky | 1 | 48755 | 7 | 1.593 | 30605.8 |
358 | 2022-04-09 08:32:36 | sparky | 1 | 48755 | 7 | 0.766 | 63648.8 |
357 | 2022-01-22 07:32:38 | sparky | 1 | 48755 | 7 | 0.920 | 52994.6 |
356 | 2022-01-17 02:51:19 | sparky | 1 | 48755 | 7 | 0.876 | 55656.4 |
355 | 2022-01-16 16:03:50 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
354 | 2022-01-16 07:17:00 | sparky | 1 | 48755 | 7 | 0.873 | 55847.7 |
353 | 2022-01-15 23:09:42 | sparky | 1 | 48755 | 7 | 0.920 | 52994.6 |
352 | 2022-01-15 15:27:17 | sparky | 1 | 48755 | 7 | 0.826 | 59025.4 |
351 | 2022-01-15 05:13:11 | sparky | 1 | 48755 | 7 | 0.860 | 56691.9 |
350 | 2022-01-14 17:26:04 | sparky | 1 | 48755 | 7 | 0.906 | 53813.5 |
349 | 2022-01-13 23:02:53 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
348 | 2022-01-13 12:06:10 | sparky | 1 | 48755 | 7 | 0.830 | 58741.0 |
347 | 2022-01-10 23:02:23 | sparky | 1 | 48755 | 7 | 0.876 | 55656.4 |
346 | 2021-12-17 14:23:12 | sparky | 1 | 48755 | 7 | 0.780 | 62506.4 |
345 | 2021-12-17 03:04:54 | sparky | 1 | 48755 | 7 | 0.780 | 62506.4 |
344 | 2021-12-16 20:14:35 | sparky | 1 | 48755 | 7 | 0.860 | 56691.9 |
343 | 2021-12-16 07:50:11 | sparky | 1 | 48755 | 7 | 0.813 | 59969.2 |
342 | 2021-12-15 22:15:09 | sparky | 1 | 48755 | 7 | 0.750 | 65006.7 |
341 | 2021-12-15 05:24:27 | sparky | 1 | 48755 | 7 | 0.843 | 57835.1 |
340 | 2021-12-14 18:59:40 | sparky | 1 | 48755 | 7 | 0.876 | 55656.4 |
339 | 2021-12-14 07:01:23 | sparky | 1 | 48755 | 7 | 0.826 | 59025.4 |
338 | 2021-12-13 14:57:32 | sparky | 1 | 48755 | 7 | 0.830 | 58741.0 |
337 | 2021-12-12 21:03:34 | sparky | 1 | 48755 | 7 | 0.966 | 50471.0 |
336 | 2021-12-12 09:54:19 | sparky | 1 | 48755 | 7 | 1.830 | 26642.1 |
335 | 2021-12-12 00:28:05 | sparky | 1 | 48755 | 7 | 0.903 | 53992.2 |
334 | 2021-12-08 05:01:42 | sparky | 1 | 48755 | 7 | 0.780 | 62506.4 |
333 | 2021-12-07 18:46:07 | sparky | 1 | 48755 | 7 | 0.843 | 57835.1 |
332 | 2021-12-07 09:53:47 | sparky | 1 | 48755 | 7 | 0.843 | 57835.1 |
331 | 2021-12-06 21:32:05 | sparky | 1 | 48755 | 7 | 0.826 | 59025.4 |
330 | 2021-12-06 02:29:57 | sparky | 1 | 48755 | 7 | 0.846 | 57630.0 |
329 | 2021-12-05 14:45:57 | sparky | 1 | 48755 | 7 | 0.843 | 57835.1 |
328 | 2021-11-07 01:17:16 | sparky | 1 | 48755 | 7 | 0.766 | 63648.8 |
327 | 2021-10-26 18:52:47 | sparky | 1 | 48755 | 7 | 0.856 | 56956.8 |
326 | 2021-10-26 08:18:34 | sparky | 1 | 48755 | 7 | 0.826 | 59025.4 |
325 | 2021-10-25 14:42:21 | sparky | 1 | 48755 | 7 | 1.733 | 28133.3 |
324 | 2021-10-25 08:44:08 | sparky | 1 | 48755 | 7 | 1.720 | 28345.9 |
323 | 2021-10-24 20:48:35 | sparky | 1 | 48755 | 7 | 0.860 | 56691.9 |
322 | 2021-10-24 12:49:12 | sparky | 1 | 48755 | 7 | 0.763 | 63899.1 |
321 | 2021-10-24 02:22:22 | sparky | 1 | 48755 | 7 | 0.890 | 54780.9 |
320 | 2021-10-23 20:41:29 | sparky | 1 | 48755 | 7 | 0.860 | 56691.9 |