History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"optometry"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 248 | 2024-06-02 14:45:40 | optometry | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 247 | 2024-06-01 23:59:43 | optometry | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 246 | 2024-05-30 17:14:07 | optometry | 1 | 81242 | 1 | 1.440 | 56418.1 |
| 245 | 2024-05-22 21:51:28 | optometry | 1 | 81242 | 1 | 1.580 | 51419.0 |
| 244 | 2024-05-12 23:09:10 | optometry | 1 | 81242 | 1 | 3.126 | 25989.1 |
| 243 | 2024-05-09 08:07:40 | optometry | 4 | 165329 | 100 | 20.390 | 8108.3 |
| 242 | 2024-05-02 12:31:58 | optometry | 2 | 121436 | 6 | 9.216 | 13176.6 |
| 241 | 2024-05-02 10:48:19 | optometry | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 240 | 2024-05-02 10:48:18 | optometry | 1 | 81242 | 1 | 1.530 | 53099.3 |
| 239 | 2024-04-30 02:38:00 | optometry | 5 | 174418 | 899 | 61.786 | 2822.9 |
| 238 | 2024-04-28 10:05:49 | optometry | 3 | 148641 | 34 | 26.236 | 5665.5 |
| 237 | 2024-04-27 17:54:50 | optometry | 3 | 148641 | 34 | 9.830 | 15121.2 |
| 236 | 2024-04-27 11:10:21 | optometry | 4 | 165329 | 100 | 25.613 | 6454.9 |
| 235 | 2024-04-26 21:46:51 | optometry | 3 | 148641 | 34 | 20.660 | 7194.6 |
| 234 | 2024-04-26 21:45:02 | optometry | 4 | 165329 | 100 | 42.690 | 3872.8 |
| 233 | 2024-04-26 21:45:25 | optometry | 2 | 121436 | 6 | 10.063 | 12067.6 |
| 232 | 2024-04-26 16:29:50 | optometry | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 231 | 2024-04-25 06:38:58 | optometry | 3 | 148641 | 34 | 26.283 | 5655.4 |
| 230 | 2024-04-25 06:38:59 | optometry | 2 | 121436 | 6 | 11.860 | 10239.1 |
| 229 | 2024-04-25 06:08:42 | optometry | 1 | 81242 | 1 | 1.513 | 53696.0 |
| 228 | 2024-04-23 14:44:08 | optometry | 4 | 165329 | 100 | 30.906 | 5349.4 |
| 227 | 2024-04-22 11:01:32 | optometry | 4 | 165329 | 100 | 23.220 | 7120.1 |
| 226 | 2024-04-22 10:59:17 | optometry | 4 | 165329 | 100 | 39.986 | 4134.7 |
| 225 | 2024-04-21 08:45:55 | optometry | 2 | 121436 | 6 | 7.966 | 15244.3 |
| 224 | 2024-04-16 00:07:49 | optometry | 4 | 165329 | 100 | 46.003 | 3593.9 |
| 223 | 2024-04-15 23:40:27 | optometry | 4 | 165329 | 100 | 50.143 | 3297.2 |
| 222 | 2024-04-15 19:49:23 | optometry | 4 | 165329 | 100 | 61.943 | 2669.1 |
| 221 | 2024-04-15 19:49:22 | optometry | 4 | 165329 | 100 | 18.030 | 9169.7 |
| 220 | 2024-04-15 12:12:20 | optometry | 4 | 165329 | 100 | 56.270 | 2938.1 |
| 219 | 2024-04-15 11:37:36 | optometry | 5 | 174418 | 899 | 58.910 | 2960.8 |
| 218 | 2024-04-15 11:37:35 | optometry | 4 | 165329 | 100 | 33.173 | 4983.8 |
| 217 | 2024-04-15 11:37:38 | optometry | 2 | 121436 | 6 | 5.423 | 22392.8 |
| 216 | 2024-04-15 11:37:05 | optometry | 1 | 81242 | 1 | 1.826 | 44491.8 |
| 215 | 2024-04-08 03:40:15 | optometry | 3 | 148641 | 34 | 12.203 | 12180.7 |
| 214 | 2024-03-30 22:13:53 | optometry | 1 | 81242 | 1 | 2.796 | 29056.5 |
| 213 | 2024-03-25 20:46:41 | optometry | 4 | 165329 | 100 | 29.363 | 5630.5 |
| 212 | 2024-03-25 20:43:51 | optometry | 3 | 148641 | 34 | 8.750 | 16987.5 |
| 211 | 2024-03-25 20:42:43 | optometry | 2 | 121436 | 6 | 16.703 | 7270.3 |
| 210 | 2024-03-25 20:42:20 | optometry | 4 | 165329 | 100 | 20.156 | 8202.5 |
| 209 | 2024-03-25 17:22:47 | optometry | 1 | 81242 | 1 | 1.453 | 55913.3 |
| 208 | 2024-03-23 18:21:06 | optometry | 4 | 165329 | 100 | 36.050 | 4586.1 |
| 207 | 2024-03-22 21:43:02 | optometry | 4 | 165329 | 100 | 21.953 | 7531.0 |
| 206 | 2024-03-22 21:43:14 | optometry | 1 | 81242 | 1 | 2.906 | 27956.6 |
| 205 | 2024-03-22 21:43:08 | optometry | 2 | 121436 | 6 | 7.533 | 16120.5 |
| 204 | 2024-03-22 21:43:03 | optometry | 3 | 148641 | 34 | 7.813 | 19024.8 |
| 203 | 2024-03-22 21:42:51 | optometry | 1 | 81242 | 1 | 1.483 | 54782.2 |
| 202 | 2024-03-06 20:35:59 | optometry | 1 | 81242 | 1 | 3.936 | 20640.8 |
| 201 | 2024-02-29 09:32:48 | optometry | 2 | 121436 | 6 | 5.030 | 24142.3 |
| 200 | 2024-02-29 09:32:33 | optometry | 3 | 148641 | 34 | 8.936 | 16634.0 |
| 199 | 2024-02-29 09:32:01 | optometry | 4 | 165329 | 100 | 12.596 | 13125.5 |
| 198 | 2024-02-27 18:44:46 | optometry | 3 | 148641 | 34 | 8.610 | 17263.8 |
| 197 | 2024-02-27 18:44:45 | optometry | 2 | 121436 | 6 | 3.860 | 31460.1 |
| 196 | 2024-02-27 18:44:20 | optometry | 1 | 81242 | 1 | 1.643 | 49447.4 |
| 195 | 2024-02-27 18:43:54 | optometry | 4 | 165329 | 100 | 19.673 | 8403.9 |
| 194 | 2024-02-27 09:56:12 | optometry | 1 | 81242 | 1 | 1.310 | 62016.8 |
| 193 | 2024-02-22 16:38:22 | optometry | 4 | 165329 | 100 | 18.076 | 9146.3 |
| 192 | 2024-02-21 10:11:49 | optometry | 4 | 165329 | 100 | 31.173 | 5303.6 |
| 191 | 2024-02-21 10:11:48 | optometry | 3 | 148641 | 34 | 11.546 | 12873.8 |
| 190 | 2024-02-21 10:11:50 | optometry | 2 | 121436 | 6 | 4.500 | 26985.8 |
| 189 | 2024-02-21 10:05:16 | optometry | 5 | 174418 | 899 | 50.816 | 3432.3 |
| 188 | 2024-02-21 08:43:59 | optometry | 1 | 81242 | 1 | 3.190 | 25467.7 |
| 187 | 2024-02-21 03:57:46 | optometry | 5 | 174418 | 899 | 22.596 | 7719.0 |
| 186 | 2024-02-20 04:49:04 | optometry | 1 | 81242 | 1 | 1.826 | 44491.8 |
| 185 | 2024-01-31 09:39:58 | optometry | 1 | 81242 | 1 | 1.263 | 64324.6 |
| 184 | 2024-01-30 17:25:27 | optometry | 1 | 81242 | 1 | 1.406 | 57782.4 |
| 183 | 2024-01-24 06:33:41 | optometry | 1 | 81242 | 1 | 1.236 | 65729.8 |
| 182 | 2023-12-16 11:37:26 | optometry | 5 | 174418 | 899 | 16.733 | 10423.6 |
| 181 | 2023-12-14 23:31:27 | optometry | 5 | 174418 | 899 | 19.550 | 8921.6 |
| 180 | 2023-12-13 13:55:26 | optometry | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 179 | 2023-12-10 18:20:55 | optometry | 3 | 148641 | 34 | 6.000 | 24773.5 |
| 178 | 2023-12-09 10:30:53 | optometry | 2 | 121436 | 6 | 3.033 | 40038.2 |
| 177 | 2023-11-22 16:33:54 | optometry | 5 | 174418 | 899 | 24.796 | 7034.1 |
| 176 | 2023-11-19 23:36:42 | optometry | 1 | 81242 | 1 | 1.326 | 61268.5 |
| 175 | 2023-10-20 13:51:06 | optometry | 5 | 174418 | 899 | 49.050 | 3555.9 |
| 174 | 2023-10-17 11:14:57 | optometry | 5 | 174418 | 899 | 47.380 | 3681.3 |
| 173 | 2023-10-11 10:33:26 | optometry | 5 | 174418 | 899 | 40.520 | 4304.5 |
| 172 | 2023-10-04 02:04:33 | optometry | 5 | 174418 | 899 | 44.550 | 3915.1 |
| 171 | 2023-09-28 13:18:14 | optometry | 5 | 174418 | 899 | 21.143 | 8249.4 |
| 170 | 2023-09-27 14:50:59 | optometry | 1 | 81242 | 1 | 1.233 | 65889.7 |
| 169 | 2023-09-22 22:53:44 | optometry | 5 | 174418 | 899 | 27.596 | 6320.4 |
| 168 | 2023-09-18 23:01:21 | optometry | 5 | 174418 | 899 | 17.623 | 9897.2 |
| 167 | 2023-09-18 03:04:35 | optometry | 5 | 174418 | 899 | 17.533 | 9948.0 |
| 166 | 2023-09-08 06:56:22 | optometry | 2 | 121436 | 6 | 3.140 | 38673.9 |
| 165 | 2023-09-07 19:33:20 | optometry | 3 | 148641 | 34 | 6.003 | 24761.1 |
| 164 | 2023-09-06 14:46:46 | optometry | 1 | 81242 | 1 | 1.236 | 65729.8 |
| 163 | 2023-06-16 05:07:34 | optometry | 5 | 174418 | 899 | 16.936 | 10298.7 |
| 162 | 2023-06-10 03:07:05 | optometry | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 161 | 2023-05-26 00:13:54 | optometry | 2 | 121436 | 6 | 3.030 | 40077.9 |
| 160 | 2023-05-19 21:55:14 | optometry | 3 | 148641 | 34 | 5.873 | 25309.2 |
| 159 | 2023-03-29 14:28:56 | optometry | 1 | 81242 | 1 | 1.313 | 61875.1 |
| 158 | 2023-03-22 08:17:41 | optometry | 5 | 174418 | 899 | 15.796 | 11041.9 |
| 157 | 2023-03-16 20:32:35 | optometry | 5 | 174418 | 899 | 16.673 | 10461.1 |
| 156 | 2023-03-05 02:02:01 | optometry | 2 | 121436 | 6 | 2.936 | 41361.0 |
| 155 | 2023-02-25 00:59:00 | optometry | 3 | 148641 | 34 | 6.080 | 24447.5 |
| 154 | 2023-01-13 21:47:21 | optometry | 1 | 81242 | 1 | 1.203 | 67532.8 |
| 153 | 2022-12-19 16:33:45 | optometry | 5 | 174418 | 899 | 15.923 | 10953.8 |
| 152 | 2022-12-12 02:29:09 | optometry | 2 | 121436 | 6 | 2.983 | 40709.4 |
| 151 | 2022-12-11 23:44:43 | optometry | 5 | 174418 | 899 | 16.156 | 10795.9 |
| 150 | 2022-12-07 10:39:23 | optometry | 3 | 148641 | 34 | 6.280 | 23668.9 |
| 149 | 2022-11-20 18:49:35 | optometry | 5 | 174418 | 899 | 15.503 | 11250.6 |