History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"apertures"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1104 | 2025-07-19 03:24:15 | apertures | 3 | 148641 | 65 | 7.453 | 19943.8 |
| 1103 | 2025-07-18 05:14:19 | apertures | 2 | 121436 | 8 | 9.140 | 13286.2 |
| 1102 | 2025-07-18 03:56:08 | apertures | 3 | 148641 | 65 | 46.440 | 3200.7 |
| 1101 | 2025-07-12 14:27:46 | apertures | 2 | 121436 | 8 | 3.750 | 32382.9 |
| 1100 | 2025-07-05 20:42:31 | apertures | 2 | 121436 | 8 | 3.736 | 32504.3 |
| 1099 | 2025-06-30 13:26:46 | apertures | 1 | 81242 | 3 | 6.626 | 12261.1 |
| 1098 | 2025-06-28 08:44:19 | apertures | 1 | 81242 | 3 | 5.940 | 13677.1 |
| 1097 | 2025-06-26 11:41:10 | apertures | 1 | 81242 | 3 | 3.623 | 22424.0 |
| 1096 | 2025-06-17 21:30:13 | apertures | 3 | 148641 | 65 | 30.330 | 4900.8 |
| 1095 | 2025-06-15 19:39:49 | apertures | 3 | 148641 | 65 | 34.096 | 4359.5 |
| 1094 | 2025-06-15 14:30:01 | apertures | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 1093 | 2025-06-15 03:51:37 | apertures | 1 | 81242 | 3 | 6.140 | 13231.6 |
| 1092 | 2025-06-14 09:01:56 | apertures | 1 | 81242 | 3 | 9.513 | 8540.1 |
| 1091 | 2025-06-02 01:41:03 | apertures | 4 | 165329 | 549 | 67.346 | 2454.9 |
| 1090 | 2025-05-26 05:27:56 | apertures | 1 | 81242 | 3 | 6.126 | 13261.8 |
| 1089 | 2025-05-23 13:08:52 | apertures | 4 | 165329 | 549 | 68.596 | 2410.2 |
| 1088 | 2025-05-22 13:44:45 | apertures | 4 | 165329 | 549 | 32.953 | 5017.1 |
| 1087 | 2025-05-22 10:45:53 | apertures | 4 | 165329 | 549 | 61.893 | 2671.2 |
| 1086 | 2025-05-20 16:38:19 | apertures | 4 | 165329 | 549 | 40.456 | 4086.6 |
| 1085 | 2025-05-19 06:54:46 | apertures | 3 | 148641 | 65 | 7.423 | 20024.4 |
| 1084 | 2025-05-18 13:10:16 | apertures | 1 | 81242 | 3 | 5.326 | 15253.8 |
| 1083 | 2025-05-17 04:30:23 | apertures | 3 | 148641 | 65 | 42.606 | 3488.7 |
| 1082 | 2025-05-16 22:43:36 | apertures | 3 | 148641 | 65 | 32.766 | 4536.4 |
| 1081 | 2025-05-16 04:24:57 | apertures | 3 | 148641 | 65 | 47.690 | 3116.8 |
| 1080 | 2025-05-14 08:58:40 | apertures | 1 | 81242 | 3 | 6.970 | 11656.0 |
| 1079 | 2025-05-13 17:26:43 | apertures | 3 | 148641 | 65 | 24.376 | 6097.8 |
| 1078 | 2025-05-08 09:12:27 | apertures | 2 | 121436 | 8 | 16.360 | 7422.7 |
| 1077 | 2025-05-07 19:52:20 | apertures | 3 | 148641 | 65 | 37.550 | 3958.5 |
| 1076 | 2025-05-04 09:19:12 | apertures | 2 | 121436 | 8 | 17.656 | 6877.9 |
| 1075 | 2025-05-04 03:41:47 | apertures | 1 | 81242 | 3 | 3.920 | 20725.0 |
| 1074 | 2025-05-03 21:26:53 | apertures | 3 | 148641 | 65 | 40.983 | 3626.9 |
| 1073 | 2025-04-28 03:08:54 | apertures | 1 | 81242 | 3 | 8.483 | 9577.0 |
| 1072 | 2025-04-23 10:48:11 | apertures | 1 | 81242 | 3 | 3.593 | 22611.2 |
| 1071 | 2025-04-20 04:05:39 | apertures | 1 | 81242 | 3 | 5.783 | 14048.4 |
| 1070 | 2025-04-11 13:51:52 | apertures | 1 | 81242 | 3 | 6.783 | 11977.3 |
| 1069 | 2025-04-04 12:36:40 | apertures | 4 | 165329 | 549 | 47.253 | 3498.8 |
| 1068 | 2025-04-02 17:44:04 | apertures | 4 | 165329 | 549 | 59.630 | 2772.6 |
| 1067 | 2025-04-02 10:22:49 | apertures | 4 | 165329 | 549 | 59.393 | 2783.6 |
| 1066 | 2025-04-02 02:05:21 | apertures | 4 | 165329 | 549 | 74.706 | 2213.1 |
| 1065 | 2025-04-01 22:29:34 | apertures | 4 | 165329 | 549 | 72.366 | 2284.6 |
| 1064 | 2025-03-31 10:55:48 | apertures | 4 | 165329 | 549 | 62.406 | 2649.2 |
| 1063 | 2025-03-29 11:55:48 | apertures | 3 | 148641 | 65 | 23.233 | 6397.8 |
| 1062 | 2025-03-26 19:11:37 | apertures | 3 | 148641 | 65 | 33.410 | 4449.0 |
| 1061 | 2025-03-24 10:01:04 | apertures | 2 | 121436 | 8 | 9.200 | 13199.6 |
| 1060 | 2025-03-24 09:11:04 | apertures | 3 | 148641 | 65 | 40.593 | 3661.7 |
| 1059 | 2025-03-22 12:24:11 | apertures | 1 | 81242 | 3 | 6.766 | 12007.4 |
| 1058 | 2025-03-22 10:22:49 | apertures | 1 | 81242 | 3 | 6.190 | 13124.7 |
| 1057 | 2025-03-20 05:35:13 | apertures | 1 | 81242 | 3 | 8.626 | 9418.3 |
| 1056 | 2025-03-09 05:40:07 | apertures | 2 | 121436 | 8 | 13.313 | 9121.6 |
| 1055 | 2025-03-05 14:41:32 | apertures | 3 | 148641 | 65 | 54.423 | 2731.2 |
| 1054 | 2025-03-03 17:46:27 | apertures | 1 | 81242 | 3 | 8.610 | 9435.8 |
| 1053 | 2025-03-03 12:16:00 | apertures | 3 | 148641 | 65 | 48.046 | 3093.7 |
| 1052 | 2025-02-20 08:04:22 | apertures | 3 | 148641 | 65 | 39.720 | 3742.2 |
| 1051 | 2025-02-14 01:42:39 | apertures | 3 | 148641 | 65 | 7.783 | 19098.2 |
| 1050 | 2025-02-07 01:13:33 | apertures | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 1049 | 2025-02-06 02:31:02 | apertures | 3 | 148641 | 65 | 35.076 | 4237.7 |
| 1048 | 2025-02-02 13:19:24 | apertures | 1 | 81242 | 3 | 3.440 | 23616.9 |
| 1047 | 2025-02-02 08:30:07 | apertures | 3 | 148641 | 65 | 34.766 | 4275.5 |
| 1046 | 2025-02-01 07:15:28 | apertures | 3 | 148641 | 65 | 23.360 | 6363.1 |
| 1045 | 2025-02-01 07:14:55 | apertures | 1 | 81242 | 3 | 7.016 | 11579.5 |
| 1044 | 2025-01-29 15:13:26 | apertures | 1 | 81242 | 3 | 4.143 | 19609.5 |
| 1043 | 2025-01-23 06:52:01 | apertures | 2 | 121436 | 8 | 9.000 | 13492.9 |
| 1042 | 2025-01-21 00:55:02 | apertures | 3 | 148641 | 65 | 32.253 | 4608.6 |
| 1041 | 2024-12-31 14:23:34 | apertures | 3 | 148641 | 65 | 38.826 | 3828.4 |
| 1040 | 2024-12-31 09:01:41 | apertures | 4 | 165329 | 549 | 71.003 | 2328.5 |
| 1039 | 2024-12-31 09:01:53 | apertures | 3 | 148641 | 65 | 41.093 | 3617.2 |
| 1038 | 2024-12-31 09:01:58 | apertures | 2 | 121436 | 8 | 24.563 | 4943.9 |
| 1037 | 2024-12-31 08:23:31 | apertures | 2 | 121436 | 8 | 17.050 | 7122.3 |
| 1036 | 2024-12-31 08:23:23 | apertures | 3 | 148641 | 65 | 19.036 | 7808.4 |
| 1035 | 2024-12-31 08:20:55 | apertures | 1 | 81242 | 3 | 3.310 | 24544.4 |
| 1034 | 2024-12-30 09:08:43 | apertures | 3 | 148641 | 65 | 49.706 | 2990.4 |
| 1033 | 2024-12-30 09:08:45 | apertures | 3 | 148641 | 65 | 22.110 | 6722.8 |
| 1032 | 2024-12-30 09:08:42 | apertures | 2 | 121436 | 8 | 9.453 | 12846.3 |
| 1031 | 2024-12-30 09:07:43 | apertures | 1 | 81242 | 3 | 6.313 | 12869.0 |
| 1030 | 2024-12-29 11:09:14 | apertures | 1 | 81242 | 3 | 9.190 | 8840.3 |
| 1029 | 2024-12-27 09:30:48 | apertures | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 1028 | 2024-11-28 06:21:19 | apertures | 3 | 148641 | 65 | 47.520 | 3128.0 |
| 1027 | 2024-11-27 10:59:07 | apertures | 3 | 148641 | 65 | 28.813 | 5158.8 |
| 1026 | 2024-11-27 04:44:12 | apertures | 3 | 148641 | 65 | 54.486 | 2728.1 |
| 1025 | 2024-11-27 04:44:09 | apertures | 3 | 148641 | 65 | 21.050 | 7061.3 |
| 1024 | 2024-11-27 04:44:13 | apertures | 2 | 121436 | 8 | 9.296 | 13063.3 |
| 1023 | 2024-11-27 03:40:55 | apertures | 1 | 81242 | 3 | 6.170 | 13167.3 |
| 1022 | 2024-11-21 02:00:45 | apertures | 2 | 121436 | 8 | 16.423 | 7394.3 |
| 1021 | 2024-11-21 01:44:54 | apertures | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 1020 | 2024-10-28 04:33:14 | apertures | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 1019 | 2024-10-24 06:34:14 | apertures | 3 | 148641 | 65 | 44.143 | 3367.3 |
| 1018 | 2024-10-23 05:52:14 | apertures | 3 | 148641 | 65 | 36.893 | 4029.0 |
| 1017 | 2024-10-23 05:52:02 | apertures | 3 | 148641 | 65 | 37.813 | 3930.9 |
| 1016 | 2024-10-23 05:52:02 | apertures | 2 | 121436 | 8 | 10.063 | 12067.6 |
| 1015 | 2024-10-23 05:50:17 | apertures | 1 | 81242 | 3 | 6.173 | 13160.9 |
| 1014 | 2024-10-22 20:38:41 | apertures | 3 | 148641 | 65 | 43.470 | 3419.4 |
| 1013 | 2024-10-22 20:38:44 | apertures | 3 | 148641 | 65 | 37.406 | 3973.7 |
| 1012 | 2024-10-22 20:38:42 | apertures | 2 | 121436 | 8 | 11.173 | 10868.7 |
| 1011 | 2024-10-22 02:36:58 | apertures | 1 | 81242 | 3 | 3.280 | 24768.9 |
| 1010 | 2024-10-13 22:18:31 | apertures | 1 | 81242 | 3 | 6.670 | 12180.2 |
| 1009 | 2024-09-16 08:19:08 | apertures | 1 | 81242 | 3 | 12.033 | 6751.6 |
| 1008 | 2024-09-02 06:54:44 | apertures | 3 | 148641 | 65 | 75.830 | 1960.2 |
| 1007 | 2024-09-01 15:55:26 | apertures | 3 | 148641 | 65 | 32.660 | 4551.2 |
| 1006 | 2024-09-01 02:28:39 | apertures | 3 | 148641 | 65 | 57.066 | 2604.7 |
| 1005 | 2024-08-19 15:19:47 | apertures | 3 | 148641 | 65 | 60.486 | 2457.4 |