History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"peruser"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 308 | 2024-03-28 20:08:09 | peruser | 1 | 69583 | 5 | 2.016 | 34515.4 |
| 307 | 2024-03-26 20:42:33 | peruser | 1 | 69583 | 5 | 2.796 | 24886.6 |
| 306 | 2024-02-06 04:28:42 | peruser | 2 | 107671 | 34 | 3.046 | 35348.3 |
| 305 | 2024-02-04 12:20:42 | peruser | 3 | 134027 | 413 | 15.093 | 8880.1 |
| 304 | 2024-02-04 12:20:38 | peruser | 2 | 107671 | 34 | 7.406 | 14538.3 |
| 303 | 2024-02-02 04:11:35 | peruser | 2 | 107671 | 34 | 6.110 | 17622.1 |
| 302 | 2024-01-31 12:14:43 | peruser | 2 | 107671 | 34 | 3.500 | 30763.1 |
| 301 | 2024-01-31 12:14:27 | peruser | 3 | 134027 | 413 | 6.206 | 21596.4 |
| 300 | 2024-01-18 13:32:29 | peruser | 3 | 134027 | 413 | 6.970 | 19229.1 |
| 299 | 2024-01-18 13:32:23 | peruser | 2 | 107671 | 34 | 3.486 | 30886.7 |
| 298 | 2024-01-08 22:58:14 | peruser | 3 | 134027 | 413 | 7.516 | 17832.2 |
| 297 | 2023-12-21 10:18:02 | peruser | 2 | 107671 | 34 | 2.953 | 36461.6 |
| 296 | 2023-12-19 04:57:25 | peruser | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 295 | 2023-12-02 21:07:24 | peruser | 3 | 134027 | 413 | 14.296 | 9375.1 |
| 294 | 2023-12-02 21:07:24 | peruser | 2 | 107671 | 34 | 4.296 | 25063.1 |
| 293 | 2023-11-19 04:52:30 | peruser | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 292 | 2023-11-17 02:32:07 | peruser | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 291 | 2023-11-15 03:38:06 | peruser | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 290 | 2023-11-11 19:50:56 | peruser | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 289 | 2023-10-27 21:51:34 | peruser | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 288 | 2023-10-26 12:06:40 | peruser | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 287 | 2023-10-18 08:02:44 | peruser | 1 | 69583 | 5 | 1.436 | 48456.1 |
| 286 | 2023-10-14 08:02:10 | peruser | 1 | 69583 | 5 | 1.483 | 46920.4 |
| 285 | 2023-10-14 00:20:48 | peruser | 3 | 134027 | 413 | 7.126 | 18808.2 |
| 284 | 2023-10-06 11:46:36 | peruser | 1 | 69583 | 5 | 1.410 | 49349.6 |
| 283 | 2023-09-26 22:58:16 | peruser | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 282 | 2023-09-21 08:11:19 | peruser | 2 | 107671 | 34 | 3.296 | 32667.2 |
| 281 | 2023-09-16 00:29:14 | peruser | 1 | 69583 | 5 | 1.376 | 50569.0 |
| 280 | 2023-08-01 23:27:55 | peruser | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 279 | 2023-07-23 19:22:15 | peruser | 3 | 134027 | 413 | 6.876 | 19492.0 |
| 278 | 2023-07-21 03:00:12 | peruser | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 277 | 2023-04-27 16:28:21 | peruser | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 276 | 2023-04-05 02:44:57 | peruser | 3 | 134027 | 413 | 6.030 | 22226.7 |
| 275 | 2023-04-02 02:42:00 | peruser | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 274 | 2023-03-16 02:19:08 | peruser | 2 | 107671 | 34 | 2.873 | 37476.9 |
| 273 | 2023-02-17 11:06:49 | peruser | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 272 | 2023-01-02 11:59:39 | peruser | 3 | 134027 | 413 | 5.766 | 23244.4 |
| 271 | 2022-12-18 15:45:47 | peruser | 2 | 107671 | 34 | 3.250 | 33129.5 |
| 270 | 2022-12-17 04:11:59 | peruser | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 269 | 2022-12-16 10:42:28 | peruser | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 268 | 2022-09-07 11:29:11 | peruser | 3 | 134027 | 413 | 5.893 | 22743.4 |
| 267 | 2022-09-05 08:48:58 | peruser | 3 | 134027 | 413 | 5.923 | 22628.2 |
| 266 | 2022-08-25 04:09:42 | peruser | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 265 | 2022-08-13 19:50:32 | peruser | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 264 | 2022-08-12 16:52:02 | peruser | 2 | 107671 | 34 | 3.000 | 35890.3 |
| 263 | 2022-05-16 03:16:54 | peruser | 1 | 69583 | 5 | 1.330 | 52318.0 |
| 262 | 2022-04-12 10:10:39 | peruser | 1 | 69583 | 5 | 1.486 | 46825.7 |
| 261 | 2022-04-09 11:12:43 | peruser | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 260 | 2022-03-24 11:39:13 | peruser | 3 | 134027 | 413 | 7.003 | 19138.5 |
| 259 | 2022-03-11 06:38:00 | peruser | 2 | 107671 | 34 | 3.186 | 33795.0 |
| 258 | 2022-01-12 08:58:18 | peruser | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 257 | 2022-01-10 05:46:20 | peruser | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 256 | 2022-01-08 03:00:01 | peruser | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 255 | 2021-12-28 11:21:02 | peruser | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 254 | 2021-12-09 07:52:44 | peruser | 3 | 134027 | 413 | 7.033 | 19056.9 |
| 253 | 2021-12-08 18:44:37 | peruser | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 252 | 2021-12-02 19:13:57 | peruser | 2 | 107671 | 34 | 3.516 | 30623.2 |
| 251 | 2021-11-30 17:18:04 | peruser | 2 | 107671 | 34 | 3.593 | 29966.9 |
| 250 | 2021-11-14 00:45:34 | peruser | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 249 | 2021-11-04 06:19:28 | peruser | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 248 | 2021-10-03 21:45:27 | peruser | 2 | 107671 | 34 | 3.406 | 31612.2 |
| 247 | 2021-10-02 06:42:19 | peruser | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 246 | 2021-09-30 04:12:11 | peruser | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 245 | 2021-09-18 03:22:00 | peruser | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 244 | 2021-09-14 08:01:09 | peruser | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 243 | 2021-09-10 22:48:31 | peruser | 1 | 69583 | 5 | 1.090 | 63837.6 |
| 242 | 2021-08-16 17:39:38 | peruser | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 241 | 2021-07-21 16:16:14 | peruser | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 240 | 2021-06-27 02:26:11 | peruser | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 239 | 2021-06-18 07:12:21 | peruser | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 238 | 2021-04-09 21:31:02 | peruser | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 237 | 2021-03-19 02:09:34 | peruser | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 236 | 2021-01-30 03:28:43 | peruser | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 235 | 2021-01-26 03:36:11 | peruser | 1 | 69583 | 5 | 1.206 | 57697.3 |
| 234 | 2021-01-24 10:38:15 | peruser | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 233 | 2020-12-16 05:00:09 | peruser | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 232 | 2020-11-12 16:28:00 | peruser | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 231 | 2020-10-27 11:36:48 | peruser | 3 | 134027 | 413 | 6.576 | 20381.2 |
| 230 | 2020-10-16 12:30:39 | peruser | 2 | 107671 | 34 | 3.313 | 32499.5 |
| 229 | 2020-10-09 22:53:25 | peruser | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 228 | 2020-09-12 02:25:30 | peruser | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 227 | 2020-08-22 09:25:27 | peruser | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 226 | 2020-08-21 12:07:38 | peruser | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 225 | 2020-08-19 06:22:48 | peruser | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 224 | 2020-08-17 09:21:07 | peruser | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 223 | 2020-08-16 11:17:01 | peruser | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 222 | 2020-08-10 22:38:39 | peruser | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 221 | 2020-08-06 10:34:53 | peruser | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 220 | 2020-07-24 02:24:23 | peruser | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 219 | 2020-05-31 11:21:26 | peruser | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 218 | 2020-05-13 06:16:35 | peruser | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 217 | 2020-03-29 14:37:40 | peruser | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 216 | 2020-03-26 12:14:40 | peruser | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 215 | 2020-03-25 22:17:19 | peruser | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 214 | 2020-03-20 19:50:08 | peruser | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 213 | 2020-02-29 01:04:40 | peruser | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 212 | 2020-02-27 05:05:55 | peruser | 1 | 69583 | 5 | 1.373 | 50679.5 |
| 211 | 2020-02-27 03:08:49 | peruser | 1 | 69583 | 5 | 1.486 | 46825.7 |
| 210 | 2020-02-25 08:08:45 | peruser | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 209 | 2020-02-25 01:32:43 | peruser | 1 | 69583 | 5 | 1.266 | 54962.9 |