History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"materials"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
496 | 2025-07-27 00:27:33 | materials | 1 | 81242 | 3 | 3.360 | 24179.2 |
495 | 2025-07-25 09:54:34 | materials | 1 | 81242 | 3 | 2.953 | 27511.7 |
494 | 2025-07-24 02:22:20 | materials | 1 | 81242 | 3 | 7.610 | 10675.7 |
493 | 2025-07-22 21:55:05 | materials | 1 | 81242 | 3 | 3.266 | 24875.1 |
492 | 2025-07-17 21:48:11 | materials | 1 | 81242 | 3 | 3.156 | 25742.1 |
491 | 2025-07-13 12:47:47 | materials | 1 | 81242 | 3 | 1.420 | 57212.7 |
490 | 2025-07-11 03:49:11 | materials | 1 | 81242 | 3 | 8.626 | 9418.3 |
489 | 2025-07-10 16:08:02 | materials | 1 | 81242 | 3 | 7.856 | 10341.4 |
488 | 2025-07-06 21:26:59 | materials | 1 | 81242 | 3 | 3.936 | 20640.8 |
487 | 2025-07-02 12:08:45 | materials | 3 | 148641 | 81 | 19.330 | 7689.7 |
486 | 2025-06-29 00:29:02 | materials | 1 | 81242 | 3 | 3.436 | 23644.4 |
485 | 2025-06-27 15:09:49 | materials | 4 | 165329 | 645 | 60.550 | 2730.5 |
484 | 2025-06-27 14:12:15 | materials | 4 | 165329 | 645 | 68.846 | 2401.4 |
483 | 2025-06-26 17:54:42 | materials | 2 | 121436 | 13 | 20.203 | 6010.8 |
482 | 2025-06-26 13:31:04 | materials | 3 | 148641 | 81 | 25.930 | 5732.4 |
481 | 2025-06-26 10:42:55 | materials | 3 | 148641 | 81 | 38.033 | 3908.2 |
480 | 2025-06-26 01:04:31 | materials | 3 | 148641 | 81 | 37.470 | 3966.9 |
479 | 2025-06-25 04:06:17 | materials | 3 | 148641 | 81 | 28.343 | 5244.4 |
478 | 2025-06-24 14:17:03 | materials | 3 | 148641 | 81 | 30.640 | 4851.2 |
477 | 2025-06-24 13:42:01 | materials | 2 | 121436 | 13 | 21.780 | 5575.6 |
476 | 2025-06-23 12:48:43 | materials | 4 | 165329 | 645 | 36.360 | 4547.0 |
475 | 2025-06-23 07:24:57 | materials | 1 | 81242 | 3 | 2.640 | 30773.5 |
474 | 2025-06-22 13:15:50 | materials | 2 | 121436 | 13 | 24.830 | 4890.7 |
473 | 2025-06-22 09:26:41 | materials | 3 | 148641 | 81 | 28.126 | 5284.8 |
472 | 2025-06-21 00:57:04 | materials | 1 | 81242 | 3 | 1.436 | 56575.2 |
471 | 2025-06-11 01:00:38 | materials | 1 | 81242 | 3 | 1.500 | 54161.3 |
470 | 2025-06-10 15:09:28 | materials | 2 | 121436 | 13 | 12.456 | 9749.2 |
469 | 2025-06-08 13:00:21 | materials | 1 | 81242 | 3 | 6.076 | 13371.0 |
468 | 2025-06-06 10:59:51 | materials | 3 | 148641 | 81 | 35.440 | 4194.2 |
467 | 2025-06-06 05:40:19 | materials | 2 | 121436 | 13 | 19.530 | 6217.9 |
466 | 2025-06-05 14:13:55 | materials | 1 | 81242 | 3 | 1.390 | 58447.5 |
465 | 2025-06-05 02:35:15 | materials | 1 | 81242 | 3 | 5.796 | 14016.9 |
464 | 2025-05-31 16:45:11 | materials | 1 | 81242 | 3 | 6.733 | 12066.2 |
463 | 2025-05-24 13:36:48 | materials | 1 | 81242 | 3 | 7.390 | 10993.5 |
462 | 2025-05-15 18:51:59 | materials | 1 | 81242 | 3 | 1.470 | 55266.7 |
461 | 2025-05-14 16:21:11 | materials | 1 | 81242 | 3 | 4.156 | 19548.1 |
460 | 2025-05-07 22:50:41 | materials | 1 | 81242 | 3 | 9.860 | 8239.6 |
459 | 2025-05-06 13:04:47 | materials | 1 | 81242 | 3 | 3.406 | 23852.6 |
458 | 2025-04-29 10:40:44 | materials | 1 | 81242 | 3 | 1.390 | 58447.5 |
457 | 2025-04-23 13:23:34 | materials | 1 | 81242 | 3 | 7.220 | 11252.4 |
456 | 2025-04-22 23:38:32 | materials | 1 | 81242 | 3 | 10.970 | 7405.8 |
455 | 2025-04-04 13:02:42 | materials | 1 | 81242 | 3 | 9.486 | 8564.4 |
454 | 2025-04-04 11:13:29 | materials | 3 | 148641 | 81 | 39.203 | 3791.6 |
453 | 2025-04-01 11:32:26 | materials | 3 | 148641 | 81 | 16.593 | 8958.1 |
452 | 2025-03-29 17:11:39 | materials | 1 | 81242 | 3 | 10.080 | 8059.7 |
451 | 2025-03-25 00:18:01 | materials | 4 | 165329 | 645 | 56.830 | 2909.2 |
450 | 2025-03-24 09:29:25 | materials | 2 | 121436 | 13 | 22.190 | 5472.6 |
449 | 2025-03-24 07:21:24 | materials | 3 | 148641 | 81 | 18.986 | 7829.0 |
448 | 2025-03-23 16:28:47 | materials | 2 | 121436 | 13 | 14.936 | 8130.4 |
447 | 2025-03-22 15:43:06 | materials | 1 | 81242 | 3 | 6.766 | 12007.4 |
446 | 2025-03-22 00:17:13 | materials | 1 | 81242 | 3 | 1.436 | 56575.2 |
445 | 2025-03-09 20:04:42 | materials | 3 | 148641 | 81 | 29.300 | 5073.1 |
444 | 2025-03-04 15:51:13 | materials | 3 | 148641 | 81 | 37.906 | 3921.3 |
443 | 2025-03-03 04:10:53 | materials | 1 | 81242 | 3 | 6.623 | 12266.6 |
442 | 2025-03-02 03:03:37 | materials | 3 | 148641 | 81 | 44.863 | 3313.2 |
441 | 2025-02-24 07:09:21 | materials | 3 | 148641 | 81 | 39.343 | 3778.1 |
440 | 2025-02-20 15:06:06 | materials | 1 | 81242 | 3 | 7.406 | 10969.8 |
439 | 2025-02-16 05:39:31 | materials | 3 | 148641 | 81 | 36.410 | 4082.4 |
438 | 2025-02-01 20:59:59 | materials | 3 | 148641 | 81 | 49.260 | 3017.5 |
437 | 2025-02-01 21:00:11 | materials | 2 | 121436 | 13 | 14.690 | 8266.6 |
436 | 2025-02-01 20:59:49 | materials | 3 | 148641 | 81 | 33.910 | 4383.4 |
435 | 2025-02-01 20:58:38 | materials | 1 | 81242 | 3 | 6.890 | 11791.3 |
434 | 2025-01-27 22:26:06 | materials | 1 | 81242 | 3 | 1.376 | 59042.2 |
433 | 2025-01-27 00:28:37 | materials | 1 | 81242 | 3 | 7.983 | 10176.9 |
432 | 2025-01-17 07:44:42 | materials | 2 | 121436 | 13 | 17.890 | 6787.9 |
431 | 2025-01-16 07:48:18 | materials | 2 | 121436 | 13 | 33.330 | 3643.4 |
430 | 2025-01-16 07:48:16 | materials | 3 | 148641 | 81 | 29.546 | 5030.8 |
429 | 2025-01-15 05:59:20 | materials | 2 | 121436 | 13 | 31.470 | 3858.8 |
428 | 2025-01-15 05:59:15 | materials | 3 | 148641 | 81 | 25.626 | 5800.4 |
427 | 2025-01-15 05:57:50 | materials | 1 | 81242 | 3 | 5.763 | 14097.2 |
426 | 2025-01-15 03:41:24 | materials | 1 | 81242 | 3 | 7.436 | 10925.5 |
425 | 2024-12-30 19:13:58 | materials | 1 | 81242 | 3 | 1.343 | 60492.9 |
424 | 2024-12-28 09:36:07 | materials | 1 | 81242 | 3 | 7.343 | 11063.9 |
423 | 2024-12-19 19:06:45 | materials | 1 | 81242 | 3 | 3.310 | 24544.4 |
422 | 2024-12-03 22:28:31 | materials | 2 | 121436 | 13 | 15.500 | 7834.6 |
421 | 2024-12-01 01:43:39 | materials | 3 | 148641 | 81 | 36.393 | 4084.3 |
420 | 2024-11-28 02:50:00 | materials | 1 | 81242 | 3 | 2.970 | 27354.2 |
419 | 2024-11-27 10:56:36 | materials | 3 | 148641 | 81 | 43.143 | 3445.3 |
418 | 2024-11-27 10:56:33 | materials | 2 | 121436 | 13 | 28.720 | 4228.3 |
417 | 2024-11-27 10:56:29 | materials | 3 | 148641 | 81 | 30.983 | 4797.5 |
416 | 2024-11-27 08:44:36 | materials | 1 | 81242 | 3 | 1.343 | 60492.9 |
415 | 2024-10-30 08:47:32 | materials | 1 | 81242 | 3 | 1.343 | 60492.9 |
414 | 2024-10-27 20:21:50 | materials | 1 | 81242 | 3 | 10.173 | 7986.0 |
413 | 2024-10-26 21:01:10 | materials | 3 | 148641 | 81 | 37.643 | 3948.7 |
412 | 2024-10-26 21:01:11 | materials | 2 | 121436 | 13 | 19.330 | 6282.3 |
411 | 2024-10-26 21:00:40 | materials | 3 | 148641 | 81 | 41.753 | 3560.0 |
410 | 2024-10-26 20:59:37 | materials | 1 | 81242 | 3 | 2.143 | 37910.4 |
409 | 2024-10-23 04:02:58 | materials | 1 | 81242 | 3 | 3.890 | 20884.8 |
408 | 2024-10-23 03:33:31 | materials | 1 | 81242 | 3 | 3.733 | 21763.2 |
407 | 2024-10-23 03:29:31 | materials | 3 | 148641 | 81 | 37.363 | 3978.3 |
406 | 2024-10-23 03:28:51 | materials | 2 | 121436 | 13 | 21.346 | 5688.9 |
405 | 2024-10-23 03:26:01 | materials | 2 | 121436 | 13 | 15.966 | 7605.9 |
404 | 2024-10-23 03:23:13 | materials | 3 | 148641 | 81 | 29.766 | 4993.7 |
403 | 2024-10-23 03:18:03 | materials | 1 | 81242 | 3 | 7.016 | 11579.5 |
402 | 2024-10-22 18:30:00 | materials | 3 | 148641 | 81 | 31.396 | 4734.4 |
401 | 2024-10-22 13:37:20 | materials | 3 | 148641 | 81 | 44.266 | 3357.9 |
400 | 2024-10-22 11:32:03 | materials | 1 | 81242 | 3 | 4.076 | 19931.8 |
399 | 2024-10-22 10:58:07 | materials | 3 | 148641 | 81 | 45.413 | 3273.1 |
398 | 2024-10-22 10:55:37 | materials | 1 | 81242 | 3 | 3.826 | 21234.2 |
397 | 2024-10-22 10:52:03 | materials | 1 | 81242 | 3 | 6.110 | 13296.6 |