History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"reptile"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
508 | 2024-03-28 13:41:50 | reptile | 1 | 69583 | 3 | 1.093 | 63662.4 |
507 | 2024-03-23 21:37:07 | reptile | 1 | 69583 | 3 | 1.280 | 54361.7 |
506 | 2024-03-12 04:20:46 | reptile | 2 | 107671 | 32 | 4.950 | 21751.7 |
505 | 2024-02-22 00:00:06 | reptile | 3 | 134027 | 392 | 10.626 | 12613.1 |
504 | 2024-02-20 08:44:55 | reptile | 3 | 134027 | 392 | 10.686 | 12542.3 |
503 | 2024-01-30 05:50:37 | reptile | 3 | 134027 | 392 | 14.563 | 9203.3 |
502 | 2024-01-20 05:13:14 | reptile | 3 | 134027 | 392 | 7.453 | 17983.0 |
501 | 2024-01-13 06:42:40 | reptile | 3 | 134027 | 392 | 6.016 | 22278.4 |
500 | 2023-12-18 15:33:50 | reptile | 1 | 69583 | 3 | 1.233 | 56433.9 |
499 | 2023-12-15 09:29:28 | reptile | 1 | 69583 | 3 | 1.310 | 53116.8 |
498 | 2023-12-12 00:03:14 | reptile | 1 | 69583 | 3 | 1.296 | 53690.6 |
497 | 2023-12-09 23:11:59 | reptile | 1 | 69583 | 3 | 1.296 | 53690.6 |
496 | 2023-11-29 07:17:26 | reptile | 1 | 69583 | 3 | 1.123 | 61961.7 |
495 | 2023-11-26 00:35:31 | reptile | 1 | 69583 | 3 | 1.093 | 63662.4 |
494 | 2023-11-25 22:18:48 | reptile | 2 | 107671 | 32 | 3.280 | 32826.5 |
493 | 2023-11-17 07:48:07 | reptile | 3 | 134027 | 392 | 6.796 | 19721.5 |
492 | 2023-11-05 21:38:44 | reptile | 1 | 69583 | 3 | 1.296 | 53690.6 |
491 | 2023-10-15 16:14:39 | reptile | 1 | 69583 | 3 | 1.160 | 59985.3 |
490 | 2023-10-06 05:02:12 | reptile | 1 | 69583 | 3 | 1.203 | 57841.2 |
489 | 2023-09-29 11:57:15 | reptile | 1 | 69583 | 3 | 1.203 | 57841.2 |
488 | 2023-09-22 19:28:17 | reptile | 1 | 69583 | 3 | 1.170 | 59472.6 |
487 | 2023-08-25 07:36:36 | reptile | 2 | 107671 | 32 | 2.906 | 37051.3 |
486 | 2023-08-18 20:57:49 | reptile | 3 | 134027 | 392 | 5.970 | 22450.1 |
485 | 2023-08-08 22:27:10 | reptile | 1 | 69583 | 3 | 1.233 | 56433.9 |
484 | 2023-08-02 16:52:25 | reptile | 1 | 69583 | 3 | 1.220 | 57035.2 |
483 | 2023-06-21 05:36:03 | reptile | 3 | 134027 | 392 | 6.013 | 22289.5 |
482 | 2023-05-09 01:15:16 | reptile | 2 | 107671 | 32 | 2.876 | 37437.8 |
481 | 2023-05-04 10:18:54 | reptile | 3 | 134027 | 392 | 6.423 | 20866.7 |
480 | 2023-05-02 18:52:38 | reptile | 3 | 134027 | 392 | 6.033 | 22215.6 |
479 | 2023-05-02 04:47:53 | reptile | 1 | 69583 | 3 | 1.250 | 55666.4 |
478 | 2023-04-24 02:41:09 | reptile | 2 | 107671 | 32 | 3.093 | 34811.2 |
477 | 2023-04-24 00:00:20 | reptile | 1 | 69583 | 3 | 2.576 | 27012.0 |
476 | 2023-04-19 17:46:47 | reptile | 3 | 134027 | 392 | 6.673 | 20085.0 |
475 | 2023-03-28 04:21:23 | reptile | 3 | 134027 | 392 | 5.876 | 22809.2 |
474 | 2023-03-20 11:21:53 | reptile | 2 | 107671 | 32 | 2.860 | 37647.2 |
473 | 2023-03-19 02:04:34 | reptile | 2 | 107671 | 32 | 2.890 | 37256.4 |
472 | 2023-02-20 18:04:45 | reptile | 1 | 69583 | 3 | 1.076 | 64668.2 |
471 | 2023-02-14 07:01:55 | reptile | 2 | 107671 | 32 | 3.266 | 32967.2 |
470 | 2023-02-11 00:54:11 | reptile | 3 | 134027 | 392 | 6.936 | 19323.4 |
469 | 2023-01-07 21:48:09 | reptile | 1 | 69583 | 3 | 1.076 | 64668.2 |
468 | 2022-12-18 13:51:24 | reptile | 1 | 69583 | 3 | 1.093 | 63662.4 |
467 | 2022-11-25 15:17:15 | reptile | 2 | 107671 | 32 | 3.690 | 29179.1 |
466 | 2022-11-22 02:57:15 | reptile | 3 | 134027 | 392 | 5.906 | 22693.4 |
465 | 2022-09-10 19:45:27 | reptile | 1 | 69583 | 3 | 1.110 | 62687.4 |
464 | 2022-09-06 04:38:09 | reptile | 1 | 69583 | 3 | 1.280 | 54361.7 |
463 | 2022-08-31 17:17:52 | reptile | 1 | 69583 | 3 | 1.093 | 63662.4 |
462 | 2022-08-30 17:09:54 | reptile | 1 | 69583 | 3 | 1.093 | 63662.4 |
461 | 2022-08-21 23:26:30 | reptile | 1 | 69583 | 3 | 1.093 | 63662.4 |
460 | 2022-06-27 05:36:25 | reptile | 3 | 134027 | 392 | 5.956 | 22502.9 |
459 | 2022-06-25 00:59:30 | reptile | 3 | 134027 | 392 | 5.923 | 22628.2 |
458 | 2022-04-30 09:59:32 | reptile | 1 | 69583 | 3 | 1.263 | 55093.4 |
457 | 2022-04-29 17:37:57 | reptile | 2 | 107671 | 32 | 2.860 | 37647.2 |
456 | 2022-04-19 11:44:42 | reptile | 1 | 69583 | 3 | 1.203 | 57841.2 |
455 | 2022-02-08 15:10:54 | reptile | 3 | 134027 | 392 | 5.873 | 22820.9 |
454 | 2022-01-15 05:18:33 | reptile | 1 | 69583 | 3 | 1.313 | 52995.4 |
453 | 2022-01-10 03:28:02 | reptile | 1 | 69583 | 3 | 1.153 | 60349.5 |
452 | 2022-01-03 20:03:44 | reptile | 2 | 107671 | 32 | 3.236 | 33272.9 |
451 | 2021-11-15 18:41:33 | reptile | 3 | 134027 | 392 | 9.890 | 13551.8 |
450 | 2021-11-13 03:41:31 | reptile | 1 | 69583 | 3 | 1.233 | 56433.9 |
449 | 2021-10-29 00:25:06 | reptile | 2 | 107671 | 32 | 3.063 | 35152.1 |
448 | 2021-09-30 20:02:01 | reptile | 1 | 69583 | 3 | 1.186 | 58670.3 |
447 | 2021-09-30 17:11:55 | reptile | 1 | 69583 | 3 | 1.216 | 57222.9 |
446 | 2021-08-31 13:22:13 | reptile | 1 | 69583 | 3 | 1.156 | 60192.9 |
445 | 2021-08-29 07:42:10 | reptile | 1 | 69583 | 3 | 1.110 | 62687.4 |
444 | 2021-08-27 03:12:51 | reptile | 1 | 69583 | 3 | 1.143 | 60877.5 |
443 | 2021-07-28 04:46:47 | reptile | 1 | 69583 | 3 | 1.236 | 56296.9 |
442 | 2021-07-01 07:58:50 | reptile | 1 | 69583 | 3 | 1.110 | 62687.4 |
441 | 2021-05-28 10:59:42 | reptile | 2 | 107671 | 32 | 3.640 | 29579.9 |
440 | 2021-05-19 07:04:48 | reptile | 1 | 69583 | 3 | 1.233 | 56433.9 |
439 | 2021-05-02 17:12:41 | reptile | 2 | 107671 | 32 | 2.983 | 36094.9 |
438 | 2021-03-31 09:11:02 | reptile | 1 | 69583 | 3 | 1.093 | 63662.4 |
437 | 2021-03-22 04:44:44 | reptile | 1 | 69583 | 3 | 1.313 | 52995.4 |
436 | 2021-02-23 08:17:26 | reptile | 1 | 69583 | 3 | 1.296 | 53690.6 |
435 | 2021-01-30 05:57:44 | reptile | 1 | 69583 | 3 | 1.203 | 57841.2 |
434 | 2021-01-15 20:49:56 | reptile | 2 | 107671 | 32 | 3.063 | 35152.1 |
433 | 2021-01-04 00:09:20 | reptile | 1 | 69583 | 3 | 1.203 | 57841.2 |
432 | 2020-12-19 18:24:08 | reptile | 1 | 69583 | 3 | 1.126 | 61796.6 |
431 | 2020-12-16 22:16:38 | reptile | 2 | 107671 | 32 | 2.936 | 36672.7 |
430 | 2020-11-01 15:23:35 | reptile | 1 | 69583 | 3 | 1.140 | 61037.7 |
429 | 2020-10-30 03:18:35 | reptile | 2 | 107671 | 32 | 3.390 | 31761.4 |
428 | 2020-10-27 01:49:56 | reptile | 1 | 69583 | 3 | 1.220 | 57035.2 |
427 | 2020-10-22 16:11:35 | reptile | 3 | 134027 | 392 | 13.203 | 10151.3 |
426 | 2020-10-18 19:42:26 | reptile | 1 | 69583 | 3 | 1.093 | 63662.4 |
425 | 2020-10-17 17:59:37 | reptile | 1 | 69583 | 3 | 1.220 | 57035.2 |
424 | 2020-09-25 04:00:29 | reptile | 2 | 107671 | 32 | 2.903 | 37089.6 |
423 | 2020-09-19 08:21:20 | reptile | 1 | 69583 | 3 | 1.110 | 62687.4 |
422 | 2020-09-11 03:34:48 | reptile | 2 | 107671 | 32 | 2.906 | 37051.3 |
421 | 2020-08-17 03:16:26 | reptile | 1 | 69583 | 3 | 1.313 | 52995.4 |
420 | 2020-08-12 07:54:37 | reptile | 2 | 107671 | 32 | 3.546 | 30364.1 |
419 | 2020-08-11 11:46:33 | reptile | 1 | 69583 | 3 | 1.203 | 57841.2 |
418 | 2020-07-30 05:35:03 | reptile | 2 | 107671 | 32 | 3.220 | 33438.2 |
417 | 2020-06-15 04:34:11 | reptile | 1 | 69583 | 3 | 1.140 | 61037.7 |
416 | 2020-06-12 05:12:54 | reptile | 1 | 69583 | 3 | 1.080 | 64428.7 |
415 | 2020-04-08 12:01:08 | reptile | 1 | 69583 | 3 | 1.190 | 58473.1 |
414 | 2020-03-28 06:54:46 | reptile | 1 | 69583 | 3 | 1.283 | 54234.6 |
413 | 2020-03-26 04:24:51 | reptile | 1 | 69583 | 3 | 2.330 | 29863.9 |
412 | 2020-03-23 22:02:03 | reptile | 1 | 69583 | 3 | 1.233 | 56433.9 |
411 | 2020-03-22 13:58:43 | reptile | 1 | 69583 | 3 | 2.690 | 25867.3 |
410 | 2020-03-20 11:48:01 | reptile | 1 | 69583 | 3 | 1.283 | 54234.6 |
409 | 2020-03-01 21:30:25 | reptile | 1 | 69583 | 3 | 1.123 | 61961.7 |