History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pangene"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
335 | 2024-04-23 17:05:31 | pangene | 1 | 69583 | 4 | 1.283 | 54234.6 |
334 | 2024-03-30 14:53:11 | pangene | 1 | 69583 | 4 | 3.093 | 22496.9 |
333 | 2024-03-29 02:10:41 | pangene | 1 | 69583 | 4 | 1.283 | 54234.6 |
332 | 2024-03-15 07:27:45 | pangene | 2 | 107671 | 16 | 5.203 | 20694.0 |
331 | 2024-03-14 14:05:11 | pangene | 3 | 134027 | 258 | 17.313 | 7741.4 |
330 | 2024-03-13 17:46:43 | pangene | 3 | 134027 | 258 | 16.703 | 8024.1 |
329 | 2024-03-13 17:46:36 | pangene | 1 | 69583 | 4 | 4.216 | 16504.5 |
328 | 2024-03-11 01:32:28 | pangene | 2 | 107671 | 16 | 7.873 | 13676.0 |
327 | 2024-03-10 23:22:38 | pangene | 3 | 134027 | 258 | 8.110 | 16526.1 |
326 | 2024-03-10 20:10:56 | pangene | 2 | 107671 | 16 | 12.800 | 8411.8 |
325 | 2024-03-10 20:10:58 | pangene | 3 | 134027 | 258 | 8.376 | 16001.3 |
324 | 2024-03-05 03:51:07 | pangene | 1 | 69583 | 4 | 2.936 | 23699.9 |
323 | 2024-02-19 15:36:12 | pangene | 1 | 69583 | 4 | 1.423 | 48898.8 |
322 | 2024-02-12 15:24:50 | pangene | 3 | 134027 | 258 | 15.250 | 8788.7 |
321 | 2024-02-12 13:37:57 | pangene | 1 | 69583 | 4 | 1.216 | 57222.9 |
320 | 2024-02-04 17:26:30 | pangene | 3 | 134027 | 258 | 10.016 | 13381.3 |
319 | 2024-02-03 00:50:29 | pangene | 2 | 107671 | 16 | 6.513 | 16531.7 |
318 | 2024-02-03 00:50:25 | pangene | 3 | 134027 | 258 | 10.220 | 13114.2 |
317 | 2024-02-03 00:50:21 | pangene | 1 | 69583 | 4 | 1.220 | 57035.2 |
316 | 2024-01-21 14:38:20 | pangene | 1 | 69583 | 4 | 1.203 | 57841.2 |
315 | 2024-01-07 13:46:35 | pangene | 1 | 69583 | 4 | 1.360 | 51164.0 |
314 | 2024-01-04 08:17:02 | pangene | 1 | 69583 | 4 | 1.203 | 57841.2 |
313 | 2024-01-03 21:25:32 | pangene | 1 | 69583 | 4 | 1.453 | 47889.2 |
312 | 2023-12-30 04:19:45 | pangene | 1 | 69583 | 4 | 1.266 | 54962.9 |
311 | 2023-12-10 06:05:47 | pangene | 1 | 69583 | 4 | 1.250 | 55666.4 |
310 | 2023-12-05 07:28:21 | pangene | 1 | 69583 | 4 | 2.643 | 26327.3 |
309 | 2023-10-24 22:31:28 | pangene | 1 | 69583 | 4 | 1.110 | 62687.4 |
308 | 2023-09-27 02:57:28 | pangene | 1 | 69583 | 4 | 1.703 | 40859.1 |
307 | 2023-08-28 02:42:35 | pangene | 1 | 69583 | 4 | 1.686 | 41271.1 |
306 | 2023-08-19 13:08:34 | pangene | 1 | 69583 | 4 | 1.076 | 64668.2 |
305 | 2023-05-20 11:38:19 | pangene | 1 | 69583 | 4 | 1.186 | 58670.3 |
304 | 2023-05-10 20:06:37 | pangene | 1 | 69583 | 4 | 1.110 | 62687.4 |
303 | 2023-03-13 16:57:47 | pangene | 1 | 69583 | 4 | 1.063 | 65459.1 |
302 | 2023-01-21 08:10:41 | pangene | 1 | 69583 | 4 | 1.236 | 56296.9 |
301 | 2023-01-02 16:58:51 | pangene | 1 | 69583 | 4 | 1.063 | 65459.1 |
300 | 2022-09-26 06:46:55 | pangene | 1 | 69583 | 4 | 1.076 | 64668.2 |
299 | 2022-09-23 16:55:05 | pangene | 1 | 69583 | 4 | 1.096 | 63488.1 |
298 | 2022-05-23 15:18:01 | pangene | 1 | 69583 | 4 | 1.373 | 50679.5 |
297 | 2022-05-20 05:44:46 | pangene | 1 | 69583 | 4 | 1.093 | 63662.4 |
296 | 2022-05-04 15:32:34 | pangene | 1 | 69583 | 4 | 1.393 | 49951.9 |
295 | 2022-01-28 23:51:25 | pangene | 1 | 69583 | 4 | 1.126 | 61796.6 |
294 | 2022-01-23 15:26:50 | pangene | 1 | 69583 | 4 | 1.236 | 56296.9 |
293 | 2021-11-19 03:04:44 | pangene | 1 | 69583 | 4 | 1.266 | 54962.9 |
292 | 2021-11-02 18:07:47 | pangene | 1 | 69583 | 4 | 1.076 | 64668.2 |
291 | 2021-10-31 11:11:11 | pangene | 1 | 69583 | 4 | 1.313 | 52995.4 |
290 | 2021-10-12 05:48:01 | pangene | 1 | 69583 | 4 | 1.233 | 56433.9 |
289 | 2021-10-06 23:10:31 | pangene | 1 | 69583 | 4 | 1.203 | 57841.2 |
288 | 2021-09-02 13:20:14 | pangene | 1 | 69583 | 4 | 1.203 | 57841.2 |
287 | 2021-08-18 06:09:15 | pangene | 1 | 69583 | 4 | 1.110 | 62687.4 |
286 | 2021-07-10 23:57:18 | pangene | 1 | 69583 | 4 | 1.080 | 64428.7 |
285 | 2021-06-07 01:04:00 | pangene | 1 | 69583 | 4 | 1.093 | 63662.4 |
284 | 2021-05-13 00:46:56 | pangene | 1 | 69583 | 4 | 1.250 | 55666.4 |
283 | 2021-04-07 02:38:43 | pangene | 1 | 69583 | 4 | 1.216 | 57222.9 |
282 | 2021-04-02 22:33:45 | pangene | 1 | 69583 | 4 | 1.156 | 60192.9 |
281 | 2021-02-18 19:25:27 | pangene | 1 | 69583 | 4 | 1.123 | 61961.7 |
280 | 2020-12-21 21:59:20 | pangene | 1 | 69583 | 4 | 1.076 | 64668.2 |
279 | 2020-11-30 15:08:22 | pangene | 1 | 69583 | 4 | 1.123 | 61961.7 |
278 | 2020-11-02 04:38:10 | pangene | 1 | 69583 | 4 | 1.266 | 54962.9 |
277 | 2020-10-30 20:03:56 | pangene | 1 | 69583 | 4 | 1.250 | 55666.4 |
276 | 2020-09-17 22:37:00 | pangene | 1 | 69583 | 4 | 1.296 | 53690.6 |
275 | 2020-08-30 01:41:40 | pangene | 1 | 69583 | 4 | 1.156 | 60192.9 |
274 | 2020-08-24 20:55:29 | pangene | 1 | 69583 | 4 | 1.203 | 57841.2 |
273 | 2020-08-13 17:55:51 | pangene | 1 | 69583 | 4 | 1.126 | 61796.6 |
272 | 2020-06-02 02:36:58 | pangene | 1 | 69583 | 4 | 1.296 | 53690.6 |
271 | 2020-04-22 02:24:47 | pangene | 1 | 69583 | 4 | 1.266 | 54962.9 |
270 | 2020-04-18 12:22:33 | pangene | 1 | 69583 | 4 | 1.093 | 63662.4 |
269 | 2020-04-17 13:10:05 | pangene | 1 | 69583 | 4 | 1.093 | 63662.4 |
268 | 2020-04-16 13:08:55 | pangene | 1 | 69583 | 4 | 1.126 | 61796.6 |
267 | 2020-04-15 12:26:19 | pangene | 1 | 69583 | 4 | 1.266 | 54962.9 |
266 | 2020-03-28 05:42:14 | pangene | 1 | 69583 | 4 | 1.296 | 53690.6 |
265 | 2020-03-23 14:30:25 | pangene | 1 | 69583 | 4 | 1.313 | 52995.4 |
264 | 2020-03-23 03:16:22 | pangene | 1 | 69583 | 4 | 1.266 | 54962.9 |
263 | 2020-03-18 21:04:36 | pangene | 1 | 69583 | 4 | 1.233 | 56433.9 |
262 | 2020-02-26 20:06:08 | pangene | 1 | 69583 | 4 | 1.466 | 47464.5 |
261 | 2020-02-26 17:51:26 | pangene | 1 | 69583 | 4 | 1.263 | 55093.4 |
260 | 2020-02-26 16:35:42 | pangene | 1 | 69583 | 4 | 1.313 | 52995.4 |
259 | 2020-02-20 07:44:19 | pangene | 1 | 69583 | 4 | 2.890 | 24077.2 |
258 | 2020-02-10 00:20:07 | pangene | 1 | 69583 | 4 | 2.796 | 24886.6 |
257 | 2020-02-08 04:41:32 | pangene | 1 | 69583 | 4 | 4.313 | 16133.3 |
256 | 2020-02-05 13:48:46 | pangene | 1 | 69583 | 4 | 2.686 | 25905.8 |
255 | 2020-02-03 20:27:53 | pangene | 1 | 69583 | 4 | 2.843 | 24475.2 |
254 | 2020-01-29 06:59:20 | pangene | 1 | 69583 | 4 | 2.873 | 24219.6 |
253 | 2020-01-24 13:37:49 | pangene | 1 | 69583 | 4 | 2.296 | 30306.2 |
252 | 2020-01-17 08:15:16 | pangene | 1 | 69583 | 4 | 1.373 | 50679.5 |
251 | 2020-01-16 01:30:16 | pangene | 1 | 69583 | 4 | 1.736 | 40082.4 |
250 | 2020-01-12 20:51:16 | pangene | 1 | 69583 | 4 | 1.250 | 55666.4 |
249 | 2020-01-12 19:55:05 | pangene | 1 | 69583 | 4 | 1.420 | 49002.1 |
248 | 2020-01-08 01:08:22 | pangene | 1 | 69583 | 4 | 1.360 | 51164.0 |
247 | 2019-12-29 19:24:24 | pangene | 1 | 69583 | 4 | 1.390 | 50059.7 |
246 | 2019-12-27 02:31:46 | pangene | 1 | 69583 | 4 | 1.263 | 55093.4 |
245 | 2019-12-27 01:47:52 | pangene | 1 | 69583 | 4 | 1.346 | 51696.1 |
244 | 2019-12-26 21:46:25 | pangene | 1 | 69583 | 4 | 1.300 | 53525.4 |
243 | 2019-11-24 20:12:16 | pangene | 1 | 69583 | 4 | 1.093 | 63662.4 |
242 | 2019-08-26 01:53:56 | pangene | 1 | 69583 | 4 | 1.246 | 55845.1 |
241 | 2019-07-25 09:22:50 | pangene | 1 | 69583 | 4 | 1.063 | 65459.1 |
240 | 2019-06-27 04:19:31 | pangene | 1 | 69583 | 4 | 1.323 | 52594.9 |
239 | 2019-05-26 09:43:05 | pangene | 1 | 69583 | 4 | 1.190 | 58473.1 |
238 | 2019-03-06 18:23:51 | pangene | 1 | 69583 | 4 | 1.053 | 66080.7 |
237 | 2019-02-17 03:30:09 | pangene | 1 | 69583 | 4 | 1.226 | 56756.1 |
236 | 2019-02-10 07:20:51 | pangene | 1 | 69583 | 4 | 1.043 | 66714.3 |