History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"entrances"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
318 | 2024-04-26 02:16:25 | entrances | 1 | 81242 | 3 | 2.780 | 29223.7 |
317 | 2024-04-13 01:07:29 | entrances | 1 | 81242 | 3 | 1.453 | 55913.3 |
316 | 2024-04-12 23:41:52 | entrances | 1 | 81242 | 3 | 1.423 | 57092.1 |
315 | 2024-04-09 23:43:27 | entrances | 1 | 81242 | 3 | 3.360 | 24179.2 |
314 | 2024-04-05 21:31:00 | entrances | 1 | 81242 | 3 | 1.390 | 58447.5 |
313 | 2024-04-05 01:57:27 | entrances | 1 | 81242 | 3 | 1.623 | 50056.7 |
312 | 2024-03-30 03:05:11 | entrances | 1 | 81242 | 3 | 1.420 | 57212.7 |
311 | 2024-03-23 07:59:20 | entrances | 1 | 81242 | 3 | 2.076 | 39133.9 |
310 | 2024-03-09 08:48:47 | entrances | 2 | 121436 | 12 | 3.050 | 39815.1 |
309 | 2024-03-07 08:05:43 | entrances | 1 | 81242 | 3 | 1.750 | 46424.0 |
308 | 2024-03-06 17:24:06 | entrances | 3 | 148641 | 110 | 20.986 | 7082.9 |
307 | 2024-03-06 17:24:06 | entrances | 2 | 121436 | 12 | 11.830 | 10265.1 |
306 | 2024-03-06 16:04:45 | entrances | 1 | 81242 | 3 | 1.610 | 50460.9 |
305 | 2024-03-06 08:39:34 | entrances | 3 | 148641 | 110 | 20.080 | 7402.4 |
304 | 2024-03-05 22:11:21 | entrances | 3 | 148641 | 110 | 26.800 | 5546.3 |
303 | 2024-03-05 22:11:22 | entrances | 2 | 121436 | 12 | 12.796 | 9490.2 |
302 | 2024-03-05 21:54:58 | entrances | 1 | 81242 | 3 | 4.810 | 16890.2 |
301 | 2024-03-01 23:18:41 | entrances | 1 | 81242 | 3 | 1.533 | 52995.4 |
300 | 2024-02-22 11:44:25 | entrances | 2 | 121436 | 12 | 8.346 | 14550.2 |
299 | 2024-02-22 03:27:47 | entrances | 1 | 81242 | 3 | 3.076 | 26411.6 |
298 | 2024-01-29 22:47:54 | entrances | 1 | 81242 | 3 | 2.923 | 27794.0 |
297 | 2024-01-25 04:44:10 | entrances | 3 | 148641 | 110 | 7.030 | 21143.8 |
296 | 2023-12-30 12:43:16 | entrances | 1 | 81242 | 3 | 1.500 | 54161.3 |
295 | 2023-12-29 12:06:46 | entrances | 1 | 81242 | 3 | 1.406 | 57782.4 |
294 | 2023-12-27 07:09:51 | entrances | 1 | 81242 | 3 | 1.313 | 61875.1 |
293 | 2023-12-17 21:17:07 | entrances | 1 | 81242 | 3 | 1.436 | 56575.2 |
292 | 2023-12-08 12:44:34 | entrances | 1 | 81242 | 3 | 1.216 | 66810.9 |
291 | 2023-12-06 19:46:46 | entrances | 3 | 148641 | 110 | 7.936 | 18730.0 |
290 | 2023-11-30 09:39:22 | entrances | 2 | 121436 | 12 | 3.170 | 38307.9 |
289 | 2023-11-10 19:44:55 | entrances | 1 | 81242 | 3 | 1.216 | 66810.9 |
288 | 2023-11-06 02:45:32 | entrances | 3 | 148641 | 110 | 6.250 | 23782.6 |
287 | 2023-10-17 03:33:00 | entrances | 1 | 81242 | 3 | 1.406 | 57782.4 |
286 | 2023-10-11 15:14:47 | entrances | 1 | 81242 | 3 | 1.390 | 58447.5 |
285 | 2023-09-14 00:02:18 | entrances | 1 | 81242 | 3 | 1.356 | 59913.0 |
284 | 2023-08-30 01:14:17 | entrances | 2 | 121436 | 12 | 3.046 | 39867.4 |
283 | 2023-08-28 10:54:27 | entrances | 1 | 81242 | 3 | 1.266 | 64172.2 |
282 | 2023-08-11 20:38:04 | entrances | 1 | 81242 | 3 | 2.423 | 33529.5 |
281 | 2023-08-11 07:09:24 | entrances | 3 | 148641 | 110 | 6.156 | 24145.7 |
280 | 2023-05-18 07:08:22 | entrances | 1 | 81242 | 3 | 1.360 | 59736.8 |
279 | 2023-05-16 10:49:15 | entrances | 2 | 121436 | 12 | 3.170 | 38307.9 |
278 | 2023-05-12 18:25:27 | entrances | 1 | 81242 | 3 | 1.220 | 66591.8 |
277 | 2023-04-23 23:42:45 | entrances | 3 | 148641 | 110 | 6.186 | 24028.6 |
276 | 2023-03-08 23:02:56 | entrances | 1 | 81242 | 3 | 1.423 | 57092.1 |
275 | 2023-02-24 05:04:30 | entrances | 2 | 121436 | 12 | 3.406 | 35653.6 |
274 | 2023-02-04 20:30:17 | entrances | 1 | 81242 | 3 | 1.390 | 58447.5 |
273 | 2023-01-28 19:05:22 | entrances | 3 | 148641 | 110 | 6.126 | 24264.0 |
272 | 2023-01-14 23:34:54 | entrances | 2 | 121436 | 12 | 3.203 | 37913.2 |
271 | 2022-12-30 07:52:30 | entrances | 1 | 81242 | 3 | 1.220 | 66591.8 |
270 | 2022-12-05 12:28:04 | entrances | 2 | 121436 | 12 | 3.436 | 35342.3 |
269 | 2022-12-04 17:48:12 | entrances | 2 | 121436 | 12 | 2.986 | 40668.5 |
268 | 2022-11-25 22:13:45 | entrances | 3 | 148641 | 110 | 7.310 | 20333.9 |
267 | 2022-11-11 01:31:01 | entrances | 3 | 148641 | 110 | 6.203 | 23962.8 |
266 | 2022-11-09 16:21:24 | entrances | 2 | 121436 | 12 | 3.703 | 32794.0 |
265 | 2022-10-22 04:11:04 | entrances | 3 | 148641 | 110 | 6.720 | 22119.2 |
264 | 2022-10-22 02:09:08 | entrances | 1 | 81242 | 3 | 1.233 | 65889.7 |
263 | 2022-09-17 09:40:38 | entrances | 1 | 81242 | 3 | 1.326 | 61268.5 |
262 | 2022-07-22 11:25:09 | entrances | 2 | 121436 | 12 | 3.233 | 37561.4 |
261 | 2022-07-02 03:45:31 | entrances | 1 | 81242 | 3 | 1.203 | 67532.8 |
260 | 2022-05-27 14:50:49 | entrances | 3 | 148641 | 110 | 6.186 | 24028.6 |
259 | 2022-05-01 12:35:34 | entrances | 1 | 81242 | 3 | 1.360 | 59736.8 |
258 | 2022-03-15 03:31:03 | entrances | 1 | 81242 | 3 | 1.720 | 47233.7 |
257 | 2022-01-27 00:47:17 | entrances | 1 | 81242 | 3 | 1.546 | 52549.8 |
256 | 2021-12-16 20:26:51 | entrances | 1 | 81242 | 3 | 1.436 | 56575.2 |
255 | 2021-12-04 20:04:53 | entrances | 1 | 81242 | 3 | 1.220 | 66591.8 |
254 | 2021-11-20 07:43:20 | entrances | 1 | 81242 | 3 | 2.610 | 31127.2 |
253 | 2021-11-11 11:37:51 | entrances | 1 | 81242 | 3 | 1.436 | 56575.2 |
252 | 2021-10-14 12:50:20 | entrances | 1 | 81242 | 3 | 1.390 | 58447.5 |
251 | 2021-10-13 16:04:40 | entrances | 1 | 81242 | 3 | 1.216 | 66810.9 |
250 | 2021-10-12 08:37:15 | entrances | 1 | 81242 | 3 | 1.390 | 58447.5 |
249 | 2021-10-11 11:30:48 | entrances | 1 | 81242 | 3 | 1.390 | 58447.5 |
248 | 2021-10-10 08:28:56 | entrances | 1 | 81242 | 3 | 1.356 | 59913.0 |
247 | 2021-10-06 01:42:37 | entrances | 1 | 81242 | 3 | 1.406 | 57782.4 |
246 | 2021-09-29 19:44:12 | entrances | 2 | 121436 | 12 | 3.156 | 38477.8 |
245 | 2021-09-21 14:47:56 | entrances | 1 | 81242 | 3 | 1.220 | 66591.8 |
244 | 2021-09-21 01:53:46 | entrances | 2 | 121436 | 12 | 3.343 | 36325.5 |
243 | 2021-09-20 12:29:56 | entrances | 1 | 81242 | 3 | 1.390 | 58447.5 |
242 | 2021-09-14 04:06:15 | entrances | 1 | 81242 | 3 | 1.220 | 66591.8 |
241 | 2021-08-30 09:48:35 | entrances | 1 | 81242 | 3 | 1.250 | 64993.6 |
240 | 2021-08-28 10:21:10 | entrances | 1 | 81242 | 3 | 1.236 | 65729.8 |
239 | 2021-08-28 04:26:23 | entrances | 1 | 81242 | 3 | 1.283 | 63321.9 |
238 | 2021-06-21 06:24:20 | entrances | 3 | 148641 | 110 | 7.173 | 20722.3 |
237 | 2021-05-27 16:21:45 | entrances | 1 | 81242 | 3 | 1.376 | 59042.2 |
236 | 2021-05-18 12:29:33 | entrances | 1 | 81242 | 3 | 1.346 | 60358.1 |
235 | 2021-05-17 15:10:24 | entrances | 1 | 81242 | 3 | 1.263 | 64324.6 |
234 | 2021-05-17 00:17:03 | entrances | 1 | 81242 | 3 | 1.236 | 65729.8 |
233 | 2021-05-16 09:56:33 | entrances | 1 | 81242 | 3 | 1.356 | 59913.0 |
232 | 2021-05-07 04:22:45 | entrances | 1 | 81242 | 3 | 1.453 | 55913.3 |
231 | 2021-04-03 10:25:37 | entrances | 3 | 148641 | 110 | 6.810 | 21826.9 |
230 | 2021-04-01 18:01:13 | entrances | 3 | 148641 | 110 | 6.953 | 21378.0 |
229 | 2021-03-06 08:19:50 | entrances | 3 | 148641 | 110 | 6.236 | 23836.0 |
228 | 2021-02-24 11:35:17 | entrances | 1 | 81242 | 3 | 1.296 | 62686.7 |
227 | 2021-02-22 10:02:17 | entrances | 1 | 81242 | 3 | 1.360 | 59736.8 |
226 | 2021-02-14 04:58:57 | entrances | 1 | 81242 | 3 | 1.343 | 60492.9 |
225 | 2021-02-10 23:07:40 | entrances | 1 | 81242 | 3 | 1.376 | 59042.2 |
224 | 2021-02-08 08:28:39 | entrances | 1 | 81242 | 3 | 1.250 | 64993.6 |
223 | 2021-02-07 15:35:52 | entrances | 1 | 81242 | 3 | 1.233 | 65889.7 |
222 | 2021-02-06 11:15:12 | entrances | 1 | 81242 | 3 | 1.266 | 64172.2 |
221 | 2021-02-02 16:10:45 | entrances | 1 | 81242 | 3 | 1.373 | 59171.2 |
220 | 2021-02-02 00:28:24 | entrances | 1 | 81242 | 3 | 1.423 | 57092.1 |
219 | 2021-01-31 21:04:58 | entrances | 1 | 81242 | 3 | 1.360 | 59736.8 |