History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"giardias"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
357 | 2024-05-03 05:38:32 | giardias | 2 | 121059 | 8 | 7.330 | 16515.6 |
356 | 2024-05-02 12:24:44 | giardias | 1 | 82945 | 2 | 3.860 | 21488.3 |
355 | 2024-05-02 09:57:38 | giardias | 1 | 82945 | 2 | 1.653 | 50178.5 |
354 | 2024-05-02 09:53:27 | giardias | 3 | 146162 | 61 | 21.436 | 6818.5 |
353 | 2024-05-02 09:53:23 | giardias | 2 | 121059 | 8 | 4.953 | 24441.6 |
352 | 2024-05-02 07:51:48 | giardias | 3 | 146162 | 61 | 22.516 | 6491.5 |
351 | 2024-04-30 23:01:55 | giardias | 4 | 161609 | 840 | 15.280 | 10576.5 |
350 | 2024-04-30 19:46:37 | giardias | 4 | 161609 | 840 | 24.390 | 6626.0 |
349 | 2024-04-30 18:03:40 | giardias | 4 | 161609 | 840 | 42.173 | 3832.0 |
348 | 2024-04-30 18:03:45 | giardias | 3 | 146162 | 61 | 20.626 | 7086.3 |
347 | 2024-04-30 18:03:37 | giardias | 2 | 121059 | 8 | 8.750 | 13835.3 |
346 | 2024-04-30 16:46:13 | giardias | 1 | 82945 | 2 | 1.390 | 59672.7 |
345 | 2024-04-28 04:08:31 | giardias | 1 | 82945 | 2 | 1.453 | 57085.3 |
344 | 2024-04-23 02:00:07 | giardias | 1 | 82945 | 2 | 1.576 | 52630.1 |
343 | 2024-04-21 17:45:43 | giardias | 1 | 82945 | 2 | 3.890 | 21322.6 |
342 | 2024-04-11 00:24:32 | giardias | 3 | 146162 | 61 | 13.093 | 11163.4 |
341 | 2024-04-09 20:31:33 | giardias | 4 | 161609 | 840 | 14.263 | 11330.6 |
340 | 2024-04-09 17:20:02 | giardias | 3 | 146162 | 61 | 26.910 | 5431.5 |
339 | 2024-04-08 15:33:39 | giardias | 3 | 146162 | 61 | 7.953 | 18378.2 |
338 | 2024-04-08 15:33:40 | giardias | 1 | 82945 | 2 | 1.673 | 49578.6 |
337 | 2024-04-08 15:33:37 | giardias | 2 | 121059 | 8 | 3.893 | 31096.6 |
336 | 2024-04-03 19:56:04 | giardias | 4 | 161609 | 840 | 50.876 | 3176.5 |
335 | 2024-04-01 08:38:20 | giardias | 1 | 82945 | 2 | 1.656 | 50087.6 |
334 | 2024-04-01 08:37:33 | giardias | 3 | 146162 | 61 | 19.233 | 7599.5 |
333 | 2024-04-01 08:37:37 | giardias | 2 | 121059 | 8 | 8.420 | 14377.6 |
332 | 2024-04-01 08:37:28 | giardias | 1 | 82945 | 2 | 2.280 | 36379.4 |
331 | 2024-04-01 08:37:12 | giardias | 2 | 121059 | 8 | 8.030 | 15075.8 |
330 | 2024-04-01 08:37:11 | giardias | 3 | 146162 | 61 | 8.656 | 16885.6 |
329 | 2024-03-31 07:01:30 | giardias | 4 | 161609 | 840 | 26.796 | 6031.1 |
328 | 2024-03-31 06:11:16 | giardias | 4 | 161609 | 840 | 15.266 | 10586.2 |
327 | 2024-03-31 04:32:03 | giardias | 4 | 161609 | 840 | 41.896 | 3857.4 |
326 | 2024-03-31 04:32:07 | giardias | 2 | 121059 | 8 | 12.736 | 9505.3 |
325 | 2024-03-31 04:32:07 | giardias | 3 | 146162 | 61 | 11.766 | 12422.4 |
324 | 2024-03-31 04:20:45 | giardias | 1 | 82945 | 2 | 1.453 | 57085.3 |
323 | 2024-03-27 07:30:22 | giardias | 1 | 82945 | 2 | 1.420 | 58412.0 |
322 | 2024-03-25 20:10:26 | giardias | 1 | 82945 | 2 | 3.233 | 25655.7 |
321 | 2024-03-07 12:04:10 | giardias | 1 | 82945 | 2 | 4.860 | 17066.9 |
320 | 2024-03-02 07:06:32 | giardias | 3 | 146162 | 61 | 21.203 | 6893.5 |
319 | 2024-03-02 07:06:34 | giardias | 2 | 121059 | 8 | 4.513 | 26824.5 |
318 | 2024-03-02 07:06:05 | giardias | 3 | 146162 | 61 | 24.563 | 5950.5 |
317 | 2024-03-02 07:06:06 | giardias | 2 | 121059 | 8 | 6.076 | 19924.1 |
316 | 2024-02-29 06:01:51 | giardias | 2 | 121059 | 8 | 3.780 | 32026.2 |
315 | 2024-02-29 06:01:15 | giardias | 3 | 146162 | 61 | 11.326 | 12905.0 |
314 | 2024-02-28 23:00:37 | giardias | 4 | 161609 | 840 | 23.436 | 6895.8 |
313 | 2024-02-28 10:54:12 | giardias | 4 | 161609 | 840 | 22.720 | 7113.1 |
312 | 2024-02-28 09:05:09 | giardias | 4 | 161609 | 840 | 29.660 | 5448.7 |
311 | 2024-02-28 09:05:12 | giardias | 2 | 121059 | 8 | 22.063 | 5487.0 |
310 | 2024-02-28 09:05:12 | giardias | 3 | 146162 | 61 | 13.236 | 11042.8 |
309 | 2024-02-28 08:14:49 | giardias | 1 | 82945 | 2 | 1.546 | 53651.4 |
308 | 2024-02-17 20:24:07 | giardias | 3 | 146162 | 61 | 13.640 | 10715.7 |
307 | 2024-02-17 20:24:06 | giardias | 2 | 121059 | 8 | 7.360 | 16448.2 |
306 | 2024-02-17 16:55:52 | giardias | 1 | 82945 | 2 | 2.860 | 29001.7 |
305 | 2024-02-04 16:36:47 | giardias | 4 | 161609 | 840 | 17.626 | 9168.8 |
304 | 2024-02-04 16:25:02 | giardias | 4 | 161609 | 840 | 18.796 | 8598.1 |
303 | 2024-01-30 05:14:53 | giardias | 2 | 121059 | 8 | 3.330 | 36354.1 |
302 | 2024-01-28 08:27:19 | giardias | 2 | 121059 | 8 | 3.500 | 34588.3 |
301 | 2024-01-28 08:26:43 | giardias | 3 | 146162 | 61 | 7.486 | 19524.7 |
300 | 2024-01-26 06:33:17 | giardias | 4 | 161609 | 840 | 13.050 | 12383.8 |
299 | 2024-01-26 06:27:27 | giardias | 4 | 161609 | 840 | 19.190 | 8421.5 |
298 | 2024-01-26 06:26:11 | giardias | 4 | 161609 | 840 | 12.546 | 12881.3 |
297 | 2024-01-26 06:26:07 | giardias | 3 | 146162 | 61 | 7.843 | 18636.0 |
296 | 2024-01-06 19:03:45 | giardias | 1 | 82945 | 2 | 1.250 | 66356.0 |
295 | 2023-12-29 22:17:12 | giardias | 1 | 82945 | 2 | 1.360 | 60989.0 |
294 | 2023-12-26 17:11:39 | giardias | 1 | 82945 | 2 | 1.233 | 67270.9 |
293 | 2023-12-21 14:18:21 | giardias | 1 | 82945 | 2 | 1.423 | 58288.8 |
292 | 2023-12-14 06:09:11 | giardias | 1 | 82945 | 2 | 1.313 | 63172.1 |
291 | 2023-11-02 15:07:31 | giardias | 1 | 82945 | 2 | 1.423 | 58288.8 |
290 | 2023-10-24 09:47:51 | giardias | 1 | 82945 | 2 | 1.326 | 62552.8 |
289 | 2023-10-13 13:07:24 | giardias | 1 | 82945 | 2 | 1.220 | 67987.7 |
288 | 2023-10-08 16:58:47 | giardias | 1 | 82945 | 2 | 1.266 | 65517.4 |
287 | 2023-09-14 09:21:54 | giardias | 1 | 82945 | 2 | 2.703 | 30686.3 |
286 | 2023-08-24 06:13:03 | giardias | 1 | 82945 | 2 | 1.436 | 57761.1 |
285 | 2023-08-03 17:10:23 | giardias | 1 | 82945 | 2 | 1.233 | 67270.9 |
284 | 2023-05-01 03:31:39 | giardias | 1 | 82945 | 2 | 1.263 | 65673.0 |
283 | 2023-04-29 14:47:01 | giardias | 1 | 82945 | 2 | 1.420 | 58412.0 |
282 | 2023-02-22 04:19:45 | giardias | 1 | 82945 | 2 | 1.343 | 61761.0 |
281 | 2023-01-02 08:56:06 | giardias | 1 | 82945 | 2 | 1.220 | 67987.7 |
280 | 2022-12-21 11:14:27 | giardias | 1 | 82945 | 2 | 1.283 | 64649.3 |
279 | 2022-09-08 22:47:55 | giardias | 1 | 82945 | 2 | 1.250 | 66356.0 |
278 | 2022-09-08 01:22:35 | giardias | 1 | 82945 | 2 | 1.216 | 68211.3 |
277 | 2022-05-12 23:18:33 | giardias | 1 | 82945 | 2 | 1.673 | 49578.6 |
276 | 2022-04-13 15:37:13 | giardias | 1 | 82945 | 2 | 1.546 | 53651.4 |
275 | 2022-04-11 10:38:00 | giardias | 1 | 82945 | 2 | 1.296 | 64000.8 |
274 | 2022-01-28 18:02:51 | giardias | 1 | 82945 | 2 | 1.406 | 58993.6 |
273 | 2021-10-08 19:43:31 | giardias | 1 | 82945 | 2 | 1.376 | 60279.8 |
272 | 2021-07-10 15:52:04 | giardias | 1 | 82945 | 2 | 1.263 | 65673.0 |
271 | 2021-04-28 13:44:34 | giardias | 1 | 82945 | 2 | 1.326 | 62552.8 |
270 | 2021-04-06 20:02:28 | giardias | 1 | 82945 | 2 | 1.436 | 57761.1 |
269 | 2021-04-02 16:06:08 | giardias | 1 | 82945 | 2 | 1.376 | 60279.8 |
268 | 2021-03-28 09:34:44 | giardias | 1 | 82945 | 2 | 1.343 | 61761.0 |
267 | 2021-01-11 18:02:54 | giardias | 1 | 82945 | 2 | 1.250 | 66356.0 |
266 | 2020-12-25 08:00:41 | giardias | 1 | 82945 | 2 | 1.250 | 66356.0 |
265 | 2020-11-02 06:36:14 | giardias | 1 | 82945 | 2 | 1.313 | 63172.1 |
264 | 2020-10-24 08:46:49 | giardias | 1 | 82945 | 2 | 1.330 | 62364.7 |
263 | 2020-10-16 18:40:36 | giardias | 1 | 82945 | 2 | 1.423 | 58288.8 |
262 | 2020-10-12 07:28:59 | giardias | 1 | 82945 | 2 | 1.343 | 61761.0 |
261 | 2020-09-21 12:08:32 | giardias | 1 | 82945 | 2 | 1.436 | 57761.1 |
260 | 2020-08-17 09:34:25 | giardias | 1 | 82945 | 2 | 1.266 | 65517.4 |
259 | 2020-06-07 20:06:39 | giardias | 1 | 82945 | 2 | 1.360 | 60989.0 |
258 | 2020-03-26 12:50:50 | giardias | 1 | 82945 | 2 | 1.423 | 58288.8 |