History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pertest"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1225 | 2025-04-17 00:42:04 | pertest | 3 | 134027 | 527 | 8.190 | 16364.7 |
| 1224 | 2025-04-15 11:37:46 | pertest | 3 | 134027 | 527 | 7.626 | 17575.0 |
| 1223 | 2025-04-14 03:44:32 | pertest | 3 | 134027 | 527 | 56.656 | 2365.6 |
| 1222 | 2025-04-14 02:34:59 | pertest | 3 | 134027 | 527 | 36.280 | 3694.2 |
| 1221 | 2025-04-13 09:20:42 | pertest | 3 | 134027 | 527 | 9.766 | 13723.8 |
| 1220 | 2025-04-12 06:29:07 | pertest | 3 | 134027 | 527 | 46.940 | 2855.3 |
| 1219 | 2025-04-11 16:57:59 | pertest | 1 | 69583 | 3 | 3.346 | 20795.9 |
| 1218 | 2025-04-10 20:23:50 | pertest | 2 | 107671 | 43 | 12.940 | 8320.8 |
| 1217 | 2025-04-10 10:14:21 | pertest | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 1216 | 2025-04-02 20:39:45 | pertest | 3 | 134027 | 527 | 26.720 | 5016.0 |
| 1215 | 2025-04-02 04:11:45 | pertest | 1 | 69583 | 3 | 6.046 | 11508.9 |
| 1214 | 2025-03-21 02:27:14 | pertest | 2 | 107671 | 43 | 15.813 | 6809.0 |
| 1213 | 2025-03-20 00:37:34 | pertest | 1 | 69583 | 3 | 6.953 | 10007.6 |
| 1212 | 2025-03-19 01:19:14 | pertest | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 1211 | 2025-03-18 23:58:28 | pertest | 3 | 134027 | 527 | 6.110 | 21935.7 |
| 1210 | 2025-03-16 22:33:37 | pertest | 3 | 134027 | 527 | 21.830 | 6139.6 |
| 1209 | 2025-03-16 06:57:22 | pertest | 3 | 134027 | 527 | 35.800 | 3743.8 |
| 1208 | 2025-03-16 05:19:55 | pertest | 3 | 134027 | 527 | 35.050 | 3823.9 |
| 1207 | 2025-03-13 12:35:53 | pertest | 3 | 134027 | 527 | 40.393 | 3318.1 |
| 1206 | 2025-03-13 08:00:23 | pertest | 3 | 134027 | 527 | 39.710 | 3375.1 |
| 1205 | 2025-03-13 06:54:45 | pertest | 3 | 134027 | 527 | 35.596 | 3765.2 |
| 1204 | 2025-03-12 22:37:39 | pertest | 3 | 134027 | 527 | 25.410 | 5274.6 |
| 1203 | 2025-03-10 18:08:02 | pertest | 1 | 69583 | 3 | 6.283 | 11074.8 |
| 1202 | 2025-03-08 17:09:56 | pertest | 1 | 69583 | 3 | 5.126 | 13574.5 |
| 1201 | 2025-03-02 05:40:59 | pertest | 1 | 69583 | 3 | 4.106 | 16946.7 |
| 1200 | 2025-02-07 07:58:40 | pertest | 3 | 134027 | 527 | 18.296 | 7325.5 |
| 1199 | 2025-02-06 14:06:34 | pertest | 2 | 107671 | 43 | 6.016 | 17897.4 |
| 1198 | 2025-02-06 11:57:15 | pertest | 3 | 134027 | 527 | 22.516 | 5952.5 |
| 1197 | 2025-02-06 10:40:06 | pertest | 3 | 134027 | 527 | 19.160 | 6995.1 |
| 1196 | 2025-02-06 08:20:24 | pertest | 3 | 134027 | 527 | 26.126 | 5130.0 |
| 1195 | 2025-02-06 08:20:29 | pertest | 2 | 107671 | 43 | 16.580 | 6494.0 |
| 1194 | 2025-02-06 07:44:49 | pertest | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 1193 | 2025-01-17 10:19:40 | pertest | 1 | 69583 | 3 | 3.016 | 23071.3 |
| 1192 | 2024-12-27 13:34:28 | pertest | 1 | 69583 | 3 | 3.420 | 20345.9 |
| 1191 | 2024-12-26 12:45:41 | pertest | 1 | 69583 | 3 | 5.140 | 13537.5 |
| 1190 | 2024-12-07 15:44:10 | pertest | 1 | 69583 | 3 | 7.110 | 9786.6 |
| 1189 | 2024-12-04 09:12:45 | pertest | 3 | 134027 | 527 | 35.940 | 3729.2 |
| 1188 | 2024-12-02 18:09:52 | pertest | 3 | 134027 | 527 | 30.550 | 4387.1 |
| 1187 | 2024-12-01 21:08:41 | pertest | 3 | 134027 | 527 | 37.940 | 3532.6 |
| 1186 | 2024-11-26 08:49:09 | pertest | 1 | 69583 | 3 | 5.606 | 12412.2 |
| 1185 | 2024-10-29 04:16:49 | pertest | 2 | 107671 | 43 | 16.820 | 6401.4 |
| 1184 | 2024-10-27 03:31:46 | pertest | 3 | 134027 | 527 | 38.076 | 3520.0 |
| 1183 | 2024-10-27 03:26:08 | pertest | 2 | 107671 | 43 | 24.596 | 4377.6 |
| 1182 | 2024-10-27 03:15:44 | pertest | 1 | 69583 | 3 | 3.343 | 20814.5 |
| 1181 | 2024-10-27 02:06:49 | pertest | 1 | 69583 | 3 | 6.173 | 11272.2 |
| 1180 | 2024-10-26 21:25:13 | pertest | 3 | 134027 | 527 | 45.250 | 2961.9 |
| 1179 | 2024-10-26 08:09:00 | pertest | 3 | 134027 | 527 | 34.250 | 3913.2 |
| 1178 | 2024-10-26 00:13:08 | pertest | 3 | 134027 | 527 | 32.173 | 4165.8 |
| 1177 | 2024-10-25 23:26:37 | pertest | 3 | 134027 | 527 | 16.893 | 7933.9 |
| 1176 | 2024-10-23 11:35:30 | pertest | 1 | 69583 | 3 | 7.156 | 9723.7 |
| 1175 | 2024-10-23 10:44:56 | pertest | 1 | 69583 | 3 | 6.126 | 11358.6 |
| 1174 | 2024-09-23 12:51:19 | pertest | 1 | 69583 | 3 | 8.080 | 8611.8 |
| 1173 | 2024-09-04 14:06:41 | pertest | 3 | 134027 | 527 | 26.893 | 4983.7 |
| 1172 | 2024-09-02 09:53:08 | pertest | 1 | 69583 | 3 | 13.783 | 5048.5 |
| 1171 | 2024-09-02 07:35:56 | pertest | 3 | 134027 | 527 | 65.780 | 2037.5 |
| 1170 | 2024-09-01 20:04:57 | pertest | 3 | 134027 | 527 | 42.343 | 3165.3 |
| 1169 | 2024-08-29 18:34:34 | pertest | 1 | 69583 | 3 | 4.640 | 14996.3 |
| 1168 | 2024-08-20 14:20:42 | pertest | 1 | 69583 | 3 | 12.673 | 5490.6 |
| 1167 | 2024-08-20 10:57:10 | pertest | 1 | 69583 | 3 | 5.106 | 13627.7 |
| 1166 | 2024-08-15 18:40:04 | pertest | 3 | 134027 | 527 | 61.050 | 2195.4 |
| 1165 | 2024-08-14 22:10:12 | pertest | 3 | 134027 | 527 | 26.063 | 5142.4 |
| 1164 | 2024-08-14 13:44:59 | pertest | 3 | 134027 | 527 | 25.626 | 5230.1 |
| 1163 | 2024-08-13 05:49:16 | pertest | 1 | 69583 | 3 | 10.313 | 6747.1 |
| 1162 | 2024-08-13 04:12:41 | pertest | 3 | 134027 | 527 | 70.643 | 1897.2 |
| 1161 | 2024-08-12 17:30:44 | pertest | 3 | 134027 | 527 | 25.360 | 5285.0 |
| 1160 | 2024-08-12 17:10:37 | pertest | 2 | 107671 | 43 | 23.283 | 4624.4 |
| 1159 | 2024-08-11 19:36:16 | pertest | 1 | 69583 | 3 | 6.410 | 10855.4 |
| 1158 | 2024-08-09 16:51:35 | pertest | 1 | 69583 | 3 | 4.033 | 17253.4 |
| 1157 | 2024-08-03 17:56:43 | pertest | 1 | 69583 | 3 | 4.643 | 14986.6 |
| 1156 | 2024-07-25 06:59:14 | pertest | 2 | 107671 | 43 | 11.326 | 9506.5 |
| 1155 | 2024-07-25 06:55:09 | pertest | 3 | 134027 | 527 | 9.110 | 14712.1 |
| 1154 | 2024-07-21 14:54:44 | pertest | 3 | 134027 | 527 | 26.126 | 5130.0 |
| 1153 | 2024-07-20 07:26:20 | pertest | 1 | 69583 | 3 | 4.860 | 14317.5 |
| 1152 | 2024-07-18 22:55:58 | pertest | 1 | 69583 | 3 | 2.406 | 28920.6 |
| 1151 | 2024-07-10 19:46:18 | pertest | 3 | 134027 | 527 | 48.236 | 2778.6 |
| 1150 | 2024-07-09 06:11:44 | pertest | 3 | 134027 | 527 | 39.203 | 3418.8 |
| 1149 | 2024-07-07 03:07:49 | pertest | 2 | 107671 | 43 | 14.563 | 7393.5 |
| 1148 | 2024-07-07 03:06:23 | pertest | 1 | 69583 | 3 | 5.343 | 13023.2 |
| 1147 | 2024-07-02 08:26:46 | pertest | 2 | 107671 | 43 | 17.390 | 6191.5 |
| 1146 | 2024-06-30 23:39:11 | pertest | 1 | 69583 | 3 | 3.000 | 23194.3 |
| 1145 | 2024-06-30 15:30:04 | pertest | 1 | 69583 | 3 | 2.220 | 31343.7 |
| 1144 | 2024-06-29 19:32:55 | pertest | 1 | 69583 | 3 | 4.390 | 15850.3 |
| 1143 | 2024-06-26 17:02:38 | pertest | 3 | 134027 | 527 | 42.563 | 3148.9 |
| 1142 | 2024-06-26 03:55:00 | pertest | 3 | 134027 | 527 | 33.296 | 4025.3 |
| 1141 | 2024-06-25 07:01:21 | pertest | 3 | 134027 | 527 | 19.733 | 6792.0 |
| 1140 | 2024-06-25 02:36:40 | pertest | 3 | 134027 | 527 | 33.160 | 4041.8 |
| 1139 | 2024-06-25 02:35:51 | pertest | 1 | 69583 | 3 | 4.360 | 15959.4 |
| 1138 | 2024-06-24 23:46:59 | pertest | 3 | 134027 | 527 | 32.703 | 4098.3 |
| 1137 | 2024-06-24 15:17:43 | pertest | 3 | 134027 | 527 | 30.673 | 4369.5 |
| 1136 | 2024-06-23 22:06:17 | pertest | 1 | 69583 | 3 | 1.940 | 35867.5 |
| 1135 | 2024-06-22 16:34:09 | pertest | 1 | 69583 | 3 | 4.593 | 15149.8 |
| 1134 | 2024-06-20 20:51:58 | pertest | 1 | 69583 | 3 | 4.643 | 14986.6 |
| 1133 | 2024-06-05 23:15:53 | pertest | 1 | 69583 | 3 | 2.186 | 31831.2 |
| 1132 | 2024-06-04 13:47:04 | pertest | 1 | 69583 | 3 | 1.970 | 35321.3 |
| 1131 | 2024-05-03 01:13:43 | pertest | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 1130 | 2024-05-01 05:22:57 | pertest | 2 | 107671 | 43 | 3.500 | 30763.1 |
| 1129 | 2024-04-27 17:32:06 | pertest | 1 | 69583 | 3 | 1.376 | 50569.0 |
| 1128 | 2024-04-20 22:33:10 | pertest | 3 | 134027 | 527 | 10.300 | 13012.3 |
| 1127 | 2024-04-20 21:18:40 | pertest | 3 | 134027 | 527 | 32.940 | 4068.8 |
| 1126 | 2024-04-20 07:57:55 | pertest | 3 | 134027 | 527 | 16.923 | 7919.8 |