History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sprayed"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 286 | 2024-04-30 12:18:15 | sprayed | 1 | 69583 | 6 | 1.483 | 46920.4 |
| 285 | 2024-04-01 03:47:18 | sprayed | 3 | 134027 | 485 | 17.596 | 7616.9 |
| 284 | 2024-03-31 17:58:22 | sprayed | 3 | 134027 | 485 | 18.610 | 7201.9 |
| 283 | 2024-03-31 14:43:42 | sprayed | 3 | 134027 | 485 | 19.563 | 6851.0 |
| 282 | 2024-03-31 14:43:43 | sprayed | 2 | 107671 | 49 | 7.623 | 14124.5 |
| 281 | 2024-03-31 14:43:20 | sprayed | 3 | 134027 | 485 | 17.330 | 7733.8 |
| 280 | 2024-03-31 14:43:34 | sprayed | 1 | 69583 | 6 | 2.780 | 25029.9 |
| 279 | 2024-03-31 14:43:23 | sprayed | 2 | 107671 | 49 | 4.483 | 24017.6 |
| 278 | 2024-03-31 14:43:18 | sprayed | 1 | 69583 | 6 | 2.673 | 26031.8 |
| 277 | 2024-03-07 23:45:20 | sprayed | 3 | 134027 | 485 | 11.076 | 12100.7 |
| 276 | 2024-03-07 02:54:03 | sprayed | 3 | 134027 | 485 | 15.876 | 8442.1 |
| 275 | 2024-03-07 00:23:17 | sprayed | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 274 | 2024-02-25 10:32:42 | sprayed | 3 | 134027 | 485 | 19.000 | 7054.1 |
| 273 | 2024-02-24 20:28:23 | sprayed | 3 | 134027 | 485 | 7.796 | 17191.8 |
| 272 | 2024-01-21 16:38:30 | sprayed | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 271 | 2023-12-18 18:44:17 | sprayed | 1 | 69583 | 6 | 1.236 | 56296.9 |
| 270 | 2023-12-07 14:40:32 | sprayed | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 269 | 2023-11-20 09:53:23 | sprayed | 3 | 134027 | 485 | 6.063 | 22105.7 |
| 268 | 2023-11-17 05:48:37 | sprayed | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 267 | 2023-11-06 11:54:02 | sprayed | 1 | 69583 | 6 | 1.096 | 63488.1 |
| 266 | 2023-11-01 01:06:13 | sprayed | 1 | 69583 | 6 | 2.623 | 26528.0 |
| 265 | 2023-10-31 10:35:00 | sprayed | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 264 | 2023-09-27 10:41:59 | sprayed | 1 | 69583 | 6 | 1.080 | 64428.7 |
| 263 | 2023-09-22 19:05:09 | sprayed | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 262 | 2023-09-04 00:33:44 | sprayed | 1 | 69583 | 6 | 1.140 | 61037.7 |
| 261 | 2023-08-20 17:44:39 | sprayed | 3 | 134027 | 485 | 5.830 | 22989.2 |
| 260 | 2023-05-28 08:54:50 | sprayed | 1 | 69583 | 6 | 1.060 | 65644.3 |
| 259 | 2023-05-03 17:31:21 | sprayed | 3 | 134027 | 485 | 5.733 | 23378.2 |
| 258 | 2023-02-07 02:39:21 | sprayed | 3 | 134027 | 485 | 6.953 | 19276.1 |
| 257 | 2023-02-03 01:17:41 | sprayed | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 256 | 2023-01-25 11:18:20 | sprayed | 1 | 69583 | 6 | 1.170 | 59472.6 |
| 255 | 2023-01-21 19:09:49 | sprayed | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 254 | 2022-12-01 03:52:36 | sprayed | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 253 | 2022-11-19 03:26:02 | sprayed | 3 | 134027 | 485 | 5.720 | 23431.3 |
| 252 | 2022-09-19 12:15:16 | sprayed | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 251 | 2022-09-01 13:16:47 | sprayed | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 250 | 2022-07-26 07:13:03 | sprayed | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 249 | 2022-07-18 19:06:07 | sprayed | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 248 | 2022-06-22 07:21:35 | sprayed | 3 | 134027 | 485 | 5.766 | 23244.4 |
| 247 | 2022-06-07 14:56:54 | sprayed | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 246 | 2022-05-03 00:12:47 | sprayed | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 245 | 2022-03-25 09:38:27 | sprayed | 1 | 69583 | 6 | 1.530 | 45479.1 |
| 244 | 2022-03-21 02:04:00 | sprayed | 1 | 69583 | 6 | 1.236 | 56296.9 |
| 243 | 2022-01-05 22:26:59 | sprayed | 1 | 69583 | 6 | 1.140 | 61037.7 |
| 242 | 2022-01-02 17:04:11 | sprayed | 1 | 69583 | 6 | 1.296 | 53690.6 |
| 241 | 2021-12-29 04:06:07 | sprayed | 1 | 69583 | 6 | 1.096 | 63488.1 |
| 240 | 2021-11-04 22:49:06 | sprayed | 1 | 69583 | 6 | 1.216 | 57222.9 |
| 239 | 2021-09-24 12:17:54 | sprayed | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 238 | 2021-09-22 08:25:36 | sprayed | 1 | 69583 | 6 | 1.436 | 48456.1 |
| 237 | 2021-09-17 00:33:42 | sprayed | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 236 | 2021-09-13 19:12:10 | sprayed | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 235 | 2021-06-09 17:35:33 | sprayed | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 234 | 2021-02-28 18:25:46 | sprayed | 1 | 69583 | 6 | 1.096 | 63488.1 |
| 233 | 2020-11-19 11:53:58 | sprayed | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 232 | 2020-11-09 01:00:52 | sprayed | 1 | 69583 | 6 | 1.153 | 60349.5 |
| 231 | 2020-10-30 08:39:43 | sprayed | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 230 | 2020-10-23 04:27:35 | sprayed | 1 | 69583 | 6 | 1.296 | 53690.6 |
| 229 | 2020-10-16 11:02:03 | sprayed | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 228 | 2020-08-17 12:39:41 | sprayed | 1 | 69583 | 6 | 1.060 | 65644.3 |
| 227 | 2020-08-13 02:25:29 | sprayed | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 226 | 2020-08-08 07:06:47 | sprayed | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 225 | 2020-07-29 10:38:13 | sprayed | 1 | 69583 | 6 | 1.343 | 51811.6 |
| 224 | 2020-05-12 00:41:36 | sprayed | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 223 | 2020-03-25 03:02:34 | sprayed | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 222 | 2020-03-24 11:58:33 | sprayed | 1 | 69583 | 6 | 1.953 | 35628.8 |
| 221 | 2020-03-24 11:03:49 | sprayed | 1 | 69583 | 6 | 1.423 | 48898.8 |
| 220 | 2020-03-21 00:56:54 | sprayed | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 219 | 2020-02-25 23:24:45 | sprayed | 1 | 69583 | 6 | 2.720 | 25582.0 |
| 218 | 2020-02-17 21:35:17 | sprayed | 1 | 69583 | 6 | 2.486 | 27989.9 |
| 217 | 2020-02-14 18:27:41 | sprayed | 1 | 69583 | 6 | 2.873 | 24219.6 |
| 216 | 2020-02-10 09:03:27 | sprayed | 1 | 69583 | 6 | 1.140 | 61037.7 |
| 215 | 2020-02-06 02:16:17 | sprayed | 1 | 69583 | 6 | 3.830 | 18167.9 |
| 214 | 2020-02-05 10:46:53 | sprayed | 1 | 69583 | 6 | 2.813 | 24736.2 |
| 213 | 2020-02-03 11:56:17 | sprayed | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 212 | 2020-01-29 05:48:20 | sprayed | 1 | 69583 | 6 | 1.376 | 50569.0 |
| 211 | 2020-01-23 19:32:33 | sprayed | 1 | 69583 | 6 | 2.780 | 25029.9 |
| 210 | 2020-01-20 00:38:46 | sprayed | 1 | 69583 | 6 | 2.796 | 24886.6 |
| 209 | 2020-01-18 03:08:25 | sprayed | 1 | 69583 | 6 | 2.856 | 24363.8 |
| 208 | 2020-01-13 19:48:31 | sprayed | 1 | 69583 | 6 | 1.356 | 51314.9 |
| 207 | 2020-01-09 00:29:01 | sprayed | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 206 | 2019-12-29 16:04:57 | sprayed | 1 | 69583 | 6 | 1.173 | 59320.5 |
| 205 | 2019-12-28 05:42:53 | sprayed | 1 | 69583 | 6 | 1.343 | 51811.6 |
| 204 | 2019-12-28 03:46:20 | sprayed | 1 | 69583 | 6 | 1.406 | 49490.0 |
| 203 | 2019-12-27 20:20:06 | sprayed | 1 | 69583 | 6 | 2.000 | 34791.5 |
| 202 | 2019-11-02 16:27:33 | sprayed | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 201 | 2019-08-04 15:34:25 | sprayed | 1 | 69583 | 6 | 1.150 | 60507.0 |
| 200 | 2019-04-25 06:08:39 | sprayed | 1 | 69583 | 6 | 1.056 | 65893.0 |
| 199 | 2019-03-04 16:48:54 | sprayed | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 198 | 2019-02-15 11:23:23 | sprayed | 1 | 69583 | 6 | 1.060 | 65644.3 |
| 197 | 2019-02-12 02:37:04 | sprayed | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 196 | 2019-01-30 19:39:23 | sprayed | 1 | 69583 | 6 | 1.216 | 57222.9 |
| 195 | 2019-01-05 13:12:22 | sprayed | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 194 | 2019-01-02 05:10:46 | sprayed | 1 | 69583 | 6 | 1.113 | 62518.4 |
| 193 | 2018-12-25 02:44:07 | sprayed | 1 | 69583 | 6 | 1.256 | 55400.5 |
| 192 | 2018-11-28 15:19:59 | sprayed | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 191 | 2018-10-17 20:52:52 | sprayed | 1 | 69583 | 6 | 2.603 | 26731.8 |
| 190 | 2018-10-03 06:35:12 | sprayed | 1 | 69583 | 6 | 1.173 | 59320.5 |
| 189 | 2018-09-05 11:26:04 | sprayed | 1 | 69583 | 6 | 1.070 | 65030.8 |
| 188 | 2018-08-19 04:24:34 | sprayed | 1 | 69583 | 6 | 1.123 | 61961.7 |
| 187 | 2018-08-03 01:41:28 | sprayed | 1 | 69583 | 6 | 1.243 | 55979.9 |