History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"insureds"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
298 | 2024-05-03 10:03:32 | insureds | 2 | 121059 | 17 | 4.516 | 26806.7 |
297 | 2024-05-01 10:00:18 | insureds | 3 | 146162 | 132 | 21.673 | 6744.0 |
296 | 2024-05-01 04:04:49 | insureds | 3 | 146162 | 132 | 8.720 | 16761.7 |
295 | 2024-05-01 04:04:45 | insureds | 2 | 121059 | 17 | 3.890 | 31120.6 |
294 | 2024-04-30 23:02:25 | insureds | 1 | 82945 | 4 | 3.096 | 26791.0 |
293 | 2024-04-28 09:34:58 | insureds | 1 | 82945 | 4 | 4.250 | 19516.5 |
292 | 2024-04-27 05:16:29 | insureds | 3 | 146162 | 132 | 10.563 | 13837.2 |
291 | 2024-04-26 08:49:56 | insureds | 3 | 146162 | 132 | 10.140 | 14414.4 |
290 | 2024-04-25 17:48:14 | insureds | 2 | 121059 | 17 | 4.220 | 28687.0 |
289 | 2024-04-25 17:47:42 | insureds | 3 | 146162 | 132 | 8.673 | 16852.5 |
288 | 2024-04-23 02:12:11 | insureds | 3 | 146162 | 132 | 12.640 | 11563.4 |
287 | 2024-04-21 06:25:12 | insureds | 3 | 146162 | 132 | 6.170 | 23689.1 |
286 | 2024-04-21 04:21:11 | insureds | 2 | 121059 | 17 | 6.846 | 17683.2 |
285 | 2024-04-21 03:54:58 | insureds | 1 | 82945 | 4 | 3.233 | 25655.7 |
284 | 2024-04-21 03:50:42 | insureds | 1 | 82945 | 4 | 2.470 | 33581.0 |
283 | 2024-04-20 22:31:07 | insureds | 1 | 82945 | 4 | 4.266 | 19443.3 |
282 | 2024-04-20 22:30:57 | insureds | 3 | 146162 | 132 | 10.640 | 13737.0 |
281 | 2024-04-20 22:30:56 | insureds | 2 | 121059 | 17 | 4.703 | 25740.8 |
280 | 2024-04-20 22:30:53 | insureds | 1 | 82945 | 4 | 1.906 | 43517.8 |
279 | 2024-04-03 09:19:03 | insureds | 1 | 82945 | 4 | 2.580 | 32149.2 |
278 | 2024-03-31 00:15:13 | insureds | 3 | 146162 | 132 | 20.190 | 7239.3 |
277 | 2024-03-30 07:41:10 | insureds | 1 | 82945 | 4 | 3.216 | 25791.4 |
276 | 2024-03-30 02:57:22 | insureds | 1 | 82945 | 4 | 3.003 | 27620.7 |
275 | 2024-03-29 21:41:31 | insureds | 3 | 146162 | 132 | 14.123 | 10349.2 |
274 | 2024-03-28 06:58:34 | insureds | 2 | 121059 | 17 | 3.656 | 33112.4 |
273 | 2024-03-27 06:07:01 | insureds | 2 | 121059 | 17 | 3.720 | 32542.7 |
272 | 2024-03-26 16:18:13 | insureds | 3 | 146162 | 132 | 8.000 | 18270.3 |
271 | 2024-03-26 03:18:00 | insureds | 3 | 146162 | 132 | 7.670 | 19056.3 |
270 | 2024-03-25 06:23:46 | insureds | 1 | 82945 | 4 | 2.890 | 28700.7 |
269 | 2024-03-23 07:15:32 | insureds | 3 | 146162 | 132 | 6.953 | 21021.4 |
268 | 2024-03-20 18:30:09 | insureds | 3 | 146162 | 132 | 11.376 | 12848.3 |
267 | 2024-03-20 18:30:14 | insureds | 2 | 121059 | 17 | 4.343 | 27874.5 |
266 | 2024-03-20 18:29:50 | insureds | 1 | 82945 | 4 | 1.550 | 53512.9 |
265 | 2024-03-05 11:39:27 | insureds | 2 | 121059 | 17 | 7.843 | 15435.3 |
264 | 2024-03-04 07:01:55 | insureds | 1 | 82945 | 4 | 3.080 | 26930.2 |
263 | 2024-03-04 07:01:20 | insureds | 2 | 121059 | 17 | 7.873 | 15376.5 |
262 | 2024-03-03 15:43:28 | insureds | 2 | 121059 | 17 | 4.296 | 28179.5 |
261 | 2024-02-26 05:14:44 | insureds | 3 | 146162 | 132 | 17.000 | 8597.8 |
260 | 2024-02-22 15:52:17 | insureds | 2 | 121059 | 17 | 8.626 | 14034.2 |
259 | 2024-02-22 06:08:56 | insureds | 3 | 146162 | 132 | 7.610 | 19206.6 |
258 | 2024-02-21 08:51:02 | insureds | 3 | 146162 | 132 | 10.420 | 14027.1 |
257 | 2024-02-21 02:42:26 | insureds | 3 | 146162 | 132 | 16.266 | 8985.7 |
256 | 2024-02-18 09:13:38 | insureds | 3 | 146162 | 132 | 25.970 | 5628.1 |
255 | 2024-02-18 09:13:39 | insureds | 2 | 121059 | 17 | 22.063 | 5487.0 |
254 | 2024-02-18 00:40:31 | insureds | 1 | 82945 | 4 | 1.593 | 52068.4 |
253 | 2024-01-18 04:17:48 | insureds | 1 | 82945 | 4 | 1.343 | 61761.0 |
252 | 2023-12-28 04:50:36 | insureds | 1 | 82945 | 4 | 1.250 | 66356.0 |
251 | 2023-12-19 15:27:42 | insureds | 1 | 82945 | 4 | 1.250 | 66356.0 |
250 | 2023-12-15 12:18:16 | insureds | 3 | 146162 | 132 | 6.423 | 22756.0 |
249 | 2023-12-10 01:14:56 | insureds | 1 | 82945 | 4 | 1.233 | 67270.9 |
248 | 2023-11-03 13:00:21 | insureds | 1 | 82945 | 4 | 1.360 | 60989.0 |
247 | 2023-10-25 13:45:37 | insureds | 1 | 82945 | 4 | 2.280 | 36379.4 |
246 | 2023-10-09 16:12:38 | insureds | 1 | 82945 | 4 | 1.423 | 58288.8 |
245 | 2023-10-06 19:10:03 | insureds | 1 | 82945 | 4 | 3.173 | 26140.9 |
244 | 2023-09-29 09:12:54 | insureds | 1 | 82945 | 4 | 1.453 | 57085.3 |
243 | 2023-09-17 06:06:39 | insureds | 3 | 146162 | 132 | 6.860 | 21306.4 |
242 | 2023-09-14 07:51:25 | insureds | 1 | 82945 | 4 | 1.356 | 61168.9 |
241 | 2023-08-02 10:03:38 | insureds | 1 | 82945 | 4 | 1.296 | 64000.8 |
240 | 2023-07-11 12:32:24 | insureds | 1 | 82945 | 4 | 1.250 | 66356.0 |
239 | 2023-06-14 04:55:04 | insureds | 3 | 146162 | 132 | 6.513 | 22441.6 |
238 | 2023-05-27 20:23:04 | insureds | 3 | 146162 | 132 | 5.986 | 24417.3 |
237 | 2023-05-01 08:38:16 | insureds | 1 | 82945 | 4 | 1.250 | 66356.0 |
236 | 2023-04-23 22:15:02 | insureds | 3 | 146162 | 132 | 6.873 | 21266.1 |
235 | 2023-04-08 00:23:09 | insureds | 3 | 146162 | 132 | 6.470 | 22590.7 |
234 | 2023-03-17 09:53:24 | insureds | 1 | 82945 | 4 | 1.343 | 61761.0 |
233 | 2023-03-14 19:55:37 | insureds | 3 | 146162 | 132 | 6.080 | 24039.8 |
232 | 2023-02-22 00:44:33 | insureds | 1 | 82945 | 4 | 1.233 | 67270.9 |
231 | 2023-01-26 15:33:10 | insureds | 3 | 146162 | 132 | 6.953 | 21021.4 |
230 | 2023-01-24 18:16:19 | insureds | 1 | 82945 | 4 | 1.220 | 67987.7 |
229 | 2022-12-21 03:04:41 | insureds | 1 | 82945 | 4 | 1.216 | 68211.3 |
228 | 2022-12-17 03:05:33 | insureds | 3 | 146162 | 132 | 6.046 | 24175.0 |
227 | 2022-12-10 13:35:01 | insureds | 1 | 82945 | 4 | 1.373 | 60411.5 |
226 | 2022-12-09 03:25:31 | insureds | 1 | 82945 | 4 | 1.453 | 57085.3 |
225 | 2022-11-22 13:44:16 | insureds | 1 | 82945 | 4 | 1.326 | 62552.8 |
224 | 2022-11-20 00:50:53 | insureds | 1 | 82945 | 4 | 1.233 | 67270.9 |
223 | 2022-11-15 03:31:27 | insureds | 1 | 82945 | 4 | 1.373 | 60411.5 |
222 | 2022-11-11 00:24:41 | insureds | 1 | 82945 | 4 | 1.483 | 55930.5 |
221 | 2022-09-05 02:56:07 | insureds | 1 | 82945 | 4 | 1.563 | 53067.8 |
220 | 2022-08-07 21:29:29 | insureds | 3 | 146162 | 132 | 6.063 | 24107.2 |
219 | 2022-07-29 18:26:30 | insureds | 1 | 82945 | 4 | 1.280 | 64800.8 |
218 | 2022-06-30 23:55:18 | insureds | 1 | 82945 | 4 | 1.250 | 66356.0 |
217 | 2022-06-18 08:50:52 | insureds | 1 | 82945 | 4 | 1.330 | 62364.7 |
216 | 2022-04-16 05:22:59 | insureds | 1 | 82945 | 4 | 1.280 | 64800.8 |
215 | 2022-03-31 20:26:34 | insureds | 1 | 82945 | 4 | 1.656 | 50087.6 |
214 | 2022-01-14 01:49:45 | insureds | 1 | 82945 | 4 | 1.266 | 65517.4 |
213 | 2021-12-20 12:49:12 | insureds | 1 | 82945 | 4 | 1.546 | 53651.4 |
212 | 2021-11-10 16:36:49 | insureds | 1 | 82945 | 4 | 1.233 | 67270.9 |
211 | 2021-11-10 00:11:06 | insureds | 1 | 82945 | 4 | 1.563 | 53067.8 |
210 | 2021-11-08 23:31:30 | insureds | 1 | 82945 | 4 | 1.296 | 64000.8 |
209 | 2021-10-12 06:45:37 | insureds | 1 | 82945 | 4 | 1.330 | 62364.7 |
208 | 2021-09-22 12:49:19 | insureds | 1 | 82945 | 4 | 1.250 | 66356.0 |
207 | 2021-09-21 08:38:23 | insureds | 1 | 82945 | 4 | 1.266 | 65517.4 |
206 | 2021-09-15 06:29:18 | insureds | 1 | 82945 | 4 | 1.233 | 67270.9 |
205 | 2021-09-10 01:46:09 | insureds | 1 | 82945 | 4 | 1.233 | 67270.9 |
204 | 2021-06-09 04:05:16 | insureds | 1 | 82945 | 4 | 1.470 | 56425.2 |
203 | 2021-05-19 22:53:39 | insureds | 1 | 82945 | 4 | 1.250 | 66356.0 |
202 | 2021-04-20 00:29:12 | insureds | 1 | 82945 | 4 | 1.483 | 55930.5 |
201 | 2021-04-09 03:13:45 | insureds | 3 | 146162 | 132 | 6.453 | 22650.2 |
200 | 2021-03-22 19:16:48 | insureds | 1 | 82945 | 4 | 1.420 | 58412.0 |
199 | 2021-03-10 04:43:09 | insureds | 1 | 82945 | 4 | 2.110 | 39310.4 |