History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bob"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2494 | 2024-04-29 16:13:11 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2493 | 2024-04-29 01:46:34 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2492 | 2024-04-27 04:52:00 | bob | 1 | 5146 | 30 | 0.250 | 20584.0 |
2491 | 2024-04-26 16:47:59 | bob | 1 | 5146 | 30 | 0.096 | 53604.2 |
2490 | 2024-04-25 15:25:16 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2489 | 2024-04-21 17:07:54 | bob | 2 | 14084 | 412 | 0.843 | 16707.0 |
2488 | 2024-04-21 17:06:23 | bob | 2 | 14084 | 412 | 1.596 | 8824.6 |
2487 | 2024-04-21 01:59:31 | bob | 2 | 14084 | 412 | 0.923 | 15258.9 |
2486 | 2024-04-17 21:49:15 | bob | 2 | 14084 | 412 | 1.796 | 7841.9 |
2485 | 2024-04-12 08:24:03 | bob | 1 | 5146 | 30 | 0.096 | 53604.2 |
2484 | 2024-04-12 08:13:03 | bob | 1 | 5146 | 30 | 0.360 | 14294.4 |
2483 | 2024-04-07 18:28:55 | bob | 2 | 14084 | 412 | 0.640 | 22006.3 |
2482 | 2024-04-04 20:55:25 | bob | 2 | 14084 | 412 | 0.330 | 42678.8 |
2481 | 2024-04-02 17:35:19 | bob | 1 | 5146 | 30 | 0.313 | 16440.9 |
2480 | 2024-03-31 00:48:18 | bob | 2 | 14084 | 412 | 0.953 | 14778.6 |
2479 | 2024-03-30 23:33:19 | bob | 2 | 14084 | 412 | 0.766 | 18386.4 |
2478 | 2024-03-30 22:38:57 | bob | 1 | 5146 | 30 | 0.283 | 18183.7 |
2477 | 2024-03-30 22:38:26 | bob | 2 | 14084 | 412 | 0.453 | 31090.5 |
2476 | 2024-03-30 22:19:09 | bob | 1 | 5146 | 30 | 0.076 | 67710.5 |
2475 | 2024-03-30 09:52:19 | bob | 1 | 5146 | 30 | 0.390 | 13194.9 |
2474 | 2024-03-28 17:48:35 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2473 | 2024-03-26 17:36:19 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2472 | 2024-03-22 23:15:04 | bob | 1 | 5146 | 30 | 0.080 | 64325.0 |
2471 | 2024-03-11 23:47:55 | bob | 1 | 5146 | 30 | 0.096 | 53604.2 |
2470 | 2024-03-09 04:44:05 | bob | 1 | 5146 | 30 | 0.076 | 67710.5 |
2469 | 2024-03-02 16:44:00 | bob | 1 | 5146 | 30 | 0.203 | 25349.8 |
2468 | 2024-02-29 18:15:05 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2467 | 2024-02-25 16:06:22 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2466 | 2024-02-02 13:59:15 | bob | 1 | 5146 | 30 | 0.090 | 57177.8 |
2465 | 2024-01-31 16:21:51 | bob | 2 | 14084 | 412 | 0.356 | 39561.8 |
2464 | 2024-01-31 16:05:01 | bob | 2 | 14084 | 412 | 0.406 | 34689.7 |
2463 | 2024-01-25 18:15:09 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2462 | 2024-01-22 23:37:04 | bob | 1 | 5146 | 30 | 0.153 | 33634.0 |
2461 | 2024-01-07 00:26:45 | bob | 2 | 14084 | 412 | 0.343 | 41061.2 |
2460 | 2023-12-27 21:44:27 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2459 | 2023-12-24 06:54:42 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2458 | 2023-12-18 08:14:18 | bob | 2 | 14084 | 412 | 0.390 | 36112.8 |
2457 | 2023-12-07 01:35:39 | bob | 1 | 5146 | 30 | 0.076 | 67710.5 |
2456 | 2023-12-07 01:35:38 | bob | 1 | 5146 | 30 | 0.076 | 67710.5 |
2455 | 2023-12-07 00:01:57 | bob | 1 | 5146 | 30 | 0.076 | 67710.5 |
2454 | 2023-12-03 06:26:16 | bob | 2 | 14084 | 412 | 0.423 | 33295.5 |
2453 | 2023-12-03 06:26:15 | bob | 2 | 14084 | 412 | 0.373 | 37758.7 |
2452 | 2023-12-01 08:00:03 | bob | 2 | 14084 | 412 | 0.440 | 32009.1 |
2451 | 2023-11-25 23:14:35 | bob | 2 | 14084 | 412 | 0.330 | 42678.8 |
2450 | 2023-11-21 16:43:36 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2449 | 2023-11-10 00:56:33 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2448 | 2023-11-09 21:02:18 | bob | 1 | 5146 | 30 | 0.080 | 64325.0 |
2447 | 2023-11-07 10:02:11 | bob | 1 | 5146 | 30 | 0.190 | 27084.2 |
2446 | 2023-11-07 10:01:47 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2445 | 2023-11-06 15:22:26 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2444 | 2023-11-04 22:30:51 | bob | 2 | 14084 | 412 | 0.330 | 42678.8 |
2443 | 2023-11-02 14:44:44 | bob | 2 | 14084 | 412 | 0.326 | 43202.5 |
2442 | 2023-11-01 00:45:09 | bob | 2 | 14084 | 412 | 0.346 | 40705.2 |
2441 | 2023-11-01 00:26:10 | bob | 2 | 14084 | 412 | 0.406 | 34689.7 |
2440 | 2023-10-31 22:03:06 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2439 | 2023-10-31 16:16:15 | bob | 2 | 14084 | 412 | 0.343 | 41061.2 |
2438 | 2023-10-30 14:54:48 | bob | 2 | 14084 | 412 | 0.373 | 37758.7 |
2437 | 2023-10-29 09:28:16 | bob | 2 | 14084 | 412 | 0.326 | 43202.5 |
2436 | 2023-10-28 23:19:41 | bob | 2 | 14084 | 412 | 0.436 | 32302.8 |
2435 | 2023-10-27 07:12:59 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2434 | 2023-10-26 15:20:51 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2433 | 2023-10-26 00:22:19 | bob | 2 | 14084 | 412 | 0.406 | 34689.7 |
2432 | 2023-10-24 08:59:42 | bob | 2 | 14084 | 412 | 0.373 | 37758.7 |
2431 | 2023-10-22 23:40:15 | bob | 2 | 14084 | 412 | 0.483 | 29159.4 |
2430 | 2023-10-22 16:59:00 | bob | 2 | 14084 | 412 | 0.326 | 43202.5 |
2429 | 2023-10-19 21:35:11 | bob | 1 | 5146 | 30 | 0.096 | 53604.2 |
2428 | 2023-10-19 16:06:05 | bob | 2 | 14084 | 412 | 0.376 | 37457.4 |
2427 | 2023-10-17 04:09:22 | bob | 2 | 14084 | 412 | 0.373 | 37758.7 |
2426 | 2023-10-17 01:48:25 | bob | 1 | 5146 | 30 | 0.076 | 67710.5 |
2425 | 2023-10-15 00:58:51 | bob | 2 | 14084 | 412 | 0.326 | 43202.5 |
2424 | 2023-10-13 00:28:27 | bob | 1 | 5146 | 30 | 0.080 | 64325.0 |
2423 | 2023-10-12 23:44:57 | bob | 2 | 14084 | 412 | 0.360 | 39122.2 |
2422 | 2023-10-11 02:37:50 | bob | 2 | 14084 | 412 | 0.326 | 43202.5 |
2421 | 2023-10-03 18:29:39 | bob | 2 | 14084 | 412 | 0.423 | 33295.5 |
2420 | 2023-10-03 17:36:02 | bob | 1 | 5146 | 30 | 0.110 | 46781.8 |
2419 | 2023-10-01 17:05:07 | bob | 2 | 14084 | 412 | 0.343 | 41061.2 |
2418 | 2023-09-29 13:47:38 | bob | 2 | 14084 | 412 | 0.736 | 19135.9 |
2417 | 2023-09-27 00:47:17 | bob | 2 | 14084 | 412 | 0.343 | 41061.2 |
2416 | 2023-09-23 14:45:19 | bob | 2 | 14084 | 412 | 0.656 | 21469.5 |
2415 | 2023-09-22 12:20:23 | bob | 2 | 14084 | 412 | 0.326 | 43202.5 |
2414 | 2023-09-21 00:39:37 | bob | 2 | 14084 | 412 | 0.390 | 36112.8 |
2413 | 2023-09-19 13:56:10 | bob | 1 | 5146 | 30 | 0.076 | 67710.5 |
2412 | 2023-09-18 21:10:02 | bob | 2 | 14084 | 412 | 0.330 | 42678.8 |
2411 | 2023-09-17 08:29:45 | bob | 2 | 14084 | 412 | 0.313 | 44996.8 |
2410 | 2023-09-14 22:44:11 | bob | 2 | 14084 | 412 | 0.436 | 32302.8 |
2409 | 2023-09-13 01:47:48 | bob | 2 | 14084 | 412 | 0.360 | 39122.2 |
2408 | 2023-09-11 01:42:51 | bob | 2 | 14084 | 412 | 0.373 | 37758.7 |
2407 | 2023-09-10 16:39:02 | bob | 1 | 5146 | 30 | 0.093 | 55333.3 |
2406 | 2023-09-10 15:40:28 | bob | 2 | 14084 | 412 | 0.453 | 31090.5 |
2405 | 2023-09-09 05:57:26 | bob | 2 | 14084 | 412 | 0.343 | 41061.2 |
2404 | 2023-09-07 16:18:03 | bob | 2 | 14084 | 412 | 0.330 | 42678.8 |
2403 | 2023-09-05 12:28:16 | bob | 2 | 14084 | 412 | 0.356 | 39561.8 |
2402 | 2023-09-03 15:14:36 | bob | 2 | 14084 | 412 | 0.360 | 39122.2 |
2401 | 2023-09-01 21:54:44 | bob | 2 | 14084 | 412 | 0.406 | 34689.7 |
2400 | 2023-08-30 23:34:02 | bob | 2 | 14084 | 412 | 0.360 | 39122.2 |
2399 | 2023-08-29 13:04:56 | bob | 2 | 14084 | 412 | 0.376 | 37457.4 |
2398 | 2023-08-28 08:10:31 | bob | 2 | 14084 | 412 | 0.360 | 39122.2 |
2397 | 2023-08-27 00:52:49 | bob | 2 | 14084 | 412 | 0.330 | 42678.8 |
2396 | 2023-08-26 09:17:12 | bob | 2 | 14084 | 412 | 0.356 | 39561.8 |
2395 | 2023-08-25 08:03:42 | bob | 2 | 14084 | 412 | 0.330 | 42678.8 |