History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
453 | 2024-03-29 06:25:09 | sparks | 1 | 48755 | 10 | 1.936 | 25183.4 |
452 | 2024-03-29 05:11:29 | sparks | 2 | 82551 | 141 | 5.580 | 14794.1 |
451 | 2024-03-29 05:11:24 | sparks | 1 | 48755 | 10 | 2.046 | 23829.4 |
450 | 2024-03-29 05:11:04 | sparks | 2 | 82551 | 141 | 7.500 | 11006.8 |
449 | 2024-03-23 21:25:35 | sparks | 2 | 82551 | 141 | 2.186 | 37763.5 |
448 | 2024-03-04 07:30:28 | sparks | 1 | 48755 | 10 | 1.063 | 45865.5 |
447 | 2024-02-28 10:29:58 | sparks | 1 | 48755 | 10 | 2.156 | 22613.6 |
446 | 2024-02-22 16:24:35 | sparks | 1 | 48755 | 10 | 0.906 | 53813.5 |
445 | 2024-01-22 10:52:33 | sparks | 2 | 82551 | 141 | 2.920 | 28270.9 |
444 | 2024-01-20 18:06:34 | sparks | 2 | 82551 | 141 | 2.703 | 30540.5 |
443 | 2024-01-10 20:27:00 | sparks | 2 | 82551 | 141 | 2.780 | 29694.6 |
442 | 2023-12-23 19:15:38 | sparks | 1 | 48755 | 10 | 0.813 | 59969.2 |
441 | 2023-12-06 07:02:42 | sparks | 1 | 48755 | 10 | 0.890 | 54780.9 |
440 | 2023-12-03 10:14:04 | sparks | 2 | 82551 | 141 | 2.500 | 33020.4 |
439 | 2023-12-03 10:14:01 | sparks | 2 | 82551 | 141 | 2.513 | 32849.6 |
438 | 2023-11-30 16:10:44 | sparks | 2 | 82551 | 141 | 2.170 | 38041.9 |
437 | 2023-11-22 04:31:02 | sparks | 1 | 48755 | 10 | 0.780 | 62506.4 |
436 | 2023-11-18 14:18:22 | sparks | 1 | 48755 | 10 | 1.156 | 42175.6 |
435 | 2023-11-18 05:47:03 | sparks | 1 | 48755 | 10 | 0.763 | 63899.1 |
434 | 2023-11-01 04:52:24 | sparks | 1 | 48755 | 10 | 0.750 | 65006.7 |
433 | 2023-10-31 07:50:41 | sparks | 1 | 48755 | 10 | 0.733 | 66514.3 |
432 | 2023-10-20 16:50:23 | sparks | 1 | 48755 | 10 | 1.593 | 30605.8 |
431 | 2023-10-17 14:22:25 | sparks | 1 | 48755 | 10 | 0.780 | 62506.4 |
430 | 2023-10-14 02:34:02 | sparks | 1 | 48755 | 10 | 0.780 | 62506.4 |
429 | 2023-09-26 19:25:04 | sparks | 1 | 48755 | 10 | 0.796 | 61250.0 |
428 | 2023-09-20 02:36:46 | sparks | 1 | 48755 | 10 | 0.843 | 57835.1 |
427 | 2023-09-14 09:24:48 | sparks | 1 | 48755 | 10 | 0.890 | 54780.9 |
426 | 2023-08-29 09:30:08 | sparks | 2 | 82551 | 141 | 4.300 | 19197.9 |
425 | 2023-07-15 00:19:14 | sparks | 1 | 48755 | 10 | 0.766 | 63648.8 |
424 | 2023-06-23 08:42:44 | sparks | 1 | 48755 | 10 | 0.843 | 57835.1 |
423 | 2023-05-14 17:16:48 | sparks | 2 | 82551 | 141 | 2.266 | 36430.3 |
422 | 2023-04-20 10:40:08 | sparks | 1 | 48755 | 10 | 0.750 | 65006.7 |
421 | 2023-02-22 06:56:08 | sparks | 1 | 48755 | 10 | 0.846 | 57630.0 |
420 | 2023-02-21 04:30:06 | sparks | 2 | 82551 | 141 | 2.220 | 37185.1 |
419 | 2023-02-05 16:15:23 | sparks | 1 | 48755 | 10 | 0.750 | 65006.7 |
418 | 2022-12-04 11:52:54 | sparks | 1 | 48755 | 10 | 0.830 | 58741.0 |
417 | 2022-12-02 02:34:34 | sparks | 2 | 82551 | 141 | 2.203 | 37472.1 |
416 | 2022-10-22 00:40:19 | sparks | 1 | 48755 | 10 | 0.750 | 65006.7 |
415 | 2022-08-02 16:52:15 | sparks | 1 | 48755 | 10 | 0.766 | 63648.8 |
414 | 2022-07-29 05:05:12 | sparks | 1 | 48755 | 10 | 0.856 | 56956.8 |
413 | 2022-07-09 18:06:41 | sparks | 2 | 82551 | 141 | 2.173 | 37989.4 |
412 | 2022-06-24 09:07:04 | sparks | 1 | 48755 | 10 | 0.763 | 63899.1 |
411 | 2022-06-12 00:43:08 | sparks | 2 | 82551 | 141 | 2.156 | 38289.0 |
410 | 2022-05-18 16:15:41 | sparks | 2 | 82551 | 141 | 2.436 | 33887.9 |
409 | 2022-05-16 07:29:19 | sparks | 1 | 48755 | 10 | 0.906 | 53813.5 |
408 | 2022-03-27 21:33:07 | sparks | 1 | 48755 | 10 | 0.736 | 66243.2 |
407 | 2022-02-18 16:20:39 | sparks | 2 | 82551 | 141 | 3.063 | 26951.0 |
406 | 2022-02-15 20:27:07 | sparks | 1 | 48755 | 10 | 0.813 | 59969.2 |
405 | 2021-12-31 16:00:28 | sparks | 1 | 48755 | 10 | 0.843 | 57835.1 |
404 | 2021-11-19 03:53:47 | sparks | 2 | 82551 | 141 | 2.686 | 30733.8 |
403 | 2021-11-01 03:25:03 | sparks | 1 | 48755 | 10 | 0.766 | 63648.8 |
402 | 2021-10-30 03:22:02 | sparks | 1 | 48755 | 10 | 0.763 | 63899.1 |
401 | 2021-10-28 15:51:36 | sparks | 1 | 48755 | 10 | 0.873 | 55847.7 |
400 | 2021-09-27 09:30:25 | sparks | 1 | 48755 | 10 | 0.923 | 52822.3 |
399 | 2021-09-26 18:03:00 | sparks | 1 | 48755 | 10 | 0.843 | 57835.1 |
398 | 2021-09-21 22:54:55 | sparks | 1 | 48755 | 10 | 0.846 | 57630.0 |
397 | 2021-09-20 15:27:39 | sparks | 1 | 48755 | 10 | 0.780 | 62506.4 |
396 | 2021-09-18 11:36:14 | sparks | 1 | 48755 | 10 | 0.750 | 65006.7 |
395 | 2021-09-03 05:12:20 | sparks | 1 | 48755 | 10 | 0.860 | 56691.9 |
394 | 2021-07-22 05:05:25 | sparks | 1 | 48755 | 10 | 0.780 | 62506.4 |
393 | 2021-06-30 23:33:33 | sparks | 1 | 48755 | 10 | 0.890 | 54780.9 |
392 | 2021-06-02 07:08:24 | sparks | 1 | 48755 | 10 | 0.843 | 57835.1 |
391 | 2021-05-15 00:56:48 | sparks | 2 | 82551 | 141 | 2.483 | 33246.5 |
390 | 2021-05-08 00:06:43 | sparks | 1 | 48755 | 10 | 0.780 | 62506.4 |
389 | 2021-04-24 18:02:55 | sparks | 1 | 48755 | 10 | 0.890 | 54780.9 |
388 | 2021-04-19 10:46:17 | sparks | 1 | 48755 | 10 | 0.890 | 54780.9 |
387 | 2021-04-06 07:58:33 | sparks | 1 | 48755 | 10 | 0.843 | 57835.1 |
386 | 2021-03-10 15:40:30 | sparks | 1 | 48755 | 10 | 0.830 | 58741.0 |
385 | 2021-02-23 19:08:44 | sparks | 1 | 48755 | 10 | 0.810 | 60191.4 |
384 | 2021-01-30 15:31:54 | sparks | 1 | 48755 | 10 | 0.766 | 63648.8 |
383 | 2021-01-27 17:43:53 | sparks | 2 | 82551 | 141 | 2.233 | 36968.7 |
382 | 2021-01-26 07:38:56 | sparks | 1 | 48755 | 10 | 0.750 | 65006.7 |
381 | 2021-01-21 15:31:54 | sparks | 1 | 48755 | 10 | 0.796 | 61250.0 |
380 | 2020-12-29 23:56:20 | sparks | 2 | 82551 | 141 | 2.220 | 37185.1 |
379 | 2020-12-29 08:40:49 | sparks | 1 | 48755 | 10 | 0.826 | 59025.4 |
378 | 2020-11-08 05:18:42 | sparks | 2 | 82551 | 141 | 2.530 | 32628.9 |
377 | 2020-11-03 05:30:02 | sparks | 1 | 48755 | 10 | 0.860 | 56691.9 |
376 | 2020-11-02 07:38:39 | sparks | 1 | 48755 | 10 | 1.483 | 32875.9 |
375 | 2020-10-25 07:32:12 | sparks | 1 | 48755 | 10 | 0.780 | 62506.4 |
374 | 2020-10-20 19:05:58 | sparks | 1 | 48755 | 10 | 0.780 | 62506.4 |
373 | 2020-10-08 02:06:58 | sparks | 1 | 48755 | 10 | 0.780 | 62506.4 |
372 | 2020-10-06 23:54:43 | sparks | 1 | 48755 | 10 | 0.846 | 57630.0 |
371 | 2020-09-26 00:11:45 | sparks | 1 | 48755 | 10 | 0.766 | 63648.8 |
370 | 2020-08-08 18:58:03 | sparks | 1 | 48755 | 10 | 0.873 | 55847.7 |
369 | 2020-08-01 03:26:25 | sparks | 1 | 48755 | 10 | 0.876 | 55656.4 |
368 | 2020-07-23 00:08:19 | sparks | 1 | 48755 | 10 | 0.890 | 54780.9 |
367 | 2020-06-14 05:52:30 | sparks | 1 | 48755 | 10 | 0.783 | 62266.9 |
366 | 2020-05-16 15:40:59 | sparks | 1 | 48755 | 10 | 0.733 | 66514.3 |
365 | 2020-03-29 17:26:05 | sparks | 1 | 48755 | 10 | 0.750 | 65006.7 |
364 | 2020-03-28 01:40:38 | sparks | 1 | 48755 | 10 | 0.940 | 51867.0 |
363 | 2020-03-23 02:06:50 | sparks | 1 | 48755 | 10 | 1.030 | 47335.0 |
362 | 2020-03-22 23:26:10 | sparks | 1 | 48755 | 10 | 0.860 | 56691.9 |
361 | 2020-03-18 18:31:04 | sparks | 1 | 48755 | 10 | 0.813 | 59969.2 |
360 | 2020-03-09 15:55:32 | sparks | 1 | 48755 | 10 | 0.843 | 57835.1 |
359 | 2020-02-22 21:59:29 | sparks | 1 | 48755 | 10 | 0.906 | 53813.5 |
358 | 2020-02-19 15:19:07 | sparks | 1 | 48755 | 10 | 1.873 | 26030.4 |
357 | 2020-02-14 23:40:53 | sparks | 1 | 48755 | 10 | 0.873 | 55847.7 |
356 | 2020-02-12 13:27:30 | sparks | 1 | 48755 | 10 | 2.076 | 23485.1 |
355 | 2020-02-02 22:10:32 | sparks | 1 | 48755 | 10 | 0.983 | 49598.2 |
354 | 2020-02-01 02:47:17 | sparks | 1 | 48755 | 10 | 1.016 | 47987.2 |