History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"licensee"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
315 | 2024-04-22 17:47:41 | licensee | 1 | 82945 | 7 | 4.716 | 17588.0 |
314 | 2024-04-20 22:51:54 | licensee | 4 | 161609 | 535 | 38.736 | 4172.1 |
313 | 2024-04-20 22:42:09 | licensee | 4 | 161609 | 535 | 31.393 | 5147.9 |
312 | 2024-04-20 07:48:32 | licensee | 4 | 161609 | 535 | 24.643 | 6558.0 |
311 | 2024-04-20 01:49:50 | licensee | 4 | 161609 | 535 | 27.580 | 5859.6 |
310 | 2024-04-19 16:09:52 | licensee | 4 | 161609 | 535 | 38.673 | 4178.9 |
309 | 2024-04-19 16:09:54 | licensee | 3 | 146162 | 63 | 9.466 | 15440.7 |
308 | 2024-04-19 16:09:53 | licensee | 2 | 121059 | 16 | 4.360 | 27765.8 |
307 | 2024-04-19 14:54:21 | licensee | 1 | 82945 | 7 | 1.563 | 53067.8 |
306 | 2024-04-17 07:37:23 | licensee | 1 | 82945 | 7 | 1.296 | 64000.8 |
305 | 2024-04-12 08:56:37 | licensee | 1 | 82945 | 7 | 1.233 | 67270.9 |
304 | 2024-04-08 14:09:54 | licensee | 3 | 146162 | 63 | 16.640 | 8783.8 |
303 | 2024-04-06 13:25:54 | licensee | 1 | 82945 | 7 | 4.000 | 20736.3 |
302 | 2024-04-05 17:35:10 | licensee | 1 | 82945 | 7 | 3.296 | 25165.4 |
301 | 2024-04-04 03:57:29 | licensee | 3 | 146162 | 63 | 11.956 | 12225.0 |
300 | 2024-04-02 22:02:56 | licensee | 3 | 146162 | 63 | 18.050 | 8097.6 |
299 | 2024-04-01 21:01:56 | licensee | 3 | 146162 | 63 | 6.140 | 23804.9 |
298 | 2024-04-01 15:03:55 | licensee | 2 | 121059 | 16 | 7.500 | 16141.2 |
297 | 2024-04-01 15:03:45 | licensee | 3 | 146162 | 63 | 10.406 | 14045.9 |
296 | 2024-04-01 15:03:25 | licensee | 1 | 82945 | 7 | 3.110 | 26670.4 |
295 | 2024-03-25 15:07:17 | licensee | 4 | 161609 | 535 | 12.000 | 13467.4 |
294 | 2024-03-23 07:13:53 | licensee | 1 | 82945 | 7 | 3.013 | 27529.0 |
293 | 2024-03-23 07:13:40 | licensee | 3 | 146162 | 63 | 13.686 | 10679.7 |
292 | 2024-03-23 07:13:51 | licensee | 1 | 82945 | 7 | 1.560 | 53169.9 |
291 | 2024-03-23 07:13:39 | licensee | 2 | 121059 | 16 | 7.873 | 15376.5 |
290 | 2024-03-18 22:01:55 | licensee | 4 | 161609 | 535 | 27.096 | 5964.3 |
289 | 2024-03-18 13:35:52 | licensee | 4 | 161609 | 535 | 21.376 | 7560.3 |
288 | 2024-03-18 04:24:10 | licensee | 4 | 161609 | 535 | 14.393 | 11228.3 |
287 | 2024-03-16 23:09:11 | licensee | 4 | 161609 | 535 | 14.656 | 11026.8 |
286 | 2024-03-16 19:00:33 | licensee | 3 | 146162 | 63 | 20.363 | 7177.8 |
285 | 2024-03-16 19:00:35 | licensee | 2 | 121059 | 16 | 10.503 | 11526.1 |
284 | 2024-03-16 18:59:37 | licensee | 4 | 161609 | 535 | 39.330 | 4109.1 |
283 | 2024-03-16 18:57:17 | licensee | 1 | 82945 | 7 | 2.046 | 40540.1 |
282 | 2024-03-07 10:54:35 | licensee | 1 | 82945 | 7 | 3.140 | 26415.6 |
281 | 2024-03-06 14:21:24 | licensee | 1 | 82945 | 7 | 3.013 | 27529.0 |
280 | 2024-03-02 05:58:44 | licensee | 1 | 82945 | 7 | 4.780 | 17352.5 |
279 | 2024-02-21 22:23:05 | licensee | 1 | 82945 | 7 | 1.330 | 62364.7 |
278 | 2024-02-21 05:43:13 | licensee | 1 | 82945 | 7 | 3.796 | 21850.6 |
277 | 2024-02-06 11:26:26 | licensee | 2 | 121059 | 16 | 3.406 | 35542.9 |
276 | 2024-02-06 11:26:14 | licensee | 3 | 146162 | 63 | 7.483 | 19532.5 |
275 | 2024-02-04 14:08:32 | licensee | 1 | 82945 | 7 | 3.123 | 26559.4 |
274 | 2024-01-30 06:47:02 | licensee | 1 | 82945 | 7 | 1.530 | 54212.4 |
273 | 2024-01-29 13:09:31 | licensee | 4 | 161609 | 535 | 14.190 | 11388.9 |
272 | 2024-01-29 13:09:36 | licensee | 2 | 121059 | 16 | 6.656 | 18188.0 |
271 | 2024-01-29 13:09:03 | licensee | 3 | 146162 | 63 | 7.796 | 18748.3 |
270 | 2024-01-29 13:07:31 | licensee | 1 | 82945 | 7 | 2.970 | 27927.6 |
269 | 2024-01-29 13:07:17 | licensee | 2 | 121059 | 16 | 3.796 | 31891.2 |
268 | 2024-01-29 13:07:13 | licensee | 3 | 146162 | 63 | 7.596 | 19242.0 |
267 | 2024-01-29 11:46:55 | licensee | 2 | 121059 | 16 | 3.453 | 35059.1 |
266 | 2024-01-29 11:46:51 | licensee | 1 | 82945 | 7 | 2.500 | 33178.0 |
265 | 2024-01-12 21:50:42 | licensee | 1 | 82945 | 7 | 1.470 | 56425.2 |
264 | 2023-12-29 09:43:42 | licensee | 1 | 82945 | 7 | 1.250 | 66356.0 |
263 | 2023-12-08 09:43:23 | licensee | 1 | 82945 | 7 | 3.126 | 26533.9 |
262 | 2023-12-05 03:44:48 | licensee | 3 | 146162 | 63 | 6.876 | 21256.8 |
261 | 2023-12-04 08:23:23 | licensee | 1 | 82945 | 7 | 1.233 | 67270.9 |
260 | 2023-11-06 18:31:54 | licensee | 1 | 82945 | 7 | 1.280 | 64800.8 |
259 | 2023-10-23 00:15:45 | licensee | 1 | 82945 | 7 | 1.343 | 61761.0 |
258 | 2023-10-19 17:22:54 | licensee | 1 | 82945 | 7 | 1.563 | 53067.8 |
257 | 2023-10-19 02:08:57 | licensee | 1 | 82945 | 7 | 1.483 | 55930.5 |
256 | 2023-09-16 09:04:39 | licensee | 1 | 82945 | 7 | 1.406 | 58993.6 |
255 | 2023-09-02 11:15:03 | licensee | 3 | 146162 | 63 | 6.313 | 23152.5 |
254 | 2023-08-14 03:35:48 | licensee | 1 | 82945 | 7 | 1.250 | 66356.0 |
253 | 2023-08-09 21:31:14 | licensee | 1 | 82945 | 7 | 1.250 | 66356.0 |
252 | 2023-07-17 02:34:00 | licensee | 1 | 82945 | 7 | 1.360 | 60989.0 |
251 | 2023-06-02 06:22:36 | licensee | 1 | 82945 | 7 | 1.110 | 74725.2 |
250 | 2023-05-20 15:35:30 | licensee | 3 | 146162 | 63 | 6.063 | 24107.2 |
249 | 2023-05-13 13:44:31 | licensee | 1 | 82945 | 7 | 1.376 | 60279.8 |
248 | 2023-05-08 02:19:17 | licensee | 1 | 82945 | 7 | 1.406 | 58993.6 |
247 | 2023-03-31 00:21:47 | licensee | 1 | 82945 | 7 | 1.203 | 68948.5 |
246 | 2023-03-09 13:58:36 | licensee | 1 | 82945 | 7 | 1.233 | 67270.9 |
245 | 2023-03-05 17:04:11 | licensee | 1 | 82945 | 7 | 1.216 | 68211.3 |
244 | 2023-02-27 14:59:47 | licensee | 3 | 146162 | 63 | 6.923 | 21112.5 |
243 | 2023-01-31 22:31:09 | licensee | 1 | 82945 | 7 | 1.236 | 67107.6 |
242 | 2022-12-30 22:20:53 | licensee | 1 | 82945 | 7 | 1.233 | 67270.9 |
241 | 2022-12-06 21:11:06 | licensee | 3 | 146162 | 63 | 7.063 | 20694.0 |
240 | 2022-10-23 04:38:02 | licensee | 1 | 82945 | 7 | 1.330 | 62364.7 |
239 | 2022-09-18 09:09:44 | licensee | 1 | 82945 | 7 | 1.250 | 66356.0 |
238 | 2022-06-29 04:44:13 | licensee | 1 | 82945 | 7 | 1.266 | 65517.4 |
237 | 2022-06-07 03:35:45 | licensee | 1 | 82945 | 7 | 1.313 | 63172.1 |
236 | 2022-05-17 01:12:21 | licensee | 1 | 82945 | 7 | 1.626 | 51011.7 |
235 | 2022-04-03 22:59:12 | licensee | 3 | 146162 | 63 | 6.296 | 23215.1 |
234 | 2022-03-04 03:35:31 | licensee | 1 | 82945 | 7 | 1.470 | 56425.2 |
233 | 2022-01-19 23:19:39 | licensee | 1 | 82945 | 7 | 1.296 | 64000.8 |
232 | 2022-01-16 16:46:20 | licensee | 1 | 82945 | 7 | 1.390 | 59672.7 |
231 | 2022-01-13 10:02:47 | licensee | 1 | 82945 | 7 | 2.736 | 30316.2 |
230 | 2021-12-20 22:55:32 | licensee | 1 | 82945 | 7 | 1.250 | 66356.0 |
229 | 2021-10-27 23:59:54 | licensee | 1 | 82945 | 7 | 1.233 | 67270.9 |
228 | 2021-09-21 04:50:07 | licensee | 1 | 82945 | 7 | 1.233 | 67270.9 |
227 | 2021-09-18 07:57:04 | licensee | 1 | 82945 | 7 | 1.470 | 56425.2 |
226 | 2021-09-16 04:50:58 | licensee | 1 | 82945 | 7 | 1.390 | 59672.7 |
225 | 2021-08-29 15:36:30 | licensee | 1 | 82945 | 7 | 1.283 | 64649.3 |
224 | 2021-08-27 10:46:58 | licensee | 1 | 82945 | 7 | 1.360 | 60989.0 |
223 | 2021-06-18 03:29:32 | licensee | 1 | 82945 | 7 | 1.376 | 60279.8 |
222 | 2021-06-11 16:57:42 | licensee | 1 | 82945 | 7 | 1.393 | 59544.1 |
221 | 2021-05-04 21:18:56 | licensee | 1 | 82945 | 7 | 1.450 | 57203.4 |
220 | 2021-04-09 15:19:47 | licensee | 1 | 82945 | 7 | 1.346 | 61623.3 |
219 | 2021-03-21 02:46:00 | licensee | 1 | 82945 | 7 | 1.266 | 65517.4 |
218 | 2021-03-18 21:38:35 | licensee | 1 | 82945 | 7 | 1.263 | 65673.0 |
217 | 2021-02-23 18:04:27 | licensee | 1 | 82945 | 7 | 3.783 | 21925.7 |
216 | 2020-12-16 00:01:18 | licensee | 1 | 82945 | 7 | 1.263 | 65673.0 |