History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"deejay"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
308 | 2024-04-27 16:08:42 | deejay | 1 | 48755 | 3 | 0.953 | 51159.5 |
307 | 2024-04-26 09:11:44 | deejay | 3 | 112716 | 177 | 6.453 | 17467.2 |
306 | 2024-04-11 01:51:26 | deejay | 3 | 112716 | 177 | 7.673 | 14690.0 |
305 | 2024-04-10 05:53:44 | deejay | 3 | 112716 | 177 | 9.393 | 12000.0 |
304 | 2024-04-10 05:53:45 | deejay | 2 | 82551 | 13 | 3.003 | 27489.5 |
303 | 2024-04-10 05:53:42 | deejay | 1 | 48755 | 3 | 0.966 | 50471.0 |
302 | 2024-04-05 03:56:02 | deejay | 2 | 82551 | 13 | 2.843 | 29036.6 |
301 | 2024-04-01 13:13:27 | deejay | 1 | 48755 | 3 | 0.766 | 63648.8 |
300 | 2024-04-01 13:13:20 | deejay | 2 | 82551 | 13 | 2.560 | 32246.5 |
299 | 2024-03-31 16:20:20 | deejay | 3 | 112716 | 177 | 10.343 | 10897.8 |
298 | 2024-03-31 16:20:04 | deejay | 2 | 82551 | 13 | 7.686 | 10740.4 |
297 | 2024-03-31 01:10:41 | deejay | 2 | 82551 | 13 | 5.703 | 14475.0 |
296 | 2024-03-29 02:58:01 | deejay | 1 | 48755 | 3 | 1.580 | 30857.6 |
295 | 2024-03-11 22:34:50 | deejay | 3 | 112716 | 177 | 13.063 | 8628.6 |
294 | 2024-03-10 22:30:54 | deejay | 3 | 112716 | 177 | 5.750 | 19602.8 |
293 | 2024-03-10 22:30:55 | deejay | 2 | 82551 | 13 | 2.593 | 31836.1 |
292 | 2024-03-10 22:30:48 | deejay | 1 | 48755 | 3 | 0.860 | 56691.9 |
291 | 2024-03-04 02:35:52 | deejay | 1 | 48755 | 3 | 0.873 | 55847.7 |
290 | 2024-03-02 02:10:41 | deejay | 2 | 82551 | 13 | 5.720 | 14432.0 |
289 | 2024-03-02 02:10:38 | deejay | 1 | 48755 | 3 | 0.953 | 51159.5 |
288 | 2024-03-01 12:02:53 | deejay | 2 | 82551 | 13 | 2.640 | 31269.3 |
287 | 2024-03-01 12:02:45 | deejay | 3 | 112716 | 177 | 5.250 | 21469.7 |
286 | 2024-02-29 00:59:34 | deejay | 2 | 82551 | 13 | 2.626 | 31436.0 |
285 | 2024-02-29 00:59:31 | deejay | 3 | 112716 | 177 | 6.110 | 18447.8 |
284 | 2024-02-29 00:59:19 | deejay | 1 | 48755 | 3 | 1.843 | 26454.2 |
283 | 2024-02-28 05:17:19 | deejay | 1 | 48755 | 3 | 3.063 | 15917.4 |
282 | 2024-02-26 03:35:00 | deejay | 1 | 48755 | 3 | 0.936 | 52088.7 |
281 | 2024-02-18 11:13:09 | deejay | 2 | 82551 | 13 | 5.796 | 14242.8 |
280 | 2024-02-18 05:08:09 | deejay | 1 | 48755 | 3 | 1.936 | 25183.4 |
279 | 2024-01-31 08:21:03 | deejay | 2 | 82551 | 13 | 2.360 | 34979.2 |
278 | 2024-01-31 08:20:55 | deejay | 3 | 112716 | 177 | 5.530 | 20382.6 |
277 | 2024-01-30 23:44:48 | deejay | 2 | 82551 | 13 | 2.486 | 33206.4 |
276 | 2024-01-30 23:44:27 | deejay | 3 | 112716 | 177 | 4.686 | 24053.8 |
275 | 2024-01-29 19:08:11 | deejay | 3 | 112716 | 177 | 5.156 | 21861.1 |
274 | 2024-01-29 14:59:57 | deejay | 2 | 82551 | 13 | 2.453 | 33653.1 |
273 | 2024-01-29 14:59:53 | deejay | 3 | 112716 | 177 | 5.656 | 19928.6 |
272 | 2023-12-18 09:04:11 | deejay | 3 | 112716 | 177 | 5.093 | 22131.6 |
271 | 2023-12-07 04:11:58 | deejay | 1 | 48755 | 3 | 0.750 | 65006.7 |
270 | 2023-12-06 00:54:26 | deejay | 2 | 82551 | 13 | 2.343 | 35233.0 |
269 | 2023-11-27 23:03:06 | deejay | 1 | 48755 | 3 | 0.750 | 65006.7 |
268 | 2023-11-26 21:43:55 | deejay | 1 | 48755 | 3 | 0.830 | 58741.0 |
267 | 2023-11-24 21:39:40 | deejay | 1 | 48755 | 3 | 1.000 | 48755.0 |
266 | 2023-11-23 12:54:16 | deejay | 1 | 48755 | 3 | 0.860 | 56691.9 |
265 | 2023-10-24 03:03:45 | deejay | 1 | 48755 | 3 | 0.893 | 54596.9 |
264 | 2023-10-20 16:27:18 | deejay | 1 | 48755 | 3 | 1.000 | 48755.0 |
263 | 2023-10-16 12:08:28 | deejay | 1 | 48755 | 3 | 0.783 | 62266.9 |
262 | 2023-09-24 12:21:39 | deejay | 1 | 48755 | 3 | 0.733 | 66514.3 |
261 | 2023-09-24 10:31:31 | deejay | 3 | 112716 | 177 | 5.233 | 21539.5 |
260 | 2023-09-21 15:13:31 | deejay | 1 | 48755 | 3 | 0.843 | 57835.1 |
259 | 2023-09-18 07:03:03 | deejay | 3 | 112716 | 177 | 4.640 | 24292.2 |
258 | 2023-09-12 20:33:17 | deejay | 1 | 48755 | 3 | 0.736 | 66243.2 |
257 | 2023-09-03 04:50:40 | deejay | 2 | 82551 | 13 | 4.483 | 18414.2 |
256 | 2023-08-01 01:54:28 | deejay | 1 | 48755 | 3 | 0.736 | 66243.2 |
255 | 2023-07-12 20:12:15 | deejay | 1 | 48755 | 3 | 0.813 | 59969.2 |
254 | 2023-06-18 09:24:07 | deejay | 3 | 112716 | 177 | 6.516 | 17298.3 |
253 | 2023-05-28 11:15:36 | deejay | 1 | 48755 | 3 | 0.736 | 66243.2 |
252 | 2023-05-28 07:30:28 | deejay | 1 | 48755 | 3 | 0.830 | 58741.0 |
251 | 2023-05-19 15:29:43 | deejay | 2 | 82551 | 13 | 2.190 | 37694.5 |
250 | 2023-04-16 21:58:13 | deejay | 1 | 48755 | 3 | 0.733 | 66514.3 |
249 | 2023-04-12 15:58:44 | deejay | 1 | 48755 | 3 | 0.733 | 66514.3 |
248 | 2023-03-16 15:35:33 | deejay | 3 | 112716 | 177 | 4.626 | 24365.8 |
247 | 2023-02-25 02:16:00 | deejay | 2 | 82551 | 13 | 2.373 | 34787.6 |
246 | 2023-02-07 09:11:15 | deejay | 1 | 48755 | 3 | 0.796 | 61250.0 |
245 | 2022-12-23 16:24:57 | deejay | 1 | 48755 | 3 | 0.736 | 66243.2 |
244 | 2022-12-18 06:09:30 | deejay | 3 | 112716 | 177 | 5.580 | 20200.0 |
243 | 2022-12-07 12:56:44 | deejay | 2 | 82551 | 13 | 2.080 | 39688.0 |
242 | 2022-12-05 23:13:48 | deejay | 1 | 48755 | 3 | 0.733 | 66514.3 |
241 | 2022-08-16 13:34:20 | deejay | 1 | 48755 | 3 | 0.750 | 65006.7 |
240 | 2022-08-11 08:40:13 | deejay | 3 | 112716 | 177 | 4.546 | 24794.5 |
239 | 2022-08-06 05:59:34 | deejay | 1 | 48755 | 3 | 0.750 | 65006.7 |
238 | 2022-08-03 20:42:54 | deejay | 1 | 48755 | 3 | 0.750 | 65006.7 |
237 | 2022-04-12 11:05:53 | deejay | 1 | 48755 | 3 | 0.953 | 51159.5 |
236 | 2022-04-01 11:05:45 | deejay | 2 | 82551 | 13 | 2.090 | 39498.1 |
235 | 2022-03-29 01:01:01 | deejay | 1 | 48755 | 3 | 0.783 | 62266.9 |
234 | 2022-01-01 18:33:27 | deejay | 1 | 48755 | 3 | 0.936 | 52088.7 |
233 | 2021-12-25 14:17:08 | deejay | 2 | 82551 | 13 | 2.640 | 31269.3 |
232 | 2021-12-24 20:17:21 | deejay | 1 | 48755 | 3 | 0.876 | 55656.4 |
231 | 2021-12-21 15:54:07 | deejay | 1 | 48755 | 3 | 0.873 | 55847.7 |
230 | 2021-11-20 05:52:43 | deejay | 1 | 48755 | 3 | 0.766 | 63648.8 |
229 | 2021-10-29 03:30:52 | deejay | 1 | 48755 | 3 | 0.796 | 61250.0 |
228 | 2021-09-14 11:00:51 | deejay | 1 | 48755 | 3 | 0.733 | 66514.3 |
227 | 2021-09-13 02:44:13 | deejay | 1 | 48755 | 3 | 0.810 | 60191.4 |
226 | 2021-08-26 12:02:23 | deejay | 1 | 48755 | 3 | 0.830 | 58741.0 |
225 | 2021-06-14 07:22:10 | deejay | 1 | 48755 | 3 | 0.843 | 57835.1 |
224 | 2021-05-20 13:16:42 | deejay | 1 | 48755 | 3 | 0.936 | 52088.7 |
223 | 2021-04-20 20:19:19 | deejay | 1 | 48755 | 3 | 0.750 | 65006.7 |
222 | 2021-03-11 11:40:23 | deejay | 1 | 48755 | 3 | 0.733 | 66514.3 |
221 | 2021-02-25 19:16:03 | deejay | 1 | 48755 | 3 | 0.750 | 65006.7 |
220 | 2020-12-08 06:04:03 | deejay | 1 | 48755 | 3 | 1.190 | 40970.6 |
219 | 2020-11-25 07:49:36 | deejay | 1 | 48755 | 3 | 0.826 | 59025.4 |
218 | 2020-10-15 16:55:08 | deejay | 1 | 48755 | 3 | 0.750 | 65006.7 |
217 | 2020-10-15 06:27:13 | deejay | 1 | 48755 | 3 | 0.826 | 59025.4 |
216 | 2020-09-01 19:26:59 | deejay | 1 | 48755 | 3 | 0.750 | 65006.7 |
215 | 2020-08-23 05:02:24 | deejay | 1 | 48755 | 3 | 0.733 | 66514.3 |
214 | 2020-08-20 00:17:39 | deejay | 1 | 48755 | 3 | 0.783 | 62266.9 |
213 | 2020-08-13 02:20:06 | deejay | 1 | 48755 | 3 | 0.906 | 53813.5 |
212 | 2020-07-28 14:46:05 | deejay | 1 | 48755 | 3 | 0.890 | 54780.9 |
211 | 2020-05-12 14:32:27 | deejay | 1 | 48755 | 3 | 0.843 | 57835.1 |
210 | 2020-03-28 10:12:15 | deejay | 1 | 48755 | 3 | 0.876 | 55656.4 |
209 | 2020-03-28 07:22:37 | deejay | 1 | 48755 | 3 | 1.626 | 29984.6 |