History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"truffled"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
212 | 2024-05-06 06:22:34 | truffled | 1 | 82945 | 4 | 1.406 | 58993.6 |
211 | 2024-05-06 03:05:19 | truffled | 3 | 146162 | 149 | 21.080 | 6933.7 |
210 | 2024-05-03 22:50:40 | truffled | 3 | 146162 | 149 | 10.576 | 13820.2 |
209 | 2024-05-03 22:50:44 | truffled | 2 | 121059 | 22 | 4.000 | 30264.8 |
208 | 2024-05-03 21:36:51 | truffled | 1 | 82945 | 4 | 1.486 | 55817.6 |
207 | 2024-05-03 20:58:28 | truffled | 2 | 121059 | 22 | 7.690 | 15742.4 |
206 | 2024-05-03 20:58:24 | truffled | 3 | 146162 | 149 | 7.673 | 19048.9 |
205 | 2024-05-03 20:36:32 | truffled | 1 | 82945 | 4 | 1.440 | 57600.7 |
204 | 2024-04-29 04:00:35 | truffled | 1 | 82945 | 4 | 5.063 | 16382.6 |
203 | 2024-04-27 22:53:47 | truffled | 1 | 82945 | 4 | 3.406 | 24352.6 |
202 | 2024-04-06 15:33:16 | truffled | 2 | 121059 | 22 | 3.800 | 31857.6 |
201 | 2024-04-06 15:33:15 | truffled | 1 | 82945 | 4 | 1.390 | 59672.7 |
200 | 2024-04-06 00:33:25 | truffled | 3 | 146162 | 149 | 16.906 | 8645.6 |
199 | 2024-04-05 15:23:42 | truffled | 3 | 146162 | 149 | 21.720 | 6729.4 |
198 | 2024-04-05 03:22:57 | truffled | 3 | 146162 | 149 | 12.186 | 11994.3 |
197 | 2024-04-03 14:58:14 | truffled | 3 | 146162 | 149 | 18.456 | 7919.5 |
196 | 2024-04-03 14:58:16 | truffled | 2 | 121059 | 22 | 6.736 | 17971.9 |
195 | 2024-04-03 14:58:06 | truffled | 1 | 82945 | 4 | 1.873 | 44284.6 |
194 | 2024-04-03 14:57:53 | truffled | 3 | 146162 | 149 | 8.576 | 17043.1 |
193 | 2024-04-03 14:57:52 | truffled | 2 | 121059 | 22 | 8.330 | 14532.9 |
192 | 2024-04-03 14:57:51 | truffled | 1 | 82945 | 4 | 1.546 | 53651.4 |
191 | 2024-03-29 21:03:16 | truffled | 1 | 82945 | 4 | 2.063 | 40206.0 |
190 | 2024-03-29 00:19:50 | truffled | 1 | 82945 | 4 | 4.940 | 16790.5 |
189 | 2024-03-07 03:21:50 | truffled | 1 | 82945 | 4 | 1.626 | 51011.7 |
188 | 2024-03-01 19:42:57 | truffled | 3 | 146162 | 149 | 18.486 | 7906.6 |
187 | 2024-03-01 06:54:12 | truffled | 2 | 121059 | 22 | 3.330 | 36354.1 |
186 | 2024-03-01 06:54:00 | truffled | 3 | 146162 | 149 | 6.500 | 22486.5 |
185 | 2024-03-01 03:59:11 | truffled | 3 | 146162 | 149 | 12.660 | 11545.2 |
184 | 2024-02-29 18:38:30 | truffled | 1 | 82945 | 4 | 1.423 | 58288.8 |
183 | 2024-02-29 18:38:10 | truffled | 3 | 146162 | 149 | 10.003 | 14611.8 |
182 | 2024-02-29 18:38:12 | truffled | 2 | 121059 | 22 | 3.936 | 30756.9 |
181 | 2024-02-28 11:45:59 | truffled | 1 | 82945 | 4 | 1.626 | 51011.7 |
180 | 2024-02-27 12:25:24 | truffled | 1 | 82945 | 4 | 1.470 | 56425.2 |
179 | 2024-02-08 01:09:31 | truffled | 2 | 121059 | 22 | 8.656 | 13985.6 |
178 | 2024-02-04 09:41:53 | truffled | 3 | 146162 | 149 | 23.406 | 6244.6 |
177 | 2024-01-28 22:08:12 | truffled | 2 | 121059 | 22 | 3.343 | 36212.7 |
176 | 2024-01-28 22:07:43 | truffled | 3 | 146162 | 149 | 7.546 | 19369.5 |
175 | 2024-01-26 17:12:53 | truffled | 2 | 121059 | 22 | 3.173 | 38152.9 |
174 | 2024-01-26 17:12:09 | truffled | 3 | 146162 | 149 | 9.486 | 15408.2 |
173 | 2024-01-16 09:45:38 | truffled | 3 | 146162 | 149 | 7.080 | 20644.4 |
172 | 2024-01-16 09:45:37 | truffled | 2 | 121059 | 22 | 3.640 | 33258.0 |
171 | 2024-01-15 18:00:57 | truffled | 1 | 82945 | 4 | 1.343 | 61761.0 |
170 | 2024-01-12 02:49:04 | truffled | 2 | 121059 | 22 | 3.190 | 37949.5 |
169 | 2023-12-02 19:48:27 | truffled | 3 | 146162 | 149 | 7.483 | 19532.5 |
168 | 2023-12-02 19:48:29 | truffled | 2 | 121059 | 22 | 4.690 | 25812.2 |
167 | 2023-11-21 12:11:35 | truffled | 3 | 146162 | 149 | 6.296 | 23215.1 |
166 | 2023-11-20 16:46:11 | truffled | 1 | 82945 | 4 | 1.436 | 57761.1 |
165 | 2023-11-16 12:39:28 | truffled | 1 | 82945 | 4 | 1.390 | 59672.7 |
164 | 2023-11-11 02:37:58 | truffled | 1 | 82945 | 4 | 1.376 | 60279.8 |
163 | 2023-11-10 15:27:10 | truffled | 1 | 82945 | 4 | 1.250 | 66356.0 |
162 | 2023-11-02 09:06:06 | truffled | 2 | 121059 | 22 | 3.533 | 34265.2 |
161 | 2023-10-31 23:30:54 | truffled | 1 | 82945 | 4 | 2.940 | 28212.6 |
160 | 2023-10-30 23:43:56 | truffled | 2 | 121059 | 22 | 3.486 | 34727.2 |
159 | 2023-10-23 03:25:06 | truffled | 1 | 82945 | 4 | 1.436 | 57761.1 |
158 | 2023-10-20 15:38:03 | truffled | 2 | 121059 | 22 | 3.610 | 33534.3 |
157 | 2023-10-15 12:31:29 | truffled | 1 | 82945 | 4 | 1.266 | 65517.4 |
156 | 2023-09-29 20:24:56 | truffled | 1 | 82945 | 4 | 1.266 | 65517.4 |
155 | 2023-08-30 23:53:29 | truffled | 1 | 82945 | 4 | 1.330 | 62364.7 |
154 | 2023-08-22 20:53:20 | truffled | 3 | 146162 | 149 | 7.373 | 19824.0 |
153 | 2023-07-31 19:42:44 | truffled | 2 | 121059 | 22 | 3.516 | 34430.9 |
152 | 2023-06-04 21:28:31 | truffled | 1 | 82945 | 4 | 1.250 | 66356.0 |
151 | 2023-05-05 15:12:45 | truffled | 3 | 146162 | 149 | 5.936 | 24623.0 |
150 | 2023-04-10 10:07:43 | truffled | 2 | 121059 | 22 | 3.093 | 39139.7 |
149 | 2023-03-29 05:42:17 | truffled | 1 | 82945 | 4 | 1.486 | 55817.6 |
148 | 2023-02-12 07:40:54 | truffled | 3 | 146162 | 149 | 6.003 | 24348.2 |
147 | 2023-01-17 05:53:33 | truffled | 2 | 121059 | 22 | 3.126 | 38726.5 |
146 | 2023-01-12 07:21:13 | truffled | 1 | 82945 | 4 | 1.390 | 59672.7 |
145 | 2022-11-21 18:38:31 | truffled | 3 | 146162 | 149 | 6.106 | 23937.4 |
144 | 2022-10-28 21:28:08 | truffled | 1 | 82945 | 4 | 1.453 | 57085.3 |
143 | 2022-10-27 16:01:24 | truffled | 2 | 121059 | 22 | 3.046 | 39743.6 |
142 | 2022-06-26 14:30:12 | truffled | 3 | 146162 | 149 | 6.186 | 23627.9 |
141 | 2022-06-17 20:35:53 | truffled | 1 | 82945 | 4 | 1.266 | 65517.4 |
140 | 2022-05-25 13:42:05 | truffled | 2 | 121059 | 22 | 3.313 | 36540.6 |
139 | 2022-02-23 04:38:40 | truffled | 1 | 82945 | 4 | 1.403 | 59119.7 |
138 | 2022-02-02 14:05:55 | truffled | 2 | 121059 | 22 | 3.093 | 39139.7 |
137 | 2021-12-12 07:06:25 | truffled | 1 | 82945 | 4 | 1.466 | 56579.1 |
136 | 2021-10-19 11:57:19 | truffled | 1 | 82945 | 4 | 1.283 | 64649.3 |
135 | 2021-09-11 14:27:48 | truffled | 1 | 82945 | 4 | 1.420 | 58412.0 |
134 | 2021-09-09 10:50:19 | truffled | 1 | 82945 | 4 | 1.266 | 65517.4 |
133 | 2021-08-24 23:42:48 | truffled | 1 | 82945 | 4 | 1.233 | 67270.9 |
132 | 2021-03-20 19:30:39 | truffled | 1 | 82945 | 4 | 1.390 | 59672.7 |
131 | 2021-01-02 08:32:12 | truffled | 1 | 82945 | 4 | 1.250 | 66356.0 |
130 | 2020-11-13 12:53:49 | truffled | 1 | 82945 | 4 | 1.390 | 59672.7 |
129 | 2020-10-26 18:25:03 | truffled | 1 | 82945 | 4 | 1.376 | 60279.8 |
128 | 2020-10-26 13:34:27 | truffled | 1 | 82945 | 4 | 1.280 | 64800.8 |
127 | 2020-10-24 18:51:02 | truffled | 1 | 82945 | 4 | 1.296 | 64000.8 |
126 | 2020-09-24 07:30:04 | truffled | 1 | 82945 | 4 | 1.376 | 60279.8 |
125 | 2020-07-10 11:47:04 | truffled | 1 | 82945 | 4 | 1.376 | 60279.8 |
124 | 2020-04-14 22:46:54 | truffled | 1 | 82945 | 4 | 1.310 | 63316.8 |
123 | 2020-03-27 01:04:49 | truffled | 1 | 82945 | 4 | 1.453 | 57085.3 |
122 | 2020-03-23 10:42:04 | truffled | 1 | 82945 | 4 | 1.530 | 54212.4 |
121 | 2020-02-26 12:09:59 | truffled | 1 | 82945 | 4 | 1.640 | 50576.2 |
120 | 2020-02-23 06:07:57 | truffled | 1 | 82945 | 4 | 1.516 | 54713.1 |
119 | 2020-02-23 05:07:27 | truffled | 1 | 82945 | 4 | 2.873 | 28870.5 |
118 | 2020-02-22 16:56:09 | truffled | 1 | 82945 | 4 | 3.140 | 26415.6 |
117 | 2020-02-12 19:07:44 | truffled | 1 | 82945 | 4 | 1.640 | 50576.2 |
116 | 2020-02-05 21:31:35 | truffled | 1 | 82945 | 4 | 3.720 | 22297.0 |
115 | 2020-02-04 01:31:52 | truffled | 1 | 82945 | 4 | 1.810 | 45826.0 |
114 | 2020-01-30 23:57:20 | truffled | 1 | 82945 | 4 | 1.530 | 54212.4 |
113 | 2020-01-26 20:05:09 | truffled | 1 | 82945 | 4 | 1.813 | 45750.1 |