History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lavender"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
214 | 2024-04-20 07:43:27 | lavender | 2 | 121059 | 14 | 3.330 | 36354.1 |
213 | 2024-04-20 07:43:12 | lavender | 3 | 146162 | 131 | 8.220 | 17781.3 |
212 | 2024-04-19 00:15:11 | lavender | 3 | 146162 | 131 | 12.156 | 12023.9 |
211 | 2024-04-19 00:15:11 | lavender | 2 | 121059 | 14 | 9.280 | 13045.2 |
210 | 2024-04-18 20:40:44 | lavender | 1 | 82945 | 2 | 1.313 | 63172.1 |
209 | 2024-04-06 17:13:44 | lavender | 1 | 82945 | 2 | 5.720 | 14500.9 |
208 | 2024-03-29 03:22:43 | lavender | 2 | 121059 | 14 | 6.420 | 18856.5 |
207 | 2024-03-29 03:22:41 | lavender | 1 | 82945 | 2 | 1.470 | 56425.2 |
206 | 2024-03-27 11:43:05 | lavender | 1 | 82945 | 2 | 1.500 | 55296.7 |
205 | 2024-03-25 15:05:15 | lavender | 3 | 146162 | 131 | 7.546 | 19369.5 |
204 | 2024-03-25 15:05:03 | lavender | 2 | 121059 | 14 | 3.563 | 33976.7 |
203 | 2024-03-23 12:58:12 | lavender | 2 | 121059 | 14 | 3.283 | 36874.5 |
202 | 2024-03-18 21:42:10 | lavender | 3 | 146162 | 131 | 11.030 | 13251.3 |
201 | 2024-03-18 06:17:31 | lavender | 2 | 121059 | 14 | 3.610 | 33534.3 |
200 | 2024-03-18 06:17:19 | lavender | 3 | 146162 | 131 | 8.000 | 18270.3 |
199 | 2024-03-18 00:14:09 | lavender | 3 | 146162 | 131 | 10.750 | 13596.5 |
198 | 2024-03-18 00:14:12 | lavender | 2 | 121059 | 14 | 4.483 | 27004.0 |
197 | 2024-03-17 17:32:30 | lavender | 2 | 121059 | 14 | 3.796 | 31891.2 |
196 | 2024-03-17 17:32:30 | lavender | 1 | 82945 | 2 | 1.500 | 55296.7 |
195 | 2024-03-17 17:32:15 | lavender | 3 | 146162 | 131 | 7.640 | 19131.2 |
194 | 2024-03-16 19:00:38 | lavender | 3 | 146162 | 131 | 13.766 | 10617.6 |
193 | 2024-03-16 19:00:40 | lavender | 2 | 121059 | 14 | 8.983 | 13476.5 |
192 | 2024-03-16 18:56:50 | lavender | 1 | 82945 | 2 | 1.640 | 50576.2 |
191 | 2024-02-26 05:34:22 | lavender | 1 | 82945 | 2 | 4.733 | 17524.8 |
190 | 2024-02-26 03:39:53 | lavender | 1 | 82945 | 2 | 3.063 | 27079.7 |
189 | 2024-02-07 09:02:11 | lavender | 2 | 121059 | 14 | 4.653 | 26017.4 |
188 | 2024-02-07 09:01:59 | lavender | 3 | 146162 | 131 | 8.110 | 18022.4 |
187 | 2024-01-31 23:00:24 | lavender | 2 | 121059 | 14 | 3.720 | 32542.7 |
186 | 2024-01-31 23:00:12 | lavender | 3 | 146162 | 131 | 8.186 | 17855.1 |
185 | 2024-01-31 22:59:36 | lavender | 3 | 146162 | 131 | 8.093 | 18060.3 |
184 | 2024-01-31 22:59:39 | lavender | 1 | 82945 | 2 | 1.596 | 51970.6 |
183 | 2024-01-31 22:59:32 | lavender | 2 | 121059 | 14 | 3.780 | 32026.2 |
182 | 2024-01-30 01:53:53 | lavender | 1 | 82945 | 2 | 1.456 | 56967.7 |
181 | 2023-12-14 04:01:48 | lavender | 1 | 82945 | 2 | 1.296 | 64000.8 |
180 | 2023-12-02 01:17:28 | lavender | 2 | 121059 | 14 | 3.576 | 33853.2 |
179 | 2023-11-24 02:27:40 | lavender | 1 | 82945 | 2 | 1.280 | 64800.8 |
178 | 2023-11-09 11:42:42 | lavender | 1 | 82945 | 2 | 1.313 | 63172.1 |
177 | 2023-09-16 08:55:05 | lavender | 1 | 82945 | 2 | 1.250 | 66356.0 |
176 | 2023-09-08 16:57:58 | lavender | 1 | 82945 | 2 | 1.280 | 64800.8 |
175 | 2023-08-29 13:16:31 | lavender | 2 | 121059 | 14 | 3.280 | 36908.2 |
174 | 2023-07-03 07:17:47 | lavender | 1 | 82945 | 2 | 1.483 | 55930.5 |
173 | 2023-06-13 18:33:59 | lavender | 1 | 82945 | 2 | 1.393 | 59544.1 |
172 | 2023-05-14 20:36:20 | lavender | 2 | 121059 | 14 | 3.250 | 37248.9 |
171 | 2023-03-30 19:27:46 | lavender | 1 | 82945 | 2 | 1.236 | 67107.6 |
170 | 2023-03-06 21:05:59 | lavender | 1 | 82945 | 2 | 1.420 | 58412.0 |
169 | 2023-02-20 18:53:35 | lavender | 2 | 121059 | 14 | 3.250 | 37248.9 |
168 | 2023-01-13 08:44:08 | lavender | 1 | 82945 | 2 | 1.250 | 66356.0 |
167 | 2022-12-02 15:25:35 | lavender | 2 | 121059 | 14 | 3.060 | 39561.8 |
166 | 2022-10-31 05:01:40 | lavender | 1 | 82945 | 2 | 1.216 | 68211.3 |
165 | 2022-10-28 01:14:23 | lavender | 1 | 82945 | 2 | 1.393 | 59544.1 |
164 | 2022-07-10 17:09:56 | lavender | 2 | 121059 | 14 | 3.110 | 38925.7 |
163 | 2022-07-08 11:30:46 | lavender | 2 | 121059 | 14 | 3.140 | 38553.8 |
162 | 2022-06-23 04:54:13 | lavender | 1 | 82945 | 2 | 1.236 | 67107.6 |
161 | 2022-06-07 15:28:14 | lavender | 1 | 82945 | 2 | 1.280 | 64800.8 |
160 | 2022-05-16 11:04:25 | lavender | 1 | 82945 | 2 | 1.623 | 51106.0 |
159 | 2022-03-02 11:13:10 | lavender | 2 | 121059 | 14 | 4.280 | 28284.8 |
158 | 2022-02-17 09:16:27 | lavender | 1 | 82945 | 2 | 1.280 | 64800.8 |
157 | 2022-02-15 05:44:53 | lavender | 1 | 82945 | 2 | 1.326 | 62552.8 |
156 | 2022-02-11 03:38:19 | lavender | 1 | 82945 | 2 | 1.420 | 58412.0 |
155 | 2022-02-07 17:05:22 | lavender | 1 | 82945 | 2 | 1.250 | 66356.0 |
154 | 2021-10-14 18:26:43 | lavender | 1 | 82945 | 2 | 1.546 | 53651.4 |
153 | 2021-07-09 23:38:02 | lavender | 1 | 82945 | 2 | 1.453 | 57085.3 |
152 | 2021-06-04 01:02:05 | lavender | 1 | 82945 | 2 | 1.470 | 56425.2 |
151 | 2021-05-09 19:17:46 | lavender | 1 | 82945 | 2 | 1.610 | 51518.6 |
150 | 2021-04-08 09:44:32 | lavender | 1 | 82945 | 2 | 1.330 | 62364.7 |
149 | 2021-04-06 03:16:30 | lavender | 1 | 82945 | 2 | 1.266 | 65517.4 |
148 | 2021-04-01 23:32:21 | lavender | 1 | 82945 | 2 | 1.406 | 58993.6 |
147 | 2021-03-12 15:57:42 | lavender | 1 | 82945 | 2 | 1.330 | 62364.7 |
146 | 2021-01-23 08:41:39 | lavender | 1 | 82945 | 2 | 1.296 | 64000.8 |
145 | 2020-12-24 18:45:53 | lavender | 1 | 82945 | 2 | 1.296 | 64000.8 |
144 | 2020-12-21 00:56:18 | lavender | 1 | 82945 | 2 | 1.486 | 55817.6 |
143 | 2020-11-20 21:13:29 | lavender | 1 | 82945 | 2 | 1.310 | 63316.8 |
142 | 2020-11-04 12:50:10 | lavender | 1 | 82945 | 2 | 1.390 | 59672.7 |
141 | 2020-10-27 01:44:55 | lavender | 1 | 82945 | 2 | 1.530 | 54212.4 |
140 | 2020-10-16 18:35:40 | lavender | 1 | 82945 | 2 | 1.283 | 64649.3 |
139 | 2020-09-17 01:51:43 | lavender | 1 | 82945 | 2 | 1.233 | 67270.9 |
138 | 2020-05-26 06:21:50 | lavender | 1 | 82945 | 2 | 1.280 | 64800.8 |
137 | 2020-03-24 23:11:19 | lavender | 1 | 82945 | 2 | 1.843 | 45005.4 |
136 | 2020-02-25 21:29:19 | lavender | 1 | 82945 | 2 | 1.716 | 48336.2 |
135 | 2020-02-23 20:14:04 | lavender | 1 | 82945 | 2 | 4.560 | 18189.7 |
134 | 2020-02-21 15:26:48 | lavender | 1 | 82945 | 2 | 1.580 | 52496.8 |
133 | 2020-02-14 05:07:47 | lavender | 1 | 82945 | 2 | 1.483 | 55930.5 |
132 | 2020-02-11 21:16:40 | lavender | 3 | 146162 | 131 | 8.343 | 17519.1 |
131 | 2020-02-11 10:37:04 | lavender | 3 | 146162 | 131 | 15.593 | 9373.6 |
130 | 2020-02-09 23:38:05 | lavender | 1 | 82945 | 2 | 1.670 | 49667.7 |
129 | 2020-02-08 23:29:12 | lavender | 3 | 146162 | 131 | 11.706 | 12486.1 |
128 | 2020-02-07 18:06:04 | lavender | 3 | 146162 | 131 | 8.780 | 16647.2 |
127 | 2020-02-03 16:08:58 | lavender | 1 | 82945 | 2 | 1.670 | 49667.7 |
126 | 2020-01-27 18:56:41 | lavender | 3 | 146162 | 131 | 24.143 | 6054.0 |
125 | 2020-01-25 17:03:26 | lavender | 1 | 82945 | 2 | 2.280 | 36379.4 |
124 | 2020-01-24 22:32:03 | lavender | 1 | 82945 | 2 | 1.563 | 53067.8 |
123 | 2020-01-24 08:44:01 | lavender | 1 | 82945 | 2 | 1.330 | 62364.7 |
122 | 2020-01-20 15:28:18 | lavender | 2 | 121059 | 14 | 5.110 | 23690.6 |
121 | 2020-01-20 15:27:37 | lavender | 3 | 146162 | 131 | 12.640 | 11563.4 |
120 | 2020-01-20 12:55:24 | lavender | 1 | 82945 | 2 | 3.296 | 25165.4 |
119 | 2020-01-15 07:23:52 | lavender | 1 | 82945 | 2 | 3.453 | 24021.1 |
118 | 2020-01-02 11:18:59 | lavender | 1 | 82945 | 2 | 3.156 | 26281.7 |
117 | 2020-01-01 22:11:52 | lavender | 1 | 82945 | 2 | 2.296 | 36125.9 |
116 | 2019-11-14 06:11:31 | lavender | 1 | 82945 | 2 | 1.360 | 60989.0 |
115 | 2019-08-12 21:48:37 | lavender | 1 | 82945 | 2 | 1.320 | 62837.1 |