History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"acyclovirs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
174 | 2024-04-30 19:59:49 | acyclovirs | 1 | 67641 | 2 | 1.123 | 60232.4 |
173 | 2024-04-16 20:15:21 | acyclovirs | 1 | 67641 | 2 | 3.610 | 18737.1 |
172 | 2024-03-31 14:59:29 | acyclovirs | 1 | 67641 | 2 | 1.186 | 57032.9 |
171 | 2024-03-30 17:52:59 | acyclovirs | 5 | 173545 | 236 | 41.723 | 4159.5 |
170 | 2024-03-30 04:24:35 | acyclovirs | 5 | 173545 | 236 | 45.063 | 3851.2 |
169 | 2024-03-29 15:45:35 | acyclovirs | 5 | 173545 | 236 | 37.063 | 4682.4 |
168 | 2024-03-27 02:48:20 | acyclovirs | 5 | 173545 | 236 | 40.050 | 4333.2 |
167 | 2024-03-27 02:48:13 | acyclovirs | 4 | 161450 | 29 | 13.033 | 12387.8 |
166 | 2024-03-27 02:48:11 | acyclovirs | 2 | 108824 | 2 | 10.330 | 10534.8 |
165 | 2024-03-27 02:48:06 | acyclovirs | 3 | 140603 | 5 | 13.936 | 10089.2 |
164 | 2024-03-27 01:51:28 | acyclovirs | 1 | 67641 | 2 | 1.203 | 56226.9 |
163 | 2024-02-29 01:29:18 | acyclovirs | 1 | 67641 | 2 | 1.153 | 58665.2 |
162 | 2024-02-16 11:51:05 | acyclovirs | 1 | 67641 | 2 | 3.920 | 17255.4 |
161 | 2024-02-04 19:17:05 | acyclovirs | 1 | 67641 | 2 | 2.076 | 32582.4 |
160 | 2024-01-31 19:26:40 | acyclovirs | 1 | 67641 | 2 | 1.203 | 56226.9 |
159 | 2024-01-31 07:22:11 | acyclovirs | 1 | 67641 | 2 | 2.483 | 27241.6 |
158 | 2024-01-27 04:05:59 | acyclovirs | 1 | 67641 | 2 | 1.186 | 57032.9 |
157 | 2024-01-19 00:20:25 | acyclovirs | 5 | 173545 | 236 | 15.046 | 11534.3 |
156 | 2023-12-30 18:36:52 | acyclovirs | 4 | 161450 | 29 | 9.220 | 17510.8 |
155 | 2023-12-23 02:05:32 | acyclovirs | 2 | 108824 | 2 | 2.593 | 41968.4 |
154 | 2023-12-15 11:58:22 | acyclovirs | 5 | 173545 | 236 | 14.923 | 11629.4 |
153 | 2023-12-14 14:55:02 | acyclovirs | 1 | 67641 | 2 | 1.016 | 66575.8 |
152 | 2023-12-08 23:07:44 | acyclovirs | 1 | 67641 | 2 | 1.013 | 66773.0 |
151 | 2023-12-06 05:56:08 | acyclovirs | 5 | 173545 | 236 | 41.630 | 4168.7 |
150 | 2023-12-03 05:38:53 | acyclovirs | 5 | 173545 | 236 | 19.360 | 8964.1 |
149 | 2023-11-20 16:30:49 | acyclovirs | 1 | 67641 | 2 | 1.186 | 57032.9 |
148 | 2023-10-28 04:17:48 | acyclovirs | 5 | 173545 | 236 | 18.250 | 9509.3 |
147 | 2023-10-01 03:23:06 | acyclovirs | 4 | 161450 | 29 | 9.876 | 16347.7 |
146 | 2023-09-27 00:07:23 | acyclovirs | 1 | 67641 | 2 | 1.126 | 60071.9 |
145 | 2023-09-26 03:45:35 | acyclovirs | 2 | 108824 | 2 | 2.733 | 39818.5 |
144 | 2023-09-23 15:42:57 | acyclovirs | 1 | 67641 | 2 | 1.000 | 67641.0 |
143 | 2023-08-06 04:51:09 | acyclovirs | 5 | 173545 | 236 | 14.346 | 12097.1 |
142 | 2023-07-21 05:21:04 | acyclovirs | 1 | 67641 | 2 | 1.110 | 60937.8 |
141 | 2023-07-12 00:10:32 | acyclovirs | 4 | 161450 | 29 | 14.016 | 11519.0 |
140 | 2023-07-08 19:26:17 | acyclovirs | 2 | 108824 | 2 | 2.906 | 37448.0 |
139 | 2023-05-07 06:49:13 | acyclovirs | 1 | 67641 | 2 | 1.030 | 65670.9 |
138 | 2023-04-21 05:03:43 | acyclovirs | 1 | 67641 | 2 | 1.000 | 67641.0 |
137 | 2023-04-17 21:49:58 | acyclovirs | 5 | 173545 | 236 | 13.783 | 12591.2 |
136 | 2023-03-28 11:30:06 | acyclovirs | 4 | 161450 | 29 | 8.796 | 18354.9 |
135 | 2023-03-27 21:50:10 | acyclovirs | 2 | 108824 | 2 | 2.563 | 42459.6 |
134 | 2023-02-12 01:59:15 | acyclovirs | 1 | 67641 | 2 | 1.190 | 56841.2 |
133 | 2023-01-22 20:14:45 | acyclovirs | 5 | 173545 | 236 | 13.766 | 12606.8 |
132 | 2023-01-01 23:00:24 | acyclovirs | 5 | 173545 | 236 | 17.576 | 9874.0 |
131 | 2022-12-25 20:58:57 | acyclovirs | 4 | 161450 | 29 | 8.940 | 18059.3 |
130 | 2022-12-24 06:23:20 | acyclovirs | 2 | 108824 | 2 | 2.890 | 37655.4 |
129 | 2022-12-18 20:42:18 | acyclovirs | 1 | 67641 | 2 | 1.106 | 61158.2 |
128 | 2022-12-10 15:51:48 | acyclovirs | 1 | 67641 | 2 | 1.000 | 67641.0 |
127 | 2022-11-11 03:49:32 | acyclovirs | 5 | 173545 | 236 | 14.876 | 11666.1 |
126 | 2022-11-08 18:24:51 | acyclovirs | 5 | 173545 | 236 | 15.826 | 10965.8 |
125 | 2022-11-03 23:48:53 | acyclovirs | 5 | 173545 | 236 | 24.643 | 7042.4 |
124 | 2022-11-02 13:06:30 | acyclovirs | 5 | 173545 | 236 | 17.143 | 10123.4 |
123 | 2022-10-02 09:47:09 | acyclovirs | 5 | 173545 | 236 | 14.436 | 12021.7 |
122 | 2022-08-26 06:26:10 | acyclovirs | 4 | 161450 | 29 | 9.016 | 17907.1 |
121 | 2022-08-25 12:28:09 | acyclovirs | 2 | 108824 | 2 | 2.563 | 42459.6 |
120 | 2022-08-18 19:00:12 | acyclovirs | 5 | 173545 | 236 | 14.173 | 12244.8 |
119 | 2022-08-13 15:53:41 | acyclovirs | 1 | 67641 | 2 | 1.013 | 66773.0 |
118 | 2022-08-12 08:36:22 | acyclovirs | 5 | 173545 | 236 | 14.690 | 11813.8 |
117 | 2022-08-09 23:03:11 | acyclovirs | 5 | 173545 | 236 | 15.593 | 11129.7 |
116 | 2022-07-26 10:02:18 | acyclovirs | 1 | 67641 | 2 | 1.030 | 65670.9 |
115 | 2022-07-22 17:54:50 | acyclovirs | 1 | 67641 | 2 | 1.000 | 67641.0 |
114 | 2022-07-17 08:01:14 | acyclovirs | 5 | 173545 | 236 | 15.436 | 11242.9 |
113 | 2022-06-06 01:34:45 | acyclovirs | 5 | 173545 | 236 | 14.126 | 12285.5 |
112 | 2022-04-06 22:22:07 | acyclovirs | 1 | 67641 | 2 | 1.250 | 54112.8 |
111 | 2022-04-04 18:24:34 | acyclovirs | 1 | 67641 | 2 | 1.733 | 39031.2 |
110 | 2022-04-02 14:51:45 | acyclovirs | 1 | 67641 | 2 | 1.000 | 67641.0 |
109 | 2022-02-11 23:20:53 | acyclovirs | 1 | 67641 | 2 | 1.283 | 52721.0 |
108 | 2021-12-20 10:08:21 | acyclovirs | 1 | 67641 | 2 | 1.170 | 57812.8 |
107 | 2021-09-29 09:00:46 | acyclovirs | 1 | 67641 | 2 | 1.156 | 58513.0 |
106 | 2021-09-26 02:39:44 | acyclovirs | 1 | 67641 | 2 | 1.030 | 65670.9 |
105 | 2021-06-13 05:14:02 | acyclovirs | 1 | 67641 | 2 | 1.170 | 57812.8 |
104 | 2021-03-06 22:44:54 | acyclovirs | 1 | 67641 | 2 | 1.156 | 58513.0 |
103 | 2020-11-18 20:52:52 | acyclovirs | 1 | 67641 | 2 | 1.110 | 60937.8 |
102 | 2020-07-24 21:47:28 | acyclovirs | 1 | 67641 | 2 | 1.283 | 52721.0 |
101 | 2020-04-10 10:02:35 | acyclovirs | 1 | 67641 | 2 | 1.030 | 65670.9 |
100 | 2020-03-27 01:34:30 | acyclovirs | 1 | 67641 | 2 | 2.450 | 27608.6 |
99 | 2020-02-29 05:21:18 | acyclovirs | 1 | 67641 | 2 | 1.236 | 54725.7 |
98 | 2020-02-28 04:27:25 | acyclovirs | 1 | 67641 | 2 | 1.156 | 58513.0 |
97 | 2020-02-15 06:58:24 | acyclovirs | 1 | 67641 | 2 | 1.360 | 49736.0 |
96 | 2020-02-10 09:05:31 | acyclovirs | 1 | 67641 | 2 | 1.233 | 54858.9 |
95 | 2020-02-09 14:31:07 | acyclovirs | 1 | 67641 | 2 | 2.436 | 27767.2 |
94 | 2020-01-16 18:37:14 | acyclovirs | 1 | 67641 | 2 | 2.453 | 27574.8 |
93 | 2020-01-10 19:42:47 | acyclovirs | 1 | 67641 | 2 | 1.763 | 38367.0 |
92 | 2020-01-07 16:51:58 | acyclovirs | 1 | 67641 | 2 | 1.266 | 53428.9 |
91 | 2019-12-20 21:59:00 | acyclovirs | 1 | 67641 | 2 | 1.076 | 62863.4 |
90 | 2019-09-19 17:47:32 | acyclovirs | 1 | 67641 | 2 | 1.193 | 56698.2 |
89 | 2019-06-04 15:15:42 | acyclovirs | 1 | 67641 | 2 | 1.063 | 63632.2 |
88 | 2019-02-01 06:23:45 | acyclovirs | 1 | 67641 | 2 | 1.146 | 59023.6 |
87 | 2018-11-03 07:16:48 | acyclovirs | 1 | 67641 | 2 | 0.966 | 70021.7 |
86 | 2018-09-20 00:53:34 | acyclovirs | 1 | 67641 | 2 | 1.500 | 45094.0 |
85 | 2018-06-16 04:29:11 | acyclovirs | 1 | 67641 | 2 | 1.100 | 61491.8 |
84 | 2018-03-22 18:26:08 | acyclovirs | 1 | 67641 | 2 | 1.730 | 39098.8 |
83 | 2018-01-03 13:03:43 | acyclovirs | 1 | 67641 | 2 | 1.590 | 42541.5 |
82 | 2017-11-16 23:01:09 | acyclovirs | 1 | 67641 | 2 | 1.643 | 41169.2 |
81 | 2017-11-14 22:43:39 | acyclovirs | 1 | 67641 | 2 | 1.573 | 43001.3 |
80 | 2017-11-08 14:39:05 | acyclovirs | 1 | 67641 | 2 | 2.630 | 25719.0 |
79 | 2017-01-16 21:53:18 | acyclovirs | 1 | 67641 | 2 | 1.406 | 48108.8 |
78 | 2016-12-12 23:05:28 | acyclovirs | 1 | 67641 | 2 | 2.126 | 31816.1 |
77 | 2016-12-01 18:59:15 | acyclovirs | 1 | 67641 | 2 | 1.416 | 47769.1 |
76 | 2016-11-18 07:44:14 | acyclovirs | 1 | 67641 | 2 | 1.786 | 37872.9 |
75 | 2016-11-11 16:43:32 | acyclovirs | 1 | 67641 | 2 | 1.416 | 47769.1 |