History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"webcams"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
187 | 2024-04-26 20:15:51 | webcams | 1 | 69583 | 2 | 3.843 | 18106.4 |
186 | 2024-04-04 04:38:10 | webcams | 2 | 107671 | 4 | 8.250 | 13051.0 |
185 | 2024-04-04 04:37:49 | webcams | 3 | 134027 | 73 | 7.533 | 17792.0 |
184 | 2024-04-03 18:38:58 | webcams | 4 | 151207 | 1240 | 14.220 | 10633.4 |
183 | 2024-04-03 15:27:19 | webcams | 3 | 134027 | 73 | 12.923 | 10371.2 |
182 | 2024-04-03 15:27:12 | webcams | 2 | 107671 | 4 | 6.390 | 16849.9 |
181 | 2024-04-03 07:39:27 | webcams | 3 | 134027 | 73 | 15.813 | 8475.7 |
180 | 2024-04-03 04:00:48 | webcams | 4 | 151207 | 1240 | 38.376 | 3940.1 |
179 | 2024-04-02 22:14:42 | webcams | 4 | 151207 | 1240 | 31.706 | 4769.0 |
178 | 2024-04-02 21:36:53 | webcams | 1 | 69583 | 2 | 1.346 | 51696.1 |
177 | 2024-04-02 21:36:04 | webcams | 4 | 151207 | 1240 | 12.766 | 11844.5 |
176 | 2024-04-02 21:36:03 | webcams | 3 | 134027 | 73 | 8.796 | 15237.3 |
175 | 2024-04-02 21:36:02 | webcams | 2 | 107671 | 4 | 6.970 | 15447.8 |
174 | 2024-04-02 21:36:01 | webcams | 1 | 69583 | 2 | 2.576 | 27012.0 |
173 | 2024-03-12 08:26:44 | webcams | 4 | 151207 | 1240 | 16.766 | 9018.7 |
172 | 2024-03-12 08:26:43 | webcams | 3 | 134027 | 73 | 8.000 | 16753.4 |
171 | 2024-03-12 08:26:40 | webcams | 2 | 107671 | 4 | 7.596 | 14174.7 |
170 | 2024-03-12 08:24:44 | webcams | 1 | 69583 | 2 | 1.453 | 47889.2 |
169 | 2024-03-10 05:46:08 | webcams | 1 | 69583 | 2 | 5.356 | 12991.6 |
168 | 2024-03-02 16:12:12 | webcams | 1 | 69583 | 2 | 1.220 | 57035.2 |
167 | 2024-02-28 21:28:34 | webcams | 4 | 151207 | 1240 | 12.970 | 11658.2 |
166 | 2024-02-28 08:54:44 | webcams | 4 | 151207 | 1240 | 32.173 | 4699.8 |
165 | 2024-02-26 16:44:48 | webcams | 4 | 151207 | 1240 | 33.096 | 4568.7 |
164 | 2024-02-26 16:44:50 | webcams | 3 | 134027 | 73 | 21.266 | 6302.4 |
163 | 2024-02-26 16:44:53 | webcams | 2 | 107671 | 4 | 10.766 | 10001.0 |
162 | 2024-02-26 16:44:35 | webcams | 1 | 69583 | 2 | 2.360 | 29484.3 |
161 | 2024-02-08 11:13:16 | webcams | 1 | 69583 | 2 | 5.170 | 13459.0 |
160 | 2024-01-31 15:44:31 | webcams | 1 | 69583 | 2 | 1.233 | 56433.9 |
159 | 2024-01-30 10:11:51 | webcams | 1 | 69583 | 2 | 1.236 | 56296.9 |
158 | 2024-01-09 00:17:57 | webcams | 1 | 69583 | 2 | 1.220 | 57035.2 |
157 | 2023-12-18 01:52:50 | webcams | 1 | 69583 | 2 | 1.170 | 59472.6 |
156 | 2023-11-26 23:50:24 | webcams | 1 | 69583 | 2 | 1.046 | 66522.9 |
155 | 2023-11-24 10:00:32 | webcams | 1 | 69583 | 2 | 1.110 | 62687.4 |
154 | 2023-10-31 00:31:36 | webcams | 1 | 69583 | 2 | 1.250 | 55666.4 |
153 | 2023-10-16 14:28:34 | webcams | 1 | 69583 | 2 | 1.080 | 64428.7 |
152 | 2023-09-29 06:23:50 | webcams | 1 | 69583 | 2 | 1.406 | 49490.0 |
151 | 2023-09-25 07:32:21 | webcams | 1 | 69583 | 2 | 1.140 | 61037.7 |
150 | 2023-09-10 21:59:25 | webcams | 1 | 69583 | 2 | 1.503 | 46296.1 |
149 | 2023-08-06 09:22:08 | webcams | 1 | 69583 | 2 | 1.063 | 65459.1 |
148 | 2023-07-12 00:12:21 | webcams | 1 | 69583 | 2 | 1.250 | 55666.4 |
147 | 2023-06-21 13:27:41 | webcams | 1 | 69583 | 2 | 1.046 | 66522.9 |
146 | 2023-04-03 01:28:08 | webcams | 1 | 69583 | 2 | 1.033 | 67360.1 |
145 | 2023-03-10 00:23:26 | webcams | 1 | 69583 | 2 | 1.080 | 64428.7 |
144 | 2023-01-13 20:01:24 | webcams | 1 | 69583 | 2 | 1.123 | 61961.7 |
143 | 2022-11-01 02:53:56 | webcams | 1 | 69583 | 2 | 1.013 | 68690.0 |
142 | 2022-10-09 15:27:48 | webcams | 1 | 69583 | 2 | 1.046 | 66522.9 |
141 | 2022-06-21 01:56:32 | webcams | 1 | 69583 | 2 | 1.046 | 66522.9 |
140 | 2022-05-15 17:18:57 | webcams | 1 | 69583 | 2 | 1.063 | 65459.1 |
139 | 2022-02-26 09:19:17 | webcams | 1 | 69583 | 2 | 1.220 | 57035.2 |
138 | 2022-02-24 04:11:36 | webcams | 1 | 69583 | 2 | 1.406 | 49490.0 |
137 | 2021-12-27 23:12:30 | webcams | 1 | 69583 | 2 | 1.220 | 57035.2 |
136 | 2021-12-26 03:45:01 | webcams | 1 | 69583 | 2 | 1.080 | 64428.7 |
135 | 2021-09-27 16:19:10 | webcams | 1 | 69583 | 2 | 1.186 | 58670.3 |
134 | 2021-09-26 15:23:01 | webcams | 1 | 69583 | 2 | 1.060 | 65644.3 |
133 | 2021-09-22 01:48:17 | webcams | 1 | 69583 | 2 | 1.050 | 66269.5 |
132 | 2021-08-17 03:02:33 | webcams | 1 | 69583 | 2 | 1.063 | 65459.1 |
131 | 2021-04-21 18:22:36 | webcams | 1 | 69583 | 2 | 1.310 | 53116.8 |
130 | 2021-04-18 00:31:05 | webcams | 1 | 69583 | 2 | 2.500 | 27833.2 |
129 | 2021-01-29 11:00:41 | webcams | 1 | 69583 | 2 | 1.186 | 58670.3 |
128 | 2021-01-27 17:17:37 | webcams | 4 | 151207 | 1240 | 10.516 | 14378.8 |
127 | 2020-12-29 23:00:37 | webcams | 4 | 151207 | 1240 | 9.546 | 15839.8 |
126 | 2020-12-20 20:46:25 | webcams | 1 | 69583 | 2 | 1.080 | 64428.7 |
125 | 2020-11-08 05:15:22 | webcams | 4 | 151207 | 1240 | 9.940 | 15212.0 |
124 | 2020-11-03 09:41:01 | webcams | 1 | 69583 | 2 | 1.060 | 65644.3 |
123 | 2020-10-31 22:23:09 | webcams | 1 | 69583 | 2 | 1.250 | 55666.4 |
122 | 2020-10-29 22:55:11 | webcams | 1 | 69583 | 2 | 1.076 | 64668.2 |
121 | 2020-10-17 02:36:46 | webcams | 1 | 69583 | 2 | 1.216 | 57222.9 |
120 | 2020-10-06 05:33:28 | webcams | 1 | 69583 | 2 | 1.046 | 66522.9 |
119 | 2020-08-27 15:05:24 | webcams | 1 | 69583 | 2 | 1.186 | 58670.3 |
118 | 2020-08-20 18:46:31 | webcams | 1 | 69583 | 2 | 1.093 | 63662.4 |
117 | 2020-08-06 13:38:22 | webcams | 1 | 69583 | 2 | 1.093 | 63662.4 |
116 | 2020-08-03 04:33:31 | webcams | 1 | 69583 | 2 | 1.090 | 63837.6 |
115 | 2020-05-18 18:45:37 | webcams | 1 | 69583 | 2 | 1.030 | 67556.3 |
114 | 2020-04-28 03:38:20 | webcams | 1 | 69583 | 2 | 1.250 | 55666.4 |
113 | 2020-03-28 23:17:59 | webcams | 1 | 69583 | 2 | 1.236 | 56296.9 |
112 | 2020-03-28 01:04:40 | webcams | 1 | 69583 | 2 | 1.250 | 55666.4 |
111 | 2020-03-21 12:11:05 | webcams | 1 | 69583 | 2 | 1.220 | 57035.2 |
110 | 2020-02-26 17:19:30 | webcams | 1 | 69583 | 2 | 1.250 | 55666.4 |
109 | 2020-02-23 17:32:30 | webcams | 1 | 69583 | 2 | 1.266 | 54962.9 |
108 | 2020-02-19 22:07:10 | webcams | 1 | 69583 | 2 | 1.190 | 58473.1 |
107 | 2020-02-18 17:22:00 | webcams | 1 | 69583 | 2 | 1.220 | 57035.2 |
106 | 2020-02-17 16:52:56 | webcams | 1 | 69583 | 2 | 1.140 | 61037.7 |
105 | 2020-02-05 19:01:02 | webcams | 1 | 69583 | 2 | 3.296 | 21111.3 |
104 | 2020-02-05 14:28:21 | webcams | 1 | 69583 | 2 | 1.236 | 56296.9 |
103 | 2020-01-27 14:43:29 | webcams | 1 | 69583 | 2 | 2.596 | 26803.9 |
102 | 2020-01-26 11:48:18 | webcams | 1 | 69583 | 2 | 3.970 | 17527.2 |
101 | 2020-01-23 19:39:35 | webcams | 1 | 69583 | 2 | 1.406 | 49490.0 |
100 | 2020-01-20 10:33:56 | webcams | 1 | 69583 | 2 | 1.263 | 55093.4 |
99 | 2020-01-18 02:21:12 | webcams | 1 | 69583 | 2 | 1.266 | 54962.9 |
98 | 2020-01-12 13:15:30 | webcams | 1 | 69583 | 2 | 3.356 | 20733.9 |
97 | 2020-01-03 17:47:50 | webcams | 1 | 69583 | 2 | 1.173 | 59320.5 |
96 | 2020-01-02 02:08:42 | webcams | 1 | 69583 | 2 | 1.343 | 51811.6 |
95 | 2019-12-30 09:56:50 | webcams | 1 | 69583 | 2 | 1.266 | 54962.9 |
94 | 2019-11-29 16:23:00 | webcams | 1 | 69583 | 2 | 1.046 | 66522.9 |
93 | 2019-10-08 09:22:55 | webcams | 1 | 69583 | 2 | 1.046 | 66522.9 |
92 | 2019-10-05 00:41:46 | webcams | 1 | 69583 | 2 | 0.980 | 71003.1 |
91 | 2019-09-19 15:20:32 | webcams | 1 | 69583 | 2 | 0.966 | 72032.1 |
90 | 2019-06-09 23:58:49 | webcams | 1 | 69583 | 2 | 1.156 | 60192.9 |
89 | 2019-05-04 05:22:26 | webcams | 1 | 69583 | 2 | 1.053 | 66080.7 |
88 | 2019-04-17 00:41:29 | webcams | 1 | 69583 | 2 | 1.070 | 65030.8 |