History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"optometer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 319 | 2024-12-23 16:13:53 | optometer | 3 | 148641 | 58 | 42.203 | 3522.0 |
| 318 | 2024-12-23 16:13:57 | optometer | 3 | 148641 | 58 | 36.530 | 4069.0 |
| 317 | 2024-12-22 19:47:14 | optometer | 3 | 148641 | 58 | 40.020 | 3714.2 |
| 316 | 2024-12-22 11:03:25 | optometer | 3 | 148641 | 58 | 50.033 | 2970.9 |
| 315 | 2024-12-22 11:00:33 | optometer | 3 | 148641 | 58 | 44.893 | 3311.0 |
| 314 | 2024-12-22 09:39:36 | optometer | 4 | 165329 | 256 | 69.503 | 2378.7 |
| 313 | 2024-12-22 09:39:42 | optometer | 2 | 121436 | 9 | 26.516 | 4579.7 |
| 312 | 2024-12-22 09:39:36 | optometer | 3 | 148641 | 58 | 31.203 | 4763.7 |
| 311 | 2024-12-22 09:38:47 | optometer | 1 | 81242 | 3 | 6.220 | 13061.4 |
| 310 | 2024-12-16 17:03:29 | optometer | 2 | 121436 | 9 | 3.563 | 34082.5 |
| 309 | 2024-12-04 22:09:21 | optometer | 1 | 81242 | 3 | 9.110 | 8917.9 |
| 308 | 2024-11-29 18:00:35 | optometer | 2 | 121436 | 9 | 20.003 | 6070.9 |
| 307 | 2024-11-29 17:39:59 | optometer | 1 | 81242 | 3 | 5.580 | 14559.5 |
| 306 | 2024-11-21 13:45:33 | optometer | 4 | 165329 | 256 | 66.503 | 2486.0 |
| 305 | 2024-11-21 13:45:20 | optometer | 2 | 121436 | 9 | 24.110 | 5036.7 |
| 304 | 2024-11-21 08:17:13 | optometer | 4 | 165329 | 256 | 53.283 | 3102.8 |
| 303 | 2024-11-21 08:17:24 | optometer | 2 | 121436 | 9 | 17.796 | 6823.8 |
| 302 | 2024-11-21 08:16:51 | optometer | 1 | 81242 | 3 | 6.376 | 12741.8 |
| 301 | 2024-11-18 07:42:58 | optometer | 3 | 148641 | 58 | 20.080 | 7402.4 |
| 300 | 2024-11-17 02:33:34 | optometer | 3 | 148641 | 58 | 32.496 | 4574.1 |
| 299 | 2024-11-15 23:39:33 | optometer | 3 | 148641 | 58 | 34.623 | 4293.1 |
| 298 | 2024-11-14 11:38:29 | optometer | 3 | 148641 | 58 | 35.096 | 4235.3 |
| 297 | 2024-11-12 21:08:32 | optometer | 3 | 148641 | 58 | 28.753 | 5169.6 |
| 296 | 2024-11-11 21:47:14 | optometer | 3 | 148641 | 58 | 43.156 | 3444.3 |
| 295 | 2024-11-10 07:33:45 | optometer | 1 | 81242 | 3 | 2.986 | 27207.6 |
| 294 | 2024-11-08 01:10:37 | optometer | 3 | 148641 | 58 | 21.423 | 6938.4 |
| 293 | 2024-11-08 01:07:15 | optometer | 2 | 121436 | 9 | 8.470 | 14337.2 |
| 292 | 2024-10-26 19:36:50 | optometer | 1 | 81242 | 3 | 7.126 | 11400.8 |
| 291 | 2024-10-20 21:43:09 | optometer | 2 | 121436 | 9 | 11.130 | 10910.7 |
| 290 | 2024-10-12 12:33:09 | optometer | 3 | 148641 | 58 | 28.533 | 5209.4 |
| 289 | 2024-10-11 21:37:23 | optometer | 2 | 121436 | 9 | 17.250 | 7039.8 |
| 288 | 2024-10-10 10:34:05 | optometer | 3 | 148641 | 58 | 43.436 | 3422.1 |
| 287 | 2024-10-08 07:55:41 | optometer | 3 | 148641 | 58 | 89.923 | 1653.0 |
| 286 | 2024-10-08 05:15:54 | optometer | 3 | 148641 | 58 | 50.253 | 2957.9 |
| 285 | 2024-10-08 04:40:08 | optometer | 3 | 148641 | 58 | 70.626 | 2104.6 |
| 284 | 2024-10-08 04:17:20 | optometer | 4 | 165329 | 256 | 80.003 | 2066.5 |
| 283 | 2024-10-08 04:17:30 | optometer | 3 | 148641 | 58 | 62.896 | 2363.3 |
| 282 | 2024-10-08 04:17:22 | optometer | 2 | 121436 | 9 | 26.046 | 4662.4 |
| 281 | 2024-10-04 20:13:52 | optometer | 1 | 81242 | 3 | 8.250 | 9847.5 |
| 280 | 2024-10-01 17:59:39 | optometer | 1 | 81242 | 3 | 10.030 | 8099.9 |
| 279 | 2024-09-22 15:16:33 | optometer | 1 | 81242 | 3 | 15.156 | 5360.4 |
| 278 | 2024-08-17 01:28:03 | optometer | 1 | 81242 | 3 | 11.093 | 7323.7 |
| 277 | 2024-08-16 02:24:34 | optometer | 1 | 81242 | 3 | 13.720 | 5921.4 |
| 276 | 2024-08-12 02:56:23 | optometer | 1 | 81242 | 3 | 4.076 | 19931.8 |
| 275 | 2024-08-03 06:14:09 | optometer | 3 | 148641 | 58 | 21.346 | 6963.4 |
| 274 | 2024-07-29 08:31:50 | optometer | 1 | 81242 | 3 | 4.313 | 18836.5 |
| 273 | 2024-07-14 16:08:10 | optometer | 1 | 81242 | 3 | 4.030 | 20159.3 |
| 272 | 2024-07-14 08:02:52 | optometer | 3 | 148641 | 58 | 39.970 | 3718.8 |
| 271 | 2024-07-14 02:13:10 | optometer | 4 | 165329 | 256 | 70.650 | 2340.1 |
| 270 | 2024-07-14 02:13:19 | optometer | 2 | 121436 | 9 | 19.893 | 6104.5 |
| 269 | 2024-07-14 02:13:12 | optometer | 3 | 148641 | 58 | 22.346 | 6651.8 |
| 268 | 2024-07-14 02:10:21 | optometer | 1 | 81242 | 3 | 4.516 | 17989.8 |
| 267 | 2024-07-11 01:53:21 | optometer | 1 | 81242 | 3 | 4.860 | 16716.5 |
| 266 | 2024-07-10 20:17:43 | optometer | 1 | 81242 | 3 | 3.763 | 21589.7 |
| 265 | 2024-07-09 04:28:17 | optometer | 1 | 81242 | 3 | 2.533 | 32073.4 |
| 264 | 2024-07-08 21:47:20 | optometer | 4 | 165329 | 256 | 45.440 | 3638.4 |
| 263 | 2024-07-05 16:37:15 | optometer | 1 | 81242 | 3 | 6.750 | 12035.9 |
| 262 | 2024-07-05 16:05:23 | optometer | 1 | 81242 | 3 | 3.343 | 24302.1 |
| 261 | 2024-07-05 08:34:49 | optometer | 4 | 165329 | 256 | 74.646 | 2214.8 |
| 260 | 2024-07-02 18:50:58 | optometer | 4 | 165329 | 256 | 41.393 | 3994.1 |
| 259 | 2024-06-20 20:03:59 | optometer | 1 | 81242 | 3 | 5.203 | 15614.5 |
| 258 | 2024-06-18 09:15:42 | optometer | 3 | 148641 | 58 | 23.736 | 6262.3 |
| 257 | 2024-06-18 01:08:05 | optometer | 1 | 81242 | 3 | 7.360 | 11038.3 |
| 256 | 2024-06-13 21:41:06 | optometer | 3 | 148641 | 58 | 10.576 | 14054.6 |
| 255 | 2024-06-11 12:36:20 | optometer | 4 | 165329 | 256 | 54.050 | 3058.8 |
| 254 | 2024-06-11 12:36:25 | optometer | 3 | 148641 | 58 | 30.830 | 4821.3 |
| 253 | 2024-06-11 12:36:20 | optometer | 2 | 121436 | 9 | 9.936 | 12221.8 |
| 252 | 2024-06-11 12:33:22 | optometer | 1 | 81242 | 3 | 4.826 | 16834.2 |
| 251 | 2024-06-07 01:35:39 | optometer | 1 | 81242 | 3 | 7.423 | 10944.6 |
| 250 | 2024-06-05 00:31:01 | optometer | 1 | 81242 | 3 | 1.860 | 43678.5 |
| 249 | 2024-06-02 00:06:34 | optometer | 1 | 81242 | 3 | 2.846 | 28546.0 |
| 248 | 2024-05-31 23:18:54 | optometer | 1 | 81242 | 3 | 4.673 | 17385.4 |
| 247 | 2024-05-31 19:57:05 | optometer | 1 | 81242 | 3 | 2.720 | 29868.4 |
| 246 | 2024-05-22 12:56:45 | optometer | 3 | 148641 | 58 | 15.813 | 9399.9 |
| 245 | 2024-05-22 06:32:56 | optometer | 4 | 165329 | 256 | 32.126 | 5146.3 |
| 244 | 2024-05-22 04:09:35 | optometer | 4 | 165329 | 256 | 37.690 | 4386.5 |
| 243 | 2024-05-22 03:12:08 | optometer | 4 | 165329 | 256 | 39.860 | 4147.7 |
| 242 | 2024-05-21 07:53:18 | optometer | 4 | 165329 | 256 | 38.656 | 4276.9 |
| 241 | 2024-05-21 07:53:16 | optometer | 3 | 148641 | 58 | 9.403 | 15807.8 |
| 240 | 2024-05-21 07:53:06 | optometer | 2 | 121436 | 9 | 9.513 | 12765.3 |
| 239 | 2024-05-21 06:01:15 | optometer | 4 | 165329 | 256 | 22.686 | 7287.7 |
| 238 | 2024-05-21 06:01:18 | optometer | 2 | 121436 | 9 | 10.110 | 12011.5 |
| 237 | 2024-05-21 06:01:00 | optometer | 3 | 148641 | 58 | 9.720 | 15292.3 |
| 236 | 2024-05-21 06:00:50 | optometer | 1 | 81242 | 3 | 5.080 | 15992.5 |
| 235 | 2024-05-07 13:49:01 | optometer | 1 | 81242 | 3 | 1.766 | 46003.4 |
| 234 | 2024-05-03 11:51:32 | optometer | 2 | 121436 | 9 | 3.563 | 34082.5 |
| 233 | 2024-05-02 06:57:12 | optometer | 4 | 165329 | 256 | 11.546 | 14319.2 |
| 232 | 2024-05-01 11:48:24 | optometer | 4 | 165329 | 256 | 40.066 | 4126.4 |
| 231 | 2024-04-30 11:45:11 | optometer | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 230 | 2024-04-26 21:45:10 | optometer | 2 | 121436 | 9 | 11.920 | 10187.6 |
| 229 | 2024-04-25 06:38:08 | optometer | 2 | 121436 | 9 | 7.563 | 16056.6 |
| 228 | 2024-04-25 06:11:32 | optometer | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 227 | 2024-04-25 00:34:33 | optometer | 3 | 148641 | 58 | 14.250 | 10430.9 |
| 226 | 2024-04-22 09:25:55 | optometer | 3 | 148641 | 58 | 18.940 | 7848.0 |
| 225 | 2024-04-21 08:02:22 | optometer | 4 | 165329 | 256 | 33.690 | 4907.4 |
| 224 | 2024-04-21 08:02:27 | optometer | 3 | 148641 | 58 | 19.050 | 7802.7 |
| 223 | 2024-04-20 00:34:35 | optometer | 3 | 148641 | 58 | 23.110 | 6431.9 |
| 222 | 2024-04-20 00:25:49 | optometer | 3 | 148641 | 58 | 17.703 | 8396.4 |
| 221 | 2024-04-20 00:24:02 | optometer | 1 | 81242 | 3 | 4.440 | 18297.7 |
| 220 | 2024-04-19 23:14:57 | optometer | 4 | 165329 | 256 | 42.770 | 3865.5 |