History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lothario"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 322 | 2025-11-01 18:08:37 | lothario | 3 | 146162 | 6 | 7.330 | 19940.2 |
| 321 | 2025-10-28 06:39:30 | lothario | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 320 | 2025-10-23 05:56:37 | lothario | 3 | 146162 | 6 | 32.686 | 4471.7 |
| 319 | 2025-10-23 05:56:35 | lothario | 2 | 121059 | 2 | 22.593 | 5358.3 |
| 318 | 2025-10-23 05:56:19 | lothario | 3 | 146162 | 6 | 35.813 | 4081.3 |
| 317 | 2025-10-23 05:56:19 | lothario | 2 | 121059 | 2 | 26.890 | 4502.0 |
| 316 | 2025-10-23 05:55:55 | lothario | 3 | 146162 | 6 | 29.110 | 5021.0 |
| 315 | 2025-10-23 05:55:55 | lothario | 2 | 121059 | 2 | 21.956 | 5513.7 |
| 314 | 2025-10-23 05:55:32 | lothario | 3 | 146162 | 6 | 32.880 | 4445.3 |
| 313 | 2025-10-23 05:55:32 | lothario | 2 | 121059 | 2 | 24.630 | 4915.1 |
| 312 | 2025-10-23 04:12:12 | lothario | 1 | 82945 | 2 | 1.580 | 52496.8 |
| 311 | 2025-09-20 00:23:15 | lothario | 1 | 82945 | 2 | 1.466 | 56579.1 |
| 310 | 2025-09-16 17:49:50 | lothario | 1 | 82945 | 2 | 1.673 | 49578.6 |
| 309 | 2025-09-12 19:34:34 | lothario | 1 | 82945 | 2 | 1.313 | 63172.1 |
| 308 | 2025-07-25 03:02:39 | lothario | 1 | 82945 | 2 | 3.233 | 25655.7 |
| 307 | 2025-07-24 21:57:09 | lothario | 1 | 82945 | 2 | 3.563 | 23279.5 |
| 306 | 2025-07-24 05:15:36 | lothario | 1 | 82945 | 2 | 5.000 | 16589.0 |
| 305 | 2025-06-17 16:57:31 | lothario | 1 | 82945 | 2 | 1.390 | 59672.7 |
| 304 | 2025-05-30 16:57:42 | lothario | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 303 | 2025-05-04 17:47:13 | lothario | 1 | 82945 | 2 | 7.390 | 11224.0 |
| 302 | 2025-04-20 03:18:59 | lothario | 1 | 82945 | 2 | 6.983 | 11878.1 |
| 301 | 2025-04-02 09:56:20 | lothario | 1 | 82945 | 2 | 3.860 | 21488.3 |
| 300 | 2025-03-27 17:55:38 | lothario | 1 | 82945 | 2 | 6.640 | 12491.7 |
| 299 | 2025-02-08 10:32:07 | lothario | 3 | 146162 | 6 | 40.470 | 3611.6 |
| 298 | 2025-02-08 10:32:04 | lothario | 2 | 121059 | 2 | 16.186 | 7479.2 |
| 297 | 2025-02-08 10:20:31 | lothario | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 296 | 2025-02-05 20:58:23 | lothario | 2 | 121059 | 2 | 3.576 | 33853.2 |
| 295 | 2025-02-05 20:58:25 | lothario | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 294 | 2025-02-05 20:58:01 | lothario | 3 | 146162 | 6 | 7.610 | 19206.6 |
| 293 | 2025-02-05 12:10:18 | lothario | 4 | 161609 | 192 | 74.663 | 2164.5 |
| 292 | 2025-02-04 20:17:05 | lothario | 3 | 146162 | 6 | 7.953 | 18378.2 |
| 291 | 2025-02-04 20:16:35 | lothario | 3 | 146162 | 6 | 7.986 | 18302.3 |
| 290 | 2025-02-04 00:03:17 | lothario | 3 | 146162 | 6 | 33.470 | 4367.0 |
| 289 | 2025-02-02 23:38:06 | lothario | 3 | 146162 | 6 | 37.393 | 3908.8 |
| 288 | 2025-02-02 23:38:14 | lothario | 2 | 121059 | 2 | 18.736 | 6461.3 |
| 287 | 2025-02-02 23:37:09 | lothario | 4 | 161609 | 192 | 65.346 | 2473.1 |
| 286 | 2025-02-02 23:37:00 | lothario | 1 | 82945 | 2 | 3.186 | 26034.2 |
| 285 | 2025-01-01 16:20:02 | lothario | 4 | 161609 | 192 | 59.563 | 2713.2 |
| 284 | 2025-01-01 00:18:53 | lothario | 1 | 82945 | 2 | 7.173 | 11563.5 |
| 283 | 2025-01-01 00:15:46 | lothario | 4 | 161609 | 192 | 22.393 | 7216.9 |
| 282 | 2025-01-01 00:15:45 | lothario | 2 | 121059 | 2 | 3.860 | 31362.4 |
| 281 | 2024-12-31 14:41:30 | lothario | 4 | 161609 | 192 | 60.770 | 2659.4 |
| 280 | 2024-12-30 23:02:36 | lothario | 4 | 161609 | 192 | 14.830 | 10897.4 |
| 279 | 2024-12-30 23:02:38 | lothario | 2 | 121059 | 2 | 5.030 | 24067.4 |
| 278 | 2024-12-30 23:02:24 | lothario | 3 | 146162 | 6 | 7.643 | 19123.6 |
| 277 | 2024-12-20 02:18:24 | lothario | 3 | 146162 | 6 | 35.266 | 4144.6 |
| 276 | 2024-12-20 02:18:23 | lothario | 2 | 121059 | 2 | 17.266 | 7011.4 |
| 275 | 2024-12-20 02:18:20 | lothario | 1 | 82945 | 2 | 5.923 | 14003.9 |
| 274 | 2024-12-13 09:47:11 | lothario | 1 | 82945 | 2 | 5.700 | 14551.8 |
| 273 | 2024-12-03 14:43:42 | lothario | 3 | 146162 | 6 | 29.940 | 4881.8 |
| 272 | 2024-11-29 04:19:04 | lothario | 4 | 161609 | 192 | 65.113 | 2482.0 |
| 271 | 2024-11-29 03:35:41 | lothario | 4 | 161609 | 192 | 17.173 | 9410.6 |
| 270 | 2024-11-29 03:35:42 | lothario | 2 | 121059 | 2 | 3.640 | 33258.0 |
| 269 | 2024-11-29 03:35:30 | lothario | 3 | 146162 | 6 | 9.093 | 16074.1 |
| 268 | 2024-11-25 21:21:28 | lothario | 3 | 146162 | 6 | 27.910 | 5236.9 |
| 267 | 2024-11-25 21:21:23 | lothario | 3 | 146162 | 6 | 29.670 | 4926.3 |
| 266 | 2024-11-25 21:21:26 | lothario | 2 | 121059 | 2 | 11.640 | 10400.3 |
| 265 | 2024-11-25 21:21:13 | lothario | 1 | 82945 | 2 | 3.733 | 22219.4 |
| 264 | 2024-11-17 09:03:49 | lothario | 1 | 82945 | 2 | 6.080 | 13642.3 |
| 263 | 2024-11-11 21:16:16 | lothario | 1 | 82945 | 2 | 10.393 | 7980.9 |
| 262 | 2024-10-11 07:06:33 | lothario | 1 | 82945 | 2 | 6.860 | 12091.1 |
| 261 | 2024-10-02 10:06:02 | lothario | 1 | 82945 | 2 | 7.110 | 11666.0 |
| 260 | 2024-09-27 01:26:27 | lothario | 3 | 146162 | 6 | 57.816 | 2528.1 |
| 259 | 2024-09-26 23:07:36 | lothario | 2 | 121059 | 2 | 27.423 | 4414.5 |
| 258 | 2024-09-26 07:52:57 | lothario | 2 | 121059 | 2 | 28.923 | 4185.6 |
| 257 | 2024-09-25 16:07:36 | lothario | 2 | 121059 | 2 | 43.206 | 2801.9 |
| 256 | 2024-09-25 16:07:27 | lothario | 2 | 121059 | 2 | 46.563 | 2599.9 |
| 255 | 2024-09-25 09:01:18 | lothario | 4 | 161609 | 192 | 133.166 | 1213.6 |
| 254 | 2024-09-25 09:01:35 | lothario | 3 | 146162 | 6 | 88.020 | 1660.6 |
| 253 | 2024-09-25 09:01:22 | lothario | 2 | 121059 | 2 | 32.876 | 3682.3 |
| 252 | 2024-09-24 05:47:30 | lothario | 1 | 82945 | 2 | 11.250 | 7372.9 |
| 251 | 2024-09-01 23:12:23 | lothario | 1 | 82945 | 2 | 15.986 | 5188.6 |
| 250 | 2024-08-06 16:23:44 | lothario | 3 | 146162 | 6 | 26.986 | 5416.2 |
| 249 | 2024-08-06 16:23:46 | lothario | 2 | 121059 | 2 | 14.313 | 8458.0 |
| 248 | 2024-08-06 16:23:42 | lothario | 1 | 82945 | 2 | 6.796 | 12205.0 |
| 247 | 2024-07-26 03:46:08 | lothario | 3 | 146162 | 6 | 41.893 | 3488.9 |
| 246 | 2024-07-23 12:10:24 | lothario | 2 | 121059 | 2 | 14.140 | 8561.5 |
| 245 | 2024-07-23 12:10:25 | lothario | 3 | 146162 | 6 | 12.830 | 11392.2 |
| 244 | 2024-07-23 12:09:03 | lothario | 1 | 82945 | 2 | 7.343 | 11295.8 |
| 243 | 2024-07-14 22:49:40 | lothario | 3 | 146162 | 6 | 37.703 | 3876.7 |
| 242 | 2024-07-14 22:49:42 | lothario | 2 | 121059 | 2 | 13.343 | 9072.8 |
| 241 | 2024-07-14 22:48:41 | lothario | 1 | 82945 | 2 | 5.983 | 13863.4 |
| 240 | 2024-07-08 03:53:14 | lothario | 3 | 146162 | 6 | 29.843 | 4897.7 |
| 239 | 2024-07-08 03:53:15 | lothario | 2 | 121059 | 2 | 6.936 | 17453.7 |
| 238 | 2024-06-19 04:03:08 | lothario | 1 | 82945 | 2 | 6.453 | 12853.7 |
| 237 | 2024-06-15 21:16:51 | lothario | 1 | 82945 | 2 | 6.766 | 12259.1 |
| 236 | 2024-06-15 14:55:52 | lothario | 1 | 82945 | 2 | 6.940 | 11951.7 |
| 235 | 2024-06-14 22:46:49 | lothario | 4 | 161609 | 192 | 55.706 | 2901.1 |
| 234 | 2024-06-07 14:22:52 | lothario | 4 | 161609 | 192 | 34.610 | 4669.4 |
| 233 | 2024-06-05 23:33:42 | lothario | 4 | 161609 | 192 | 48.470 | 3334.2 |
| 232 | 2024-06-05 17:06:21 | lothario | 1 | 82945 | 2 | 5.050 | 16424.8 |
| 231 | 2024-06-05 10:54:25 | lothario | 4 | 161609 | 192 | 17.063 | 9471.3 |
| 230 | 2024-06-05 10:54:29 | lothario | 2 | 121059 | 2 | 3.813 | 31749.0 |
| 229 | 2024-06-05 10:54:13 | lothario | 3 | 146162 | 6 | 7.596 | 19242.0 |
| 228 | 2024-06-02 12:35:22 | lothario | 2 | 121059 | 2 | 12.610 | 9600.2 |
| 227 | 2024-06-02 12:35:27 | lothario | 1 | 82945 | 2 | 2.360 | 35146.2 |
| 226 | 2024-06-02 12:34:31 | lothario | 3 | 146162 | 6 | 18.626 | 7847.2 |
| 225 | 2024-06-02 12:34:15 | lothario | 3 | 146162 | 6 | 8.643 | 16911.0 |
| 224 | 2024-05-29 11:25:52 | lothario | 3 | 146162 | 6 | 32.936 | 4437.8 |
| 223 | 2024-05-29 11:25:47 | lothario | 2 | 121059 | 2 | 14.360 | 8430.3 |