History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"zyzzyva"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
7533 | 2024-04-27 00:14:32 | zyzzyva | 5 | 162725 | 426 | 14.783 | 11007.6 |
7532 | 2024-04-27 00:09:39 | zyzzyva | 2 | 107671 | 2 | 3.016 | 35699.9 |
7531 | 2024-04-26 23:33:09 | zyzzyva | 3 | 134027 | 2 | 6.406 | 20922.1 |
7530 | 2024-04-26 22:38:13 | zyzzyva | 1 | 69583 | 2 | 1.266 | 54962.9 |
7529 | 2024-04-26 03:03:06 | zyzzyva | 2 | 107671 | 2 | 3.076 | 35003.6 |
7528 | 2024-04-25 21:13:21 | zyzzyva | 5 | 162725 | 426 | 37.766 | 4308.8 |
7527 | 2024-04-25 06:17:01 | zyzzyva | 4 | 151207 | 25 | 11.000 | 13746.1 |
7526 | 2024-04-24 20:30:44 | zyzzyva | 4 | 151207 | 25 | 21.533 | 7022.1 |
7525 | 2024-04-24 20:30:09 | zyzzyva | 2 | 107671 | 2 | 10.066 | 10696.5 |
7524 | 2024-04-24 20:29:32 | zyzzyva | 4 | 151207 | 25 | 36.486 | 4144.2 |
7523 | 2024-04-24 20:29:52 | zyzzyva | 3 | 134027 | 2 | 11.673 | 11481.8 |
7522 | 2024-04-24 15:33:53 | zyzzyva | 4 | 151207 | 25 | 28.330 | 5337.3 |
7521 | 2024-04-24 15:33:47 | zyzzyva | 5 | 162725 | 426 | 31.863 | 5107.0 |
7520 | 2024-04-24 15:33:58 | zyzzyva | 2 | 107671 | 2 | 12.500 | 8613.7 |
7519 | 2024-04-24 15:33:55 | zyzzyva | 3 | 134027 | 2 | 8.390 | 15974.6 |
7518 | 2024-04-24 14:34:58 | zyzzyva | 1 | 69583 | 2 | 2.626 | 26497.7 |
7517 | 2024-04-23 04:17:25 | zyzzyva | 1 | 69583 | 2 | 4.580 | 15192.8 |
7516 | 2024-04-22 23:10:34 | zyzzyva | 2 | 107671 | 2 | 3.266 | 32967.2 |
7515 | 2024-04-22 23:10:33 | zyzzyva | 2 | 107671 | 2 | 3.440 | 31299.7 |
7514 | 2024-04-22 23:08:45 | zyzzyva | 5 | 162725 | 426 | 18.376 | 8855.3 |
7513 | 2024-04-22 23:08:48 | zyzzyva | 4 | 151207 | 25 | 13.863 | 10907.2 |
7512 | 2024-04-22 23:08:47 | zyzzyva | 3 | 134027 | 2 | 6.216 | 21561.6 |
7511 | 2024-04-22 23:08:44 | zyzzyva | 2 | 107671 | 2 | 2.780 | 38730.6 |
7510 | 2024-04-22 23:07:57 | zyzzyva | 1 | 69583 | 2 | 1.983 | 35089.8 |
7509 | 2024-04-22 11:08:47 | zyzzyva | 4 | 151207 | 25 | 23.236 | 6507.4 |
7508 | 2024-04-21 06:35:53 | zyzzyva | 1 | 69583 | 2 | 1.186 | 58670.3 |
7507 | 2024-04-21 02:51:37 | zyzzyva | 4 | 151207 | 25 | 40.423 | 3740.6 |
7506 | 2024-04-21 02:51:39 | zyzzyva | 3 | 134027 | 2 | 15.640 | 8569.5 |
7505 | 2024-04-21 02:51:39 | zyzzyva | 2 | 107671 | 2 | 8.440 | 12757.2 |
7504 | 2024-04-21 02:51:16 | zyzzyva | 1 | 69583 | 2 | 3.376 | 20611.1 |
7503 | 2024-04-20 19:02:48 | zyzzyva | 1 | 69583 | 2 | 4.313 | 16133.3 |
7502 | 2024-04-20 09:03:16 | zyzzyva | 5 | 162725 | 426 | 15.690 | 10371.3 |
7501 | 2024-04-19 07:46:15 | zyzzyva | 1 | 69583 | 2 | 1.266 | 54962.9 |
7500 | 2024-04-19 03:15:19 | zyzzyva | 4 | 151207 | 25 | 10.640 | 14211.2 |
7499 | 2024-04-18 00:54:06 | zyzzyva | 2 | 107671 | 2 | 5.160 | 20866.5 |
7498 | 2024-04-17 16:52:30 | zyzzyva | 4 | 151207 | 25 | 21.843 | 6922.4 |
7497 | 2024-04-17 09:07:45 | zyzzyva | 5 | 162725 | 426 | 13.033 | 12485.6 |
7496 | 2024-04-17 09:07:35 | zyzzyva | 4 | 151207 | 25 | 8.750 | 17280.8 |
7495 | 2024-04-17 09:07:30 | zyzzyva | 3 | 134027 | 2 | 5.236 | 25597.2 |
7494 | 2024-04-17 09:07:27 | zyzzyva | 2 | 107671 | 2 | 2.876 | 37437.8 |
7493 | 2024-04-17 08:35:53 | zyzzyva | 1 | 69583 | 2 | 1.000 | 69583.0 |
7492 | 2024-04-15 19:03:10 | zyzzyva | 1 | 69583 | 2 | 1.016 | 68487.2 |
7491 | 2024-04-15 13:54:14 | zyzzyva | 5 | 162725 | 426 | 39.656 | 4103.4 |
7490 | 2024-04-15 13:50:41 | zyzzyva | 4 | 151207 | 25 | 27.563 | 5485.9 |
7489 | 2024-04-15 13:49:24 | zyzzyva | 5 | 162725 | 426 | 61.003 | 2667.5 |
7488 | 2024-04-15 13:50:04 | zyzzyva | 2 | 107671 | 2 | 8.686 | 12395.9 |
7487 | 2024-04-15 13:49:18 | zyzzyva | 4 | 151207 | 25 | 32.096 | 4711.1 |
7486 | 2024-04-15 13:44:04 | zyzzyva | 3 | 134027 | 2 | 11.330 | 11829.4 |
7485 | 2024-04-15 13:44:07 | zyzzyva | 2 | 107671 | 2 | 7.000 | 15381.6 |
7484 | 2024-04-15 13:36:36 | zyzzyva | 1 | 69583 | 2 | 3.000 | 23194.3 |
7483 | 2024-04-15 13:29:51 | zyzzyva | 1 | 69583 | 2 | 2.220 | 31343.7 |
7482 | 2024-04-13 16:45:13 | zyzzyva | 4 | 151207 | 25 | 9.640 | 15685.4 |
7481 | 2024-04-13 14:32:08 | zyzzyva | 5 | 162725 | 426 | 14.703 | 11067.5 |
7480 | 2024-04-13 14:31:58 | zyzzyva | 4 | 151207 | 25 | 10.346 | 14615.0 |
7479 | 2024-04-13 14:31:51 | zyzzyva | 3 | 134027 | 2 | 6.236 | 21492.5 |
7478 | 2024-04-13 14:31:48 | zyzzyva | 2 | 107671 | 2 | 3.140 | 34290.1 |
7477 | 2024-04-13 14:05:09 | zyzzyva | 1 | 69583 | 2 | 1.326 | 52475.9 |
7476 | 2024-04-12 13:36:39 | zyzzyva | 1 | 69583 | 2 | 3.923 | 17737.2 |
7475 | 2024-04-12 11:51:11 | zyzzyva | 1 | 69583 | 2 | 1.296 | 53690.6 |
7474 | 2024-04-12 11:45:19 | zyzzyva | 1 | 69583 | 2 | 3.923 | 17737.2 |
7473 | 2024-04-12 10:30:32 | zyzzyva | 3 | 134027 | 2 | 24.173 | 5544.5 |
7472 | 2024-04-12 10:06:45 | zyzzyva | 3 | 134027 | 2 | 10.936 | 12255.6 |
7471 | 2024-04-12 09:46:18 | zyzzyva | 1 | 69583 | 2 | 2.436 | 28564.4 |
7470 | 2024-04-11 06:19:15 | zyzzyva | 5 | 162725 | 426 | 26.190 | 6213.2 |
7469 | 2024-04-11 06:18:59 | zyzzyva | 4 | 151207 | 25 | 14.126 | 10704.2 |
7468 | 2024-04-11 06:18:49 | zyzzyva | 3 | 134027 | 2 | 9.156 | 14638.2 |
7467 | 2024-04-11 06:18:44 | zyzzyva | 2 | 107671 | 2 | 3.140 | 34290.1 |
7466 | 2024-04-11 05:39:35 | zyzzyva | 1 | 69583 | 2 | 1.156 | 60192.9 |
7465 | 2024-04-09 19:04:53 | zyzzyva | 1 | 69583 | 2 | 4.420 | 15742.8 |
7464 | 2024-04-09 17:42:43 | zyzzyva | 1 | 69583 | 2 | 3.750 | 18555.5 |
7463 | 2024-04-09 16:54:12 | zyzzyva | 1 | 69583 | 2 | 1.030 | 67556.3 |
7462 | 2024-04-09 15:55:56 | zyzzyva | 1 | 69583 | 2 | 1.966 | 35393.2 |
7461 | 2024-04-05 23:55:39 | zyzzyva | 5 | 162725 | 426 | 29.813 | 5458.2 |
7460 | 2024-04-05 04:01:13 | zyzzyva | 5 | 162725 | 426 | 39.173 | 4154.0 |
7459 | 2024-04-04 14:54:35 | zyzzyva | 5 | 162725 | 426 | 12.890 | 12624.1 |
7458 | 2024-03-31 04:29:47 | zyzzyva | 2 | 107671 | 2 | 8.346 | 12900.9 |
7457 | 2024-03-31 04:29:43 | zyzzyva | 3 | 134027 | 2 | 7.186 | 18651.1 |
7456 | 2024-03-31 03:27:53 | zyzzyva | 1 | 69583 | 2 | 3.626 | 19190.0 |
7455 | 2024-03-29 23:25:17 | zyzzyva | 5 | 162725 | 426 | 35.863 | 4537.4 |
7454 | 2024-03-29 06:04:36 | zyzzyva | 1 | 69583 | 2 | 3.673 | 18944.5 |
7453 | 2024-03-28 23:50:02 | zyzzyva | 5 | 162725 | 426 | 38.220 | 4257.6 |
7452 | 2024-03-28 21:34:05 | zyzzyva | 5 | 162725 | 426 | 40.596 | 4008.4 |
7451 | 2024-03-28 03:51:02 | zyzzyva | 1 | 69583 | 2 | 1.033 | 67360.1 |
7450 | 2024-03-22 00:58:03 | zyzzyva | 3 | 134027 | 2 | 13.093 | 10236.5 |
7449 | 2024-03-22 00:58:01 | zyzzyva | 2 | 107671 | 2 | 3.403 | 31640.0 |
7448 | 2024-03-21 01:12:27 | zyzzyva | 1 | 69583 | 2 | 1.906 | 36507.3 |
7447 | 2024-03-20 11:11:42 | zyzzyva | 1 | 69583 | 2 | 1.173 | 59320.5 |
7446 | 2024-03-20 11:11:28 | zyzzyva | 3 | 134027 | 2 | 6.233 | 21502.8 |
7445 | 2024-03-20 11:11:31 | zyzzyva | 2 | 107671 | 2 | 3.126 | 34443.7 |
7444 | 2024-03-20 11:11:22 | zyzzyva | 4 | 151207 | 25 | 10.640 | 14211.2 |
7443 | 2024-03-20 11:11:13 | zyzzyva | 1 | 69583 | 2 | 0.986 | 70571.0 |
7442 | 2024-03-19 04:54:04 | zyzzyva | 1 | 69583 | 2 | 2.640 | 26357.2 |
7441 | 2024-03-13 20:05:31 | zyzzyva | 1 | 69583 | 2 | 1.156 | 60192.9 |
7440 | 2024-03-09 21:29:27 | zyzzyva | 4 | 151207 | 25 | 27.326 | 5533.4 |
7439 | 2024-03-09 06:57:02 | zyzzyva | 1 | 69583 | 2 | 1.266 | 54962.9 |
7438 | 2024-03-08 23:14:43 | zyzzyva | 1 | 69583 | 2 | 1.203 | 57841.2 |
7437 | 2024-03-08 10:25:49 | zyzzyva | 1 | 69583 | 2 | 1.283 | 54234.6 |
7436 | 2024-03-07 08:03:32 | zyzzyva | 4 | 151207 | 25 | 17.670 | 8557.3 |
7435 | 2024-03-06 23:09:03 | zyzzyva | 5 | 162725 | 426 | 53.050 | 3067.4 |
7434 | 2024-03-05 09:25:50 | zyzzyva | 5 | 162725 | 426 | 15.783 | 10310.1 |