History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opaques"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
201 | 2024-05-04 20:23:32 | opaques | 1 | 69583 | 5 | 1.343 | 51811.6 |
200 | 2024-04-30 21:47:46 | opaques | 3 | 134027 | 118 | 13.860 | 9670.1 |
199 | 2024-04-30 21:47:41 | opaques | 2 | 107671 | 9 | 3.703 | 29076.7 |
198 | 2024-04-29 00:08:01 | opaques | 3 | 134027 | 118 | 7.686 | 17437.8 |
197 | 2024-04-29 00:07:57 | opaques | 2 | 107671 | 9 | 3.156 | 34116.3 |
196 | 2024-04-20 21:54:55 | opaques | 3 | 134027 | 118 | 30.160 | 4443.9 |
195 | 2024-04-20 21:54:53 | opaques | 2 | 107671 | 9 | 4.483 | 24017.6 |
194 | 2024-04-20 21:54:10 | opaques | 1 | 69583 | 5 | 4.673 | 14890.4 |
193 | 2024-04-07 10:49:32 | opaques | 3 | 134027 | 118 | 14.203 | 9436.5 |
192 | 2024-04-07 10:49:31 | opaques | 2 | 107671 | 9 | 9.156 | 11759.6 |
191 | 2024-04-07 10:49:24 | opaques | 1 | 69583 | 5 | 3.046 | 22844.1 |
190 | 2024-03-29 07:13:43 | opaques | 1 | 69583 | 5 | 4.000 | 17395.8 |
189 | 2024-03-25 18:25:57 | opaques | 3 | 134027 | 118 | 6.233 | 21502.8 |
188 | 2024-03-25 18:25:53 | opaques | 2 | 107671 | 9 | 2.813 | 38276.2 |
187 | 2024-03-20 19:28:30 | opaques | 3 | 134027 | 118 | 14.640 | 9154.8 |
186 | 2024-03-20 19:28:32 | opaques | 1 | 69583 | 5 | 3.970 | 17527.2 |
185 | 2024-03-20 19:28:07 | opaques | 2 | 107671 | 9 | 8.220 | 13098.7 |
184 | 2024-03-20 19:28:00 | opaques | 1 | 69583 | 5 | 1.346 | 51696.1 |
183 | 2024-03-05 02:09:29 | opaques | 1 | 69583 | 5 | 3.703 | 18791.0 |
182 | 2024-03-01 09:41:40 | opaques | 3 | 134027 | 118 | 19.733 | 6792.0 |
181 | 2024-02-29 13:19:11 | opaques | 2 | 107671 | 9 | 3.126 | 34443.7 |
180 | 2024-02-29 13:18:31 | opaques | 3 | 134027 | 118 | 9.156 | 14638.2 |
179 | 2024-02-28 04:13:32 | opaques | 1 | 69583 | 5 | 1.483 | 46920.4 |
178 | 2024-02-19 22:42:35 | opaques | 1 | 69583 | 5 | 2.640 | 26357.2 |
177 | 2024-02-19 00:10:40 | opaques | 3 | 134027 | 118 | 16.220 | 8263.1 |
176 | 2024-02-19 00:10:38 | opaques | 2 | 107671 | 9 | 7.470 | 14413.8 |
175 | 2024-02-18 17:12:03 | opaques | 1 | 69583 | 5 | 1.076 | 64668.2 |
174 | 2024-01-18 21:28:24 | opaques | 1 | 69583 | 5 | 1.110 | 62687.4 |
173 | 2024-01-03 06:52:13 | opaques | 1 | 69583 | 5 | 1.060 | 65644.3 |
172 | 2023-12-05 03:58:03 | opaques | 1 | 69583 | 5 | 1.140 | 61037.7 |
171 | 2023-11-29 00:19:58 | opaques | 1 | 69583 | 5 | 1.236 | 56296.9 |
170 | 2023-11-23 10:10:45 | opaques | 1 | 69583 | 5 | 1.093 | 63662.4 |
169 | 2023-10-27 21:04:03 | opaques | 1 | 69583 | 5 | 1.206 | 57697.3 |
168 | 2023-10-23 00:27:00 | opaques | 1 | 69583 | 5 | 1.190 | 58473.1 |
167 | 2023-10-15 00:01:55 | opaques | 1 | 69583 | 5 | 1.063 | 65459.1 |
166 | 2023-09-29 19:25:57 | opaques | 1 | 69583 | 5 | 1.143 | 60877.5 |
165 | 2023-09-19 17:43:02 | opaques | 1 | 69583 | 5 | 1.076 | 64668.2 |
164 | 2023-09-11 05:31:40 | opaques | 1 | 69583 | 5 | 1.826 | 38106.8 |
163 | 2023-07-15 08:36:47 | opaques | 1 | 69583 | 5 | 1.170 | 59472.6 |
162 | 2023-07-10 14:17:46 | opaques | 1 | 69583 | 5 | 1.186 | 58670.3 |
161 | 2023-05-11 09:46:05 | opaques | 1 | 69583 | 5 | 1.453 | 47889.2 |
160 | 2023-04-13 01:20:45 | opaques | 1 | 69583 | 5 | 1.030 | 67556.3 |
159 | 2023-02-04 05:40:07 | opaques | 1 | 69583 | 5 | 1.030 | 67556.3 |
158 | 2023-01-07 01:08:19 | opaques | 1 | 69583 | 5 | 1.110 | 62687.4 |
157 | 2022-12-03 09:06:09 | opaques | 1 | 69583 | 5 | 1.033 | 67360.1 |
156 | 2022-09-12 05:52:32 | opaques | 1 | 69583 | 5 | 1.046 | 66522.9 |
155 | 2022-08-29 22:06:20 | opaques | 1 | 69583 | 5 | 1.063 | 65459.1 |
154 | 2022-07-10 00:08:34 | opaques | 1 | 69583 | 5 | 1.720 | 40455.2 |
153 | 2022-06-26 07:45:08 | opaques | 1 | 69583 | 5 | 1.186 | 58670.3 |
152 | 2022-06-25 05:05:55 | opaques | 1 | 69583 | 5 | 1.046 | 66522.9 |
151 | 2022-04-08 10:43:15 | opaques | 1 | 69583 | 5 | 1.313 | 52995.4 |
150 | 2022-04-05 00:00:49 | opaques | 1 | 69583 | 5 | 1.296 | 53690.6 |
149 | 2021-12-31 20:48:20 | opaques | 1 | 69583 | 5 | 1.266 | 54962.9 |
148 | 2021-12-01 16:41:46 | opaques | 1 | 69583 | 5 | 1.186 | 58670.3 |
147 | 2021-11-13 04:52:58 | opaques | 1 | 69583 | 5 | 1.220 | 57035.2 |
146 | 2021-08-08 13:30:00 | opaques | 1 | 69583 | 5 | 1.216 | 57222.9 |
145 | 2021-06-03 07:52:12 | opaques | 1 | 69583 | 5 | 1.140 | 61037.7 |
144 | 2021-04-19 19:35:52 | opaques | 1 | 69583 | 5 | 1.250 | 55666.4 |
143 | 2021-04-07 16:55:30 | opaques | 1 | 69583 | 5 | 1.076 | 64668.2 |
142 | 2021-04-07 14:29:46 | opaques | 1 | 69583 | 5 | 1.190 | 58473.1 |
141 | 2021-01-22 16:48:25 | opaques | 1 | 69583 | 5 | 1.173 | 59320.5 |
140 | 2020-12-26 04:10:43 | opaques | 1 | 69583 | 5 | 1.126 | 61796.6 |
139 | 2020-11-01 08:45:58 | opaques | 1 | 69583 | 5 | 1.203 | 57841.2 |
138 | 2020-10-09 19:38:53 | opaques | 1 | 69583 | 5 | 1.060 | 65644.3 |
137 | 2020-10-08 03:39:17 | opaques | 1 | 69583 | 5 | 1.033 | 67360.1 |
136 | 2020-09-18 12:51:15 | opaques | 1 | 69583 | 5 | 1.216 | 57222.9 |
135 | 2020-08-02 20:27:10 | opaques | 1 | 69583 | 5 | 1.093 | 63662.4 |
134 | 2020-05-30 13:15:33 | opaques | 1 | 69583 | 5 | 1.080 | 64428.7 |
133 | 2020-03-28 23:03:16 | opaques | 1 | 69583 | 5 | 1.123 | 61961.7 |
132 | 2020-03-28 15:31:19 | opaques | 1 | 69583 | 5 | 1.190 | 58473.1 |
131 | 2020-03-21 21:11:44 | opaques | 1 | 69583 | 5 | 1.046 | 66522.9 |
130 | 2020-02-29 05:06:55 | opaques | 1 | 69583 | 5 | 1.140 | 61037.7 |
129 | 2020-02-27 07:13:51 | opaques | 1 | 69583 | 5 | 1.280 | 54361.7 |
128 | 2020-02-25 12:20:08 | opaques | 1 | 69583 | 5 | 1.233 | 56433.9 |
127 | 2020-02-21 05:50:40 | opaques | 1 | 69583 | 5 | 1.216 | 57222.9 |
126 | 2020-02-19 20:28:07 | opaques | 1 | 69583 | 5 | 1.266 | 54962.9 |
125 | 2020-02-13 15:37:08 | opaques | 1 | 69583 | 5 | 1.236 | 56296.9 |
124 | 2020-02-04 05:08:03 | opaques | 1 | 69583 | 5 | 1.313 | 52995.4 |
123 | 2020-02-04 00:22:58 | opaques | 1 | 69583 | 5 | 1.516 | 45899.1 |
122 | 2020-01-27 17:52:00 | opaques | 1 | 69583 | 5 | 1.233 | 56433.9 |
121 | 2020-01-27 00:30:04 | opaques | 1 | 69583 | 5 | 1.326 | 52475.9 |
120 | 2020-01-23 20:14:13 | opaques | 1 | 69583 | 5 | 1.266 | 54962.9 |
119 | 2020-01-21 04:12:55 | opaques | 1 | 69583 | 5 | 1.313 | 52995.4 |
118 | 2020-01-17 07:07:46 | opaques | 1 | 69583 | 5 | 2.596 | 26803.9 |
117 | 2020-01-12 22:25:37 | opaques | 1 | 69583 | 5 | 1.156 | 60192.9 |
116 | 2019-12-31 22:24:08 | opaques | 1 | 69583 | 5 | 1.186 | 58670.3 |
115 | 2019-12-30 11:27:40 | opaques | 1 | 69583 | 5 | 2.720 | 25582.0 |
114 | 2019-11-18 22:29:41 | opaques | 1 | 69583 | 5 | 1.076 | 64668.2 |
113 | 2019-08-17 06:57:36 | opaques | 1 | 69583 | 5 | 1.133 | 61414.8 |
112 | 2019-05-04 21:31:18 | opaques | 1 | 69583 | 5 | 1.166 | 59676.7 |
111 | 2019-04-04 02:04:11 | opaques | 1 | 69583 | 5 | 1.146 | 60718.2 |
110 | 2019-04-01 14:38:50 | opaques | 1 | 69583 | 5 | 1.040 | 66906.7 |
109 | 2019-01-10 07:55:21 | opaques | 1 | 69583 | 5 | 2.080 | 33453.4 |
108 | 2019-01-05 17:11:20 | opaques | 1 | 69583 | 5 | 2.590 | 26866.0 |
107 | 2019-01-02 09:05:37 | opaques | 1 | 69583 | 5 | 1.070 | 65030.8 |
106 | 2018-09-25 22:05:25 | opaques | 1 | 69583 | 5 | 1.113 | 62518.4 |
105 | 2018-09-25 22:02:53 | opaques | 1 | 69583 | 5 | 1.170 | 59472.6 |
104 | 2018-09-02 14:22:21 | opaques | 1 | 69583 | 5 | 1.210 | 57506.6 |
103 | 2018-08-30 05:49:55 | opaques | 1 | 69583 | 5 | 1.356 | 51314.9 |
102 | 2018-08-16 05:26:25 | opaques | 1 | 69583 | 5 | 1.183 | 58819.1 |