History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"weather"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
502 | 2024-05-08 07:11:59 | weather | 3 | 134027 | 603 | 15.093 | 8880.1 |
501 | 2024-05-07 03:34:56 | weather | 3 | 134027 | 603 | 19.360 | 6922.9 |
500 | 2024-05-06 14:39:39 | weather | 2 | 107671 | 84 | 4.343 | 24791.8 |
499 | 2024-05-05 19:36:11 | weather | 3 | 134027 | 603 | 12.530 | 10696.5 |
498 | 2024-05-05 18:57:44 | weather | 1 | 69583 | 8 | 1.656 | 42018.7 |
497 | 2024-05-05 16:37:28 | weather | 2 | 107671 | 84 | 5.360 | 20087.9 |
496 | 2024-05-05 16:35:44 | weather | 3 | 134027 | 603 | 7.000 | 19146.7 |
495 | 2024-05-05 15:25:11 | weather | 2 | 107671 | 84 | 3.483 | 30913.3 |
494 | 2024-05-05 15:20:27 | weather | 3 | 134027 | 603 | 7.530 | 17799.1 |
493 | 2024-05-05 05:53:28 | weather | 1 | 69583 | 8 | 1.233 | 56433.9 |
492 | 2024-05-04 23:31:34 | weather | 3 | 134027 | 603 | 10.986 | 12199.8 |
491 | 2024-05-04 23:12:10 | weather | 3 | 134027 | 603 | 7.486 | 17903.7 |
490 | 2024-05-02 15:27:30 | weather | 1 | 69583 | 8 | 1.356 | 51314.9 |
489 | 2024-05-01 06:47:53 | weather | 1 | 69583 | 8 | 1.280 | 54361.7 |
488 | 2024-04-13 04:05:46 | weather | 2 | 107671 | 84 | 3.623 | 29718.7 |
487 | 2024-01-21 22:54:34 | weather | 3 | 134027 | 603 | 7.873 | 17023.6 |
486 | 2024-01-21 05:56:27 | weather | 3 | 134027 | 603 | 5.736 | 23365.9 |
485 | 2024-01-09 21:13:56 | weather | 1 | 69583 | 8 | 1.200 | 57985.8 |
484 | 2024-01-09 18:39:29 | weather | 3 | 134027 | 603 | 6.953 | 19276.1 |
483 | 2023-12-17 10:13:43 | weather | 1 | 69583 | 8 | 1.220 | 57035.2 |
482 | 2023-12-13 15:21:24 | weather | 2 | 107671 | 84 | 2.876 | 37437.8 |
481 | 2023-12-12 09:03:10 | weather | 1 | 69583 | 8 | 1.046 | 66522.9 |
480 | 2023-12-05 23:10:01 | weather | 1 | 69583 | 8 | 1.186 | 58670.3 |
479 | 2023-11-19 15:28:54 | weather | 3 | 134027 | 603 | 6.733 | 19906.0 |
478 | 2023-11-05 20:44:12 | weather | 1 | 69583 | 8 | 1.110 | 62687.4 |
477 | 2023-11-01 00:03:04 | weather | 3 | 134027 | 603 | 6.670 | 20094.0 |
476 | 2023-10-20 04:44:36 | weather | 1 | 69583 | 8 | 1.233 | 56433.9 |
475 | 2023-10-16 14:14:04 | weather | 1 | 69583 | 8 | 2.356 | 29534.4 |
474 | 2023-10-15 00:50:49 | weather | 1 | 69583 | 8 | 1.156 | 60192.9 |
473 | 2023-09-29 02:52:18 | weather | 1 | 69583 | 8 | 1.080 | 64428.7 |
472 | 2023-09-24 10:32:24 | weather | 1 | 69583 | 8 | 1.200 | 57985.8 |
471 | 2023-09-11 11:27:48 | weather | 2 | 107671 | 84 | 2.813 | 38276.2 |
470 | 2023-08-26 18:00:17 | weather | 1 | 69583 | 8 | 1.186 | 58670.3 |
469 | 2023-08-08 04:25:40 | weather | 3 | 134027 | 603 | 5.670 | 23637.9 |
468 | 2023-06-08 00:25:15 | weather | 1 | 69583 | 8 | 1.296 | 53690.6 |
467 | 2023-05-31 18:58:51 | weather | 1 | 69583 | 8 | 1.046 | 66522.9 |
466 | 2023-05-27 21:06:51 | weather | 2 | 107671 | 84 | 2.766 | 38926.6 |
465 | 2023-04-20 07:48:31 | weather | 3 | 134027 | 603 | 6.670 | 20094.0 |
464 | 2023-03-27 09:56:33 | weather | 1 | 69583 | 8 | 1.063 | 65459.1 |
463 | 2023-03-06 15:35:26 | weather | 2 | 107671 | 84 | 2.763 | 38968.9 |
462 | 2023-02-09 14:18:31 | weather | 1 | 69583 | 8 | 2.376 | 29285.8 |
461 | 2023-01-21 00:40:08 | weather | 3 | 134027 | 603 | 5.780 | 23188.1 |
460 | 2023-01-10 15:24:17 | weather | 1 | 69583 | 8 | 1.030 | 67556.3 |
459 | 2022-12-12 20:45:00 | weather | 2 | 107671 | 84 | 2.766 | 38926.6 |
458 | 2022-11-01 08:52:04 | weather | 3 | 134027 | 603 | 7.016 | 19103.1 |
457 | 2022-10-19 22:28:11 | weather | 1 | 69583 | 8 | 1.030 | 67556.3 |
456 | 2022-10-04 21:18:02 | weather | 1 | 69583 | 8 | 1.046 | 66522.9 |
455 | 2022-09-19 21:50:44 | weather | 1 | 69583 | 8 | 1.063 | 65459.1 |
454 | 2022-09-18 16:10:59 | weather | 1 | 69583 | 8 | 1.170 | 59472.6 |
453 | 2022-09-17 18:46:50 | weather | 1 | 69583 | 8 | 1.063 | 65459.1 |
452 | 2022-09-12 11:50:31 | weather | 1 | 69583 | 8 | 1.060 | 65644.3 |
451 | 2022-09-01 13:55:37 | weather | 1 | 69583 | 8 | 1.186 | 58670.3 |
450 | 2022-08-31 22:28:57 | weather | 2 | 107671 | 84 | 2.826 | 38100.1 |
449 | 2022-08-23 00:32:15 | weather | 1 | 69583 | 8 | 1.030 | 67556.3 |
448 | 2022-08-07 03:39:08 | weather | 1 | 69583 | 8 | 1.170 | 59472.6 |
447 | 2022-07-30 13:22:04 | weather | 2 | 107671 | 84 | 2.783 | 38688.8 |
446 | 2022-07-30 04:20:30 | weather | 1 | 69583 | 8 | 1.063 | 65459.1 |
445 | 2022-07-28 14:28:33 | weather | 1 | 69583 | 8 | 1.156 | 60192.9 |
444 | 2022-07-17 19:42:59 | weather | 1 | 69583 | 8 | 1.283 | 54234.6 |
443 | 2022-07-11 08:28:44 | weather | 3 | 134027 | 603 | 6.923 | 19359.7 |
442 | 2022-07-11 08:27:01 | weather | 2 | 107671 | 84 | 3.343 | 32207.9 |
441 | 2022-07-03 11:26:52 | weather | 1 | 69583 | 8 | 1.046 | 66522.9 |
440 | 2022-07-02 07:20:08 | weather | 1 | 69583 | 8 | 1.046 | 66522.9 |
439 | 2022-06-10 22:43:26 | weather | 1 | 69583 | 8 | 1.110 | 62687.4 |
438 | 2022-06-03 06:07:15 | weather | 3 | 134027 | 603 | 6.016 | 22278.4 |
437 | 2022-05-21 11:49:19 | weather | 1 | 69583 | 8 | 1.186 | 58670.3 |
436 | 2022-05-18 01:50:17 | weather | 1 | 69583 | 8 | 1.063 | 65459.1 |
435 | 2022-05-05 22:17:08 | weather | 1 | 69583 | 8 | 1.216 | 57222.9 |
434 | 2022-05-04 21:06:58 | weather | 1 | 69583 | 8 | 1.123 | 61961.7 |
433 | 2022-05-03 21:33:15 | weather | 1 | 69583 | 8 | 1.343 | 51811.6 |
432 | 2022-02-25 00:57:01 | weather | 1 | 69583 | 8 | 1.466 | 47464.5 |
431 | 2022-02-05 07:07:07 | weather | 1 | 69583 | 8 | 1.076 | 64668.2 |
430 | 2022-01-29 01:23:52 | weather | 3 | 134027 | 603 | 5.763 | 23256.5 |
429 | 2022-01-26 19:18:23 | weather | 3 | 134027 | 603 | 6.356 | 21086.7 |
428 | 2022-01-10 01:46:26 | weather | 1 | 69583 | 8 | 1.080 | 64428.7 |
427 | 2021-12-12 00:26:41 | weather | 1 | 69583 | 8 | 1.046 | 66522.9 |
426 | 2021-11-06 16:34:07 | weather | 1 | 69583 | 8 | 1.250 | 55666.4 |
425 | 2021-11-03 13:46:16 | weather | 3 | 134027 | 603 | 6.016 | 22278.4 |
424 | 2021-09-18 20:51:31 | weather | 1 | 69583 | 8 | 1.080 | 64428.7 |
423 | 2021-09-18 04:25:31 | weather | 1 | 69583 | 8 | 1.096 | 63488.1 |
422 | 2021-09-17 21:34:18 | weather | 1 | 69583 | 8 | 1.173 | 59320.5 |
421 | 2021-09-17 12:11:44 | weather | 1 | 69583 | 8 | 1.063 | 65459.1 |
420 | 2021-09-11 12:16:37 | weather | 1 | 69583 | 8 | 1.173 | 59320.5 |
419 | 2021-09-11 07:30:09 | weather | 1 | 69583 | 8 | 1.046 | 66522.9 |
418 | 2021-08-27 23:00:22 | weather | 3 | 134027 | 603 | 6.516 | 20568.9 |
417 | 2021-08-22 11:58:34 | weather | 1 | 69583 | 8 | 1.190 | 58473.1 |
416 | 2021-08-12 12:08:41 | weather | 1 | 69583 | 8 | 1.076 | 64668.2 |
415 | 2021-06-18 00:53:56 | weather | 1 | 69583 | 8 | 1.186 | 58670.3 |
414 | 2021-03-18 18:45:40 | weather | 1 | 69583 | 8 | 1.063 | 65459.1 |
413 | 2021-02-11 14:55:36 | weather | 3 | 134027 | 603 | 6.186 | 21666.2 |
412 | 2021-02-11 13:10:22 | weather | 1 | 69583 | 8 | 1.326 | 52475.9 |
411 | 2020-12-26 06:06:25 | weather | 1 | 69583 | 8 | 1.063 | 65459.1 |
410 | 2020-12-15 20:21:50 | weather | 1 | 69583 | 8 | 1.220 | 57035.2 |
409 | 2020-11-12 05:29:13 | weather | 1 | 69583 | 8 | 1.093 | 63662.4 |
408 | 2020-11-01 15:37:21 | weather | 1 | 69583 | 8 | 1.450 | 47988.3 |
407 | 2020-10-20 18:06:22 | weather | 1 | 69583 | 8 | 1.046 | 66522.9 |
406 | 2020-09-15 11:44:31 | weather | 1 | 69583 | 8 | 1.050 | 66269.5 |
405 | 2020-08-29 19:18:14 | weather | 1 | 69583 | 8 | 1.126 | 61796.6 |
404 | 2020-08-25 10:14:44 | weather | 1 | 69583 | 8 | 1.093 | 63662.4 |
403 | 2020-08-24 09:54:11 | weather | 1 | 69583 | 8 | 1.063 | 65459.1 |