History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doses"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1200 | 2024-04-19 13:34:40 | doses | 1 | 28756 | 24 | 0.483 | 59536.2 |
| 1199 | 2024-04-03 06:43:25 | doses | 1 | 28756 | 24 | 0.513 | 56054.6 |
| 1198 | 2024-04-03 06:43:11 | doses | 2 | 53800 | 409 | 2.046 | 26295.2 |
| 1197 | 2024-04-03 03:58:10 | doses | 2 | 53800 | 409 | 1.920 | 28020.8 |
| 1196 | 2024-04-03 03:53:35 | doses | 1 | 28756 | 24 | 0.543 | 52957.6 |
| 1195 | 2024-03-30 21:12:32 | doses | 2 | 53800 | 409 | 3.920 | 13724.5 |
| 1194 | 2024-03-30 21:08:11 | doses | 1 | 28756 | 24 | 1.110 | 25906.3 |
| 1193 | 2024-03-30 01:48:17 | doses | 2 | 53800 | 409 | 1.610 | 33416.1 |
| 1192 | 2024-03-29 14:28:48 | doses | 1 | 28756 | 24 | 1.186 | 24246.2 |
| 1191 | 2024-03-27 03:35:12 | doses | 1 | 28756 | 24 | 1.703 | 16885.5 |
| 1190 | 2024-03-25 17:48:44 | doses | 1 | 28756 | 24 | 0.486 | 59168.7 |
| 1189 | 2024-03-04 04:04:51 | doses | 2 | 53800 | 409 | 1.813 | 29674.6 |
| 1188 | 2024-03-03 23:06:10 | doses | 2 | 53800 | 409 | 7.203 | 7469.1 |
| 1187 | 2024-03-03 22:32:16 | doses | 1 | 28756 | 24 | 0.483 | 59536.2 |
| 1186 | 2024-03-02 14:36:46 | doses | 1 | 28756 | 24 | 1.266 | 22714.1 |
| 1185 | 2024-02-25 22:07:33 | doses | 2 | 53800 | 409 | 5.656 | 9512.0 |
| 1184 | 2024-02-25 22:07:21 | doses | 1 | 28756 | 24 | 1.140 | 25224.6 |
| 1183 | 2024-01-28 17:55:32 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1182 | 2024-01-28 00:39:34 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1181 | 2024-01-26 22:02:25 | doses | 1 | 28756 | 24 | 0.533 | 53951.2 |
| 1180 | 2024-01-01 18:42:22 | doses | 1 | 28756 | 24 | 0.500 | 57512.0 |
| 1179 | 2024-01-01 02:13:25 | doses | 2 | 53800 | 409 | 1.390 | 38705.0 |
| 1178 | 2023-12-30 20:06:47 | doses | 1 | 28756 | 24 | 0.500 | 57512.0 |
| 1177 | 2023-12-25 16:05:52 | doses | 1 | 28756 | 24 | 0.453 | 63479.0 |
| 1176 | 2023-12-07 04:59:53 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1175 | 2023-12-04 08:03:35 | doses | 2 | 53800 | 409 | 1.423 | 37807.4 |
| 1174 | 2023-11-30 15:26:50 | doses | 2 | 53800 | 409 | 1.606 | 33499.4 |
| 1173 | 2023-11-30 07:14:47 | doses | 1 | 28756 | 24 | 0.453 | 63479.0 |
| 1172 | 2023-11-27 09:23:23 | doses | 1 | 28756 | 24 | 0.483 | 59536.2 |
| 1171 | 2023-11-14 03:34:52 | doses | 1 | 28756 | 24 | 0.546 | 52666.7 |
| 1170 | 2023-11-10 10:03:30 | doses | 1 | 28756 | 24 | 0.440 | 65354.5 |
| 1169 | 2023-10-26 22:08:44 | doses | 1 | 28756 | 24 | 0.623 | 46157.3 |
| 1168 | 2023-10-26 21:55:58 | doses | 2 | 53800 | 409 | 2.406 | 22360.8 |
| 1167 | 2023-10-25 16:48:12 | doses | 2 | 53800 | 409 | 1.546 | 34799.5 |
| 1166 | 2023-10-22 09:37:51 | doses | 1 | 28756 | 24 | 0.516 | 55728.7 |
| 1165 | 2023-10-19 19:06:37 | doses | 1 | 28756 | 24 | 0.486 | 59168.7 |
| 1164 | 2023-10-17 12:02:18 | doses | 1 | 28756 | 24 | 0.453 | 63479.0 |
| 1163 | 2023-10-13 16:50:35 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1162 | 2023-10-04 03:13:35 | doses | 1 | 28756 | 24 | 0.440 | 65354.5 |
| 1161 | 2023-09-24 07:08:32 | doses | 1 | 28756 | 24 | 0.626 | 45936.1 |
| 1160 | 2023-09-21 22:13:12 | doses | 1 | 28756 | 24 | 0.466 | 61708.2 |
| 1159 | 2023-08-29 18:09:24 | doses | 2 | 53800 | 409 | 1.376 | 39098.8 |
| 1158 | 2023-08-28 08:00:24 | doses | 1 | 28756 | 24 | 0.453 | 63479.0 |
| 1157 | 2023-08-18 16:31:21 | doses | 1 | 28756 | 24 | 0.563 | 51076.4 |
| 1156 | 2023-08-14 14:46:04 | doses | 1 | 28756 | 24 | 0.533 | 53951.2 |
| 1155 | 2023-08-13 21:31:58 | doses | 1 | 28756 | 24 | 0.423 | 67981.1 |
| 1154 | 2023-06-06 06:48:20 | doses | 1 | 28756 | 24 | 0.483 | 59536.2 |
| 1153 | 2023-05-28 04:22:45 | doses | 1 | 28756 | 24 | 0.423 | 67981.1 |
| 1152 | 2023-05-24 21:08:19 | doses | 1 | 28756 | 24 | 0.440 | 65354.5 |
| 1151 | 2023-05-19 01:30:51 | doses | 1 | 28756 | 24 | 0.470 | 61183.0 |
| 1150 | 2023-05-14 16:27:53 | doses | 2 | 53800 | 409 | 1.376 | 39098.8 |
| 1149 | 2023-05-08 00:58:02 | doses | 1 | 28756 | 24 | 0.483 | 59536.2 |
| 1148 | 2023-04-17 12:39:43 | doses | 1 | 28756 | 24 | 0.440 | 65354.5 |
| 1147 | 2023-03-14 15:21:13 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1146 | 2023-02-20 15:11:51 | doses | 2 | 53800 | 409 | 1.530 | 35163.4 |
| 1145 | 2023-02-18 21:08:00 | doses | 1 | 28756 | 24 | 0.423 | 67981.1 |
| 1144 | 2023-01-25 18:59:26 | doses | 1 | 28756 | 24 | 0.486 | 59168.7 |
| 1143 | 2023-01-23 04:41:48 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1142 | 2023-01-10 01:07:38 | doses | 2 | 53800 | 409 | 1.656 | 32487.9 |
| 1141 | 2023-01-03 07:58:54 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1140 | 2022-12-23 16:13:44 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1139 | 2022-12-18 05:09:06 | doses | 2 | 53800 | 409 | 1.393 | 38621.7 |
| 1138 | 2022-12-11 14:31:04 | doses | 1 | 28756 | 24 | 0.483 | 59536.2 |
| 1137 | 2022-12-09 00:18:46 | doses | 1 | 28756 | 24 | 0.420 | 68466.7 |
| 1136 | 2022-12-02 21:19:50 | doses | 2 | 53800 | 409 | 1.346 | 39970.3 |
| 1135 | 2022-11-19 11:49:07 | doses | 1 | 28756 | 24 | 0.500 | 57512.0 |
| 1134 | 2022-11-19 02:02:10 | doses | 2 | 53800 | 409 | 1.580 | 34050.6 |
| 1133 | 2022-11-18 09:33:04 | doses | 2 | 53800 | 409 | 1.436 | 37465.2 |
| 1132 | 2022-10-31 14:36:54 | doses | 2 | 53800 | 409 | 1.436 | 37465.2 |
| 1131 | 2022-10-25 05:39:24 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1130 | 2022-10-22 21:05:32 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1129 | 2022-10-07 01:37:04 | doses | 2 | 53800 | 409 | 1.390 | 38705.0 |
| 1128 | 2022-09-22 15:23:56 | doses | 1 | 28756 | 24 | 0.440 | 65354.5 |
| 1127 | 2022-09-18 21:02:41 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1126 | 2022-09-11 13:52:53 | doses | 1 | 28756 | 24 | 0.450 | 63902.2 |
| 1125 | 2022-09-09 10:19:15 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1124 | 2022-09-02 09:31:20 | doses | 1 | 28756 | 24 | 0.560 | 51350.0 |
| 1123 | 2022-08-24 01:44:16 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1122 | 2022-08-19 01:14:47 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1121 | 2022-07-24 04:37:54 | doses | 1 | 28756 | 24 | 0.453 | 63479.0 |
| 1120 | 2022-07-21 03:35:08 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1119 | 2022-07-18 01:31:46 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1118 | 2022-07-11 13:02:23 | doses | 1 | 28756 | 24 | 0.453 | 63479.0 |
| 1117 | 2022-07-10 05:41:29 | doses | 1 | 28756 | 24 | 0.453 | 63479.0 |
| 1116 | 2022-06-29 04:23:36 | doses | 1 | 28756 | 24 | 0.453 | 63479.0 |
| 1115 | 2022-06-25 10:44:34 | doses | 1 | 28756 | 24 | 0.453 | 63479.0 |
| 1114 | 2022-06-05 00:33:36 | doses | 1 | 28756 | 24 | 0.486 | 59168.7 |
| 1113 | 2022-06-02 07:48:19 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1112 | 2022-06-01 21:35:55 | doses | 1 | 28756 | 24 | 0.450 | 63902.2 |
| 1111 | 2022-06-01 16:19:07 | doses | 1 | 28756 | 24 | 0.453 | 63479.0 |
| 1110 | 2022-05-18 10:58:15 | doses | 1 | 28756 | 24 | 0.436 | 65954.1 |
| 1109 | 2022-05-11 10:50:20 | doses | 1 | 28756 | 24 | 0.716 | 40162.0 |
| 1108 | 2022-05-10 03:27:08 | doses | 1 | 28756 | 24 | 0.483 | 59536.2 |
| 1107 | 2022-05-03 10:55:25 | doses | 1 | 28756 | 24 | 0.563 | 51076.4 |
| 1106 | 2022-05-01 06:54:01 | doses | 1 | 28756 | 24 | 0.440 | 65354.5 |
| 1105 | 2022-04-22 10:06:54 | doses | 2 | 53800 | 409 | 2.126 | 25305.7 |
| 1104 | 2022-04-17 22:59:37 | doses | 1 | 28756 | 24 | 0.500 | 57512.0 |
| 1103 | 2022-04-15 03:03:10 | doses | 1 | 28756 | 24 | 0.546 | 52666.7 |
| 1102 | 2022-03-25 12:05:21 | doses | 1 | 28756 | 24 | 0.593 | 48492.4 |
| 1101 | 2022-03-24 15:35:32 | doses | 1 | 28756 | 24 | 0.593 | 48492.4 |