History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"luminaire"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
179 | 2024-04-27 09:32:55 | luminaire | 1 | 81242 | 2 | 1.406 | 57782.4 |
178 | 2024-04-01 08:35:22 | luminaire | 4 | 165329 | 162 | 22.126 | 7472.2 |
177 | 2024-04-01 08:35:40 | luminaire | 1 | 81242 | 2 | 1.470 | 55266.7 |
176 | 2024-04-01 08:35:26 | luminaire | 3 | 148641 | 24 | 14.516 | 10239.8 |
175 | 2024-04-01 08:35:24 | luminaire | 2 | 121436 | 6 | 4.876 | 24904.8 |
174 | 2024-04-01 08:35:20 | luminaire | 1 | 81242 | 2 | 1.656 | 49059.2 |
173 | 2024-03-21 18:47:48 | luminaire | 3 | 148641 | 24 | 17.503 | 8492.3 |
172 | 2024-03-21 18:47:46 | luminaire | 2 | 121436 | 6 | 8.500 | 14286.6 |
171 | 2024-03-21 18:34:37 | luminaire | 1 | 81242 | 2 | 1.440 | 56418.1 |
170 | 2024-03-20 23:17:26 | luminaire | 4 | 165329 | 162 | 37.923 | 4359.6 |
169 | 2024-03-20 22:54:10 | luminaire | 4 | 165329 | 162 | 19.843 | 8331.9 |
168 | 2024-03-20 06:18:48 | luminaire | 4 | 165329 | 162 | 39.160 | 4221.9 |
167 | 2024-03-20 06:18:49 | luminaire | 3 | 148641 | 24 | 17.156 | 8664.1 |
166 | 2024-03-20 06:18:48 | luminaire | 2 | 121436 | 6 | 8.296 | 14637.9 |
165 | 2024-03-20 06:04:44 | luminaire | 1 | 81242 | 2 | 1.483 | 54782.2 |
164 | 2024-03-13 04:23:52 | luminaire | 1 | 81242 | 2 | 1.393 | 58321.6 |
163 | 2024-03-10 12:18:18 | luminaire | 1 | 81242 | 2 | 2.656 | 30588.1 |
162 | 2024-03-07 11:55:27 | luminaire | 1 | 81242 | 2 | 2.216 | 36661.6 |
161 | 2024-02-16 03:41:59 | luminaire | 1 | 81242 | 2 | 4.703 | 17274.5 |
160 | 2024-02-01 06:22:16 | luminaire | 1 | 81242 | 2 | 2.656 | 30588.1 |
159 | 2024-01-30 11:03:51 | luminaire | 1 | 81242 | 2 | 1.436 | 56575.2 |
158 | 2024-01-30 11:03:21 | luminaire | 1 | 81242 | 2 | 1.343 | 60492.9 |
157 | 2024-01-29 16:34:59 | luminaire | 1 | 81242 | 2 | 2.720 | 29868.4 |
156 | 2024-01-01 12:39:15 | luminaire | 3 | 148641 | 24 | 6.093 | 24395.4 |
155 | 2023-12-31 05:59:54 | luminaire | 2 | 121436 | 6 | 3.203 | 37913.2 |
154 | 2023-12-15 22:54:34 | luminaire | 1 | 81242 | 2 | 1.266 | 64172.2 |
153 | 2023-11-25 07:54:47 | luminaire | 1 | 81242 | 2 | 1.186 | 68500.8 |
152 | 2023-10-31 04:51:56 | luminaire | 1 | 81242 | 2 | 1.346 | 60358.1 |
151 | 2023-10-05 18:20:47 | luminaire | 3 | 148641 | 24 | 7.203 | 20636.0 |
150 | 2023-10-03 11:47:47 | luminaire | 2 | 121436 | 6 | 4.796 | 25320.3 |
149 | 2023-09-12 06:36:15 | luminaire | 1 | 81242 | 2 | 1.233 | 65889.7 |
148 | 2023-07-15 17:05:58 | luminaire | 3 | 148641 | 24 | 7.186 | 20684.8 |
147 | 2023-07-14 07:23:27 | luminaire | 2 | 121436 | 6 | 3.436 | 35342.3 |
146 | 2023-06-16 11:58:05 | luminaire | 1 | 81242 | 2 | 1.186 | 68500.8 |
145 | 2023-04-05 23:25:29 | luminaire | 3 | 148641 | 24 | 5.813 | 25570.4 |
144 | 2023-04-01 05:52:31 | luminaire | 2 | 121436 | 6 | 3.346 | 36292.9 |
143 | 2023-03-31 16:49:59 | luminaire | 1 | 81242 | 2 | 1.393 | 58321.6 |
142 | 2023-01-14 08:41:20 | luminaire | 1 | 81242 | 2 | 1.203 | 67532.8 |
141 | 2023-01-03 22:47:58 | luminaire | 3 | 148641 | 24 | 6.203 | 23962.8 |
140 | 2022-12-27 14:13:26 | luminaire | 2 | 121436 | 6 | 2.906 | 41788.0 |
139 | 2022-11-01 20:59:30 | luminaire | 1 | 81242 | 2 | 1.236 | 65729.8 |
138 | 2022-09-09 14:00:02 | luminaire | 3 | 148641 | 24 | 6.220 | 23897.3 |
137 | 2022-08-26 06:47:30 | luminaire | 2 | 121436 | 6 | 3.500 | 34696.0 |
136 | 2022-06-20 23:08:53 | luminaire | 1 | 81242 | 2 | 1.220 | 66591.8 |
135 | 2022-03-19 13:17:18 | luminaire | 4 | 165329 | 162 | 10.673 | 15490.4 |
134 | 2022-02-28 10:21:07 | luminaire | 1 | 81242 | 2 | 1.563 | 51978.2 |
133 | 2021-12-19 10:15:48 | luminaire | 1 | 81242 | 2 | 2.893 | 28082.3 |
132 | 2021-12-17 07:56:13 | luminaire | 1 | 81242 | 2 | 1.423 | 57092.1 |
131 | 2021-11-07 18:44:56 | luminaire | 1 | 81242 | 2 | 1.420 | 57212.7 |
130 | 2021-04-06 20:39:03 | luminaire | 1 | 81242 | 2 | 1.280 | 63470.3 |
129 | 2021-01-22 00:35:54 | luminaire | 1 | 81242 | 2 | 1.250 | 64993.6 |
128 | 2020-11-02 01:50:02 | luminaire | 1 | 81242 | 2 | 1.420 | 57212.7 |
127 | 2020-10-06 02:01:32 | luminaire | 1 | 81242 | 2 | 2.436 | 33350.6 |
126 | 2020-04-02 15:47:15 | luminaire | 1 | 81242 | 2 | 1.263 | 64324.6 |
125 | 2020-02-18 03:54:04 | luminaire | 1 | 81242 | 2 | 2.763 | 29403.5 |
124 | 2020-02-09 15:01:07 | luminaire | 4 | 165329 | 162 | 24.546 | 6735.5 |
123 | 2020-02-09 00:18:35 | luminaire | 1 | 81242 | 2 | 1.406 | 57782.4 |
122 | 2020-02-04 06:50:07 | luminaire | 3 | 148641 | 24 | 16.766 | 8865.6 |
121 | 2020-02-03 14:37:48 | luminaire | 1 | 81242 | 2 | 2.033 | 39961.6 |
120 | 2020-02-02 01:38:01 | luminaire | 1 | 81242 | 2 | 1.736 | 46798.4 |
119 | 2020-02-01 10:12:51 | luminaire | 1 | 81242 | 2 | 1.470 | 55266.7 |
118 | 2020-01-23 21:26:36 | luminaire | 1 | 81242 | 2 | 5.593 | 14525.7 |
117 | 2020-01-23 17:16:34 | luminaire | 3 | 148641 | 24 | 9.673 | 15366.6 |
116 | 2020-01-20 05:12:37 | luminaire | 4 | 165329 | 162 | 11.516 | 14356.5 |
115 | 2020-01-19 18:57:42 | luminaire | 4 | 165329 | 162 | 19.910 | 8303.8 |
114 | 2020-01-19 08:14:58 | luminaire | 4 | 165329 | 162 | 13.250 | 12477.7 |
113 | 2020-01-19 08:12:39 | luminaire | 3 | 148641 | 24 | 7.030 | 21143.8 |
112 | 2020-01-19 03:14:00 | luminaire | 1 | 81242 | 2 | 1.406 | 57782.4 |
111 | 2020-01-06 22:13:43 | luminaire | 1 | 81242 | 2 | 2.733 | 29726.3 |
110 | 2020-01-02 14:37:36 | luminaire | 1 | 81242 | 2 | 1.533 | 52995.4 |
109 | 2019-12-19 18:45:48 | luminaire | 1 | 81242 | 2 | 1.220 | 66591.8 |
108 | 2019-09-18 12:47:05 | luminaire | 1 | 81242 | 2 | 1.283 | 63321.9 |
107 | 2019-07-23 18:28:00 | luminaire | 1 | 81242 | 2 | 1.210 | 67142.1 |
106 | 2019-06-12 16:16:44 | luminaire | 1 | 81242 | 2 | 1.376 | 59042.2 |
105 | 2019-02-22 02:21:36 | luminaire | 1 | 81242 | 2 | 1.300 | 62493.8 |
104 | 2019-01-03 08:19:29 | luminaire | 1 | 81242 | 2 | 1.220 | 66591.8 |
103 | 2018-11-15 09:40:17 | luminaire | 1 | 81242 | 2 | 1.210 | 67142.1 |
102 | 2018-10-30 09:13:09 | luminaire | 1 | 81242 | 2 | 1.273 | 63819.3 |
101 | 2018-08-23 21:29:45 | luminaire | 1 | 81242 | 2 | 1.186 | 68500.8 |
100 | 2018-07-23 06:10:53 | luminaire | 1 | 81242 | 2 | 1.423 | 57092.1 |
99 | 2018-06-23 19:52:23 | luminaire | 1 | 81242 | 2 | 1.480 | 54893.2 |
98 | 2018-06-23 16:05:04 | luminaire | 1 | 81242 | 2 | 1.166 | 69675.8 |
97 | 2018-06-23 15:29:24 | luminaire | 1 | 81242 | 2 | 1.313 | 61875.1 |
96 | 2018-06-23 12:59:27 | luminaire | 1 | 81242 | 2 | 1.316 | 61734.0 |
95 | 2018-05-22 00:23:15 | luminaire | 1 | 81242 | 2 | 1.223 | 66428.5 |
94 | 2018-03-25 02:28:16 | luminaire | 1 | 81242 | 2 | 4.210 | 19297.4 |
93 | 2017-12-14 23:47:02 | luminaire | 1 | 81242 | 2 | 1.610 | 50460.9 |
92 | 2017-11-09 16:35:16 | luminaire | 1 | 81242 | 2 | 2.366 | 34337.3 |
91 | 2017-10-31 23:32:06 | luminaire | 1 | 81242 | 2 | 1.680 | 48358.3 |
90 | 2017-10-27 17:08:58 | luminaire | 1 | 81242 | 2 | 2.240 | 36268.8 |
89 | 2017-10-20 00:09:59 | luminaire | 4 | 165329 | 162 | 15.240 | 10848.4 |
88 | 2017-10-19 02:07:14 | luminaire | 1 | 81242 | 2 | 1.653 | 49148.2 |
87 | 2017-07-15 05:46:09 | luminaire | 1 | 81242 | 2 | 2.100 | 38686.7 |
86 | 2017-05-18 18:21:04 | luminaire | 1 | 81242 | 2 | 4.610 | 17623.0 |
85 | 2017-03-26 18:48:57 | luminaire | 1 | 81242 | 2 | 1.616 | 50273.5 |
84 | 2017-03-24 04:14:10 | luminaire | 1 | 81242 | 2 | 2.060 | 39437.9 |
83 | 2016-10-25 05:07:33 | luminaire | 1 | 81242 | 2 | 1.683 | 48272.1 |
82 | 2016-10-14 23:33:22 | luminaire | 1 | 81242 | 2 | 1.703 | 47705.2 |
81 | 2016-10-03 11:57:57 | luminaire | 1 | 81242 | 2 | 1.763 | 46081.7 |
80 | 2016-07-28 08:51:10 | luminaire | 3 | 148641 | 24 | 10.393 | 14302.0 |