History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pasticci"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
225 | 2024-05-29 15:19:02 | pasticci | 1 | 82945 | 2 | 7.000 | 11849.3 |
224 | 2024-05-26 07:21:55 | pasticci | 1 | 82945 | 2 | 3.360 | 24686.0 |
223 | 2024-05-16 11:48:30 | pasticci | 1 | 82945 | 2 | 1.700 | 48791.2 |
222 | 2024-05-04 17:09:16 | pasticci | 3 | 146162 | 37 | 12.766 | 11449.3 |
221 | 2024-05-01 13:32:01 | pasticci | 2 | 121059 | 4 | 8.920 | 13571.6 |
220 | 2024-05-01 13:31:21 | pasticci | 1 | 82945 | 2 | 1.626 | 51011.7 |
219 | 2024-05-01 09:04:29 | pasticci | 3 | 146162 | 37 | 8.236 | 17746.7 |
218 | 2024-05-01 06:47:02 | pasticci | 1 | 82945 | 2 | 1.483 | 55930.5 |
217 | 2024-05-01 06:46:54 | pasticci | 3 | 146162 | 37 | 9.220 | 15852.7 |
216 | 2024-05-01 06:46:57 | pasticci | 2 | 121059 | 4 | 3.860 | 31362.4 |
215 | 2024-04-29 12:20:08 | pasticci | 4 | 161609 | 354 | 14.783 | 10932.1 |
214 | 2024-04-28 17:58:19 | pasticci | 4 | 161609 | 354 | 12.233 | 13210.9 |
213 | 2024-04-28 11:41:49 | pasticci | 4 | 161609 | 354 | 38.676 | 4178.5 |
212 | 2024-04-27 17:03:46 | pasticci | 4 | 161609 | 354 | 17.063 | 9471.3 |
211 | 2024-04-26 15:42:44 | pasticci | 1 | 82945 | 2 | 1.513 | 54821.5 |
210 | 2024-04-26 15:36:59 | pasticci | 2 | 121059 | 4 | 4.030 | 30039.5 |
209 | 2024-04-26 15:36:48 | pasticci | 4 | 161609 | 354 | 13.126 | 12312.1 |
208 | 2024-04-26 15:36:51 | pasticci | 3 | 146162 | 37 | 7.923 | 18447.8 |
207 | 2024-04-26 15:36:29 | pasticci | 4 | 161609 | 354 | 17.186 | 9403.5 |
206 | 2024-04-26 15:36:38 | pasticci | 3 | 146162 | 37 | 8.156 | 17920.8 |
205 | 2024-04-26 15:36:40 | pasticci | 1 | 82945 | 2 | 1.516 | 54713.1 |
204 | 2024-04-26 15:36:33 | pasticci | 2 | 121059 | 4 | 3.893 | 31096.6 |
203 | 2024-04-10 03:46:45 | pasticci | 3 | 146162 | 37 | 13.233 | 11045.3 |
202 | 2024-04-10 03:46:46 | pasticci | 2 | 121059 | 4 | 4.686 | 25834.2 |
201 | 2024-04-10 03:46:43 | pasticci | 1 | 82945 | 2 | 1.453 | 57085.3 |
200 | 2024-03-31 22:15:09 | pasticci | 2 | 121059 | 4 | 6.330 | 19124.6 |
199 | 2024-03-31 22:14:59 | pasticci | 3 | 146162 | 37 | 14.406 | 10145.9 |
198 | 2024-03-31 22:14:55 | pasticci | 1 | 82945 | 2 | 3.250 | 25521.5 |
197 | 2024-03-31 05:15:24 | pasticci | 2 | 121059 | 4 | 5.516 | 21946.9 |
196 | 2024-03-30 03:57:10 | pasticci | 3 | 146162 | 37 | 21.423 | 6822.7 |
195 | 2024-03-29 20:32:52 | pasticci | 3 | 146162 | 37 | 11.576 | 12626.3 |
194 | 2024-03-29 20:32:53 | pasticci | 2 | 121059 | 4 | 4.046 | 29920.7 |
193 | 2024-03-29 20:32:51 | pasticci | 1 | 82945 | 2 | 1.546 | 53651.4 |
192 | 2024-03-29 11:31:27 | pasticci | 1 | 82945 | 2 | 1.906 | 43517.8 |
191 | 2024-03-26 12:52:17 | pasticci | 4 | 161609 | 354 | 13.203 | 12240.3 |
190 | 2024-03-26 02:53:00 | pasticci | 4 | 161609 | 354 | 14.283 | 11314.8 |
189 | 2024-03-22 07:14:10 | pasticci | 4 | 161609 | 354 | 28.486 | 5673.3 |
188 | 2024-03-20 21:20:37 | pasticci | 4 | 161609 | 354 | 41.626 | 3882.4 |
187 | 2024-03-20 00:57:18 | pasticci | 4 | 161609 | 354 | 31.126 | 5192.1 |
186 | 2024-03-12 06:28:28 | pasticci | 1 | 82945 | 2 | 1.516 | 54713.1 |
185 | 2024-03-12 06:28:20 | pasticci | 2 | 121059 | 4 | 5.830 | 20764.8 |
184 | 2024-03-12 06:28:17 | pasticci | 3 | 146162 | 37 | 8.233 | 17753.2 |
183 | 2024-03-12 06:27:55 | pasticci | 4 | 161609 | 354 | 16.080 | 10050.3 |
182 | 2024-03-12 06:27:53 | pasticci | 3 | 146162 | 37 | 16.876 | 8660.9 |
181 | 2024-03-12 06:28:05 | pasticci | 1 | 82945 | 2 | 3.123 | 26559.4 |
180 | 2024-03-12 06:27:52 | pasticci | 2 | 121059 | 4 | 4.420 | 27388.9 |
179 | 2024-02-27 15:35:35 | pasticci | 1 | 82945 | 2 | 1.470 | 56425.2 |
178 | 2024-02-26 09:19:26 | pasticci | 1 | 82945 | 2 | 1.420 | 58412.0 |
177 | 2024-02-22 14:05:57 | pasticci | 4 | 161609 | 354 | 46.723 | 3458.9 |
176 | 2024-02-19 17:56:00 | pasticci | 4 | 161609 | 354 | 16.470 | 9812.3 |
175 | 2024-02-18 03:56:33 | pasticci | 4 | 161609 | 354 | 19.796 | 8163.7 |
174 | 2024-02-17 18:19:44 | pasticci | 3 | 146162 | 37 | 26.923 | 5428.9 |
173 | 2024-02-17 01:26:51 | pasticci | 4 | 161609 | 354 | 31.250 | 5171.5 |
172 | 2024-02-15 22:03:59 | pasticci | 4 | 161609 | 354 | 48.270 | 3348.0 |
171 | 2024-02-15 22:04:02 | pasticci | 3 | 146162 | 37 | 16.986 | 8604.9 |
170 | 2024-02-15 22:03:59 | pasticci | 2 | 121059 | 4 | 4.516 | 26806.7 |
169 | 2024-02-15 21:08:01 | pasticci | 1 | 82945 | 2 | 1.606 | 51646.9 |
168 | 2024-01-22 08:16:43 | pasticci | 1 | 82945 | 2 | 1.453 | 57085.3 |
167 | 2023-12-22 04:18:56 | pasticci | 3 | 146162 | 37 | 6.513 | 22441.6 |
166 | 2023-12-07 21:26:15 | pasticci | 1 | 82945 | 2 | 1.326 | 62552.8 |
165 | 2023-11-28 03:53:05 | pasticci | 1 | 82945 | 2 | 1.456 | 56967.7 |
164 | 2023-11-19 10:12:43 | pasticci | 1 | 82945 | 2 | 1.500 | 55296.7 |
163 | 2023-11-04 16:59:01 | pasticci | 1 | 82945 | 2 | 1.453 | 57085.3 |
162 | 2023-09-24 07:43:26 | pasticci | 3 | 146162 | 37 | 7.436 | 19656.0 |
161 | 2023-09-22 08:25:32 | pasticci | 1 | 82945 | 2 | 1.266 | 65517.4 |
160 | 2023-07-16 08:04:12 | pasticci | 1 | 82945 | 2 | 1.346 | 61623.3 |
159 | 2023-07-03 09:25:52 | pasticci | 3 | 146162 | 37 | 6.766 | 21602.4 |
158 | 2023-04-18 02:43:54 | pasticci | 1 | 82945 | 2 | 1.403 | 59119.7 |
157 | 2023-03-26 17:28:17 | pasticci | 3 | 146162 | 37 | 7.563 | 19325.9 |
156 | 2023-02-07 21:34:40 | pasticci | 1 | 82945 | 2 | 1.283 | 64649.3 |
155 | 2022-12-25 01:45:12 | pasticci | 3 | 146162 | 37 | 6.343 | 23043.0 |
154 | 2022-12-06 06:45:39 | pasticci | 1 | 82945 | 2 | 1.266 | 65517.4 |
153 | 2022-08-25 19:57:30 | pasticci | 3 | 146162 | 37 | 6.423 | 22756.0 |
152 | 2022-08-03 00:44:19 | pasticci | 1 | 82945 | 2 | 1.530 | 54212.4 |
151 | 2022-03-29 14:05:14 | pasticci | 3 | 146162 | 37 | 8.326 | 17554.9 |
150 | 2022-03-23 23:23:57 | pasticci | 1 | 82945 | 2 | 1.453 | 57085.3 |
149 | 2022-01-02 07:42:17 | pasticci | 3 | 146162 | 37 | 6.766 | 21602.4 |
148 | 2021-12-29 21:31:35 | pasticci | 1 | 82945 | 2 | 1.516 | 54713.1 |
147 | 2021-12-27 18:01:28 | pasticci | 1 | 82945 | 2 | 1.343 | 61761.0 |
146 | 2021-10-30 10:13:46 | pasticci | 1 | 82945 | 2 | 3.170 | 26165.6 |
145 | 2021-10-28 09:57:12 | pasticci | 1 | 82945 | 2 | 1.516 | 54713.1 |
144 | 2021-09-20 22:51:08 | pasticci | 1 | 82945 | 2 | 1.436 | 57761.1 |
143 | 2021-09-18 20:41:41 | pasticci | 1 | 82945 | 2 | 1.360 | 60989.0 |
142 | 2021-09-01 08:05:21 | pasticci | 1 | 82945 | 2 | 1.373 | 60411.5 |
141 | 2021-05-06 04:42:01 | pasticci | 1 | 82945 | 2 | 1.313 | 63172.1 |
140 | 2021-04-12 01:34:36 | pasticci | 4 | 161609 | 354 | 11.406 | 14168.8 |
139 | 2021-04-04 09:03:04 | pasticci | 1 | 82945 | 2 | 2.970 | 27927.6 |
138 | 2021-03-15 23:49:00 | pasticci | 4 | 161609 | 354 | 14.330 | 11277.7 |
137 | 2021-03-08 18:04:38 | pasticci | 1 | 82945 | 2 | 1.360 | 60989.0 |
136 | 2021-02-19 00:16:17 | pasticci | 4 | 161609 | 354 | 11.326 | 14268.9 |
135 | 2020-11-04 02:15:31 | pasticci | 1 | 82945 | 2 | 1.393 | 59544.1 |
134 | 2020-10-05 00:58:35 | pasticci | 1 | 82945 | 2 | 1.326 | 62552.8 |
133 | 2020-09-05 22:05:43 | pasticci | 1 | 82945 | 2 | 1.343 | 61761.0 |
132 | 2020-03-23 21:08:02 | pasticci | 1 | 82945 | 2 | 1.530 | 54212.4 |
131 | 2020-03-22 19:34:20 | pasticci | 1 | 82945 | 2 | 1.513 | 54821.5 |
130 | 2020-03-21 02:05:01 | pasticci | 1 | 82945 | 2 | 1.326 | 62552.8 |
129 | 2020-03-02 20:15:57 | pasticci | 1 | 82945 | 2 | 1.563 | 53067.8 |
128 | 2020-02-20 07:40:22 | pasticci | 1 | 82945 | 2 | 1.530 | 54212.4 |
127 | 2020-02-13 05:23:26 | pasticci | 1 | 82945 | 2 | 1.466 | 56579.1 |
126 | 2020-02-10 15:24:33 | pasticci | 4 | 161609 | 354 | 20.093 | 8043.0 |