History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spirometer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
199 | 2024-04-17 23:08:24 | spirometer | 4 | 161450 | 158 | 37.940 | 4255.4 |
198 | 2024-04-17 14:47:21 | spirometer | 4 | 161450 | 158 | 18.876 | 8553.2 |
197 | 2024-04-17 14:47:17 | spirometer | 3 | 140603 | 43 | 13.830 | 10166.5 |
196 | 2024-04-15 06:20:00 | spirometer | 1 | 67641 | 2 | 3.966 | 17055.2 |
195 | 2024-04-15 06:08:17 | spirometer | 4 | 161450 | 158 | 14.190 | 11377.7 |
194 | 2024-04-15 06:08:19 | spirometer | 3 | 140603 | 43 | 7.673 | 18324.4 |
193 | 2024-04-15 06:08:21 | spirometer | 2 | 108824 | 7 | 3.706 | 29364.3 |
192 | 2024-04-15 06:07:47 | spirometer | 1 | 67641 | 2 | 1.266 | 53428.9 |
191 | 2024-03-24 12:19:39 | spirometer | 3 | 140603 | 43 | 8.003 | 17568.8 |
190 | 2024-03-23 03:09:18 | spirometer | 3 | 140603 | 43 | 9.013 | 15600.0 |
189 | 2024-03-21 19:04:52 | spirometer | 4 | 161450 | 158 | 26.390 | 6117.8 |
188 | 2024-03-19 23:46:58 | spirometer | 1 | 67641 | 2 | 1.236 | 54725.7 |
187 | 2024-03-18 02:58:48 | spirometer | 4 | 161450 | 158 | 49.206 | 3281.1 |
186 | 2024-03-18 02:58:41 | spirometer | 2 | 108824 | 7 | 6.216 | 17507.1 |
185 | 2024-03-18 02:58:34 | spirometer | 3 | 140603 | 43 | 11.390 | 12344.4 |
184 | 2024-03-18 02:53:54 | spirometer | 1 | 67641 | 2 | 1.250 | 54112.8 |
183 | 2024-03-16 17:40:39 | spirometer | 4 | 161450 | 158 | 31.316 | 5155.5 |
182 | 2024-03-16 17:40:28 | spirometer | 3 | 140603 | 43 | 21.376 | 6577.6 |
181 | 2024-03-13 02:13:18 | spirometer | 1 | 67641 | 2 | 2.813 | 24045.9 |
180 | 2024-03-13 02:13:08 | spirometer | 2 | 108824 | 7 | 3.423 | 31792.0 |
179 | 2024-03-13 02:13:00 | spirometer | 1 | 67641 | 2 | 1.250 | 54112.8 |
178 | 2024-03-11 20:02:21 | spirometer | 4 | 161450 | 158 | 26.593 | 6071.1 |
177 | 2024-03-11 20:02:21 | spirometer | 3 | 140603 | 43 | 8.813 | 15954.0 |
176 | 2024-03-09 17:27:26 | spirometer | 4 | 161450 | 158 | 23.236 | 6948.3 |
175 | 2024-03-09 17:27:26 | spirometer | 2 | 108824 | 7 | 10.016 | 10865.0 |
174 | 2024-03-09 17:26:36 | spirometer | 3 | 140603 | 43 | 13.906 | 10111.0 |
173 | 2024-03-07 10:53:07 | spirometer | 2 | 108824 | 7 | 10.986 | 9905.7 |
172 | 2024-03-07 07:42:22 | spirometer | 1 | 67641 | 2 | 1.186 | 57032.9 |
171 | 2024-02-21 08:47:55 | spirometer | 1 | 67641 | 2 | 2.610 | 25916.1 |
170 | 2024-02-19 11:57:33 | spirometer | 4 | 161450 | 158 | 13.813 | 11688.3 |
169 | 2024-02-19 11:57:33 | spirometer | 3 | 140603 | 43 | 11.060 | 12712.7 |
168 | 2024-02-17 04:03:38 | spirometer | 4 | 161450 | 158 | 29.940 | 5392.5 |
167 | 2024-02-17 02:59:33 | spirometer | 3 | 140603 | 43 | 15.703 | 8953.9 |
166 | 2024-02-15 14:16:26 | spirometer | 4 | 161450 | 158 | 29.766 | 5424.0 |
165 | 2024-02-15 14:16:26 | spirometer | 3 | 140603 | 43 | 14.390 | 9770.9 |
164 | 2024-02-15 07:12:41 | spirometer | 4 | 161450 | 158 | 28.076 | 5750.5 |
163 | 2024-02-15 07:12:41 | spirometer | 3 | 140603 | 43 | 15.593 | 9017.1 |
162 | 2024-02-15 07:12:40 | spirometer | 2 | 108824 | 7 | 7.156 | 15207.4 |
161 | 2024-02-11 15:38:18 | spirometer | 1 | 67641 | 2 | 4.080 | 16578.7 |
160 | 2024-02-04 19:34:20 | spirometer | 1 | 67641 | 2 | 1.140 | 59334.2 |
159 | 2024-01-28 18:26:55 | spirometer | 1 | 67641 | 2 | 2.156 | 31373.4 |
158 | 2023-12-04 12:49:20 | spirometer | 1 | 67641 | 2 | 2.453 | 27574.8 |
157 | 2023-12-01 12:54:48 | spirometer | 1 | 67641 | 2 | 1.173 | 57665.0 |
156 | 2023-11-27 02:38:49 | spirometer | 1 | 67641 | 2 | 1.063 | 63632.2 |
155 | 2023-09-12 22:52:01 | spirometer | 1 | 67641 | 2 | 1.216 | 55625.8 |
154 | 2023-06-24 12:23:02 | spirometer | 1 | 67641 | 2 | 1.030 | 65670.9 |
153 | 2023-05-07 13:33:49 | spirometer | 1 | 67641 | 2 | 1.016 | 66575.8 |
152 | 2023-03-31 15:19:32 | spirometer | 1 | 67641 | 2 | 1.030 | 65670.9 |
151 | 2023-03-20 12:28:30 | spirometer | 1 | 67641 | 2 | 1.173 | 57665.0 |
150 | 2023-01-15 11:29:12 | spirometer | 1 | 67641 | 2 | 1.126 | 60071.9 |
149 | 2022-11-12 14:35:14 | spirometer | 1 | 67641 | 2 | 1.000 | 67641.0 |
148 | 2022-07-13 04:52:45 | spirometer | 3 | 140603 | 43 | 5.593 | 25139.1 |
147 | 2022-07-04 06:56:16 | spirometer | 1 | 67641 | 2 | 1.046 | 64666.3 |
146 | 2022-07-02 02:07:14 | spirometer | 1 | 67641 | 2 | 1.013 | 66773.0 |
145 | 2021-07-26 17:08:34 | spirometer | 1 | 67641 | 2 | 1.203 | 56226.9 |
144 | 2021-06-13 07:35:11 | spirometer | 1 | 67641 | 2 | 1.080 | 62630.6 |
143 | 2021-05-21 19:36:00 | spirometer | 1 | 67641 | 2 | 1.180 | 57322.9 |
142 | 2021-04-14 11:04:09 | spirometer | 4 | 161450 | 158 | 10.376 | 15559.9 |
141 | 2021-03-20 06:08:36 | spirometer | 1 | 67641 | 2 | 1.030 | 65670.9 |
140 | 2021-02-23 00:17:23 | spirometer | 1 | 67641 | 2 | 1.466 | 46139.8 |
139 | 2021-02-21 00:07:36 | spirometer | 4 | 161450 | 158 | 10.050 | 16064.7 |
138 | 2020-12-05 06:22:54 | spirometer | 1 | 67641 | 2 | 1.046 | 64666.3 |
137 | 2020-11-14 20:15:20 | spirometer | 1 | 67641 | 2 | 1.343 | 50365.6 |
136 | 2020-11-07 17:16:47 | spirometer | 4 | 161450 | 158 | 9.923 | 16270.3 |
135 | 2020-11-02 07:20:16 | spirometer | 2 | 108824 | 7 | 2.810 | 38727.4 |
134 | 2020-10-28 12:51:50 | spirometer | 1 | 67641 | 2 | 1.140 | 59334.2 |
133 | 2020-08-15 20:32:53 | spirometer | 1 | 67641 | 2 | 1.016 | 66575.8 |
132 | 2020-03-30 02:44:37 | spirometer | 1 | 67641 | 2 | 1.156 | 58513.0 |
131 | 2020-03-25 03:54:21 | spirometer | 1 | 67641 | 2 | 1.060 | 63812.3 |
130 | 2020-02-26 15:47:10 | spirometer | 1 | 67641 | 2 | 1.156 | 58513.0 |
129 | 2020-02-26 02:49:56 | spirometer | 1 | 67641 | 2 | 1.346 | 50253.3 |
128 | 2020-02-22 17:09:53 | spirometer | 3 | 140603 | 43 | 11.343 | 12395.6 |
127 | 2020-02-15 01:54:38 | spirometer | 4 | 161450 | 158 | 13.173 | 12256.1 |
126 | 2020-02-13 07:05:00 | spirometer | 1 | 67641 | 2 | 1.156 | 58513.0 |
125 | 2020-02-11 15:19:52 | spirometer | 4 | 161450 | 158 | 13.406 | 12043.1 |
124 | 2020-02-06 01:21:10 | spirometer | 1 | 67641 | 2 | 1.280 | 52844.5 |
123 | 2020-01-31 05:42:17 | spirometer | 1 | 67641 | 2 | 1.296 | 52192.1 |
122 | 2020-01-30 16:52:48 | spirometer | 3 | 140603 | 43 | 7.453 | 18865.3 |
121 | 2020-01-30 13:38:09 | spirometer | 1 | 67641 | 2 | 1.233 | 54858.9 |
120 | 2020-01-29 05:59:40 | spirometer | 3 | 140603 | 43 | 7.936 | 17717.1 |
119 | 2020-01-29 01:20:34 | spirometer | 1 | 67641 | 2 | 2.750 | 24596.7 |
118 | 2020-01-28 04:38:02 | spirometer | 3 | 140603 | 43 | 8.343 | 16852.8 |
117 | 2020-01-21 03:50:40 | spirometer | 4 | 161450 | 158 | 34.546 | 4673.5 |
116 | 2020-01-20 23:24:09 | spirometer | 4 | 161450 | 158 | 17.706 | 9118.4 |
115 | 2020-01-20 17:22:31 | spirometer | 4 | 161450 | 158 | 31.956 | 5052.3 |
114 | 2020-01-20 17:21:32 | spirometer | 3 | 140603 | 43 | 15.016 | 9363.5 |
113 | 2020-01-20 17:21:27 | spirometer | 2 | 108824 | 7 | 6.856 | 15872.8 |
112 | 2020-01-20 12:56:23 | spirometer | 1 | 67641 | 2 | 2.516 | 26884.3 |
111 | 2020-01-17 21:14:54 | spirometer | 1 | 67641 | 2 | 1.000 | 67641.0 |
110 | 2020-01-04 18:48:09 | spirometer | 1 | 67641 | 2 | 2.483 | 27241.6 |
109 | 2020-01-02 00:32:15 | spirometer | 1 | 67641 | 2 | 2.390 | 28301.7 |
108 | 2019-12-21 22:57:43 | spirometer | 1 | 67641 | 2 | 1.016 | 66575.8 |
107 | 2019-09-20 20:13:59 | spirometer | 1 | 67641 | 2 | 0.946 | 71502.1 |
106 | 2019-07-22 23:32:38 | spirometer | 1 | 67641 | 2 | 1.050 | 64420.0 |
105 | 2019-06-14 23:44:29 | spirometer | 1 | 67641 | 2 | 1.106 | 61158.2 |
104 | 2019-03-14 00:23:34 | spirometer | 1 | 67641 | 2 | 1.110 | 60937.8 |
103 | 2019-02-24 10:30:12 | spirometer | 1 | 67641 | 2 | 1.116 | 60610.2 |
102 | 2018-11-01 14:51:31 | spirometer | 1 | 67641 | 2 | 1.140 | 59334.2 |
101 | 2018-07-25 14:00:09 | spirometer | 1 | 67641 | 2 | 1.033 | 65480.2 |
100 | 2017-11-30 14:31:17 | spirometer | 1 | 67641 | 2 | 1.960 | 34510.7 |