History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"truncates"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 268 | 2024-04-28 02:51:29 | truncates | 3 | 148641 | 48 | 19.720 | 7537.6 |
| 267 | 2024-04-28 02:51:36 | truncates | 2 | 121436 | 4 | 11.653 | 10421.0 |
| 266 | 2024-04-28 01:53:11 | truncates | 1 | 81242 | 3 | 1.530 | 53099.3 |
| 265 | 2024-04-27 23:13:10 | truncates | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 264 | 2024-04-27 17:48:37 | truncates | 1 | 81242 | 3 | 1.720 | 47233.7 |
| 263 | 2024-04-27 16:56:01 | truncates | 1 | 81242 | 3 | 3.470 | 23412.7 |
| 262 | 2024-04-22 10:19:48 | truncates | 4 | 165329 | 630 | 19.500 | 8478.4 |
| 261 | 2024-04-21 11:03:37 | truncates | 4 | 165329 | 630 | 44.126 | 3746.7 |
| 260 | 2024-04-21 07:43:29 | truncates | 1 | 81242 | 3 | 3.096 | 26241.0 |
| 259 | 2024-04-17 01:43:08 | truncates | 3 | 148641 | 48 | 8.970 | 16570.9 |
| 258 | 2024-04-17 01:01:42 | truncates | 4 | 165329 | 630 | 15.173 | 10896.3 |
| 257 | 2024-04-16 02:20:34 | truncates | 4 | 165329 | 630 | 26.703 | 6191.4 |
| 256 | 2024-04-15 23:38:07 | truncates | 4 | 165329 | 630 | 29.516 | 5601.3 |
| 255 | 2024-04-15 23:38:07 | truncates | 3 | 148641 | 48 | 16.000 | 9290.1 |
| 254 | 2024-04-15 23:38:03 | truncates | 2 | 121436 | 4 | 4.013 | 30260.7 |
| 253 | 2024-04-15 22:14:36 | truncates | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 252 | 2024-04-08 16:27:31 | truncates | 1 | 81242 | 3 | 4.953 | 16402.6 |
| 251 | 2024-03-28 10:42:16 | truncates | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 250 | 2024-03-22 21:12:22 | truncates | 4 | 165329 | 630 | 21.360 | 7740.1 |
| 249 | 2024-03-22 04:38:23 | truncates | 2 | 121436 | 4 | 4.673 | 25986.7 |
| 248 | 2024-03-22 04:15:17 | truncates | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 247 | 2024-03-20 07:59:44 | truncates | 3 | 148641 | 48 | 17.406 | 8539.6 |
| 246 | 2024-03-20 07:59:44 | truncates | 2 | 121436 | 4 | 12.720 | 9546.9 |
| 245 | 2024-03-20 07:44:16 | truncates | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 244 | 2024-03-15 12:53:48 | truncates | 4 | 165329 | 630 | 31.440 | 5258.6 |
| 243 | 2024-03-15 12:53:52 | truncates | 2 | 121436 | 4 | 12.173 | 9975.8 |
| 242 | 2024-03-15 11:57:22 | truncates | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 241 | 2024-03-10 21:11:04 | truncates | 1 | 81242 | 3 | 2.906 | 27956.6 |
| 240 | 2024-03-07 09:33:34 | truncates | 1 | 81242 | 3 | 1.720 | 47233.7 |
| 239 | 2024-03-01 14:26:43 | truncates | 2 | 121436 | 4 | 7.440 | 16322.0 |
| 238 | 2024-02-26 17:38:19 | truncates | 3 | 148641 | 48 | 17.970 | 8271.6 |
| 237 | 2024-02-25 21:35:06 | truncates | 3 | 148641 | 48 | 26.003 | 5716.3 |
| 236 | 2024-02-23 20:44:32 | truncates | 4 | 165329 | 630 | 11.843 | 13960.1 |
| 235 | 2024-02-23 20:44:34 | truncates | 3 | 148641 | 48 | 7.203 | 20636.0 |
| 234 | 2024-02-23 20:44:34 | truncates | 2 | 121436 | 4 | 3.626 | 33490.3 |
| 233 | 2024-02-23 17:55:32 | truncates | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 232 | 2024-02-18 07:17:02 | truncates | 1 | 81242 | 3 | 4.000 | 20310.5 |
| 231 | 2024-02-16 00:07:22 | truncates | 4 | 165329 | 630 | 16.330 | 10124.2 |
| 230 | 2024-02-08 11:06:34 | truncates | 1 | 81242 | 3 | 3.156 | 25742.1 |
| 229 | 2024-02-07 23:10:51 | truncates | 4 | 165329 | 630 | 37.003 | 4468.0 |
| 228 | 2024-02-07 18:19:35 | truncates | 4 | 165329 | 630 | 47.723 | 3464.3 |
| 227 | 2024-02-02 22:28:43 | truncates | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 226 | 2024-02-01 06:01:44 | truncates | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 225 | 2024-01-24 11:07:25 | truncates | 1 | 81242 | 3 | 1.393 | 58321.6 |
| 224 | 2024-01-20 12:29:06 | truncates | 4 | 165329 | 630 | 25.110 | 6584.2 |
| 223 | 2024-01-17 05:27:01 | truncates | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 222 | 2024-01-16 20:13:26 | truncates | 4 | 165329 | 630 | 11.233 | 14718.2 |
| 221 | 2024-01-13 17:54:55 | truncates | 4 | 165329 | 630 | 12.250 | 13496.2 |
| 220 | 2024-01-09 10:30:39 | truncates | 4 | 165329 | 630 | 14.626 | 11303.8 |
| 219 | 2024-01-04 17:45:32 | truncates | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 218 | 2024-01-02 04:01:31 | truncates | 1 | 81242 | 3 | 1.356 | 59913.0 |
| 217 | 2023-11-21 12:10:34 | truncates | 2 | 121436 | 4 | 3.153 | 38514.4 |
| 216 | 2023-11-17 15:29:54 | truncates | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 215 | 2023-11-16 07:20:06 | truncates | 4 | 165329 | 630 | 11.843 | 13960.1 |
| 214 | 2023-10-25 16:18:05 | truncates | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 213 | 2023-08-22 09:13:02 | truncates | 2 | 121436 | 4 | 3.030 | 40077.9 |
| 212 | 2023-08-21 02:31:18 | truncates | 1 | 81242 | 3 | 1.403 | 57905.9 |
| 211 | 2023-08-17 15:55:15 | truncates | 4 | 165329 | 630 | 11.500 | 14376.4 |
| 210 | 2023-05-20 11:03:23 | truncates | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 209 | 2023-05-17 09:41:37 | truncates | 4 | 165329 | 630 | 11.313 | 14614.1 |
| 208 | 2023-05-06 14:24:02 | truncates | 2 | 121436 | 4 | 3.030 | 40077.9 |
| 207 | 2023-05-02 22:42:49 | truncates | 4 | 165329 | 630 | 11.310 | 14617.9 |
| 206 | 2023-03-16 04:32:27 | truncates | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 205 | 2023-02-11 00:22:06 | truncates | 2 | 121436 | 4 | 3.310 | 36687.6 |
| 204 | 2023-02-08 00:05:53 | truncates | 4 | 165329 | 630 | 10.160 | 16272.5 |
| 203 | 2023-02-03 12:15:59 | truncates | 4 | 165329 | 630 | 11.170 | 14801.2 |
| 202 | 2023-01-02 23:23:22 | truncates | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 201 | 2022-12-25 04:23:38 | truncates | 4 | 165329 | 630 | 15.610 | 10591.2 |
| 200 | 2022-12-24 09:06:07 | truncates | 4 | 165329 | 630 | 10.890 | 15181.7 |
| 199 | 2022-12-20 06:02:28 | truncates | 4 | 165329 | 630 | 12.140 | 13618.5 |
| 198 | 2022-12-18 22:37:27 | truncates | 4 | 165329 | 630 | 10.173 | 16251.7 |
| 197 | 2022-11-22 06:21:35 | truncates | 4 | 165329 | 630 | 15.046 | 10988.2 |
| 196 | 2022-11-21 21:11:21 | truncates | 2 | 121436 | 4 | 3.000 | 40478.7 |
| 195 | 2022-11-19 21:41:34 | truncates | 4 | 165329 | 630 | 10.156 | 16278.9 |
| 194 | 2022-10-17 12:28:23 | truncates | 4 | 165329 | 630 | 10.643 | 15534.1 |
| 193 | 2022-10-09 13:23:22 | truncates | 4 | 165329 | 630 | 10.346 | 15980.0 |
| 192 | 2022-09-25 03:03:16 | truncates | 1 | 81242 | 3 | 1.216 | 66810.9 |
| 191 | 2022-09-08 13:17:08 | truncates | 4 | 165329 | 630 | 13.550 | 12201.4 |
| 190 | 2022-08-27 10:56:22 | truncates | 4 | 165329 | 630 | 10.390 | 15912.3 |
| 189 | 2022-08-25 04:27:38 | truncates | 4 | 165329 | 630 | 10.733 | 15403.8 |
| 188 | 2022-08-02 01:58:13 | truncates | 4 | 165329 | 630 | 10.360 | 15958.4 |
| 187 | 2022-07-28 11:22:46 | truncates | 4 | 165329 | 630 | 10.720 | 15422.5 |
| 186 | 2022-06-24 09:10:22 | truncates | 4 | 165329 | 630 | 10.593 | 15607.4 |
| 185 | 2022-05-07 07:43:15 | truncates | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 184 | 2022-04-30 01:51:02 | truncates | 2 | 121436 | 4 | 3.250 | 37364.9 |
| 183 | 2022-01-26 07:33:41 | truncates | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 182 | 2021-12-08 08:19:32 | truncates | 1 | 81242 | 3 | 2.826 | 28748.1 |
| 181 | 2021-11-13 08:36:27 | truncates | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 180 | 2021-10-09 08:35:09 | truncates | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 179 | 2021-09-25 02:14:35 | truncates | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 178 | 2021-09-21 14:23:37 | truncates | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 177 | 2021-09-20 09:58:23 | truncates | 1 | 81242 | 3 | 1.563 | 51978.2 |
| 176 | 2021-09-14 09:04:53 | truncates | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 175 | 2021-05-12 00:25:59 | truncates | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 174 | 2021-04-10 19:39:24 | truncates | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 173 | 2021-03-14 19:58:41 | truncates | 1 | 81242 | 3 | 1.280 | 63470.3 |
| 172 | 2021-02-18 00:10:42 | truncates | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 171 | 2020-11-13 10:50:41 | truncates | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 170 | 2020-11-03 00:46:36 | truncates | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 169 | 2020-10-22 03:44:09 | truncates | 1 | 81242 | 3 | 1.263 | 64324.6 |