History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"unshift"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 308 | 2024-04-23 12:46:45 | unshift | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 307 | 2024-04-19 06:02:20 | unshift | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 306 | 2024-04-15 23:17:30 | unshift | 1 | 69583 | 3 | 5.640 | 12337.4 |
| 305 | 2024-04-01 03:28:20 | unshift | 2 | 107671 | 10 | 5.736 | 18771.1 |
| 304 | 2024-03-31 05:19:16 | unshift | 3 | 134027 | 81 | 12.626 | 10615.2 |
| 303 | 2024-03-30 02:29:17 | unshift | 3 | 134027 | 81 | 14.143 | 9476.6 |
| 302 | 2024-03-30 02:29:16 | unshift | 2 | 107671 | 10 | 3.533 | 30475.8 |
| 301 | 2024-03-29 23:48:01 | unshift | 3 | 134027 | 81 | 18.096 | 7406.4 |
| 300 | 2024-03-29 23:48:00 | unshift | 2 | 107671 | 10 | 9.253 | 11636.3 |
| 299 | 2024-03-29 23:47:08 | unshift | 1 | 69583 | 3 | 1.470 | 47335.4 |
| 298 | 2024-03-23 17:11:06 | unshift | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 297 | 2024-03-18 20:36:49 | unshift | 4 | 151207 | 719 | 12.140 | 12455.3 |
| 296 | 2024-03-14 14:14:34 | unshift | 4 | 151207 | 719 | 42.360 | 3569.6 |
| 295 | 2024-03-13 17:38:05 | unshift | 4 | 151207 | 719 | 20.440 | 7397.6 |
| 294 | 2024-03-11 13:19:05 | unshift | 4 | 151207 | 719 | 24.736 | 6112.8 |
| 293 | 2024-03-11 05:07:51 | unshift | 4 | 151207 | 719 | 20.563 | 7353.4 |
| 292 | 2024-03-11 05:07:32 | unshift | 4 | 151207 | 719 | 36.500 | 4142.7 |
| 291 | 2024-03-11 05:07:32 | unshift | 3 | 134027 | 81 | 12.750 | 10511.9 |
| 290 | 2024-03-11 05:07:41 | unshift | 1 | 69583 | 3 | 2.686 | 25905.8 |
| 289 | 2024-03-11 05:07:32 | unshift | 2 | 107671 | 10 | 4.953 | 21738.5 |
| 288 | 2024-03-11 05:07:29 | unshift | 1 | 69583 | 3 | 2.656 | 26198.4 |
| 287 | 2024-03-01 06:40:53 | unshift | 2 | 107671 | 10 | 3.296 | 32667.2 |
| 286 | 2024-03-01 06:40:17 | unshift | 3 | 134027 | 81 | 7.703 | 17399.3 |
| 285 | 2024-02-26 03:28:28 | unshift | 3 | 134027 | 81 | 12.953 | 10347.2 |
| 284 | 2024-02-22 17:55:22 | unshift | 3 | 134027 | 81 | 7.470 | 17942.0 |
| 283 | 2024-02-22 17:55:24 | unshift | 2 | 107671 | 10 | 3.513 | 30649.3 |
| 282 | 2024-02-22 12:09:37 | unshift | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 281 | 2024-02-04 20:11:39 | unshift | 4 | 151207 | 719 | 30.516 | 4955.0 |
| 280 | 2024-02-04 19:00:59 | unshift | 4 | 151207 | 719 | 12.846 | 11770.7 |
| 279 | 2024-01-26 20:08:15 | unshift | 4 | 151207 | 719 | 11.923 | 12682.0 |
| 278 | 2024-01-18 10:09:33 | unshift | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 277 | 2024-01-13 04:48:45 | unshift | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 276 | 2024-01-02 04:40:05 | unshift | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 275 | 2023-12-18 16:52:14 | unshift | 4 | 151207 | 719 | 11.063 | 13667.8 |
| 274 | 2023-12-10 16:50:14 | unshift | 4 | 151207 | 719 | 11.563 | 13076.8 |
| 273 | 2023-12-10 16:50:15 | unshift | 3 | 134027 | 81 | 6.876 | 19492.0 |
| 272 | 2023-12-10 16:50:12 | unshift | 2 | 107671 | 10 | 3.160 | 34073.1 |
| 271 | 2023-12-09 07:43:00 | unshift | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 270 | 2023-11-11 01:50:44 | unshift | 1 | 69583 | 3 | 1.013 | 68690.0 |
| 269 | 2023-11-06 02:44:26 | unshift | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 268 | 2023-10-23 19:50:11 | unshift | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 267 | 2023-10-15 07:33:35 | unshift | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 266 | 2023-09-21 15:12:09 | unshift | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 265 | 2023-08-18 21:33:43 | unshift | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 264 | 2023-08-17 07:37:49 | unshift | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 263 | 2023-08-14 00:26:15 | unshift | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 262 | 2023-05-19 01:32:40 | unshift | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 261 | 2023-03-30 19:27:41 | unshift | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 260 | 2023-03-14 11:26:44 | unshift | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 259 | 2023-01-14 01:31:50 | unshift | 4 | 151207 | 719 | 11.860 | 12749.3 |
| 258 | 2023-01-04 21:25:27 | unshift | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 257 | 2022-11-29 22:51:31 | unshift | 4 | 151207 | 719 | 10.173 | 14863.6 |
| 256 | 2022-11-26 04:23:17 | unshift | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 255 | 2022-11-21 07:22:02 | unshift | 4 | 151207 | 719 | 9.953 | 15192.1 |
| 254 | 2022-11-20 17:44:33 | unshift | 4 | 151207 | 719 | 9.513 | 15894.8 |
| 253 | 2022-11-15 09:23:27 | unshift | 4 | 151207 | 719 | 11.220 | 13476.6 |
| 252 | 2022-11-11 10:28:05 | unshift | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 251 | 2022-10-13 15:26:14 | unshift | 4 | 151207 | 719 | 9.796 | 15435.6 |
| 250 | 2022-09-22 23:56:19 | unshift | 4 | 151207 | 719 | 10.453 | 14465.4 |
| 249 | 2022-08-31 12:42:21 | unshift | 4 | 151207 | 719 | 10.110 | 14956.2 |
| 248 | 2022-08-16 06:36:50 | unshift | 4 | 151207 | 719 | 9.780 | 15460.8 |
| 247 | 2022-08-07 04:22:37 | unshift | 4 | 151207 | 719 | 9.750 | 15508.4 |
| 246 | 2022-07-27 17:03:14 | unshift | 4 | 151207 | 719 | 10.173 | 14863.6 |
| 245 | 2022-07-07 23:35:18 | unshift | 4 | 151207 | 719 | 9.513 | 15894.8 |
| 244 | 2022-06-29 06:00:19 | unshift | 4 | 151207 | 719 | 9.453 | 15995.7 |
| 243 | 2022-06-23 12:08:16 | unshift | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 242 | 2022-06-19 18:15:56 | unshift | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 241 | 2022-04-30 18:56:28 | unshift | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 240 | 2022-01-25 01:11:11 | unshift | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 239 | 2022-01-19 19:48:59 | unshift | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 238 | 2022-01-17 16:07:07 | unshift | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 237 | 2021-11-09 07:56:28 | unshift | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 236 | 2021-11-07 04:50:14 | unshift | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 235 | 2021-10-09 12:51:43 | unshift | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 234 | 2021-10-07 11:10:11 | unshift | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 233 | 2021-09-27 15:05:08 | unshift | 4 | 151207 | 719 | 11.140 | 13573.3 |
| 232 | 2021-09-19 09:38:27 | unshift | 1 | 69583 | 3 | 1.580 | 44039.9 |
| 231 | 2021-08-08 19:35:26 | unshift | 3 | 134027 | 81 | 6.326 | 21186.7 |
| 230 | 2021-07-11 08:35:16 | unshift | 3 | 134027 | 81 | 6.123 | 21889.1 |
| 229 | 2021-06-21 01:19:28 | unshift | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 228 | 2021-06-18 12:12:52 | unshift | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 227 | 2021-06-08 18:46:54 | unshift | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 226 | 2021-03-09 18:50:31 | unshift | 1 | 69583 | 3 | 1.796 | 38743.3 |
| 225 | 2021-03-01 20:42:13 | unshift | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 224 | 2020-11-13 07:29:09 | unshift | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 223 | 2020-10-25 07:42:50 | unshift | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 222 | 2020-10-23 07:59:43 | unshift | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 221 | 2020-10-12 20:52:52 | unshift | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 220 | 2020-10-03 09:15:54 | unshift | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 219 | 2020-07-21 03:38:17 | unshift | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 218 | 2020-07-17 19:39:09 | unshift | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 217 | 2020-06-10 04:34:22 | unshift | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 216 | 2020-04-06 16:49:35 | unshift | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 215 | 2020-03-29 06:03:56 | unshift | 4 | 151207 | 719 | 10.593 | 14274.2 |
| 214 | 2020-03-29 02:23:54 | unshift | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 213 | 2020-03-29 00:09:21 | unshift | 4 | 151207 | 719 | 12.780 | 11831.5 |
| 212 | 2020-03-28 21:48:22 | unshift | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 211 | 2020-03-28 13:49:27 | unshift | 4 | 151207 | 719 | 10.266 | 14728.9 |
| 210 | 2020-03-23 00:01:58 | unshift | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 209 | 2020-02-29 13:14:33 | unshift | 4 | 151207 | 719 | 32.156 | 4702.3 |