History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"veggie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
294 | 2024-04-28 10:24:22 | veggie | 1 | 48755 | 3 | 1.890 | 25796.3 |
293 | 2024-04-16 22:54:21 | veggie | 1 | 48755 | 3 | 2.690 | 18124.5 |
292 | 2024-04-16 22:52:12 | veggie | 1 | 48755 | 3 | 2.250 | 21668.9 |
291 | 2024-04-05 04:53:42 | veggie | 2 | 82551 | 23 | 2.720 | 30349.6 |
290 | 2024-04-04 20:01:36 | veggie | 3 | 112716 | 274 | 12.906 | 8733.6 |
289 | 2024-04-04 04:57:16 | veggie | 1 | 48755 | 3 | 0.733 | 66514.3 |
288 | 2024-04-04 01:47:47 | veggie | 2 | 82551 | 23 | 3.733 | 22113.8 |
287 | 2024-04-04 01:47:22 | veggie | 3 | 112716 | 274 | 7.483 | 15062.9 |
286 | 2024-04-03 09:06:48 | veggie | 2 | 82551 | 23 | 2.546 | 32423.8 |
285 | 2024-04-03 09:06:47 | veggie | 1 | 48755 | 3 | 0.890 | 54780.9 |
284 | 2024-04-03 05:02:36 | veggie | 3 | 112716 | 274 | 14.593 | 7724.0 |
283 | 2024-04-03 04:05:40 | veggie | 3 | 112716 | 274 | 10.376 | 10863.1 |
282 | 2024-03-29 02:48:10 | veggie | 1 | 48755 | 3 | 0.890 | 54780.9 |
281 | 2024-03-29 02:47:59 | veggie | 3 | 112716 | 274 | 4.813 | 23419.1 |
280 | 2024-03-29 02:47:58 | veggie | 2 | 82551 | 23 | 2.390 | 34540.2 |
279 | 2024-03-29 02:47:51 | veggie | 1 | 48755 | 3 | 0.830 | 58741.0 |
278 | 2024-03-05 18:08:40 | veggie | 3 | 112716 | 274 | 11.530 | 9775.9 |
277 | 2024-03-05 00:37:51 | veggie | 3 | 112716 | 274 | 10.533 | 10701.2 |
276 | 2024-03-04 00:25:38 | veggie | 1 | 48755 | 3 | 1.873 | 26030.4 |
275 | 2024-03-03 08:33:01 | veggie | 3 | 112716 | 274 | 5.733 | 19660.9 |
274 | 2024-02-29 20:32:35 | veggie | 2 | 82551 | 23 | 3.873 | 21314.5 |
273 | 2024-02-28 03:33:50 | veggie | 2 | 82551 | 23 | 2.690 | 30688.1 |
272 | 2024-02-28 03:33:38 | veggie | 3 | 112716 | 274 | 5.893 | 19127.1 |
271 | 2024-02-27 22:22:52 | veggie | 3 | 112716 | 274 | 9.466 | 11907.5 |
270 | 2024-02-27 22:22:50 | veggie | 1 | 48755 | 3 | 1.720 | 28345.9 |
269 | 2024-02-02 09:27:47 | veggie | 2 | 82551 | 23 | 2.110 | 39123.7 |
268 | 2024-02-02 09:27:39 | veggie | 3 | 112716 | 274 | 4.546 | 24794.5 |
267 | 2024-01-28 22:37:15 | veggie | 2 | 82551 | 23 | 2.123 | 38884.1 |
266 | 2024-01-28 22:37:07 | veggie | 3 | 112716 | 274 | 4.576 | 24632.0 |
265 | 2024-01-26 11:22:48 | veggie | 3 | 112716 | 274 | 5.360 | 21029.1 |
264 | 2024-01-09 21:39:55 | veggie | 2 | 82551 | 23 | 4.626 | 17845.0 |
263 | 2023-12-23 13:03:42 | veggie | 1 | 48755 | 3 | 0.716 | 68093.6 |
262 | 2023-12-11 11:45:47 | veggie | 2 | 82551 | 23 | 2.310 | 35736.4 |
261 | 2023-11-25 02:48:15 | veggie | 1 | 48755 | 3 | 0.766 | 63648.8 |
260 | 2023-11-20 09:09:26 | veggie | 2 | 82551 | 23 | 2.220 | 37185.1 |
259 | 2023-11-19 20:58:58 | veggie | 1 | 48755 | 3 | 0.810 | 60191.4 |
258 | 2023-11-15 03:10:11 | veggie | 3 | 112716 | 274 | 4.516 | 24959.3 |
257 | 2023-11-11 11:18:06 | veggie | 3 | 112716 | 274 | 5.343 | 21096.0 |
256 | 2023-11-10 18:55:34 | veggie | 1 | 48755 | 3 | 0.856 | 56956.8 |
255 | 2023-11-07 21:29:22 | veggie | 3 | 112716 | 274 | 5.296 | 21283.2 |
254 | 2023-10-22 14:23:38 | veggie | 1 | 48755 | 3 | 0.810 | 60191.4 |
253 | 2023-10-17 13:31:58 | veggie | 1 | 48755 | 3 | 0.736 | 66243.2 |
252 | 2023-10-13 17:13:50 | veggie | 1 | 48755 | 3 | 0.750 | 65006.7 |
251 | 2023-10-10 02:25:12 | veggie | 1 | 48755 | 3 | 0.813 | 59969.2 |
250 | 2023-10-07 02:37:14 | veggie | 1 | 48755 | 3 | 1.483 | 32875.9 |
249 | 2023-09-26 21:24:14 | veggie | 1 | 48755 | 3 | 0.843 | 57835.1 |
248 | 2023-09-14 09:52:21 | veggie | 1 | 48755 | 3 | 0.843 | 57835.1 |
247 | 2023-08-20 07:01:19 | veggie | 2 | 82551 | 23 | 2.423 | 34069.7 |
246 | 2023-08-10 16:44:45 | veggie | 3 | 112716 | 274 | 4.560 | 24718.4 |
245 | 2023-08-06 01:23:29 | veggie | 1 | 48755 | 3 | 0.720 | 67715.3 |
244 | 2023-05-05 21:54:58 | veggie | 2 | 82551 | 23 | 2.110 | 39123.7 |
243 | 2023-05-03 02:33:18 | veggie | 1 | 48755 | 3 | 1.483 | 32875.9 |
242 | 2023-04-23 10:16:02 | veggie | 3 | 112716 | 274 | 4.470 | 25216.1 |
241 | 2023-02-25 06:50:41 | veggie | 1 | 48755 | 3 | 0.720 | 67715.3 |
240 | 2023-02-13 21:25:34 | veggie | 2 | 82551 | 23 | 2.046 | 40347.5 |
239 | 2023-01-28 11:19:23 | veggie | 3 | 112716 | 274 | 4.440 | 25386.5 |
238 | 2022-12-23 15:12:18 | veggie | 1 | 48755 | 3 | 0.720 | 67715.3 |
237 | 2022-12-05 17:44:25 | veggie | 3 | 112716 | 274 | 5.343 | 21096.0 |
236 | 2022-11-25 06:47:22 | veggie | 2 | 82551 | 23 | 2.063 | 40015.0 |
235 | 2022-11-10 19:38:56 | veggie | 3 | 112716 | 274 | 4.436 | 25409.4 |
234 | 2022-09-19 08:22:20 | veggie | 1 | 48755 | 3 | 0.843 | 57835.1 |
233 | 2022-09-06 08:22:44 | veggie | 1 | 48755 | 3 | 0.703 | 69352.8 |
232 | 2022-08-15 09:11:25 | veggie | 1 | 48755 | 3 | 0.813 | 59969.2 |
231 | 2022-08-14 14:30:47 | veggie | 1 | 48755 | 3 | 0.716 | 68093.6 |
230 | 2022-08-14 01:56:34 | veggie | 1 | 48755 | 3 | 0.720 | 67715.3 |
229 | 2022-07-28 21:30:09 | veggie | 1 | 48755 | 3 | 0.813 | 59969.2 |
228 | 2022-06-01 15:24:11 | veggie | 3 | 112716 | 274 | 4.673 | 24120.7 |
227 | 2022-04-24 02:53:11 | veggie | 2 | 82551 | 23 | 2.093 | 39441.5 |
226 | 2022-04-19 14:07:42 | veggie | 1 | 48755 | 3 | 1.093 | 44606.6 |
225 | 2022-01-17 11:31:34 | veggie | 1 | 48755 | 3 | 0.813 | 59969.2 |
224 | 2022-01-15 08:38:43 | veggie | 1 | 48755 | 3 | 0.800 | 60943.8 |
223 | 2021-11-13 06:01:14 | veggie | 1 | 48755 | 3 | 0.860 | 56691.9 |
222 | 2021-11-11 04:14:02 | veggie | 1 | 48755 | 3 | 0.716 | 68093.6 |
221 | 2021-11-03 12:38:31 | veggie | 1 | 48755 | 3 | 0.750 | 65006.7 |
220 | 2021-10-13 11:13:48 | veggie | 1 | 48755 | 3 | 0.796 | 61250.0 |
219 | 2021-09-28 11:41:51 | veggie | 1 | 48755 | 3 | 1.673 | 29142.3 |
218 | 2021-09-27 11:48:36 | veggie | 1 | 48755 | 3 | 0.750 | 65006.7 |
217 | 2021-09-23 14:55:48 | veggie | 1 | 48755 | 3 | 1.280 | 38089.8 |
216 | 2021-05-25 10:14:55 | veggie | 1 | 48755 | 3 | 0.830 | 58741.0 |
215 | 2021-04-28 22:12:45 | veggie | 1 | 48755 | 3 | 0.733 | 66514.3 |
214 | 2021-03-23 21:46:21 | veggie | 1 | 48755 | 3 | 0.876 | 55656.4 |
213 | 2021-02-06 18:39:45 | veggie | 1 | 48755 | 3 | 0.736 | 66243.2 |
212 | 2021-02-02 06:59:08 | veggie | 1 | 48755 | 3 | 0.813 | 59969.2 |
211 | 2021-01-12 01:02:58 | veggie | 1 | 48755 | 3 | 0.733 | 66514.3 |
210 | 2021-01-06 02:45:55 | veggie | 1 | 48755 | 3 | 0.750 | 65006.7 |
209 | 2020-12-08 16:18:40 | veggie | 1 | 48755 | 3 | 0.796 | 61250.0 |
208 | 2020-10-25 00:34:58 | veggie | 1 | 48755 | 3 | 0.720 | 67715.3 |
207 | 2020-08-12 03:50:21 | veggie | 1 | 48755 | 3 | 0.876 | 55656.4 |
206 | 2020-08-09 15:12:50 | veggie | 1 | 48755 | 3 | 0.733 | 66514.3 |
205 | 2020-08-09 05:59:16 | veggie | 1 | 48755 | 3 | 0.736 | 66243.2 |
204 | 2020-04-20 12:17:30 | veggie | 1 | 48755 | 3 | 0.733 | 66514.3 |
203 | 2020-04-03 03:24:02 | veggie | 1 | 48755 | 3 | 0.813 | 59969.2 |
202 | 2020-03-27 19:32:09 | veggie | 1 | 48755 | 3 | 0.876 | 55656.4 |
201 | 2020-03-26 07:56:02 | veggie | 1 | 48755 | 3 | 0.856 | 56956.8 |
200 | 2020-03-24 07:15:59 | veggie | 1 | 48755 | 3 | 0.856 | 56956.8 |
199 | 2020-03-23 17:19:29 | veggie | 1 | 48755 | 3 | 0.796 | 61250.0 |
198 | 2020-03-18 16:30:16 | veggie | 1 | 48755 | 3 | 0.783 | 62266.9 |
197 | 2020-02-28 14:14:54 | veggie | 1 | 48755 | 3 | 0.873 | 55847.7 |
196 | 2020-02-22 13:28:43 | veggie | 1 | 48755 | 3 | 0.983 | 49598.2 |
195 | 2020-02-14 11:51:24 | veggie | 1 | 48755 | 3 | 0.986 | 49447.3 |