History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pantries"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
493 | 2024-04-01 18:48:49 | pantries | 1 | 82945 | 5 | 3.483 | 23814.2 |
492 | 2024-03-29 11:37:32 | pantries | 1 | 82945 | 5 | 3.470 | 23903.5 |
491 | 2024-03-18 00:45:00 | pantries | 3 | 146162 | 348 | 14.296 | 10224.0 |
490 | 2024-03-17 14:50:46 | pantries | 3 | 146162 | 348 | 7.763 | 18828.0 |
489 | 2024-03-07 12:42:47 | pantries | 1 | 82945 | 5 | 1.310 | 63316.8 |
488 | 2024-03-01 13:23:48 | pantries | 3 | 146162 | 348 | 9.766 | 14966.4 |
487 | 2024-02-29 23:18:52 | pantries | 1 | 82945 | 5 | 1.940 | 42755.2 |
486 | 2024-02-29 17:12:10 | pantries | 1 | 82945 | 5 | 1.936 | 42843.5 |
485 | 2024-02-28 15:42:47 | pantries | 2 | 121059 | 35 | 14.530 | 8331.7 |
484 | 2024-02-28 03:48:43 | pantries | 2 | 121059 | 35 | 9.970 | 12142.3 |
483 | 2024-02-28 03:47:25 | pantries | 3 | 146162 | 348 | 9.203 | 15882.0 |
482 | 2024-02-28 03:46:58 | pantries | 3 | 146162 | 348 | 8.686 | 16827.3 |
481 | 2024-02-28 03:46:58 | pantries | 2 | 121059 | 35 | 4.313 | 28068.4 |
480 | 2024-02-28 03:46:56 | pantries | 1 | 82945 | 5 | 1.596 | 51970.6 |
479 | 2024-01-08 23:14:31 | pantries | 3 | 146162 | 348 | 7.796 | 18748.3 |
478 | 2024-01-08 23:14:34 | pantries | 2 | 121059 | 35 | 4.126 | 29340.5 |
477 | 2023-12-10 19:44:08 | pantries | 1 | 82945 | 5 | 1.330 | 62364.7 |
476 | 2023-12-01 04:02:09 | pantries | 2 | 121059 | 35 | 3.953 | 30624.6 |
475 | 2023-11-30 14:48:37 | pantries | 3 | 146162 | 348 | 6.423 | 22756.0 |
474 | 2023-11-29 22:47:49 | pantries | 3 | 146162 | 348 | 7.046 | 20744.0 |
473 | 2023-11-28 03:51:00 | pantries | 1 | 82945 | 5 | 1.466 | 56579.1 |
472 | 2023-11-28 03:42:54 | pantries | 1 | 82945 | 5 | 1.453 | 57085.3 |
471 | 2023-11-10 04:01:01 | pantries | 1 | 82945 | 5 | 1.420 | 58412.0 |
470 | 2023-11-05 09:19:48 | pantries | 1 | 82945 | 5 | 1.280 | 64800.8 |
469 | 2023-10-31 20:57:38 | pantries | 1 | 82945 | 5 | 1.610 | 51518.6 |
468 | 2023-10-17 21:47:48 | pantries | 1 | 82945 | 5 | 1.390 | 59672.7 |
467 | 2023-09-29 18:48:11 | pantries | 1 | 82945 | 5 | 1.296 | 64000.8 |
466 | 2023-09-26 04:27:24 | pantries | 1 | 82945 | 5 | 1.513 | 54821.5 |
465 | 2023-09-26 01:03:47 | pantries | 1 | 82945 | 5 | 1.530 | 54212.4 |
464 | 2023-08-29 17:49:02 | pantries | 3 | 146162 | 348 | 6.356 | 22995.9 |
463 | 2023-08-05 02:19:51 | pantries | 1 | 82945 | 5 | 1.503 | 55186.3 |
462 | 2023-07-25 03:54:05 | pantries | 1 | 82945 | 5 | 1.300 | 63803.8 |
461 | 2023-05-26 08:16:38 | pantries | 3 | 146162 | 348 | 7.686 | 19016.7 |
460 | 2023-05-14 15:59:49 | pantries | 3 | 146162 | 348 | 6.330 | 23090.4 |
459 | 2023-04-27 14:15:49 | pantries | 1 | 82945 | 5 | 1.436 | 57761.1 |
458 | 2023-03-23 12:00:27 | pantries | 3 | 146162 | 348 | 6.420 | 22766.7 |
457 | 2023-02-20 21:53:53 | pantries | 3 | 146162 | 348 | 6.313 | 23152.5 |
456 | 2023-01-18 23:35:06 | pantries | 1 | 82945 | 5 | 1.546 | 53651.4 |
455 | 2022-12-02 23:12:04 | pantries | 3 | 146162 | 348 | 7.796 | 18748.3 |
454 | 2022-10-01 06:31:26 | pantries | 1 | 82945 | 5 | 1.313 | 63172.1 |
453 | 2022-07-11 10:45:39 | pantries | 3 | 146162 | 348 | 6.936 | 21073.0 |
452 | 2022-06-07 01:02:10 | pantries | 1 | 82945 | 5 | 1.313 | 63172.1 |
451 | 2022-05-16 05:02:46 | pantries | 1 | 82945 | 5 | 1.343 | 61761.0 |
450 | 2022-05-04 13:45:51 | pantries | 1 | 82945 | 5 | 1.326 | 62552.8 |
449 | 2022-02-20 05:20:05 | pantries | 1 | 82945 | 5 | 1.440 | 57600.7 |
448 | 2022-02-16 21:07:08 | pantries | 1 | 82945 | 5 | 1.436 | 57761.1 |
447 | 2022-01-23 13:25:08 | pantries | 1 | 82945 | 5 | 1.360 | 60989.0 |
446 | 2022-01-21 09:50:02 | pantries | 1 | 82945 | 5 | 1.656 | 50087.6 |
445 | 2022-01-04 21:25:20 | pantries | 1 | 82945 | 5 | 1.393 | 59544.1 |
444 | 2021-11-21 16:45:13 | pantries | 1 | 82945 | 5 | 1.326 | 62552.8 |
443 | 2021-11-17 00:13:37 | pantries | 1 | 82945 | 5 | 1.343 | 61761.0 |
442 | 2021-11-08 21:23:08 | pantries | 1 | 82945 | 5 | 1.453 | 57085.3 |
441 | 2021-10-19 05:56:26 | pantries | 1 | 82945 | 5 | 1.356 | 61168.9 |
440 | 2021-09-04 18:24:31 | pantries | 1 | 82945 | 5 | 1.500 | 55296.7 |
439 | 2021-08-15 23:31:00 | pantries | 1 | 82945 | 5 | 1.296 | 64000.8 |
438 | 2021-08-09 06:33:17 | pantries | 1 | 82945 | 5 | 1.483 | 55930.5 |
437 | 2021-08-05 19:33:56 | pantries | 1 | 82945 | 5 | 1.360 | 60989.0 |
436 | 2021-05-01 18:46:16 | pantries | 1 | 82945 | 5 | 1.563 | 53067.8 |
435 | 2021-04-08 02:35:40 | pantries | 3 | 146162 | 348 | 7.110 | 20557.2 |
434 | 2021-02-15 17:07:53 | pantries | 3 | 146162 | 348 | 6.686 | 21860.9 |
433 | 2021-01-29 08:58:21 | pantries | 1 | 82945 | 5 | 1.313 | 63172.1 |
432 | 2021-01-27 08:01:32 | pantries | 1 | 82945 | 5 | 1.470 | 56425.2 |
431 | 2021-01-27 07:24:41 | pantries | 1 | 82945 | 5 | 1.326 | 62552.8 |
430 | 2020-11-10 22:29:07 | pantries | 1 | 82945 | 5 | 1.390 | 59672.7 |
429 | 2020-10-26 14:35:12 | pantries | 1 | 82945 | 5 | 1.470 | 56425.2 |
428 | 2020-10-21 22:45:46 | pantries | 1 | 82945 | 5 | 1.373 | 60411.5 |
427 | 2020-10-17 18:26:19 | pantries | 1 | 82945 | 5 | 1.516 | 54713.1 |
426 | 2020-09-24 06:45:23 | pantries | 1 | 82945 | 5 | 1.330 | 62364.7 |
425 | 2020-09-16 09:05:35 | pantries | 1 | 82945 | 5 | 1.483 | 55930.5 |
424 | 2020-08-27 03:14:51 | pantries | 1 | 82945 | 5 | 1.453 | 57085.3 |
423 | 2020-08-24 14:47:58 | pantries | 1 | 82945 | 5 | 1.486 | 55817.6 |
422 | 2020-07-30 03:43:12 | pantries | 1 | 82945 | 5 | 1.546 | 53651.4 |
421 | 2020-07-26 04:50:31 | pantries | 1 | 82945 | 5 | 1.360 | 60989.0 |
420 | 2020-07-23 13:52:33 | pantries | 1 | 82945 | 5 | 1.360 | 60989.0 |
419 | 2020-06-10 15:30:16 | pantries | 1 | 82945 | 5 | 1.483 | 55930.5 |
418 | 2020-04-23 22:47:32 | pantries | 1 | 82945 | 5 | 1.483 | 55930.5 |
417 | 2020-03-28 16:07:32 | pantries | 1 | 82945 | 5 | 1.593 | 52068.4 |
416 | 2020-03-28 06:12:03 | pantries | 1 | 82945 | 5 | 1.546 | 53651.4 |
415 | 2020-03-24 13:38:37 | pantries | 1 | 82945 | 5 | 1.313 | 63172.1 |
414 | 2020-03-23 18:09:47 | pantries | 1 | 82945 | 5 | 1.516 | 54713.1 |
413 | 2020-03-20 03:27:08 | pantries | 1 | 82945 | 5 | 1.360 | 60989.0 |
412 | 2020-03-07 23:11:00 | pantries | 1 | 82945 | 5 | 1.296 | 64000.8 |
411 | 2020-03-05 22:40:27 | pantries | 1 | 82945 | 5 | 1.640 | 50576.2 |
410 | 2020-03-05 18:20:00 | pantries | 1 | 82945 | 5 | 1.750 | 47397.1 |
409 | 2020-02-25 11:37:35 | pantries | 1 | 82945 | 5 | 1.500 | 55296.7 |
408 | 2020-02-24 11:26:59 | pantries | 1 | 82945 | 5 | 1.640 | 50576.2 |
407 | 2020-02-24 08:38:44 | pantries | 1 | 82945 | 5 | 1.906 | 43517.8 |
406 | 2020-02-15 01:01:10 | pantries | 3 | 146162 | 348 | 9.263 | 15779.1 |
405 | 2020-02-14 23:46:57 | pantries | 3 | 146162 | 348 | 18.936 | 7718.7 |
404 | 2020-02-14 18:38:48 | pantries | 3 | 146162 | 348 | 8.686 | 16827.3 |
403 | 2020-02-13 01:27:26 | pantries | 1 | 82945 | 5 | 2.876 | 28840.4 |
402 | 2020-02-07 19:35:05 | pantries | 3 | 146162 | 348 | 11.656 | 12539.6 |
401 | 2020-02-06 22:50:05 | pantries | 3 | 146162 | 348 | 11.533 | 12673.4 |
400 | 2020-02-05 01:59:39 | pantries | 3 | 146162 | 348 | 12.860 | 11365.6 |
399 | 2020-02-03 23:39:53 | pantries | 1 | 82945 | 5 | 3.390 | 24467.6 |
398 | 2020-02-03 10:40:20 | pantries | 1 | 82945 | 5 | 1.550 | 53512.9 |
397 | 2020-01-31 20:13:00 | pantries | 1 | 82945 | 5 | 1.610 | 51518.6 |
396 | 2020-01-30 21:42:39 | pantries | 1 | 82945 | 5 | 5.390 | 15388.7 |
395 | 2020-01-26 13:21:15 | pantries | 1 | 82945 | 5 | 1.856 | 44690.2 |
394 | 2020-01-24 00:23:39 | pantries | 1 | 82945 | 5 | 1.500 | 55296.7 |