History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prentices"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 281 | 2024-05-04 14:41:17 | prentices | 1 | 81242 | 3 | 1.513 | 53696.0 |
| 280 | 2024-05-03 06:16:39 | prentices | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 279 | 2024-04-28 04:55:12 | prentices | 1 | 81242 | 3 | 4.716 | 17226.9 |
| 278 | 2024-04-13 09:42:27 | prentices | 1 | 81242 | 3 | 1.513 | 53696.0 |
| 277 | 2024-03-30 04:13:37 | prentices | 1 | 81242 | 3 | 4.673 | 17385.4 |
| 276 | 2024-03-28 13:41:29 | prentices | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 275 | 2024-03-26 08:04:24 | prentices | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 274 | 2024-03-25 21:40:53 | prentices | 2 | 121436 | 11 | 3.390 | 35821.8 |
| 273 | 2024-03-14 11:23:36 | prentices | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 272 | 2024-03-10 18:12:43 | prentices | 1 | 81242 | 3 | 3.483 | 23325.3 |
| 271 | 2024-03-05 16:12:59 | prentices | 1 | 81242 | 3 | 1.503 | 54053.2 |
| 270 | 2024-02-27 07:42:44 | prentices | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 269 | 2024-02-04 16:46:30 | prentices | 3 | 148641 | 148 | 21.880 | 6793.5 |
| 268 | 2024-02-04 13:00:10 | prentices | 3 | 148641 | 148 | 9.593 | 15494.7 |
| 267 | 2024-02-04 09:15:40 | prentices | 2 | 121436 | 11 | 9.813 | 12375.0 |
| 266 | 2024-02-04 09:15:34 | prentices | 3 | 148641 | 148 | 13.860 | 10724.5 |
| 265 | 2024-02-04 06:27:38 | prentices | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 264 | 2023-12-19 10:31:59 | prentices | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 263 | 2023-12-08 14:26:49 | prentices | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 262 | 2023-11-30 00:33:09 | prentices | 2 | 121436 | 11 | 3.250 | 37364.9 |
| 261 | 2023-11-29 00:03:36 | prentices | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 260 | 2023-11-24 14:25:40 | prentices | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 259 | 2023-11-13 21:29:37 | prentices | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 258 | 2023-11-04 03:33:42 | prentices | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 257 | 2023-10-31 21:17:23 | prentices | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 256 | 2023-10-25 05:50:43 | prentices | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 255 | 2023-10-06 11:38:27 | prentices | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 254 | 2023-09-26 01:27:40 | prentices | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 253 | 2023-08-29 22:00:24 | prentices | 2 | 121436 | 11 | 3.890 | 31217.5 |
| 252 | 2023-08-02 00:05:01 | prentices | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 251 | 2023-07-12 05:24:52 | prentices | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 250 | 2023-05-14 13:36:43 | prentices | 2 | 121436 | 11 | 3.626 | 33490.3 |
| 249 | 2023-04-27 10:02:32 | prentices | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 248 | 2023-03-24 14:49:23 | prentices | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 247 | 2023-02-19 07:08:18 | prentices | 2 | 121436 | 11 | 3.563 | 34082.5 |
| 246 | 2023-02-17 04:49:59 | prentices | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 245 | 2022-12-26 20:42:08 | prentices | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 244 | 2022-12-14 18:43:38 | prentices | 1 | 81242 | 3 | 2.190 | 37096.8 |
| 243 | 2022-12-03 03:47:30 | prentices | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 242 | 2022-12-01 20:22:55 | prentices | 2 | 121436 | 11 | 3.346 | 36292.9 |
| 241 | 2022-11-22 16:56:30 | prentices | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 240 | 2022-08-19 02:56:52 | prentices | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 239 | 2022-08-06 07:00:20 | prentices | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 238 | 2022-07-19 02:13:38 | prentices | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 237 | 2022-07-18 21:51:00 | prentices | 3 | 148641 | 148 | 6.390 | 23261.5 |
| 236 | 2022-04-18 15:03:13 | prentices | 2 | 121436 | 11 | 3.436 | 35342.3 |
| 235 | 2022-04-11 20:02:16 | prentices | 1 | 81242 | 3 | 1.610 | 50460.9 |
| 234 | 2022-04-11 03:38:12 | prentices | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 233 | 2022-01-16 12:33:18 | prentices | 2 | 121436 | 11 | 8.360 | 14525.8 |
| 232 | 2022-01-11 06:31:52 | prentices | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 231 | 2022-01-09 02:42:00 | prentices | 1 | 81242 | 3 | 1.293 | 62832.2 |
| 230 | 2021-12-24 07:23:35 | prentices | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 229 | 2021-11-07 07:02:41 | prentices | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 228 | 2021-10-13 16:52:24 | prentices | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 227 | 2021-09-13 21:32:23 | prentices | 1 | 81242 | 3 | 1.640 | 49537.8 |
| 226 | 2021-09-10 16:46:23 | prentices | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 225 | 2021-06-09 19:52:25 | prentices | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 224 | 2021-05-10 14:05:57 | prentices | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 223 | 2021-04-09 07:54:45 | prentices | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 222 | 2021-03-07 11:04:44 | prentices | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 221 | 2021-03-04 08:55:11 | prentices | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 220 | 2021-02-24 02:54:36 | prentices | 3 | 148641 | 148 | 6.326 | 23496.8 |
| 219 | 2021-02-16 19:01:58 | prentices | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 218 | 2020-11-28 18:54:11 | prentices | 1 | 81242 | 3 | 1.563 | 51978.2 |
| 217 | 2020-11-19 14:55:34 | prentices | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 216 | 2020-10-31 17:16:58 | prentices | 1 | 81242 | 3 | 1.456 | 55798.1 |
| 215 | 2020-10-22 23:28:27 | prentices | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 214 | 2020-10-09 04:51:06 | prentices | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 213 | 2020-10-08 09:29:09 | prentices | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 212 | 2020-08-28 01:34:56 | prentices | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 211 | 2020-08-10 06:57:47 | prentices | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 210 | 2020-07-31 06:17:52 | prentices | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 209 | 2020-05-09 01:43:49 | prentices | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 208 | 2020-03-29 00:49:03 | prentices | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 207 | 2020-03-28 18:44:45 | prentices | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 206 | 2020-03-24 11:46:36 | prentices | 1 | 81242 | 3 | 1.450 | 56029.0 |
| 205 | 2020-03-20 08:05:17 | prentices | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 204 | 2020-02-26 18:38:12 | prentices | 1 | 81242 | 3 | 3.236 | 25105.7 |
| 203 | 2020-02-23 17:00:17 | prentices | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 202 | 2020-02-19 04:24:06 | prentices | 1 | 81242 | 3 | 3.046 | 26671.7 |
| 201 | 2020-02-11 17:54:18 | prentices | 1 | 81242 | 3 | 3.110 | 26122.8 |
| 200 | 2020-02-06 12:20:33 | prentices | 1 | 81242 | 3 | 3.873 | 20976.5 |
| 199 | 2020-02-05 12:23:50 | prentices | 1 | 81242 | 3 | 1.626 | 49964.3 |
| 198 | 2020-02-02 06:00:56 | prentices | 1 | 81242 | 3 | 2.190 | 37096.8 |
| 197 | 2020-01-31 19:45:13 | prentices | 1 | 81242 | 3 | 1.640 | 49537.8 |
| 196 | 2020-01-27 21:08:28 | prentices | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 195 | 2020-01-22 01:21:20 | prentices | 1 | 81242 | 3 | 3.263 | 24897.9 |
| 194 | 2020-01-20 05:34:15 | prentices | 1 | 81242 | 3 | 1.593 | 50999.4 |
| 193 | 2020-01-14 08:12:39 | prentices | 1 | 81242 | 3 | 3.096 | 26241.0 |
| 192 | 2020-01-06 20:39:21 | prentices | 1 | 81242 | 3 | 1.403 | 57905.9 |
| 191 | 2020-01-02 04:50:00 | prentices | 1 | 81242 | 3 | 3.266 | 24875.1 |
| 190 | 2019-12-30 13:07:23 | prentices | 1 | 81242 | 3 | 2.860 | 28406.3 |
| 189 | 2019-12-29 01:08:12 | prentices | 1 | 81242 | 3 | 2.843 | 28576.2 |
| 188 | 2019-11-05 22:16:04 | prentices | 1 | 81242 | 3 | 1.593 | 50999.4 |
| 187 | 2019-08-04 17:49:02 | prentices | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 186 | 2019-06-08 11:43:58 | prentices | 1 | 81242 | 3 | 1.273 | 63819.3 |
| 185 | 2019-05-04 20:04:32 | prentices | 1 | 81242 | 3 | 1.463 | 55531.1 |
| 184 | 2019-04-02 18:50:41 | prentices | 1 | 81242 | 3 | 1.300 | 62493.8 |
| 183 | 2019-02-15 18:14:52 | prentices | 3 | 148641 | 148 | 10.296 | 14436.8 |
| 182 | 2019-02-15 06:23:39 | prentices | 1 | 81242 | 3 | 1.233 | 65889.7 |