History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"treatment"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
212 | 2024-05-29 06:26:46 | treatment | 3 | 148641 | 42 | 17.500 | 8493.8 |
211 | 2024-05-18 00:26:48 | treatment | 3 | 148641 | 42 | 15.330 | 9696.1 |
210 | 2024-05-15 15:29:35 | treatment | 2 | 121436 | 3 | 11.660 | 10414.8 |
209 | 2024-05-15 15:12:37 | treatment | 1 | 81242 | 2 | 1.453 | 55913.3 |
208 | 2024-05-14 08:10:53 | treatment | 1 | 81242 | 2 | 3.000 | 27080.7 |
207 | 2024-05-14 01:23:37 | treatment | 1 | 81242 | 2 | 2.686 | 30246.5 |
206 | 2024-05-13 07:28:10 | treatment | 3 | 148641 | 42 | 27.160 | 5472.8 |
205 | 2024-05-03 11:27:16 | treatment | 2 | 121436 | 3 | 8.343 | 14555.4 |
204 | 2024-05-03 11:27:02 | treatment | 4 | 165329 | 421 | 18.690 | 8845.9 |
203 | 2024-05-03 11:27:03 | treatment | 3 | 148641 | 42 | 9.156 | 16234.3 |
202 | 2024-05-03 05:37:26 | treatment | 1 | 81242 | 2 | 3.893 | 20868.7 |
201 | 2024-04-26 06:28:56 | treatment | 1 | 81242 | 2 | 1.423 | 57092.1 |
200 | 2024-04-25 05:24:05 | treatment | 1 | 81242 | 2 | 1.593 | 50999.4 |
199 | 2024-04-17 12:55:08 | treatment | 2 | 121436 | 3 | 3.313 | 36654.4 |
198 | 2024-04-11 20:36:16 | treatment | 3 | 148641 | 42 | 26.613 | 5585.3 |
197 | 2024-04-10 00:29:52 | treatment | 1 | 81242 | 2 | 1.233 | 65889.7 |
196 | 2024-04-06 18:43:31 | treatment | 1 | 81242 | 2 | 3.390 | 23965.2 |
195 | 2024-04-02 19:03:30 | treatment | 4 | 165329 | 421 | 42.690 | 3872.8 |
194 | 2024-04-01 17:54:13 | treatment | 3 | 148641 | 42 | 25.206 | 5897.0 |
193 | 2024-04-01 17:44:30 | treatment | 2 | 121436 | 3 | 13.236 | 9174.7 |
192 | 2024-04-01 14:58:36 | treatment | 1 | 81242 | 2 | 3.033 | 26786.0 |
191 | 2024-04-01 12:20:08 | treatment | 4 | 165329 | 421 | 31.406 | 5264.2 |
190 | 2024-04-01 12:20:08 | treatment | 3 | 148641 | 42 | 18.236 | 8151.0 |
189 | 2024-04-01 12:20:06 | treatment | 2 | 121436 | 3 | 10.706 | 11342.8 |
188 | 2024-04-01 12:13:57 | treatment | 1 | 81242 | 2 | 1.453 | 55913.3 |
187 | 2024-03-23 08:21:14 | treatment | 1 | 81242 | 2 | 4.453 | 18244.3 |
186 | 2024-03-01 17:03:26 | treatment | 1 | 81242 | 2 | 1.533 | 52995.4 |
185 | 2024-03-01 07:14:11 | treatment | 1 | 81242 | 2 | 1.453 | 55913.3 |
184 | 2024-02-27 19:18:20 | treatment | 1 | 81242 | 2 | 1.280 | 63470.3 |
183 | 2024-02-07 10:21:54 | treatment | 1 | 81242 | 2 | 1.360 | 59736.8 |
182 | 2024-02-04 22:19:00 | treatment | 1 | 81242 | 2 | 2.110 | 38503.3 |
181 | 2024-01-30 05:38:13 | treatment | 1 | 81242 | 2 | 1.406 | 57782.4 |
180 | 2023-12-26 04:35:11 | treatment | 1 | 81242 | 2 | 1.266 | 64172.2 |
179 | 2023-12-25 18:19:11 | treatment | 1 | 81242 | 2 | 1.266 | 64172.2 |
178 | 2023-12-17 16:09:13 | treatment | 4 | 165329 | 421 | 11.843 | 13960.1 |
177 | 2023-12-15 03:12:10 | treatment | 1 | 81242 | 2 | 1.360 | 59736.8 |
176 | 2023-12-12 11:10:17 | treatment | 1 | 81242 | 2 | 1.360 | 59736.8 |
175 | 2023-12-07 06:20:30 | treatment | 2 | 121436 | 3 | 4.970 | 24433.8 |
174 | 2023-10-28 21:47:14 | treatment | 4 | 165329 | 421 | 31.110 | 5314.3 |
173 | 2023-10-20 22:14:54 | treatment | 4 | 165329 | 421 | 12.580 | 13142.2 |
172 | 2023-10-20 22:14:59 | treatment | 2 | 121436 | 3 | 3.690 | 32909.5 |
171 | 2023-10-20 22:14:53 | treatment | 3 | 148641 | 42 | 7.393 | 20105.6 |
170 | 2023-10-19 15:08:24 | treatment | 1 | 81242 | 2 | 1.313 | 61875.1 |
169 | 2023-10-12 06:23:04 | treatment | 1 | 81242 | 2 | 1.360 | 59736.8 |
168 | 2023-09-05 19:10:36 | treatment | 2 | 121436 | 3 | 3.360 | 36141.7 |
167 | 2023-08-06 17:12:52 | treatment | 1 | 81242 | 2 | 1.233 | 65889.7 |
166 | 2023-05-25 09:20:43 | treatment | 2 | 121436 | 3 | 3.156 | 38477.8 |
165 | 2023-05-04 14:05:07 | treatment | 1 | 81242 | 2 | 1.203 | 67532.8 |
164 | 2023-03-06 14:04:03 | treatment | 2 | 121436 | 3 | 3.093 | 39261.6 |
163 | 2023-02-26 15:22:36 | treatment | 1 | 81242 | 2 | 1.216 | 66810.9 |
162 | 2022-12-23 09:18:36 | treatment | 1 | 81242 | 2 | 1.233 | 65889.7 |
161 | 2022-12-11 22:48:08 | treatment | 2 | 121436 | 3 | 3.076 | 39478.5 |
160 | 2022-09-11 07:17:04 | treatment | 1 | 81242 | 2 | 1.216 | 66810.9 |
159 | 2022-09-09 04:51:10 | treatment | 1 | 81242 | 2 | 1.263 | 64324.6 |
158 | 2022-07-29 09:58:27 | treatment | 2 | 121436 | 3 | 3.266 | 37181.9 |
157 | 2022-07-02 22:53:10 | treatment | 3 | 148641 | 42 | 6.546 | 22707.1 |
156 | 2022-04-18 05:10:02 | treatment | 1 | 81242 | 2 | 1.233 | 65889.7 |
155 | 2022-04-16 03:21:44 | treatment | 1 | 81242 | 2 | 1.360 | 59736.8 |
154 | 2022-01-11 19:42:39 | treatment | 1 | 81242 | 2 | 1.310 | 62016.8 |
153 | 2022-01-09 15:37:15 | treatment | 1 | 81242 | 2 | 1.686 | 48186.2 |
152 | 2021-12-16 01:35:11 | treatment | 1 | 81242 | 2 | 1.376 | 59042.2 |
151 | 2021-11-26 10:57:43 | treatment | 1 | 81242 | 2 | 1.376 | 59042.2 |
150 | 2021-11-24 07:48:04 | treatment | 1 | 81242 | 2 | 1.233 | 65889.7 |
149 | 2021-07-03 22:11:41 | treatment | 2 | 121436 | 3 | 3.766 | 32245.4 |
148 | 2021-04-29 13:31:03 | treatment | 1 | 81242 | 2 | 2.763 | 29403.5 |
147 | 2021-02-07 02:50:34 | treatment | 1 | 81242 | 2 | 1.266 | 64172.2 |
146 | 2021-01-12 20:26:23 | treatment | 1 | 81242 | 2 | 1.376 | 59042.2 |
145 | 2020-10-27 08:24:33 | treatment | 1 | 81242 | 2 | 1.280 | 63470.3 |
144 | 2020-10-26 06:05:59 | treatment | 1 | 81242 | 2 | 1.236 | 65729.8 |
143 | 2020-10-02 04:46:14 | treatment | 1 | 81242 | 2 | 1.343 | 60492.9 |
142 | 2020-09-30 08:38:17 | treatment | 1 | 81242 | 2 | 1.216 | 66810.9 |
141 | 2020-07-27 14:59:16 | treatment | 1 | 81242 | 2 | 1.296 | 62686.7 |
140 | 2020-07-18 23:23:32 | treatment | 1 | 81242 | 2 | 1.313 | 61875.1 |
139 | 2020-03-22 11:40:38 | treatment | 1 | 81242 | 2 | 1.440 | 56418.1 |
138 | 2020-03-18 18:18:58 | treatment | 1 | 81242 | 2 | 1.283 | 63321.9 |
137 | 2020-03-15 23:25:53 | treatment | 1 | 81242 | 2 | 1.500 | 54161.3 |
136 | 2020-03-13 21:58:17 | treatment | 1 | 81242 | 2 | 1.486 | 54671.6 |
135 | 2020-02-28 19:28:24 | treatment | 1 | 81242 | 2 | 1.563 | 51978.2 |
134 | 2020-02-27 07:17:27 | treatment | 1 | 81242 | 2 | 2.486 | 32679.8 |
133 | 2020-02-24 08:35:17 | treatment | 1 | 81242 | 2 | 2.826 | 28748.1 |
132 | 2020-02-13 21:47:51 | treatment | 1 | 81242 | 2 | 1.406 | 57782.4 |
131 | 2020-02-04 16:38:35 | treatment | 3 | 148641 | 42 | 7.846 | 18944.8 |
130 | 2020-02-04 16:37:40 | treatment | 2 | 121436 | 3 | 3.643 | 33334.1 |
129 | 2020-02-04 13:00:19 | treatment | 1 | 81242 | 2 | 2.703 | 30056.2 |
128 | 2020-01-31 05:42:24 | treatment | 1 | 81242 | 2 | 2.893 | 28082.3 |
127 | 2020-01-27 19:41:41 | treatment | 1 | 81242 | 2 | 3.093 | 26266.4 |
126 | 2020-01-26 20:58:48 | treatment | 1 | 81242 | 2 | 1.453 | 55913.3 |
125 | 2020-01-18 01:39:20 | treatment | 1 | 81242 | 2 | 1.563 | 51978.2 |
124 | 2020-01-14 22:14:09 | treatment | 1 | 81242 | 2 | 1.420 | 57212.7 |
123 | 2020-01-03 06:00:56 | treatment | 1 | 81242 | 2 | 1.563 | 51978.2 |
122 | 2019-12-31 08:33:54 | treatment | 1 | 81242 | 2 | 1.403 | 57905.9 |
121 | 2019-12-04 11:20:47 | treatment | 1 | 81242 | 2 | 1.216 | 66810.9 |
120 | 2019-09-11 19:33:20 | treatment | 1 | 81242 | 2 | 1.160 | 70036.2 |
119 | 2019-09-02 05:34:55 | treatment | 1 | 81242 | 2 | 1.270 | 63970.1 |
118 | 2019-08-25 03:01:50 | treatment | 1 | 81242 | 2 | 1.170 | 69437.6 |
117 | 2019-08-21 05:07:10 | treatment | 1 | 81242 | 2 | 1.163 | 69855.5 |
116 | 2019-08-18 05:03:05 | treatment | 1 | 81242 | 2 | 1.173 | 69260.0 |
115 | 2019-08-13 13:59:27 | treatment | 1 | 81242 | 2 | 1.143 | 71077.9 |
114 | 2019-07-28 11:46:37 | treatment | 1 | 81242 | 2 | 1.230 | 66050.4 |
113 | 2019-06-04 09:57:52 | treatment | 1 | 81242 | 2 | 1.313 | 61875.1 |