History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smell"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
479 | 2024-04-27 15:39:16 | smell | 1 | 28756 | 12 | 1.606 | 17905.4 |
478 | 2024-04-19 17:39:32 | smell | 2 | 53800 | 92 | 1.873 | 28724.0 |
477 | 2024-04-03 04:22:07 | smell | 1 | 28756 | 12 | 1.703 | 16885.5 |
476 | 2024-03-31 09:58:36 | smell | 3 | 83667 | 867 | 14.000 | 5976.2 |
475 | 2024-03-31 09:58:33 | smell | 2 | 53800 | 92 | 3.796 | 14172.8 |
474 | 2024-03-31 08:39:39 | smell | 1 | 28756 | 12 | 0.530 | 54256.6 |
473 | 2024-03-26 11:28:05 | smell | 1 | 28756 | 12 | 0.500 | 57512.0 |
472 | 2024-03-05 22:35:09 | smell | 3 | 83667 | 867 | 13.486 | 6204.0 |
471 | 2024-03-04 03:59:12 | smell | 2 | 53800 | 92 | 3.483 | 15446.5 |
470 | 2024-03-04 03:58:39 | smell | 3 | 83667 | 867 | 6.156 | 13591.1 |
469 | 2024-03-04 02:25:48 | smell | 3 | 83667 | 867 | 3.953 | 21165.4 |
468 | 2024-03-04 02:25:47 | smell | 2 | 53800 | 92 | 1.590 | 33836.5 |
467 | 2024-03-04 02:23:06 | smell | 1 | 28756 | 12 | 0.533 | 53951.2 |
466 | 2024-02-29 23:42:05 | smell | 1 | 28756 | 12 | 0.546 | 52666.7 |
465 | 2024-02-25 19:16:38 | smell | 1 | 28756 | 12 | 0.470 | 61183.0 |
464 | 2024-02-02 21:23:23 | smell | 1 | 28756 | 12 | 0.533 | 53951.2 |
463 | 2024-01-26 16:29:27 | smell | 3 | 83667 | 867 | 3.233 | 25879.1 |
462 | 2024-01-26 02:13:33 | smell | 3 | 83667 | 867 | 3.906 | 21420.1 |
461 | 2024-01-26 02:13:21 | smell | 1 | 28756 | 12 | 0.500 | 57512.0 |
460 | 2023-12-26 13:50:53 | smell | 3 | 83667 | 867 | 3.313 | 25254.2 |
459 | 2023-12-17 18:02:23 | smell | 1 | 28756 | 12 | 0.486 | 59168.7 |
458 | 2023-12-10 11:49:08 | smell | 2 | 53800 | 92 | 1.436 | 37465.2 |
457 | 2023-11-25 16:44:17 | smell | 3 | 83667 | 867 | 3.500 | 23904.9 |
456 | 2023-11-25 16:44:19 | smell | 2 | 53800 | 92 | 1.560 | 34487.2 |
455 | 2023-11-18 18:39:58 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
454 | 2023-11-18 18:04:24 | smell | 1 | 28756 | 12 | 0.483 | 59536.2 |
453 | 2023-10-28 11:12:29 | smell | 1 | 28756 | 12 | 0.440 | 65354.5 |
452 | 2023-10-27 05:43:17 | smell | 2 | 53800 | 92 | 1.436 | 37465.2 |
451 | 2023-10-27 05:43:14 | smell | 3 | 83667 | 867 | 3.406 | 24564.6 |
450 | 2023-10-25 20:08:23 | smell | 1 | 28756 | 12 | 1.043 | 27570.5 |
449 | 2023-10-22 02:07:28 | smell | 1 | 28756 | 12 | 0.456 | 63061.4 |
448 | 2023-10-18 13:12:25 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
447 | 2023-10-13 09:32:17 | smell | 1 | 28756 | 12 | 0.483 | 59536.2 |
446 | 2023-10-05 14:01:47 | smell | 1 | 28756 | 12 | 0.466 | 61708.2 |
445 | 2023-10-04 21:43:45 | smell | 1 | 28756 | 12 | 0.500 | 57512.0 |
444 | 2023-09-29 15:31:55 | smell | 3 | 83667 | 867 | 6.643 | 12594.8 |
443 | 2023-09-26 22:55:51 | smell | 3 | 83667 | 867 | 3.643 | 22966.5 |
442 | 2023-09-26 19:37:19 | smell | 1 | 28756 | 12 | 0.436 | 65954.1 |
441 | 2023-09-25 16:27:31 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
440 | 2023-09-22 22:12:21 | smell | 1 | 28756 | 12 | 0.500 | 57512.0 |
439 | 2023-09-13 19:59:40 | smell | 2 | 53800 | 92 | 1.546 | 34799.5 |
438 | 2023-09-08 18:41:49 | smell | 2 | 53800 | 92 | 1.360 | 39558.8 |
437 | 2023-08-01 06:03:09 | smell | 1 | 28756 | 12 | 0.436 | 65954.1 |
436 | 2023-07-06 14:51:43 | smell | 3 | 83667 | 867 | 3.813 | 21942.6 |
435 | 2023-06-17 16:17:42 | smell | 1 | 28756 | 12 | 0.500 | 57512.0 |
434 | 2023-05-29 18:47:19 | smell | 2 | 53800 | 92 | 1.390 | 38705.0 |
433 | 2023-05-21 02:08:55 | smell | 1 | 28756 | 12 | 0.483 | 59536.2 |
432 | 2023-04-27 20:51:26 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
431 | 2023-03-27 15:29:23 | smell | 3 | 83667 | 867 | 3.796 | 22040.8 |
430 | 2023-03-21 05:17:06 | smell | 1 | 28756 | 12 | 0.470 | 61183.0 |
429 | 2023-03-07 13:09:12 | smell | 2 | 53800 | 92 | 1.546 | 34799.5 |
428 | 2023-02-19 18:29:20 | smell | 1 | 28756 | 12 | 0.436 | 65954.1 |
427 | 2023-02-17 13:50:29 | smell | 1 | 28756 | 12 | 0.483 | 59536.2 |
426 | 2022-12-26 00:07:30 | smell | 3 | 83667 | 867 | 3.203 | 26121.4 |
425 | 2022-12-16 00:40:00 | smell | 1 | 28756 | 12 | 0.436 | 65954.1 |
424 | 2022-12-12 11:41:55 | smell | 2 | 53800 | 92 | 1.500 | 35866.7 |
423 | 2022-12-02 05:51:17 | smell | 3 | 83667 | 867 | 3.343 | 25027.5 |
422 | 2022-10-15 15:17:20 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
421 | 2022-09-25 18:51:54 | smell | 3 | 83667 | 867 | 3.376 | 24782.9 |
420 | 2022-09-10 21:25:16 | smell | 1 | 28756 | 12 | 0.516 | 55728.7 |
419 | 2022-08-31 14:09:54 | smell | 1 | 28756 | 12 | 0.500 | 57512.0 |
418 | 2022-08-25 11:04:09 | smell | 3 | 83667 | 867 | 3.236 | 25855.1 |
417 | 2022-08-22 11:34:31 | smell | 1 | 28756 | 12 | 0.436 | 65954.1 |
416 | 2022-08-15 05:50:20 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
415 | 2022-07-29 06:36:35 | smell | 1 | 28756 | 12 | 0.440 | 65354.5 |
414 | 2022-07-03 13:04:36 | smell | 2 | 53800 | 92 | 1.593 | 33772.8 |
413 | 2022-05-31 06:00:55 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
412 | 2022-04-14 06:30:59 | smell | 1 | 28756 | 12 | 0.563 | 51076.4 |
411 | 2022-04-12 00:55:11 | smell | 1 | 28756 | 12 | 0.500 | 57512.0 |
410 | 2022-03-20 15:29:19 | smell | 3 | 83667 | 867 | 4.126 | 20278.0 |
409 | 2022-02-19 04:11:53 | smell | 2 | 53800 | 92 | 1.766 | 30464.3 |
408 | 2022-01-19 17:02:57 | smell | 1 | 28756 | 12 | 0.436 | 65954.1 |
407 | 2022-01-16 10:45:16 | smell | 1 | 28756 | 12 | 0.483 | 59536.2 |
406 | 2022-01-13 03:50:13 | smell | 1 | 28756 | 12 | 0.500 | 57512.0 |
405 | 2022-01-10 00:05:36 | smell | 1 | 28756 | 12 | 0.546 | 52666.7 |
404 | 2021-11-13 10:42:17 | smell | 2 | 53800 | 92 | 1.796 | 29955.5 |
403 | 2021-11-06 01:04:53 | smell | 1 | 28756 | 12 | 0.500 | 57512.0 |
402 | 2021-11-04 00:37:26 | smell | 1 | 28756 | 12 | 0.436 | 65954.1 |
401 | 2021-09-21 10:05:51 | smell | 1 | 28756 | 12 | 0.576 | 49923.6 |
400 | 2021-09-20 23:06:16 | smell | 1 | 28756 | 12 | 0.483 | 59536.2 |
399 | 2021-09-11 21:24:53 | smell | 2 | 53800 | 92 | 1.546 | 34799.5 |
398 | 2021-09-06 06:16:14 | smell | 1 | 28756 | 12 | 0.483 | 59536.2 |
397 | 2021-06-22 16:40:01 | smell | 1 | 28756 | 12 | 0.470 | 61183.0 |
396 | 2021-05-08 16:02:04 | smell | 3 | 83667 | 867 | 4.190 | 19968.3 |
395 | 2021-04-03 11:05:08 | smell | 1 | 28756 | 12 | 0.483 | 59536.2 |
394 | 2021-03-19 06:54:02 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
393 | 2021-01-26 22:42:11 | smell | 3 | 83667 | 867 | 3.640 | 22985.4 |
392 | 2021-01-22 07:48:32 | smell | 3 | 83667 | 867 | 3.313 | 25254.2 |
391 | 2021-01-18 10:08:25 | smell | 1 | 28756 | 12 | 0.436 | 65954.1 |
390 | 2020-11-23 23:27:56 | smell | 1 | 28756 | 12 | 0.423 | 67981.1 |
389 | 2020-11-03 11:55:50 | smell | 1 | 28756 | 12 | 0.470 | 61183.0 |
388 | 2020-11-02 08:12:56 | smell | 3 | 83667 | 867 | 3.733 | 22412.8 |
387 | 2020-10-31 19:14:34 | smell | 1 | 28756 | 12 | 0.483 | 59536.2 |
386 | 2020-10-20 12:40:31 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
385 | 2020-10-04 07:13:13 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
384 | 2020-08-12 10:25:35 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
383 | 2020-07-27 22:05:11 | smell | 1 | 28756 | 12 | 0.500 | 57512.0 |
382 | 2020-07-16 10:02:46 | smell | 1 | 28756 | 12 | 0.500 | 57512.0 |
381 | 2020-04-29 09:42:16 | smell | 1 | 28756 | 12 | 0.453 | 63479.0 |
380 | 2020-03-25 19:48:29 | smell | 1 | 28756 | 12 | 0.530 | 54256.6 |