History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stock"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
491 | 2024-04-28 02:41:05 | stock | 1 | 28756 | 11 | 1.140 | 25224.6 |
490 | 2024-04-27 09:29:08 | stock | 1 | 28756 | 11 | 0.750 | 38341.3 |
489 | 2024-04-02 20:52:10 | stock | 1 | 28756 | 11 | 0.486 | 59168.7 |
488 | 2024-03-31 03:41:13 | stock | 1 | 28756 | 11 | 0.530 | 54256.6 |
487 | 2024-03-29 02:22:52 | stock | 1 | 28756 | 11 | 0.546 | 52666.7 |
486 | 2024-03-13 22:18:50 | stock | 1 | 28756 | 11 | 0.530 | 54256.6 |
485 | 2024-02-27 20:24:44 | stock | 1 | 28756 | 11 | 0.486 | 59168.7 |
484 | 2024-01-14 09:06:46 | stock | 2 | 53800 | 120 | 1.406 | 38264.6 |
483 | 2024-01-10 18:06:39 | stock | 2 | 53800 | 120 | 1.483 | 36277.8 |
482 | 2023-12-30 00:34:48 | stock | 2 | 53800 | 120 | 1.560 | 34487.2 |
481 | 2023-12-25 09:34:04 | stock | 2 | 53800 | 120 | 1.576 | 34137.1 |
480 | 2023-12-14 19:34:24 | stock | 1 | 28756 | 11 | 0.530 | 54256.6 |
479 | 2023-12-12 21:00:28 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
478 | 2023-11-17 04:42:04 | stock | 1 | 28756 | 11 | 0.516 | 55728.7 |
477 | 2023-11-15 14:36:00 | stock | 2 | 53800 | 120 | 1.563 | 34421.0 |
476 | 2023-11-12 09:53:26 | stock | 1 | 28756 | 11 | 0.516 | 55728.7 |
475 | 2023-11-03 19:11:41 | stock | 2 | 53800 | 120 | 1.653 | 32546.9 |
474 | 2023-10-30 23:13:20 | stock | 1 | 28756 | 11 | 1.063 | 27051.7 |
473 | 2023-10-30 02:20:28 | stock | 2 | 53800 | 120 | 1.533 | 35094.6 |
472 | 2023-10-26 14:54:46 | stock | 1 | 28756 | 11 | 0.596 | 48248.3 |
471 | 2023-10-22 02:26:41 | stock | 1 | 28756 | 11 | 0.453 | 63479.0 |
470 | 2023-10-20 17:52:53 | stock | 2 | 53800 | 120 | 1.436 | 37465.2 |
469 | 2023-10-18 21:03:39 | stock | 1 | 28756 | 11 | 0.593 | 48492.4 |
468 | 2023-10-14 08:12:02 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
467 | 2023-10-07 12:30:49 | stock | 1 | 28756 | 11 | 0.453 | 63479.0 |
466 | 2023-10-01 15:43:10 | stock | 1 | 28756 | 11 | 0.436 | 65954.1 |
465 | 2023-09-23 11:20:16 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
464 | 2023-08-09 18:06:25 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
463 | 2023-07-31 05:28:11 | stock | 2 | 53800 | 120 | 1.623 | 33148.5 |
462 | 2023-07-28 10:08:22 | stock | 1 | 28756 | 11 | 0.453 | 63479.0 |
461 | 2023-04-24 22:53:26 | stock | 1 | 28756 | 11 | 0.456 | 63061.4 |
460 | 2023-04-21 03:34:22 | stock | 1 | 28756 | 11 | 0.516 | 55728.7 |
459 | 2023-04-07 03:31:06 | stock | 2 | 53800 | 120 | 1.360 | 39558.8 |
458 | 2023-02-15 00:49:36 | stock | 1 | 28756 | 11 | 0.470 | 61183.0 |
457 | 2023-01-05 02:27:13 | stock | 2 | 53800 | 120 | 1.360 | 39558.8 |
456 | 2023-01-01 05:49:03 | stock | 1 | 28756 | 11 | 0.440 | 65354.5 |
455 | 2022-12-14 01:37:50 | stock | 1 | 28756 | 11 | 0.440 | 65354.5 |
454 | 2022-09-10 20:13:18 | stock | 2 | 53800 | 120 | 1.466 | 36698.5 |
453 | 2022-08-24 15:24:35 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
452 | 2022-08-16 01:09:38 | stock | 1 | 28756 | 11 | 0.453 | 63479.0 |
451 | 2022-08-13 14:31:02 | stock | 1 | 28756 | 11 | 0.453 | 63479.0 |
450 | 2022-07-29 04:28:20 | stock | 1 | 28756 | 11 | 0.436 | 65954.1 |
449 | 2022-04-23 22:00:09 | stock | 1 | 28756 | 11 | 0.466 | 61708.2 |
448 | 2022-03-31 11:26:20 | stock | 1 | 28756 | 11 | 0.513 | 56054.6 |
447 | 2022-03-29 07:18:24 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
446 | 2022-02-23 09:05:40 | stock | 2 | 53800 | 120 | 1.780 | 30224.7 |
445 | 2022-02-23 08:59:09 | stock | 1 | 28756 | 11 | 0.486 | 59168.7 |
444 | 2022-01-02 01:36:11 | stock | 1 | 28756 | 11 | 0.580 | 49579.3 |
443 | 2021-12-29 00:08:12 | stock | 1 | 28756 | 11 | 0.450 | 63902.2 |
442 | 2021-11-04 14:38:31 | stock | 1 | 28756 | 11 | 0.513 | 56054.6 |
441 | 2021-09-26 06:12:49 | stock | 1 | 28756 | 11 | 0.516 | 55728.7 |
440 | 2021-09-12 06:23:54 | stock | 1 | 28756 | 11 | 0.453 | 63479.0 |
439 | 2021-09-04 16:56:15 | stock | 1 | 28756 | 11 | 0.453 | 63479.0 |
438 | 2021-09-02 11:06:08 | stock | 1 | 28756 | 11 | 0.466 | 61708.2 |
437 | 2021-08-01 10:19:32 | stock | 2 | 53800 | 120 | 1.453 | 37026.8 |
436 | 2021-06-16 13:29:23 | stock | 2 | 53800 | 120 | 1.563 | 34421.0 |
435 | 2021-06-11 23:47:07 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
434 | 2021-05-30 03:58:40 | stock | 2 | 53800 | 120 | 1.766 | 30464.3 |
433 | 2021-05-25 17:18:36 | stock | 1 | 28756 | 11 | 0.470 | 61183.0 |
432 | 2021-05-17 10:21:53 | stock | 1 | 28756 | 11 | 0.516 | 55728.7 |
431 | 2021-05-08 08:45:07 | stock | 2 | 53800 | 120 | 1.640 | 32804.9 |
430 | 2021-04-29 10:23:45 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
429 | 2021-03-28 23:02:34 | stock | 1 | 28756 | 11 | 0.516 | 55728.7 |
428 | 2021-03-27 04:37:44 | stock | 2 | 53800 | 120 | 1.390 | 38705.0 |
427 | 2021-03-12 14:34:50 | stock | 1 | 28756 | 11 | 0.453 | 63479.0 |
426 | 2021-02-20 08:56:15 | stock | 1 | 28756 | 11 | 0.470 | 61183.0 |
425 | 2021-02-14 15:56:06 | stock | 2 | 53800 | 120 | 1.576 | 34137.1 |
424 | 2021-02-07 02:31:05 | stock | 1 | 28756 | 11 | 0.453 | 63479.0 |
423 | 2021-02-04 14:35:18 | stock | 1 | 28756 | 11 | 0.533 | 53951.2 |
422 | 2021-01-10 13:25:04 | stock | 2 | 53800 | 120 | 1.390 | 38705.0 |
421 | 2020-12-12 02:48:55 | stock | 2 | 53800 | 120 | 1.390 | 38705.0 |
420 | 2020-12-05 11:25:26 | stock | 1 | 28756 | 11 | 0.436 | 65954.1 |
419 | 2020-10-22 16:23:56 | stock | 1 | 28756 | 11 | 0.533 | 53951.2 |
418 | 2020-09-15 17:37:03 | stock | 2 | 53800 | 120 | 1.390 | 38705.0 |
417 | 2020-09-07 13:02:18 | stock | 2 | 53800 | 120 | 1.483 | 36277.8 |
416 | 2020-08-28 12:16:30 | stock | 1 | 28756 | 11 | 0.486 | 59168.7 |
415 | 2020-08-24 03:44:34 | stock | 1 | 28756 | 11 | 0.453 | 63479.0 |
414 | 2020-07-21 12:42:22 | stock | 2 | 53800 | 120 | 1.470 | 36598.6 |
413 | 2020-07-19 10:30:51 | stock | 2 | 53800 | 120 | 1.893 | 28420.5 |
412 | 2020-06-17 04:03:07 | stock | 1 | 28756 | 11 | 0.486 | 59168.7 |
411 | 2020-05-13 12:14:43 | stock | 1 | 28756 | 11 | 0.483 | 59536.2 |
410 | 2020-03-25 22:47:57 | stock | 1 | 28756 | 11 | 0.533 | 53951.2 |
409 | 2020-03-23 19:42:18 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
408 | 2020-03-23 19:33:14 | stock | 1 | 28756 | 11 | 0.486 | 59168.7 |
407 | 2020-03-23 15:36:03 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
406 | 2020-03-23 03:41:49 | stock | 1 | 28756 | 11 | 0.483 | 59536.2 |
405 | 2020-03-21 15:07:16 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
404 | 2020-03-18 09:37:49 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
403 | 2020-02-27 04:23:13 | stock | 1 | 28756 | 11 | 0.436 | 65954.1 |
402 | 2020-02-27 01:26:19 | stock | 1 | 28756 | 11 | 0.783 | 36725.4 |
401 | 2020-02-24 16:54:20 | stock | 1 | 28756 | 11 | 0.530 | 54256.6 |
400 | 2020-02-22 13:54:51 | stock | 1 | 28756 | 11 | 1.000 | 28756.0 |
399 | 2020-02-22 12:51:52 | stock | 1 | 28756 | 11 | 0.550 | 52283.6 |
398 | 2020-02-12 06:08:36 | stock | 1 | 28756 | 11 | 1.530 | 18794.8 |
397 | 2020-02-10 21:23:28 | stock | 1 | 28756 | 11 | 0.563 | 51076.4 |
396 | 2020-02-02 21:44:06 | stock | 1 | 28756 | 11 | 1.670 | 17219.2 |
395 | 2020-02-02 04:32:19 | stock | 1 | 28756 | 11 | 1.140 | 25224.6 |
394 | 2020-01-30 15:17:41 | stock | 1 | 28756 | 11 | 0.516 | 55728.7 |
393 | 2020-01-29 21:17:53 | stock | 1 | 28756 | 11 | 0.530 | 54256.6 |
392 | 2020-01-25 19:53:32 | stock | 1 | 28756 | 11 | 1.063 | 27051.7 |