History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"informant"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
325 | 2025-05-08 12:55:38 | informant | 1 | 81242 | 2 | 9.750 | 8332.5 |
324 | 2025-05-05 13:53:09 | informant | 1 | 81242 | 2 | 7.563 | 10742.0 |
323 | 2025-04-23 02:44:55 | informant | 1 | 81242 | 2 | 4.890 | 16613.9 |
322 | 2025-04-20 11:21:10 | informant | 1 | 81242 | 2 | 6.313 | 12869.0 |
321 | 2025-04-19 21:24:00 | informant | 1 | 81242 | 2 | 1.780 | 45641.6 |
320 | 2025-04-15 21:20:12 | informant | 1 | 81242 | 2 | 6.233 | 13034.2 |
319 | 2025-04-06 12:39:21 | informant | 1 | 81242 | 2 | 6.920 | 11740.2 |
318 | 2025-03-31 15:55:43 | informant | 4 | 165329 | 202 | 50.580 | 3268.7 |
317 | 2025-03-29 20:48:24 | informant | 4 | 165329 | 202 | 48.200 | 3430.1 |
316 | 2025-03-29 17:05:37 | informant | 4 | 165329 | 202 | 55.736 | 2966.3 |
315 | 2025-03-26 20:20:30 | informant | 4 | 165329 | 202 | 11.783 | 14031.1 |
314 | 2025-03-26 14:39:25 | informant | 1 | 81242 | 2 | 6.783 | 11977.3 |
313 | 2025-03-22 02:23:18 | informant | 2 | 121436 | 5 | 5.190 | 23398.1 |
312 | 2025-03-21 15:01:17 | informant | 1 | 81242 | 2 | 3.160 | 25709.5 |
311 | 2025-03-21 14:33:39 | informant | 2 | 121436 | 5 | 25.893 | 4689.9 |
310 | 2025-03-19 20:17:05 | informant | 3 | 148641 | 34 | 7.750 | 19179.5 |
309 | 2025-03-18 13:28:25 | informant | 3 | 148641 | 34 | 43.533 | 3414.4 |
308 | 2025-03-17 11:11:45 | informant | 3 | 148641 | 34 | 35.253 | 4216.4 |
307 | 2025-03-17 05:40:28 | informant | 1 | 81242 | 2 | 4.513 | 18001.8 |
306 | 2025-03-16 01:37:38 | informant | 3 | 148641 | 34 | 39.343 | 3778.1 |
305 | 2025-03-16 01:37:41 | informant | 3 | 148641 | 34 | 33.580 | 4426.5 |
304 | 2025-03-16 01:37:37 | informant | 2 | 121436 | 5 | 12.843 | 9455.4 |
303 | 2025-03-16 01:36:03 | informant | 1 | 81242 | 2 | 3.423 | 23734.2 |
302 | 2025-02-26 07:34:42 | informant | 3 | 148641 | 34 | 51.816 | 2868.6 |
301 | 2025-02-25 16:42:34 | informant | 1 | 81242 | 2 | 1.296 | 62686.7 |
300 | 2025-02-24 23:44:17 | informant | 1 | 81242 | 2 | 3.970 | 20464.0 |
299 | 2025-02-17 22:05:22 | informant | 1 | 81242 | 2 | 6.516 | 12468.1 |
298 | 2025-02-13 19:36:10 | informant | 3 | 148641 | 34 | 26.940 | 5517.5 |
297 | 2025-02-07 15:31:37 | informant | 3 | 148641 | 34 | 43.050 | 3452.8 |
296 | 2025-02-07 15:31:35 | informant | 3 | 148641 | 34 | 34.000 | 4371.8 |
295 | 2025-02-07 14:50:11 | informant | 1 | 81242 | 2 | 1.580 | 51419.0 |
294 | 2025-02-01 03:28:07 | informant | 3 | 148641 | 34 | 33.436 | 4445.5 |
293 | 2025-01-31 14:57:35 | informant | 3 | 148641 | 34 | 40.110 | 3705.8 |
292 | 2025-01-30 14:16:51 | informant | 3 | 148641 | 34 | 32.673 | 4549.4 |
291 | 2025-01-23 07:15:02 | informant | 2 | 121436 | 5 | 19.763 | 6144.6 |
290 | 2025-01-23 07:14:31 | informant | 1 | 81242 | 2 | 3.453 | 23527.9 |
289 | 2025-01-16 04:57:41 | informant | 1 | 81242 | 2 | 7.500 | 10832.3 |
288 | 2025-01-01 07:31:03 | informant | 1 | 81242 | 2 | 6.643 | 12229.7 |
287 | 2024-12-28 08:34:32 | informant | 1 | 81242 | 2 | 7.393 | 10989.0 |
286 | 2024-12-25 06:51:20 | informant | 3 | 148641 | 34 | 35.546 | 4181.7 |
285 | 2024-12-25 04:45:48 | informant | 3 | 148641 | 34 | 36.143 | 4112.6 |
284 | 2024-12-21 19:51:02 | informant | 3 | 148641 | 34 | 40.376 | 3681.4 |
283 | 2024-12-14 18:40:14 | informant | 4 | 165329 | 202 | 40.283 | 4104.2 |
282 | 2024-12-14 16:47:34 | informant | 1 | 81242 | 2 | 4.126 | 19690.3 |
281 | 2024-12-14 02:42:02 | informant | 4 | 165329 | 202 | 68.486 | 2414.1 |
280 | 2024-12-12 21:38:15 | informant | 3 | 148641 | 34 | 25.533 | 5821.5 |
279 | 2024-12-12 02:08:18 | informant | 3 | 148641 | 34 | 35.240 | 4218.0 |
278 | 2024-11-27 15:36:18 | informant | 1 | 81242 | 2 | 6.033 | 13466.3 |
277 | 2024-11-22 01:24:19 | informant | 1 | 81242 | 2 | 6.736 | 12060.9 |
276 | 2024-11-13 16:51:28 | informant | 1 | 81242 | 2 | 1.203 | 67532.8 |
275 | 2024-10-31 16:36:19 | informant | 1 | 81242 | 2 | 3.250 | 24997.5 |
274 | 2024-10-25 20:53:38 | informant | 3 | 148641 | 34 | 31.656 | 4695.5 |
273 | 2024-10-25 06:32:18 | informant | 3 | 148641 | 34 | 50.236 | 2958.9 |
272 | 2024-10-23 00:52:38 | informant | 2 | 121436 | 5 | 14.423 | 8419.6 |
271 | 2024-10-23 00:52:19 | informant | 1 | 81242 | 2 | 6.156 | 13197.2 |
270 | 2024-10-22 14:43:48 | informant | 4 | 165329 | 202 | 61.660 | 2681.3 |
269 | 2024-10-21 19:33:30 | informant | 3 | 148641 | 34 | 27.203 | 5464.1 |
268 | 2024-10-20 05:30:27 | informant | 3 | 148641 | 34 | 30.970 | 4799.5 |
267 | 2024-10-19 23:24:41 | informant | 3 | 148641 | 34 | 30.210 | 4920.3 |
266 | 2024-10-19 23:24:43 | informant | 2 | 121436 | 5 | 17.410 | 6975.1 |
265 | 2024-10-19 23:23:29 | informant | 1 | 81242 | 2 | 2.766 | 29371.7 |
264 | 2024-10-18 07:04:17 | informant | 4 | 165329 | 202 | 77.750 | 2126.4 |
263 | 2024-10-15 17:51:57 | informant | 2 | 121436 | 5 | 9.190 | 13213.9 |
262 | 2024-10-13 06:44:37 | informant | 4 | 165329 | 202 | 70.956 | 2330.0 |
261 | 2024-10-01 22:45:36 | informant | 4 | 165329 | 202 | 72.726 | 2273.3 |
260 | 2024-09-24 04:39:43 | informant | 4 | 165329 | 202 | 113.663 | 1454.6 |
259 | 2024-09-21 16:09:00 | informant | 4 | 165329 | 202 | 104.863 | 1576.6 |
258 | 2024-09-13 18:03:56 | informant | 1 | 81242 | 2 | 12.920 | 6288.1 |
257 | 2024-09-13 03:31:39 | informant | 4 | 165329 | 202 | 117.376 | 1408.5 |
256 | 2024-09-09 09:21:05 | informant | 1 | 81242 | 2 | 5.860 | 13863.8 |
255 | 2024-09-01 12:48:46 | informant | 1 | 81242 | 2 | 13.346 | 6087.4 |
254 | 2024-08-24 23:45:11 | informant | 4 | 165329 | 202 | 78.626 | 2102.7 |
253 | 2024-08-21 14:31:02 | informant | 4 | 165329 | 202 | 99.366 | 1663.8 |
252 | 2024-08-19 00:39:33 | informant | 4 | 165329 | 202 | 93.676 | 1764.9 |
251 | 2024-08-18 12:53:46 | informant | 4 | 165329 | 202 | 119.253 | 1386.4 |
250 | 2024-08-14 07:34:11 | informant | 1 | 81242 | 2 | 4.653 | 17460.1 |
249 | 2024-08-08 02:52:37 | informant | 4 | 165329 | 202 | 37.580 | 4399.4 |
248 | 2024-08-08 02:52:38 | informant | 2 | 121436 | 5 | 20.720 | 5860.8 |
247 | 2024-08-08 02:51:08 | informant | 1 | 81242 | 2 | 1.466 | 55417.5 |
246 | 2024-08-07 03:36:12 | informant | 3 | 148641 | 34 | 25.986 | 5720.0 |
245 | 2024-08-06 16:29:55 | informant | 1 | 81242 | 2 | 6.906 | 11764.0 |
244 | 2024-08-01 14:34:35 | informant | 3 | 148641 | 34 | 27.176 | 5469.6 |
243 | 2024-07-31 20:47:34 | informant | 3 | 148641 | 34 | 24.843 | 5983.2 |
242 | 2024-07-26 06:19:38 | informant | 1 | 81242 | 2 | 6.203 | 13097.2 |
241 | 2024-07-25 23:49:10 | informant | 3 | 148641 | 34 | 13.316 | 11162.6 |
240 | 2024-07-25 23:49:02 | informant | 2 | 121436 | 5 | 5.986 | 20286.7 |
239 | 2024-07-25 23:45:11 | informant | 1 | 81242 | 2 | 6.890 | 11791.3 |
238 | 2024-07-21 03:13:56 | informant | 4 | 165329 | 202 | 71.350 | 2317.2 |
237 | 2024-07-20 00:38:07 | informant | 4 | 165329 | 202 | 54.693 | 3022.9 |
236 | 2024-07-19 15:33:52 | informant | 4 | 165329 | 202 | 38.130 | 4335.9 |
235 | 2024-07-19 13:43:59 | informant | 4 | 165329 | 202 | 28.623 | 5776.1 |
234 | 2024-07-03 20:32:52 | informant | 1 | 81242 | 2 | 6.123 | 13268.3 |
233 | 2024-07-03 04:13:07 | informant | 4 | 165329 | 202 | 58.550 | 2823.7 |
232 | 2024-06-27 09:48:49 | informant | 4 | 165329 | 202 | 59.720 | 2768.4 |
231 | 2024-06-23 23:44:07 | informant | 4 | 165329 | 202 | 59.723 | 2768.3 |
230 | 2024-06-23 14:52:56 | informant | 3 | 148641 | 34 | 26.550 | 5598.5 |
229 | 2024-06-23 14:53:06 | informant | 2 | 121436 | 5 | 8.656 | 14029.1 |
228 | 2024-06-23 14:47:34 | informant | 1 | 81242 | 2 | 7.313 | 11109.3 |
227 | 2024-06-19 16:21:27 | informant | 1 | 81242 | 2 | 4.830 | 16820.3 |
226 | 2024-06-18 12:05:37 | informant | 4 | 165329 | 202 | 48.080 | 3438.6 |