History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"personality"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
293 | 2024-04-28 01:26:38 | personality | 4 | 148819 | 81 | 17.970 | 8281.5 |
292 | 2024-04-27 01:25:37 | personality | 5 | 164607 | 335 | 49.266 | 3341.2 |
291 | 2024-04-27 01:25:45 | personality | 4 | 148819 | 81 | 31.596 | 4710.1 |
290 | 2024-04-27 01:25:51 | personality | 3 | 121633 | 28 | 17.110 | 7108.9 |
289 | 2024-04-27 01:26:01 | personality | 2 | 86808 | 10 | 6.190 | 14023.9 |
288 | 2024-04-26 23:34:21 | personality | 1 | 49908 | 2 | 0.796 | 62698.5 |
287 | 2024-04-26 02:09:00 | personality | 1 | 49908 | 2 | 0.953 | 52369.4 |
286 | 2024-04-12 14:44:27 | personality | 1 | 49908 | 2 | 1.016 | 49122.0 |
285 | 2024-04-09 22:34:39 | personality | 1 | 49908 | 2 | 0.966 | 51664.6 |
284 | 2024-04-04 10:04:25 | personality | 3 | 121633 | 28 | 12.376 | 9828.1 |
283 | 2024-04-04 10:03:48 | personality | 2 | 86808 | 10 | 4.356 | 19928.4 |
282 | 2024-04-03 22:44:41 | personality | 2 | 86808 | 10 | 2.186 | 39710.9 |
281 | 2024-04-03 04:01:44 | personality | 4 | 148819 | 81 | 29.360 | 5068.8 |
280 | 2024-04-01 07:46:58 | personality | 4 | 148819 | 81 | 31.380 | 4742.5 |
279 | 2024-03-27 18:08:58 | personality | 4 | 148819 | 81 | 24.046 | 6188.9 |
278 | 2024-03-27 12:11:40 | personality | 4 | 148819 | 81 | 22.533 | 6604.5 |
277 | 2024-03-27 11:02:09 | personality | 1 | 49908 | 2 | 0.860 | 58032.6 |
276 | 2024-03-18 19:32:27 | personality | 1 | 49908 | 2 | 2.093 | 23845.2 |
275 | 2024-03-14 05:34:04 | personality | 5 | 164607 | 335 | 47.676 | 3452.6 |
274 | 2024-03-11 16:55:30 | personality | 2 | 86808 | 10 | 5.156 | 16836.3 |
273 | 2024-03-10 15:19:23 | personality | 1 | 49908 | 2 | 1.000 | 49908.0 |
272 | 2024-03-10 15:08:20 | personality | 2 | 86808 | 10 | 3.690 | 23525.2 |
271 | 2024-03-10 09:02:11 | personality | 5 | 164607 | 335 | 49.220 | 3344.3 |
270 | 2024-03-10 07:58:39 | personality | 5 | 164607 | 335 | 39.813 | 4134.5 |
269 | 2024-03-10 07:47:36 | personality | 3 | 121633 | 28 | 6.843 | 17774.8 |
268 | 2024-03-09 20:38:45 | personality | 1 | 49908 | 2 | 1.266 | 39421.8 |
267 | 2024-03-09 07:42:53 | personality | 5 | 164607 | 335 | 41.033 | 4011.6 |
266 | 2024-03-09 06:32:22 | personality | 5 | 164607 | 335 | 43.423 | 3790.8 |
265 | 2024-03-09 06:32:12 | personality | 3 | 121633 | 28 | 15.580 | 7807.0 |
264 | 2024-03-09 06:32:12 | personality | 2 | 86808 | 10 | 8.983 | 9663.6 |
263 | 2024-03-09 04:13:41 | personality | 1 | 49908 | 2 | 0.936 | 53320.5 |
262 | 2024-02-29 12:29:02 | personality | 4 | 148819 | 81 | 10.890 | 13665.7 |
261 | 2024-02-18 06:23:24 | personality | 1 | 49908 | 2 | 2.936 | 16998.6 |
260 | 2024-02-18 06:21:07 | personality | 1 | 49908 | 2 | 2.436 | 20487.7 |
259 | 2024-02-15 17:02:42 | personality | 1 | 49908 | 2 | 2.106 | 23698.0 |
258 | 2024-02-10 12:25:26 | personality | 2 | 86808 | 10 | 5.690 | 15256.2 |
257 | 2024-02-10 12:25:22 | personality | 3 | 121633 | 28 | 9.360 | 12995.0 |
256 | 2024-02-07 22:32:40 | personality | 1 | 49908 | 2 | 2.953 | 16900.8 |
255 | 2024-02-07 16:37:26 | personality | 1 | 49908 | 2 | 0.876 | 56972.6 |
254 | 2024-02-07 04:26:35 | personality | 1 | 49908 | 2 | 0.796 | 62698.5 |
253 | 2024-02-05 22:33:46 | personality | 1 | 49908 | 2 | 1.920 | 25993.8 |
252 | 2024-01-31 10:17:39 | personality | 1 | 49908 | 2 | 0.876 | 56972.6 |
251 | 2024-01-23 20:00:49 | personality | 4 | 148819 | 81 | 9.720 | 15310.6 |
250 | 2024-01-23 13:29:22 | personality | 4 | 148819 | 81 | 33.986 | 4378.8 |
249 | 2024-01-23 12:41:25 | personality | 4 | 148819 | 81 | 14.080 | 10569.5 |
248 | 2024-01-14 14:28:09 | personality | 5 | 164607 | 335 | 14.503 | 11349.9 |
247 | 2024-01-10 14:52:05 | personality | 4 | 148819 | 81 | 8.656 | 17192.6 |
246 | 2023-12-24 05:14:01 | personality | 1 | 49908 | 2 | 0.983 | 50771.1 |
245 | 2023-12-17 00:41:32 | personality | 5 | 164607 | 335 | 19.610 | 8394.0 |
244 | 2023-12-07 09:11:30 | personality | 2 | 86808 | 10 | 2.280 | 38073.7 |
243 | 2023-12-03 17:57:00 | personality | 1 | 49908 | 2 | 0.780 | 63984.6 |
242 | 2023-12-01 18:49:49 | personality | 5 | 164607 | 335 | 20.813 | 7908.9 |
241 | 2023-11-29 11:16:07 | personality | 1 | 49908 | 2 | 0.780 | 63984.6 |
240 | 2023-10-29 23:01:03 | personality | 5 | 164607 | 335 | 21.253 | 7745.1 |
239 | 2023-10-26 09:48:48 | personality | 5 | 164607 | 335 | 22.640 | 7270.6 |
238 | 2023-10-25 06:10:59 | personality | 5 | 164607 | 335 | 19.343 | 8509.9 |
237 | 2023-10-22 15:36:31 | personality | 5 | 164607 | 335 | 13.766 | 11957.5 |
236 | 2023-10-19 01:17:12 | personality | 4 | 148819 | 81 | 9.390 | 15848.7 |
235 | 2023-10-15 14:12:52 | personality | 5 | 164607 | 335 | 19.753 | 8333.3 |
234 | 2023-10-14 04:43:04 | personality | 1 | 49908 | 2 | 0.906 | 55086.1 |
233 | 2023-09-21 09:31:34 | personality | 5 | 164607 | 335 | 14.436 | 11402.5 |
232 | 2023-09-18 08:48:24 | personality | 1 | 49908 | 2 | 0.796 | 62698.5 |
231 | 2023-09-04 07:22:04 | personality | 2 | 86808 | 10 | 2.580 | 33646.5 |
230 | 2023-08-02 13:02:13 | personality | 5 | 164607 | 335 | 13.720 | 11997.6 |
229 | 2023-07-30 00:29:48 | personality | 4 | 148819 | 81 | 10.063 | 14788.7 |
228 | 2023-07-11 04:57:52 | personality | 1 | 49908 | 2 | 0.860 | 58032.6 |
227 | 2023-04-15 22:58:24 | personality | 1 | 49908 | 2 | 0.766 | 65154.0 |
226 | 2023-04-10 07:58:17 | personality | 5 | 164607 | 335 | 14.533 | 11326.4 |
225 | 2023-04-07 21:02:32 | personality | 4 | 148819 | 81 | 8.250 | 18038.7 |
224 | 2023-02-09 22:40:00 | personality | 1 | 49908 | 2 | 0.766 | 65154.0 |
223 | 2023-01-27 08:54:20 | personality | 5 | 164607 | 335 | 13.813 | 11916.8 |
222 | 2023-01-20 10:31:01 | personality | 2 | 86808 | 10 | 2.423 | 35826.7 |
221 | 2023-01-15 22:48:27 | personality | 5 | 164607 | 335 | 13.673 | 12038.8 |
220 | 2023-01-13 15:28:33 | personality | 4 | 148819 | 81 | 9.983 | 14907.2 |
219 | 2022-12-29 01:05:38 | personality | 5 | 164607 | 335 | 23.393 | 7036.6 |
218 | 2022-12-07 17:01:52 | personality | 1 | 49908 | 2 | 0.750 | 66544.0 |
217 | 2022-10-31 08:41:01 | personality | 2 | 86808 | 10 | 2.280 | 38073.7 |
216 | 2022-10-27 12:52:48 | personality | 5 | 164607 | 335 | 13.483 | 12208.5 |
215 | 2022-10-15 10:47:40 | personality | 4 | 148819 | 81 | 8.796 | 16918.9 |
214 | 2022-08-05 23:06:37 | personality | 1 | 49908 | 2 | 0.813 | 61387.5 |
213 | 2022-08-03 15:03:48 | personality | 1 | 49908 | 2 | 0.873 | 57168.4 |
212 | 2022-06-02 05:28:30 | personality | 2 | 86808 | 10 | 2.203 | 39404.4 |
211 | 2022-05-26 03:46:24 | personality | 5 | 164607 | 335 | 13.736 | 11983.6 |
210 | 2022-05-17 04:33:49 | personality | 4 | 148819 | 81 | 9.326 | 15957.4 |
209 | 2022-03-24 11:48:05 | personality | 1 | 49908 | 2 | 1.280 | 38990.6 |
208 | 2022-01-27 23:35:22 | personality | 2 | 86808 | 10 | 2.203 | 39404.4 |
207 | 2022-01-25 18:58:53 | personality | 2 | 86808 | 10 | 2.156 | 40263.5 |
206 | 2022-01-21 02:23:43 | personality | 5 | 164607 | 335 | 14.720 | 11182.5 |
205 | 2022-01-06 00:49:29 | personality | 5 | 164607 | 335 | 14.030 | 11732.5 |
204 | 2021-12-30 10:32:58 | personality | 1 | 49908 | 2 | 0.953 | 52369.4 |
203 | 2021-11-25 13:33:50 | personality | 5 | 164607 | 335 | 16.690 | 9862.6 |
202 | 2021-11-15 00:23:43 | personality | 2 | 86808 | 10 | 2.673 | 32475.9 |
201 | 2021-11-04 01:35:02 | personality | 1 | 49908 | 2 | 0.766 | 65154.0 |
200 | 2021-10-28 11:09:39 | personality | 5 | 164607 | 335 | 16.656 | 9882.7 |
199 | 2021-09-27 21:34:35 | personality | 1 | 49908 | 2 | 0.843 | 59202.8 |
198 | 2021-09-25 17:47:24 | personality | 1 | 49908 | 2 | 0.860 | 58032.6 |
197 | 2021-09-17 09:25:08 | personality | 5 | 164607 | 335 | 15.546 | 10588.4 |
196 | 2021-07-30 20:41:57 | personality | 5 | 164607 | 335 | 13.906 | 11837.1 |
195 | 2021-07-25 04:48:55 | personality | 5 | 164607 | 335 | 16.063 | 10247.6 |
194 | 2021-07-16 07:51:29 | personality | 5 | 164607 | 335 | 14.393 | 11436.6 |