History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"operatives"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
210 | 2024-04-27 19:22:46 | operatives | 1 | 67641 | 2 | 1.110 | 60937.8 |
209 | 2024-04-02 19:10:37 | operatives | 1 | 67641 | 2 | 4.126 | 16393.8 |
208 | 2024-03-30 07:56:41 | operatives | 1 | 67641 | 2 | 2.390 | 28301.7 |
207 | 2024-03-11 01:08:45 | operatives | 1 | 67641 | 2 | 1.236 | 54725.7 |
206 | 2024-03-01 03:43:07 | operatives | 1 | 67641 | 2 | 1.186 | 57032.9 |
205 | 2024-02-07 10:56:14 | operatives | 1 | 67641 | 2 | 1.233 | 54858.9 |
204 | 2024-02-05 10:41:22 | operatives | 1 | 67641 | 2 | 1.140 | 59334.2 |
203 | 2024-01-30 06:51:19 | operatives | 1 | 67641 | 2 | 1.106 | 61158.2 |
202 | 2024-01-14 01:57:20 | operatives | 1 | 67641 | 2 | 1.143 | 59178.5 |
201 | 2023-12-11 07:04:24 | operatives | 1 | 67641 | 2 | 1.123 | 60232.4 |
200 | 2023-11-22 07:29:19 | operatives | 1 | 67641 | 2 | 1.013 | 66773.0 |
199 | 2023-10-28 08:01:07 | operatives | 1 | 67641 | 2 | 1.310 | 51634.4 |
198 | 2023-09-27 10:47:37 | operatives | 1 | 67641 | 2 | 1.000 | 67641.0 |
197 | 2023-09-27 01:51:33 | operatives | 1 | 67641 | 2 | 1.140 | 59334.2 |
196 | 2023-09-10 22:43:51 | operatives | 1 | 67641 | 2 | 1.156 | 58513.0 |
195 | 2023-05-18 06:21:25 | operatives | 1 | 67641 | 2 | 1.060 | 63812.3 |
194 | 2023-01-25 08:29:24 | operatives | 1 | 67641 | 2 | 1.000 | 67641.0 |
193 | 2023-01-21 16:31:49 | operatives | 1 | 67641 | 2 | 1.093 | 61885.6 |
192 | 2022-10-17 09:06:36 | operatives | 1 | 67641 | 2 | 1.096 | 61716.2 |
191 | 2022-09-26 14:48:02 | operatives | 1 | 67641 | 2 | 1.030 | 65670.9 |
190 | 2022-06-07 03:56:01 | operatives | 1 | 67641 | 2 | 1.033 | 65480.2 |
189 | 2022-05-30 11:20:22 | operatives | 1 | 67641 | 2 | 0.983 | 68810.8 |
188 | 2022-05-27 06:17:29 | operatives | 1 | 67641 | 2 | 1.140 | 59334.2 |
187 | 2022-02-17 00:02:32 | operatives | 1 | 67641 | 2 | 1.110 | 60937.8 |
186 | 2022-02-01 18:31:41 | operatives | 1 | 67641 | 2 | 2.220 | 30468.9 |
185 | 2021-12-25 08:02:11 | operatives | 1 | 67641 | 2 | 1.013 | 66773.0 |
184 | 2021-12-25 05:41:34 | operatives | 1 | 67641 | 2 | 1.173 | 57665.0 |
183 | 2021-12-06 06:48:02 | operatives | 1 | 67641 | 2 | 1.110 | 60937.8 |
182 | 2021-12-04 05:41:36 | operatives | 1 | 67641 | 2 | 1.000 | 67641.0 |
181 | 2021-10-25 11:17:52 | operatives | 1 | 67641 | 2 | 1.093 | 61885.6 |
180 | 2021-07-18 10:31:38 | operatives | 1 | 67641 | 2 | 0.983 | 68810.8 |
179 | 2021-05-16 06:05:11 | operatives | 3 | 140603 | 43 | 6.343 | 22166.6 |
178 | 2021-05-03 23:33:18 | operatives | 2 | 108824 | 9 | 2.843 | 38277.9 |
177 | 2021-05-02 23:15:36 | operatives | 1 | 67641 | 2 | 1.686 | 40119.2 |
176 | 2021-04-15 17:03:20 | operatives | 1 | 67641 | 2 | 1.563 | 43276.4 |
175 | 2021-04-11 21:00:46 | operatives | 1 | 67641 | 2 | 1.123 | 60232.4 |
174 | 2021-04-02 02:29:28 | operatives | 2 | 108824 | 9 | 3.173 | 34296.9 |
173 | 2021-02-21 10:51:38 | operatives | 1 | 67641 | 2 | 1.110 | 60937.8 |
172 | 2021-01-28 21:59:18 | operatives | 3 | 140603 | 43 | 6.503 | 21621.3 |
171 | 2021-01-17 04:07:26 | operatives | 2 | 108824 | 9 | 3.033 | 35880.0 |
170 | 2020-12-31 06:17:16 | operatives | 3 | 140603 | 43 | 5.576 | 25215.7 |
169 | 2020-12-25 21:29:52 | operatives | 1 | 67641 | 2 | 0.983 | 68810.8 |
168 | 2020-11-22 12:07:14 | operatives | 2 | 108824 | 9 | 2.720 | 40008.8 |
167 | 2020-10-28 19:38:29 | operatives | 1 | 67641 | 2 | 1.186 | 57032.9 |
166 | 2020-10-28 12:50:12 | operatives | 2 | 108824 | 9 | 2.956 | 36814.6 |
165 | 2020-10-26 03:23:06 | operatives | 1 | 67641 | 2 | 1.140 | 59334.2 |
164 | 2020-10-25 03:32:21 | operatives | 1 | 67641 | 2 | 1.076 | 62863.4 |
163 | 2020-10-16 16:49:59 | operatives | 3 | 140603 | 43 | 5.720 | 24580.9 |
162 | 2020-09-18 06:16:55 | operatives | 1 | 67641 | 2 | 1.030 | 65670.9 |
161 | 2020-06-08 07:11:26 | operatives | 1 | 67641 | 2 | 1.046 | 64666.3 |
160 | 2020-04-09 05:40:59 | operatives | 1 | 67641 | 2 | 1.033 | 65480.2 |
159 | 2020-04-02 01:34:41 | operatives | 1 | 67641 | 2 | 1.076 | 62863.4 |
158 | 2020-03-27 22:44:22 | operatives | 1 | 67641 | 2 | 1.000 | 67641.0 |
157 | 2020-03-23 11:07:34 | operatives | 1 | 67641 | 2 | 1.140 | 59334.2 |
156 | 2020-03-06 18:38:26 | operatives | 1 | 67641 | 2 | 1.110 | 60937.8 |
155 | 2020-02-29 21:25:38 | operatives | 4 | 161450 | 336 | 23.670 | 6820.9 |
154 | 2020-02-27 00:02:19 | operatives | 4 | 161450 | 336 | 13.360 | 12084.6 |
153 | 2020-02-26 21:40:37 | operatives | 4 | 161450 | 336 | 30.613 | 5273.9 |
152 | 2020-02-25 19:49:17 | operatives | 1 | 67641 | 2 | 1.170 | 57812.8 |
151 | 2020-02-23 19:12:05 | operatives | 4 | 161450 | 336 | 14.233 | 11343.4 |
150 | 2020-02-23 17:41:44 | operatives | 1 | 67641 | 2 | 1.250 | 54112.8 |
149 | 2020-02-21 01:01:47 | operatives | 4 | 161450 | 336 | 23.283 | 6934.2 |
148 | 2020-02-18 21:05:31 | operatives | 1 | 67641 | 2 | 2.530 | 26735.6 |
147 | 2020-02-12 13:46:18 | operatives | 1 | 67641 | 2 | 3.703 | 18266.5 |
146 | 2020-02-05 03:55:59 | operatives | 1 | 67641 | 2 | 1.216 | 55625.8 |
145 | 2020-02-05 01:41:41 | operatives | 1 | 67641 | 2 | 1.220 | 55443.4 |
144 | 2020-02-01 18:43:50 | operatives | 1 | 67641 | 2 | 1.000 | 67641.0 |
143 | 2020-01-30 14:55:08 | operatives | 1 | 67641 | 2 | 2.546 | 26567.6 |
142 | 2020-01-24 18:26:32 | operatives | 4 | 161450 | 336 | 22.613 | 7139.7 |
141 | 2020-01-24 13:37:01 | operatives | 4 | 161450 | 336 | 40.643 | 3972.4 |
140 | 2020-01-24 06:18:29 | operatives | 4 | 161450 | 336 | 27.016 | 5976.1 |
139 | 2020-01-24 06:18:22 | operatives | 3 | 140603 | 43 | 7.500 | 18747.1 |
138 | 2020-01-24 06:18:04 | operatives | 2 | 108824 | 9 | 4.953 | 21971.3 |
137 | 2020-01-24 04:12:08 | operatives | 1 | 67641 | 2 | 1.156 | 58513.0 |
136 | 2020-01-24 00:59:33 | operatives | 1 | 67641 | 2 | 1.873 | 36113.7 |
135 | 2020-01-16 07:13:55 | operatives | 1 | 67641 | 2 | 3.860 | 17523.6 |
134 | 2020-01-16 05:56:40 | operatives | 1 | 67641 | 2 | 1.220 | 55443.4 |
133 | 2020-01-14 05:06:38 | operatives | 1 | 67641 | 2 | 1.173 | 57665.0 |
132 | 2020-01-02 17:52:41 | operatives | 1 | 67641 | 2 | 1.126 | 60071.9 |
131 | 2019-12-31 00:57:37 | operatives | 1 | 67641 | 2 | 1.033 | 65480.2 |
130 | 2019-12-18 19:12:34 | operatives | 1 | 67641 | 2 | 1.013 | 66773.0 |
129 | 2019-11-30 22:17:01 | operatives | 1 | 67641 | 2 | 1.000 | 67641.0 |
128 | 2019-11-07 03:43:39 | operatives | 1 | 67641 | 2 | 1.030 | 65670.9 |
127 | 2019-11-01 08:42:11 | operatives | 1 | 67641 | 2 | 1.156 | 58513.0 |
126 | 2019-09-26 06:20:53 | operatives | 1 | 67641 | 2 | 0.916 | 73843.9 |
125 | 2019-09-01 13:09:29 | operatives | 1 | 67641 | 2 | 1.106 | 61158.2 |
124 | 2019-06-09 18:38:53 | operatives | 1 | 67641 | 2 | 1.033 | 65480.2 |
123 | 2019-06-01 21:33:29 | operatives | 1 | 67641 | 2 | 1.093 | 61885.6 |
122 | 2019-04-01 08:02:04 | operatives | 1 | 67641 | 2 | 1.016 | 66575.8 |
121 | 2019-02-23 15:42:02 | operatives | 1 | 67641 | 2 | 1.086 | 62284.5 |
120 | 2018-12-04 10:48:13 | operatives | 1 | 67641 | 2 | 0.956 | 70754.2 |
119 | 2018-12-02 13:02:13 | operatives | 1 | 67641 | 2 | 0.966 | 70021.7 |
118 | 2018-11-12 22:54:12 | operatives | 1 | 67641 | 2 | 1.020 | 66314.7 |
117 | 2018-08-12 02:32:19 | operatives | 1 | 67641 | 2 | 1.086 | 62284.5 |
116 | 2018-06-24 11:43:23 | operatives | 1 | 67641 | 2 | 2.236 | 30250.9 |
115 | 2018-06-16 03:55:01 | operatives | 1 | 67641 | 2 | 1.160 | 58311.2 |
114 | 2018-05-13 15:11:44 | operatives | 1 | 67641 | 2 | 1.033 | 65480.2 |
113 | 2018-03-24 00:04:50 | operatives | 1 | 67641 | 2 | 1.380 | 49015.2 |
112 | 2018-03-09 10:14:42 | operatives | 1 | 67641 | 2 | 1.570 | 43083.4 |
111 | 2018-03-09 10:09:41 | operatives | 1 | 67641 | 2 | 1.960 | 34510.7 |