History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"informants"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
254 | 2024-04-11 13:15:07 | informants | 1 | 67641 | 2 | 1.080 | 62630.6 |
253 | 2024-04-08 07:18:32 | informants | 1 | 67641 | 2 | 1.296 | 52192.1 |
252 | 2024-04-07 11:47:55 | informants | 2 | 108824 | 3 | 11.186 | 9728.6 |
251 | 2024-04-07 11:47:42 | informants | 3 | 140603 | 23 | 7.360 | 19103.7 |
250 | 2024-04-07 11:45:42 | informants | 1 | 67641 | 2 | 2.470 | 27385.0 |
249 | 2024-04-07 00:42:23 | informants | 3 | 140603 | 23 | 18.703 | 7517.7 |
248 | 2024-04-06 22:16:26 | informants | 4 | 161450 | 141 | 16.703 | 9665.9 |
247 | 2024-04-05 14:07:23 | informants | 3 | 140603 | 23 | 28.410 | 4949.1 |
246 | 2024-04-04 14:01:33 | informants | 4 | 161450 | 141 | 30.830 | 5236.8 |
245 | 2024-04-04 06:13:57 | informants | 4 | 161450 | 141 | 33.610 | 4803.6 |
244 | 2024-04-04 06:13:52 | informants | 3 | 140603 | 23 | 20.986 | 6699.8 |
243 | 2024-04-04 06:13:55 | informants | 2 | 108824 | 3 | 8.750 | 12437.0 |
242 | 2024-04-04 06:09:12 | informants | 1 | 67641 | 2 | 1.453 | 46552.6 |
241 | 2024-03-28 09:54:26 | informants | 2 | 108824 | 3 | 5.296 | 20548.3 |
240 | 2024-03-28 09:33:38 | informants | 1 | 67641 | 2 | 1.156 | 58513.0 |
239 | 2024-03-18 04:40:04 | informants | 1 | 67641 | 2 | 1.186 | 57032.9 |
238 | 2024-03-12 03:18:39 | informants | 1 | 67641 | 2 | 3.750 | 18037.6 |
237 | 2024-03-05 15:11:50 | informants | 1 | 67641 | 2 | 1.126 | 60071.9 |
236 | 2024-03-04 22:33:16 | informants | 4 | 161450 | 141 | 27.300 | 5913.9 |
235 | 2024-03-02 06:08:53 | informants | 4 | 161450 | 141 | 25.436 | 6347.3 |
234 | 2024-03-02 06:08:54 | informants | 3 | 140603 | 23 | 7.670 | 18331.6 |
233 | 2024-03-02 06:08:52 | informants | 2 | 108824 | 3 | 8.576 | 12689.4 |
232 | 2024-03-02 06:08:33 | informants | 1 | 67641 | 2 | 2.486 | 27208.8 |
231 | 2024-03-02 06:08:27 | informants | 1 | 67641 | 2 | 2.653 | 25496.0 |
230 | 2024-02-05 19:27:46 | informants | 1 | 67641 | 2 | 1.140 | 59334.2 |
229 | 2024-02-04 06:27:58 | informants | 1 | 67641 | 2 | 1.186 | 57032.9 |
228 | 2024-02-01 04:52:27 | informants | 1 | 67641 | 2 | 1.140 | 59334.2 |
227 | 2024-02-01 04:52:23 | informants | 1 | 67641 | 2 | 1.143 | 59178.5 |
226 | 2023-12-27 05:33:58 | informants | 1 | 67641 | 2 | 1.016 | 66575.8 |
225 | 2023-12-17 10:03:19 | informants | 1 | 67641 | 2 | 0.986 | 68601.4 |
224 | 2023-12-11 11:20:30 | informants | 1 | 67641 | 2 | 1.796 | 37662.0 |
223 | 2023-10-04 16:03:08 | informants | 1 | 67641 | 2 | 1.016 | 66575.8 |
222 | 2023-09-26 06:19:32 | informants | 1 | 67641 | 2 | 0.986 | 68601.4 |
221 | 2023-08-02 10:28:20 | informants | 1 | 67641 | 2 | 1.016 | 66575.8 |
220 | 2023-05-27 03:32:57 | informants | 1 | 67641 | 2 | 1.080 | 62630.6 |
219 | 2023-05-01 13:53:40 | informants | 1 | 67641 | 2 | 1.016 | 66575.8 |
218 | 2023-02-22 07:56:42 | informants | 1 | 67641 | 2 | 0.983 | 68810.8 |
217 | 2023-02-03 16:06:17 | informants | 1 | 67641 | 2 | 1.110 | 60937.8 |
216 | 2023-01-24 21:47:36 | informants | 1 | 67641 | 2 | 0.986 | 68601.4 |
215 | 2022-12-19 20:24:52 | informants | 1 | 67641 | 2 | 1.080 | 62630.6 |
214 | 2022-12-10 18:01:49 | informants | 1 | 67641 | 2 | 1.140 | 59334.2 |
213 | 2022-12-10 17:03:22 | informants | 1 | 67641 | 2 | 0.983 | 68810.8 |
212 | 2022-11-22 19:00:00 | informants | 1 | 67641 | 2 | 1.076 | 62863.4 |
211 | 2022-11-10 16:28:03 | informants | 1 | 67641 | 2 | 1.046 | 64666.3 |
210 | 2022-10-06 03:58:50 | informants | 1 | 67641 | 2 | 1.000 | 67641.0 |
209 | 2022-09-01 07:38:37 | informants | 1 | 67641 | 2 | 1.093 | 61885.6 |
208 | 2022-06-08 08:54:36 | informants | 1 | 67641 | 2 | 1.093 | 61885.6 |
207 | 2022-06-04 18:01:31 | informants | 1 | 67641 | 2 | 1.000 | 67641.0 |
206 | 2022-04-14 13:50:25 | informants | 1 | 67641 | 2 | 1.436 | 47103.8 |
205 | 2022-02-07 15:48:31 | informants | 1 | 67641 | 2 | 1.093 | 61885.6 |
204 | 2022-01-14 12:52:56 | informants | 1 | 67641 | 2 | 1.140 | 59334.2 |
203 | 2021-12-17 15:50:40 | informants | 1 | 67641 | 2 | 1.156 | 58513.0 |
202 | 2021-11-15 05:07:44 | informants | 1 | 67641 | 2 | 1.123 | 60232.4 |
201 | 2021-11-12 12:15:31 | informants | 1 | 67641 | 2 | 1.140 | 59334.2 |
200 | 2021-10-24 10:20:38 | informants | 1 | 67641 | 2 | 1.093 | 61885.6 |
199 | 2021-09-28 00:31:39 | informants | 1 | 67641 | 2 | 1.143 | 59178.5 |
198 | 2021-09-10 22:27:39 | informants | 1 | 67641 | 2 | 0.986 | 68601.4 |
197 | 2021-07-13 16:20:55 | informants | 1 | 67641 | 2 | 2.470 | 27385.0 |
196 | 2021-04-14 11:33:47 | informants | 1 | 67641 | 2 | 1.216 | 55625.8 |
195 | 2020-12-31 20:35:17 | informants | 1 | 67641 | 2 | 1.000 | 67641.0 |
194 | 2020-12-07 03:19:39 | informants | 1 | 67641 | 2 | 1.016 | 66575.8 |
193 | 2020-11-18 05:14:44 | informants | 1 | 67641 | 2 | 1.096 | 61716.2 |
192 | 2020-11-06 07:10:58 | informants | 1 | 67641 | 2 | 1.110 | 60937.8 |
191 | 2020-10-21 06:20:24 | informants | 1 | 67641 | 2 | 0.983 | 68810.8 |
190 | 2020-09-28 20:10:02 | informants | 1 | 67641 | 2 | 1.000 | 67641.0 |
189 | 2020-06-15 22:37:14 | informants | 1 | 67641 | 2 | 1.050 | 64420.0 |
188 | 2020-06-13 05:47:22 | informants | 1 | 67641 | 2 | 1.016 | 66575.8 |
187 | 2020-03-24 13:57:10 | informants | 1 | 67641 | 2 | 1.203 | 56226.9 |
186 | 2020-03-21 17:29:09 | informants | 1 | 67641 | 2 | 1.000 | 67641.0 |
185 | 2020-03-08 17:03:30 | informants | 1 | 67641 | 2 | 1.063 | 63632.2 |
184 | 2020-02-29 00:29:44 | informants | 1 | 67641 | 2 | 3.610 | 18737.1 |
183 | 2020-02-13 02:31:36 | informants | 1 | 67641 | 2 | 2.406 | 28113.5 |
182 | 2020-02-06 09:57:48 | informants | 1 | 67641 | 2 | 1.313 | 51516.4 |
181 | 2020-01-31 17:28:37 | informants | 1 | 67641 | 2 | 1.173 | 57665.0 |
180 | 2020-01-29 02:10:16 | informants | 1 | 67641 | 2 | 3.313 | 20416.8 |
179 | 2020-01-28 08:08:28 | informants | 1 | 67641 | 2 | 1.123 | 60232.4 |
178 | 2020-01-24 03:35:05 | informants | 1 | 67641 | 2 | 2.550 | 26525.9 |
177 | 2020-01-16 19:16:02 | informants | 1 | 67641 | 2 | 1.190 | 56841.2 |
176 | 2020-01-04 21:46:44 | informants | 1 | 67641 | 2 | 1.173 | 57665.0 |
175 | 2020-01-04 21:13:40 | informants | 1 | 67641 | 2 | 1.156 | 58513.0 |
174 | 2019-11-27 00:34:55 | informants | 1 | 67641 | 2 | 1.060 | 63812.3 |
173 | 2019-08-25 07:17:31 | informants | 1 | 67641 | 2 | 1.043 | 64852.3 |
172 | 2019-05-16 05:22:58 | informants | 1 | 67641 | 2 | 1.116 | 60610.2 |
171 | 2019-03-08 13:24:47 | informants | 1 | 67641 | 2 | 0.973 | 69518.0 |
170 | 2019-01-28 08:21:16 | informants | 1 | 67641 | 2 | 0.976 | 69304.3 |
169 | 2018-12-08 08:20:02 | informants | 1 | 67641 | 2 | 0.943 | 71729.6 |
168 | 2018-10-04 01:42:16 | informants | 1 | 67641 | 2 | 1.186 | 57032.9 |
167 | 2018-10-01 15:52:28 | informants | 1 | 67641 | 2 | 1.136 | 59543.1 |
166 | 2018-07-01 16:15:14 | informants | 1 | 67641 | 2 | 2.276 | 29719.2 |
165 | 2018-06-27 13:18:02 | informants | 1 | 67641 | 2 | 1.123 | 60232.4 |
164 | 2018-06-23 18:42:52 | informants | 1 | 67641 | 2 | 1.130 | 59859.3 |
163 | 2018-06-23 15:01:36 | informants | 1 | 67641 | 2 | 0.983 | 68810.8 |
162 | 2018-06-23 14:21:57 | informants | 1 | 67641 | 2 | 1.050 | 64420.0 |
161 | 2018-06-23 11:52:04 | informants | 1 | 67641 | 2 | 2.133 | 31711.7 |
160 | 2017-12-22 22:51:17 | informants | 1 | 67641 | 2 | 1.333 | 50743.4 |
159 | 2017-07-29 10:15:49 | informants | 1 | 67641 | 2 | 1.273 | 53135.1 |
158 | 2017-04-04 19:48:24 | informants | 1 | 67641 | 2 | 1.463 | 46234.4 |
157 | 2017-03-30 02:50:06 | informants | 1 | 67641 | 2 | 1.390 | 48662.6 |
156 | 2017-01-08 13:26:10 | informants | 1 | 67641 | 2 | 1.220 | 55443.4 |
155 | 2017-01-07 22:39:50 | informants | 3 | 140603 | 23 | 6.993 | 20106.2 |