History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"melodies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 228 | 2024-04-08 08:47:37 | melodies | 1 | 82945 | 5 | 5.216 | 15902.0 |
| 227 | 2024-04-03 14:48:11 | melodies | 1 | 82945 | 5 | 2.046 | 40540.1 |
| 226 | 2024-02-20 23:28:30 | melodies | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 225 | 2024-01-31 10:15:35 | melodies | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 224 | 2024-01-27 19:09:04 | melodies | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 223 | 2024-01-06 21:57:39 | melodies | 3 | 146162 | 181 | 8.220 | 17781.3 |
| 222 | 2024-01-06 21:57:38 | melodies | 2 | 121059 | 26 | 8.016 | 15102.2 |
| 221 | 2023-11-21 19:15:02 | melodies | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 220 | 2023-11-19 00:31:33 | melodies | 1 | 82945 | 5 | 1.623 | 51106.0 |
| 219 | 2023-11-14 09:12:55 | melodies | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 218 | 2023-11-11 20:30:55 | melodies | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 217 | 2023-10-23 07:16:23 | melodies | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 216 | 2023-10-17 22:22:23 | melodies | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 215 | 2023-10-06 15:41:59 | melodies | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 214 | 2023-09-12 15:13:34 | melodies | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 213 | 2023-09-08 18:59:44 | melodies | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 212 | 2023-06-28 22:40:27 | melodies | 1 | 82945 | 5 | 1.300 | 63803.8 |
| 211 | 2023-06-12 03:16:43 | melodies | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 210 | 2023-03-29 02:25:39 | melodies | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 209 | 2023-03-12 23:02:21 | melodies | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 208 | 2023-01-13 14:25:28 | melodies | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 207 | 2022-11-21 10:21:40 | melodies | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 206 | 2022-10-26 02:22:17 | melodies | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 205 | 2022-07-28 14:55:05 | melodies | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 204 | 2022-06-30 19:24:59 | melodies | 2 | 121059 | 26 | 3.156 | 38358.4 |
| 203 | 2022-06-15 11:53:35 | melodies | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 202 | 2022-04-03 02:28:40 | melodies | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 201 | 2022-02-23 00:53:45 | melodies | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 200 | 2022-02-20 21:28:46 | melodies | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 199 | 2021-12-12 22:59:11 | melodies | 1 | 82945 | 5 | 1.736 | 47779.4 |
| 198 | 2021-12-10 02:06:23 | melodies | 1 | 82945 | 5 | 2.890 | 28700.7 |
| 197 | 2021-12-09 17:17:21 | melodies | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 196 | 2021-10-23 11:55:06 | melodies | 1 | 82945 | 5 | 1.716 | 48336.2 |
| 195 | 2021-10-21 11:58:24 | melodies | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 194 | 2021-09-28 13:39:15 | melodies | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 193 | 2021-09-20 19:35:03 | melodies | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 192 | 2021-09-20 02:27:43 | melodies | 1 | 82945 | 5 | 1.440 | 57600.7 |
| 191 | 2021-09-14 05:52:11 | melodies | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 190 | 2021-09-02 09:16:25 | melodies | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 189 | 2021-08-30 02:13:32 | melodies | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 188 | 2021-05-29 10:01:17 | melodies | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 187 | 2021-04-30 15:41:18 | melodies | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 186 | 2021-02-26 14:23:14 | melodies | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 185 | 2021-01-28 12:44:08 | melodies | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 184 | 2021-01-02 01:43:28 | melodies | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 183 | 2020-11-26 16:20:43 | melodies | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 182 | 2020-10-18 16:45:08 | melodies | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 181 | 2020-10-17 16:55:14 | melodies | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 180 | 2020-09-23 00:20:20 | melodies | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 179 | 2020-08-20 22:15:56 | melodies | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 178 | 2020-05-19 16:01:59 | melodies | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 177 | 2020-03-25 08:55:09 | melodies | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 176 | 2020-03-20 14:19:23 | melodies | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 175 | 2020-02-28 18:49:00 | melodies | 3 | 146162 | 181 | 9.296 | 15723.1 |
| 174 | 2020-02-28 15:18:39 | melodies | 3 | 146162 | 181 | 16.046 | 9108.9 |
| 173 | 2020-02-28 14:10:42 | melodies | 3 | 146162 | 181 | 13.826 | 10571.5 |
| 172 | 2020-02-28 01:47:19 | melodies | 3 | 146162 | 181 | 16.470 | 8874.4 |
| 171 | 2020-02-22 07:54:10 | melodies | 1 | 82945 | 5 | 3.453 | 24021.1 |
| 170 | 2020-02-20 11:13:13 | melodies | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 169 | 2020-02-19 14:26:14 | melodies | 1 | 82945 | 5 | 1.656 | 50087.6 |
| 168 | 2020-02-10 05:06:16 | melodies | 1 | 82945 | 5 | 3.030 | 27374.6 |
| 167 | 2020-02-08 02:14:14 | melodies | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 166 | 2020-02-03 16:45:32 | melodies | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 165 | 2020-02-02 01:34:24 | melodies | 1 | 82945 | 5 | 3.263 | 25419.9 |
| 164 | 2020-01-25 10:11:40 | melodies | 1 | 82945 | 5 | 1.670 | 49667.7 |
| 163 | 2020-01-20 11:12:35 | melodies | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 162 | 2020-01-19 02:51:50 | melodies | 1 | 82945 | 5 | 1.533 | 54106.3 |
| 161 | 2020-01-16 04:37:40 | melodies | 1 | 82945 | 5 | 3.530 | 23497.2 |
| 160 | 2020-01-13 19:53:13 | melodies | 3 | 146162 | 181 | 9.670 | 15115.0 |
| 159 | 2020-01-13 08:03:43 | melodies | 3 | 146162 | 181 | 8.953 | 16325.5 |
| 158 | 2020-01-13 03:09:25 | melodies | 3 | 146162 | 181 | 11.470 | 12743.0 |
| 157 | 2020-01-13 03:08:59 | melodies | 2 | 121059 | 26 | 3.906 | 30993.1 |
| 156 | 2020-01-13 01:48:09 | melodies | 1 | 82945 | 5 | 1.626 | 51011.7 |
| 155 | 2020-01-01 11:37:38 | melodies | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 154 | 2019-12-28 05:32:29 | melodies | 1 | 82945 | 5 | 1.513 | 54821.5 |
| 153 | 2019-12-27 16:37:24 | melodies | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 152 | 2019-12-26 22:35:33 | melodies | 1 | 82945 | 5 | 1.813 | 45750.1 |
| 151 | 2019-11-20 10:17:22 | melodies | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 150 | 2019-08-18 15:53:14 | melodies | 1 | 82945 | 5 | 1.226 | 67655.0 |
| 149 | 2019-05-18 22:21:02 | melodies | 1 | 82945 | 5 | 1.286 | 64498.4 |
| 148 | 2019-04-23 07:58:19 | melodies | 1 | 82945 | 5 | 1.510 | 54930.5 |
| 147 | 2019-03-29 10:47:04 | melodies | 1 | 82945 | 5 | 1.270 | 65311.0 |
| 146 | 2019-02-12 18:12:12 | melodies | 1 | 82945 | 5 | 1.460 | 56811.6 |
| 145 | 2019-02-12 14:56:02 | melodies | 1 | 82945 | 5 | 1.286 | 64498.4 |
| 144 | 2019-02-07 07:11:07 | melodies | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 143 | 2019-01-10 21:23:43 | melodies | 1 | 82945 | 5 | 1.246 | 66569.0 |
| 142 | 2018-11-28 19:47:58 | melodies | 3 | 146162 | 181 | 6.700 | 21815.2 |
| 141 | 2018-11-08 08:37:28 | melodies | 1 | 82945 | 5 | 1.290 | 64298.4 |
| 140 | 2018-09-30 07:40:50 | melodies | 2 | 121059 | 26 | 3.323 | 36430.6 |
| 139 | 2018-08-07 13:43:26 | melodies | 1 | 82945 | 5 | 1.700 | 48791.2 |
| 138 | 2018-08-05 20:50:34 | melodies | 1 | 82945 | 5 | 1.310 | 63316.8 |
| 137 | 2018-07-30 05:26:01 | melodies | 1 | 82945 | 5 | 1.303 | 63656.9 |
| 136 | 2018-06-09 16:13:50 | melodies | 1 | 82945 | 5 | 1.270 | 65311.0 |
| 135 | 2018-05-11 16:22:29 | melodies | 1 | 82945 | 5 | 1.446 | 57361.7 |
| 134 | 2018-05-05 19:30:57 | melodies | 1 | 82945 | 5 | 1.286 | 64498.4 |
| 133 | 2018-04-12 22:58:51 | melodies | 1 | 82945 | 5 | 1.270 | 65311.0 |
| 132 | 2018-04-03 11:13:42 | melodies | 1 | 82945 | 5 | 2.436 | 34049.7 |
| 131 | 2018-03-29 08:33:35 | melodies | 1 | 82945 | 5 | 1.843 | 45005.4 |
| 130 | 2018-03-10 03:50:15 | melodies | 1 | 82945 | 5 | 1.770 | 46861.6 |
| 129 | 2018-03-10 03:47:30 | melodies | 1 | 82945 | 5 | 1.720 | 48223.8 |