History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pathogene"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
313 | 2025-05-11 11:27:15 | pathogene | 1 | 81242 | 5 | 1.453 | 55913.3 |
312 | 2025-05-02 22:17:46 | pathogene | 3 | 148641 | 20 | 20.063 | 7408.7 |
311 | 2025-04-25 22:26:28 | pathogene | 3 | 148641 | 20 | 35.143 | 4229.6 |
310 | 2025-04-25 14:05:07 | pathogene | 1 | 81242 | 5 | 1.530 | 53099.3 |
309 | 2025-04-17 12:27:45 | pathogene | 1 | 81242 | 5 | 1.453 | 55913.3 |
308 | 2025-04-17 12:18:38 | pathogene | 1 | 81242 | 5 | 1.500 | 54161.3 |
307 | 2025-04-04 02:48:26 | pathogene | 1 | 81242 | 5 | 3.470 | 23412.7 |
306 | 2025-03-26 03:15:24 | pathogene | 2 | 121436 | 8 | 16.703 | 7270.3 |
305 | 2025-03-25 14:49:52 | pathogene | 2 | 121436 | 8 | 31.893 | 3807.6 |
304 | 2025-03-25 12:58:11 | pathogene | 3 | 148641 | 20 | 32.876 | 4521.3 |
303 | 2025-03-24 01:57:57 | pathogene | 1 | 81242 | 5 | 1.390 | 58447.5 |
302 | 2025-03-10 13:36:10 | pathogene | 1 | 81242 | 5 | 5.453 | 14898.6 |
301 | 2025-03-03 04:37:19 | pathogene | 3 | 148641 | 20 | 51.610 | 2880.1 |
300 | 2025-02-28 23:59:20 | pathogene | 1 | 81242 | 5 | 10.343 | 7854.8 |
299 | 2025-02-28 15:38:24 | pathogene | 2 | 121436 | 8 | 17.656 | 6877.9 |
298 | 2025-02-28 15:37:57 | pathogene | 3 | 148641 | 20 | 32.736 | 4540.6 |
297 | 2025-02-28 15:35:19 | pathogene | 1 | 81242 | 5 | 5.360 | 15157.1 |
296 | 2025-02-26 07:46:05 | pathogene | 3 | 148641 | 20 | 78.050 | 1904.4 |
295 | 2025-02-18 01:06:02 | pathogene | 2 | 121436 | 8 | 12.486 | 9725.8 |
294 | 2025-02-18 01:05:50 | pathogene | 3 | 148641 | 20 | 18.923 | 7855.0 |
293 | 2025-02-10 22:56:40 | pathogene | 3 | 148641 | 20 | 39.050 | 3806.4 |
292 | 2025-02-06 04:49:30 | pathogene | 3 | 148641 | 20 | 36.656 | 4055.0 |
291 | 2025-02-06 04:49:36 | pathogene | 2 | 121436 | 8 | 28.203 | 4305.8 |
290 | 2025-02-06 04:22:26 | pathogene | 1 | 81242 | 5 | 2.060 | 39437.9 |
289 | 2025-02-05 22:06:16 | pathogene | 1 | 81242 | 5 | 2.453 | 33119.4 |
288 | 2025-01-27 08:55:55 | pathogene | 1 | 81242 | 5 | 6.000 | 13540.3 |
287 | 2025-01-23 05:58:41 | pathogene | 1 | 81242 | 5 | 5.233 | 15524.9 |
286 | 2025-01-16 12:18:35 | pathogene | 3 | 148641 | 20 | 42.596 | 3489.6 |
285 | 2025-01-08 00:35:50 | pathogene | 3 | 148641 | 20 | 43.973 | 3380.3 |
284 | 2025-01-05 03:00:49 | pathogene | 1 | 81242 | 5 | 8.660 | 9381.3 |
283 | 2025-01-03 19:07:36 | pathogene | 1 | 81242 | 5 | 5.780 | 14055.7 |
282 | 2024-12-21 23:36:42 | pathogene | 2 | 121436 | 8 | 17.503 | 6938.0 |
281 | 2024-12-21 23:35:51 | pathogene | 3 | 148641 | 20 | 42.126 | 3528.5 |
280 | 2024-12-16 18:35:55 | pathogene | 1 | 81242 | 5 | 6.873 | 11820.5 |
279 | 2024-12-15 05:19:21 | pathogene | 1 | 81242 | 5 | 9.346 | 8692.7 |
278 | 2024-12-06 02:36:40 | pathogene | 1 | 81242 | 5 | 1.280 | 63470.3 |
277 | 2024-12-05 23:01:44 | pathogene | 4 | 165329 | 140 | 62.953 | 2626.2 |
276 | 2024-12-05 20:42:11 | pathogene | 4 | 165329 | 140 | 79.613 | 2076.7 |
275 | 2024-12-02 15:46:20 | pathogene | 1 | 81242 | 5 | 1.906 | 42624.3 |
274 | 2024-11-16 12:46:02 | pathogene | 1 | 81242 | 5 | 6.560 | 12384.5 |
273 | 2024-11-11 18:39:21 | pathogene | 1 | 81242 | 5 | 8.326 | 9757.6 |
272 | 2024-11-05 05:11:15 | pathogene | 4 | 165329 | 140 | 72.520 | 2279.8 |
271 | 2024-11-05 00:49:28 | pathogene | 4 | 165329 | 140 | 81.000 | 2041.1 |
270 | 2024-11-05 00:49:32 | pathogene | 2 | 121436 | 8 | 12.373 | 9814.6 |
269 | 2024-11-05 00:48:32 | pathogene | 1 | 81242 | 5 | 9.093 | 8934.6 |
268 | 2024-10-31 19:13:54 | pathogene | 3 | 148641 | 20 | 23.720 | 6266.5 |
267 | 2024-10-29 01:47:40 | pathogene | 3 | 148641 | 20 | 58.723 | 2531.2 |
266 | 2024-10-24 04:01:15 | pathogene | 3 | 148641 | 20 | 35.830 | 4148.5 |
265 | 2024-10-19 16:24:58 | pathogene | 1 | 81242 | 5 | 3.610 | 22504.7 |
264 | 2024-10-17 10:24:30 | pathogene | 1 | 81242 | 5 | 4.373 | 18578.1 |
263 | 2024-10-13 04:11:26 | pathogene | 1 | 81242 | 5 | 6.720 | 12089.6 |
262 | 2024-10-02 13:50:51 | pathogene | 3 | 148641 | 20 | 55.973 | 2655.6 |
261 | 2024-10-02 11:42:37 | pathogene | 3 | 148641 | 20 | 71.940 | 2066.2 |
260 | 2024-10-02 11:42:36 | pathogene | 2 | 121436 | 8 | 15.546 | 7811.4 |
259 | 2024-10-02 11:42:02 | pathogene | 1 | 81242 | 5 | 10.440 | 7781.8 |
258 | 2024-09-22 22:36:21 | pathogene | 3 | 148641 | 20 | 68.593 | 2167.0 |
257 | 2024-09-21 00:55:37 | pathogene | 3 | 148641 | 20 | 46.346 | 3207.2 |
256 | 2024-09-19 02:42:56 | pathogene | 3 | 148641 | 20 | 74.036 | 2007.7 |
255 | 2024-09-19 02:43:01 | pathogene | 2 | 121436 | 8 | 28.140 | 4315.4 |
254 | 2024-09-19 02:42:09 | pathogene | 1 | 81242 | 5 | 5.266 | 15427.6 |
253 | 2024-09-15 09:19:25 | pathogene | 1 | 81242 | 5 | 12.110 | 6708.7 |
252 | 2024-08-29 17:23:24 | pathogene | 1 | 81242 | 5 | 8.220 | 9883.5 |
251 | 2024-08-15 06:13:20 | pathogene | 1 | 81242 | 5 | 13.796 | 5888.8 |
250 | 2024-07-25 19:40:24 | pathogene | 1 | 81242 | 5 | 3.686 | 22040.7 |
249 | 2024-07-16 16:10:02 | pathogene | 4 | 165329 | 140 | 28.690 | 5762.6 |
248 | 2024-07-16 09:21:12 | pathogene | 1 | 81242 | 5 | 5.766 | 14089.8 |
247 | 2024-07-15 23:31:42 | pathogene | 2 | 121436 | 8 | 19.843 | 6119.8 |
246 | 2024-07-14 02:18:26 | pathogene | 3 | 148641 | 20 | 26.580 | 5592.2 |
245 | 2024-07-13 09:14:41 | pathogene | 3 | 148641 | 20 | 32.800 | 4531.7 |
244 | 2024-07-13 09:14:39 | pathogene | 2 | 121436 | 8 | 13.593 | 8933.7 |
243 | 2024-07-13 09:09:17 | pathogene | 1 | 81242 | 5 | 7.220 | 11252.4 |
242 | 2024-07-13 07:49:34 | pathogene | 3 | 148641 | 20 | 13.703 | 10847.3 |
241 | 2024-07-13 05:19:15 | pathogene | 2 | 121436 | 8 | 16.330 | 7436.4 |
240 | 2024-07-13 05:19:10 | pathogene | 3 | 148641 | 20 | 19.253 | 7720.4 |
239 | 2024-07-13 05:17:08 | pathogene | 1 | 81242 | 5 | 5.423 | 14981.0 |
238 | 2024-07-13 05:11:52 | pathogene | 4 | 165329 | 140 | 69.736 | 2370.8 |
237 | 2024-07-12 03:41:39 | pathogene | 4 | 165329 | 140 | 64.050 | 2581.2 |
236 | 2024-07-11 02:23:42 | pathogene | 1 | 81242 | 5 | 4.830 | 16820.3 |
235 | 2024-07-10 01:24:49 | pathogene | 4 | 165329 | 140 | 48.673 | 3396.7 |
234 | 2024-07-09 07:00:22 | pathogene | 4 | 165329 | 140 | 65.160 | 2537.3 |
233 | 2024-07-07 04:36:02 | pathogene | 4 | 165329 | 140 | 59.753 | 2766.9 |
232 | 2024-07-06 14:16:05 | pathogene | 1 | 81242 | 5 | 6.643 | 12229.7 |
231 | 2024-07-06 13:47:40 | pathogene | 4 | 165329 | 140 | 52.626 | 3141.6 |
230 | 2024-07-06 13:35:49 | pathogene | 1 | 81242 | 5 | 7.660 | 10606.0 |
229 | 2024-07-06 13:15:47 | pathogene | 1 | 81242 | 5 | 5.376 | 15112.0 |
228 | 2024-07-04 16:35:57 | pathogene | 1 | 81242 | 5 | 4.173 | 19468.5 |
227 | 2024-06-18 08:47:34 | pathogene | 1 | 81242 | 5 | 2.983 | 27235.0 |
226 | 2024-06-09 16:00:12 | pathogene | 1 | 81242 | 5 | 7.343 | 11063.9 |
225 | 2024-06-05 12:53:40 | pathogene | 1 | 81242 | 5 | 6.783 | 11977.3 |
224 | 2024-05-24 17:16:00 | pathogene | 1 | 81242 | 5 | 4.923 | 16502.5 |
223 | 2024-05-16 06:48:44 | pathogene | 1 | 81242 | 5 | 1.420 | 57212.7 |
222 | 2024-05-14 06:25:22 | pathogene | 1 | 81242 | 5 | 1.436 | 56575.2 |
221 | 2024-05-10 03:17:30 | pathogene | 1 | 81242 | 5 | 1.236 | 65729.8 |
220 | 2024-05-04 08:20:00 | pathogene | 1 | 81242 | 5 | 1.560 | 52078.2 |
219 | 2024-05-02 21:00:36 | pathogene | 1 | 81242 | 5 | 1.373 | 59171.2 |
218 | 2024-04-24 13:16:36 | pathogene | 3 | 148641 | 20 | 24.783 | 5997.7 |
217 | 2024-04-21 08:54:27 | pathogene | 2 | 121436 | 8 | 13.983 | 8684.5 |
216 | 2024-04-21 08:54:23 | pathogene | 3 | 148641 | 20 | 17.656 | 8418.7 |
215 | 2024-04-21 08:53:06 | pathogene | 1 | 81242 | 5 | 2.860 | 28406.3 |
214 | 2024-04-18 23:09:16 | pathogene | 1 | 81242 | 5 | 1.466 | 55417.5 |