History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparge"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
460 | 2024-04-26 22:29:19 | sparge | 1 | 48755 | 9 | 1.750 | 27860.0 |
459 | 2024-04-07 20:58:49 | sparge | 2 | 82551 | 76 | 7.673 | 10758.6 |
458 | 2024-04-07 20:57:59 | sparge | 3 | 112716 | 773 | 7.576 | 14878.0 |
457 | 2024-04-07 18:23:02 | sparge | 3 | 112716 | 773 | 14.080 | 8005.4 |
456 | 2024-04-04 02:13:46 | sparge | 2 | 82551 | 76 | 7.716 | 10698.7 |
455 | 2024-04-04 02:13:07 | sparge | 3 | 112716 | 773 | 6.843 | 16471.7 |
454 | 2024-04-03 22:40:02 | sparge | 3 | 112716 | 773 | 13.516 | 8339.4 |
453 | 2024-04-03 11:22:20 | sparge | 3 | 112716 | 773 | 14.686 | 7675.1 |
452 | 2024-04-03 11:22:21 | sparge | 2 | 82551 | 76 | 8.783 | 9399.0 |
451 | 2024-04-03 11:22:13 | sparge | 1 | 48755 | 9 | 0.970 | 50262.9 |
450 | 2024-04-03 11:21:58 | sparge | 3 | 112716 | 773 | 10.220 | 11029.0 |
449 | 2024-04-03 11:21:59 | sparge | 2 | 82551 | 76 | 7.126 | 11584.5 |
448 | 2024-04-03 11:21:56 | sparge | 1 | 48755 | 9 | 1.890 | 25796.3 |
447 | 2024-03-30 00:56:34 | sparge | 1 | 48755 | 9 | 1.266 | 38511.1 |
446 | 2024-03-29 06:27:24 | sparge | 1 | 48755 | 9 | 2.923 | 16679.8 |
445 | 2024-03-04 07:36:37 | sparge | 1 | 48755 | 9 | 1.800 | 27086.1 |
444 | 2024-02-29 03:44:56 | sparge | 2 | 82551 | 76 | 2.143 | 38521.2 |
443 | 2024-02-29 03:39:57 | sparge | 3 | 112716 | 773 | 5.546 | 20323.8 |
442 | 2024-02-28 06:23:25 | sparge | 2 | 82551 | 76 | 3.703 | 22293.0 |
441 | 2024-02-28 06:22:59 | sparge | 3 | 112716 | 773 | 5.953 | 18934.3 |
440 | 2024-02-27 21:27:12 | sparge | 2 | 82551 | 76 | 5.796 | 14242.8 |
439 | 2024-02-27 21:27:14 | sparge | 1 | 48755 | 9 | 1.563 | 31193.2 |
438 | 2024-02-25 20:32:25 | sparge | 3 | 112716 | 773 | 6.263 | 17997.1 |
437 | 2024-02-22 13:41:54 | sparge | 3 | 112716 | 773 | 14.096 | 7996.3 |
436 | 2024-02-22 13:41:54 | sparge | 2 | 82551 | 76 | 8.080 | 10216.7 |
435 | 2024-01-12 18:07:03 | sparge | 3 | 112716 | 773 | 9.000 | 12524.0 |
434 | 2024-01-12 18:07:05 | sparge | 2 | 82551 | 76 | 2.813 | 29346.2 |
433 | 2024-01-08 19:34:06 | sparge | 1 | 48755 | 9 | 0.843 | 57835.1 |
432 | 2024-01-04 13:48:09 | sparge | 2 | 82551 | 76 | 2.266 | 36430.3 |
431 | 2024-01-04 05:00:58 | sparge | 3 | 112716 | 773 | 4.860 | 23192.6 |
430 | 2023-11-21 18:33:52 | sparge | 1 | 48755 | 9 | 0.830 | 58741.0 |
429 | 2023-11-20 08:47:06 | sparge | 1 | 48755 | 9 | 0.763 | 63899.1 |
428 | 2023-11-17 05:58:56 | sparge | 1 | 48755 | 9 | 0.843 | 57835.1 |
427 | 2023-11-01 09:04:02 | sparge | 1 | 48755 | 9 | 0.840 | 58041.7 |
426 | 2023-10-31 06:57:06 | sparge | 3 | 112716 | 773 | 5.800 | 19433.8 |
425 | 2023-10-31 06:57:05 | sparge | 2 | 82551 | 76 | 3.016 | 27371.0 |
424 | 2023-10-20 20:10:28 | sparge | 1 | 48755 | 9 | 0.796 | 61250.0 |
423 | 2023-10-20 16:50:22 | sparge | 1 | 48755 | 9 | 1.720 | 28345.9 |
422 | 2023-10-14 03:38:09 | sparge | 1 | 48755 | 9 | 0.860 | 56691.9 |
421 | 2023-10-08 18:55:06 | sparge | 1 | 48755 | 9 | 0.783 | 62266.9 |
420 | 2023-09-29 08:34:13 | sparge | 1 | 48755 | 9 | 0.750 | 65006.7 |
419 | 2023-09-26 19:24:57 | sparge | 1 | 48755 | 9 | 0.766 | 63648.8 |
418 | 2023-09-14 09:01:13 | sparge | 1 | 48755 | 9 | 0.813 | 59969.2 |
417 | 2023-08-24 12:31:16 | sparge | 1 | 48755 | 9 | 0.826 | 59025.4 |
416 | 2023-05-30 03:58:33 | sparge | 1 | 48755 | 9 | 0.826 | 59025.4 |
415 | 2023-05-25 14:33:49 | sparge | 1 | 48755 | 9 | 0.733 | 66514.3 |
414 | 2023-03-20 10:20:52 | sparge | 1 | 48755 | 9 | 0.890 | 54780.9 |
413 | 2023-02-27 16:27:03 | sparge | 1 | 48755 | 9 | 0.733 | 66514.3 |
412 | 2023-02-24 06:32:17 | sparge | 1 | 48755 | 9 | 0.920 | 52994.6 |
411 | 2023-01-17 08:31:21 | sparge | 3 | 112716 | 773 | 5.250 | 21469.7 |
410 | 2023-01-17 08:31:21 | sparge | 2 | 82551 | 76 | 2.453 | 33653.1 |
409 | 2023-01-17 08:14:28 | sparge | 1 | 48755 | 9 | 0.890 | 54780.9 |
408 | 2023-01-07 10:02:32 | sparge | 1 | 48755 | 9 | 0.750 | 65006.7 |
407 | 2022-10-20 12:45:39 | sparge | 1 | 48755 | 9 | 0.966 | 50471.0 |
406 | 2022-09-29 17:29:33 | sparge | 1 | 48755 | 9 | 0.813 | 59969.2 |
405 | 2022-07-13 06:03:47 | sparge | 2 | 82551 | 76 | 2.143 | 38521.2 |
404 | 2022-06-11 16:28:54 | sparge | 1 | 48755 | 9 | 0.813 | 59969.2 |
403 | 2022-05-14 17:32:59 | sparge | 1 | 48755 | 9 | 0.890 | 54780.9 |
402 | 2022-02-10 19:19:41 | sparge | 1 | 48755 | 9 | 0.906 | 53813.5 |
401 | 2022-01-31 14:14:10 | sparge | 1 | 48755 | 9 | 0.843 | 57835.1 |
400 | 2021-12-11 06:50:18 | sparge | 1 | 48755 | 9 | 0.843 | 57835.1 |
399 | 2021-10-27 08:08:14 | sparge | 1 | 48755 | 9 | 0.750 | 65006.7 |
398 | 2021-09-29 19:37:10 | sparge | 1 | 48755 | 9 | 0.843 | 57835.1 |
397 | 2021-07-16 23:27:56 | sparge | 1 | 48755 | 9 | 0.750 | 65006.7 |
396 | 2021-05-21 03:13:36 | sparge | 1 | 48755 | 9 | 0.986 | 49447.3 |
395 | 2021-04-14 05:28:15 | sparge | 1 | 48755 | 9 | 0.923 | 52822.3 |
394 | 2021-04-06 12:08:24 | sparge | 1 | 48755 | 9 | 0.906 | 53813.5 |
393 | 2021-02-02 11:42:36 | sparge | 1 | 48755 | 9 | 0.783 | 62266.9 |
392 | 2021-01-06 17:32:51 | sparge | 1 | 48755 | 9 | 0.766 | 63648.8 |
391 | 2020-12-27 23:37:07 | sparge | 1 | 48755 | 9 | 0.750 | 65006.7 |
390 | 2020-10-30 08:32:41 | sparge | 1 | 48755 | 9 | 0.830 | 58741.0 |
389 | 2020-10-22 23:52:40 | sparge | 1 | 48755 | 9 | 0.766 | 63648.8 |
388 | 2020-10-20 18:50:25 | sparge | 1 | 48755 | 9 | 1.483 | 32875.9 |
387 | 2020-10-20 04:48:16 | sparge | 1 | 48755 | 9 | 0.846 | 57630.0 |
386 | 2020-09-24 09:29:27 | sparge | 1 | 48755 | 9 | 0.796 | 61250.0 |
385 | 2020-08-05 03:28:36 | sparge | 1 | 48755 | 9 | 0.860 | 56691.9 |
384 | 2020-07-31 03:57:25 | sparge | 1 | 48755 | 9 | 0.856 | 56956.8 |
383 | 2020-06-21 05:38:25 | sparge | 1 | 48755 | 9 | 0.986 | 49447.3 |
382 | 2020-06-20 07:09:36 | sparge | 1 | 48755 | 9 | 0.826 | 59025.4 |
381 | 2020-06-17 01:03:21 | sparge | 1 | 48755 | 9 | 0.750 | 65006.7 |
380 | 2020-06-14 07:40:56 | sparge | 1 | 48755 | 9 | 0.783 | 62266.9 |
379 | 2020-06-13 07:42:00 | sparge | 1 | 48755 | 9 | 0.813 | 59969.2 |
378 | 2020-06-09 23:55:39 | sparge | 1 | 48755 | 9 | 0.783 | 62266.9 |
377 | 2020-04-11 19:07:29 | sparge | 1 | 48755 | 9 | 0.843 | 57835.1 |
376 | 2020-03-27 23:38:10 | sparge | 1 | 48755 | 9 | 0.923 | 52822.3 |
375 | 2020-03-26 14:08:09 | sparge | 1 | 48755 | 9 | 0.906 | 53813.5 |
374 | 2020-03-26 09:29:24 | sparge | 1 | 48755 | 9 | 0.813 | 59969.2 |
373 | 2020-03-23 00:51:29 | sparge | 1 | 48755 | 9 | 0.890 | 54780.9 |
372 | 2020-03-22 18:25:57 | sparge | 1 | 48755 | 9 | 0.780 | 62506.4 |
371 | 2020-03-19 13:41:39 | sparge | 1 | 48755 | 9 | 0.953 | 51159.5 |
370 | 2020-03-18 23:42:23 | sparge | 1 | 48755 | 9 | 0.843 | 57835.1 |
369 | 2020-03-08 11:24:21 | sparge | 1 | 48755 | 9 | 0.750 | 65006.7 |
368 | 2020-02-25 14:13:00 | sparge | 1 | 48755 | 9 | 0.813 | 59969.2 |
367 | 2020-02-20 04:26:29 | sparge | 1 | 48755 | 9 | 0.953 | 51159.5 |
366 | 2020-02-18 06:58:19 | sparge | 1 | 48755 | 9 | 0.873 | 55847.7 |
365 | 2020-02-16 04:57:07 | sparge | 1 | 48755 | 9 | 0.846 | 57630.0 |
364 | 2020-02-13 03:28:47 | sparge | 1 | 48755 | 9 | 1.940 | 25131.4 |
363 | 2020-02-12 09:48:08 | sparge | 1 | 48755 | 9 | 1.843 | 26454.2 |
362 | 2020-02-08 16:38:23 | sparge | 1 | 48755 | 9 | 0.936 | 52088.7 |
361 | 2020-02-06 06:59:17 | sparge | 1 | 48755 | 9 | 0.876 | 55656.4 |