History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pigsney"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
241 | 2024-04-28 03:09:00 | pigsney | 1 | 69583 | 2 | 1.326 | 52475.9 |
240 | 2024-04-11 02:18:53 | pigsney | 1 | 69583 | 2 | 1.236 | 56296.9 |
239 | 2024-04-05 23:02:30 | pigsney | 2 | 107671 | 5 | 9.220 | 11678.0 |
238 | 2024-04-05 23:02:05 | pigsney | 3 | 134027 | 73 | 9.173 | 14611.0 |
237 | 2024-04-04 20:58:55 | pigsney | 3 | 134027 | 73 | 5.966 | 22465.1 |
236 | 2024-03-30 14:52:56 | pigsney | 1 | 69583 | 2 | 2.156 | 32274.1 |
235 | 2024-03-28 21:12:52 | pigsney | 1 | 69583 | 2 | 2.640 | 26357.2 |
234 | 2024-03-09 00:07:43 | pigsney | 4 | 151207 | 1302 | 25.280 | 5981.3 |
233 | 2024-03-08 00:31:28 | pigsney | 4 | 151207 | 1302 | 11.486 | 13164.5 |
232 | 2024-03-08 00:06:57 | pigsney | 4 | 151207 | 1302 | 19.970 | 7571.7 |
231 | 2024-03-07 14:30:05 | pigsney | 4 | 151207 | 1302 | 17.533 | 8624.1 |
230 | 2024-03-07 12:32:13 | pigsney | 1 | 69583 | 2 | 1.076 | 64668.2 |
229 | 2024-02-27 18:22:28 | pigsney | 1 | 69583 | 2 | 1.283 | 54234.6 |
228 | 2024-02-20 04:56:27 | pigsney | 3 | 134027 | 73 | 14.376 | 9323.0 |
227 | 2024-02-20 04:56:28 | pigsney | 2 | 107671 | 5 | 3.550 | 30329.9 |
226 | 2024-02-19 00:12:42 | pigsney | 3 | 134027 | 73 | 22.360 | 5994.1 |
225 | 2024-02-18 00:05:47 | pigsney | 2 | 107671 | 5 | 4.046 | 26611.7 |
224 | 2024-02-17 22:50:31 | pigsney | 3 | 134027 | 73 | 13.703 | 9780.9 |
223 | 2024-02-17 19:26:28 | pigsney | 1 | 69583 | 2 | 1.390 | 50059.7 |
222 | 2024-02-06 04:18:26 | pigsney | 4 | 151207 | 1302 | 11.533 | 13110.8 |
221 | 2024-01-30 11:11:15 | pigsney | 4 | 151207 | 1302 | 22.393 | 6752.4 |
220 | 2024-01-30 08:26:37 | pigsney | 4 | 151207 | 1302 | 17.763 | 8512.5 |
219 | 2024-01-17 11:38:43 | pigsney | 1 | 69583 | 2 | 2.186 | 31831.2 |
218 | 2024-01-08 22:09:17 | pigsney | 1 | 69583 | 2 | 2.140 | 32515.4 |
217 | 2023-12-30 04:34:41 | pigsney | 4 | 151207 | 1302 | 9.703 | 15583.5 |
216 | 2023-12-28 09:36:47 | pigsney | 1 | 69583 | 2 | 1.080 | 64428.7 |
215 | 2023-12-08 14:11:36 | pigsney | 3 | 134027 | 73 | 6.046 | 22167.9 |
214 | 2023-11-18 17:46:56 | pigsney | 1 | 69583 | 2 | 1.110 | 62687.4 |
213 | 2023-11-11 14:56:49 | pigsney | 1 | 69583 | 2 | 1.236 | 56296.9 |
212 | 2023-11-06 08:13:07 | pigsney | 1 | 69583 | 2 | 1.203 | 57841.2 |
211 | 2023-10-17 21:50:22 | pigsney | 1 | 69583 | 2 | 1.203 | 57841.2 |
210 | 2023-10-11 02:14:58 | pigsney | 4 | 151207 | 1302 | 9.890 | 15288.9 |
209 | 2023-10-03 20:05:02 | pigsney | 4 | 151207 | 1302 | 13.080 | 11560.2 |
208 | 2023-10-03 04:25:51 | pigsney | 4 | 151207 | 1302 | 11.126 | 13590.4 |
207 | 2023-09-05 00:34:14 | pigsney | 3 | 134027 | 73 | 5.733 | 23378.2 |
206 | 2023-08-13 12:40:33 | pigsney | 1 | 69583 | 2 | 1.156 | 60192.9 |
205 | 2023-08-06 07:36:42 | pigsney | 1 | 69583 | 2 | 1.170 | 59472.6 |
204 | 2023-07-15 01:15:59 | pigsney | 4 | 151207 | 1302 | 9.690 | 15604.4 |
203 | 2023-05-20 22:32:50 | pigsney | 3 | 134027 | 73 | 5.610 | 23890.7 |
202 | 2023-05-16 05:15:05 | pigsney | 1 | 69583 | 2 | 1.080 | 64428.7 |
201 | 2023-05-12 01:31:00 | pigsney | 3 | 134027 | 73 | 6.046 | 22167.9 |
200 | 2023-04-08 20:14:36 | pigsney | 4 | 151207 | 1302 | 9.500 | 15916.5 |
199 | 2023-04-02 03:55:54 | pigsney | 4 | 151207 | 1302 | 9.516 | 15889.8 |
198 | 2023-03-26 05:31:58 | pigsney | 3 | 134027 | 73 | 6.376 | 21020.5 |
197 | 2023-03-16 12:43:11 | pigsney | 1 | 69583 | 2 | 1.173 | 59320.5 |
196 | 2023-03-09 16:13:48 | pigsney | 1 | 69583 | 2 | 1.046 | 66522.9 |
195 | 2023-02-27 08:45:52 | pigsney | 3 | 134027 | 73 | 6.203 | 21606.8 |
194 | 2022-12-30 22:26:48 | pigsney | 1 | 69583 | 2 | 1.190 | 58473.1 |
193 | 2022-12-29 04:52:57 | pigsney | 4 | 151207 | 1302 | 10.033 | 15071.0 |
192 | 2022-12-09 02:19:26 | pigsney | 3 | 134027 | 73 | 7.373 | 18178.1 |
191 | 2022-10-17 01:12:25 | pigsney | 1 | 69583 | 2 | 1.046 | 66522.9 |
190 | 2022-09-19 04:12:43 | pigsney | 1 | 69583 | 2 | 1.623 | 42873.1 |
189 | 2022-09-07 08:16:57 | pigsney | 3 | 134027 | 73 | 5.673 | 23625.4 |
188 | 2022-09-05 16:08:52 | pigsney | 4 | 151207 | 1302 | 11.203 | 13497.0 |
187 | 2022-08-28 11:21:25 | pigsney | 4 | 151207 | 1302 | 9.546 | 15839.8 |
186 | 2022-07-23 01:10:58 | pigsney | 3 | 134027 | 73 | 5.563 | 24092.6 |
185 | 2022-07-17 11:26:55 | pigsney | 1 | 69583 | 2 | 1.060 | 65644.3 |
184 | 2022-01-11 01:50:18 | pigsney | 1 | 69583 | 2 | 1.140 | 61037.7 |
183 | 2021-09-09 06:02:12 | pigsney | 1 | 69583 | 2 | 1.156 | 60192.9 |
182 | 2021-07-27 10:01:26 | pigsney | 4 | 151207 | 1302 | 11.533 | 13110.8 |
181 | 2021-07-05 00:37:31 | pigsney | 1 | 69583 | 2 | 1.093 | 63662.4 |
180 | 2021-06-19 06:40:25 | pigsney | 4 | 151207 | 1302 | 10.626 | 14229.9 |
179 | 2021-05-31 15:27:32 | pigsney | 1 | 69583 | 2 | 1.220 | 57035.2 |
178 | 2021-05-29 17:13:16 | pigsney | 1 | 69583 | 2 | 1.326 | 52475.9 |
177 | 2021-05-24 06:32:59 | pigsney | 4 | 151207 | 1302 | 9.656 | 15659.4 |
176 | 2021-05-22 04:55:11 | pigsney | 4 | 151207 | 1302 | 15.096 | 10016.4 |
175 | 2021-05-19 00:54:04 | pigsney | 1 | 69583 | 2 | 1.076 | 64668.2 |
174 | 2021-04-20 04:21:05 | pigsney | 4 | 151207 | 1302 | 12.313 | 12280.3 |
173 | 2021-03-21 20:12:06 | pigsney | 1 | 69583 | 2 | 1.250 | 55666.4 |
172 | 2021-03-21 00:26:13 | pigsney | 4 | 151207 | 1302 | 10.983 | 13767.4 |
171 | 2021-03-11 11:18:17 | pigsney | 1 | 69583 | 2 | 1.266 | 54962.9 |
170 | 2021-02-20 23:24:46 | pigsney | 1 | 69583 | 2 | 1.170 | 59472.6 |
169 | 2021-02-15 19:22:58 | pigsney | 4 | 151207 | 1302 | 9.970 | 15166.2 |
168 | 2021-01-31 10:03:46 | pigsney | 1 | 69583 | 2 | 1.076 | 64668.2 |
167 | 2021-01-30 16:19:34 | pigsney | 4 | 151207 | 1302 | 10.110 | 14956.2 |
166 | 2021-01-22 08:22:27 | pigsney | 1 | 69583 | 2 | 1.140 | 61037.7 |
165 | 2021-01-15 11:05:27 | pigsney | 4 | 151207 | 1302 | 11.346 | 13326.9 |
164 | 2020-12-23 10:35:29 | pigsney | 1 | 69583 | 2 | 1.313 | 52995.4 |
163 | 2020-11-20 09:35:50 | pigsney | 1 | 69583 | 2 | 1.063 | 65459.1 |
162 | 2020-11-17 14:04:28 | pigsney | 1 | 69583 | 2 | 1.200 | 57985.8 |
161 | 2020-11-12 16:26:13 | pigsney | 1 | 69583 | 2 | 1.110 | 62687.4 |
160 | 2020-10-15 15:58:44 | pigsney | 4 | 151207 | 1302 | 9.920 | 15242.6 |
159 | 2020-08-21 05:16:05 | pigsney | 1 | 69583 | 2 | 1.076 | 64668.2 |
158 | 2020-07-31 06:55:10 | pigsney | 1 | 69583 | 2 | 1.266 | 54962.9 |
157 | 2020-07-20 16:08:48 | pigsney | 1 | 69583 | 2 | 1.156 | 60192.9 |
156 | 2020-04-14 07:52:09 | pigsney | 4 | 151207 | 1302 | 10.466 | 14447.4 |
155 | 2020-04-06 04:28:47 | pigsney | 1 | 69583 | 2 | 1.313 | 52995.4 |
154 | 2020-03-28 23:06:27 | pigsney | 1 | 69583 | 2 | 1.233 | 56433.9 |
153 | 2020-03-28 15:36:48 | pigsney | 1 | 69583 | 2 | 2.670 | 26061.0 |
152 | 2020-03-22 07:31:14 | pigsney | 1 | 69583 | 2 | 1.080 | 64428.7 |
151 | 2020-03-02 11:25:57 | pigsney | 4 | 151207 | 1302 | 11.703 | 12920.4 |
150 | 2020-03-01 08:05:31 | pigsney | 1 | 69583 | 2 | 1.280 | 54361.7 |
149 | 2020-03-01 05:45:18 | pigsney | 4 | 151207 | 1302 | 14.143 | 10691.3 |
148 | 2020-03-01 04:54:42 | pigsney | 1 | 69583 | 2 | 1.343 | 51811.6 |
147 | 2020-02-28 21:08:19 | pigsney | 1 | 69583 | 2 | 1.453 | 47889.2 |
146 | 2020-02-25 05:34:55 | pigsney | 1 | 69583 | 2 | 1.420 | 49002.1 |
145 | 2020-02-24 19:58:20 | pigsney | 4 | 151207 | 1302 | 19.796 | 7638.3 |
144 | 2020-02-19 04:04:39 | pigsney | 4 | 151207 | 1302 | 11.173 | 13533.2 |
143 | 2020-02-11 03:21:15 | pigsney | 4 | 151207 | 1302 | 11.766 | 12851.2 |
142 | 2020-02-10 16:10:06 | pigsney | 4 | 151207 | 1302 | 22.173 | 6819.4 |