History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"biopics"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
308 | 2024-05-17 09:13:07 | biopics | 1 | 69583 | 4 | 1.623 | 42873.1 |
307 | 2024-05-03 07:17:55 | biopics | 2 | 107671 | 14 | 7.300 | 14749.5 |
306 | 2024-05-01 23:35:05 | biopics | 1 | 69583 | 4 | 2.796 | 24886.6 |
305 | 2024-05-01 23:35:00 | biopics | 2 | 107671 | 14 | 5.893 | 18271.0 |
304 | 2024-04-30 02:43:37 | biopics | 1 | 69583 | 4 | 4.140 | 16807.5 |
303 | 2024-04-29 23:10:11 | biopics | 1 | 69583 | 4 | 1.046 | 66522.9 |
302 | 2024-04-22 17:52:16 | biopics | 3 | 134027 | 168 | 13.296 | 10080.2 |
301 | 2024-04-20 22:23:35 | biopics | 3 | 134027 | 168 | 15.846 | 8458.1 |
300 | 2024-04-20 06:18:25 | biopics | 2 | 107671 | 14 | 7.360 | 14629.2 |
299 | 2024-04-20 06:18:24 | biopics | 3 | 134027 | 168 | 7.703 | 17399.3 |
298 | 2024-04-20 06:18:19 | biopics | 1 | 69583 | 4 | 1.623 | 42873.1 |
297 | 2024-04-19 13:54:24 | biopics | 3 | 134027 | 168 | 17.750 | 7550.8 |
296 | 2024-04-19 05:12:24 | biopics | 3 | 134027 | 168 | 28.126 | 4765.2 |
295 | 2024-04-02 21:53:56 | biopics | 2 | 107671 | 14 | 2.920 | 36873.6 |
294 | 2024-04-01 18:53:21 | biopics | 1 | 69583 | 4 | 4.046 | 17198.0 |
293 | 2024-04-01 16:48:37 | biopics | 1 | 69583 | 4 | 4.126 | 16864.5 |
292 | 2024-03-29 16:33:10 | biopics | 2 | 107671 | 14 | 3.313 | 32499.5 |
291 | 2024-03-29 16:31:33 | biopics | 3 | 134027 | 168 | 7.456 | 17975.7 |
290 | 2024-03-25 08:55:34 | biopics | 2 | 107671 | 14 | 2.766 | 38926.6 |
289 | 2024-03-25 08:54:50 | biopics | 3 | 134027 | 168 | 7.483 | 17910.9 |
288 | 2024-03-20 19:11:04 | biopics | 3 | 134027 | 168 | 14.000 | 9573.4 |
287 | 2024-03-19 15:42:36 | biopics | 3 | 134027 | 168 | 17.796 | 7531.3 |
286 | 2024-03-18 22:19:01 | biopics | 3 | 134027 | 168 | 21.660 | 6187.8 |
285 | 2024-03-18 22:19:01 | biopics | 2 | 107671 | 14 | 9.736 | 11059.1 |
284 | 2024-03-18 22:18:28 | biopics | 3 | 134027 | 168 | 16.550 | 8098.3 |
283 | 2024-03-18 22:18:44 | biopics | 1 | 69583 | 4 | 1.453 | 47889.2 |
282 | 2024-03-18 22:18:30 | biopics | 2 | 107671 | 14 | 3.826 | 28141.9 |
281 | 2024-03-18 22:18:25 | biopics | 1 | 69583 | 4 | 1.436 | 48456.1 |
280 | 2024-02-29 14:02:51 | biopics | 1 | 69583 | 4 | 1.263 | 55093.4 |
279 | 2024-02-28 14:03:20 | biopics | 1 | 69583 | 4 | 1.283 | 54234.6 |
278 | 2024-02-12 15:17:42 | biopics | 3 | 134027 | 168 | 7.983 | 16789.1 |
277 | 2024-02-12 00:42:17 | biopics | 3 | 134027 | 168 | 25.500 | 5256.0 |
276 | 2024-02-07 21:40:56 | biopics | 2 | 107671 | 14 | 3.346 | 32179.0 |
275 | 2024-02-07 21:40:34 | biopics | 3 | 134027 | 168 | 7.483 | 17910.9 |
274 | 2024-02-07 08:25:35 | biopics | 3 | 134027 | 168 | 6.330 | 21173.3 |
273 | 2024-02-07 08:25:31 | biopics | 2 | 107671 | 14 | 2.936 | 36672.7 |
272 | 2024-02-07 08:25:27 | biopics | 1 | 69583 | 4 | 1.283 | 54234.6 |
271 | 2024-01-07 21:01:03 | biopics | 1 | 69583 | 4 | 1.250 | 55666.4 |
270 | 2024-01-06 07:42:42 | biopics | 1 | 69583 | 4 | 1.190 | 58473.1 |
269 | 2024-01-02 11:00:18 | biopics | 3 | 134027 | 168 | 6.250 | 21444.3 |
268 | 2024-01-02 11:00:15 | biopics | 2 | 107671 | 14 | 3.140 | 34290.1 |
267 | 2023-12-06 12:13:58 | biopics | 2 | 107671 | 14 | 3.406 | 31612.2 |
266 | 2023-11-24 11:37:26 | biopics | 1 | 69583 | 4 | 2.610 | 26660.2 |
265 | 2023-11-19 05:05:15 | biopics | 1 | 69583 | 4 | 1.186 | 58670.3 |
264 | 2023-11-19 04:25:39 | biopics | 1 | 69583 | 4 | 1.076 | 64668.2 |
263 | 2023-11-13 22:47:39 | biopics | 1 | 69583 | 4 | 1.326 | 52475.9 |
262 | 2023-11-09 13:24:25 | biopics | 1 | 69583 | 4 | 1.046 | 66522.9 |
261 | 2023-10-28 18:21:14 | biopics | 1 | 69583 | 4 | 1.250 | 55666.4 |
260 | 2023-09-23 09:16:32 | biopics | 1 | 69583 | 4 | 1.186 | 58670.3 |
259 | 2023-09-03 08:19:50 | biopics | 2 | 107671 | 14 | 3.110 | 34620.9 |
258 | 2023-08-22 12:24:46 | biopics | 1 | 69583 | 4 | 1.190 | 58473.1 |
257 | 2023-08-04 15:24:06 | biopics | 1 | 69583 | 4 | 1.190 | 58473.1 |
256 | 2023-05-21 00:51:46 | biopics | 1 | 69583 | 4 | 1.050 | 66269.5 |
255 | 2023-04-27 03:37:10 | biopics | 1 | 69583 | 4 | 1.046 | 66522.9 |
254 | 2023-03-18 16:53:52 | biopics | 1 | 69583 | 4 | 2.500 | 27833.2 |
253 | 2023-01-22 07:27:35 | biopics | 1 | 69583 | 4 | 1.093 | 63662.4 |
252 | 2023-01-07 18:14:33 | biopics | 1 | 69583 | 4 | 1.030 | 67556.3 |
251 | 2022-12-20 10:59:36 | biopics | 2 | 107671 | 14 | 2.720 | 39584.9 |
250 | 2022-10-04 10:22:15 | biopics | 1 | 69583 | 4 | 1.046 | 66522.9 |
249 | 2022-09-29 17:13:12 | biopics | 1 | 69583 | 4 | 1.063 | 65459.1 |
248 | 2022-06-17 13:37:52 | biopics | 1 | 69583 | 4 | 1.080 | 64428.7 |
247 | 2022-05-17 07:17:22 | biopics | 1 | 69583 | 4 | 1.076 | 64668.2 |
246 | 2022-05-15 02:38:23 | biopics | 1 | 69583 | 4 | 1.200 | 57985.8 |
245 | 2022-04-28 00:12:54 | biopics | 3 | 134027 | 168 | 7.393 | 18128.9 |
244 | 2022-03-02 02:07:30 | biopics | 1 | 69583 | 4 | 1.640 | 42428.7 |
243 | 2022-01-27 13:00:22 | biopics | 1 | 69583 | 4 | 1.140 | 61037.7 |
242 | 2021-12-06 07:12:17 | biopics | 2 | 107671 | 14 | 2.826 | 38100.1 |
241 | 2021-11-20 19:32:48 | biopics | 1 | 69583 | 4 | 1.093 | 63662.4 |
240 | 2021-11-18 09:54:12 | biopics | 1 | 69583 | 4 | 1.250 | 55666.4 |
239 | 2021-10-04 10:21:44 | biopics | 1 | 69583 | 4 | 1.110 | 62687.4 |
238 | 2021-10-02 07:53:22 | biopics | 1 | 69583 | 4 | 2.186 | 31831.2 |
237 | 2021-08-24 09:13:56 | biopics | 1 | 69583 | 4 | 1.123 | 61961.7 |
236 | 2021-08-22 04:15:28 | biopics | 1 | 69583 | 4 | 1.220 | 57035.2 |
235 | 2021-08-15 14:40:41 | biopics | 1 | 69583 | 4 | 1.063 | 65459.1 |
234 | 2021-05-14 23:00:05 | biopics | 1 | 69583 | 4 | 1.280 | 54361.7 |
233 | 2021-05-01 17:41:38 | biopics | 1 | 69583 | 4 | 1.250 | 55666.4 |
232 | 2021-04-28 04:24:00 | biopics | 1 | 69583 | 4 | 1.216 | 57222.9 |
231 | 2021-03-28 01:34:48 | biopics | 1 | 69583 | 4 | 1.080 | 64428.7 |
230 | 2021-02-12 02:52:28 | biopics | 1 | 69583 | 4 | 1.076 | 64668.2 |
229 | 2021-02-07 01:58:47 | biopics | 1 | 69583 | 4 | 1.076 | 64668.2 |
228 | 2021-01-11 09:00:42 | biopics | 1 | 69583 | 4 | 1.076 | 64668.2 |
227 | 2020-11-05 03:18:46 | biopics | 1 | 69583 | 4 | 1.126 | 61796.6 |
226 | 2020-11-03 12:52:05 | biopics | 1 | 69583 | 4 | 1.186 | 58670.3 |
225 | 2020-10-28 19:47:48 | biopics | 1 | 69583 | 4 | 1.173 | 59320.5 |
224 | 2020-10-28 13:36:24 | biopics | 2 | 107671 | 14 | 3.436 | 31336.1 |
223 | 2020-10-13 01:39:08 | biopics | 1 | 69583 | 4 | 1.093 | 63662.4 |
222 | 2020-09-26 09:39:44 | biopics | 1 | 69583 | 4 | 1.080 | 64428.7 |
221 | 2020-08-01 08:01:59 | biopics | 1 | 69583 | 4 | 1.300 | 53525.4 |
220 | 2020-07-31 17:06:54 | biopics | 1 | 69583 | 4 | 1.080 | 64428.7 |
219 | 2020-07-29 22:53:31 | biopics | 1 | 69583 | 4 | 1.953 | 35628.8 |
218 | 2020-04-30 05:04:28 | biopics | 1 | 69583 | 4 | 1.216 | 57222.9 |
217 | 2020-04-29 20:57:24 | biopics | 1 | 69583 | 4 | 1.156 | 60192.9 |
216 | 2020-03-26 06:11:22 | biopics | 1 | 69583 | 4 | 2.516 | 27656.2 |
215 | 2020-03-21 12:59:36 | biopics | 1 | 69583 | 4 | 1.143 | 60877.5 |
214 | 2020-02-23 16:38:40 | biopics | 1 | 69583 | 4 | 2.516 | 27656.2 |
213 | 2020-02-23 09:38:05 | biopics | 1 | 69583 | 4 | 1.156 | 60192.9 |
212 | 2020-02-22 09:35:48 | biopics | 1 | 69583 | 4 | 1.313 | 52995.4 |
211 | 2020-02-21 18:25:55 | biopics | 1 | 69583 | 4 | 1.063 | 65459.1 |
210 | 2020-02-07 17:28:29 | biopics | 1 | 69583 | 4 | 2.110 | 32977.7 |
209 | 2020-02-02 07:16:43 | biopics | 1 | 69583 | 4 | 1.263 | 55093.4 |