History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rifampicin"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
279 | 2025-09-29 14:42:14 | rifampicin | 4 | 161450 | 8 | 11.313 | 14271.2 |
278 | 2025-09-29 12:28:47 | rifampicin | 3 | 140603 | 6 | 6.750 | 20830.1 |
277 | 2025-09-29 12:28:01 | rifampicin | 2 | 108824 | 4 | 3.343 | 32552.8 |
276 | 2025-08-09 12:40:26 | rifampicin | 1 | 67641 | 2 | 7.253 | 9325.9 |
275 | 2025-07-25 10:05:43 | rifampicin | 1 | 67641 | 2 | 3.046 | 22206.5 |
274 | 2025-07-25 07:43:32 | rifampicin | 1 | 67641 | 2 | 4.860 | 13917.9 |
273 | 2025-07-24 02:20:41 | rifampicin | 1 | 67641 | 2 | 6.686 | 10116.8 |
272 | 2025-07-19 17:15:08 | rifampicin | 1 | 67641 | 2 | 1.143 | 59178.5 |
271 | 2025-05-30 12:41:52 | rifampicin | 1 | 67641 | 2 | 5.103 | 13255.1 |
270 | 2025-04-28 13:05:59 | rifampicin | 1 | 67641 | 2 | 3.310 | 20435.3 |
269 | 2025-04-23 17:10:53 | rifampicin | 4 | 161450 | 8 | 41.160 | 3922.5 |
268 | 2025-04-23 02:11:18 | rifampicin | 2 | 108824 | 4 | 14.983 | 7263.2 |
267 | 2025-04-22 23:16:32 | rifampicin | 3 | 140603 | 6 | 17.953 | 7831.7 |
266 | 2025-03-08 00:32:50 | rifampicin | 4 | 161450 | 8 | 49.593 | 3255.5 |
265 | 2025-03-07 01:37:04 | rifampicin | 3 | 140603 | 6 | 25.046 | 5613.8 |
264 | 2025-03-07 01:36:58 | rifampicin | 2 | 108824 | 4 | 22.706 | 4792.7 |
263 | 2025-02-28 13:19:07 | rifampicin | 3 | 140603 | 6 | 43.033 | 3267.3 |
262 | 2025-02-28 13:19:06 | rifampicin | 2 | 108824 | 4 | 16.523 | 6586.2 |
261 | 2025-02-28 13:19:06 | rifampicin | 3 | 140603 | 6 | 17.146 | 8200.3 |
260 | 2025-02-24 07:56:14 | rifampicin | 1 | 67641 | 2 | 5.063 | 13359.9 |
259 | 2025-02-21 06:11:42 | rifampicin | 3 | 140603 | 6 | 40.953 | 3433.3 |
258 | 2025-02-21 06:11:41 | rifampicin | 2 | 108824 | 4 | 15.186 | 7166.1 |
257 | 2025-02-21 06:11:16 | rifampicin | 3 | 140603 | 6 | 33.656 | 4177.7 |
256 | 2025-02-21 06:11:19 | rifampicin | 3 | 140603 | 6 | 28.016 | 5018.7 |
255 | 2025-02-21 06:08:13 | rifampicin | 1 | 67641 | 2 | 6.733 | 10046.2 |
254 | 2025-02-05 09:00:55 | rifampicin | 1 | 67641 | 2 | 4.376 | 15457.3 |
253 | 2025-01-31 12:35:42 | rifampicin | 4 | 161450 | 8 | 44.316 | 3643.2 |
252 | 2025-01-31 12:35:25 | rifampicin | 4 | 161450 | 8 | 57.000 | 2832.5 |
251 | 2025-01-31 12:35:23 | rifampicin | 3 | 140603 | 6 | 38.566 | 3645.8 |
250 | 2025-01-31 12:35:17 | rifampicin | 2 | 108824 | 4 | 16.593 | 6558.4 |
249 | 2025-01-22 18:55:54 | rifampicin | 1 | 67641 | 2 | 7.983 | 8473.1 |
248 | 2025-01-21 10:16:36 | rifampicin | 4 | 161450 | 8 | 74.163 | 2177.0 |
247 | 2025-01-21 10:16:23 | rifampicin | 1 | 67641 | 2 | 7.736 | 8743.7 |
246 | 2025-01-14 23:05:26 | rifampicin | 4 | 161450 | 8 | 52.080 | 3100.0 |
245 | 2025-01-07 05:06:38 | rifampicin | 4 | 161450 | 8 | 57.673 | 2799.4 |
244 | 2025-01-07 05:06:20 | rifampicin | 3 | 140603 | 6 | 25.876 | 5433.7 |
243 | 2025-01-07 05:06:04 | rifampicin | 2 | 108824 | 4 | 11.906 | 9140.3 |
242 | 2025-01-06 18:44:41 | rifampicin | 4 | 161450 | 8 | 56.816 | 2841.6 |
241 | 2024-12-30 10:15:23 | rifampicin | 4 | 161450 | 8 | 54.970 | 2937.1 |
240 | 2024-12-21 02:56:10 | rifampicin | 3 | 140603 | 6 | 25.953 | 5417.6 |
239 | 2024-12-21 02:56:10 | rifampicin | 2 | 108824 | 4 | 12.110 | 8986.3 |
238 | 2024-12-21 02:54:59 | rifampicin | 1 | 67641 | 2 | 2.516 | 26884.3 |
237 | 2024-12-13 16:32:38 | rifampicin | 3 | 140603 | 6 | 31.610 | 4448.1 |
236 | 2024-12-13 16:32:46 | rifampicin | 2 | 108824 | 4 | 22.063 | 4932.4 |
235 | 2024-12-13 16:29:48 | rifampicin | 1 | 67641 | 2 | 5.096 | 13273.4 |
234 | 2024-12-04 21:46:36 | rifampicin | 3 | 140603 | 6 | 39.970 | 3517.7 |
233 | 2024-12-04 05:51:45 | rifampicin | 3 | 140603 | 6 | 29.486 | 4768.5 |
232 | 2024-12-04 05:51:46 | rifampicin | 2 | 108824 | 4 | 7.373 | 14759.8 |
231 | 2024-12-04 05:47:41 | rifampicin | 1 | 67641 | 2 | 6.623 | 10213.0 |
230 | 2024-11-30 04:59:41 | rifampicin | 3 | 140603 | 6 | 34.956 | 4022.3 |
229 | 2024-11-21 13:25:59 | rifampicin | 4 | 161450 | 8 | 66.626 | 2423.2 |
228 | 2024-11-21 13:25:25 | rifampicin | 4 | 161450 | 8 | 67.670 | 2385.8 |
227 | 2024-11-21 13:25:43 | rifampicin | 3 | 140603 | 6 | 34.046 | 4129.8 |
226 | 2024-11-21 13:25:43 | rifampicin | 2 | 108824 | 4 | 15.813 | 6881.9 |
225 | 2024-11-21 13:23:23 | rifampicin | 1 | 67641 | 2 | 3.516 | 19238.1 |
224 | 2024-11-20 12:56:13 | rifampicin | 4 | 161450 | 8 | 53.533 | 3015.9 |
223 | 2024-11-20 11:03:24 | rifampicin | 1 | 67641 | 2 | 1.216 | 55625.8 |
222 | 2024-11-15 20:18:20 | rifampicin | 4 | 161450 | 8 | 59.016 | 2735.7 |
221 | 2024-11-10 00:06:35 | rifampicin | 1 | 67641 | 2 | 3.110 | 21749.5 |
220 | 2024-11-04 00:13:09 | rifampicin | 1 | 67641 | 2 | 1.173 | 57665.0 |
219 | 2024-10-19 02:03:18 | rifampicin | 3 | 140603 | 6 | 22.080 | 6367.9 |
218 | 2024-10-19 02:00:47 | rifampicin | 1 | 67641 | 2 | 2.876 | 23519.1 |
217 | 2024-10-19 01:51:32 | rifampicin | 2 | 108824 | 4 | 7.593 | 14332.1 |
216 | 2024-10-19 01:32:36 | rifampicin | 1 | 67641 | 2 | 5.330 | 12690.6 |
215 | 2024-10-15 14:26:21 | rifampicin | 1 | 67641 | 2 | 5.283 | 12803.5 |
214 | 2024-10-15 02:27:14 | rifampicin | 3 | 140603 | 6 | 33.426 | 4206.4 |
213 | 2024-10-15 02:27:01 | rifampicin | 3 | 140603 | 6 | 30.720 | 4576.9 |
212 | 2024-10-13 09:06:23 | rifampicin | 3 | 140603 | 6 | 33.690 | 4173.4 |
211 | 2024-10-13 09:05:41 | rifampicin | 3 | 140603 | 6 | 40.456 | 3475.5 |
210 | 2024-10-13 09:04:54 | rifampicin | 2 | 108824 | 4 | 12.766 | 8524.5 |
209 | 2024-10-13 08:22:35 | rifampicin | 4 | 161450 | 8 | 58.673 | 2751.7 |
208 | 2024-10-13 04:59:55 | rifampicin | 4 | 161450 | 8 | 68.770 | 2347.7 |
207 | 2024-10-13 05:00:26 | rifampicin | 3 | 140603 | 6 | 26.300 | 5346.1 |
206 | 2024-10-13 04:59:55 | rifampicin | 4 | 161450 | 8 | 54.563 | 2959.0 |
205 | 2024-10-13 05:00:06 | rifampicin | 2 | 108824 | 4 | 14.296 | 7612.2 |
204 | 2024-10-13 04:51:42 | rifampicin | 1 | 67641 | 2 | 2.673 | 25305.3 |
203 | 2024-10-10 15:28:01 | rifampicin | 3 | 140603 | 6 | 27.326 | 5145.4 |
202 | 2024-10-01 05:56:35 | rifampicin | 3 | 140603 | 6 | 46.893 | 2998.4 |
201 | 2024-09-17 04:32:50 | rifampicin | 1 | 67641 | 2 | 6.893 | 9813.0 |
200 | 2024-08-23 00:51:31 | rifampicin | 2 | 108824 | 4 | 10.813 | 10064.2 |
199 | 2024-08-16 15:50:55 | rifampicin | 4 | 161450 | 8 | 81.536 | 1980.1 |
198 | 2024-08-16 15:50:31 | rifampicin | 3 | 140603 | 6 | 70.033 | 2007.7 |
197 | 2024-08-16 15:50:09 | rifampicin | 2 | 108824 | 4 | 34.143 | 3187.3 |
196 | 2024-08-09 11:41:48 | rifampicin | 4 | 161450 | 8 | 64.906 | 2487.4 |
195 | 2024-08-08 23:21:11 | rifampicin | 4 | 161450 | 8 | 40.143 | 4021.9 |
194 | 2024-08-08 23:21:09 | rifampicin | 2 | 108824 | 4 | 13.830 | 7868.7 |
193 | 2024-08-08 23:21:10 | rifampicin | 3 | 140603 | 6 | 12.533 | 11218.6 |
192 | 2024-08-07 23:39:52 | rifampicin | 1 | 67641 | 2 | 1.670 | 40503.6 |
191 | 2024-07-20 00:53:48 | rifampicin | 4 | 161450 | 8 | 46.910 | 3441.7 |
190 | 2024-07-20 00:53:54 | rifampicin | 2 | 108824 | 4 | 15.690 | 6935.9 |
189 | 2024-07-20 00:53:54 | rifampicin | 3 | 140603 | 6 | 11.893 | 11822.3 |
188 | 2024-07-20 00:52:35 | rifampicin | 1 | 67641 | 2 | 3.766 | 17961.0 |
187 | 2024-07-16 20:34:34 | rifampicin | 1 | 67641 | 2 | 2.360 | 28661.4 |
186 | 2024-07-16 18:50:57 | rifampicin | 3 | 140603 | 6 | 28.126 | 4999.0 |
185 | 2024-07-16 18:50:54 | rifampicin | 2 | 108824 | 4 | 15.436 | 7050.0 |
184 | 2024-07-16 04:41:47 | rifampicin | 4 | 161450 | 8 | 51.073 | 3161.2 |
183 | 2024-07-14 11:57:10 | rifampicin | 4 | 161450 | 8 | 49.076 | 3289.8 |
182 | 2024-07-14 11:57:11 | rifampicin | 3 | 140603 | 6 | 28.313 | 4966.0 |
181 | 2024-07-14 06:29:22 | rifampicin | 5 | 173545 | 62 | 84.516 | 2053.4 |
180 | 2024-07-07 21:14:51 | rifampicin | 1 | 67641 | 2 | 2.063 | 32787.7 |