History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"celeste"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 285 | 2024-04-30 09:19:48 | celeste | 1 | 69583 | 3 | 4.393 | 15839.5 |
| 284 | 2024-04-28 06:34:25 | celeste | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 283 | 2024-04-01 17:31:17 | celeste | 3 | 134027 | 244 | 26.093 | 5136.5 |
| 282 | 2024-04-01 01:25:32 | celeste | 3 | 134027 | 244 | 9.986 | 13421.5 |
| 281 | 2024-03-31 06:05:40 | celeste | 3 | 134027 | 244 | 20.826 | 6435.6 |
| 280 | 2024-03-31 04:53:51 | celeste | 1 | 69583 | 3 | 2.186 | 31831.2 |
| 279 | 2024-03-31 04:22:51 | celeste | 3 | 134027 | 244 | 10.763 | 12452.6 |
| 278 | 2024-03-31 04:22:50 | celeste | 2 | 107671 | 7 | 5.110 | 21070.6 |
| 277 | 2024-03-31 01:20:21 | celeste | 3 | 134027 | 244 | 15.263 | 8781.2 |
| 276 | 2024-03-31 01:20:21 | celeste | 2 | 107671 | 7 | 8.766 | 12282.8 |
| 275 | 2024-03-31 00:56:08 | celeste | 1 | 69583 | 3 | 3.013 | 23094.3 |
| 274 | 2024-03-01 23:13:54 | celeste | 3 | 134027 | 244 | 8.736 | 15341.9 |
| 273 | 2024-02-29 16:15:08 | celeste | 2 | 107671 | 7 | 3.360 | 32044.9 |
| 272 | 2024-02-28 15:40:57 | celeste | 3 | 134027 | 244 | 17.000 | 7883.9 |
| 271 | 2024-02-28 15:40:58 | celeste | 2 | 107671 | 7 | 9.000 | 11963.4 |
| 270 | 2024-02-28 11:44:29 | celeste | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 269 | 2024-02-21 08:49:47 | celeste | 1 | 69583 | 3 | 3.343 | 20814.5 |
| 268 | 2024-02-15 23:31:38 | celeste | 1 | 69583 | 3 | 3.623 | 19205.9 |
| 267 | 2024-01-21 12:33:29 | celeste | 3 | 134027 | 244 | 6.140 | 21828.5 |
| 266 | 2024-01-21 12:33:27 | celeste | 2 | 107671 | 7 | 2.970 | 36252.9 |
| 265 | 2024-01-05 09:01:54 | celeste | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 264 | 2023-12-13 19:43:54 | celeste | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 263 | 2023-12-06 17:01:48 | celeste | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 262 | 2023-12-03 18:23:20 | celeste | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 261 | 2023-12-03 18:23:18 | celeste | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 260 | 2023-12-01 23:35:57 | celeste | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 259 | 2023-11-19 00:43:38 | celeste | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 258 | 2023-10-26 20:20:12 | celeste | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 257 | 2023-08-20 20:31:26 | celeste | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 256 | 2023-08-13 01:02:33 | celeste | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 255 | 2023-05-22 07:28:43 | celeste | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 254 | 2023-05-05 15:54:28 | celeste | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 253 | 2023-04-22 11:02:27 | celeste | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 252 | 2023-03-21 06:25:22 | celeste | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 251 | 2023-03-17 11:37:23 | celeste | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 250 | 2023-01-27 00:13:50 | celeste | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 249 | 2023-01-05 06:02:10 | celeste | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 248 | 2022-10-16 11:47:59 | celeste | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 247 | 2022-09-30 12:03:16 | celeste | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 246 | 2022-06-30 01:36:21 | celeste | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 245 | 2022-05-14 10:13:44 | celeste | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 244 | 2022-03-20 03:28:21 | celeste | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 243 | 2022-03-16 16:57:11 | celeste | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 242 | 2022-01-31 06:34:36 | celeste | 1 | 69583 | 3 | 1.346 | 51696.1 |
| 241 | 2021-12-15 04:00:24 | celeste | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 240 | 2021-12-02 23:56:55 | celeste | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 239 | 2021-11-24 06:57:41 | celeste | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 238 | 2021-10-26 10:45:53 | celeste | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 237 | 2021-08-23 07:31:58 | celeste | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 236 | 2021-06-19 13:26:25 | celeste | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 235 | 2021-05-22 13:17:30 | celeste | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 234 | 2021-03-30 17:38:55 | celeste | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 233 | 2021-03-04 12:19:48 | celeste | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 232 | 2021-02-20 10:41:10 | celeste | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 231 | 2021-01-14 06:36:13 | celeste | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 230 | 2020-11-16 21:52:17 | celeste | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 229 | 2020-11-04 19:32:00 | celeste | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 228 | 2020-10-28 15:26:36 | celeste | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 227 | 2020-10-26 08:52:18 | celeste | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 226 | 2020-10-25 01:08:54 | celeste | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 225 | 2020-10-01 10:13:09 | celeste | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 224 | 2020-09-04 21:39:01 | celeste | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 223 | 2020-08-15 11:22:27 | celeste | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 222 | 2020-08-12 13:31:24 | celeste | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 221 | 2020-08-11 11:09:44 | celeste | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 220 | 2020-08-09 10:39:20 | celeste | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 219 | 2020-08-08 13:18:55 | celeste | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 218 | 2020-05-10 21:17:10 | celeste | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 217 | 2020-05-04 00:39:12 | celeste | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 216 | 2020-04-18 14:15:36 | celeste | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 215 | 2020-04-17 14:58:22 | celeste | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 214 | 2020-04-15 14:16:51 | celeste | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 213 | 2020-03-30 08:56:20 | celeste | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 212 | 2020-03-25 02:03:15 | celeste | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 211 | 2020-03-24 14:19:47 | celeste | 1 | 69583 | 3 | 2.266 | 30707.4 |
| 210 | 2020-03-20 23:25:37 | celeste | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 209 | 2020-02-24 08:47:20 | celeste | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 208 | 2020-02-23 10:21:12 | celeste | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 207 | 2020-02-22 12:48:49 | celeste | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 206 | 2020-02-07 23:34:26 | celeste | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 205 | 2020-02-07 18:39:32 | celeste | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 204 | 2020-02-06 20:01:50 | celeste | 1 | 69583 | 3 | 2.593 | 26834.9 |
| 203 | 2020-02-04 11:57:47 | celeste | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 202 | 2020-02-02 01:33:11 | celeste | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 201 | 2020-02-01 19:50:22 | celeste | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 200 | 2020-01-27 23:49:39 | celeste | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 199 | 2020-01-27 07:11:59 | celeste | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 198 | 2020-01-19 05:04:30 | celeste | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 197 | 2020-01-15 06:08:49 | celeste | 2 | 107671 | 7 | 4.436 | 24272.1 |
| 196 | 2020-01-15 00:31:51 | celeste | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 195 | 2020-01-09 17:34:35 | celeste | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 194 | 2020-01-06 21:06:13 | celeste | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 193 | 2020-01-01 14:00:45 | celeste | 1 | 69583 | 3 | 2.373 | 29322.8 |
| 192 | 2019-12-29 06:10:24 | celeste | 1 | 69583 | 3 | 1.346 | 51696.1 |
| 191 | 2019-12-29 05:56:43 | celeste | 1 | 69583 | 3 | 2.016 | 34515.4 |
| 190 | 2019-11-12 08:06:27 | celeste | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 189 | 2019-10-31 20:14:54 | celeste | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 188 | 2019-10-07 16:02:10 | celeste | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 187 | 2019-09-21 23:29:41 | celeste | 1 | 69583 | 3 | 1.010 | 68894.1 |
| 186 | 2019-09-20 02:42:12 | celeste | 1 | 69583 | 3 | 1.030 | 67556.3 |