History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"surge"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
507 | 2024-04-02 20:35:51 | surge | 1 | 28756 | 12 | 0.466 | 61708.2 |
506 | 2024-03-31 02:27:03 | surge | 1 | 28756 | 12 | 1.106 | 26000.0 |
505 | 2024-03-27 06:40:43 | surge | 1 | 28756 | 12 | 0.466 | 61708.2 |
504 | 2024-02-25 22:12:01 | surge | 1 | 28756 | 12 | 0.610 | 47141.0 |
503 | 2024-02-17 19:23:22 | surge | 2 | 53800 | 120 | 3.706 | 14517.0 |
502 | 2024-02-14 18:18:16 | surge | 2 | 53800 | 120 | 5.670 | 9488.5 |
501 | 2024-02-13 16:14:45 | surge | 2 | 53800 | 120 | 1.906 | 28226.7 |
500 | 2024-02-01 18:59:57 | surge | 1 | 28756 | 12 | 0.530 | 54256.6 |
499 | 2024-01-26 19:22:10 | surge | 1 | 28756 | 12 | 0.440 | 65354.5 |
498 | 2024-01-04 06:03:33 | surge | 2 | 53800 | 120 | 1.420 | 37887.3 |
497 | 2023-12-09 10:54:02 | surge | 2 | 53800 | 120 | 1.423 | 37807.4 |
496 | 2023-12-09 00:39:50 | surge | 2 | 53800 | 120 | 1.530 | 35163.4 |
495 | 2023-12-08 14:28:30 | surge | 1 | 28756 | 12 | 0.530 | 54256.6 |
494 | 2023-12-08 14:28:29 | surge | 1 | 28756 | 12 | 0.500 | 57512.0 |
493 | 2023-12-08 14:27:12 | surge | 1 | 28756 | 12 | 0.560 | 51350.0 |
492 | 2023-12-08 14:27:11 | surge | 1 | 28756 | 12 | 0.640 | 44931.3 |
491 | 2023-11-25 17:34:20 | surge | 1 | 28756 | 12 | 0.516 | 55728.7 |
490 | 2023-11-15 23:43:36 | surge | 1 | 28756 | 12 | 0.483 | 59536.2 |
489 | 2023-11-14 15:22:14 | surge | 1 | 28756 | 12 | 1.046 | 27491.4 |
488 | 2023-11-05 14:45:36 | surge | 2 | 53800 | 120 | 1.470 | 36598.6 |
487 | 2023-10-28 10:43:30 | surge | 1 | 28756 | 12 | 0.513 | 56054.6 |
486 | 2023-10-22 20:08:11 | surge | 1 | 28756 | 12 | 0.546 | 52666.7 |
485 | 2023-10-21 14:52:30 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
484 | 2023-10-11 15:44:04 | surge | 1 | 28756 | 12 | 0.483 | 59536.2 |
483 | 2023-10-08 08:30:52 | surge | 1 | 28756 | 12 | 0.513 | 56054.6 |
482 | 2023-10-05 05:55:24 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
481 | 2023-09-29 18:37:11 | surge | 1 | 28756 | 12 | 0.470 | 61183.0 |
480 | 2023-09-24 15:23:52 | surge | 1 | 28756 | 12 | 0.466 | 61708.2 |
479 | 2023-09-12 01:11:45 | surge | 1 | 28756 | 12 | 0.546 | 52666.7 |
478 | 2023-06-18 07:15:30 | surge | 1 | 28756 | 12 | 0.486 | 59168.7 |
477 | 2023-06-11 13:31:17 | surge | 1 | 28756 | 12 | 0.500 | 57512.0 |
476 | 2023-04-01 18:56:01 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
475 | 2023-02-20 04:51:21 | surge | 1 | 28756 | 12 | 0.440 | 65354.5 |
474 | 2023-01-14 14:35:19 | surge | 1 | 28756 | 12 | 0.486 | 59168.7 |
473 | 2022-10-31 00:14:24 | surge | 1 | 28756 | 12 | 0.436 | 65954.1 |
472 | 2022-10-19 18:22:43 | surge | 1 | 28756 | 12 | 0.436 | 65954.1 |
471 | 2022-07-29 06:57:36 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
470 | 2022-06-18 20:19:25 | surge | 1 | 28756 | 12 | 0.486 | 59168.7 |
469 | 2022-06-07 03:18:58 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
468 | 2022-06-03 19:20:27 | surge | 1 | 28756 | 12 | 0.436 | 65954.1 |
467 | 2022-02-28 11:57:01 | surge | 1 | 28756 | 12 | 0.606 | 47452.1 |
466 | 2022-02-26 08:15:47 | surge | 1 | 28756 | 12 | 0.533 | 53951.2 |
465 | 2022-02-06 15:50:40 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
464 | 2021-12-11 03:49:44 | surge | 1 | 28756 | 12 | 0.500 | 57512.0 |
463 | 2021-11-14 03:35:20 | surge | 1 | 28756 | 12 | 0.546 | 52666.7 |
462 | 2021-10-30 07:34:23 | surge | 1 | 28756 | 12 | 0.516 | 55728.7 |
461 | 2021-10-24 12:55:13 | surge | 1 | 28756 | 12 | 0.450 | 63902.2 |
460 | 2021-10-22 12:55:17 | surge | 1 | 28756 | 12 | 0.986 | 29164.3 |
459 | 2021-10-13 17:22:27 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
458 | 2021-09-10 10:28:48 | surge | 1 | 28756 | 12 | 0.626 | 45936.1 |
457 | 2021-08-23 19:14:30 | surge | 1 | 28756 | 12 | 0.450 | 63902.2 |
456 | 2021-07-12 15:24:11 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
455 | 2021-06-04 14:44:54 | surge | 1 | 28756 | 12 | 0.500 | 57512.0 |
454 | 2021-05-01 11:09:17 | surge | 1 | 28756 | 12 | 1.030 | 27918.4 |
453 | 2021-04-08 22:46:15 | surge | 1 | 28756 | 12 | 0.513 | 56054.6 |
452 | 2021-04-04 18:05:14 | surge | 1 | 28756 | 12 | 0.486 | 59168.7 |
451 | 2021-03-13 05:50:01 | surge | 1 | 28756 | 12 | 0.483 | 59536.2 |
450 | 2021-02-16 13:41:49 | surge | 1 | 28756 | 12 | 0.500 | 57512.0 |
449 | 2020-12-30 19:10:49 | surge | 1 | 28756 | 12 | 0.456 | 63061.4 |
448 | 2020-10-26 12:23:23 | surge | 1 | 28756 | 12 | 0.516 | 55728.7 |
447 | 2020-10-21 20:56:17 | surge | 1 | 28756 | 12 | 0.640 | 44931.3 |
446 | 2020-10-20 16:11:12 | surge | 1 | 28756 | 12 | 0.470 | 61183.0 |
445 | 2020-10-17 21:13:23 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
444 | 2020-09-27 11:28:34 | surge | 1 | 28756 | 12 | 0.483 | 59536.2 |
443 | 2020-08-08 11:12:51 | surge | 1 | 28756 | 12 | 0.516 | 55728.7 |
442 | 2020-06-21 02:02:03 | surge | 1 | 28756 | 12 | 0.690 | 41675.4 |
441 | 2020-06-18 11:47:07 | surge | 1 | 28756 | 12 | 0.470 | 61183.0 |
440 | 2020-03-30 02:26:05 | surge | 1 | 28756 | 12 | 0.466 | 61708.2 |
439 | 2020-03-28 00:47:29 | surge | 1 | 28756 | 12 | 0.670 | 42919.4 |
438 | 2020-03-26 06:00:48 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
437 | 2020-03-25 14:23:43 | surge | 1 | 28756 | 12 | 0.500 | 57512.0 |
436 | 2020-03-25 08:03:20 | surge | 1 | 28756 | 12 | 0.530 | 54256.6 |
435 | 2020-03-22 20:31:24 | surge | 1 | 28756 | 12 | 0.533 | 53951.2 |
434 | 2020-03-22 15:31:51 | surge | 1 | 28756 | 12 | 0.623 | 46157.3 |
433 | 2020-03-21 13:02:36 | surge | 1 | 28756 | 12 | 0.516 | 55728.7 |
432 | 2020-03-18 07:55:19 | surge | 1 | 28756 | 12 | 0.483 | 59536.2 |
431 | 2020-03-10 17:39:22 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
430 | 2020-02-23 09:17:55 | surge | 1 | 28756 | 12 | 0.763 | 37688.1 |
429 | 2020-02-22 22:39:37 | surge | 1 | 28756 | 12 | 0.533 | 53951.2 |
428 | 2020-02-22 08:37:32 | surge | 1 | 28756 | 12 | 0.546 | 52666.7 |
427 | 2020-02-14 08:01:27 | surge | 1 | 28756 | 12 | 1.750 | 16432.0 |
426 | 2020-02-10 16:08:57 | surge | 1 | 28756 | 12 | 0.546 | 52666.7 |
425 | 2020-02-08 09:52:34 | surge | 1 | 28756 | 12 | 1.186 | 24246.2 |
424 | 2020-01-28 19:35:06 | surge | 1 | 28756 | 12 | 0.546 | 52666.7 |
423 | 2020-01-28 16:27:34 | surge | 1 | 28756 | 12 | 0.516 | 55728.7 |
422 | 2020-01-26 17:56:07 | surge | 1 | 28756 | 12 | 0.923 | 31154.9 |
421 | 2020-01-25 22:36:12 | surge | 1 | 28756 | 12 | 0.450 | 63902.2 |
420 | 2020-01-22 15:44:14 | surge | 1 | 28756 | 12 | 1.110 | 25906.3 |
419 | 2020-01-21 16:13:41 | surge | 1 | 28756 | 12 | 0.563 | 51076.4 |
418 | 2020-01-21 04:08:21 | surge | 1 | 28756 | 12 | 1.780 | 16155.1 |
417 | 2020-01-10 22:46:38 | surge | 1 | 28756 | 12 | 0.486 | 59168.7 |
416 | 2020-01-10 04:56:34 | surge | 1 | 28756 | 12 | 0.800 | 35945.0 |
415 | 2020-01-06 22:06:55 | surge | 1 | 28756 | 12 | 1.843 | 15602.8 |
414 | 2020-01-02 23:56:00 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
413 | 2019-12-28 10:34:51 | surge | 1 | 28756 | 12 | 0.953 | 30174.2 |
412 | 2019-12-24 18:58:43 | surge | 1 | 28756 | 12 | 0.580 | 49579.3 |
411 | 2019-12-24 15:23:13 | surge | 1 | 28756 | 12 | 0.533 | 53951.2 |
410 | 2019-12-24 11:47:01 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
409 | 2019-12-24 08:06:00 | surge | 1 | 28756 | 12 | 0.453 | 63479.0 |
408 | 2019-12-11 05:57:07 | surge | 1 | 28756 | 12 | 0.516 | 55728.7 |