History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"thievery"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
232 | 2024-05-11 15:09:53 | thievery | 4 | 161609 | 672 | 18.076 | 8940.5 |
231 | 2024-05-11 06:45:06 | thievery | 4 | 161609 | 672 | 28.643 | 5642.2 |
230 | 2024-05-08 07:07:12 | thievery | 4 | 161609 | 672 | 30.440 | 5309.1 |
229 | 2024-05-08 07:07:11 | thievery | 3 | 146162 | 47 | 18.750 | 7795.3 |
228 | 2024-05-08 07:07:11 | thievery | 2 | 121059 | 5 | 12.720 | 9517.2 |
227 | 2024-05-08 07:06:59 | thievery | 1 | 82945 | 1 | 1.656 | 50087.6 |
226 | 2024-04-30 09:05:50 | thievery | 1 | 82945 | 1 | 1.563 | 53067.8 |
225 | 2024-04-16 01:38:29 | thievery | 4 | 161609 | 672 | 40.610 | 3979.5 |
224 | 2024-04-13 00:03:33 | thievery | 4 | 161609 | 672 | 17.440 | 9266.6 |
223 | 2024-04-12 21:01:34 | thievery | 4 | 161609 | 672 | 20.783 | 7776.0 |
222 | 2024-04-11 14:46:12 | thievery | 1 | 82945 | 1 | 1.410 | 58826.2 |
221 | 2024-04-10 21:19:20 | thievery | 4 | 161609 | 672 | 27.110 | 5961.2 |
220 | 2024-04-10 08:58:28 | thievery | 4 | 161609 | 672 | 13.593 | 11889.1 |
219 | 2024-04-10 08:58:29 | thievery | 2 | 121059 | 5 | 3.860 | 31362.4 |
218 | 2024-04-10 08:58:27 | thievery | 1 | 82945 | 1 | 1.530 | 54212.4 |
217 | 2024-04-09 18:44:45 | thievery | 3 | 146162 | 47 | 15.703 | 9307.9 |
216 | 2024-04-08 07:57:46 | thievery | 1 | 82945 | 1 | 1.483 | 55930.5 |
215 | 2024-04-07 17:41:26 | thievery | 2 | 121059 | 5 | 4.143 | 29220.1 |
214 | 2024-04-07 17:41:25 | thievery | 1 | 82945 | 1 | 1.690 | 49079.9 |
213 | 2024-04-05 20:03:38 | thievery | 3 | 146162 | 47 | 8.313 | 17582.3 |
212 | 2024-04-03 12:53:02 | thievery | 3 | 146162 | 47 | 16.783 | 8708.9 |
211 | 2024-04-01 18:37:44 | thievery | 3 | 146162 | 47 | 33.940 | 4306.5 |
210 | 2024-04-01 09:05:10 | thievery | 2 | 121059 | 5 | 4.093 | 29577.1 |
209 | 2024-04-01 09:00:37 | thievery | 3 | 146162 | 47 | 7.436 | 19656.0 |
208 | 2024-03-31 01:04:45 | thievery | 2 | 121059 | 5 | 7.936 | 15254.4 |
207 | 2024-03-31 01:04:41 | thievery | 3 | 146162 | 47 | 10.016 | 14592.9 |
206 | 2024-03-31 01:04:15 | thievery | 1 | 82945 | 1 | 1.643 | 50483.9 |
205 | 2024-03-14 14:21:56 | thievery | 4 | 161609 | 672 | 29.536 | 5471.6 |
204 | 2024-03-14 10:46:19 | thievery | 4 | 161609 | 672 | 22.750 | 7103.7 |
203 | 2024-03-13 17:27:53 | thievery | 4 | 161609 | 672 | 20.046 | 8061.9 |
202 | 2024-03-11 22:35:51 | thievery | 2 | 121059 | 5 | 4.016 | 30144.2 |
201 | 2024-03-11 22:35:38 | thievery | 1 | 82945 | 1 | 3.326 | 24938.4 |
200 | 2024-03-11 13:16:38 | thievery | 4 | 161609 | 672 | 28.470 | 5676.5 |
199 | 2024-03-11 06:58:49 | thievery | 4 | 161609 | 672 | 14.780 | 10934.3 |
198 | 2024-03-11 04:22:23 | thievery | 4 | 161609 | 672 | 13.110 | 12327.2 |
197 | 2024-03-11 04:22:24 | thievery | 2 | 121059 | 5 | 3.860 | 31362.4 |
196 | 2024-03-11 04:22:22 | thievery | 1 | 82945 | 1 | 1.500 | 55296.7 |
195 | 2024-03-06 16:27:18 | thievery | 3 | 146162 | 47 | 18.173 | 8042.8 |
194 | 2024-03-02 02:54:48 | thievery | 3 | 146162 | 47 | 17.563 | 8322.2 |
193 | 2024-02-29 10:39:43 | thievery | 1 | 82945 | 1 | 1.483 | 55930.5 |
192 | 2024-02-28 12:11:01 | thievery | 3 | 146162 | 47 | 14.436 | 10124.8 |
191 | 2024-02-28 12:11:02 | thievery | 2 | 121059 | 5 | 3.720 | 32542.7 |
190 | 2024-02-28 12:10:53 | thievery | 1 | 82945 | 1 | 1.576 | 52630.1 |
189 | 2024-02-06 08:53:21 | thievery | 2 | 121059 | 5 | 3.720 | 32542.7 |
188 | 2024-02-06 08:53:10 | thievery | 3 | 146162 | 47 | 7.673 | 19048.9 |
187 | 2024-02-06 00:22:49 | thievery | 4 | 161609 | 672 | 11.250 | 14365.2 |
186 | 2024-02-05 18:41:22 | thievery | 4 | 161609 | 672 | 13.016 | 12416.2 |
185 | 2024-02-05 15:08:38 | thievery | 3 | 146162 | 47 | 6.796 | 21507.1 |
184 | 2024-02-05 14:10:15 | thievery | 2 | 121059 | 5 | 7.783 | 15554.3 |
183 | 2024-02-05 14:10:07 | thievery | 4 | 161609 | 672 | 13.190 | 12252.4 |
182 | 2024-02-05 14:10:11 | thievery | 3 | 146162 | 47 | 8.050 | 18156.8 |
181 | 2024-02-05 14:10:03 | thievery | 1 | 82945 | 1 | 2.703 | 30686.3 |
180 | 2024-01-30 12:41:24 | thievery | 1 | 82945 | 1 | 1.500 | 55296.7 |
179 | 2024-01-20 20:15:55 | thievery | 1 | 82945 | 1 | 1.233 | 67270.9 |
178 | 2023-12-28 12:39:34 | thievery | 1 | 82945 | 1 | 2.606 | 31828.5 |
177 | 2023-12-26 08:55:57 | thievery | 1 | 82945 | 1 | 1.453 | 57085.3 |
176 | 2023-12-11 11:42:00 | thievery | 4 | 161609 | 672 | 12.640 | 12785.5 |
175 | 2023-12-09 04:59:31 | thievery | 4 | 161609 | 672 | 11.956 | 13517.0 |
174 | 2023-12-09 04:59:35 | thievery | 3 | 146162 | 47 | 7.593 | 19249.6 |
173 | 2023-12-09 04:59:37 | thievery | 2 | 121059 | 5 | 3.843 | 31501.2 |
172 | 2023-11-28 09:24:09 | thievery | 1 | 82945 | 1 | 1.250 | 66356.0 |
171 | 2023-11-11 05:50:13 | thievery | 1 | 82945 | 1 | 1.436 | 57761.1 |
170 | 2023-11-04 22:13:16 | thievery | 1 | 82945 | 1 | 1.236 | 67107.6 |
169 | 2023-10-17 01:26:37 | thievery | 1 | 82945 | 1 | 1.220 | 67987.7 |
168 | 2023-09-24 08:43:13 | thievery | 1 | 82945 | 1 | 1.373 | 60411.5 |
167 | 2023-09-15 03:51:48 | thievery | 1 | 82945 | 1 | 1.280 | 64800.8 |
166 | 2023-08-14 10:18:27 | thievery | 1 | 82945 | 1 | 1.236 | 67107.6 |
165 | 2023-07-22 21:22:37 | thievery | 1 | 82945 | 1 | 1.216 | 68211.3 |
164 | 2023-05-08 02:57:44 | thievery | 1 | 82945 | 1 | 1.250 | 66356.0 |
163 | 2023-03-05 01:36:07 | thievery | 1 | 82945 | 1 | 1.233 | 67270.9 |
162 | 2023-02-04 05:38:16 | thievery | 1 | 82945 | 1 | 1.250 | 66356.0 |
161 | 2022-12-28 17:35:06 | thievery | 1 | 82945 | 1 | 1.373 | 60411.5 |
160 | 2022-09-15 07:12:28 | thievery | 1 | 82945 | 1 | 1.313 | 63172.1 |
159 | 2022-08-18 11:26:28 | thievery | 1 | 82945 | 1 | 1.220 | 67987.7 |
158 | 2022-02-04 15:07:16 | thievery | 1 | 82945 | 1 | 1.686 | 49196.3 |
157 | 2021-09-03 09:37:13 | thievery | 1 | 82945 | 1 | 1.313 | 63172.1 |
156 | 2021-05-10 10:25:47 | thievery | 4 | 161609 | 672 | 21.470 | 7527.2 |
155 | 2021-05-03 12:09:36 | thievery | 1 | 82945 | 1 | 1.356 | 61168.9 |
154 | 2021-04-29 20:29:10 | thievery | 1 | 82945 | 1 | 1.436 | 57761.1 |
153 | 2021-04-09 03:45:06 | thievery | 4 | 161609 | 672 | 10.843 | 14904.5 |
152 | 2021-03-14 01:09:51 | thievery | 1 | 82945 | 1 | 1.236 | 67107.6 |
151 | 2021-03-13 08:18:51 | thievery | 4 | 161609 | 672 | 13.030 | 12402.8 |
150 | 2021-02-22 19:39:47 | thievery | 1 | 82945 | 1 | 1.280 | 64800.8 |
149 | 2021-02-20 09:48:06 | thievery | 4 | 161609 | 672 | 14.373 | 11243.9 |
148 | 2021-02-16 16:15:17 | thievery | 4 | 161609 | 672 | 10.610 | 15231.8 |
147 | 2021-01-26 17:39:47 | thievery | 4 | 161609 | 672 | 12.456 | 12974.4 |
146 | 2020-12-25 13:25:02 | thievery | 4 | 161609 | 672 | 10.436 | 15485.7 |
145 | 2020-12-21 13:48:57 | thievery | 1 | 82945 | 1 | 1.263 | 65673.0 |
144 | 2020-11-29 06:56:37 | thievery | 1 | 82945 | 1 | 1.263 | 65673.0 |
143 | 2020-11-10 06:03:00 | thievery | 1 | 82945 | 1 | 1.596 | 51970.6 |
142 | 2020-08-18 16:51:29 | thievery | 1 | 82945 | 1 | 1.296 | 64000.8 |
141 | 2020-08-06 12:21:57 | thievery | 1 | 82945 | 1 | 1.266 | 65517.4 |
140 | 2020-04-13 06:48:53 | thievery | 1 | 82945 | 1 | 1.280 | 64800.8 |
139 | 2020-03-28 03:54:31 | thievery | 1 | 82945 | 1 | 1.470 | 56425.2 |
138 | 2020-02-17 15:17:50 | thievery | 1 | 82945 | 1 | 3.063 | 27079.7 |
137 | 2020-02-12 00:15:11 | thievery | 1 | 82945 | 1 | 1.500 | 55296.7 |
136 | 2020-02-09 16:30:27 | thievery | 1 | 82945 | 1 | 3.080 | 26930.2 |
135 | 2020-02-05 01:11:54 | thievery | 1 | 82945 | 1 | 1.796 | 46183.2 |
134 | 2020-02-03 22:55:34 | thievery | 1 | 82945 | 1 | 1.266 | 65517.4 |
133 | 2020-01-23 12:52:25 | thievery | 1 | 82945 | 1 | 3.140 | 26415.6 |