History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prowled"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 325 | 2024-03-31 16:23:53 | prowled | 1 | 69583 | 3 | 5.673 | 12265.6 |
| 324 | 2024-03-31 15:59:46 | prowled | 2 | 107671 | 63 | 7.486 | 14383.0 |
| 323 | 2024-03-31 12:49:16 | prowled | 2 | 107671 | 63 | 9.703 | 11096.7 |
| 322 | 2024-03-30 03:33:15 | prowled | 3 | 134027 | 537 | 18.050 | 7425.3 |
| 321 | 2024-03-30 01:33:51 | prowled | 2 | 107671 | 63 | 16.033 | 6715.6 |
| 320 | 2024-03-30 01:33:52 | prowled | 3 | 134027 | 537 | 10.516 | 12745.1 |
| 319 | 2024-03-30 01:33:45 | prowled | 1 | 69583 | 3 | 1.670 | 41666.5 |
| 318 | 2024-03-28 13:04:39 | prowled | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 317 | 2024-02-29 03:50:44 | prowled | 1 | 69583 | 3 | 2.593 | 26834.9 |
| 316 | 2023-12-20 01:51:07 | prowled | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 315 | 2023-12-17 20:18:51 | prowled | 3 | 134027 | 537 | 7.093 | 18895.7 |
| 314 | 2023-12-17 20:18:50 | prowled | 2 | 107671 | 63 | 3.436 | 31336.1 |
| 313 | 2023-12-10 12:16:57 | prowled | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 312 | 2023-12-07 01:43:12 | prowled | 2 | 107671 | 63 | 2.936 | 36672.7 |
| 311 | 2023-12-06 15:29:45 | prowled | 3 | 134027 | 537 | 7.156 | 18729.3 |
| 310 | 2023-11-16 10:06:20 | prowled | 3 | 134027 | 537 | 5.750 | 23309.0 |
| 309 | 2023-11-10 14:32:57 | prowled | 3 | 134027 | 537 | 6.016 | 22278.4 |
| 308 | 2023-11-10 14:32:49 | prowled | 2 | 107671 | 63 | 2.826 | 38100.1 |
| 307 | 2023-11-08 01:12:50 | prowled | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 306 | 2023-10-29 08:01:33 | prowled | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 305 | 2023-10-25 14:29:08 | prowled | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 304 | 2023-10-14 03:14:06 | prowled | 1 | 69583 | 3 | 2.376 | 29285.8 |
| 303 | 2023-10-07 04:59:05 | prowled | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 302 | 2023-09-29 19:02:44 | prowled | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 301 | 2023-09-24 21:07:07 | prowled | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 300 | 2023-08-03 03:23:26 | prowled | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 299 | 2023-06-13 18:54:36 | prowled | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 298 | 2023-05-01 08:59:26 | prowled | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 297 | 2023-02-20 06:06:07 | prowled | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 296 | 2023-02-19 01:54:45 | prowled | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 295 | 2022-12-18 09:40:39 | prowled | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 294 | 2022-10-22 05:02:08 | prowled | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 293 | 2022-08-28 18:40:10 | prowled | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 292 | 2022-06-20 19:29:02 | prowled | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 291 | 2022-04-11 06:35:41 | prowled | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 290 | 2022-02-12 11:53:39 | prowled | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 289 | 2022-01-13 12:46:19 | prowled | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 288 | 2022-01-11 09:50:02 | prowled | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 287 | 2021-11-13 13:38:21 | prowled | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 286 | 2021-11-11 12:00:28 | prowled | 1 | 69583 | 3 | 1.253 | 55533.1 |
| 285 | 2021-10-25 14:31:32 | prowled | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 284 | 2021-10-01 06:54:31 | prowled | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 283 | 2021-09-29 03:27:13 | prowled | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 282 | 2021-09-19 07:59:38 | prowled | 3 | 134027 | 537 | 6.656 | 20136.3 |
| 281 | 2021-09-12 00:57:33 | prowled | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 280 | 2021-09-09 21:52:52 | prowled | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 279 | 2021-08-11 19:37:06 | prowled | 3 | 134027 | 537 | 6.703 | 19995.1 |
| 278 | 2021-07-18 14:11:30 | prowled | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 277 | 2021-07-14 15:24:27 | prowled | 3 | 134027 | 537 | 6.783 | 19759.3 |
| 276 | 2021-05-19 07:06:40 | prowled | 3 | 134027 | 537 | 6.060 | 22116.7 |
| 275 | 2021-05-12 02:51:27 | prowled | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 274 | 2021-05-03 15:45:20 | prowled | 3 | 134027 | 537 | 7.580 | 17681.7 |
| 273 | 2021-04-26 01:40:09 | prowled | 3 | 134027 | 537 | 6.906 | 19407.3 |
| 272 | 2021-04-15 21:16:32 | prowled | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 271 | 2021-04-12 01:10:13 | prowled | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 270 | 2021-02-24 14:36:54 | prowled | 3 | 134027 | 537 | 6.013 | 22289.5 |
| 269 | 2021-01-31 16:29:03 | prowled | 3 | 134027 | 537 | 6.843 | 19586.0 |
| 268 | 2021-01-25 04:01:27 | prowled | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 267 | 2021-01-16 19:15:22 | prowled | 3 | 134027 | 537 | 6.016 | 22278.4 |
| 266 | 2020-12-26 23:02:46 | prowled | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 265 | 2020-12-17 11:08:17 | prowled | 3 | 134027 | 537 | 6.826 | 19634.8 |
| 264 | 2020-12-11 08:02:57 | prowled | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 263 | 2020-11-18 04:09:27 | prowled | 3 | 134027 | 537 | 5.920 | 22639.7 |
| 262 | 2020-11-12 03:59:38 | prowled | 3 | 134027 | 537 | 6.330 | 21173.3 |
| 261 | 2020-11-10 15:24:16 | prowled | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 260 | 2020-11-04 09:47:18 | prowled | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 259 | 2020-10-27 21:33:23 | prowled | 1 | 69583 | 3 | 3.813 | 18248.9 |
| 258 | 2020-09-20 12:07:33 | prowled | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 257 | 2020-09-04 14:01:30 | prowled | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 256 | 2020-07-31 03:30:03 | prowled | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 255 | 2020-07-19 22:06:07 | prowled | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 254 | 2020-06-19 06:30:44 | prowled | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 253 | 2020-05-30 10:11:33 | prowled | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 252 | 2020-03-25 17:36:40 | prowled | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 251 | 2020-03-25 17:19:28 | prowled | 1 | 69583 | 3 | 2.486 | 27989.9 |
| 250 | 2020-03-22 00:07:39 | prowled | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 249 | 2020-03-17 14:49:19 | prowled | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 248 | 2020-03-02 18:48:10 | prowled | 2 | 107671 | 63 | 3.326 | 32372.5 |
| 247 | 2020-03-01 15:44:30 | prowled | 2 | 107671 | 63 | 3.596 | 29941.9 |
| 246 | 2020-03-01 02:35:25 | prowled | 2 | 107671 | 63 | 3.656 | 29450.5 |
| 245 | 2020-02-29 19:46:22 | prowled | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 244 | 2020-02-27 03:10:22 | prowled | 1 | 69583 | 3 | 3.030 | 22964.7 |
| 243 | 2020-02-26 23:25:45 | prowled | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 242 | 2020-02-17 17:59:02 | prowled | 1 | 69583 | 3 | 2.750 | 25302.9 |
| 241 | 2020-02-14 10:10:56 | prowled | 3 | 134027 | 537 | 16.266 | 8239.7 |
| 240 | 2020-02-07 23:23:37 | prowled | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 239 | 2020-02-07 17:55:01 | prowled | 3 | 134027 | 537 | 10.686 | 12542.3 |
| 238 | 2020-02-07 17:12:32 | prowled | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 237 | 2020-02-07 07:19:30 | prowled | 3 | 134027 | 537 | 10.143 | 13213.7 |
| 236 | 2020-02-07 04:56:52 | prowled | 3 | 134027 | 537 | 14.673 | 9134.3 |
| 235 | 2020-02-06 07:24:23 | prowled | 3 | 134027 | 537 | 6.893 | 19443.9 |
| 234 | 2020-02-06 02:08:06 | prowled | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 233 | 2020-02-05 23:33:32 | prowled | 3 | 134027 | 537 | 16.453 | 8146.1 |
| 232 | 2020-02-05 23:03:46 | prowled | 1 | 69583 | 3 | 4.216 | 16504.5 |
| 231 | 2020-02-05 19:06:12 | prowled | 3 | 134027 | 537 | 20.046 | 6686.0 |
| 230 | 2020-02-03 18:45:02 | prowled | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 229 | 2020-01-30 12:58:09 | prowled | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 228 | 2020-01-25 03:47:58 | prowled | 2 | 107671 | 63 | 7.843 | 13728.3 |
| 227 | 2020-01-24 13:27:17 | prowled | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 226 | 2020-01-16 11:49:53 | prowled | 1 | 69583 | 3 | 1.360 | 51164.0 |