History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prophases"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
339 | 2024-06-05 00:56:41 | prophases | 1 | 81242 | 3 | 3.453 | 23527.9 |
338 | 2024-06-03 12:07:24 | prophases | 1 | 81242 | 3 | 7.763 | 10465.3 |
337 | 2024-05-19 23:23:06 | prophases | 1 | 81242 | 3 | 2.000 | 40621.0 |
336 | 2024-05-10 17:41:24 | prophases | 4 | 165329 | 626 | 59.630 | 2772.6 |
335 | 2024-05-09 11:22:01 | prophases | 4 | 165329 | 626 | 43.830 | 3772.1 |
334 | 2024-05-07 19:30:54 | prophases | 4 | 165329 | 626 | 25.250 | 6547.7 |
333 | 2024-05-07 19:30:46 | prophases | 3 | 148641 | 84 | 20.623 | 7207.5 |
332 | 2024-05-07 14:45:38 | prophases | 4 | 165329 | 626 | 35.520 | 4654.5 |
331 | 2024-05-07 14:45:45 | prophases | 2 | 121436 | 13 | 10.206 | 11898.5 |
330 | 2024-05-07 14:45:40 | prophases | 3 | 148641 | 84 | 8.750 | 16987.5 |
329 | 2024-05-07 11:21:57 | prophases | 1 | 81242 | 3 | 3.060 | 26549.7 |
328 | 2024-05-04 04:57:44 | prophases | 1 | 81242 | 3 | 1.516 | 53589.7 |
327 | 2024-05-03 22:54:19 | prophases | 1 | 81242 | 3 | 1.436 | 56575.2 |
326 | 2024-04-26 15:44:37 | prophases | 1 | 81242 | 3 | 1.436 | 56575.2 |
325 | 2024-04-20 16:58:17 | prophases | 2 | 121436 | 13 | 9.233 | 13152.4 |
324 | 2024-04-20 14:32:57 | prophases | 1 | 81242 | 3 | 1.920 | 42313.5 |
323 | 2024-04-16 12:07:31 | prophases | 2 | 121436 | 13 | 15.656 | 7756.5 |
322 | 2024-04-16 12:07:31 | prophases | 3 | 148641 | 84 | 12.660 | 11741.0 |
321 | 2024-04-16 11:29:37 | prophases | 1 | 81242 | 3 | 1.500 | 54161.3 |
320 | 2024-04-10 12:24:05 | prophases | 2 | 121436 | 13 | 18.736 | 6481.4 |
319 | 2024-04-10 11:47:54 | prophases | 1 | 81242 | 3 | 1.423 | 57092.1 |
318 | 2024-04-08 00:20:06 | prophases | 4 | 165329 | 626 | 43.343 | 3814.4 |
317 | 2024-04-07 10:23:09 | prophases | 4 | 165329 | 626 | 48.193 | 3430.6 |
316 | 2024-04-07 04:42:36 | prophases | 4 | 165329 | 626 | 41.423 | 3991.2 |
315 | 2024-04-04 01:45:04 | prophases | 2 | 121436 | 13 | 6.610 | 18371.6 |
314 | 2024-04-04 01:44:40 | prophases | 3 | 148641 | 84 | 26.863 | 5533.3 |
313 | 2024-04-04 01:44:41 | prophases | 4 | 165329 | 626 | 25.186 | 6564.3 |
312 | 2024-04-04 01:44:36 | prophases | 1 | 81242 | 3 | 1.640 | 49537.8 |
311 | 2024-04-01 05:30:56 | prophases | 1 | 81242 | 3 | 1.563 | 51978.2 |
310 | 2024-03-29 09:27:00 | prophases | 2 | 121436 | 13 | 3.890 | 31217.5 |
309 | 2024-03-18 23:01:33 | prophases | 2 | 121436 | 13 | 11.546 | 10517.6 |
308 | 2024-03-18 21:46:20 | prophases | 1 | 81242 | 3 | 3.016 | 26937.0 |
307 | 2024-03-05 17:22:04 | prophases | 1 | 81242 | 3 | 1.516 | 53589.7 |
306 | 2024-03-04 17:19:48 | prophases | 4 | 165329 | 626 | 15.406 | 10731.5 |
305 | 2024-03-04 10:18:47 | prophases | 4 | 165329 | 626 | 36.533 | 4525.5 |
304 | 2024-03-04 10:18:48 | prophases | 2 | 121436 | 13 | 17.283 | 7026.3 |
303 | 2024-03-04 10:18:45 | prophases | 3 | 148641 | 84 | 19.423 | 7652.8 |
302 | 2024-03-04 09:55:53 | prophases | 1 | 81242 | 3 | 4.890 | 16613.9 |
301 | 2024-03-02 02:05:59 | prophases | 1 | 81242 | 3 | 1.530 | 53099.3 |
300 | 2024-02-17 03:51:52 | prophases | 2 | 121436 | 13 | 8.813 | 13779.2 |
299 | 2024-02-17 01:07:38 | prophases | 1 | 81242 | 3 | 1.546 | 52549.8 |
298 | 2024-02-04 11:16:52 | prophases | 4 | 165329 | 626 | 18.736 | 8824.1 |
297 | 2024-02-04 11:16:18 | prophases | 3 | 148641 | 84 | 18.316 | 8115.4 |
296 | 2024-02-03 05:26:14 | prophases | 4 | 165329 | 626 | 27.470 | 6018.5 |
295 | 2024-02-03 05:26:28 | prophases | 2 | 121436 | 13 | 11.470 | 10587.3 |
294 | 2024-02-03 05:26:21 | prophases | 3 | 148641 | 84 | 8.843 | 16808.9 |
293 | 2024-02-02 19:54:40 | prophases | 1 | 81242 | 3 | 1.343 | 60492.9 |
292 | 2024-02-01 18:55:57 | prophases | 1 | 81242 | 3 | 1.266 | 64172.2 |
291 | 2024-01-29 17:18:49 | prophases | 1 | 81242 | 3 | 1.436 | 56575.2 |
290 | 2024-01-26 06:14:59 | prophases | 1 | 81242 | 3 | 2.906 | 27956.6 |
289 | 2024-01-10 19:35:14 | prophases | 1 | 81242 | 3 | 1.266 | 64172.2 |
288 | 2024-01-07 03:27:30 | prophases | 1 | 81242 | 3 | 1.296 | 62686.7 |
287 | 2024-01-03 19:37:40 | prophases | 1 | 81242 | 3 | 1.420 | 57212.7 |
286 | 2023-11-30 15:19:20 | prophases | 2 | 121436 | 13 | 3.780 | 32125.9 |
285 | 2023-11-24 18:33:51 | prophases | 1 | 81242 | 3 | 1.450 | 56029.0 |
284 | 2023-11-03 18:28:58 | prophases | 1 | 81242 | 3 | 1.470 | 55266.7 |
283 | 2023-09-11 04:45:17 | prophases | 1 | 81242 | 3 | 1.280 | 63470.3 |
282 | 2023-09-01 04:06:18 | prophases | 1 | 81242 | 3 | 1.283 | 63321.9 |
281 | 2023-08-29 13:45:31 | prophases | 2 | 121436 | 13 | 3.156 | 38477.8 |
280 | 2023-08-28 20:10:54 | prophases | 1 | 81242 | 3 | 1.326 | 61268.5 |
279 | 2023-06-21 19:26:11 | prophases | 1 | 81242 | 3 | 1.300 | 62493.8 |
278 | 2023-05-13 19:59:40 | prophases | 2 | 121436 | 13 | 3.140 | 38673.9 |
277 | 2023-05-04 09:28:21 | prophases | 1 | 81242 | 3 | 1.250 | 64993.6 |
276 | 2023-04-07 14:59:08 | prophases | 1 | 81242 | 3 | 1.483 | 54782.2 |
275 | 2023-02-20 16:02:44 | prophases | 2 | 121436 | 13 | 3.406 | 35653.6 |
274 | 2023-01-18 09:34:41 | prophases | 1 | 81242 | 3 | 1.343 | 60492.9 |
273 | 2023-01-17 09:01:19 | prophases | 1 | 81242 | 3 | 1.326 | 61268.5 |
272 | 2022-12-01 17:09:50 | prophases | 2 | 121436 | 13 | 3.080 | 39427.3 |
271 | 2022-09-27 01:34:10 | prophases | 1 | 81242 | 3 | 1.250 | 64993.6 |
270 | 2022-05-24 08:42:27 | prophases | 1 | 81242 | 3 | 1.593 | 50999.4 |
269 | 2022-05-20 22:52:24 | prophases | 1 | 81242 | 3 | 1.296 | 62686.7 |
268 | 2022-05-17 03:08:44 | prophases | 1 | 81242 | 3 | 1.346 | 60358.1 |
267 | 2022-04-19 07:08:15 | prophases | 2 | 121436 | 13 | 3.126 | 38847.1 |
266 | 2022-02-05 03:09:25 | prophases | 1 | 81242 | 3 | 1.453 | 55913.3 |
265 | 2022-01-26 07:36:39 | prophases | 1 | 81242 | 3 | 1.576 | 51549.5 |
264 | 2021-12-24 16:02:30 | prophases | 2 | 121436 | 13 | 4.093 | 29669.2 |
263 | 2021-12-05 06:29:07 | prophases | 1 | 81242 | 3 | 1.313 | 61875.1 |
262 | 2021-11-24 07:47:44 | prophases | 1 | 81242 | 3 | 1.423 | 57092.1 |
261 | 2021-10-14 16:10:00 | prophases | 1 | 81242 | 3 | 2.766 | 29371.7 |
260 | 2021-10-06 22:54:31 | prophases | 2 | 121436 | 13 | 3.203 | 37913.2 |
259 | 2021-10-06 12:48:56 | prophases | 1 | 81242 | 3 | 1.263 | 64324.6 |
258 | 2021-09-07 22:44:33 | prophases | 4 | 165329 | 626 | 12.470 | 13258.1 |
257 | 2021-09-04 04:50:53 | prophases | 1 | 81242 | 3 | 1.250 | 64993.6 |
256 | 2021-08-29 02:57:59 | prophases | 2 | 121436 | 13 | 3.283 | 36989.3 |
255 | 2021-08-19 19:46:02 | prophases | 1 | 81242 | 3 | 1.343 | 60492.9 |
254 | 2021-08-07 22:04:26 | prophases | 4 | 165329 | 626 | 13.076 | 12643.7 |
253 | 2021-07-28 10:56:29 | prophases | 3 | 148641 | 84 | 12.546 | 11847.7 |
252 | 2021-07-28 05:29:09 | prophases | 4 | 165329 | 626 | 10.513 | 15726.1 |
251 | 2021-07-22 09:52:33 | prophases | 4 | 165329 | 626 | 11.266 | 14675.0 |
250 | 2021-07-06 18:40:00 | prophases | 1 | 81242 | 3 | 1.296 | 62686.7 |
249 | 2021-07-02 12:41:24 | prophases | 2 | 121436 | 13 | 3.920 | 30978.6 |
248 | 2021-06-30 17:56:03 | prophases | 1 | 81242 | 3 | 1.296 | 62686.7 |
247 | 2021-06-12 12:07:15 | prophases | 4 | 165329 | 626 | 12.436 | 13294.4 |
246 | 2021-06-06 03:28:53 | prophases | 4 | 165329 | 626 | 23.453 | 7049.4 |
245 | 2021-05-25 07:35:38 | prophases | 4 | 165329 | 626 | 10.546 | 15676.9 |
244 | 2021-05-20 23:44:36 | prophases | 1 | 81242 | 3 | 1.423 | 57092.1 |
243 | 2021-05-20 04:55:17 | prophases | 4 | 165329 | 626 | 10.546 | 15676.9 |
242 | 2021-05-19 20:22:24 | prophases | 3 | 148641 | 84 | 7.423 | 20024.4 |
241 | 2021-05-15 16:58:29 | prophases | 2 | 121436 | 13 | 3.470 | 34996.0 |
240 | 2021-05-14 03:09:23 | prophases | 1 | 81242 | 3 | 1.546 | 52549.8 |