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 |
| 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 |
| 224 | 2023-09-14 08:49:51 | terrain | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 223 | 2023-08-06 02:53:22 | terrain | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 222 | 2023-05-15 11:01:54 | terrain | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 221 | 2023-05-01 01:45:40 | terrain | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 220 | 2023-02-21 18:32:56 | terrain | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 219 | 2023-01-22 09:26:01 | terrain | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 218 | 2022-12-17 23:14:36 | terrain | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 217 | 2022-11-25 09:06:43 | terrain | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 216 | 2022-11-22 16:32:33 | terrain | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 215 | 2022-09-16 11:50:44 | terrain | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 214 | 2022-08-25 05:14:03 | terrain | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 213 | 2022-04-26 07:02:02 | terrain | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 212 | 2022-04-08 16:55:59 | terrain | 1 | 69583 | 3 | 1.440 | 48321.5 |
| 211 | 2022-01-19 02:30:55 | terrain | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 210 | 2022-01-06 01:15:38 | terrain | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 209 | 2022-01-03 21:47:42 | terrain | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 208 | 2022-01-03 05:57:51 | terrain | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 207 | 2021-12-31 00:37:45 | terrain | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 206 | 2021-12-05 19:37:51 | terrain | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 205 | 2021-11-20 18:39:26 | terrain | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 204 | 2021-11-18 16:59:04 | terrain | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 203 | 2021-11-11 23:27:46 | terrain | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 202 | 2021-11-11 04:05:10 | terrain | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 201 | 2021-09-11 02:43:54 | terrain | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 200 | 2021-09-07 20:23:19 | terrain | 1 | 69583 | 3 | 1.643 | 42351.2 |
| 199 | 2021-07-18 13:59:16 | terrain | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 198 | 2021-05-31 14:24:37 | terrain | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 197 | 2021-04-06 04:15:43 | terrain | 1 | 69583 | 3 | 1.233 | 56433.9 |