History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"unalerted"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
193 | 2024-03-28 16:03:52 | unalerted | 1 | 81242 | 2 | 1.376 | 59042.2 |
192 | 2024-03-18 23:04:37 | unalerted | 3 | 148641 | 98 | 16.456 | 9032.6 |
191 | 2024-03-18 17:55:58 | unalerted | 2 | 121436 | 10 | 3.893 | 31193.4 |
190 | 2024-03-18 17:55:23 | unalerted | 3 | 148641 | 98 | 8.140 | 18260.6 |
189 | 2024-03-18 12:10:51 | unalerted | 2 | 121436 | 10 | 12.826 | 9468.0 |
188 | 2024-03-18 12:10:46 | unalerted | 3 | 148641 | 98 | 14.956 | 9938.6 |
187 | 2024-03-18 04:52:33 | unalerted | 4 | 165329 | 797 | 16.763 | 9862.7 |
186 | 2024-03-16 08:34:15 | unalerted | 4 | 165329 | 797 | 21.766 | 7595.7 |
185 | 2024-03-15 21:43:05 | unalerted | 3 | 148641 | 98 | 20.733 | 7169.3 |
184 | 2024-03-15 21:43:06 | unalerted | 2 | 121436 | 10 | 12.813 | 9477.6 |
183 | 2024-03-15 21:42:26 | unalerted | 4 | 165329 | 797 | 34.283 | 4822.5 |
182 | 2024-03-15 20:54:16 | unalerted | 1 | 81242 | 2 | 1.296 | 62686.7 |
181 | 2024-02-27 11:02:47 | unalerted | 1 | 81242 | 2 | 1.220 | 66591.8 |
180 | 2024-02-18 04:37:27 | unalerted | 1 | 81242 | 2 | 1.516 | 53589.7 |
179 | 2024-02-03 16:32:29 | unalerted | 1 | 81242 | 2 | 1.250 | 64993.6 |
178 | 2023-12-22 13:09:57 | unalerted | 1 | 81242 | 2 | 1.250 | 64993.6 |
177 | 2023-12-02 07:05:57 | unalerted | 1 | 81242 | 2 | 1.220 | 66591.8 |
176 | 2023-11-24 20:22:24 | unalerted | 1 | 81242 | 2 | 1.390 | 58447.5 |
175 | 2023-11-22 03:44:39 | unalerted | 1 | 81242 | 2 | 1.220 | 66591.8 |
174 | 2023-11-20 07:53:54 | unalerted | 1 | 81242 | 2 | 1.296 | 62686.7 |
173 | 2023-10-10 03:52:34 | unalerted | 1 | 81242 | 2 | 1.393 | 58321.6 |
172 | 2023-10-06 18:42:42 | unalerted | 1 | 81242 | 2 | 1.326 | 61268.5 |
171 | 2023-08-05 02:20:18 | unalerted | 1 | 81242 | 2 | 1.360 | 59736.8 |
170 | 2023-07-25 08:05:45 | unalerted | 1 | 81242 | 2 | 1.233 | 65889.7 |
169 | 2023-05-04 17:18:19 | unalerted | 1 | 81242 | 2 | 1.173 | 69260.0 |
168 | 2023-04-06 04:36:19 | unalerted | 1 | 81242 | 2 | 1.250 | 64993.6 |
167 | 2023-02-26 15:48:22 | unalerted | 1 | 81242 | 2 | 1.216 | 66810.9 |
166 | 2022-12-24 22:25:39 | unalerted | 1 | 81242 | 2 | 1.313 | 61875.1 |
165 | 2022-12-17 11:08:12 | unalerted | 1 | 81242 | 2 | 1.360 | 59736.8 |
164 | 2022-12-14 06:06:10 | unalerted | 1 | 81242 | 2 | 1.326 | 61268.5 |
163 | 2022-09-12 19:45:02 | unalerted | 1 | 81242 | 2 | 1.203 | 67532.8 |
162 | 2022-08-04 07:02:14 | unalerted | 1 | 81242 | 2 | 1.236 | 65729.8 |
161 | 2022-07-31 20:11:09 | unalerted | 1 | 81242 | 2 | 1.203 | 67532.8 |
160 | 2022-07-14 01:49:58 | unalerted | 1 | 81242 | 2 | 1.233 | 65889.7 |
159 | 2022-04-02 21:32:45 | unalerted | 1 | 81242 | 2 | 1.203 | 67532.8 |
158 | 2022-03-18 11:30:09 | unalerted | 1 | 81242 | 2 | 1.563 | 51978.2 |
157 | 2022-03-16 07:36:38 | unalerted | 1 | 81242 | 2 | 1.423 | 57092.1 |
156 | 2022-01-10 12:02:26 | unalerted | 1 | 81242 | 2 | 1.483 | 54782.2 |
155 | 2021-12-09 12:45:11 | unalerted | 1 | 81242 | 2 | 1.420 | 57212.7 |
154 | 2021-08-26 14:18:04 | unalerted | 1 | 81242 | 2 | 1.393 | 58321.6 |
153 | 2021-06-06 20:59:03 | unalerted | 3 | 148641 | 98 | 7.453 | 19943.8 |
152 | 2021-05-22 13:29:14 | unalerted | 1 | 81242 | 2 | 1.233 | 65889.7 |
151 | 2021-05-12 14:55:15 | unalerted | 3 | 148641 | 98 | 8.123 | 18298.8 |
150 | 2021-04-30 10:37:46 | unalerted | 1 | 81242 | 2 | 1.406 | 57782.4 |
149 | 2021-04-11 09:46:50 | unalerted | 3 | 148641 | 98 | 7.110 | 20905.9 |
148 | 2021-03-19 05:31:25 | unalerted | 2 | 121436 | 10 | 4.000 | 30359.0 |
147 | 2021-02-22 01:45:12 | unalerted | 2 | 121436 | 10 | 3.063 | 39646.1 |
146 | 2021-02-18 11:55:24 | unalerted | 3 | 148641 | 98 | 6.250 | 23782.6 |
145 | 2021-02-16 03:36:08 | unalerted | 1 | 81242 | 2 | 1.220 | 66591.8 |
144 | 2021-01-26 02:45:30 | unalerted | 1 | 81242 | 2 | 1.393 | 58321.6 |
143 | 2021-01-13 12:22:34 | unalerted | 1 | 81242 | 2 | 1.216 | 66810.9 |
142 | 2020-11-11 21:08:08 | unalerted | 1 | 81242 | 2 | 1.203 | 67532.8 |
141 | 2020-10-28 10:55:53 | unalerted | 1 | 81242 | 2 | 1.266 | 64172.2 |
140 | 2020-10-25 20:14:14 | unalerted | 1 | 81242 | 2 | 1.373 | 59171.2 |
139 | 2020-08-02 06:46:44 | unalerted | 1 | 81242 | 2 | 1.390 | 58447.5 |
138 | 2020-04-27 14:40:29 | unalerted | 1 | 81242 | 2 | 1.360 | 59736.8 |
137 | 2020-03-28 12:15:07 | unalerted | 1 | 81242 | 2 | 2.766 | 29371.7 |
136 | 2020-03-22 11:28:11 | unalerted | 1 | 81242 | 2 | 1.250 | 64993.6 |
135 | 2020-02-29 09:41:53 | unalerted | 1 | 81242 | 2 | 1.346 | 60358.1 |
134 | 2020-02-19 06:31:32 | unalerted | 1 | 81242 | 2 | 1.546 | 52549.8 |
133 | 2020-02-18 18:32:59 | unalerted | 1 | 81242 | 2 | 1.436 | 56575.2 |
132 | 2020-02-14 17:30:14 | unalerted | 1 | 81242 | 2 | 4.656 | 17448.9 |
131 | 2020-02-02 06:32:31 | unalerted | 1 | 81242 | 2 | 1.593 | 50999.4 |
130 | 2020-01-30 02:51:50 | unalerted | 1 | 81242 | 2 | 1.483 | 54782.2 |
129 | 2020-01-26 16:43:55 | unalerted | 1 | 81242 | 2 | 3.236 | 25105.7 |
128 | 2020-01-26 11:16:09 | unalerted | 1 | 81242 | 2 | 3.173 | 25604.2 |
127 | 2020-01-23 21:12:34 | unalerted | 1 | 81242 | 2 | 2.186 | 37164.7 |
126 | 2020-01-22 04:52:09 | unalerted | 1 | 81242 | 2 | 2.843 | 28576.2 |
125 | 2020-01-20 01:11:32 | unalerted | 1 | 81242 | 2 | 3.076 | 26411.6 |
124 | 2020-01-08 19:51:07 | unalerted | 1 | 81242 | 2 | 1.420 | 57212.7 |
123 | 2020-01-05 01:49:56 | unalerted | 1 | 81242 | 2 | 1.250 | 64993.6 |
122 | 2020-01-02 22:56:44 | unalerted | 1 | 81242 | 2 | 1.440 | 56418.1 |
121 | 2019-10-25 11:03:51 | unalerted | 1 | 81242 | 2 | 1.296 | 62686.7 |
120 | 2019-07-25 04:51:16 | unalerted | 1 | 81242 | 2 | 1.193 | 68098.9 |
119 | 2019-07-24 10:16:29 | unalerted | 1 | 81242 | 2 | 1.310 | 62016.8 |
118 | 2019-04-17 00:33:16 | unalerted | 1 | 81242 | 2 | 1.323 | 61407.4 |
117 | 2019-02-15 04:20:07 | unalerted | 1 | 81242 | 2 | 1.186 | 68500.8 |
116 | 2018-12-27 23:56:24 | unalerted | 1 | 81242 | 2 | 1.320 | 61547.0 |
115 | 2018-11-24 18:22:54 | unalerted | 1 | 81242 | 2 | 1.153 | 70461.4 |
114 | 2018-09-02 10:49:28 | unalerted | 1 | 81242 | 2 | 1.300 | 62493.8 |
113 | 2018-08-31 15:53:36 | unalerted | 1 | 81242 | 2 | 1.320 | 61547.0 |
112 | 2018-07-12 08:51:11 | unalerted | 1 | 81242 | 2 | 1.236 | 65729.8 |
111 | 2018-07-07 02:03:53 | unalerted | 1 | 81242 | 2 | 1.193 | 68098.9 |
110 | 2018-07-02 19:03:25 | unalerted | 1 | 81242 | 2 | 1.296 | 62686.7 |
109 | 2018-06-10 01:08:03 | unalerted | 1 | 81242 | 2 | 1.160 | 70036.2 |
108 | 2018-05-30 00:27:22 | unalerted | 1 | 81242 | 2 | 1.353 | 60045.8 |
107 | 2018-04-20 04:31:34 | unalerted | 1 | 81242 | 2 | 1.206 | 67364.8 |
106 | 2018-02-19 19:16:36 | unalerted | 1 | 81242 | 2 | 1.690 | 48072.2 |
105 | 2018-02-18 11:56:42 | unalerted | 1 | 81242 | 2 | 1.713 | 47426.7 |
104 | 2018-02-18 11:25:28 | unalerted | 1 | 81242 | 2 | 1.690 | 48072.2 |
103 | 2017-12-09 16:39:53 | unalerted | 1 | 81242 | 2 | 1.606 | 50586.6 |
102 | 2017-12-09 16:35:44 | unalerted | 1 | 81242 | 2 | 1.923 | 42247.5 |
101 | 2017-11-16 13:50:00 | unalerted | 1 | 81242 | 2 | 1.776 | 45744.4 |
100 | 2017-10-22 15:53:43 | unalerted | 1 | 81242 | 2 | 1.810 | 44885.1 |
99 | 2017-09-28 00:38:37 | unalerted | 1 | 81242 | 2 | 1.773 | 45821.8 |
98 | 2017-09-20 17:01:10 | unalerted | 1 | 81242 | 2 | 2.243 | 36220.2 |
97 | 2017-07-25 22:31:21 | unalerted | 1 | 81242 | 2 | 1.593 | 50999.4 |
96 | 2017-07-20 06:17:15 | unalerted | 1 | 81242 | 2 | 2.133 | 38088.1 |
95 | 2017-07-20 06:11:36 | unalerted | 1 | 81242 | 2 | 1.563 | 51978.2 |
94 | 2017-06-29 13:58:29 | unalerted | 1 | 81242 | 2 | 1.793 | 45310.7 |