History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"odour"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
493 | 2024-04-21 10:02:12 | odour | 3 | 83667 | 477 | 7.390 | 11321.7 |
492 | 2024-04-21 07:26:17 | odour | 1 | 28756 | 4 | 0.546 | 52666.7 |
491 | 2024-04-21 07:26:05 | odour | 3 | 83667 | 477 | 6.593 | 12690.3 |
490 | 2024-04-21 07:26:06 | odour | 2 | 53800 | 39 | 4.686 | 11481.0 |
489 | 2024-04-21 07:25:59 | odour | 1 | 28756 | 4 | 1.313 | 21901.0 |
488 | 2024-04-09 16:21:12 | odour | 2 | 53800 | 39 | 1.486 | 36204.6 |
487 | 2024-04-06 12:09:45 | odour | 1 | 28756 | 4 | 0.530 | 54256.6 |
486 | 2024-03-30 15:08:54 | odour | 3 | 83667 | 477 | 13.110 | 6381.9 |
485 | 2024-03-28 23:28:35 | odour | 2 | 53800 | 39 | 1.810 | 29723.8 |
484 | 2024-03-28 23:28:17 | odour | 3 | 83667 | 477 | 4.186 | 19987.3 |
483 | 2024-03-17 19:36:48 | odour | 1 | 28756 | 4 | 0.516 | 55728.7 |
482 | 2024-03-12 19:32:08 | odour | 3 | 83667 | 477 | 4.233 | 19765.4 |
481 | 2024-03-12 19:32:09 | odour | 2 | 53800 | 39 | 3.500 | 15371.4 |
480 | 2024-03-11 17:30:55 | odour | 2 | 53800 | 39 | 4.983 | 10796.7 |
479 | 2024-03-11 17:30:40 | odour | 1 | 28756 | 4 | 1.143 | 25158.4 |
478 | 2024-03-11 17:29:49 | odour | 3 | 83667 | 477 | 8.906 | 9394.5 |
477 | 2024-03-07 09:32:59 | odour | 3 | 83667 | 477 | 10.970 | 7626.9 |
476 | 2024-03-07 09:32:59 | odour | 2 | 53800 | 39 | 5.640 | 9539.0 |
475 | 2024-03-07 06:04:59 | odour | 1 | 28756 | 4 | 0.560 | 51350.0 |
474 | 2024-03-05 18:59:40 | odour | 1 | 28756 | 4 | 1.703 | 16885.5 |
473 | 2024-02-27 09:16:06 | odour | 2 | 53800 | 39 | 1.826 | 29463.3 |
472 | 2024-02-27 09:15:39 | odour | 3 | 83667 | 477 | 4.560 | 18348.0 |
471 | 2024-02-26 22:51:00 | odour | 3 | 83667 | 477 | 4.110 | 20356.9 |
470 | 2024-02-26 22:50:59 | odour | 2 | 53800 | 39 | 1.783 | 30173.9 |
469 | 2024-02-25 18:32:16 | odour | 1 | 28756 | 4 | 0.860 | 33437.2 |
468 | 2024-02-14 18:19:00 | odour | 1 | 28756 | 4 | 0.580 | 49579.3 |
467 | 2024-02-12 13:21:57 | odour | 1 | 28756 | 4 | 0.546 | 52666.7 |
466 | 2024-02-03 18:55:31 | odour | 1 | 28756 | 4 | 0.470 | 61183.0 |
465 | 2024-02-01 01:38:17 | odour | 1 | 28756 | 4 | 0.513 | 56054.6 |
464 | 2024-01-26 11:22:37 | odour | 1 | 28756 | 4 | 0.530 | 54256.6 |
463 | 2024-01-13 12:58:17 | odour | 1 | 28756 | 4 | 0.516 | 55728.7 |
462 | 2024-01-08 04:23:36 | odour | 3 | 83667 | 477 | 3.453 | 24230.2 |
461 | 2024-01-08 04:23:35 | odour | 2 | 53800 | 39 | 1.423 | 37807.4 |
460 | 2024-01-07 10:37:31 | odour | 3 | 83667 | 477 | 3.266 | 25617.6 |
459 | 2024-01-01 10:57:26 | odour | 3 | 83667 | 477 | 3.360 | 24900.9 |
458 | 2023-12-11 05:32:03 | odour | 2 | 53800 | 39 | 1.593 | 33772.8 |
457 | 2023-12-08 01:48:17 | odour | 1 | 28756 | 4 | 0.516 | 55728.7 |
456 | 2023-12-08 01:48:16 | odour | 1 | 28756 | 4 | 0.500 | 57512.0 |
455 | 2023-12-06 00:56:36 | odour | 3 | 83667 | 477 | 3.250 | 25743.7 |
454 | 2023-12-06 00:56:34 | odour | 2 | 53800 | 39 | 1.373 | 39184.3 |
453 | 2023-11-30 19:10:56 | odour | 1 | 28756 | 4 | 0.470 | 61183.0 |
452 | 2023-11-23 14:19:54 | odour | 2 | 53800 | 39 | 1.483 | 36277.8 |
451 | 2023-11-23 04:00:08 | odour | 3 | 83667 | 477 | 4.156 | 20131.6 |
450 | 2023-11-15 14:00:58 | odour | 1 | 28756 | 4 | 0.436 | 65954.1 |
449 | 2023-11-15 12:05:23 | odour | 1 | 28756 | 4 | 0.436 | 65954.1 |
448 | 2023-11-09 12:57:31 | odour | 1 | 28756 | 4 | 0.436 | 65954.1 |
447 | 2023-11-02 01:41:10 | odour | 3 | 83667 | 477 | 3.610 | 23176.5 |
446 | 2023-11-02 01:41:04 | odour | 2 | 53800 | 39 | 1.626 | 33087.3 |
445 | 2023-10-28 03:30:05 | odour | 1 | 28756 | 4 | 0.516 | 55728.7 |
444 | 2023-10-21 03:50:38 | odour | 3 | 83667 | 477 | 4.156 | 20131.6 |
443 | 2023-10-21 03:50:36 | odour | 2 | 53800 | 39 | 3.280 | 16402.4 |
442 | 2023-10-20 22:00:02 | odour | 1 | 28756 | 4 | 0.436 | 65954.1 |
441 | 2023-10-17 10:29:15 | odour | 2 | 53800 | 39 | 1.563 | 34421.0 |
440 | 2023-10-16 23:12:52 | odour | 1 | 28756 | 4 | 0.530 | 54256.6 |
439 | 2023-10-10 23:44:29 | odour | 1 | 28756 | 4 | 0.516 | 55728.7 |
438 | 2023-10-10 23:40:44 | odour | 3 | 83667 | 477 | 3.720 | 22491.1 |
437 | 2023-10-05 22:58:40 | odour | 3 | 83667 | 477 | 3.640 | 22985.4 |
436 | 2023-10-04 13:59:50 | odour | 1 | 28756 | 4 | 0.453 | 63479.0 |
435 | 2023-09-26 17:53:46 | odour | 1 | 28756 | 4 | 0.436 | 65954.1 |
434 | 2023-09-25 03:33:28 | odour | 3 | 83667 | 477 | 3.610 | 23176.5 |
433 | 2023-09-22 05:52:12 | odour | 1 | 28756 | 4 | 0.503 | 57169.0 |
432 | 2023-09-19 13:50:55 | odour | 1 | 28756 | 4 | 0.440 | 65354.5 |
431 | 2023-09-19 12:58:21 | odour | 2 | 53800 | 39 | 1.546 | 34799.5 |
430 | 2023-09-16 07:16:15 | odour | 1 | 28756 | 4 | 0.483 | 59536.2 |
429 | 2023-09-15 02:58:45 | odour | 2 | 53800 | 39 | 1.546 | 34799.5 |
428 | 2023-09-10 14:47:14 | odour | 2 | 53800 | 39 | 1.346 | 39970.3 |
427 | 2023-07-17 08:49:31 | odour | 3 | 83667 | 477 | 3.313 | 25254.2 |
426 | 2023-06-29 03:13:52 | odour | 1 | 28756 | 4 | 0.466 | 61708.2 |
425 | 2023-06-05 14:31:12 | odour | 2 | 53800 | 39 | 1.486 | 36204.6 |
424 | 2023-05-27 15:07:43 | odour | 1 | 28756 | 4 | 0.470 | 61183.0 |
423 | 2023-05-15 12:28:26 | odour | 3 | 83667 | 477 | 3.236 | 25855.1 |
422 | 2023-04-08 13:17:02 | odour | 1 | 28756 | 4 | 0.420 | 68466.7 |
421 | 2023-04-01 15:14:27 | odour | 3 | 83667 | 477 | 3.300 | 25353.6 |
420 | 2023-03-11 03:57:07 | odour | 2 | 53800 | 39 | 1.533 | 35094.6 |
419 | 2023-02-06 05:32:26 | odour | 3 | 83667 | 477 | 3.783 | 22116.6 |
418 | 2023-01-31 22:03:31 | odour | 1 | 28756 | 4 | 0.440 | 65354.5 |
417 | 2023-01-28 06:51:50 | odour | 1 | 28756 | 4 | 0.420 | 68466.7 |
416 | 2023-01-24 15:41:49 | odour | 1 | 28756 | 4 | 0.436 | 65954.1 |
415 | 2022-12-29 11:55:24 | odour | 3 | 83667 | 477 | 3.830 | 21845.2 |
414 | 2022-12-20 22:07:01 | odour | 3 | 83667 | 477 | 3.700 | 22612.7 |
413 | 2022-12-16 12:59:47 | odour | 3 | 83667 | 477 | 3.876 | 21585.9 |
412 | 2022-12-14 23:59:03 | odour | 2 | 53800 | 39 | 1.343 | 40059.6 |
411 | 2022-12-13 16:09:35 | odour | 3 | 83667 | 477 | 3.203 | 26121.4 |
410 | 2022-11-28 12:20:07 | odour | 1 | 28756 | 4 | 0.516 | 55728.7 |
409 | 2022-11-22 02:51:55 | odour | 3 | 83667 | 477 | 3.360 | 24900.9 |
408 | 2022-11-11 20:52:54 | odour | 3 | 83667 | 477 | 3.436 | 24350.1 |
407 | 2022-11-05 14:19:35 | odour | 3 | 83667 | 477 | 3.563 | 23482.2 |
406 | 2022-11-03 23:35:50 | odour | 3 | 83667 | 477 | 3.280 | 25508.2 |
405 | 2022-10-07 10:30:22 | odour | 3 | 83667 | 477 | 3.313 | 25254.2 |
404 | 2022-09-22 07:21:23 | odour | 1 | 28756 | 4 | 0.420 | 68466.7 |
403 | 2022-09-12 23:18:29 | odour | 3 | 83667 | 477 | 3.403 | 24586.2 |
402 | 2022-09-01 00:29:59 | odour | 3 | 83667 | 477 | 3.296 | 25384.4 |
401 | 2022-08-04 13:23:03 | odour | 2 | 53800 | 39 | 1.546 | 34799.5 |
400 | 2022-07-23 22:17:32 | odour | 1 | 28756 | 4 | 0.420 | 68466.7 |
399 | 2022-07-21 14:36:05 | odour | 1 | 28756 | 4 | 0.453 | 63479.0 |
398 | 2022-06-26 01:12:35 | odour | 1 | 28756 | 4 | 0.436 | 65954.1 |
397 | 2022-05-23 06:52:32 | odour | 1 | 28756 | 4 | 0.436 | 65954.1 |
396 | 2022-05-19 21:20:04 | odour | 1 | 28756 | 4 | 0.453 | 63479.0 |
395 | 2022-03-21 00:22:59 | odour | 1 | 28756 | 4 | 0.436 | 65954.1 |
394 | 2022-03-18 21:42:01 | odour | 1 | 28756 | 4 | 0.546 | 52666.7 |