History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"patrollers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
208 | 2024-04-23 17:18:18 | patrollers | 2 | 108824 | 6 | 3.093 | 35184.0 |
207 | 2024-04-18 00:08:49 | patrollers | 4 | 161450 | 269 | 29.750 | 5426.9 |
206 | 2024-04-18 00:08:49 | patrollers | 3 | 140603 | 35 | 24.436 | 5753.9 |
205 | 2024-04-17 09:56:54 | patrollers | 4 | 161450 | 269 | 26.906 | 6000.5 |
204 | 2024-04-16 19:49:38 | patrollers | 4 | 161450 | 269 | 49.456 | 3264.5 |
203 | 2024-04-16 19:49:37 | patrollers | 3 | 140603 | 35 | 24.690 | 5694.7 |
202 | 2024-04-16 19:49:36 | patrollers | 2 | 108824 | 6 | 7.550 | 14413.8 |
201 | 2024-04-16 17:51:31 | patrollers | 1 | 67641 | 2 | 1.626 | 41599.6 |
200 | 2024-04-06 06:22:01 | patrollers | 1 | 67641 | 2 | 4.173 | 16209.2 |
199 | 2024-04-01 10:10:56 | patrollers | 1 | 67641 | 2 | 1.280 | 52844.5 |
198 | 2024-03-31 04:10:09 | patrollers | 1 | 67641 | 2 | 1.186 | 57032.9 |
197 | 2024-03-31 04:10:04 | patrollers | 1 | 67641 | 2 | 1.203 | 56226.9 |
196 | 2024-03-11 03:54:20 | patrollers | 1 | 67641 | 2 | 1.063 | 63632.2 |
195 | 2024-03-06 15:39:07 | patrollers | 4 | 161450 | 269 | 36.050 | 4478.5 |
194 | 2024-03-06 07:37:51 | patrollers | 1 | 67641 | 2 | 2.656 | 25467.2 |
193 | 2024-03-05 16:20:16 | patrollers | 1 | 67641 | 2 | 1.220 | 55443.4 |
192 | 2024-02-29 09:36:34 | patrollers | 1 | 67641 | 2 | 1.203 | 56226.9 |
191 | 2024-02-29 09:36:32 | patrollers | 1 | 67641 | 2 | 2.390 | 28301.7 |
190 | 2024-02-11 20:48:39 | patrollers | 4 | 161450 | 269 | 39.500 | 4087.3 |
189 | 2024-02-02 21:29:52 | patrollers | 1 | 67641 | 2 | 1.170 | 57812.8 |
188 | 2024-01-30 12:06:47 | patrollers | 1 | 67641 | 2 | 1.580 | 42810.8 |
187 | 2024-01-30 08:04:35 | patrollers | 1 | 67641 | 2 | 1.236 | 54725.7 |
186 | 2024-01-30 08:04:30 | patrollers | 1 | 67641 | 2 | 2.436 | 27767.2 |
185 | 2024-01-23 04:24:40 | patrollers | 4 | 161450 | 269 | 47.673 | 3386.6 |
184 | 2024-01-22 06:15:24 | patrollers | 4 | 161450 | 269 | 11.236 | 14369.0 |
183 | 2023-12-24 01:42:22 | patrollers | 1 | 67641 | 2 | 1.160 | 58311.2 |
182 | 2023-12-17 12:50:25 | patrollers | 2 | 108824 | 6 | 3.143 | 34624.2 |
181 | 2023-12-15 00:59:27 | patrollers | 3 | 140603 | 35 | 7.423 | 18941.5 |
180 | 2023-12-15 00:59:29 | patrollers | 2 | 108824 | 6 | 3.640 | 29896.7 |
179 | 2023-12-14 23:22:44 | patrollers | 4 | 161450 | 269 | 13.550 | 11915.1 |
178 | 2023-11-23 02:03:30 | patrollers | 1 | 67641 | 2 | 1.173 | 57665.0 |
177 | 2023-11-02 04:13:07 | patrollers | 1 | 67641 | 2 | 1.156 | 58513.0 |
176 | 2023-11-01 04:30:14 | patrollers | 4 | 161450 | 269 | 11.126 | 14511.1 |
175 | 2023-10-28 22:32:12 | patrollers | 1 | 67641 | 2 | 1.156 | 58513.0 |
174 | 2023-10-23 15:29:31 | patrollers | 4 | 161450 | 269 | 14.393 | 11217.3 |
173 | 2023-10-23 15:29:35 | patrollers | 2 | 108824 | 6 | 5.796 | 18775.7 |
172 | 2023-10-23 15:29:29 | patrollers | 3 | 140603 | 35 | 6.203 | 22666.9 |
171 | 2023-10-20 19:04:06 | patrollers | 1 | 67641 | 2 | 1.736 | 38963.7 |
170 | 2023-10-10 05:40:48 | patrollers | 1 | 67641 | 2 | 1.200 | 56367.5 |
169 | 2023-09-18 03:44:32 | patrollers | 2 | 108824 | 6 | 3.063 | 35528.6 |
168 | 2023-08-09 00:02:09 | patrollers | 4 | 161450 | 269 | 10.593 | 15241.2 |
167 | 2023-08-06 14:20:08 | patrollers | 1 | 67641 | 2 | 1.123 | 60232.4 |
166 | 2023-06-21 12:53:32 | patrollers | 2 | 108824 | 6 | 2.890 | 37655.4 |
165 | 2023-05-07 03:47:20 | patrollers | 1 | 67641 | 2 | 1.030 | 65670.9 |
164 | 2023-04-18 18:40:56 | patrollers | 4 | 161450 | 269 | 10.186 | 15850.2 |
163 | 2023-03-15 00:11:08 | patrollers | 2 | 108824 | 6 | 2.703 | 40260.5 |
162 | 2023-02-28 17:15:21 | patrollers | 1 | 67641 | 2 | 1.030 | 65670.9 |
161 | 2023-01-25 07:51:16 | patrollers | 4 | 161450 | 269 | 9.686 | 16668.4 |
160 | 2022-12-25 07:44:23 | patrollers | 1 | 67641 | 2 | 1.000 | 67641.0 |
159 | 2022-12-18 15:56:07 | patrollers | 2 | 108824 | 6 | 2.686 | 40515.3 |
158 | 2022-11-06 18:15:39 | patrollers | 4 | 161450 | 269 | 13.750 | 11741.8 |
157 | 2022-09-13 15:31:21 | patrollers | 1 | 67641 | 2 | 1.173 | 57665.0 |
156 | 2022-08-14 06:08:21 | patrollers | 2 | 108824 | 6 | 2.750 | 39572.4 |
155 | 2022-07-16 15:25:52 | patrollers | 3 | 140603 | 35 | 5.563 | 25274.7 |
154 | 2022-07-14 16:13:12 | patrollers | 1 | 67641 | 2 | 1.013 | 66773.0 |
153 | 2022-06-08 10:54:33 | patrollers | 4 | 161450 | 269 | 10.390 | 15539.0 |
152 | 2022-03-18 22:46:47 | patrollers | 1 | 67641 | 2 | 1.156 | 58513.0 |
151 | 2022-03-16 19:16:24 | patrollers | 1 | 67641 | 2 | 1.030 | 65670.9 |
150 | 2022-01-08 19:17:13 | patrollers | 1 | 67641 | 2 | 1.250 | 54112.8 |
149 | 2021-10-09 20:08:44 | patrollers | 1 | 67641 | 2 | 1.206 | 56087.1 |
148 | 2021-06-15 18:35:33 | patrollers | 1 | 67641 | 2 | 1.016 | 66575.8 |
147 | 2021-04-24 07:16:33 | patrollers | 1 | 67641 | 2 | 1.190 | 56841.2 |
146 | 2021-04-03 07:18:42 | patrollers | 1 | 67641 | 2 | 2.063 | 32787.7 |
145 | 2021-01-09 11:43:25 | patrollers | 1 | 67641 | 2 | 1.033 | 65480.2 |
144 | 2020-10-29 15:28:07 | patrollers | 1 | 67641 | 2 | 1.250 | 54112.8 |
143 | 2020-10-29 15:14:17 | patrollers | 1 | 67641 | 2 | 1.063 | 63632.2 |
142 | 2020-10-21 22:27:14 | patrollers | 1 | 67641 | 2 | 1.143 | 59178.5 |
141 | 2020-10-09 06:26:13 | patrollers | 1 | 67641 | 2 | 1.126 | 60071.9 |
140 | 2020-04-01 09:24:14 | patrollers | 1 | 67641 | 2 | 1.140 | 59334.2 |
139 | 2020-03-25 12:16:58 | patrollers | 1 | 67641 | 2 | 1.093 | 61885.6 |
138 | 2020-02-23 05:53:31 | patrollers | 1 | 67641 | 2 | 2.453 | 27574.8 |
137 | 2020-02-08 11:23:39 | patrollers | 1 | 67641 | 2 | 2.220 | 30468.9 |
136 | 2020-02-07 09:20:40 | patrollers | 1 | 67641 | 2 | 1.343 | 50365.6 |
135 | 2020-02-04 11:35:54 | patrollers | 1 | 67641 | 2 | 3.766 | 17961.0 |
134 | 2020-01-30 16:49:41 | patrollers | 1 | 67641 | 2 | 1.266 | 53428.9 |
133 | 2020-01-23 11:57:55 | patrollers | 1 | 67641 | 2 | 3.470 | 19493.1 |
132 | 2020-01-16 19:08:25 | patrollers | 1 | 67641 | 2 | 1.140 | 59334.2 |
131 | 2020-01-11 19:15:19 | patrollers | 1 | 67641 | 2 | 1.186 | 57032.9 |
130 | 2020-01-03 04:44:43 | patrollers | 1 | 67641 | 2 | 1.216 | 55625.8 |
129 | 2019-12-27 05:08:29 | patrollers | 1 | 67641 | 2 | 1.250 | 54112.8 |
128 | 2019-09-26 13:32:27 | patrollers | 1 | 67641 | 2 | 1.013 | 66773.0 |
127 | 2019-08-08 16:13:11 | patrollers | 1 | 67641 | 2 | 1.050 | 64420.0 |
126 | 2019-07-25 16:14:43 | patrollers | 1 | 67641 | 2 | 1.016 | 66575.8 |
125 | 2019-07-21 16:36:19 | patrollers | 1 | 67641 | 2 | 1.006 | 67237.6 |
124 | 2019-06-17 11:18:37 | patrollers | 1 | 67641 | 2 | 1.083 | 62457.1 |
123 | 2019-06-05 12:42:31 | patrollers | 1 | 67641 | 2 | 1.030 | 65670.9 |
122 | 2019-06-02 07:46:13 | patrollers | 1 | 67641 | 2 | 1.050 | 64420.0 |
121 | 2019-05-29 20:41:00 | patrollers | 1 | 67641 | 2 | 1.336 | 50629.5 |
120 | 2019-04-09 11:00:19 | patrollers | 1 | 67641 | 2 | 1.180 | 57322.9 |
119 | 2019-02-26 21:01:45 | patrollers | 1 | 67641 | 2 | 1.116 | 60610.2 |
118 | 2019-02-23 20:14:51 | patrollers | 1 | 67641 | 2 | 1.130 | 59859.3 |
117 | 2018-10-29 01:26:34 | patrollers | 1 | 67641 | 2 | 1.166 | 58011.1 |
116 | 2018-09-21 07:00:39 | patrollers | 1 | 67641 | 2 | 1.216 | 55625.8 |
115 | 2018-09-19 10:14:25 | patrollers | 1 | 67641 | 2 | 1.026 | 65926.9 |
114 | 2018-09-13 21:53:48 | patrollers | 1 | 67641 | 2 | 1.086 | 62284.5 |
113 | 2018-08-17 00:23:14 | patrollers | 1 | 67641 | 2 | 1.023 | 66120.2 |
112 | 2018-08-15 10:56:43 | patrollers | 1 | 67641 | 2 | 1.036 | 65290.5 |
111 | 2018-07-15 17:13:01 | patrollers | 1 | 67641 | 2 | 1.200 | 56367.5 |
110 | 2018-04-15 23:42:22 | patrollers | 1 | 67641 | 2 | 1.086 | 62284.5 |
109 | 2018-04-09 00:08:49 | patrollers | 1 | 67641 | 2 | 1.233 | 54858.9 |