History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"photophores"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
349 | 2024-04-26 22:18:20 | photophores | 5 | 164607 | 418 | 14.110 | 11666.0 |
348 | 2024-04-25 03:37:48 | photophores | 4 | 148819 | 87 | 19.706 | 7552.0 |
347 | 2024-04-24 01:45:00 | photophores | 5 | 164607 | 418 | 60.113 | 2738.3 |
346 | 2024-04-23 05:56:47 | photophores | 4 | 148819 | 87 | 17.986 | 8274.2 |
345 | 2024-04-22 11:53:49 | photophores | 4 | 148819 | 87 | 38.190 | 3896.8 |
344 | 2024-04-22 00:07:51 | photophores | 5 | 164607 | 418 | 40.986 | 4016.2 |
343 | 2024-04-21 14:31:09 | photophores | 4 | 148819 | 87 | 17.953 | 8289.4 |
342 | 2024-04-21 14:31:07 | photophores | 3 | 121633 | 21 | 18.643 | 6524.3 |
341 | 2024-04-21 14:31:06 | photophores | 2 | 86808 | 5 | 9.470 | 9166.6 |
340 | 2024-04-21 08:54:36 | photophores | 5 | 164607 | 418 | 53.083 | 3100.9 |
339 | 2024-04-21 07:47:47 | photophores | 5 | 164607 | 418 | 38.206 | 4308.4 |
338 | 2024-04-21 07:47:49 | photophores | 4 | 148819 | 87 | 25.423 | 5853.7 |
337 | 2024-04-21 07:47:51 | photophores | 3 | 121633 | 21 | 15.110 | 8049.8 |
336 | 2024-04-21 07:47:51 | photophores | 2 | 86808 | 5 | 8.280 | 10484.1 |
335 | 2024-04-21 07:46:41 | photophores | 1 | 49908 | 2 | 3.516 | 14194.5 |
334 | 2024-04-21 07:46:29 | photophores | 1 | 49908 | 2 | 1.686 | 29601.4 |
333 | 2024-04-17 06:09:09 | photophores | 1 | 49908 | 2 | 2.250 | 22181.3 |
332 | 2024-04-17 06:09:06 | photophores | 1 | 49908 | 2 | 2.560 | 19495.3 |
331 | 2024-04-04 06:34:11 | photophores | 1 | 49908 | 2 | 0.890 | 56076.4 |
330 | 2024-03-29 08:38:31 | photophores | 2 | 86808 | 5 | 5.643 | 15383.3 |
329 | 2024-03-29 08:38:06 | photophores | 1 | 49908 | 2 | 0.906 | 55086.1 |
328 | 2024-03-26 08:50:28 | photophores | 2 | 86808 | 5 | 5.750 | 15097.0 |
327 | 2024-03-26 07:18:19 | photophores | 1 | 49908 | 2 | 0.860 | 58032.6 |
326 | 2024-03-21 23:31:15 | photophores | 4 | 148819 | 87 | 11.563 | 12870.3 |
325 | 2024-03-17 10:49:31 | photophores | 1 | 49908 | 2 | 0.923 | 54071.5 |
324 | 2024-03-17 10:49:09 | photophores | 2 | 86808 | 5 | 2.623 | 33094.9 |
323 | 2024-03-16 09:15:55 | photophores | 3 | 121633 | 21 | 17.563 | 6925.5 |
322 | 2024-03-16 09:16:05 | photophores | 2 | 86808 | 5 | 5.453 | 15919.3 |
321 | 2024-03-16 09:14:39 | photophores | 1 | 49908 | 2 | 1.843 | 27079.8 |
320 | 2024-03-08 05:47:49 | photophores | 4 | 148819 | 87 | 36.173 | 4114.1 |
319 | 2024-03-08 05:47:46 | photophores | 3 | 121633 | 21 | 11.560 | 10521.9 |
318 | 2024-03-08 05:46:32 | photophores | 1 | 49908 | 2 | 0.953 | 52369.4 |
317 | 2024-03-06 01:40:31 | photophores | 4 | 148819 | 87 | 34.660 | 4293.7 |
316 | 2024-03-06 01:38:55 | photophores | 3 | 121633 | 21 | 16.500 | 7371.7 |
315 | 2024-03-04 10:31:57 | photophores | 5 | 164607 | 418 | 37.456 | 4394.7 |
314 | 2024-03-03 23:31:56 | photophores | 5 | 164607 | 418 | 36.630 | 4493.8 |
313 | 2024-03-03 23:31:58 | photophores | 4 | 148819 | 87 | 25.456 | 5846.1 |
312 | 2024-03-03 23:32:02 | photophores | 3 | 121633 | 21 | 16.266 | 7477.7 |
311 | 2024-03-03 23:32:07 | photophores | 2 | 86808 | 5 | 7.826 | 11092.3 |
310 | 2024-03-03 20:47:52 | photophores | 1 | 49908 | 2 | 0.860 | 58032.6 |
309 | 2024-03-03 12:56:15 | photophores | 1 | 49908 | 2 | 0.750 | 66544.0 |
308 | 2024-02-13 21:31:26 | photophores | 2 | 86808 | 5 | 5.876 | 14773.3 |
307 | 2024-02-13 19:04:03 | photophores | 1 | 49908 | 2 | 0.750 | 66544.0 |
306 | 2024-02-13 15:11:25 | photophores | 1 | 49908 | 2 | 2.546 | 19602.5 |
305 | 2024-02-08 23:06:28 | photophores | 4 | 148819 | 87 | 11.546 | 12889.2 |
304 | 2024-02-08 04:02:29 | photophores | 5 | 164607 | 418 | 27.110 | 6071.8 |
303 | 2024-02-05 15:22:58 | photophores | 1 | 49908 | 2 | 0.936 | 53320.5 |
302 | 2024-02-05 14:35:38 | photophores | 1 | 49908 | 2 | 1.860 | 26832.3 |
301 | 2024-02-05 14:23:51 | photophores | 1 | 49908 | 2 | 0.890 | 56076.4 |
300 | 2024-02-04 10:04:15 | photophores | 4 | 148819 | 87 | 11.686 | 12734.8 |
299 | 2024-02-04 09:19:03 | photophores | 5 | 164607 | 418 | 38.250 | 4303.5 |
298 | 2024-02-04 09:18:44 | photophores | 4 | 148819 | 87 | 30.473 | 4883.6 |
297 | 2024-01-27 07:40:35 | photophores | 1 | 49908 | 2 | 1.733 | 28798.6 |
296 | 2024-01-25 03:01:36 | photophores | 3 | 121633 | 21 | 5.236 | 23230.1 |
295 | 2024-01-09 14:04:41 | photophores | 2 | 86808 | 5 | 2.063 | 42078.5 |
294 | 2024-01-06 15:17:17 | photophores | 5 | 164607 | 418 | 16.016 | 10277.7 |
293 | 2024-01-01 09:13:49 | photophores | 1 | 49908 | 2 | 0.860 | 58032.6 |
292 | 2023-12-27 13:49:29 | photophores | 4 | 148819 | 87 | 9.563 | 15562.0 |
291 | 2023-12-27 13:49:30 | photophores | 3 | 121633 | 21 | 5.390 | 22566.4 |
290 | 2023-12-27 13:49:28 | photophores | 2 | 86808 | 5 | 2.236 | 38822.9 |
289 | 2023-12-17 06:03:19 | photophores | 5 | 164607 | 418 | 13.860 | 11876.4 |
288 | 2023-12-12 21:44:12 | photophores | 1 | 49908 | 2 | 0.736 | 67809.8 |
287 | 2023-11-14 15:18:29 | photophores | 5 | 164607 | 418 | 18.813 | 8749.6 |
286 | 2023-11-14 03:08:41 | photophores | 1 | 49908 | 2 | 0.890 | 56076.4 |
285 | 2023-11-14 00:26:23 | photophores | 1 | 49908 | 2 | 0.826 | 60421.3 |
284 | 2023-11-05 05:20:43 | photophores | 3 | 121633 | 21 | 4.330 | 28090.8 |
283 | 2023-11-04 16:36:03 | photophores | 1 | 49908 | 2 | 0.736 | 67809.8 |
282 | 2023-10-28 15:53:22 | photophores | 5 | 164607 | 418 | 33.986 | 4843.4 |
281 | 2023-10-25 02:38:07 | photophores | 1 | 49908 | 2 | 0.796 | 62698.5 |
280 | 2023-10-21 02:06:28 | photophores | 5 | 164607 | 418 | 20.516 | 8023.3 |
279 | 2023-10-18 09:19:33 | photophores | 1 | 49908 | 2 | 0.750 | 66544.0 |
278 | 2023-10-18 09:14:47 | photophores | 5 | 164607 | 418 | 18.843 | 8735.7 |
277 | 2023-10-16 06:56:42 | photophores | 2 | 86808 | 5 | 2.000 | 43404.0 |
276 | 2023-09-23 07:13:19 | photophores | 5 | 164607 | 418 | 13.173 | 12495.8 |
275 | 2023-09-17 19:58:37 | photophores | 5 | 164607 | 418 | 14.110 | 11666.0 |
274 | 2023-08-20 02:39:05 | photophores | 1 | 49908 | 2 | 0.750 | 66544.0 |
273 | 2023-08-09 22:48:13 | photophores | 3 | 121633 | 21 | 4.300 | 28286.7 |
272 | 2023-07-27 07:53:46 | photophores | 2 | 86808 | 5 | 2.200 | 39458.2 |
271 | 2023-07-12 04:42:57 | photophores | 1 | 49908 | 2 | 0.750 | 66544.0 |
270 | 2023-06-22 02:33:04 | photophores | 5 | 164607 | 418 | 13.860 | 11876.4 |
269 | 2023-05-22 10:24:45 | photophores | 1 | 49908 | 2 | 0.720 | 69316.7 |
268 | 2023-04-20 18:27:14 | photophores | 3 | 121633 | 21 | 4.283 | 28399.0 |
267 | 2023-04-07 23:09:27 | photophores | 2 | 86808 | 5 | 2.323 | 37368.9 |
266 | 2023-03-24 16:31:57 | photophores | 5 | 164607 | 418 | 14.313 | 11500.5 |
265 | 2023-03-17 23:24:53 | photophores | 1 | 49908 | 2 | 0.733 | 68087.3 |
264 | 2023-03-17 17:48:50 | photophores | 1 | 49908 | 2 | 0.750 | 66544.0 |
263 | 2023-03-15 15:08:34 | photophores | 5 | 164607 | 418 | 17.536 | 9386.8 |
262 | 2023-03-10 07:45:16 | photophores | 5 | 164607 | 418 | 14.013 | 11746.7 |
261 | 2023-02-25 04:28:09 | photophores | 5 | 164607 | 418 | 16.516 | 9966.5 |
260 | 2023-01-29 03:01:35 | photophores | 5 | 164607 | 418 | 13.393 | 12290.5 |
259 | 2023-01-25 01:40:24 | photophores | 3 | 121633 | 21 | 4.813 | 25271.8 |
258 | 2023-01-12 03:20:58 | photophores | 2 | 86808 | 5 | 4.190 | 20717.9 |
257 | 2023-01-05 14:56:01 | photophores | 1 | 49908 | 2 | 0.733 | 68087.3 |
256 | 2023-01-04 19:59:45 | photophores | 5 | 164607 | 418 | 16.330 | 10080.0 |
255 | 2023-01-04 13:14:45 | photophores | 5 | 164607 | 418 | 13.236 | 12436.3 |
254 | 2022-12-29 11:01:20 | photophores | 2 | 86808 | 5 | 1.986 | 43710.0 |
253 | 2022-12-23 21:01:33 | photophores | 5 | 164607 | 418 | 12.360 | 13317.7 |
252 | 2022-12-19 03:25:34 | photophores | 1 | 49908 | 2 | 0.780 | 63984.6 |
251 | 2022-12-19 01:13:21 | photophores | 5 | 164607 | 418 | 12.440 | 13232.1 |
250 | 2022-12-14 07:03:40 | photophores | 5 | 164607 | 418 | 14.393 | 11436.6 |