History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clients"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
487 | 2024-03-23 06:03:20 | clients | 3 | 134027 | 386 | 5.716 | 23447.7 |
486 | 2024-03-18 01:23:54 | clients | 1 | 69583 | 2 | 4.063 | 17126.0 |
485 | 2024-03-10 18:01:47 | clients | 3 | 134027 | 386 | 20.863 | 6424.1 |
484 | 2024-03-10 10:55:32 | clients | 3 | 134027 | 386 | 10.516 | 12745.1 |
483 | 2024-03-09 19:35:58 | clients | 1 | 69583 | 2 | 2.733 | 25460.3 |
482 | 2024-03-09 19:35:40 | clients | 3 | 134027 | 386 | 7.673 | 17467.4 |
481 | 2024-03-08 23:56:35 | clients | 3 | 134027 | 386 | 22.143 | 6052.8 |
480 | 2024-03-06 08:31:17 | clients | 3 | 134027 | 386 | 10.236 | 13093.7 |
479 | 2024-03-06 08:31:19 | clients | 2 | 107671 | 23 | 4.096 | 26286.9 |
478 | 2024-02-08 08:53:14 | clients | 2 | 107671 | 23 | 3.860 | 27894.0 |
477 | 2024-02-08 08:48:14 | clients | 3 | 134027 | 386 | 7.826 | 17125.9 |
476 | 2024-02-06 06:15:01 | clients | 2 | 107671 | 23 | 3.313 | 32499.5 |
475 | 2024-02-06 06:14:37 | clients | 3 | 134027 | 386 | 6.673 | 20085.0 |
474 | 2024-02-05 19:19:14 | clients | 3 | 134027 | 386 | 7.203 | 18607.1 |
473 | 2024-02-05 01:47:06 | clients | 3 | 134027 | 386 | 8.016 | 16719.9 |
472 | 2024-02-05 01:47:02 | clients | 2 | 107671 | 23 | 3.360 | 32044.9 |
471 | 2024-01-03 13:09:42 | clients | 1 | 69583 | 2 | 1.186 | 58670.3 |
470 | 2024-01-01 17:18:27 | clients | 2 | 107671 | 23 | 3.486 | 30886.7 |
469 | 2023-12-27 00:27:42 | clients | 3 | 134027 | 386 | 7.376 | 18170.7 |
468 | 2023-12-07 17:28:00 | clients | 3 | 134027 | 386 | 5.656 | 23696.4 |
467 | 2023-12-07 17:27:56 | clients | 2 | 107671 | 23 | 3.186 | 33795.0 |
466 | 2023-11-30 03:09:17 | clients | 3 | 134027 | 386 | 6.610 | 20276.4 |
465 | 2023-11-25 16:37:48 | clients | 1 | 69583 | 2 | 1.233 | 56433.9 |
464 | 2023-11-22 19:25:53 | clients | 1 | 69583 | 2 | 1.483 | 46920.4 |
463 | 2023-11-12 07:36:37 | clients | 2 | 107671 | 23 | 3.126 | 34443.7 |
462 | 2023-11-12 07:36:34 | clients | 3 | 134027 | 386 | 6.080 | 22043.9 |
461 | 2023-11-11 03:08:12 | clients | 1 | 69583 | 2 | 1.203 | 57841.2 |
460 | 2023-11-10 14:52:41 | clients | 1 | 69583 | 2 | 1.123 | 61961.7 |
459 | 2023-11-04 08:37:00 | clients | 1 | 69583 | 2 | 1.063 | 65459.1 |
458 | 2023-10-26 01:16:55 | clients | 1 | 69583 | 2 | 1.093 | 63662.4 |
457 | 2023-10-21 22:49:50 | clients | 1 | 69583 | 2 | 1.203 | 57841.2 |
456 | 2023-09-26 01:12:24 | clients | 1 | 69583 | 2 | 1.186 | 58670.3 |
455 | 2023-09-24 13:03:49 | clients | 1 | 69583 | 2 | 2.156 | 32274.1 |
454 | 2023-08-30 07:21:19 | clients | 1 | 69583 | 2 | 1.063 | 65459.1 |
453 | 2023-08-29 11:47:25 | clients | 3 | 134027 | 386 | 7.140 | 18771.3 |
452 | 2023-08-28 19:42:02 | clients | 1 | 69583 | 2 | 1.140 | 61037.7 |
451 | 2023-08-21 01:33:18 | clients | 1 | 69583 | 2 | 1.190 | 58473.1 |
450 | 2023-07-31 05:11:18 | clients | 1 | 69583 | 2 | 1.153 | 60349.5 |
449 | 2023-05-22 15:32:44 | clients | 1 | 69583 | 2 | 1.046 | 66522.9 |
448 | 2023-05-22 04:10:22 | clients | 3 | 134027 | 386 | 6.736 | 19897.1 |
447 | 2023-05-20 14:26:39 | clients | 1 | 69583 | 2 | 1.153 | 60349.5 |
446 | 2023-05-17 19:39:45 | clients | 1 | 69583 | 2 | 1.140 | 61037.7 |
445 | 2023-05-17 17:15:02 | clients | 1 | 69583 | 2 | 1.236 | 56296.9 |
444 | 2023-05-16 19:36:58 | clients | 1 | 69583 | 2 | 1.063 | 65459.1 |
443 | 2023-05-16 17:13:48 | clients | 1 | 69583 | 2 | 1.156 | 60192.9 |
442 | 2023-05-15 21:50:43 | clients | 3 | 134027 | 386 | 5.716 | 23447.7 |
441 | 2023-05-15 19:26:50 | clients | 1 | 69583 | 2 | 1.063 | 65459.1 |
440 | 2023-05-14 19:20:39 | clients | 1 | 69583 | 2 | 1.216 | 57222.9 |
439 | 2023-05-09 11:03:30 | clients | 3 | 134027 | 386 | 5.700 | 23513.5 |
438 | 2023-05-05 04:51:43 | clients | 1 | 69583 | 2 | 1.216 | 57222.9 |
437 | 2023-05-04 05:29:50 | clients | 1 | 69583 | 2 | 1.063 | 65459.1 |
436 | 2023-05-03 05:19:19 | clients | 1 | 69583 | 2 | 2.436 | 28564.4 |
435 | 2023-05-02 05:16:29 | clients | 1 | 69583 | 2 | 1.156 | 60192.9 |
434 | 2023-04-22 20:07:30 | clients | 1 | 69583 | 2 | 1.203 | 57841.2 |
433 | 2023-03-20 00:50:39 | clients | 1 | 69583 | 2 | 1.080 | 64428.7 |
432 | 2023-02-25 15:41:32 | clients | 3 | 134027 | 386 | 5.623 | 23835.5 |
431 | 2023-02-05 18:51:02 | clients | 3 | 134027 | 386 | 5.610 | 23890.7 |
430 | 2023-01-10 10:19:50 | clients | 1 | 69583 | 2 | 1.030 | 67556.3 |
429 | 2023-01-07 01:59:01 | clients | 1 | 69583 | 2 | 1.093 | 63662.4 |
428 | 2023-01-06 17:44:35 | clients | 1 | 69583 | 2 | 1.220 | 57035.2 |
427 | 2022-12-20 11:36:42 | clients | 3 | 134027 | 386 | 10.110 | 13256.9 |
426 | 2022-12-07 18:37:45 | clients | 3 | 134027 | 386 | 5.640 | 23763.7 |
425 | 2022-11-11 00:56:09 | clients | 2 | 107671 | 23 | 2.826 | 38100.1 |
424 | 2022-11-06 01:43:20 | clients | 3 | 134027 | 386 | 7.033 | 19056.9 |
423 | 2022-10-06 16:02:00 | clients | 1 | 69583 | 2 | 1.173 | 59320.5 |
422 | 2022-09-22 23:41:11 | clients | 1 | 69583 | 2 | 1.046 | 66522.9 |
421 | 2022-09-02 01:36:05 | clients | 1 | 69583 | 2 | 1.203 | 57841.2 |
420 | 2022-09-01 17:41:37 | clients | 3 | 134027 | 386 | 5.843 | 22938.0 |
419 | 2022-07-29 01:53:40 | clients | 1 | 69583 | 2 | 1.063 | 65459.1 |
418 | 2022-07-21 07:53:55 | clients | 3 | 134027 | 386 | 5.703 | 23501.1 |
417 | 2022-06-12 15:36:14 | clients | 2 | 107671 | 23 | 2.766 | 38926.6 |
416 | 2022-06-02 15:25:23 | clients | 1 | 69583 | 2 | 1.153 | 60349.5 |
415 | 2022-05-28 23:42:26 | clients | 1 | 69583 | 2 | 1.063 | 65459.1 |
414 | 2022-02-19 05:45:26 | clients | 1 | 69583 | 2 | 1.156 | 60192.9 |
413 | 2022-02-08 00:23:41 | clients | 1 | 69583 | 2 | 1.063 | 65459.1 |
412 | 2021-12-03 21:42:25 | clients | 1 | 69583 | 2 | 1.313 | 52995.4 |
411 | 2021-11-17 21:00:59 | clients | 1 | 69583 | 2 | 1.266 | 54962.9 |
410 | 2021-10-21 14:09:20 | clients | 1 | 69583 | 2 | 1.063 | 65459.1 |
409 | 2021-10-19 12:21:31 | clients | 1 | 69583 | 2 | 1.063 | 65459.1 |
408 | 2021-09-30 17:56:48 | clients | 1 | 69583 | 2 | 1.220 | 57035.2 |
407 | 2021-09-29 18:59:07 | clients | 1 | 69583 | 2 | 1.203 | 57841.2 |
406 | 2021-09-28 13:25:06 | clients | 1 | 69583 | 2 | 1.156 | 60192.9 |
405 | 2021-09-27 15:51:46 | clients | 1 | 69583 | 2 | 1.080 | 64428.7 |
404 | 2021-09-22 15:16:26 | clients | 2 | 107671 | 23 | 2.873 | 37476.9 |
403 | 2021-09-21 23:09:32 | clients | 2 | 107671 | 23 | 2.966 | 36301.8 |
402 | 2021-09-17 09:23:59 | clients | 1 | 69583 | 2 | 1.266 | 54962.9 |
401 | 2021-09-16 16:38:15 | clients | 1 | 69583 | 2 | 1.096 | 63488.1 |
400 | 2021-09-16 15:31:27 | clients | 1 | 69583 | 2 | 1.170 | 59472.6 |
399 | 2021-09-16 06:02:56 | clients | 1 | 69583 | 2 | 1.123 | 61961.7 |
398 | 2021-09-15 12:43:57 | clients | 1 | 69583 | 2 | 1.220 | 57035.2 |
397 | 2021-09-14 21:54:13 | clients | 2 | 107671 | 23 | 2.796 | 38508.9 |
396 | 2021-09-14 19:21:44 | clients | 1 | 69583 | 2 | 1.186 | 58670.3 |
395 | 2021-09-09 07:36:23 | clients | 1 | 69583 | 2 | 1.156 | 60192.9 |
394 | 2021-08-18 08:17:18 | clients | 1 | 69583 | 2 | 1.126 | 61796.6 |
393 | 2021-08-15 00:39:55 | clients | 1 | 69583 | 2 | 1.063 | 65459.1 |
392 | 2021-07-16 10:16:01 | clients | 3 | 134027 | 386 | 6.876 | 19492.0 |
391 | 2021-06-01 00:41:37 | clients | 1 | 69583 | 2 | 1.250 | 55666.4 |
390 | 2021-05-14 09:08:17 | clients | 1 | 69583 | 2 | 1.206 | 57697.3 |
389 | 2021-05-06 19:45:36 | clients | 1 | 69583 | 2 | 1.296 | 53690.6 |
388 | 2021-04-03 21:17:16 | clients | 3 | 134027 | 386 | 5.893 | 22743.4 |