History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"terrain"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 324 | 2025-06-30 18:10:54 | terrain | 1 | 69583 | 3 | 6.140 | 11332.7 |
| 323 | 2025-06-25 12:55:46 | terrain | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 322 | 2025-06-23 17:55:08 | terrain | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 321 | 2025-06-23 11:55:30 | terrain | 1 | 69583 | 3 | 1.593 | 43680.5 |
| 320 | 2025-06-21 05:21:04 | terrain | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 319 | 2025-06-20 03:47:25 | terrain | 3 | 134027 | 190 | 40.596 | 3301.5 |
| 318 | 2025-06-16 07:01:42 | terrain | 3 | 134027 | 190 | 29.796 | 4498.2 |
| 317 | 2025-06-15 22:03:53 | terrain | 3 | 134027 | 190 | 46.706 | 2869.6 |
| 316 | 2025-06-14 13:59:19 | terrain | 3 | 134027 | 190 | 32.986 | 4063.1 |
| 315 | 2025-06-14 02:53:21 | terrain | 1 | 69583 | 3 | 5.360 | 12981.9 |
| 314 | 2025-06-07 17:46:27 | terrain | 3 | 134027 | 190 | 5.843 | 22938.0 |
| 313 | 2025-06-05 15:20:11 | terrain | 1 | 69583 | 3 | 1.293 | 53815.2 |
| 312 | 2025-06-05 10:23:16 | terrain | 1 | 69583 | 3 | 6.643 | 10474.6 |
| 311 | 2025-06-04 12:47:00 | terrain | 1 | 69583 | 3 | 6.296 | 11051.9 |
| 310 | 2025-06-03 22:11:19 | terrain | 3 | 134027 | 190 | 23.470 | 5710.6 |
| 309 | 2025-05-31 06:54:51 | terrain | 1 | 69583 | 3 | 6.516 | 10678.8 |
| 308 | 2025-05-28 08:01:21 | terrain | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 307 | 2025-05-22 12:12:00 | terrain | 1 | 69583 | 3 | 5.610 | 12403.4 |
| 306 | 2025-05-22 05:27:20 | terrain | 1 | 69583 | 3 | 4.093 | 17000.5 |
| 305 | 2025-05-19 04:14:43 | terrain | 1 | 69583 | 3 | 6.970 | 9983.2 |
| 304 | 2025-05-18 03:01:14 | terrain | 3 | 134027 | 190 | 17.970 | 7458.4 |
| 303 | 2025-05-16 10:02:25 | terrain | 2 | 107671 | 25 | 10.953 | 9830.3 |
| 302 | 2025-05-16 09:09:44 | terrain | 3 | 134027 | 190 | 23.423 | 5722.0 |
| 301 | 2025-05-15 22:07:58 | terrain | 3 | 134027 | 190 | 34.080 | 3932.7 |
| 300 | 2025-05-15 06:34:53 | terrain | 3 | 134027 | 190 | 7.296 | 18369.9 |
| 299 | 2025-05-13 13:16:24 | terrain | 3 | 134027 | 190 | 7.076 | 18941.1 |
| 298 | 2025-05-13 09:05:14 | terrain | 2 | 107671 | 25 | 5.486 | 19626.5 |
| 297 | 2025-05-11 02:17:09 | terrain | 1 | 69583 | 3 | 3.486 | 19960.7 |
| 296 | 2025-05-08 14:33:13 | terrain | 1 | 69583 | 3 | 2.813 | 24736.2 |
| 295 | 2025-04-30 06:56:31 | terrain | 1 | 69583 | 3 | 6.126 | 11358.6 |
| 294 | 2025-04-25 02:29:32 | terrain | 1 | 69583 | 3 | 1.846 | 37693.9 |
| 293 | 2025-04-21 12:03:47 | terrain | 1 | 69583 | 3 | 6.203 | 11217.6 |
| 292 | 2025-04-20 04:28:21 | terrain | 1 | 69583 | 3 | 5.813 | 11970.2 |
| 291 | 2025-04-09 13:33:18 | terrain | 3 | 134027 | 190 | 34.536 | 3880.8 |
| 290 | 2025-04-08 01:35:31 | terrain | 1 | 69583 | 3 | 7.500 | 9277.7 |
| 289 | 2025-04-06 14:20:18 | terrain | 1 | 69583 | 3 | 3.333 | 20877.0 |
| 288 | 2025-03-31 14:35:38 | terrain | 1 | 69583 | 3 | 3.810 | 18263.3 |
| 287 | 2025-03-29 07:57:20 | terrain | 1 | 69583 | 3 | 5.516 | 12614.8 |
| 286 | 2025-03-20 14:24:09 | terrain | 1 | 69583 | 3 | 7.203 | 9660.3 |
| 285 | 2025-03-20 05:53:12 | terrain | 1 | 69583 | 3 | 8.593 | 8097.6 |
| 284 | 2025-03-08 15:31:08 | terrain | 1 | 69583 | 3 | 4.110 | 16930.2 |
| 283 | 2025-03-05 19:18:25 | terrain | 1 | 69583 | 3 | 12.393 | 5614.7 |
| 282 | 2025-02-27 20:29:50 | terrain | 1 | 69583 | 3 | 7.093 | 9810.1 |
| 281 | 2025-02-25 21:24:56 | terrain | 3 | 134027 | 190 | 50.750 | 2640.9 |
| 280 | 2025-02-24 21:19:56 | terrain | 3 | 134027 | 190 | 39.156 | 3422.9 |
| 279 | 2025-02-24 20:15:59 | terrain | 3 | 134027 | 190 | 33.626 | 3985.8 |
| 278 | 2025-02-24 16:19:15 | terrain | 3 | 134027 | 190 | 20.563 | 6517.9 |
| 277 | 2025-02-09 10:01:09 | terrain | 1 | 69583 | 3 | 5.830 | 11935.3 |
| 276 | 2025-01-29 15:33:22 | terrain | 1 | 69583 | 3 | 5.656 | 12302.5 |
| 275 | 2025-01-28 15:09:13 | terrain | 1 | 69583 | 3 | 3.030 | 22964.7 |
| 274 | 2025-01-04 06:26:10 | terrain | 1 | 69583 | 3 | 3.670 | 18959.9 |
| 273 | 2024-12-28 14:34:21 | terrain | 1 | 69583 | 3 | 2.393 | 29077.7 |
| 272 | 2024-12-19 21:53:24 | terrain | 2 | 107671 | 25 | 3.376 | 31893.1 |
| 271 | 2024-12-19 21:53:11 | terrain | 3 | 134027 | 190 | 6.733 | 19906.0 |
| 270 | 2024-12-16 06:13:21 | terrain | 3 | 134027 | 190 | 28.236 | 4746.7 |
| 269 | 2024-12-15 18:44:03 | terrain | 3 | 134027 | 190 | 43.940 | 3050.2 |
| 268 | 2024-12-13 21:18:59 | terrain | 1 | 69583 | 3 | 2.593 | 26834.9 |
| 267 | 2024-12-09 19:25:46 | terrain | 1 | 69583 | 3 | 3.030 | 22964.7 |
| 266 | 2024-12-02 04:48:32 | terrain | 3 | 134027 | 190 | 29.253 | 4581.6 |
| 265 | 2024-11-27 15:54:06 | terrain | 1 | 69583 | 3 | 3.466 | 20075.9 |
| 264 | 2024-11-16 17:31:45 | terrain | 3 | 134027 | 190 | 32.986 | 4063.1 |
| 263 | 2024-11-15 00:52:44 | terrain | 3 | 134027 | 190 | 33.550 | 3994.8 |
| 262 | 2024-11-14 14:32:23 | terrain | 3 | 134027 | 190 | 7.456 | 17975.7 |
| 261 | 2024-11-14 14:32:12 | terrain | 2 | 107671 | 25 | 3.420 | 31482.7 |
| 260 | 2024-11-11 18:41:19 | terrain | 2 | 107671 | 25 | 21.236 | 5070.2 |
| 259 | 2024-11-09 11:23:04 | terrain | 1 | 69583 | 3 | 6.016 | 11566.3 |
| 258 | 2024-10-28 13:53:05 | terrain | 1 | 69583 | 3 | 4.953 | 14048.7 |
| 257 | 2024-10-24 08:15:54 | terrain | 1 | 69583 | 3 | 4.983 | 13964.1 |
| 256 | 2024-09-28 12:45:05 | terrain | 1 | 69583 | 3 | 8.703 | 7995.3 |
| 255 | 2024-09-16 15:52:45 | terrain | 1 | 69583 | 3 | 5.876 | 11841.9 |
| 254 | 2024-09-04 23:33:13 | terrain | 1 | 69583 | 3 | 8.873 | 7842.1 |
| 253 | 2024-09-01 07:12:02 | terrain | 1 | 69583 | 3 | 12.580 | 5531.2 |
| 252 | 2024-08-29 08:53:40 | terrain | 1 | 69583 | 3 | 5.623 | 12374.7 |
| 251 | 2024-08-27 12:05:19 | terrain | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 250 | 2024-08-12 19:23:54 | terrain | 1 | 69583 | 3 | 10.516 | 6616.9 |
| 249 | 2024-08-12 03:28:20 | terrain | 1 | 69583 | 3 | 5.953 | 11688.7 |
| 248 | 2024-08-09 19:01:10 | terrain | 1 | 69583 | 3 | 6.236 | 11158.3 |
| 247 | 2024-07-22 08:48:07 | terrain | 1 | 69583 | 3 | 9.483 | 7337.7 |
| 246 | 2024-07-01 06:22:25 | terrain | 1 | 69583 | 3 | 3.250 | 21410.2 |
| 245 | 2024-06-29 17:39:32 | terrain | 1 | 69583 | 3 | 5.220 | 13330.1 |
| 244 | 2024-06-27 11:20:44 | terrain | 1 | 69583 | 3 | 4.406 | 15792.8 |
| 243 | 2024-06-27 05:20:40 | terrain | 1 | 69583 | 3 | 6.266 | 11104.9 |
| 242 | 2024-06-16 13:23:52 | terrain | 1 | 69583 | 3 | 6.170 | 11277.6 |
| 241 | 2024-06-15 14:43:20 | terrain | 1 | 69583 | 3 | 4.546 | 15306.4 |
| 240 | 2024-05-27 21:32:23 | terrain | 1 | 69583 | 3 | 4.700 | 14804.9 |
| 239 | 2024-05-18 11:50:46 | terrain | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 238 | 2024-05-06 22:30:18 | terrain | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 237 | 2024-03-29 21:36:53 | terrain | 1 | 69583 | 3 | 1.716 | 40549.5 |
| 236 | 2024-02-27 08:57:05 | terrain | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 235 | 2024-01-26 00:00:27 | terrain | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 234 | 2023-12-21 23:43:24 | terrain | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 233 | 2023-12-08 17:09:15 | terrain | 1 | 69583 | 3 | 4.093 | 17000.5 |
| 232 | 2023-11-26 16:13:59 | terrain | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 231 | 2023-11-20 08:14:35 | terrain | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 230 | 2023-11-03 19:34:53 | terrain | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 229 | 2023-10-16 11:27:48 | terrain | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 228 | 2023-10-09 05:06:31 | terrain | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 227 | 2023-10-07 08:32:12 | terrain | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 226 | 2023-09-28 03:52:45 | terrain | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 225 | 2023-09-18 07:23:50 | terrain | 1 | 69583 | 3 | 1.076 | 64668.2 |