History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gumball"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
521 | 2024-05-08 19:50:05 | gumball | 1 | 69583 | 2 | 1.376 | 50569.0 |
520 | 2024-05-08 17:16:25 | gumball | 3 | 134027 | 100 | 20.406 | 6568.0 |
519 | 2024-05-08 06:38:24 | gumball | 3 | 134027 | 100 | 11.780 | 11377.5 |
518 | 2024-05-06 22:23:05 | gumball | 3 | 134027 | 100 | 10.720 | 12502.5 |
517 | 2024-05-04 06:53:25 | gumball | 4 | 151207 | 929 | 11.906 | 12700.1 |
516 | 2024-05-03 21:06:19 | gumball | 2 | 107671 | 7 | 7.203 | 14948.1 |
515 | 2024-05-03 18:41:39 | gumball | 3 | 134027 | 100 | 8.860 | 15127.2 |
514 | 2024-05-03 18:23:55 | gumball | 4 | 151207 | 929 | 14.110 | 10716.3 |
513 | 2024-05-03 15:45:43 | gumball | 4 | 151207 | 929 | 10.860 | 13923.3 |
512 | 2024-05-03 15:45:39 | gumball | 3 | 134027 | 100 | 6.266 | 21389.6 |
511 | 2024-05-03 15:45:35 | gumball | 2 | 107671 | 7 | 3.190 | 33752.7 |
510 | 2024-05-03 08:12:39 | gumball | 1 | 69583 | 2 | 1.153 | 60349.5 |
509 | 2024-05-02 12:03:04 | gumball | 1 | 69583 | 2 | 4.093 | 17000.5 |
508 | 2024-03-29 05:53:38 | gumball | 1 | 69583 | 2 | 2.670 | 26061.0 |
507 | 2024-03-29 00:43:00 | gumball | 1 | 69583 | 2 | 2.250 | 30925.8 |
506 | 2024-03-11 02:27:57 | gumball | 1 | 69583 | 2 | 1.266 | 54962.9 |
505 | 2024-02-29 23:23:58 | gumball | 4 | 151207 | 929 | 17.126 | 8829.1 |
504 | 2024-02-28 20:57:36 | gumball | 4 | 151207 | 929 | 10.736 | 14084.1 |
503 | 2024-02-28 20:56:46 | gumball | 3 | 134027 | 100 | 13.563 | 9881.8 |
502 | 2024-02-28 08:18:00 | gumball | 4 | 151207 | 929 | 14.766 | 10240.2 |
501 | 2024-02-28 08:17:50 | gumball | 3 | 134027 | 100 | 7.750 | 17293.8 |
500 | 2024-02-26 03:45:34 | gumball | 4 | 151207 | 929 | 22.173 | 6819.4 |
499 | 2024-02-26 03:45:32 | gumball | 3 | 134027 | 100 | 15.483 | 8656.4 |
498 | 2024-02-25 22:51:52 | gumball | 4 | 151207 | 929 | 20.953 | 7216.5 |
497 | 2024-02-25 22:51:54 | gumball | 3 | 134027 | 100 | 15.890 | 8434.7 |
496 | 2024-02-25 22:51:54 | gumball | 2 | 107671 | 7 | 3.626 | 29694.2 |
495 | 2024-02-25 22:51:46 | gumball | 1 | 69583 | 2 | 1.313 | 52995.4 |
494 | 2024-02-01 04:18:25 | gumball | 1 | 69583 | 2 | 1.170 | 59472.6 |
493 | 2024-01-23 16:53:35 | gumball | 1 | 69583 | 2 | 2.610 | 26660.2 |
492 | 2023-12-01 18:07:29 | gumball | 1 | 69583 | 2 | 1.173 | 59320.5 |
491 | 2023-12-01 01:19:46 | gumball | 1 | 69583 | 2 | 1.060 | 65644.3 |
490 | 2023-11-26 09:32:26 | gumball | 1 | 69583 | 2 | 1.076 | 64668.2 |
489 | 2023-10-20 15:15:07 | gumball | 1 | 69583 | 2 | 1.126 | 61796.6 |
488 | 2023-10-15 12:26:07 | gumball | 1 | 69583 | 2 | 1.110 | 62687.4 |
487 | 2023-10-09 21:02:44 | gumball | 1 | 69583 | 2 | 1.076 | 64668.2 |
486 | 2023-09-15 22:55:07 | gumball | 1 | 69583 | 2 | 1.110 | 62687.4 |
485 | 2023-09-10 19:17:11 | gumball | 1 | 69583 | 2 | 1.250 | 55666.4 |
484 | 2023-08-04 15:34:44 | gumball | 1 | 69583 | 2 | 1.046 | 66522.9 |
483 | 2023-06-20 10:24:50 | gumball | 1 | 69583 | 2 | 1.156 | 60192.9 |
482 | 2023-04-19 18:18:29 | gumball | 1 | 69583 | 2 | 1.140 | 61037.7 |
481 | 2023-04-03 18:00:46 | gumball | 1 | 69583 | 2 | 1.033 | 67360.1 |
480 | 2023-03-04 17:46:49 | gumball | 1 | 69583 | 2 | 1.030 | 67556.3 |
479 | 2023-01-15 23:00:56 | gumball | 1 | 69583 | 2 | 1.013 | 68690.0 |
478 | 2023-01-07 09:11:13 | gumball | 1 | 69583 | 2 | 1.126 | 61796.6 |
477 | 2022-09-09 05:23:50 | gumball | 1 | 69583 | 2 | 1.046 | 66522.9 |
476 | 2022-06-10 03:48:54 | gumball | 1 | 69583 | 2 | 1.190 | 58473.1 |
475 | 2022-06-06 08:17:30 | gumball | 1 | 69583 | 2 | 1.033 | 67360.1 |
474 | 2022-05-09 22:37:14 | gumball | 1 | 69583 | 2 | 1.330 | 52318.0 |
473 | 2022-05-03 12:09:31 | gumball | 1 | 69583 | 2 | 1.640 | 42428.7 |
472 | 2022-03-03 06:55:31 | gumball | 1 | 69583 | 2 | 1.110 | 62687.4 |
471 | 2022-01-22 21:14:34 | gumball | 1 | 69583 | 2 | 1.216 | 57222.9 |
470 | 2021-12-18 17:05:32 | gumball | 1 | 69583 | 2 | 1.266 | 54962.9 |
469 | 2021-11-07 17:07:21 | gumball | 1 | 69583 | 2 | 1.076 | 64668.2 |
468 | 2021-10-09 20:45:24 | gumball | 1 | 69583 | 2 | 1.156 | 60192.9 |
467 | 2021-09-11 23:43:41 | gumball | 1 | 69583 | 2 | 1.190 | 58473.1 |
466 | 2021-07-07 22:55:53 | gumball | 1 | 69583 | 2 | 1.050 | 66269.5 |
465 | 2021-04-08 03:39:47 | gumball | 1 | 69583 | 2 | 1.186 | 58670.3 |
464 | 2021-04-03 23:54:56 | gumball | 1 | 69583 | 2 | 1.046 | 66522.9 |
463 | 2021-03-30 00:35:08 | gumball | 1 | 69583 | 2 | 1.030 | 67556.3 |
462 | 2021-03-03 21:13:39 | gumball | 1 | 69583 | 2 | 1.030 | 67556.3 |
461 | 2021-01-31 09:20:08 | gumball | 1 | 69583 | 2 | 1.063 | 65459.1 |
460 | 2020-12-29 23:29:20 | gumball | 1 | 69583 | 2 | 1.046 | 66522.9 |
459 | 2020-10-28 07:39:11 | gumball | 1 | 69583 | 2 | 1.140 | 61037.7 |
458 | 2020-10-25 16:31:24 | gumball | 1 | 69583 | 2 | 1.123 | 61961.7 |
457 | 2020-10-03 09:05:58 | gumball | 1 | 69583 | 2 | 1.016 | 68487.2 |
456 | 2020-09-26 16:32:28 | gumball | 1 | 69583 | 2 | 1.030 | 67556.3 |
455 | 2020-09-14 08:03:13 | gumball | 1 | 69583 | 2 | 1.046 | 66522.9 |
454 | 2020-08-29 09:29:22 | gumball | 1 | 69583 | 2 | 1.203 | 57841.2 |
453 | 2020-06-21 00:51:36 | gumball | 1 | 69583 | 2 | 1.533 | 45390.1 |
452 | 2020-06-17 21:10:25 | gumball | 1 | 69583 | 2 | 1.250 | 55666.4 |
451 | 2020-03-26 05:25:55 | gumball | 1 | 69583 | 2 | 1.140 | 61037.7 |
450 | 2020-03-25 00:36:30 | gumball | 1 | 69583 | 2 | 1.076 | 64668.2 |
449 | 2020-03-21 12:15:02 | gumball | 1 | 69583 | 2 | 1.156 | 60192.9 |
448 | 2020-03-07 06:35:07 | gumball | 1 | 69583 | 2 | 1.046 | 66522.9 |
447 | 2020-03-02 20:06:33 | gumball | 1 | 69583 | 2 | 1.283 | 54234.6 |
446 | 2020-03-02 19:07:13 | gumball | 1 | 69583 | 2 | 1.250 | 55666.4 |
445 | 2020-02-24 15:07:26 | gumball | 1 | 69583 | 2 | 1.190 | 58473.1 |
444 | 2020-02-23 05:04:38 | gumball | 1 | 69583 | 2 | 1.516 | 45899.1 |
443 | 2020-02-14 10:49:12 | gumball | 1 | 69583 | 2 | 1.373 | 50679.5 |
442 | 2020-02-13 21:16:18 | gumball | 1 | 69583 | 2 | 3.233 | 21522.7 |
441 | 2020-02-07 15:36:19 | gumball | 1 | 69583 | 2 | 1.283 | 54234.6 |
440 | 2020-01-28 04:39:38 | gumball | 1 | 69583 | 2 | 2.610 | 26660.2 |
439 | 2020-01-26 12:52:57 | gumball | 1 | 69583 | 2 | 1.203 | 57841.2 |
438 | 2020-01-22 08:21:14 | gumball | 1 | 69583 | 2 | 1.300 | 53525.4 |
437 | 2020-01-21 18:15:31 | gumball | 1 | 69583 | 2 | 1.296 | 53690.6 |
436 | 2020-01-16 10:11:00 | gumball | 1 | 69583 | 2 | 2.580 | 26970.2 |
435 | 2020-01-16 09:15:42 | gumball | 1 | 69583 | 2 | 1.313 | 52995.4 |
434 | 2020-01-08 19:54:11 | gumball | 1 | 69583 | 2 | 1.153 | 60349.5 |
433 | 2020-01-07 02:35:32 | gumball | 1 | 69583 | 2 | 4.546 | 15306.4 |
432 | 2019-12-30 02:59:41 | gumball | 1 | 69583 | 2 | 1.220 | 57035.2 |
431 | 2019-12-29 21:19:48 | gumball | 1 | 69583 | 2 | 1.156 | 60192.9 |
430 | 2019-12-04 07:35:58 | gumball | 1 | 69583 | 2 | 1.233 | 56433.9 |
429 | 2019-09-05 04:03:07 | gumball | 1 | 69583 | 2 | 1.106 | 62914.1 |
428 | 2019-06-05 11:59:32 | gumball | 1 | 69583 | 2 | 1.226 | 56756.1 |
427 | 2019-03-09 03:42:35 | gumball | 1 | 69583 | 2 | 1.256 | 55400.5 |
426 | 2019-02-24 04:24:21 | gumball | 1 | 69583 | 2 | 1.960 | 35501.5 |
425 | 2019-01-06 10:04:56 | gumball | 1 | 69583 | 2 | 1.000 | 69583.0 |
424 | 2018-12-23 02:59:54 | gumball | 1 | 69583 | 2 | 1.010 | 68894.1 |
423 | 2018-11-30 10:37:41 | gumball | 1 | 69583 | 2 | 1.120 | 62127.7 |
422 | 2018-11-30 10:34:19 | gumball | 1 | 69583 | 2 | 1.173 | 59320.5 |