History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"photometer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 420 | 2025-10-20 00:13:16 | photometer | 4 | 161450 | 163 | 60.500 | 2668.6 |
| 419 | 2025-10-20 00:12:57 | photometer | 4 | 161450 | 163 | 68.003 | 2374.2 |
| 418 | 2025-10-20 00:12:35 | photometer | 4 | 161450 | 163 | 57.486 | 2808.5 |
| 417 | 2025-10-20 00:12:38 | photometer | 4 | 161450 | 163 | 50.453 | 3200.0 |
| 416 | 2025-10-18 17:05:33 | photometer | 4 | 161450 | 163 | 9.690 | 16661.5 |
| 415 | 2025-10-18 14:58:43 | photometer | 2 | 108824 | 6 | 2.843 | 38277.9 |
| 414 | 2025-10-04 23:00:01 | photometer | 3 | 140603 | 30 | 6.673 | 21070.4 |
| 413 | 2025-10-03 10:18:00 | photometer | 1 | 67641 | 3 | 2.843 | 23792.1 |
| 412 | 2025-09-22 04:39:10 | photometer | 2 | 108824 | 6 | 3.346 | 32523.6 |
| 411 | 2025-09-22 02:05:29 | photometer | 3 | 140603 | 30 | 6.076 | 23140.7 |
| 410 | 2025-09-21 23:55:17 | photometer | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 409 | 2025-09-21 19:22:18 | photometer | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 408 | 2025-09-21 19:22:06 | photometer | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 407 | 2025-09-12 00:58:43 | photometer | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 406 | 2025-09-09 07:01:05 | photometer | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 405 | 2025-08-19 14:24:17 | photometer | 1 | 67641 | 3 | 5.686 | 11896.1 |
| 404 | 2025-08-19 13:59:58 | photometer | 1 | 67641 | 3 | 2.970 | 22774.7 |
| 403 | 2025-08-18 21:07:17 | photometer | 1 | 67641 | 3 | 2.250 | 30062.7 |
| 402 | 2025-08-17 08:23:13 | photometer | 1 | 67641 | 3 | 2.280 | 29667.1 |
| 401 | 2025-07-24 23:05:30 | photometer | 1 | 67641 | 3 | 2.343 | 28869.4 |
| 400 | 2025-07-24 16:29:37 | photometer | 1 | 67641 | 3 | 3.423 | 19760.7 |
| 399 | 2025-07-17 13:15:08 | photometer | 1 | 67641 | 3 | 2.873 | 23543.7 |
| 398 | 2025-07-16 05:54:33 | photometer | 1 | 67641 | 3 | 2.906 | 23276.3 |
| 397 | 2025-06-29 23:56:36 | photometer | 1 | 67641 | 3 | 4.300 | 15730.5 |
| 396 | 2025-06-23 18:24:27 | photometer | 2 | 108824 | 6 | 2.686 | 40515.3 |
| 395 | 2025-06-22 14:32:34 | photometer | 1 | 67641 | 3 | 2.940 | 23007.1 |
| 394 | 2025-06-09 13:49:21 | photometer | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 393 | 2025-06-04 00:20:16 | photometer | 1 | 67641 | 3 | 2.406 | 28113.5 |
| 392 | 2025-05-30 12:47:54 | photometer | 1 | 67641 | 3 | 5.390 | 12549.4 |
| 391 | 2025-05-29 23:22:20 | photometer | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 390 | 2025-05-23 19:55:20 | photometer | 1 | 67641 | 3 | 5.610 | 12057.2 |
| 389 | 2025-05-20 14:32:02 | photometer | 1 | 67641 | 3 | 6.220 | 10874.8 |
| 388 | 2025-05-08 19:30:40 | photometer | 3 | 140603 | 30 | 29.346 | 4791.2 |
| 387 | 2025-05-04 16:56:48 | photometer | 1 | 67641 | 3 | 5.626 | 12022.9 |
| 386 | 2025-05-03 20:55:35 | photometer | 1 | 67641 | 3 | 5.450 | 12411.2 |
| 385 | 2025-05-01 03:23:57 | photometer | 3 | 140603 | 30 | 29.393 | 4783.6 |
| 384 | 2025-04-30 13:18:50 | photometer | 2 | 108824 | 6 | 15.016 | 7247.2 |
| 383 | 2025-04-30 13:05:38 | photometer | 3 | 140603 | 30 | 32.296 | 4353.6 |
| 382 | 2025-04-28 23:35:07 | photometer | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 381 | 2025-04-27 10:31:18 | photometer | 3 | 140603 | 30 | 15.813 | 8891.6 |
| 380 | 2025-04-21 12:37:31 | photometer | 3 | 140603 | 30 | 46.520 | 3022.4 |
| 379 | 2025-04-20 12:59:35 | photometer | 1 | 67641 | 3 | 5.593 | 12093.9 |
| 378 | 2025-04-07 04:00:06 | photometer | 4 | 161450 | 163 | 54.863 | 2942.8 |
| 377 | 2025-04-06 23:03:29 | photometer | 4 | 161450 | 163 | 87.973 | 1835.2 |
| 376 | 2025-04-03 18:09:43 | photometer | 4 | 161450 | 163 | 24.313 | 6640.5 |
| 375 | 2025-04-02 04:22:57 | photometer | 2 | 108824 | 6 | 10.656 | 10212.5 |
| 374 | 2025-03-30 01:19:36 | photometer | 2 | 108824 | 6 | 3.076 | 35378.4 |
| 373 | 2025-03-29 10:09:09 | photometer | 1 | 67641 | 3 | 2.406 | 28113.5 |
| 372 | 2025-03-28 01:50:25 | photometer | 3 | 140603 | 30 | 5.923 | 23738.5 |
| 371 | 2025-03-21 01:11:44 | photometer | 1 | 67641 | 3 | 3.326 | 20337.0 |
| 370 | 2025-03-20 21:42:49 | photometer | 1 | 67641 | 3 | 6.593 | 10259.5 |
| 369 | 2025-03-20 15:57:58 | photometer | 1 | 67641 | 3 | 4.970 | 13609.9 |
| 368 | 2025-03-20 12:55:53 | photometer | 1 | 67641 | 3 | 5.110 | 13237.0 |
| 367 | 2025-03-12 21:50:46 | photometer | 3 | 140603 | 30 | 29.346 | 4791.2 |
| 366 | 2025-03-12 14:00:33 | photometer | 1 | 67641 | 3 | 5.906 | 11452.9 |
| 365 | 2025-03-12 10:42:46 | photometer | 3 | 140603 | 30 | 28.000 | 5021.5 |
| 364 | 2025-03-12 10:42:43 | photometer | 3 | 140603 | 30 | 24.080 | 5839.0 |
| 363 | 2025-03-12 10:41:22 | photometer | 2 | 108824 | 6 | 14.643 | 7431.8 |
| 362 | 2025-03-12 10:40:48 | photometer | 1 | 67641 | 3 | 2.640 | 25621.6 |
| 361 | 2025-03-01 22:59:24 | photometer | 3 | 140603 | 30 | 30.406 | 4624.2 |
| 360 | 2025-02-25 00:17:51 | photometer | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 359 | 2025-02-22 04:13:48 | photometer | 2 | 108824 | 6 | 15.046 | 7232.8 |
| 358 | 2025-02-15 15:21:43 | photometer | 1 | 67641 | 3 | 3.923 | 17242.2 |
| 357 | 2025-02-14 19:34:17 | photometer | 3 | 140603 | 30 | 38.736 | 3629.8 |
| 356 | 2025-02-14 19:34:10 | photometer | 3 | 140603 | 30 | 18.280 | 7691.6 |
| 355 | 2025-02-14 19:34:12 | photometer | 2 | 108824 | 6 | 14.733 | 7386.4 |
| 354 | 2025-02-14 19:34:03 | photometer | 1 | 67641 | 3 | 5.626 | 12022.9 |
| 353 | 2025-02-13 12:44:33 | photometer | 3 | 140603 | 30 | 34.563 | 4068.0 |
| 352 | 2025-02-13 02:16:42 | photometer | 4 | 161450 | 163 | 52.363 | 3083.3 |
| 351 | 2025-02-13 02:16:25 | photometer | 3 | 140603 | 30 | 35.063 | 4010.0 |
| 350 | 2025-02-13 02:14:57 | photometer | 1 | 67641 | 3 | 5.436 | 12443.2 |
| 349 | 2025-02-12 05:59:03 | photometer | 2 | 108824 | 6 | 18.736 | 5808.3 |
| 348 | 2025-02-10 21:13:21 | photometer | 3 | 140603 | 30 | 28.296 | 4969.0 |
| 347 | 2025-02-08 00:01:31 | photometer | 2 | 108824 | 6 | 17.500 | 6218.5 |
| 346 | 2025-02-05 11:28:00 | photometer | 3 | 140603 | 30 | 19.563 | 7187.2 |
| 345 | 2025-02-05 11:28:03 | photometer | 2 | 108824 | 6 | 7.750 | 14041.8 |
| 344 | 2025-02-05 11:21:25 | photometer | 3 | 140603 | 30 | 24.266 | 5794.2 |
| 343 | 2025-02-05 10:59:26 | photometer | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 342 | 2025-01-14 00:35:04 | photometer | 3 | 140603 | 30 | 41.940 | 3352.5 |
| 341 | 2025-01-14 00:34:20 | photometer | 1 | 67641 | 3 | 8.220 | 8228.8 |
| 340 | 2025-01-13 23:54:48 | photometer | 2 | 108824 | 6 | 10.660 | 10208.6 |
| 339 | 2025-01-13 20:13:43 | photometer | 3 | 140603 | 30 | 30.436 | 4619.6 |
| 338 | 2025-01-12 03:37:00 | photometer | 3 | 140603 | 30 | 32.660 | 4305.1 |
| 337 | 2025-01-12 03:37:10 | photometer | 2 | 108824 | 6 | 13.266 | 8203.2 |
| 336 | 2025-01-12 03:36:41 | photometer | 3 | 140603 | 30 | 14.723 | 9549.9 |
| 335 | 2025-01-12 03:34:12 | photometer | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 334 | 2025-01-10 14:45:06 | photometer | 3 | 140603 | 30 | 32.236 | 4361.7 |
| 333 | 2025-01-10 08:52:01 | photometer | 3 | 140603 | 30 | 7.126 | 19731.0 |
| 332 | 2025-01-10 08:52:02 | photometer | 2 | 108824 | 6 | 3.316 | 32817.9 |
| 331 | 2025-01-10 08:51:54 | photometer | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 330 | 2024-12-30 18:08:10 | photometer | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 329 | 2024-12-13 20:25:50 | photometer | 3 | 140603 | 30 | 33.563 | 4189.2 |
| 328 | 2024-12-12 22:21:33 | photometer | 3 | 140603 | 30 | 31.203 | 4506.1 |
| 327 | 2024-12-12 22:21:36 | photometer | 2 | 108824 | 6 | 12.533 | 8683.0 |
| 326 | 2024-12-12 22:19:37 | photometer | 1 | 67641 | 3 | 4.813 | 14053.8 |
| 325 | 2024-11-30 11:05:47 | photometer | 2 | 108824 | 6 | 14.940 | 7284.1 |
| 324 | 2024-11-29 18:10:08 | photometer | 2 | 108824 | 6 | 22.610 | 4813.1 |
| 323 | 2024-11-17 08:47:10 | photometer | 3 | 140603 | 30 | 38.610 | 3641.6 |
| 322 | 2024-11-17 08:47:13 | photometer | 2 | 108824 | 6 | 14.546 | 7481.4 |
| 321 | 2024-11-17 08:42:16 | photometer | 1 | 67641 | 3 | 2.123 | 31861.0 |