History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"camellia"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 273 | 2024-04-25 20:52:00 | camellia | 1 | 82945 | 3 | 1.673 | 49578.6 |
| 272 | 2024-04-25 18:13:24 | camellia | 3 | 146162 | 40 | 18.546 | 7881.1 |
| 271 | 2024-04-25 18:13:30 | camellia | 2 | 121059 | 8 | 9.046 | 13382.6 |
| 270 | 2024-04-25 18:13:17 | camellia | 1 | 82945 | 3 | 2.766 | 29987.3 |
| 269 | 2024-04-25 18:13:04 | camellia | 2 | 121059 | 8 | 6.796 | 17813.3 |
| 268 | 2024-04-24 19:48:44 | camellia | 2 | 121059 | 8 | 4.640 | 26090.3 |
| 267 | 2024-04-24 18:07:51 | camellia | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 266 | 2024-04-16 06:48:19 | camellia | 2 | 121059 | 8 | 4.030 | 30039.5 |
| 265 | 2024-04-16 06:48:19 | camellia | 1 | 82945 | 3 | 3.000 | 27648.3 |
| 264 | 2024-04-16 00:32:15 | camellia | 2 | 121059 | 8 | 3.720 | 32542.7 |
| 263 | 2024-04-12 08:08:12 | camellia | 3 | 146162 | 40 | 20.093 | 7274.3 |
| 262 | 2024-04-10 20:49:48 | camellia | 4 | 161609 | 429 | 51.893 | 3114.3 |
| 261 | 2024-04-09 18:14:17 | camellia | 4 | 161609 | 429 | 24.173 | 6685.5 |
| 260 | 2024-04-09 05:29:59 | camellia | 3 | 146162 | 40 | 17.906 | 8162.7 |
| 259 | 2024-04-09 01:09:29 | camellia | 4 | 161609 | 429 | 14.326 | 11280.8 |
| 258 | 2024-04-08 13:38:54 | camellia | 4 | 161609 | 429 | 15.706 | 10289.6 |
| 257 | 2024-04-08 04:57:17 | camellia | 4 | 161609 | 429 | 21.610 | 7478.4 |
| 256 | 2024-04-08 04:57:19 | camellia | 3 | 146162 | 40 | 12.753 | 11461.0 |
| 255 | 2024-04-08 04:57:20 | camellia | 2 | 121059 | 8 | 4.390 | 27576.1 |
| 254 | 2024-04-08 04:57:17 | camellia | 1 | 82945 | 3 | 2.343 | 35401.2 |
| 253 | 2024-03-31 03:08:35 | camellia | 1 | 82945 | 3 | 4.546 | 18245.7 |
| 252 | 2024-03-25 14:54:09 | camellia | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 251 | 2024-03-22 10:35:32 | camellia | 2 | 121059 | 8 | 3.563 | 33976.7 |
| 250 | 2024-03-19 21:52:34 | camellia | 2 | 121059 | 8 | 7.263 | 16667.9 |
| 249 | 2024-03-19 20:29:50 | camellia | 1 | 82945 | 3 | 2.826 | 29350.7 |
| 248 | 2024-03-03 09:18:04 | camellia | 2 | 121059 | 8 | 3.843 | 31501.2 |
| 247 | 2024-03-03 09:18:04 | camellia | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 246 | 2024-03-01 03:20:11 | camellia | 3 | 146162 | 40 | 11.720 | 12471.2 |
| 245 | 2024-02-29 18:25:31 | camellia | 3 | 146162 | 40 | 7.140 | 20470.9 |
| 244 | 2024-02-29 18:25:26 | camellia | 2 | 121059 | 8 | 4.300 | 28153.3 |
| 243 | 2024-02-29 18:04:37 | camellia | 4 | 161609 | 429 | 13.940 | 11593.2 |
| 242 | 2024-02-29 00:13:00 | camellia | 4 | 161609 | 429 | 14.126 | 11440.5 |
| 241 | 2024-02-28 15:50:11 | camellia | 4 | 161609 | 429 | 23.673 | 6826.7 |
| 240 | 2024-02-28 14:08:57 | camellia | 4 | 161609 | 429 | 13.796 | 11714.2 |
| 239 | 2024-02-28 14:08:55 | camellia | 3 | 146162 | 40 | 8.000 | 18270.3 |
| 238 | 2024-02-28 14:08:53 | camellia | 2 | 121059 | 8 | 3.953 | 30624.6 |
| 237 | 2024-02-28 14:08:52 | camellia | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 236 | 2024-01-27 11:58:00 | camellia | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 235 | 2024-01-20 06:25:47 | camellia | 3 | 146162 | 40 | 6.580 | 22213.1 |
| 234 | 2024-01-15 08:04:55 | camellia | 1 | 82945 | 3 | 1.550 | 53512.9 |
| 233 | 2023-12-23 21:37:14 | camellia | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 232 | 2023-12-19 17:26:55 | camellia | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 231 | 2023-12-13 17:01:00 | camellia | 2 | 121059 | 8 | 3.330 | 36354.1 |
| 230 | 2023-12-01 19:22:24 | camellia | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 229 | 2023-11-29 12:32:51 | camellia | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 228 | 2023-11-24 04:01:16 | camellia | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 227 | 2023-11-04 14:58:03 | camellia | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 226 | 2023-10-31 01:58:19 | camellia | 3 | 146162 | 40 | 6.876 | 21256.8 |
| 225 | 2023-10-15 14:00:55 | camellia | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 224 | 2023-09-16 11:43:32 | camellia | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 223 | 2023-09-13 03:08:33 | camellia | 2 | 121059 | 8 | 3.296 | 36729.1 |
| 222 | 2023-09-10 13:56:26 | camellia | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 221 | 2023-09-01 19:20:55 | camellia | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 220 | 2023-08-07 21:41:46 | camellia | 3 | 146162 | 40 | 7.436 | 19656.0 |
| 219 | 2023-07-14 22:35:51 | camellia | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 218 | 2023-06-12 18:06:05 | camellia | 2 | 121059 | 8 | 3.186 | 37997.2 |
| 217 | 2023-06-10 17:38:09 | camellia | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 216 | 2023-05-05 03:39:47 | camellia | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 215 | 2023-04-21 04:31:28 | camellia | 3 | 146162 | 40 | 6.280 | 23274.2 |
| 214 | 2023-03-30 02:49:15 | camellia | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 213 | 2023-03-13 10:13:57 | camellia | 2 | 121059 | 8 | 3.250 | 37248.9 |
| 212 | 2023-01-26 15:39:40 | camellia | 3 | 146162 | 40 | 6.313 | 23152.5 |
| 211 | 2023-01-14 07:30:01 | camellia | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 210 | 2023-01-11 15:34:03 | camellia | 1 | 82945 | 3 | 2.580 | 32149.2 |
| 209 | 2022-12-17 19:46:41 | camellia | 2 | 121059 | 8 | 3.186 | 37997.2 |
| 208 | 2022-11-07 16:56:12 | camellia | 3 | 146162 | 40 | 6.580 | 22213.1 |
| 207 | 2022-10-30 18:07:23 | camellia | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 206 | 2022-09-09 18:20:45 | camellia | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 205 | 2022-09-01 18:51:49 | camellia | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 204 | 2022-08-10 01:56:44 | camellia | 2 | 121059 | 8 | 3.200 | 37830.9 |
| 203 | 2022-08-06 14:13:43 | camellia | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 202 | 2022-06-18 19:57:51 | camellia | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 201 | 2022-06-05 06:31:46 | camellia | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 200 | 2022-05-17 07:38:19 | camellia | 3 | 146162 | 40 | 7.470 | 19566.5 |
| 199 | 2022-05-10 19:26:50 | camellia | 1 | 82945 | 3 | 1.670 | 49667.7 |
| 198 | 2022-04-26 18:55:39 | camellia | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 197 | 2022-03-06 17:54:27 | camellia | 2 | 121059 | 8 | 3.250 | 37248.9 |
| 196 | 2022-02-21 23:06:10 | camellia | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 195 | 2022-02-19 19:26:52 | camellia | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 194 | 2022-01-08 04:07:36 | camellia | 3 | 146162 | 40 | 7.156 | 20425.1 |
| 193 | 2021-12-31 11:16:48 | camellia | 1 | 82945 | 3 | 1.860 | 44594.1 |
| 192 | 2021-12-10 21:51:23 | camellia | 2 | 121059 | 8 | 3.670 | 32986.1 |
| 191 | 2021-12-09 00:34:28 | camellia | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 190 | 2021-11-05 20:09:12 | camellia | 3 | 146162 | 40 | 6.893 | 21204.4 |
| 189 | 2021-10-20 10:30:12 | camellia | 1 | 82945 | 3 | 1.356 | 61168.9 |
| 188 | 2021-10-14 19:58:27 | camellia | 3 | 146162 | 40 | 7.080 | 20644.4 |
| 187 | 2021-09-21 03:36:28 | camellia | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 186 | 2021-09-14 18:13:37 | camellia | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 185 | 2021-06-14 16:04:11 | camellia | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 184 | 2021-03-24 15:39:23 | camellia | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 183 | 2021-03-08 05:07:33 | camellia | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 182 | 2021-02-03 01:07:21 | camellia | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 181 | 2021-01-07 08:17:56 | camellia | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 180 | 2020-12-24 12:41:53 | camellia | 2 | 121059 | 8 | 3.580 | 33815.4 |
| 179 | 2020-12-04 15:02:13 | camellia | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 178 | 2020-11-14 13:35:25 | camellia | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 177 | 2020-11-03 19:25:35 | camellia | 2 | 121059 | 8 | 3.813 | 31749.0 |
| 176 | 2020-11-01 05:12:58 | camellia | 3 | 146162 | 40 | 6.593 | 22169.3 |
| 175 | 2020-10-30 02:50:52 | camellia | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 174 | 2020-10-28 16:55:05 | camellia | 1 | 82945 | 3 | 1.313 | 63172.1 |