History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trumperies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 334 | 2024-05-09 19:17:25 | trumperies | 1 | 67641 | 1 | 2.563 | 26391.3 |
| 333 | 2024-05-06 10:30:57 | trumperies | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 332 | 2024-05-05 00:20:47 | trumperies | 3 | 140603 | 31 | 7.126 | 19731.0 |
| 331 | 2024-05-05 00:20:43 | trumperies | 2 | 108824 | 1 | 3.326 | 32719.2 |
| 330 | 2024-05-05 00:09:47 | trumperies | 1 | 67641 | 1 | 1.296 | 52192.1 |
| 329 | 2024-04-30 18:28:02 | trumperies | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 328 | 2024-04-29 11:48:13 | trumperies | 4 | 161450 | 243 | 32.626 | 4948.5 |
| 327 | 2024-04-29 01:38:36 | trumperies | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 326 | 2024-04-28 10:41:53 | trumperies | 1 | 67641 | 1 | 1.296 | 52192.1 |
| 325 | 2024-04-28 05:54:41 | trumperies | 4 | 161450 | 243 | 34.563 | 4671.2 |
| 324 | 2024-04-27 19:31:56 | trumperies | 4 | 161450 | 243 | 12.580 | 12833.9 |
| 323 | 2024-04-01 06:47:47 | trumperies | 4 | 161450 | 243 | 17.470 | 9241.6 |
| 322 | 2024-03-31 20:40:58 | trumperies | 1 | 67641 | 1 | 1.296 | 52192.1 |
| 321 | 2024-03-30 01:52:40 | trumperies | 1 | 67641 | 1 | 1.453 | 46552.6 |
| 320 | 2024-03-29 07:41:43 | trumperies | 3 | 140603 | 31 | 23.376 | 6014.8 |
| 319 | 2024-03-28 23:02:53 | trumperies | 1 | 67641 | 1 | 1.153 | 58665.2 |
| 318 | 2024-03-26 18:15:17 | trumperies | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 317 | 2024-03-26 00:09:14 | trumperies | 4 | 161450 | 243 | 30.110 | 5362.0 |
| 316 | 2024-03-24 19:17:43 | trumperies | 4 | 161450 | 243 | 38.516 | 4191.8 |
| 315 | 2024-03-23 09:17:35 | trumperies | 4 | 161450 | 243 | 28.206 | 5724.0 |
| 314 | 2024-03-22 21:04:26 | trumperies | 4 | 161450 | 243 | 20.143 | 8015.2 |
| 313 | 2024-03-22 21:04:27 | trumperies | 3 | 140603 | 31 | 14.456 | 9726.3 |
| 312 | 2024-03-22 21:04:23 | trumperies | 2 | 108824 | 1 | 7.236 | 15039.2 |
| 311 | 2024-03-22 20:53:21 | trumperies | 1 | 67641 | 1 | 1.000 | 67641.0 |
| 310 | 2024-03-11 19:17:33 | trumperies | 1 | 67641 | 1 | 4.156 | 16275.5 |
| 309 | 2024-02-26 07:50:00 | trumperies | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 308 | 2024-01-30 02:00:01 | trumperies | 3 | 140603 | 31 | 9.593 | 14656.8 |
| 307 | 2024-01-30 00:59:23 | trumperies | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 306 | 2024-01-25 23:10:15 | trumperies | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 305 | 2024-01-16 23:30:59 | trumperies | 3 | 140603 | 31 | 6.750 | 20830.1 |
| 304 | 2024-01-11 06:06:26 | trumperies | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 303 | 2023-12-04 08:34:44 | trumperies | 4 | 161450 | 243 | 21.360 | 7558.5 |
| 302 | 2023-11-07 04:21:20 | trumperies | 3 | 140603 | 31 | 5.423 | 25927.2 |
| 301 | 2023-11-03 15:17:31 | trumperies | 1 | 67641 | 1 | 1.033 | 65480.2 |
| 300 | 2023-10-26 22:41:14 | trumperies | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 299 | 2023-09-27 06:39:27 | trumperies | 1 | 67641 | 1 | 1.033 | 65480.2 |
| 298 | 2023-09-03 15:21:26 | trumperies | 4 | 161450 | 243 | 10.720 | 15060.6 |
| 297 | 2023-09-02 17:56:42 | trumperies | 4 | 161450 | 243 | 9.920 | 16275.2 |
| 296 | 2023-09-01 14:58:51 | trumperies | 4 | 161450 | 243 | 9.156 | 17633.2 |
| 295 | 2023-08-30 23:48:09 | trumperies | 4 | 161450 | 243 | 9.406 | 17164.6 |
| 294 | 2023-08-26 15:16:24 | trumperies | 1 | 67641 | 1 | 1.106 | 61158.2 |
| 293 | 2023-08-11 20:24:51 | trumperies | 3 | 140603 | 31 | 6.453 | 21788.8 |
| 292 | 2023-06-02 08:48:01 | trumperies | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 291 | 2023-05-30 18:25:29 | trumperies | 1 | 67641 | 1 | 0.983 | 68810.8 |
| 290 | 2023-05-18 22:04:52 | trumperies | 4 | 161450 | 243 | 10.733 | 15042.4 |
| 289 | 2023-05-06 12:11:09 | trumperies | 4 | 161450 | 243 | 9.703 | 16639.2 |
| 288 | 2023-04-20 21:41:26 | trumperies | 3 | 140603 | 31 | 5.220 | 26935.4 |
| 287 | 2023-03-24 12:01:20 | trumperies | 1 | 67641 | 1 | 1.000 | 67641.0 |
| 286 | 2023-03-22 17:05:33 | trumperies | 4 | 161450 | 243 | 9.110 | 17722.3 |
| 285 | 2023-02-24 01:31:38 | trumperies | 4 | 161450 | 243 | 9.033 | 17873.4 |
| 284 | 2023-01-26 11:44:46 | trumperies | 3 | 140603 | 31 | 5.906 | 23806.8 |
| 283 | 2023-01-23 18:41:38 | trumperies | 1 | 67641 | 1 | 0.970 | 69733.0 |
| 282 | 2023-01-08 19:49:52 | trumperies | 1 | 67641 | 1 | 1.093 | 61885.6 |
| 281 | 2022-12-05 05:30:21 | trumperies | 4 | 161450 | 243 | 9.140 | 17664.1 |
| 280 | 2022-11-07 16:52:42 | trumperies | 3 | 140603 | 31 | 6.140 | 22899.5 |
| 279 | 2022-10-13 06:21:20 | trumperies | 1 | 67641 | 1 | 0.983 | 68810.8 |
| 278 | 2022-08-24 18:03:43 | trumperies | 1 | 67641 | 1 | 1.013 | 66773.0 |
| 277 | 2022-07-12 02:34:37 | trumperies | 4 | 161450 | 243 | 9.783 | 16503.1 |
| 276 | 2022-06-04 08:04:27 | trumperies | 1 | 67641 | 1 | 1.000 | 67641.0 |
| 275 | 2022-06-02 01:39:56 | trumperies | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 274 | 2022-05-18 21:31:08 | trumperies | 3 | 140603 | 31 | 5.560 | 25288.3 |
| 273 | 2022-05-17 05:36:10 | trumperies | 1 | 67641 | 1 | 0.986 | 68601.4 |
| 272 | 2022-05-16 04:55:26 | trumperies | 1 | 67641 | 1 | 1.110 | 60937.8 |
| 271 | 2022-04-25 14:30:08 | trumperies | 3 | 140603 | 31 | 5.800 | 24241.9 |
| 270 | 2022-03-27 08:01:32 | trumperies | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 269 | 2022-03-15 19:19:15 | trumperies | 3 | 140603 | 31 | 10.486 | 13408.6 |
| 268 | 2022-03-15 01:33:22 | trumperies | 3 | 140603 | 31 | 7.000 | 20086.1 |
| 267 | 2022-03-14 10:50:15 | trumperies | 3 | 140603 | 31 | 7.093 | 19822.8 |
| 266 | 2022-03-13 18:00:37 | trumperies | 3 | 140603 | 31 | 5.376 | 26153.8 |
| 265 | 2022-03-13 00:38:02 | trumperies | 3 | 140603 | 31 | 6.000 | 23433.8 |
| 264 | 2022-03-12 21:32:26 | trumperies | 3 | 140603 | 31 | 5.656 | 24859.1 |
| 263 | 2022-03-12 05:37:04 | trumperies | 3 | 140603 | 31 | 5.580 | 25197.7 |
| 262 | 2022-02-24 11:47:08 | trumperies | 3 | 140603 | 31 | 7.326 | 19192.3 |
| 261 | 2022-02-23 23:55:42 | trumperies | 3 | 140603 | 31 | 7.060 | 19915.4 |
| 260 | 2022-02-23 06:32:03 | trumperies | 3 | 140603 | 31 | 5.640 | 24929.6 |
| 259 | 2022-02-22 19:13:19 | trumperies | 3 | 140603 | 31 | 5.753 | 24439.9 |
| 258 | 2022-02-22 04:15:32 | trumperies | 3 | 140603 | 31 | 5.860 | 23993.7 |
| 257 | 2022-02-21 06:45:01 | trumperies | 3 | 140603 | 31 | 5.563 | 25274.7 |
| 256 | 2022-02-20 23:20:27 | trumperies | 3 | 140603 | 31 | 5.330 | 26379.5 |
| 255 | 2022-02-20 13:29:21 | trumperies | 3 | 140603 | 31 | 5.280 | 26629.4 |
| 254 | 2022-02-19 12:26:07 | trumperies | 3 | 140603 | 31 | 5.593 | 25139.1 |
| 253 | 2022-02-19 02:15:09 | trumperies | 3 | 140603 | 31 | 5.750 | 24452.7 |
| 252 | 2022-02-18 15:55:30 | trumperies | 3 | 140603 | 31 | 5.750 | 24452.7 |
| 251 | 2022-02-18 04:30:24 | trumperies | 3 | 140603 | 31 | 6.423 | 21890.5 |
| 250 | 2022-02-17 16:12:08 | trumperies | 3 | 140603 | 31 | 5.373 | 26168.4 |
| 249 | 2022-02-16 23:44:39 | trumperies | 3 | 140603 | 31 | 5.516 | 25490.0 |
| 248 | 2022-02-16 07:13:39 | trumperies | 3 | 140603 | 31 | 5.343 | 26315.4 |
| 247 | 2022-02-15 14:56:08 | trumperies | 3 | 140603 | 31 | 9.953 | 14126.7 |
| 246 | 2022-02-14 18:28:04 | trumperies | 3 | 140603 | 31 | 6.406 | 21948.6 |
| 245 | 2022-02-14 01:21:20 | trumperies | 3 | 140603 | 31 | 5.330 | 26379.5 |
| 244 | 2022-02-13 16:02:47 | trumperies | 3 | 140603 | 31 | 6.423 | 21890.5 |
| 243 | 2022-02-11 02:18:19 | trumperies | 3 | 140603 | 31 | 5.800 | 24241.9 |
| 242 | 2022-02-10 08:34:45 | trumperies | 3 | 140603 | 31 | 6.376 | 22051.9 |
| 241 | 2022-02-09 20:20:56 | trumperies | 3 | 140603 | 31 | 5.530 | 25425.5 |
| 240 | 2022-02-09 03:11:19 | trumperies | 3 | 140603 | 31 | 7.050 | 19943.7 |
| 239 | 2022-02-08 02:16:36 | trumperies | 3 | 140603 | 31 | 5.376 | 26153.8 |
| 238 | 2022-01-25 14:18:34 | trumperies | 3 | 140603 | 31 | 5.453 | 25784.5 |
| 237 | 2021-12-26 20:19:11 | trumperies | 3 | 140603 | 31 | 6.623 | 21229.5 |
| 236 | 2021-12-08 04:58:43 | trumperies | 3 | 140603 | 31 | 5.390 | 26085.9 |
| 235 | 2021-12-07 18:42:34 | trumperies | 3 | 140603 | 31 | 10.440 | 13467.7 |