History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opiates"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 276 | 2024-05-04 17:56:38 | opiates | 1 | 69583 | 3 | 2.033 | 34226.8 |
| 275 | 2024-05-03 06:59:27 | opiates | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 274 | 2024-04-28 10:52:47 | opiates | 1 | 69583 | 3 | 2.576 | 27012.0 |
| 273 | 2024-04-06 10:21:15 | opiates | 1 | 69583 | 3 | 2.606 | 26701.1 |
| 272 | 2024-04-05 17:29:52 | opiates | 3 | 134027 | 434 | 28.266 | 4741.6 |
| 271 | 2024-04-05 15:35:49 | opiates | 3 | 134027 | 434 | 20.156 | 6649.5 |
| 270 | 2024-04-05 13:45:40 | opiates | 3 | 134027 | 434 | 21.250 | 6307.2 |
| 269 | 2024-04-05 13:45:41 | opiates | 2 | 107671 | 27 | 9.736 | 11059.1 |
| 268 | 2024-04-05 13:45:29 | opiates | 3 | 134027 | 434 | 9.173 | 14611.0 |
| 267 | 2024-04-05 13:45:34 | opiates | 1 | 69583 | 3 | 1.440 | 48321.5 |
| 266 | 2024-04-05 13:45:27 | opiates | 2 | 107671 | 27 | 3.656 | 29450.5 |
| 265 | 2024-04-05 13:45:27 | opiates | 1 | 69583 | 3 | 2.906 | 23944.6 |
| 264 | 2024-04-01 17:19:02 | opiates | 1 | 69583 | 3 | 2.876 | 24194.4 |
| 263 | 2024-03-29 12:23:04 | opiates | 1 | 69583 | 3 | 2.876 | 24194.4 |
| 262 | 2024-02-27 22:12:13 | opiates | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 261 | 2024-01-26 20:48:38 | opiates | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 260 | 2024-01-06 20:17:30 | opiates | 3 | 134027 | 434 | 6.656 | 20136.3 |
| 259 | 2024-01-06 20:17:27 | opiates | 2 | 107671 | 27 | 3.203 | 33615.7 |
| 258 | 2024-01-06 12:49:06 | opiates | 3 | 134027 | 434 | 6.530 | 20524.8 |
| 257 | 2024-01-06 12:49:05 | opiates | 2 | 107671 | 27 | 3.186 | 33795.0 |
| 256 | 2023-12-27 08:05:16 | opiates | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 255 | 2023-11-18 14:48:41 | opiates | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 254 | 2023-11-14 12:32:54 | opiates | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 253 | 2023-11-06 11:33:03 | opiates | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 252 | 2023-10-31 14:45:18 | opiates | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 251 | 2023-10-19 06:19:56 | opiates | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 250 | 2023-09-26 21:45:42 | opiates | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 249 | 2023-09-21 00:38:46 | opiates | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 248 | 2023-06-10 10:23:15 | opiates | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 247 | 2023-02-22 09:23:35 | opiates | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 246 | 2022-11-05 09:52:46 | opiates | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 245 | 2022-11-01 21:48:35 | opiates | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 244 | 2022-10-07 19:17:30 | opiates | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 243 | 2022-07-19 12:44:53 | opiates | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 242 | 2022-07-02 01:56:28 | opiates | 3 | 134027 | 434 | 5.750 | 23309.0 |
| 241 | 2022-07-01 13:33:16 | opiates | 2 | 107671 | 27 | 2.750 | 39153.1 |
| 240 | 2022-05-24 02:20:15 | opiates | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 239 | 2022-03-22 01:15:09 | opiates | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 238 | 2022-03-18 14:44:51 | opiates | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 237 | 2022-02-07 14:16:47 | opiates | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 236 | 2021-12-11 09:22:03 | opiates | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 235 | 2021-11-25 04:02:54 | opiates | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 234 | 2021-10-25 06:34:54 | opiates | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 233 | 2021-09-07 07:22:33 | opiates | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 232 | 2021-06-06 08:58:47 | opiates | 1 | 69583 | 3 | 1.153 | 60349.5 |
| 231 | 2021-06-03 04:11:28 | opiates | 1 | 69583 | 3 | 1.043 | 66714.3 |
| 230 | 2021-05-13 18:19:23 | opiates | 1 | 69583 | 3 | 1.310 | 53116.8 |
| 229 | 2021-04-12 17:01:11 | opiates | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 228 | 2021-02-28 17:10:32 | opiates | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 227 | 2021-02-19 12:51:56 | opiates | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 226 | 2020-12-01 06:41:32 | opiates | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 225 | 2020-11-28 21:56:24 | opiates | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 224 | 2020-10-31 13:52:44 | opiates | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 223 | 2020-10-31 03:47:18 | opiates | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 222 | 2020-09-16 05:45:43 | opiates | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 221 | 2020-08-30 13:01:09 | opiates | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 220 | 2020-08-25 16:06:16 | opiates | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 219 | 2020-08-19 17:57:17 | opiates | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 218 | 2020-07-17 13:36:54 | opiates | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 217 | 2020-05-24 06:39:29 | opiates | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 216 | 2020-03-28 09:42:34 | opiates | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 215 | 2020-03-24 15:24:24 | opiates | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 214 | 2020-03-22 02:58:53 | opiates | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 213 | 2020-03-20 00:05:12 | opiates | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 212 | 2020-02-22 21:51:53 | opiates | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 211 | 2020-02-21 01:28:23 | opiates | 1 | 69583 | 3 | 1.253 | 55533.1 |
| 210 | 2020-02-19 11:28:16 | opiates | 1 | 69583 | 3 | 2.483 | 28023.8 |
| 209 | 2020-02-14 05:28:32 | opiates | 1 | 69583 | 3 | 2.593 | 26834.9 |
| 208 | 2020-02-05 20:31:00 | opiates | 1 | 69583 | 3 | 1.810 | 38443.6 |
| 207 | 2020-02-05 11:46:17 | opiates | 1 | 69583 | 3 | 2.016 | 34515.4 |
| 206 | 2020-01-31 12:28:43 | opiates | 1 | 69583 | 3 | 3.140 | 22160.2 |
| 205 | 2020-01-31 09:08:32 | opiates | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 204 | 2020-01-26 22:12:17 | opiates | 1 | 69583 | 3 | 2.750 | 25302.9 |
| 203 | 2020-01-23 11:03:51 | opiates | 1 | 69583 | 3 | 1.376 | 50569.0 |
| 202 | 2020-01-15 19:09:10 | opiates | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 201 | 2020-01-15 07:26:43 | opiates | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 200 | 2020-01-15 06:45:05 | opiates | 1 | 69583 | 3 | 2.390 | 29114.2 |
| 199 | 2020-01-12 03:07:26 | opiates | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 198 | 2020-01-03 14:28:46 | opiates | 1 | 69583 | 3 | 2.500 | 27833.2 |
| 197 | 2019-12-27 18:44:37 | opiates | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 196 | 2019-12-27 05:49:08 | opiates | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 195 | 2019-12-27 02:56:06 | opiates | 1 | 69583 | 3 | 1.300 | 53525.4 |
| 194 | 2019-12-26 21:17:36 | opiates | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 193 | 2019-11-22 03:40:13 | opiates | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 192 | 2019-08-20 05:11:48 | opiates | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 191 | 2019-08-13 22:09:41 | opiates | 1 | 69583 | 3 | 0.996 | 69862.4 |
| 190 | 2019-05-20 12:12:26 | opiates | 1 | 69583 | 3 | 1.336 | 52083.1 |
| 189 | 2019-03-17 13:32:31 | opiates | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 188 | 2019-03-08 23:03:14 | opiates | 1 | 69583 | 3 | 1.010 | 68894.1 |
| 187 | 2019-03-04 02:30:19 | opiates | 1 | 69583 | 3 | 1.026 | 67819.7 |
| 186 | 2019-02-14 08:15:44 | opiates | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 185 | 2019-02-02 02:40:45 | opiates | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 184 | 2019-01-31 07:15:58 | opiates | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 183 | 2019-01-29 10:49:15 | opiates | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 182 | 2019-01-13 16:39:41 | opiates | 1 | 69583 | 3 | 1.103 | 63085.2 |
| 181 | 2019-01-06 05:23:09 | opiates | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 180 | 2018-12-08 17:24:26 | opiates | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 179 | 2018-12-02 23:33:54 | opiates | 1 | 69583 | 3 | 1.003 | 69374.9 |
| 178 | 2018-11-19 18:10:56 | opiates | 1 | 69583 | 3 | 1.146 | 60718.2 |
| 177 | 2018-11-09 21:24:33 | opiates | 1 | 69583 | 3 | 1.213 | 57364.4 |