History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"locates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
489 | 2024-04-26 00:07:42 | locates | 1 | 69583 | 6 | 2.593 | 26834.9 |
488 | 2024-04-20 06:07:32 | locates | 2 | 107671 | 49 | 3.970 | 27121.2 |
487 | 2024-04-20 06:05:17 | locates | 3 | 134027 | 636 | 8.720 | 15370.1 |
486 | 2024-04-20 01:51:00 | locates | 3 | 134027 | 636 | 27.936 | 4797.6 |
485 | 2024-04-18 22:36:26 | locates | 3 | 134027 | 636 | 7.546 | 17761.3 |
484 | 2024-04-18 22:36:12 | locates | 2 | 107671 | 49 | 3.470 | 31029.1 |
483 | 2024-04-18 21:04:21 | locates | 2 | 107671 | 49 | 3.233 | 33303.7 |
482 | 2024-04-06 10:21:21 | locates | 1 | 69583 | 6 | 3.330 | 20895.8 |
481 | 2024-04-02 11:36:08 | locates | 1 | 69583 | 6 | 1.110 | 62687.4 |
480 | 2024-03-04 21:53:29 | locates | 3 | 134027 | 636 | 17.640 | 7597.9 |
479 | 2024-03-02 02:04:38 | locates | 3 | 134027 | 636 | 13.190 | 10161.3 |
478 | 2024-03-02 02:04:28 | locates | 2 | 107671 | 49 | 3.250 | 33129.5 |
477 | 2024-03-01 21:01:31 | locates | 2 | 107671 | 49 | 10.123 | 10636.3 |
476 | 2024-03-01 20:59:36 | locates | 1 | 69583 | 6 | 2.156 | 32274.1 |
475 | 2024-02-08 16:32:04 | locates | 3 | 134027 | 636 | 17.110 | 7833.3 |
474 | 2024-02-07 01:12:10 | locates | 2 | 107671 | 49 | 6.893 | 15620.3 |
473 | 2024-02-07 00:45:50 | locates | 3 | 134027 | 636 | 7.216 | 18573.6 |
472 | 2024-02-06 21:43:21 | locates | 3 | 134027 | 636 | 7.906 | 16952.6 |
471 | 2024-02-06 20:26:55 | locates | 2 | 107671 | 49 | 3.280 | 32826.5 |
470 | 2024-02-06 20:26:23 | locates | 3 | 134027 | 636 | 7.313 | 18327.2 |
469 | 2024-02-06 20:25:21 | locates | 3 | 134027 | 636 | 7.123 | 18816.1 |
468 | 2024-01-17 03:39:04 | locates | 2 | 107671 | 49 | 3.220 | 33438.2 |
467 | 2024-01-15 18:43:45 | locates | 1 | 69583 | 6 | 1.206 | 57697.3 |
466 | 2023-12-26 05:15:44 | locates | 3 | 134027 | 636 | 6.580 | 20368.8 |
465 | 2023-12-24 09:49:55 | locates | 1 | 69583 | 6 | 1.173 | 59320.5 |
464 | 2023-12-23 00:45:12 | locates | 3 | 134027 | 636 | 6.966 | 19240.2 |
463 | 2023-12-16 20:44:16 | locates | 2 | 107671 | 49 | 3.470 | 31029.1 |
462 | 2023-11-26 22:34:12 | locates | 1 | 69583 | 6 | 1.063 | 65459.1 |
461 | 2023-11-25 18:19:06 | locates | 1 | 69583 | 6 | 1.373 | 50679.5 |
460 | 2023-11-17 21:10:20 | locates | 1 | 69583 | 6 | 1.076 | 64668.2 |
459 | 2023-11-12 15:15:59 | locates | 3 | 134027 | 636 | 5.733 | 23378.2 |
458 | 2023-11-11 19:37:56 | locates | 1 | 69583 | 6 | 1.170 | 59472.6 |
457 | 2023-11-07 23:08:52 | locates | 1 | 69583 | 6 | 1.050 | 66269.5 |
456 | 2023-11-06 03:51:43 | locates | 1 | 69583 | 6 | 1.186 | 58670.3 |
455 | 2023-10-19 17:28:53 | locates | 1 | 69583 | 6 | 1.123 | 61961.7 |
454 | 2023-10-14 21:48:56 | locates | 1 | 69583 | 6 | 1.076 | 64668.2 |
453 | 2023-10-11 01:20:49 | locates | 1 | 69583 | 6 | 1.173 | 59320.5 |
452 | 2023-09-29 13:21:26 | locates | 1 | 69583 | 6 | 1.173 | 59320.5 |
451 | 2023-09-17 01:13:29 | locates | 1 | 69583 | 6 | 1.033 | 67360.1 |
450 | 2023-09-15 17:53:16 | locates | 2 | 107671 | 49 | 2.813 | 38276.2 |
449 | 2023-08-14 21:00:40 | locates | 3 | 134027 | 636 | 5.953 | 22514.2 |
448 | 2023-08-06 18:47:00 | locates | 1 | 69583 | 6 | 1.076 | 64668.2 |
447 | 2023-07-28 06:44:15 | locates | 1 | 69583 | 6 | 1.046 | 66522.9 |
446 | 2023-06-08 15:17:27 | locates | 2 | 107671 | 49 | 2.766 | 38926.6 |
445 | 2023-05-23 03:17:21 | locates | 1 | 69583 | 6 | 1.220 | 57035.2 |
444 | 2023-05-01 22:12:10 | locates | 1 | 69583 | 6 | 1.233 | 56433.9 |
443 | 2023-04-28 22:04:21 | locates | 3 | 134027 | 636 | 6.670 | 20094.0 |
442 | 2023-04-16 08:49:01 | locates | 1 | 69583 | 6 | 1.173 | 59320.5 |
441 | 2023-04-01 16:19:43 | locates | 3 | 134027 | 636 | 5.783 | 23176.0 |
440 | 2023-03-27 23:45:24 | locates | 1 | 69583 | 6 | 1.046 | 66522.9 |
439 | 2023-03-12 06:36:43 | locates | 2 | 107671 | 49 | 3.126 | 34443.7 |
438 | 2023-03-05 06:51:14 | locates | 3 | 134027 | 636 | 6.516 | 20568.9 |
437 | 2023-02-24 12:28:08 | locates | 1 | 69583 | 6 | 1.046 | 66522.9 |
436 | 2023-02-01 19:25:26 | locates | 3 | 134027 | 636 | 5.953 | 22514.2 |
435 | 2023-02-01 00:49:49 | locates | 3 | 134027 | 636 | 5.826 | 23005.0 |
434 | 2023-01-13 02:46:00 | locates | 3 | 134027 | 636 | 5.750 | 23309.0 |
433 | 2023-01-07 14:36:07 | locates | 1 | 69583 | 6 | 1.093 | 63662.4 |
432 | 2022-12-21 14:40:12 | locates | 1 | 69583 | 6 | 1.046 | 66522.9 |
431 | 2022-12-17 00:54:05 | locates | 3 | 134027 | 636 | 5.706 | 23488.8 |
430 | 2022-12-16 07:01:14 | locates | 2 | 107671 | 49 | 3.280 | 32826.5 |
429 | 2022-12-09 19:38:17 | locates | 3 | 134027 | 636 | 5.640 | 23763.7 |
428 | 2022-12-09 17:34:54 | locates | 3 | 134027 | 636 | 6.546 | 20474.6 |
427 | 2022-11-13 08:56:14 | locates | 3 | 134027 | 636 | 5.673 | 23625.4 |
426 | 2022-09-20 05:10:36 | locates | 1 | 69583 | 6 | 1.046 | 66522.9 |
425 | 2022-09-18 03:52:42 | locates | 1 | 69583 | 6 | 1.063 | 65459.1 |
424 | 2022-09-06 21:16:36 | locates | 1 | 69583 | 6 | 1.063 | 65459.1 |
423 | 2022-09-04 18:46:00 | locates | 1 | 69583 | 6 | 1.060 | 65644.3 |
422 | 2022-09-02 11:00:11 | locates | 1 | 69583 | 6 | 1.186 | 58670.3 |
421 | 2022-08-07 14:54:00 | locates | 2 | 107671 | 49 | 2.796 | 38508.9 |
420 | 2022-08-07 00:46:28 | locates | 1 | 69583 | 6 | 1.046 | 66522.9 |
419 | 2022-07-29 15:15:09 | locates | 1 | 69583 | 6 | 1.080 | 64428.7 |
418 | 2022-07-10 04:23:47 | locates | 1 | 69583 | 6 | 1.190 | 58473.1 |
417 | 2022-06-25 09:29:48 | locates | 1 | 69583 | 6 | 1.030 | 67556.3 |
416 | 2022-06-03 08:40:32 | locates | 1 | 69583 | 6 | 1.186 | 58670.3 |
415 | 2022-06-01 20:55:59 | locates | 1 | 69583 | 6 | 1.173 | 59320.5 |
414 | 2022-06-01 15:36:29 | locates | 1 | 69583 | 6 | 1.343 | 51811.6 |
413 | 2022-05-22 21:34:55 | locates | 1 | 69583 | 6 | 1.063 | 65459.1 |
412 | 2022-05-20 06:16:27 | locates | 3 | 134027 | 636 | 5.783 | 23176.0 |
411 | 2022-04-26 08:56:11 | locates | 1 | 69583 | 6 | 1.173 | 59320.5 |
410 | 2022-04-13 17:33:12 | locates | 1 | 69583 | 6 | 1.266 | 54962.9 |
409 | 2022-04-11 11:13:29 | locates | 1 | 69583 | 6 | 1.593 | 43680.5 |
408 | 2022-03-06 14:38:13 | locates | 2 | 107671 | 49 | 3.236 | 33272.9 |
407 | 2022-02-23 10:50:27 | locates | 1 | 69583 | 6 | 1.390 | 50059.7 |
406 | 2022-02-20 00:03:25 | locates | 1 | 69583 | 6 | 1.203 | 57841.2 |
405 | 2022-01-03 01:24:40 | locates | 1 | 69583 | 6 | 1.250 | 55666.4 |
404 | 2021-12-29 10:01:17 | locates | 1 | 69583 | 6 | 1.203 | 57841.2 |
403 | 2021-12-25 10:17:17 | locates | 1 | 69583 | 6 | 1.296 | 53690.6 |
402 | 2021-12-06 14:59:20 | locates | 2 | 107671 | 49 | 3.343 | 32207.9 |
401 | 2021-11-15 20:33:47 | locates | 1 | 69583 | 6 | 1.203 | 57841.2 |
400 | 2021-11-12 03:17:04 | locates | 1 | 69583 | 6 | 1.190 | 58473.1 |
399 | 2021-11-08 16:33:20 | locates | 1 | 69583 | 6 | 1.153 | 60349.5 |
398 | 2021-10-21 08:08:07 | locates | 1 | 69583 | 6 | 1.203 | 57841.2 |
397 | 2021-08-29 10:58:04 | locates | 1 | 69583 | 6 | 1.063 | 65459.1 |
396 | 2021-08-09 01:31:43 | locates | 1 | 69583 | 6 | 1.173 | 59320.5 |
395 | 2021-07-12 20:47:09 | locates | 1 | 69583 | 6 | 1.203 | 57841.2 |
394 | 2021-05-31 15:33:47 | locates | 1 | 69583 | 6 | 1.236 | 56296.9 |
393 | 2021-05-26 10:22:35 | locates | 1 | 69583 | 6 | 1.593 | 43680.5 |
392 | 2021-05-06 10:00:20 | locates | 1 | 69583 | 6 | 1.093 | 63662.4 |
391 | 2021-05-04 22:07:04 | locates | 1 | 69583 | 6 | 1.296 | 53690.6 |
390 | 2021-02-02 07:59:09 | locates | 1 | 69583 | 6 | 1.283 | 54234.6 |