History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"contains"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
467 | 2024-04-30 02:46:49 | contains | 1 | 82945 | 2 | 4.470 | 18555.9 |
466 | 2024-04-03 15:01:48 | contains | 3 | 146162 | 262 | 19.080 | 7660.5 |
465 | 2024-04-03 15:01:49 | contains | 2 | 121059 | 23 | 10.033 | 12066.1 |
464 | 2024-04-03 13:54:59 | contains | 2 | 121059 | 23 | 3.673 | 32959.2 |
463 | 2024-04-03 13:54:44 | contains | 3 | 146162 | 262 | 7.376 | 19815.9 |
462 | 2024-04-01 03:21:54 | contains | 2 | 121059 | 23 | 5.453 | 22200.4 |
461 | 2024-03-31 15:40:40 | contains | 2 | 121059 | 23 | 6.253 | 19360.1 |
460 | 2024-03-31 15:40:38 | contains | 1 | 82945 | 2 | 2.173 | 38170.7 |
459 | 2024-03-31 15:39:58 | contains | 3 | 146162 | 262 | 8.236 | 17746.7 |
458 | 2024-03-31 14:05:09 | contains | 3 | 146162 | 262 | 23.580 | 6198.6 |
457 | 2024-03-31 13:21:43 | contains | 2 | 121059 | 23 | 11.643 | 10397.6 |
456 | 2024-03-31 13:21:35 | contains | 3 | 146162 | 262 | 18.130 | 8061.9 |
455 | 2024-03-31 12:29:43 | contains | 1 | 82945 | 2 | 1.390 | 59672.7 |
454 | 2024-03-30 02:39:14 | contains | 1 | 82945 | 2 | 2.423 | 34232.4 |
453 | 2024-03-15 09:49:45 | contains | 1 | 82945 | 2 | 2.893 | 28670.9 |
452 | 2024-03-01 07:47:01 | contains | 1 | 82945 | 2 | 1.593 | 52068.4 |
451 | 2024-02-04 11:28:50 | contains | 3 | 146162 | 262 | 13.940 | 10485.1 |
450 | 2024-02-04 01:20:30 | contains | 3 | 146162 | 262 | 9.033 | 16180.9 |
449 | 2024-02-04 00:08:42 | contains | 2 | 121059 | 23 | 7.453 | 16243.0 |
448 | 2024-02-04 00:08:38 | contains | 3 | 146162 | 262 | 7.483 | 19532.5 |
447 | 2024-02-04 00:07:54 | contains | 2 | 121059 | 23 | 3.440 | 35191.6 |
446 | 2024-02-03 22:15:31 | contains | 3 | 146162 | 262 | 6.516 | 22431.2 |
445 | 2024-02-03 22:15:27 | contains | 2 | 121059 | 23 | 3.546 | 34139.6 |
444 | 2024-02-03 22:15:23 | contains | 1 | 82945 | 2 | 1.390 | 59672.7 |
443 | 2024-01-22 06:36:33 | contains | 1 | 82945 | 2 | 1.466 | 56579.1 |
442 | 2023-12-02 03:25:48 | contains | 1 | 82945 | 2 | 1.360 | 60989.0 |
441 | 2023-11-29 01:26:52 | contains | 1 | 82945 | 2 | 1.390 | 59672.7 |
440 | 2023-11-19 10:29:08 | contains | 1 | 82945 | 2 | 1.453 | 57085.3 |
439 | 2023-11-11 05:35:42 | contains | 1 | 82945 | 2 | 1.606 | 51646.9 |
438 | 2023-10-26 22:38:22 | contains | 1 | 82945 | 2 | 1.423 | 58288.8 |
437 | 2023-10-18 08:42:52 | contains | 1 | 82945 | 2 | 1.376 | 60279.8 |
436 | 2023-10-16 19:05:19 | contains | 1 | 82945 | 2 | 2.750 | 30161.8 |
435 | 2023-09-16 20:32:17 | contains | 1 | 82945 | 2 | 1.296 | 64000.8 |
434 | 2023-09-04 20:59:53 | contains | 1 | 82945 | 2 | 2.420 | 34274.8 |
433 | 2023-07-18 01:38:11 | contains | 1 | 82945 | 2 | 1.516 | 54713.1 |
432 | 2023-04-13 21:48:47 | contains | 1 | 82945 | 2 | 1.486 | 55817.6 |
431 | 2023-03-19 23:14:36 | contains | 1 | 82945 | 2 | 1.420 | 58412.0 |
430 | 2023-01-06 21:16:07 | contains | 1 | 82945 | 2 | 1.266 | 65517.4 |
429 | 2023-01-05 02:04:17 | contains | 1 | 82945 | 2 | 1.436 | 57761.1 |
428 | 2022-10-01 19:52:19 | contains | 1 | 82945 | 2 | 1.296 | 64000.8 |
427 | 2022-09-14 06:20:30 | contains | 1 | 82945 | 2 | 1.436 | 57761.1 |
426 | 2022-06-01 06:56:21 | contains | 1 | 82945 | 2 | 3.003 | 27620.7 |
425 | 2022-05-30 22:46:16 | contains | 1 | 82945 | 2 | 1.313 | 63172.1 |
424 | 2022-05-15 00:22:19 | contains | 1 | 82945 | 2 | 1.343 | 61761.0 |
423 | 2022-02-21 05:08:27 | contains | 1 | 82945 | 2 | 1.330 | 62364.7 |
422 | 2022-02-10 14:47:00 | contains | 1 | 82945 | 2 | 1.436 | 57761.1 |
421 | 2022-01-29 16:26:59 | contains | 1 | 82945 | 2 | 1.330 | 62364.7 |
420 | 2021-11-24 20:58:02 | contains | 1 | 82945 | 2 | 1.500 | 55296.7 |
419 | 2021-11-19 19:09:49 | contains | 1 | 82945 | 2 | 1.360 | 60989.0 |
418 | 2021-10-06 11:30:50 | contains | 1 | 82945 | 2 | 1.376 | 60279.8 |
417 | 2021-10-04 08:56:23 | contains | 1 | 82945 | 2 | 1.326 | 62552.8 |
416 | 2021-08-30 18:44:31 | contains | 1 | 82945 | 2 | 1.296 | 64000.8 |
415 | 2021-08-28 21:13:54 | contains | 1 | 82945 | 2 | 1.283 | 64649.3 |
414 | 2021-08-16 22:16:29 | contains | 1 | 82945 | 2 | 1.300 | 63803.8 |
413 | 2021-08-15 12:31:42 | contains | 1 | 82945 | 2 | 1.283 | 64649.3 |
412 | 2021-07-15 01:17:58 | contains | 1 | 82945 | 2 | 1.343 | 61761.0 |
411 | 2021-05-16 05:57:43 | contains | 1 | 82945 | 2 | 1.486 | 55817.6 |
410 | 2021-05-12 21:18:45 | contains | 1 | 82945 | 2 | 2.906 | 28542.7 |
409 | 2021-05-04 06:32:38 | contains | 1 | 82945 | 2 | 1.360 | 60989.0 |
408 | 2021-05-03 12:11:57 | contains | 1 | 82945 | 2 | 1.530 | 54212.4 |
407 | 2021-04-02 08:02:32 | contains | 1 | 82945 | 2 | 1.300 | 63803.8 |
406 | 2021-02-15 11:43:08 | contains | 1 | 82945 | 2 | 1.326 | 62552.8 |
405 | 2021-02-09 00:57:29 | contains | 1 | 82945 | 2 | 1.310 | 63316.8 |
404 | 2021-02-03 18:44:06 | contains | 1 | 82945 | 2 | 1.313 | 63172.1 |
403 | 2021-01-17 09:25:31 | contains | 1 | 82945 | 2 | 1.436 | 57761.1 |
402 | 2020-11-02 02:08:54 | contains | 1 | 82945 | 2 | 1.576 | 52630.1 |
401 | 2020-10-30 23:05:45 | contains | 1 | 82945 | 2 | 1.436 | 57761.1 |
400 | 2020-10-25 23:13:34 | contains | 1 | 82945 | 2 | 1.313 | 63172.1 |
399 | 2020-10-08 08:27:38 | contains | 1 | 82945 | 2 | 1.406 | 58993.6 |
398 | 2020-09-21 13:57:50 | contains | 1 | 82945 | 2 | 1.313 | 63172.1 |
397 | 2020-09-19 18:22:22 | contains | 1 | 82945 | 2 | 1.313 | 63172.1 |
396 | 2020-08-07 02:36:50 | contains | 1 | 82945 | 2 | 1.313 | 63172.1 |
395 | 2020-08-05 16:33:41 | contains | 1 | 82945 | 2 | 1.483 | 55930.5 |
394 | 2020-08-03 21:17:39 | contains | 1 | 82945 | 2 | 1.516 | 54713.1 |
393 | 2020-08-02 15:40:46 | contains | 1 | 82945 | 2 | 1.403 | 59119.7 |
392 | 2020-05-04 08:45:16 | contains | 1 | 82945 | 2 | 1.296 | 64000.8 |
391 | 2020-04-30 01:47:11 | contains | 1 | 82945 | 2 | 1.516 | 54713.1 |
390 | 2020-03-28 22:07:53 | contains | 1 | 82945 | 2 | 1.516 | 54713.1 |
389 | 2020-03-25 07:35:40 | contains | 1 | 82945 | 2 | 1.470 | 56425.2 |
388 | 2020-03-23 22:58:24 | contains | 1 | 82945 | 2 | 3.046 | 27230.8 |
387 | 2020-03-20 19:09:53 | contains | 1 | 82945 | 2 | 1.356 | 61168.9 |
386 | 2020-03-01 02:13:11 | contains | 1 | 82945 | 2 | 1.440 | 57600.7 |
385 | 2020-02-24 21:05:07 | contains | 1 | 82945 | 2 | 1.326 | 62552.8 |
384 | 2020-02-23 14:14:33 | contains | 1 | 82945 | 2 | 1.906 | 43517.8 |
383 | 2020-02-21 10:37:02 | contains | 1 | 82945 | 2 | 1.376 | 60279.8 |
382 | 2020-02-06 12:20:13 | contains | 1 | 82945 | 2 | 1.593 | 52068.4 |
381 | 2020-02-05 12:19:13 | contains | 1 | 82945 | 2 | 1.596 | 51970.6 |
380 | 2020-02-03 17:56:40 | contains | 1 | 82945 | 2 | 1.470 | 56425.2 |
379 | 2020-02-02 05:54:48 | contains | 1 | 82945 | 2 | 3.030 | 27374.6 |
378 | 2020-02-02 03:42:05 | contains | 1 | 82945 | 2 | 1.453 | 57085.3 |
377 | 2020-01-31 17:46:56 | contains | 1 | 82945 | 2 | 2.063 | 40206.0 |
376 | 2020-01-31 07:18:34 | contains | 1 | 82945 | 2 | 1.736 | 47779.4 |
375 | 2020-01-16 20:49:52 | contains | 1 | 82945 | 2 | 2.970 | 27927.6 |
374 | 2020-01-15 16:24:09 | contains | 1 | 82945 | 2 | 1.720 | 48223.8 |
373 | 2020-01-12 20:40:32 | contains | 1 | 82945 | 2 | 1.690 | 49079.9 |
372 | 2020-01-12 19:45:48 | contains | 1 | 82945 | 2 | 3.060 | 27106.2 |
371 | 2020-01-07 10:52:14 | contains | 1 | 82945 | 2 | 1.563 | 53067.8 |
370 | 2020-01-05 04:56:17 | contains | 1 | 82945 | 2 | 3.360 | 24686.0 |
369 | 2019-12-28 03:30:10 | contains | 1 | 82945 | 2 | 1.550 | 53512.9 |
368 | 2019-12-27 23:20:07 | contains | 1 | 82945 | 2 | 1.533 | 54106.3 |