History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lecture"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 340 | 2024-04-25 07:05:09 | lecture | 1 | 69583 | 4 | 5.846 | 11902.7 |
| 339 | 2024-04-23 00:42:18 | lecture | 2 | 107671 | 20 | 2.810 | 38317.1 |
| 338 | 2024-04-16 22:53:49 | lecture | 1 | 69583 | 4 | 3.576 | 19458.3 |
| 337 | 2024-04-16 22:48:20 | lecture | 1 | 69583 | 4 | 2.826 | 24622.4 |
| 336 | 2024-01-24 11:04:07 | lecture | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 335 | 2024-01-17 12:54:04 | lecture | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 334 | 2024-01-03 20:16:37 | lecture | 3 | 134027 | 212 | 7.283 | 18402.7 |
| 333 | 2023-12-24 20:13:34 | lecture | 3 | 134027 | 212 | 6.640 | 20184.8 |
| 332 | 2023-12-24 20:13:28 | lecture | 2 | 107671 | 20 | 3.140 | 34290.1 |
| 331 | 2023-12-18 02:26:17 | lecture | 2 | 107671 | 20 | 3.060 | 35186.6 |
| 330 | 2023-12-10 02:53:27 | lecture | 3 | 134027 | 212 | 6.733 | 19906.0 |
| 329 | 2023-12-10 02:53:18 | lecture | 2 | 107671 | 20 | 2.843 | 37872.3 |
| 328 | 2023-11-29 20:28:31 | lecture | 2 | 107671 | 20 | 7.516 | 14325.6 |
| 327 | 2023-11-29 06:03:59 | lecture | 3 | 134027 | 212 | 6.080 | 22043.9 |
| 326 | 2023-11-13 01:58:48 | lecture | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 325 | 2023-11-12 23:23:32 | lecture | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 324 | 2023-11-10 23:17:30 | lecture | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 323 | 2023-11-07 09:28:34 | lecture | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 322 | 2023-10-29 15:19:24 | lecture | 2 | 107671 | 20 | 3.800 | 28334.5 |
| 321 | 2023-10-27 16:24:14 | lecture | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 320 | 2023-10-27 05:48:04 | lecture | 3 | 134027 | 212 | 17.170 | 7805.9 |
| 319 | 2023-10-20 18:06:19 | lecture | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 318 | 2023-10-18 00:25:46 | lecture | 3 | 134027 | 212 | 14.813 | 9047.9 |
| 317 | 2023-10-17 23:57:18 | lecture | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 316 | 2023-10-15 20:51:27 | lecture | 3 | 134027 | 212 | 7.970 | 16816.4 |
| 315 | 2023-10-11 19:44:03 | lecture | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 314 | 2023-10-08 09:21:25 | lecture | 3 | 134027 | 212 | 6.673 | 20085.0 |
| 313 | 2023-10-04 13:00:16 | lecture | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 312 | 2023-09-29 22:51:58 | lecture | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 311 | 2023-09-28 15:00:34 | lecture | 2 | 107671 | 20 | 3.763 | 28613.1 |
| 310 | 2023-09-25 20:47:11 | lecture | 3 | 134027 | 212 | 6.093 | 21996.9 |
| 309 | 2023-09-25 20:24:04 | lecture | 2 | 107671 | 20 | 3.250 | 33129.5 |
| 308 | 2023-09-21 22:19:43 | lecture | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 307 | 2023-09-19 14:34:10 | lecture | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 306 | 2023-09-18 05:49:10 | lecture | 2 | 107671 | 20 | 2.846 | 37832.4 |
| 305 | 2023-09-01 15:07:57 | lecture | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 304 | 2023-07-18 22:54:44 | lecture | 3 | 134027 | 212 | 6.736 | 19897.1 |
| 303 | 2023-06-26 11:57:42 | lecture | 2 | 107671 | 20 | 3.033 | 35499.8 |
| 302 | 2023-06-12 20:57:35 | lecture | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 301 | 2023-06-04 05:47:54 | lecture | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 300 | 2023-04-21 03:46:05 | lecture | 3 | 134027 | 212 | 6.423 | 20866.7 |
| 299 | 2023-04-17 08:36:27 | lecture | 3 | 134027 | 212 | 5.843 | 22938.0 |
| 298 | 2023-04-02 10:20:25 | lecture | 3 | 134027 | 212 | 5.920 | 22639.7 |
| 297 | 2023-03-28 19:24:36 | lecture | 3 | 134027 | 212 | 6.783 | 19759.3 |
| 296 | 2023-03-27 15:20:11 | lecture | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 295 | 2023-03-25 07:23:03 | lecture | 3 | 134027 | 212 | 6.110 | 21935.7 |
| 294 | 2023-03-20 02:16:47 | lecture | 2 | 107671 | 20 | 2.766 | 38926.6 |
| 293 | 2023-03-19 00:41:49 | lecture | 3 | 134027 | 212 | 5.623 | 23835.5 |
| 292 | 2023-02-23 10:04:02 | lecture | 3 | 134027 | 212 | 10.843 | 12360.7 |
| 291 | 2023-02-21 13:17:37 | lecture | 1 | 69583 | 4 | 1.033 | 67360.1 |
| 290 | 2023-01-11 11:00:03 | lecture | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 289 | 2023-01-02 22:36:06 | lecture | 3 | 134027 | 212 | 6.703 | 19995.1 |
| 288 | 2022-12-29 01:58:09 | lecture | 3 | 134027 | 212 | 5.623 | 23835.5 |
| 287 | 2022-12-20 13:58:51 | lecture | 2 | 107671 | 20 | 2.813 | 38276.2 |
| 286 | 2022-12-17 22:28:25 | lecture | 3 | 134027 | 212 | 5.750 | 23309.0 |
| 285 | 2022-12-09 14:59:49 | lecture | 3 | 134027 | 212 | 7.003 | 19138.5 |
| 284 | 2022-12-09 13:49:23 | lecture | 3 | 134027 | 212 | 5.686 | 23571.4 |
| 283 | 2022-12-02 14:17:41 | lecture | 2 | 107671 | 20 | 2.940 | 36622.8 |
| 282 | 2022-11-22 04:55:53 | lecture | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 281 | 2022-11-19 00:38:01 | lecture | 3 | 134027 | 212 | 6.626 | 20227.4 |
| 280 | 2022-11-17 19:53:43 | lecture | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 279 | 2022-11-01 21:32:47 | lecture | 2 | 107671 | 20 | 3.156 | 34116.3 |
| 278 | 2022-11-01 00:09:18 | lecture | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 277 | 2022-10-26 09:07:47 | lecture | 3 | 134027 | 212 | 6.126 | 21878.4 |
| 276 | 2022-10-15 06:09:56 | lecture | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 275 | 2022-10-07 09:20:04 | lecture | 3 | 134027 | 212 | 7.300 | 18359.9 |
| 274 | 2022-10-05 00:23:55 | lecture | 3 | 134027 | 212 | 5.670 | 23637.9 |
| 273 | 2022-09-19 15:03:13 | lecture | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 272 | 2022-09-10 10:01:06 | lecture | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 271 | 2022-09-01 11:39:06 | lecture | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 270 | 2022-08-30 17:35:27 | lecture | 3 | 134027 | 212 | 5.670 | 23637.9 |
| 269 | 2022-08-28 08:19:59 | lecture | 3 | 134027 | 212 | 5.846 | 22926.3 |
| 268 | 2022-08-23 16:48:32 | lecture | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 267 | 2022-08-20 12:21:44 | lecture | 2 | 107671 | 20 | 2.890 | 37256.4 |
| 266 | 2022-08-14 02:22:50 | lecture | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 265 | 2022-08-06 21:44:35 | lecture | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 264 | 2022-07-18 14:56:14 | lecture | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 263 | 2022-07-17 17:26:18 | lecture | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 262 | 2022-07-09 21:20:45 | lecture | 1 | 69583 | 4 | 2.143 | 32469.9 |
| 261 | 2022-07-03 08:31:45 | lecture | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 260 | 2022-07-02 06:19:38 | lecture | 1 | 69583 | 4 | 1.376 | 50569.0 |
| 259 | 2022-06-13 22:07:12 | lecture | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 258 | 2022-06-05 16:24:09 | lecture | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 257 | 2022-06-03 11:57:39 | lecture | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 256 | 2022-04-24 13:26:59 | lecture | 3 | 134027 | 212 | 5.843 | 22938.0 |
| 255 | 2022-03-28 00:39:25 | lecture | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 254 | 2022-03-25 09:08:25 | lecture | 3 | 134027 | 212 | 6.986 | 19185.1 |
| 253 | 2022-03-21 02:14:48 | lecture | 3 | 134027 | 212 | 6.313 | 21230.3 |
| 252 | 2022-02-11 06:46:38 | lecture | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 251 | 2021-12-15 08:22:23 | lecture | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 250 | 2021-12-10 13:47:14 | lecture | 1 | 69583 | 4 | 1.283 | 54234.6 |
| 249 | 2021-12-06 00:22:33 | lecture | 3 | 134027 | 212 | 7.016 | 19103.1 |
| 248 | 2021-11-09 23:34:01 | lecture | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 247 | 2021-10-10 05:26:22 | lecture | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 246 | 2021-09-06 12:24:45 | lecture | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 245 | 2021-06-05 12:23:40 | lecture | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 244 | 2021-05-20 18:25:38 | lecture | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 243 | 2021-04-21 00:50:40 | lecture | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 242 | 2021-03-03 07:58:37 | lecture | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 241 | 2021-01-05 20:37:49 | lecture | 1 | 69583 | 4 | 1.063 | 65459.1 |