History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"johnny"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 267 | 2024-12-21 19:58:12 | johnny | 1 | 48755 | 1 | 4.546 | 10724.8 |
| 266 | 2024-12-21 13:55:45 | johnny | 2 | 82551 | 8 | 10.766 | 7667.8 |
| 265 | 2024-12-19 12:17:44 | johnny | 2 | 82551 | 8 | 12.520 | 6593.5 |
| 264 | 2024-12-15 16:43:34 | johnny | 3 | 112716 | 141 | 5.203 | 21663.7 |
| 263 | 2024-12-15 16:43:33 | johnny | 2 | 82551 | 8 | 2.546 | 32423.8 |
| 262 | 2024-12-15 16:43:31 | johnny | 1 | 48755 | 1 | 0.860 | 56691.9 |
| 261 | 2024-12-11 20:32:20 | johnny | 3 | 112716 | 141 | 23.266 | 4844.7 |
| 260 | 2024-12-11 00:09:48 | johnny | 3 | 112716 | 141 | 36.093 | 3122.9 |
| 259 | 2024-12-10 16:26:57 | johnny | 3 | 112716 | 141 | 16.000 | 7044.8 |
| 258 | 2024-12-10 16:23:24 | johnny | 3 | 112716 | 141 | 5.470 | 20606.2 |
| 257 | 2024-12-10 03:44:15 | johnny | 3 | 112716 | 141 | 4.826 | 23356.0 |
| 256 | 2024-12-03 08:46:13 | johnny | 2 | 82551 | 8 | 8.190 | 10079.5 |
| 255 | 2024-11-28 09:57:49 | johnny | 1 | 48755 | 1 | 1.906 | 25579.7 |
| 254 | 2024-11-10 19:26:23 | johnny | 2 | 82551 | 8 | 12.516 | 6595.6 |
| 253 | 2024-11-10 15:19:42 | johnny | 1 | 48755 | 1 | 0.796 | 61250.0 |
| 252 | 2024-11-09 15:24:34 | johnny | 2 | 82551 | 8 | 17.720 | 4658.6 |
| 251 | 2024-11-09 15:00:45 | johnny | 3 | 112716 | 141 | 32.220 | 3498.3 |
| 250 | 2024-11-09 06:04:08 | johnny | 1 | 48755 | 1 | 0.783 | 62266.9 |
| 249 | 2024-11-01 04:58:52 | johnny | 3 | 112716 | 141 | 27.143 | 4152.7 |
| 248 | 2024-10-31 19:44:14 | johnny | 3 | 112716 | 141 | 27.830 | 4050.2 |
| 247 | 2024-10-30 15:05:26 | johnny | 3 | 112716 | 141 | 27.860 | 4045.8 |
| 246 | 2024-10-29 02:31:00 | johnny | 1 | 48755 | 1 | 4.033 | 12089.0 |
| 245 | 2024-10-18 22:28:16 | johnny | 1 | 48755 | 1 | 5.983 | 8148.9 |
| 244 | 2024-10-11 08:56:47 | johnny | 2 | 82551 | 8 | 11.596 | 7118.9 |
| 243 | 2024-10-10 07:14:59 | johnny | 2 | 82551 | 8 | 11.156 | 7399.7 |
| 242 | 2024-10-10 07:14:56 | johnny | 2 | 82551 | 8 | 12.170 | 6783.2 |
| 241 | 2024-10-10 07:14:49 | johnny | 1 | 48755 | 1 | 3.486 | 13985.9 |
| 240 | 2024-10-08 14:22:32 | johnny | 1 | 48755 | 1 | 3.626 | 13445.9 |
| 239 | 2024-09-23 19:33:01 | johnny | 1 | 48755 | 1 | 5.453 | 8940.9 |
| 238 | 2024-09-21 15:01:15 | johnny | 1 | 48755 | 1 | 3.126 | 15596.6 |
| 237 | 2024-09-03 13:13:22 | johnny | 1 | 48755 | 1 | 3.093 | 15763.0 |
| 236 | 2024-09-01 11:48:44 | johnny | 1 | 48755 | 1 | 3.170 | 15380.1 |
| 235 | 2024-08-23 15:55:38 | johnny | 2 | 82551 | 8 | 30.550 | 2702.2 |
| 234 | 2024-08-16 07:18:28 | johnny | 1 | 48755 | 1 | 3.126 | 15596.6 |
| 233 | 2024-08-12 12:55:04 | johnny | 1 | 48755 | 1 | 2.843 | 17149.1 |
| 232 | 2024-08-08 11:49:53 | johnny | 1 | 48755 | 1 | 1.843 | 26454.2 |
| 231 | 2024-07-30 11:05:10 | johnny | 1 | 48755 | 1 | 4.826 | 10102.6 |
| 230 | 2024-07-30 03:57:57 | johnny | 2 | 82551 | 8 | 4.173 | 19782.2 |
| 229 | 2024-07-30 03:57:49 | johnny | 1 | 48755 | 1 | 1.250 | 39004.0 |
| 228 | 2024-07-30 03:24:16 | johnny | 3 | 112716 | 141 | 24.076 | 4681.7 |
| 227 | 2024-07-29 06:48:55 | johnny | 3 | 112716 | 141 | 19.643 | 5738.2 |
| 226 | 2024-07-29 04:22:21 | johnny | 3 | 112716 | 141 | 14.470 | 7789.6 |
| 225 | 2024-07-29 01:13:03 | johnny | 3 | 112716 | 141 | 22.020 | 5118.8 |
| 224 | 2024-07-28 16:53:10 | johnny | 3 | 112716 | 141 | 18.560 | 6073.1 |
| 223 | 2024-07-28 16:53:08 | johnny | 2 | 82551 | 8 | 6.530 | 12641.8 |
| 222 | 2024-07-28 16:53:01 | johnny | 1 | 48755 | 1 | 3.623 | 13457.1 |
| 221 | 2024-07-21 15:50:47 | johnny | 1 | 48755 | 1 | 1.670 | 29194.6 |
| 220 | 2024-06-29 05:15:58 | johnny | 1 | 48755 | 1 | 1.640 | 29728.7 |
| 219 | 2024-06-28 14:20:02 | johnny | 1 | 48755 | 1 | 2.220 | 21961.7 |
| 218 | 2024-06-28 05:40:43 | johnny | 1 | 48755 | 1 | 7.623 | 6395.8 |
| 217 | 2024-06-24 11:51:04 | johnny | 3 | 112716 | 141 | 29.236 | 3855.4 |
| 216 | 2024-06-16 07:27:06 | johnny | 3 | 112716 | 141 | 21.503 | 5241.9 |
| 215 | 2024-06-07 10:53:38 | johnny | 2 | 82551 | 8 | 5.720 | 14432.0 |
| 214 | 2024-06-07 10:53:14 | johnny | 3 | 112716 | 141 | 5.296 | 21283.2 |
| 213 | 2024-06-04 22:58:24 | johnny | 3 | 112716 | 141 | 17.846 | 6316.0 |
| 212 | 2024-06-04 22:50:06 | johnny | 3 | 112716 | 141 | 17.826 | 6323.1 |
| 211 | 2024-06-04 22:50:02 | johnny | 2 | 82551 | 8 | 10.673 | 7734.6 |
| 210 | 2024-06-04 22:49:59 | johnny | 1 | 48755 | 1 | 3.000 | 16251.7 |
| 209 | 2024-05-29 09:08:51 | johnny | 1 | 48755 | 1 | 1.063 | 45865.5 |
| 208 | 2024-05-12 11:48:50 | johnny | 1 | 48755 | 1 | 2.640 | 18467.8 |
| 207 | 2024-05-07 11:07:44 | johnny | 1 | 48755 | 1 | 1.826 | 26700.4 |
| 206 | 2024-05-04 17:56:04 | johnny | 3 | 112716 | 141 | 6.753 | 16691.2 |
| 205 | 2024-05-03 18:15:56 | johnny | 2 | 82551 | 8 | 2.343 | 35233.0 |
| 204 | 2024-05-03 18:14:20 | johnny | 3 | 112716 | 141 | 5.373 | 20978.2 |
| 203 | 2024-04-30 09:34:53 | johnny | 3 | 112716 | 141 | 5.720 | 19705.6 |
| 202 | 2024-04-30 06:42:00 | johnny | 3 | 112716 | 141 | 7.766 | 14514.0 |
| 201 | 2024-04-27 13:31:59 | johnny | 1 | 48755 | 1 | 2.140 | 22782.7 |
| 200 | 2024-04-16 10:13:06 | johnny | 2 | 82551 | 8 | 2.406 | 34310.5 |
| 199 | 2024-04-16 10:12:31 | johnny | 3 | 112716 | 141 | 5.750 | 19602.8 |
| 198 | 2024-04-11 14:48:52 | johnny | 3 | 112716 | 141 | 5.796 | 19447.2 |
| 197 | 2024-04-11 14:48:40 | johnny | 2 | 82551 | 8 | 2.610 | 31628.7 |
| 196 | 2024-04-09 18:23:36 | johnny | 2 | 82551 | 8 | 2.970 | 27794.9 |
| 195 | 2024-04-09 18:23:34 | johnny | 1 | 48755 | 1 | 0.890 | 54780.9 |
| 194 | 2024-04-01 05:52:55 | johnny | 3 | 112716 | 141 | 11.550 | 9759.0 |
| 193 | 2024-04-01 05:52:18 | johnny | 2 | 82551 | 8 | 7.123 | 11589.4 |
| 192 | 2024-04-01 05:50:44 | johnny | 1 | 48755 | 1 | 1.766 | 27607.6 |
| 191 | 2024-03-31 20:24:56 | johnny | 1 | 48755 | 1 | 2.766 | 17626.5 |
| 190 | 2024-03-29 01:56:14 | johnny | 3 | 112716 | 141 | 7.360 | 15314.7 |
| 189 | 2024-03-29 01:06:54 | johnny | 3 | 112716 | 141 | 11.956 | 9427.6 |
| 188 | 2024-03-29 01:06:52 | johnny | 2 | 82551 | 8 | 8.266 | 9986.8 |
| 187 | 2024-03-29 01:06:38 | johnny | 1 | 48755 | 1 | 2.763 | 17645.7 |
| 186 | 2024-03-07 01:08:14 | johnny | 1 | 48755 | 1 | 0.890 | 54780.9 |
| 185 | 2024-03-06 15:46:33 | johnny | 1 | 48755 | 1 | 1.956 | 24925.9 |
| 184 | 2024-03-06 15:06:30 | johnny | 3 | 112716 | 141 | 5.890 | 19136.8 |
| 183 | 2024-03-06 15:06:32 | johnny | 2 | 82551 | 8 | 2.533 | 32590.2 |
| 182 | 2024-03-06 14:43:37 | johnny | 1 | 48755 | 1 | 0.826 | 59025.4 |
| 181 | 2024-03-06 11:36:39 | johnny | 3 | 112716 | 141 | 15.390 | 7324.0 |
| 180 | 2024-03-02 18:13:57 | johnny | 3 | 112716 | 141 | 18.890 | 5967.0 |
| 179 | 2024-03-02 01:04:24 | johnny | 3 | 112716 | 141 | 5.610 | 20092.0 |
| 178 | 2024-02-27 18:55:37 | johnny | 3 | 112716 | 141 | 4.640 | 24292.2 |
| 177 | 2024-02-27 18:55:36 | johnny | 2 | 82551 | 8 | 2.110 | 39123.7 |
| 176 | 2024-02-27 18:55:33 | johnny | 1 | 48755 | 1 | 0.736 | 66243.2 |
| 175 | 2024-02-04 08:14:39 | johnny | 3 | 112716 | 141 | 6.406 | 17595.4 |
| 174 | 2024-02-04 08:14:43 | johnny | 1 | 48755 | 1 | 0.906 | 53813.5 |
| 173 | 2024-02-04 08:14:35 | johnny | 2 | 82551 | 8 | 8.313 | 9930.4 |
| 172 | 2023-12-23 03:37:38 | johnny | 1 | 48755 | 1 | 0.716 | 68093.6 |
| 171 | 2023-12-16 20:25:06 | johnny | 1 | 48755 | 1 | 0.766 | 63648.8 |
| 170 | 2023-11-19 20:37:45 | johnny | 1 | 48755 | 1 | 0.830 | 58741.0 |
| 169 | 2023-11-06 23:51:08 | johnny | 1 | 48755 | 1 | 0.810 | 60191.4 |
| 168 | 2023-10-27 03:26:15 | johnny | 1 | 48755 | 1 | 0.703 | 69352.8 |