History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"competency"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
453 | 2025-08-09 16:40:49 | competency | 1 | 67641 | 2 | 4.796 | 14103.6 |
452 | 2025-08-09 07:56:18 | competency | 1 | 67641 | 2 | 7.173 | 9429.9 |
451 | 2025-07-24 14:54:34 | competency | 1 | 67641 | 2 | 3.030 | 22323.8 |
450 | 2025-07-24 03:36:16 | competency | 1 | 67641 | 2 | 3.423 | 19760.7 |
449 | 2025-07-07 09:50:52 | competency | 1 | 67641 | 2 | 2.983 | 22675.5 |
448 | 2025-07-05 06:33:56 | competency | 2 | 108824 | 6 | 15.173 | 7172.2 |
447 | 2025-07-02 01:40:17 | competency | 4 | 161450 | 96 | 43.396 | 3720.4 |
446 | 2025-06-30 15:40:24 | competency | 4 | 161450 | 96 | 56.186 | 2873.5 |
445 | 2025-06-28 06:36:17 | competency | 4 | 161450 | 96 | 47.096 | 3428.1 |
444 | 2025-06-26 05:21:52 | competency | 2 | 108824 | 6 | 16.250 | 6696.9 |
443 | 2025-06-26 05:03:40 | competency | 4 | 161450 | 96 | 46.973 | 3437.1 |
442 | 2025-06-26 01:20:54 | competency | 3 | 140603 | 19 | 24.643 | 5705.6 |
441 | 2025-06-25 15:12:08 | competency | 1 | 67641 | 2 | 1.110 | 60937.8 |
440 | 2025-06-16 09:05:56 | competency | 1 | 67641 | 2 | 2.703 | 25024.4 |
439 | 2025-05-30 11:51:39 | competency | 1 | 67641 | 2 | 3.016 | 22427.4 |
438 | 2025-05-13 00:12:08 | competency | 1 | 67641 | 2 | 6.016 | 11243.5 |
437 | 2025-05-12 01:31:49 | competency | 1 | 67641 | 2 | 5.906 | 11452.9 |
436 | 2025-05-11 10:54:00 | competency | 3 | 140603 | 19 | 29.800 | 4718.2 |
435 | 2025-05-03 21:46:26 | competency | 3 | 140603 | 19 | 37.610 | 3738.4 |
434 | 2025-05-02 08:59:03 | competency | 1 | 67641 | 2 | 6.156 | 10987.8 |
433 | 2025-04-26 17:31:06 | competency | 3 | 140603 | 19 | 29.893 | 4703.5 |
432 | 2025-04-21 14:53:20 | competency | 3 | 140603 | 19 | 30.033 | 4681.6 |
431 | 2025-04-10 21:45:44 | competency | 2 | 108824 | 6 | 14.096 | 7720.2 |
430 | 2025-04-10 11:08:46 | competency | 3 | 140603 | 19 | 5.483 | 25643.4 |
429 | 2025-04-10 10:48:47 | competency | 3 | 140603 | 19 | 5.953 | 23618.8 |
428 | 2025-03-29 07:10:27 | competency | 3 | 140603 | 19 | 36.470 | 3855.3 |
427 | 2025-03-23 19:34:08 | competency | 3 | 140603 | 19 | 33.300 | 4222.3 |
426 | 2025-03-21 21:38:25 | competency | 1 | 67641 | 2 | 1.656 | 40846.0 |
425 | 2025-03-20 01:10:04 | competency | 1 | 67641 | 2 | 4.983 | 13574.4 |
424 | 2025-03-13 04:07:14 | competency | 1 | 67641 | 2 | 2.576 | 26258.2 |
423 | 2025-02-27 08:27:17 | competency | 4 | 161450 | 96 | 102.190 | 1579.9 |
422 | 2025-02-20 23:39:53 | competency | 1 | 67641 | 2 | 5.953 | 11362.5 |
421 | 2025-02-19 09:05:45 | competency | 4 | 161450 | 96 | 47.283 | 3414.5 |
420 | 2025-02-17 09:18:17 | competency | 4 | 161450 | 96 | 82.430 | 1958.6 |
419 | 2025-02-16 08:26:33 | competency | 4 | 161450 | 96 | 75.070 | 2150.7 |
418 | 2025-02-16 02:12:21 | competency | 4 | 161450 | 96 | 56.050 | 2880.5 |
417 | 2025-02-16 02:08:03 | competency | 1 | 67641 | 2 | 7.796 | 8676.4 |
416 | 2025-02-13 23:40:56 | competency | 2 | 108824 | 6 | 17.376 | 6262.9 |
415 | 2025-02-06 02:20:01 | competency | 4 | 161450 | 96 | 79.223 | 2037.9 |
414 | 2025-02-06 02:20:07 | competency | 2 | 108824 | 6 | 8.216 | 13245.4 |
413 | 2025-01-31 11:34:33 | competency | 1 | 67641 | 2 | 9.550 | 7082.8 |
412 | 2025-01-29 18:41:01 | competency | 3 | 140603 | 19 | 20.596 | 6826.7 |
411 | 2025-01-20 15:13:35 | competency | 3 | 140603 | 19 | 32.173 | 4370.2 |
410 | 2025-01-20 15:13:19 | competency | 4 | 161450 | 96 | 44.720 | 3610.2 |
409 | 2025-01-20 15:13:45 | competency | 2 | 108824 | 6 | 15.923 | 6834.4 |
408 | 2025-01-20 15:11:16 | competency | 4 | 161450 | 96 | 58.720 | 2749.5 |
407 | 2025-01-20 15:09:34 | competency | 1 | 67641 | 2 | 2.830 | 23901.4 |
406 | 2025-01-18 21:14:23 | competency | 3 | 140603 | 19 | 22.486 | 6252.9 |
405 | 2025-01-17 19:54:08 | competency | 3 | 140603 | 19 | 49.443 | 2843.7 |
404 | 2025-01-16 16:54:07 | competency | 4 | 161450 | 96 | 57.990 | 2784.1 |
403 | 2025-01-16 04:53:47 | competency | 4 | 161450 | 96 | 52.673 | 3065.1 |
402 | 2025-01-15 20:43:22 | competency | 4 | 161450 | 96 | 57.300 | 2817.6 |
401 | 2025-01-15 19:06:26 | competency | 1 | 67641 | 2 | 6.360 | 10635.4 |
400 | 2025-01-15 15:57:12 | competency | 1 | 67641 | 2 | 2.486 | 27208.8 |
399 | 2025-01-05 11:22:33 | competency | 3 | 140603 | 19 | 6.250 | 22496.5 |
398 | 2024-12-24 04:58:01 | competency | 3 | 140603 | 19 | 32.516 | 4324.1 |
397 | 2024-12-24 04:57:43 | competency | 2 | 108824 | 6 | 3.500 | 31092.6 |
396 | 2024-12-24 04:57:37 | competency | 1 | 67641 | 2 | 1.153 | 58665.2 |
395 | 2024-12-18 09:19:37 | competency | 3 | 140603 | 19 | 39.503 | 3559.3 |
394 | 2024-12-18 09:19:30 | competency | 3 | 140603 | 19 | 29.953 | 4694.1 |
393 | 2024-12-18 09:19:20 | competency | 3 | 140603 | 19 | 38.393 | 3662.2 |
392 | 2024-12-18 09:19:35 | competency | 2 | 108824 | 6 | 21.533 | 5053.8 |
391 | 2024-12-18 09:17:19 | competency | 1 | 67641 | 2 | 8.250 | 8198.9 |
390 | 2024-12-18 06:10:08 | competency | 3 | 140603 | 19 | 40.816 | 3444.8 |
389 | 2024-12-18 06:09:51 | competency | 2 | 108824 | 6 | 15.500 | 7020.9 |
388 | 2024-12-17 08:20:17 | competency | 3 | 140603 | 19 | 37.753 | 3724.3 |
387 | 2024-12-15 09:56:27 | competency | 3 | 140603 | 19 | 31.580 | 4452.3 |
386 | 2024-12-15 09:56:28 | competency | 2 | 108824 | 6 | 15.986 | 6807.5 |
385 | 2024-12-15 09:54:22 | competency | 1 | 67641 | 2 | 2.703 | 25024.4 |
384 | 2024-12-14 21:44:14 | competency | 4 | 161450 | 96 | 54.410 | 2967.3 |
383 | 2024-12-14 08:21:10 | competency | 1 | 67641 | 2 | 2.436 | 27767.2 |
382 | 2024-12-11 23:10:09 | competency | 4 | 161450 | 96 | 61.133 | 2641.0 |
381 | 2024-12-09 05:05:32 | competency | 4 | 161450 | 96 | 45.846 | 3521.6 |
380 | 2024-11-16 00:00:04 | competency | 4 | 161450 | 96 | 59.130 | 2730.4 |
379 | 2024-11-16 00:00:08 | competency | 2 | 108824 | 6 | 7.856 | 13852.3 |
378 | 2024-11-15 23:53:45 | competency | 4 | 161450 | 96 | 73.350 | 2201.1 |
377 | 2024-11-15 23:20:29 | competency | 1 | 67641 | 2 | 1.203 | 56226.9 |
376 | 2024-11-12 21:58:29 | competency | 3 | 140603 | 19 | 26.406 | 5324.7 |
375 | 2024-11-12 00:02:57 | competency | 1 | 67641 | 2 | 5.640 | 11993.1 |
374 | 2024-11-05 14:38:26 | competency | 3 | 140603 | 19 | 53.396 | 2633.2 |
373 | 2024-11-05 08:59:09 | competency | 1 | 67641 | 2 | 5.533 | 12225.0 |
372 | 2024-11-05 00:36:25 | competency | 3 | 140603 | 19 | 27.063 | 5195.4 |
371 | 2024-11-04 08:15:58 | competency | 3 | 140603 | 19 | 16.673 | 8433.0 |
370 | 2024-11-01 11:22:59 | competency | 1 | 67641 | 2 | 2.813 | 24045.9 |
369 | 2024-10-01 00:16:02 | competency | 2 | 108824 | 6 | 24.266 | 4484.6 |
368 | 2024-10-01 00:14:34 | competency | 2 | 108824 | 6 | 23.110 | 4709.0 |
366 | 2024-10-01 00:14:32 | competency | 2 | 108824 | 6 | 24.816 | 4385.2 |
365 | 2024-10-01 00:10:22 | competency | 1 | 67641 | 2 | 6.420 | 10536.0 |
364 | 2024-09-30 19:33:32 | competency | 2 | 108824 | 6 | 34.643 | 3141.3 |
363 | 2024-09-30 19:32:20 | competency | 1 | 67641 | 2 | 7.190 | 9407.6 |
362 | 2024-09-27 19:48:01 | competency | 2 | 108824 | 6 | 24.343 | 4470.4 |
361 | 2024-09-25 01:19:31 | competency | 1 | 67641 | 2 | 9.800 | 6902.1 |
360 | 2024-09-21 09:37:36 | competency | 3 | 140603 | 19 | 80.613 | 1744.2 |
359 | 2024-09-21 09:36:57 | competency | 3 | 140603 | 19 | 50.630 | 2777.1 |
358 | 2024-09-21 09:37:05 | competency | 2 | 108824 | 6 | 16.656 | 6533.6 |
357 | 2024-09-21 09:33:50 | competency | 1 | 67641 | 2 | 11.906 | 5681.3 |
356 | 2024-09-20 04:27:44 | competency | 3 | 140603 | 19 | 48.643 | 2890.5 |
355 | 2024-09-12 08:14:38 | competency | 3 | 140603 | 19 | 74.703 | 1882.2 |
354 | 2024-09-10 04:35:26 | competency | 3 | 140603 | 19 | 24.110 | 5831.7 |