History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"staph"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1122 | 2024-04-27 06:33:59 | staph | 1 | 28756 | 3 | 1.140 | 25224.6 |
| 1121 | 2024-04-26 19:25:53 | staph | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1120 | 2024-04-26 05:13:50 | staph | 3 | 83667 | 1032 | 3.936 | 21256.9 |
| 1119 | 2024-04-20 05:19:53 | staph | 3 | 83667 | 1032 | 3.436 | 24350.1 |
| 1118 | 2024-04-14 00:23:39 | staph | 1 | 28756 | 3 | 1.860 | 15460.2 |
| 1117 | 2024-04-06 05:39:23 | staph | 1 | 28756 | 3 | 0.590 | 48739.0 |
| 1116 | 2024-03-31 08:39:18 | staph | 3 | 83667 | 1032 | 8.563 | 9770.8 |
| 1115 | 2024-03-31 08:39:19 | staph | 2 | 53800 | 94 | 3.720 | 14462.4 |
| 1114 | 2024-03-31 08:39:03 | staph | 3 | 83667 | 1032 | 9.030 | 9265.4 |
| 1113 | 2024-03-31 08:39:12 | staph | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1112 | 2024-03-31 08:39:01 | staph | 2 | 53800 | 94 | 3.623 | 14849.6 |
| 1111 | 2024-03-31 08:38:59 | staph | 1 | 28756 | 3 | 0.576 | 49923.6 |
| 1110 | 2024-03-28 20:49:50 | staph | 1 | 28756 | 3 | 0.656 | 43835.4 |
| 1109 | 2024-03-07 04:39:22 | staph | 3 | 83667 | 1032 | 10.830 | 7725.5 |
| 1108 | 2024-03-07 04:39:23 | staph | 2 | 53800 | 94 | 5.813 | 9255.1 |
| 1107 | 2024-03-07 04:19:37 | staph | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1106 | 2024-03-01 00:52:02 | staph | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1105 | 2024-02-29 17:51:29 | staph | 2 | 53800 | 94 | 1.626 | 33087.3 |
| 1104 | 2024-02-29 17:50:43 | staph | 3 | 83667 | 1032 | 5.203 | 16080.5 |
| 1103 | 2024-02-27 15:04:52 | staph | 2 | 53800 | 94 | 1.766 | 30464.3 |
| 1102 | 2024-02-27 15:04:06 | staph | 3 | 83667 | 1032 | 3.720 | 22491.1 |
| 1101 | 2024-02-26 14:41:56 | staph | 1 | 28756 | 3 | 0.560 | 51350.0 |
| 1100 | 2024-02-26 08:48:36 | staph | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1099 | 2024-02-25 19:30:54 | staph | 3 | 83667 | 1032 | 4.046 | 20678.9 |
| 1098 | 2024-02-25 19:30:54 | staph | 2 | 53800 | 94 | 1.720 | 31279.1 |
| 1097 | 2024-02-03 21:55:55 | staph | 2 | 53800 | 94 | 1.563 | 34421.0 |
| 1096 | 2024-02-03 21:55:15 | staph | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1095 | 2024-01-28 22:49:03 | staph | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1094 | 2024-01-27 05:30:33 | staph | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1093 | 2024-01-02 14:55:07 | staph | 3 | 83667 | 1032 | 3.546 | 23594.8 |
| 1092 | 2024-01-02 14:55:09 | staph | 2 | 53800 | 94 | 1.623 | 33148.5 |
| 1091 | 2024-01-01 19:22:54 | staph | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 1090 | 2023-12-28 04:20:43 | staph | 2 | 53800 | 94 | 1.373 | 39184.3 |
| 1089 | 2023-12-25 21:06:41 | staph | 3 | 83667 | 1032 | 4.546 | 18404.5 |
| 1088 | 2023-12-14 02:58:25 | staph | 3 | 83667 | 1032 | 3.780 | 22134.1 |
| 1087 | 2023-12-14 02:58:22 | staph | 2 | 53800 | 94 | 1.610 | 33416.1 |
| 1086 | 2023-12-04 17:58:37 | staph | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1085 | 2023-12-03 13:05:06 | staph | 2 | 53800 | 94 | 1.420 | 37887.3 |
| 1084 | 2023-12-03 13:05:04 | staph | 2 | 53800 | 94 | 1.533 | 35094.6 |
| 1083 | 2023-12-03 00:10:35 | staph | 3 | 83667 | 1032 | 3.500 | 23904.9 |
| 1082 | 2023-12-03 00:10:30 | staph | 2 | 53800 | 94 | 1.513 | 35558.5 |
| 1081 | 2023-11-17 12:51:09 | staph | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1080 | 2023-11-14 16:26:30 | staph | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1079 | 2023-11-11 10:25:57 | staph | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1078 | 2023-11-02 12:21:55 | staph | 3 | 83667 | 1032 | 6.376 | 13122.2 |
| 1077 | 2023-11-02 12:21:52 | staph | 2 | 53800 | 94 | 1.470 | 36598.6 |
| 1076 | 2023-10-31 04:38:12 | staph | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1075 | 2023-10-27 22:01:46 | staph | 1 | 28756 | 3 | 0.576 | 49923.6 |
| 1074 | 2023-10-20 22:25:49 | staph | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 1073 | 2023-10-18 05:00:21 | staph | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1072 | 2023-10-13 17:53:28 | staph | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1071 | 2023-10-10 15:29:24 | staph | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1070 | 2023-10-04 13:09:47 | staph | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1069 | 2023-10-03 12:19:02 | staph | 3 | 83667 | 1032 | 3.563 | 23482.2 |
| 1068 | 2023-10-01 21:56:46 | staph | 3 | 83667 | 1032 | 3.750 | 22311.2 |
| 1067 | 2023-10-01 06:44:30 | staph | 2 | 53800 | 94 | 1.390 | 38705.0 |
| 1066 | 2023-09-29 08:25:04 | staph | 3 | 83667 | 1032 | 3.330 | 25125.2 |
| 1065 | 2023-09-23 12:26:30 | staph | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1064 | 2023-09-22 01:28:54 | staph | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1063 | 2023-09-19 15:47:04 | staph | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 1062 | 2023-08-14 09:44:19 | staph | 3 | 83667 | 1032 | 3.500 | 23904.9 |
| 1061 | 2023-08-09 08:59:04 | staph | 3 | 83667 | 1032 | 3.626 | 23074.2 |
| 1060 | 2023-08-08 13:17:12 | staph | 3 | 83667 | 1032 | 3.720 | 22491.1 |
| 1059 | 2023-07-15 15:49:57 | staph | 3 | 83667 | 1032 | 3.906 | 21420.1 |
| 1058 | 2023-07-14 18:29:08 | staph | 3 | 83667 | 1032 | 6.690 | 12506.3 |
| 1057 | 2023-07-11 17:17:32 | staph | 2 | 53800 | 94 | 1.546 | 34799.5 |
| 1056 | 2023-07-11 01:03:22 | staph | 3 | 83667 | 1032 | 3.313 | 25254.2 |
| 1055 | 2023-07-05 23:03:13 | staph | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1054 | 2023-06-27 23:11:31 | staph | 3 | 83667 | 1032 | 3.703 | 22594.4 |
| 1053 | 2023-06-23 02:18:45 | staph | 3 | 83667 | 1032 | 3.626 | 23074.2 |
| 1052 | 2023-05-31 16:21:01 | staph | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 1051 | 2023-04-10 18:20:17 | staph | 1 | 28756 | 3 | 0.890 | 32310.1 |
| 1050 | 2023-03-31 08:46:54 | staph | 3 | 83667 | 1032 | 3.266 | 25617.6 |
| 1049 | 2023-03-28 13:05:47 | staph | 2 | 53800 | 94 | 1.563 | 34421.0 |
| 1048 | 2023-02-02 12:20:54 | staph | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 1047 | 2023-01-25 13:09:45 | staph | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1046 | 2022-12-29 14:44:26 | staph | 3 | 83667 | 1032 | 3.360 | 24900.9 |
| 1045 | 2022-12-27 10:07:09 | staph | 2 | 53800 | 94 | 1.360 | 39558.8 |
| 1044 | 2022-12-02 16:07:05 | staph | 3 | 83667 | 1032 | 3.813 | 21942.6 |
| 1043 | 2022-12-01 00:29:04 | staph | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1042 | 2022-10-31 07:34:36 | staph | 3 | 83667 | 1032 | 3.766 | 22216.4 |
| 1041 | 2022-09-15 23:56:25 | staph | 1 | 28756 | 3 | 0.533 | 53951.2 |
| 1040 | 2022-09-09 12:57:10 | staph | 3 | 83667 | 1032 | 3.330 | 25125.2 |
| 1039 | 2022-09-01 04:38:01 | staph | 3 | 83667 | 1032 | 3.706 | 22576.1 |
| 1038 | 2022-08-28 00:49:20 | staph | 2 | 53800 | 94 | 1.406 | 38264.6 |
| 1037 | 2022-07-26 20:33:40 | staph | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1036 | 2022-06-07 11:34:57 | staph | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1035 | 2022-04-22 05:03:30 | staph | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1034 | 2022-03-25 22:17:52 | staph | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1033 | 2022-03-19 23:20:30 | staph | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1032 | 2021-12-29 16:54:41 | staph | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1031 | 2021-12-27 13:28:35 | staph | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1030 | 2021-12-17 21:09:31 | staph | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1029 | 2021-10-30 06:13:17 | staph | 1 | 28756 | 3 | 0.513 | 56054.6 |
| 1028 | 2021-10-28 05:05:03 | staph | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1027 | 2021-09-16 10:42:27 | staph | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1026 | 2021-09-14 07:01:04 | staph | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1025 | 2021-08-27 17:07:07 | staph | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1024 | 2021-08-21 20:09:02 | staph | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1023 | 2021-07-27 18:57:46 | staph | 1 | 28756 | 3 | 0.486 | 59168.7 |