History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"andesite"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
489 | 2024-05-11 02:56:41 | andesite | 1 | 82945 | 3 | 3.516 | 23590.7 |
488 | 2024-05-03 16:34:13 | andesite | 1 | 82945 | 3 | 1.503 | 55186.3 |
487 | 2024-05-03 07:17:00 | andesite | 1 | 82945 | 3 | 1.580 | 52496.8 |
486 | 2024-05-02 16:35:35 | andesite | 2 | 121059 | 7 | 8.453 | 14321.4 |
485 | 2024-05-02 16:14:28 | andesite | 3 | 146162 | 46 | 8.876 | 16467.1 |
484 | 2024-05-02 06:36:00 | andesite | 1 | 82945 | 3 | 3.330 | 24908.4 |
483 | 2024-05-01 20:47:49 | andesite | 3 | 146162 | 46 | 17.186 | 8504.7 |
482 | 2024-05-01 20:47:53 | andesite | 2 | 121059 | 7 | 11.610 | 10427.1 |
481 | 2024-04-29 22:09:19 | andesite | 2 | 121059 | 7 | 3.966 | 30524.2 |
480 | 2024-04-29 22:06:55 | andesite | 3 | 146162 | 46 | 6.766 | 21602.4 |
479 | 2024-04-29 19:56:38 | andesite | 2 | 121059 | 7 | 3.673 | 32959.2 |
478 | 2024-04-29 19:56:34 | andesite | 3 | 146162 | 46 | 7.423 | 19690.4 |
477 | 2024-04-29 19:56:30 | andesite | 1 | 82945 | 3 | 1.466 | 56579.1 |
476 | 2024-04-29 19:56:09 | andesite | 2 | 121059 | 7 | 3.703 | 32692.1 |
475 | 2024-04-29 16:58:14 | andesite | 4 | 161609 | 695 | 13.703 | 11793.7 |
474 | 2024-04-28 19:40:23 | andesite | 3 | 146162 | 46 | 14.530 | 10059.3 |
473 | 2024-04-28 19:03:08 | andesite | 4 | 161609 | 695 | 13.203 | 12240.3 |
472 | 2024-04-28 16:46:59 | andesite | 4 | 161609 | 695 | 21.686 | 7452.2 |
471 | 2024-04-28 15:12:18 | andesite | 4 | 161609 | 695 | 25.156 | 6424.3 |
470 | 2024-04-28 12:47:13 | andesite | 3 | 146162 | 46 | 23.940 | 6105.3 |
469 | 2024-04-28 12:47:09 | andesite | 4 | 161609 | 695 | 24.673 | 6550.0 |
468 | 2024-04-28 12:47:12 | andesite | 2 | 121059 | 7 | 5.373 | 22531.0 |
467 | 2024-04-28 12:10:37 | andesite | 1 | 82945 | 3 | 1.500 | 55296.7 |
466 | 2024-04-03 17:05:51 | andesite | 1 | 82945 | 3 | 4.003 | 20720.7 |
465 | 2024-03-26 11:04:42 | andesite | 3 | 146162 | 46 | 6.516 | 22431.2 |
464 | 2024-03-26 11:04:37 | andesite | 2 | 121059 | 7 | 3.466 | 34927.6 |
463 | 2024-03-25 07:26:00 | andesite | 1 | 82945 | 3 | 1.313 | 63172.1 |
462 | 2024-03-25 00:34:31 | andesite | 1 | 82945 | 3 | 1.420 | 58412.0 |
461 | 2024-03-22 10:40:05 | andesite | 3 | 146162 | 46 | 7.763 | 18828.0 |
460 | 2024-03-22 10:40:04 | andesite | 2 | 121059 | 7 | 3.830 | 31608.1 |
459 | 2024-03-20 05:28:07 | andesite | 3 | 146162 | 46 | 9.283 | 15745.1 |
458 | 2024-03-20 05:28:08 | andesite | 2 | 121059 | 7 | 4.016 | 30144.2 |
457 | 2024-03-20 05:28:00 | andesite | 1 | 82945 | 3 | 2.420 | 34274.8 |
456 | 2024-03-20 05:27:53 | andesite | 3 | 146162 | 46 | 8.580 | 17035.2 |
455 | 2024-03-20 05:27:53 | andesite | 2 | 121059 | 7 | 3.720 | 32542.7 |
454 | 2024-03-20 05:27:50 | andesite | 1 | 82945 | 3 | 1.360 | 60989.0 |
453 | 2024-03-08 12:13:19 | andesite | 4 | 161609 | 695 | 34.003 | 4752.8 |
452 | 2024-03-08 09:10:30 | andesite | 4 | 161609 | 695 | 45.223 | 3573.6 |
451 | 2024-03-08 00:49:58 | andesite | 4 | 161609 | 695 | 20.360 | 7937.6 |
450 | 2024-03-07 15:46:49 | andesite | 4 | 161609 | 695 | 16.313 | 9906.8 |
449 | 2024-03-07 13:17:30 | andesite | 1 | 82945 | 3 | 1.376 | 60279.8 |
448 | 2024-02-08 01:08:51 | andesite | 3 | 146162 | 46 | 16.690 | 8757.5 |
447 | 2024-02-04 17:52:02 | andesite | 3 | 146162 | 46 | 8.436 | 17326.0 |
446 | 2024-02-04 08:24:42 | andesite | 4 | 161609 | 695 | 13.656 | 11834.3 |
445 | 2024-02-04 05:10:35 | andesite | 3 | 146162 | 46 | 7.233 | 20207.7 |
444 | 2024-02-04 05:10:07 | andesite | 4 | 161609 | 695 | 14.546 | 11110.2 |
443 | 2024-02-04 03:29:54 | andesite | 2 | 121059 | 7 | 3.970 | 30493.5 |
442 | 2024-02-04 03:29:50 | andesite | 1 | 82945 | 3 | 1.530 | 54212.4 |
441 | 2024-02-01 01:38:48 | andesite | 2 | 121059 | 7 | 3.830 | 31608.1 |
440 | 2024-02-01 01:36:56 | andesite | 3 | 146162 | 46 | 9.610 | 15209.4 |
439 | 2024-01-31 12:10:19 | andesite | 3 | 146162 | 46 | 10.046 | 14549.3 |
438 | 2024-01-31 08:11:34 | andesite | 4 | 161609 | 695 | 13.766 | 11739.7 |
437 | 2024-01-31 02:19:23 | andesite | 4 | 161609 | 695 | 12.640 | 12785.5 |
436 | 2024-01-30 23:18:47 | andesite | 4 | 161609 | 695 | 24.156 | 6690.2 |
435 | 2024-01-30 23:18:51 | andesite | 2 | 121059 | 7 | 3.953 | 30624.6 |
434 | 2024-01-30 23:17:31 | andesite | 3 | 146162 | 46 | 7.593 | 19249.6 |
433 | 2024-01-30 09:20:40 | andesite | 3 | 146162 | 46 | 7.376 | 19815.9 |
432 | 2024-01-17 16:05:24 | andesite | 1 | 82945 | 3 | 1.283 | 64649.3 |
431 | 2023-12-26 23:48:56 | andesite | 4 | 161609 | 695 | 13.703 | 11793.7 |
430 | 2023-12-23 19:38:48 | andesite | 4 | 161609 | 695 | 10.596 | 15251.9 |
429 | 2023-12-21 03:20:53 | andesite | 1 | 82945 | 3 | 1.266 | 65517.4 |
428 | 2023-12-18 04:15:03 | andesite | 4 | 161609 | 695 | 10.890 | 14840.1 |
427 | 2023-12-18 04:14:56 | andesite | 2 | 121059 | 7 | 3.236 | 37410.1 |
426 | 2023-12-16 23:35:55 | andesite | 1 | 82945 | 3 | 1.546 | 53651.4 |
425 | 2023-12-09 09:58:07 | andesite | 1 | 82945 | 3 | 3.280 | 25288.1 |
424 | 2023-12-03 17:34:09 | andesite | 3 | 146162 | 46 | 7.766 | 18820.8 |
423 | 2023-11-29 11:03:38 | andesite | 1 | 82945 | 3 | 1.280 | 64800.8 |
422 | 2023-11-27 07:36:34 | andesite | 1 | 82945 | 3 | 1.390 | 59672.7 |
421 | 2023-11-13 21:43:43 | andesite | 1 | 82945 | 3 | 1.436 | 57761.1 |
420 | 2023-11-12 00:47:23 | andesite | 3 | 146162 | 46 | 8.156 | 17920.8 |
419 | 2023-11-07 19:41:55 | andesite | 3 | 146162 | 46 | 6.266 | 23326.2 |
418 | 2023-10-23 19:31:59 | andesite | 1 | 82945 | 3 | 1.576 | 52630.1 |
417 | 2023-10-09 05:57:12 | andesite | 1 | 82945 | 3 | 1.296 | 64000.8 |
416 | 2023-10-08 11:27:29 | andesite | 1 | 82945 | 3 | 1.436 | 57761.1 |
415 | 2023-08-24 02:35:52 | andesite | 1 | 82945 | 3 | 1.280 | 64800.8 |
414 | 2023-08-11 06:08:14 | andesite | 3 | 146162 | 46 | 6.376 | 22923.8 |
413 | 2023-08-04 19:28:38 | andesite | 1 | 82945 | 3 | 1.330 | 62364.7 |
412 | 2023-05-14 02:37:17 | andesite | 1 | 82945 | 3 | 1.313 | 63172.1 |
411 | 2023-05-04 19:22:47 | andesite | 1 | 82945 | 3 | 1.280 | 64800.8 |
410 | 2023-04-23 19:48:18 | andesite | 3 | 146162 | 46 | 14.046 | 10406.0 |
409 | 2023-03-20 21:31:51 | andesite | 1 | 82945 | 3 | 1.516 | 54713.1 |
408 | 2023-02-24 21:32:01 | andesite | 1 | 82945 | 3 | 1.263 | 65673.0 |
407 | 2023-01-28 19:55:06 | andesite | 3 | 146162 | 46 | 7.000 | 20880.3 |
406 | 2023-01-28 04:59:40 | andesite | 1 | 82945 | 3 | 1.413 | 58701.3 |
405 | 2022-12-23 09:36:41 | andesite | 1 | 82945 | 3 | 1.406 | 58993.6 |
404 | 2022-11-19 03:10:44 | andesite | 1 | 82945 | 3 | 1.313 | 63172.1 |
403 | 2022-11-11 00:19:36 | andesite | 3 | 146162 | 46 | 8.126 | 17987.0 |
402 | 2022-10-10 06:01:51 | andesite | 1 | 82945 | 3 | 1.266 | 65517.4 |
401 | 2022-09-10 22:10:23 | andesite | 1 | 82945 | 3 | 1.250 | 66356.0 |
400 | 2022-07-10 21:25:24 | andesite | 1 | 82945 | 3 | 1.453 | 57085.3 |
399 | 2022-06-27 10:27:08 | andesite | 1 | 82945 | 3 | 1.436 | 57761.1 |
398 | 2022-06-06 02:51:59 | andesite | 3 | 146162 | 46 | 6.313 | 23152.5 |
397 | 2022-05-08 15:16:42 | andesite | 4 | 161609 | 695 | 12.436 | 12995.3 |
396 | 2022-04-24 08:39:30 | andesite | 1 | 82945 | 3 | 1.420 | 58412.0 |
395 | 2022-04-22 03:50:05 | andesite | 1 | 82945 | 3 | 1.546 | 53651.4 |
394 | 2022-04-06 11:46:54 | andesite | 4 | 161609 | 695 | 11.703 | 13809.2 |
393 | 2022-03-20 18:09:05 | andesite | 1 | 82945 | 3 | 1.280 | 64800.8 |
392 | 2022-03-20 17:59:05 | andesite | 1 | 82945 | 3 | 1.423 | 58288.8 |
391 | 2022-03-10 23:44:39 | andesite | 1 | 82945 | 3 | 1.500 | 55296.7 |
390 | 2022-02-04 23:06:33 | andesite | 4 | 161609 | 695 | 13.250 | 12196.9 |