History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piccata"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 233 | 2024-03-29 09:55:00 | piccata | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 232 | 2024-03-19 08:10:36 | piccata | 1 | 69583 | 1 | 2.656 | 26198.4 |
| 231 | 2024-03-07 06:51:17 | piccata | 3 | 134027 | 74 | 10.720 | 12502.5 |
| 230 | 2024-03-06 13:05:51 | piccata | 3 | 134027 | 74 | 16.596 | 8075.9 |
| 229 | 2024-03-05 20:18:40 | piccata | 1 | 69583 | 1 | 2.610 | 26660.2 |
| 228 | 2024-03-04 21:55:59 | piccata | 3 | 134027 | 74 | 20.236 | 6623.2 |
| 227 | 2024-03-04 21:55:55 | piccata | 2 | 107671 | 6 | 10.140 | 10618.4 |
| 226 | 2024-03-01 03:43:24 | piccata | 4 | 151207 | 746 | 31.266 | 4836.1 |
| 225 | 2024-02-29 18:11:37 | piccata | 2 | 107671 | 6 | 3.436 | 31336.1 |
| 224 | 2024-02-29 18:11:07 | piccata | 3 | 134027 | 74 | 8.483 | 15799.5 |
| 223 | 2024-02-28 23:14:25 | piccata | 4 | 151207 | 746 | 16.563 | 9129.2 |
| 222 | 2024-02-28 08:41:22 | piccata | 4 | 151207 | 746 | 39.016 | 3875.5 |
| 221 | 2024-02-28 06:50:28 | piccata | 4 | 151207 | 746 | 20.140 | 7507.8 |
| 220 | 2024-02-28 05:42:18 | piccata | 3 | 134027 | 74 | 12.936 | 10360.8 |
| 219 | 2024-02-28 05:42:14 | piccata | 4 | 151207 | 746 | 14.123 | 10706.4 |
| 218 | 2024-02-28 05:42:15 | piccata | 2 | 107671 | 6 | 7.813 | 13781.0 |
| 217 | 2024-02-28 04:27:35 | piccata | 1 | 69583 | 1 | 2.623 | 26528.0 |
| 216 | 2024-02-17 22:32:25 | piccata | 1 | 69583 | 1 | 4.080 | 17054.7 |
| 215 | 2024-02-08 18:14:42 | piccata | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 214 | 2024-01-12 14:13:37 | piccata | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 213 | 2024-01-08 22:11:49 | piccata | 3 | 134027 | 74 | 5.766 | 23244.4 |
| 212 | 2023-11-29 05:27:04 | piccata | 1 | 69583 | 1 | 1.060 | 65644.3 |
| 211 | 2023-11-18 20:46:45 | piccata | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 210 | 2023-10-30 18:43:19 | piccata | 3 | 134027 | 74 | 8.126 | 16493.6 |
| 209 | 2023-10-18 18:38:05 | piccata | 3 | 134027 | 74 | 5.936 | 22578.7 |
| 208 | 2023-10-18 04:34:46 | piccata | 1 | 69583 | 1 | 1.546 | 45008.4 |
| 207 | 2023-10-16 14:02:23 | piccata | 3 | 134027 | 74 | 5.733 | 23378.2 |
| 206 | 2023-10-05 17:39:51 | piccata | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 205 | 2023-09-27 20:08:54 | piccata | 1 | 69583 | 1 | 2.626 | 26497.7 |
| 204 | 2023-09-15 11:18:37 | piccata | 1 | 69583 | 1 | 1.060 | 65644.3 |
| 203 | 2023-07-28 17:25:20 | piccata | 3 | 134027 | 74 | 5.923 | 22628.2 |
| 202 | 2023-07-18 09:45:12 | piccata | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 201 | 2023-07-18 05:27:34 | piccata | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 200 | 2023-06-27 13:53:41 | piccata | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 199 | 2023-06-10 20:28:28 | piccata | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 198 | 2023-04-19 03:49:21 | piccata | 1 | 69583 | 1 | 1.170 | 59472.6 |
| 197 | 2023-04-09 10:34:36 | piccata | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 196 | 2023-04-06 22:12:26 | piccata | 3 | 134027 | 74 | 5.560 | 24105.6 |
| 195 | 2023-02-09 01:55:38 | piccata | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 194 | 2023-01-01 13:54:28 | piccata | 3 | 134027 | 74 | 5.580 | 24019.2 |
| 193 | 2022-10-07 21:52:23 | piccata | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 192 | 2022-09-03 17:14:42 | piccata | 3 | 134027 | 74 | 5.783 | 23176.0 |
| 191 | 2022-06-03 02:24:06 | piccata | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 190 | 2022-06-02 23:24:52 | piccata | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 189 | 2022-02-17 03:41:32 | piccata | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 188 | 2022-02-14 23:55:27 | piccata | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 187 | 2022-02-12 19:25:04 | piccata | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 186 | 2022-01-26 09:08:02 | piccata | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 185 | 2021-12-16 23:01:25 | piccata | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 184 | 2021-10-03 10:25:38 | piccata | 1 | 69583 | 1 | 2.126 | 32729.5 |
| 183 | 2021-06-27 07:18:53 | piccata | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 182 | 2021-03-26 10:09:40 | piccata | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 181 | 2021-03-22 00:51:46 | piccata | 1 | 69583 | 1 | 1.190 | 58473.1 |
| 180 | 2021-03-18 17:58:29 | piccata | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 179 | 2021-03-18 05:08:12 | piccata | 1 | 69583 | 1 | 2.390 | 29114.2 |
| 178 | 2021-02-21 14:05:49 | piccata | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 177 | 2020-12-30 22:31:05 | piccata | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 176 | 2020-12-15 06:21:22 | piccata | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 175 | 2020-12-11 16:45:08 | piccata | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 174 | 2020-10-28 19:16:58 | piccata | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 173 | 2020-10-21 15:26:17 | piccata | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 172 | 2020-10-16 11:32:04 | piccata | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 171 | 2020-09-01 11:28:51 | piccata | 1 | 69583 | 1 | 1.453 | 47889.2 |
| 170 | 2020-05-18 12:04:57 | piccata | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 169 | 2020-03-29 21:10:10 | piccata | 1 | 69583 | 1 | 1.373 | 50679.5 |
| 168 | 2020-03-24 03:57:50 | piccata | 1 | 69583 | 1 | 1.390 | 50059.7 |
| 167 | 2020-03-23 23:57:22 | piccata | 1 | 69583 | 1 | 1.423 | 48898.8 |
| 166 | 2020-03-20 20:58:02 | piccata | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 165 | 2020-02-24 01:28:42 | piccata | 1 | 69583 | 1 | 2.500 | 27833.2 |
| 164 | 2020-02-23 17:30:22 | piccata | 1 | 69583 | 1 | 1.190 | 58473.1 |
| 163 | 2020-02-20 02:10:03 | piccata | 1 | 69583 | 1 | 1.406 | 49490.0 |
| 162 | 2020-02-17 20:37:51 | piccata | 1 | 69583 | 1 | 1.263 | 55093.4 |
| 161 | 2020-02-12 21:19:07 | piccata | 1 | 69583 | 1 | 1.486 | 46825.7 |
| 160 | 2020-02-06 18:59:21 | piccata | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 159 | 2020-02-02 01:37:51 | piccata | 1 | 69583 | 1 | 1.343 | 51811.6 |
| 158 | 2020-01-26 22:14:42 | piccata | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 157 | 2020-01-25 00:35:11 | piccata | 1 | 69583 | 1 | 2.720 | 25582.0 |
| 156 | 2020-01-20 17:14:32 | piccata | 1 | 69583 | 1 | 4.203 | 16555.6 |
| 155 | 2020-01-20 15:09:17 | piccata | 1 | 69583 | 1 | 2.750 | 25302.9 |
| 154 | 2020-01-16 05:05:14 | piccata | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 153 | 2020-01-07 03:10:05 | piccata | 1 | 69583 | 1 | 4.313 | 16133.3 |
| 152 | 2019-12-30 01:37:48 | piccata | 1 | 69583 | 1 | 1.673 | 41591.8 |
| 151 | 2019-12-29 23:55:36 | piccata | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 150 | 2019-12-29 06:01:39 | piccata | 1 | 69583 | 1 | 2.420 | 28753.3 |
| 149 | 2019-11-06 05:07:06 | piccata | 1 | 69583 | 1 | 1.060 | 65644.3 |
| 148 | 2019-08-05 00:41:06 | piccata | 1 | 69583 | 1 | 1.216 | 57222.9 |
| 147 | 2019-07-10 16:49:59 | piccata | 1 | 69583 | 1 | 1.070 | 65030.8 |
| 146 | 2019-04-25 15:04:40 | piccata | 1 | 69583 | 1 | 1.213 | 57364.4 |
| 145 | 2019-04-03 04:21:01 | piccata | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 144 | 2019-01-10 07:31:50 | piccata | 3 | 134027 | 74 | 6.886 | 19463.7 |
| 143 | 2019-01-08 09:00:41 | piccata | 3 | 134027 | 74 | 5.800 | 23108.1 |
| 142 | 2019-01-08 08:55:38 | piccata | 1 | 69583 | 1 | 1.376 | 50569.0 |
| 141 | 2019-01-07 03:00:53 | piccata | 1 | 69583 | 1 | 1.176 | 59169.2 |
| 140 | 2018-12-30 07:44:51 | piccata | 1 | 69583 | 1 | 1.200 | 57985.8 |
| 139 | 2018-12-29 14:09:42 | piccata | 3 | 134027 | 74 | 6.226 | 21527.0 |
| 138 | 2018-12-29 13:55:41 | piccata | 1 | 69583 | 1 | 1.040 | 66906.7 |
| 137 | 2018-11-15 23:31:59 | piccata | 1 | 69583 | 1 | 1.066 | 65274.9 |
| 136 | 2018-08-30 17:10:35 | piccata | 1 | 69583 | 1 | 1.430 | 48659.4 |
| 135 | 2018-07-02 21:38:47 | piccata | 1 | 69583 | 1 | 1.036 | 67165.1 |
| 134 | 2018-06-30 15:27:24 | piccata | 1 | 69583 | 1 | 2.076 | 33517.8 |