History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"weapons"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 295 | 2024-04-16 17:31:25 | weapons | 2 | 107671 | 19 | 9.576 | 11243.8 |
| 294 | 2024-04-16 17:30:26 | weapons | 3 | 134027 | 268 | 7.560 | 17728.4 |
| 293 | 2024-04-13 14:57:51 | weapons | 2 | 107671 | 19 | 3.330 | 32333.6 |
| 292 | 2024-04-13 14:54:31 | weapons | 3 | 134027 | 268 | 6.906 | 19407.3 |
| 291 | 2024-04-12 23:06:43 | weapons | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 290 | 2024-04-12 21:55:40 | weapons | 2 | 107671 | 19 | 3.436 | 31336.1 |
| 289 | 2024-04-12 21:53:36 | weapons | 3 | 134027 | 268 | 7.470 | 17942.0 |
| 288 | 2024-04-09 17:57:35 | weapons | 3 | 134027 | 268 | 22.283 | 6014.8 |
| 287 | 2024-04-08 22:20:46 | weapons | 1 | 69583 | 4 | 2.533 | 27470.6 |
| 286 | 2024-04-08 22:20:27 | weapons | 3 | 134027 | 268 | 16.546 | 8100.3 |
| 285 | 2024-04-08 22:20:26 | weapons | 2 | 107671 | 19 | 4.640 | 23205.0 |
| 284 | 2024-04-08 22:19:00 | weapons | 1 | 69583 | 4 | 2.143 | 32469.9 |
| 283 | 2024-03-08 23:46:37 | weapons | 3 | 134027 | 268 | 14.720 | 9105.1 |
| 282 | 2024-03-08 06:49:23 | weapons | 1 | 69583 | 4 | 2.750 | 25302.9 |
| 281 | 2024-03-08 00:47:20 | weapons | 2 | 107671 | 19 | 8.423 | 12783.0 |
| 280 | 2024-03-07 17:39:13 | weapons | 3 | 134027 | 268 | 7.436 | 18024.1 |
| 279 | 2024-03-05 02:28:23 | weapons | 2 | 107671 | 19 | 8.860 | 12152.5 |
| 278 | 2024-03-05 02:28:22 | weapons | 2 | 107671 | 19 | 5.466 | 19698.3 |
| 277 | 2024-02-28 16:49:00 | weapons | 1 | 69583 | 4 | 2.406 | 28920.6 |
| 276 | 2024-02-25 18:34:46 | weapons | 2 | 107671 | 19 | 3.640 | 29579.9 |
| 275 | 2024-02-25 18:34:28 | weapons | 3 | 134027 | 268 | 6.360 | 21073.4 |
| 274 | 2024-02-06 13:37:02 | weapons | 2 | 107671 | 19 | 3.626 | 29694.2 |
| 273 | 2024-02-06 13:35:30 | weapons | 3 | 134027 | 268 | 7.236 | 18522.2 |
| 272 | 2024-02-05 21:32:02 | weapons | 3 | 134027 | 268 | 6.893 | 19443.9 |
| 271 | 2024-02-05 18:20:01 | weapons | 2 | 107671 | 19 | 2.873 | 37476.9 |
| 270 | 2024-02-05 18:17:45 | weapons | 3 | 134027 | 268 | 6.140 | 21828.5 |
| 269 | 2024-02-05 15:11:50 | weapons | 3 | 134027 | 268 | 7.093 | 18895.7 |
| 268 | 2024-02-05 15:11:22 | weapons | 2 | 107671 | 19 | 7.280 | 14790.0 |
| 267 | 2024-02-05 14:09:38 | weapons | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 266 | 2024-01-05 05:52:25 | weapons | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 265 | 2023-12-29 18:14:40 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 264 | 2023-12-05 23:39:44 | weapons | 1 | 69583 | 4 | 1.030 | 67556.3 |
| 263 | 2023-11-29 11:39:35 | weapons | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 262 | 2023-11-22 19:25:50 | weapons | 2 | 107671 | 19 | 11.063 | 9732.5 |
| 261 | 2023-11-13 07:38:36 | weapons | 1 | 69583 | 4 | 2.576 | 27012.0 |
| 260 | 2023-11-04 22:05:56 | weapons | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 259 | 2023-10-19 03:09:17 | weapons | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 258 | 2023-10-13 14:29:06 | weapons | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 257 | 2023-09-29 00:32:28 | weapons | 1 | 69583 | 4 | 2.313 | 30083.4 |
| 256 | 2023-09-14 21:20:53 | weapons | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 255 | 2023-08-23 01:59:33 | weapons | 2 | 107671 | 19 | 3.406 | 31612.2 |
| 254 | 2023-08-14 06:38:42 | weapons | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 253 | 2023-06-22 17:19:46 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 252 | 2023-06-09 07:59:07 | weapons | 1 | 69583 | 4 | 1.030 | 67556.3 |
| 251 | 2023-05-10 17:49:43 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 250 | 2023-05-07 05:31:36 | weapons | 2 | 107671 | 19 | 2.780 | 38730.6 |
| 249 | 2023-03-07 09:26:39 | weapons | 1 | 69583 | 4 | 2.216 | 31400.3 |
| 248 | 2023-02-13 08:49:41 | weapons | 2 | 107671 | 19 | 2.830 | 38046.3 |
| 247 | 2023-02-05 12:29:29 | weapons | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 246 | 2023-02-04 04:11:11 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 245 | 2022-12-29 10:48:31 | weapons | 1 | 69583 | 4 | 2.390 | 29114.2 |
| 244 | 2022-12-20 05:53:19 | weapons | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 243 | 2022-11-25 21:15:36 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 242 | 2022-11-23 21:55:50 | weapons | 2 | 107671 | 19 | 3.203 | 33615.7 |
| 241 | 2022-11-23 16:19:18 | weapons | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 240 | 2022-11-05 18:51:19 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 239 | 2022-09-30 18:36:27 | weapons | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 238 | 2022-09-19 15:12:14 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 237 | 2022-09-18 16:47:35 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 236 | 2022-09-15 16:29:05 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 235 | 2022-08-14 17:00:47 | weapons | 1 | 69583 | 4 | 1.033 | 67360.1 |
| 234 | 2022-07-29 01:13:52 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 233 | 2022-06-30 22:21:04 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 232 | 2022-05-17 14:13:54 | weapons | 1 | 69583 | 4 | 1.420 | 49002.1 |
| 231 | 2022-05-03 10:19:55 | weapons | 2 | 107671 | 19 | 4.016 | 26810.5 |
| 230 | 2022-05-02 03:44:36 | weapons | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 229 | 2022-04-29 02:25:21 | weapons | 2 | 107671 | 19 | 3.593 | 29966.9 |
| 228 | 2022-03-03 17:13:01 | weapons | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 227 | 2022-01-13 19:57:00 | weapons | 2 | 107671 | 19 | 2.860 | 37647.2 |
| 226 | 2021-12-29 19:32:00 | weapons | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 225 | 2021-12-14 05:44:36 | weapons | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 224 | 2021-10-25 13:01:56 | weapons | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 223 | 2021-10-23 13:01:50 | weapons | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 222 | 2021-08-27 17:31:14 | weapons | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 221 | 2021-06-28 02:42:57 | weapons | 3 | 134027 | 268 | 11.640 | 11514.3 |
| 220 | 2021-05-30 11:48:16 | weapons | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 219 | 2021-05-10 03:10:38 | weapons | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 218 | 2021-05-06 18:11:56 | weapons | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 217 | 2021-05-05 04:41:01 | weapons | 1 | 69583 | 4 | 1.310 | 53116.8 |
| 216 | 2021-05-02 17:57:57 | weapons | 1 | 69583 | 4 | 1.326 | 52475.9 |
| 215 | 2021-05-02 00:01:03 | weapons | 1 | 69583 | 4 | 2.533 | 27470.6 |
| 214 | 2021-04-03 07:20:21 | weapons | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 213 | 2021-03-27 09:33:08 | weapons | 3 | 134027 | 268 | 6.000 | 22337.8 |
| 212 | 2021-03-23 00:41:39 | weapons | 3 | 134027 | 268 | 6.576 | 20381.2 |
| 211 | 2021-01-18 04:56:32 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 210 | 2021-01-17 19:20:06 | weapons | 1 | 69583 | 4 | 1.033 | 67360.1 |
| 209 | 2020-12-19 04:17:50 | weapons | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 208 | 2020-11-26 00:50:01 | weapons | 3 | 134027 | 268 | 5.873 | 22820.9 |
| 207 | 2020-11-04 21:57:56 | weapons | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 206 | 2020-11-01 04:35:42 | weapons | 1 | 69583 | 4 | 1.143 | 60877.5 |
| 205 | 2020-10-29 14:17:00 | weapons | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 204 | 2020-10-26 02:27:16 | weapons | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 203 | 2020-10-03 20:29:10 | weapons | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 202 | 2020-08-04 19:06:25 | weapons | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 201 | 2020-06-10 16:12:53 | weapons | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 200 | 2020-03-29 05:41:25 | weapons | 1 | 69583 | 4 | 1.310 | 53116.8 |
| 199 | 2020-03-28 22:14:16 | weapons | 1 | 69583 | 4 | 1.310 | 53116.8 |
| 198 | 2020-03-28 10:20:14 | weapons | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 197 | 2020-03-24 05:00:34 | weapons | 1 | 69583 | 4 | 1.330 | 52318.0 |
| 196 | 2020-03-21 02:11:12 | weapons | 1 | 69583 | 4 | 1.216 | 57222.9 |