History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"theatre"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 342 | 2025-04-26 08:28:39 | theatre | 3 | 134027 | 197 | 21.066 | 6362.2 |
| 341 | 2025-04-26 06:47:00 | theatre | 3 | 134027 | 197 | 28.096 | 4770.3 |
| 340 | 2025-04-24 12:22:29 | theatre | 3 | 134027 | 197 | 26.190 | 5117.5 |
| 339 | 2025-04-23 10:09:30 | theatre | 2 | 107671 | 11 | 16.233 | 6632.8 |
| 338 | 2025-04-23 06:52:40 | theatre | 3 | 134027 | 197 | 44.673 | 3000.2 |
| 337 | 2025-04-21 17:50:18 | theatre | 3 | 134027 | 197 | 24.173 | 5544.5 |
| 336 | 2025-04-21 17:50:06 | theatre | 2 | 107671 | 11 | 19.640 | 5482.2 |
| 335 | 2025-04-20 17:45:13 | theatre | 1 | 69583 | 3 | 5.280 | 13178.6 |
| 334 | 2025-04-20 14:15:06 | theatre | 1 | 69583 | 3 | 5.343 | 13023.2 |
| 333 | 2025-04-20 14:13:59 | theatre | 1 | 69583 | 3 | 5.846 | 11902.7 |
| 332 | 2025-04-20 03:24:45 | theatre | 1 | 69583 | 3 | 4.550 | 15293.0 |
| 331 | 2025-04-14 19:52:48 | theatre | 1 | 69583 | 3 | 1.890 | 36816.4 |
| 330 | 2025-04-14 04:48:13 | theatre | 1 | 69583 | 3 | 7.780 | 8943.8 |
| 329 | 2025-04-04 03:40:06 | theatre | 1 | 69583 | 3 | 3.953 | 17602.6 |
| 328 | 2025-03-27 05:42:32 | theatre | 1 | 69583 | 3 | 3.156 | 22047.8 |
| 327 | 2025-03-20 18:47:25 | theatre | 1 | 69583 | 3 | 4.140 | 16807.5 |
| 326 | 2025-03-20 16:33:35 | theatre | 1 | 69583 | 3 | 3.390 | 20526.0 |
| 325 | 2025-03-20 04:08:24 | theatre | 1 | 69583 | 3 | 3.170 | 21950.5 |
| 324 | 2025-03-13 00:56:32 | theatre | 1 | 69583 | 3 | 3.833 | 18153.7 |
| 323 | 2025-02-27 10:48:56 | theatre | 1 | 69583 | 3 | 5.343 | 13023.2 |
| 322 | 2025-01-30 08:30:29 | theatre | 1 | 69583 | 3 | 2.843 | 24475.2 |
| 321 | 2025-01-28 12:02:46 | theatre | 1 | 69583 | 3 | 3.563 | 19529.3 |
| 320 | 2025-01-24 17:55:49 | theatre | 1 | 69583 | 3 | 2.813 | 24736.2 |
| 319 | 2025-01-05 11:54:24 | theatre | 1 | 69583 | 3 | 5.796 | 12005.3 |
| 318 | 2024-12-29 14:57:15 | theatre | 1 | 69583 | 3 | 5.936 | 11722.2 |
| 317 | 2024-12-24 17:49:07 | theatre | 1 | 69583 | 3 | 2.766 | 25156.5 |
| 316 | 2024-12-11 16:59:11 | theatre | 1 | 69583 | 3 | 5.610 | 12403.4 |
| 315 | 2024-12-06 07:48:28 | theatre | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 314 | 2024-11-20 02:05:48 | theatre | 2 | 107671 | 11 | 16.656 | 6464.4 |
| 313 | 2024-11-20 01:59:12 | theatre | 1 | 69583 | 3 | 2.703 | 25742.9 |
| 312 | 2024-11-12 16:53:03 | theatre | 3 | 134027 | 197 | 32.146 | 4169.3 |
| 311 | 2024-11-11 15:23:42 | theatre | 3 | 134027 | 197 | 31.516 | 4252.7 |
| 310 | 2024-11-11 13:19:59 | theatre | 3 | 134027 | 197 | 28.206 | 4751.7 |
| 309 | 2024-11-11 00:53:27 | theatre | 3 | 134027 | 197 | 32.206 | 4161.6 |
| 308 | 2024-11-11 00:53:28 | theatre | 2 | 107671 | 11 | 16.360 | 6581.4 |
| 307 | 2024-11-03 01:48:29 | theatre | 1 | 69583 | 3 | 8.440 | 8244.4 |
| 306 | 2024-10-19 23:27:42 | theatre | 1 | 69583 | 3 | 6.060 | 11482.3 |
| 305 | 2024-10-19 00:34:05 | theatre | 1 | 69583 | 3 | 3.720 | 18705.1 |
| 304 | 2024-09-29 23:22:07 | theatre | 1 | 69583 | 3 | 6.440 | 10804.8 |
| 303 | 2024-09-29 23:14:23 | theatre | 2 | 107671 | 11 | 23.016 | 4678.1 |
| 302 | 2024-09-27 07:04:11 | theatre | 3 | 134027 | 197 | 62.830 | 2133.2 |
| 301 | 2024-09-27 07:03:05 | theatre | 2 | 107671 | 11 | 21.530 | 5001.0 |
| 300 | 2024-09-26 03:56:49 | theatre | 3 | 134027 | 197 | 76.113 | 1760.9 |
| 299 | 2024-09-25 17:32:36 | theatre | 1 | 69583 | 3 | 7.813 | 8906.1 |
| 298 | 2024-09-19 13:27:00 | theatre | 1 | 69583 | 3 | 12.470 | 5580.0 |
| 297 | 2024-09-19 13:21:42 | theatre | 2 | 107671 | 11 | 10.986 | 9800.7 |
| 296 | 2024-09-17 22:56:50 | theatre | 3 | 134027 | 197 | 74.693 | 1794.4 |
| 295 | 2024-09-17 22:56:50 | theatre | 2 | 107671 | 11 | 33.520 | 3212.1 |
| 294 | 2024-09-17 22:54:59 | theatre | 1 | 69583 | 3 | 4.343 | 16021.9 |
| 293 | 2024-08-30 01:23:32 | theatre | 1 | 69583 | 3 | 6.533 | 10651.0 |
| 292 | 2024-08-18 20:21:08 | theatre | 1 | 69583 | 3 | 4.420 | 15742.8 |
| 291 | 2024-08-13 00:33:13 | theatre | 1 | 69583 | 3 | 4.846 | 14358.9 |
| 290 | 2024-07-20 02:19:54 | theatre | 1 | 69583 | 3 | 3.060 | 22739.5 |
| 289 | 2024-07-16 12:42:52 | theatre | 1 | 69583 | 3 | 2.376 | 29285.8 |
| 288 | 2024-07-14 02:00:41 | theatre | 1 | 69583 | 3 | 5.186 | 13417.5 |
| 287 | 2024-07-07 16:46:51 | theatre | 1 | 69583 | 3 | 2.076 | 33517.8 |
| 286 | 2024-06-30 14:02:01 | theatre | 1 | 69583 | 3 | 4.283 | 16246.3 |
| 285 | 2024-06-20 09:49:55 | theatre | 1 | 69583 | 3 | 4.720 | 14742.2 |
| 284 | 2024-06-05 10:28:54 | theatre | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 283 | 2024-06-04 21:05:29 | theatre | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 282 | 2024-05-30 13:26:55 | theatre | 1 | 69583 | 3 | 4.766 | 14599.9 |
| 281 | 2024-05-17 09:22:56 | theatre | 1 | 69583 | 3 | 1.563 | 44518.9 |
| 280 | 2024-05-09 07:28:35 | theatre | 1 | 69583 | 3 | 3.546 | 19623.0 |
| 279 | 2024-05-02 07:02:01 | theatre | 1 | 69583 | 3 | 1.813 | 38380.0 |
| 278 | 2024-03-09 04:25:52 | theatre | 3 | 134027 | 197 | 10.673 | 12557.6 |
| 277 | 2024-03-07 07:54:21 | theatre | 3 | 134027 | 197 | 12.420 | 10791.2 |
| 276 | 2024-03-07 07:54:22 | theatre | 2 | 107671 | 11 | 7.763 | 13869.8 |
| 275 | 2024-03-07 01:37:58 | theatre | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 274 | 2024-02-05 10:20:42 | theatre | 1 | 69583 | 3 | 2.560 | 27180.9 |
| 273 | 2024-01-25 02:04:52 | theatre | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 272 | 2024-01-20 23:30:52 | theatre | 2 | 107671 | 11 | 3.233 | 33303.7 |
| 271 | 2024-01-20 23:30:48 | theatre | 3 | 134027 | 197 | 6.046 | 22167.9 |
| 270 | 2023-12-13 06:52:45 | theatre | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 269 | 2023-11-27 13:12:01 | theatre | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 268 | 2023-11-20 07:34:32 | theatre | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 267 | 2023-11-19 23:01:51 | theatre | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 266 | 2023-11-19 02:02:19 | theatre | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 265 | 2023-09-27 18:30:11 | theatre | 1 | 69583 | 3 | 2.360 | 29484.3 |
| 264 | 2023-09-23 22:59:37 | theatre | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 263 | 2023-09-12 14:01:01 | theatre | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 262 | 2023-09-07 07:57:11 | theatre | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 261 | 2023-09-03 18:16:51 | theatre | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 260 | 2023-06-21 04:39:29 | theatre | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 259 | 2023-04-26 07:34:23 | theatre | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 258 | 2023-04-02 08:56:05 | theatre | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 257 | 2023-01-15 06:14:34 | theatre | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 256 | 2022-12-22 15:01:27 | theatre | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 255 | 2022-11-08 11:49:52 | theatre | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 254 | 2022-09-04 18:28:18 | theatre | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 253 | 2022-08-02 13:51:00 | theatre | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 252 | 2022-06-27 20:12:30 | theatre | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 251 | 2022-03-08 03:21:24 | theatre | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 250 | 2022-03-07 01:58:02 | theatre | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 249 | 2021-12-23 21:41:01 | theatre | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 248 | 2021-12-21 18:13:43 | theatre | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 247 | 2021-11-04 07:12:18 | theatre | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 246 | 2021-10-31 21:04:39 | theatre | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 245 | 2021-10-26 16:49:16 | theatre | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 244 | 2021-10-01 23:12:51 | theatre | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 243 | 2021-09-29 19:17:04 | theatre | 1 | 69583 | 3 | 1.093 | 63662.4 |