History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lighthouse"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
194 | 2024-03-25 10:16:39 | lighthouse | 1 | 67641 | 2 | 1.110 | 60937.8 |
193 | 2024-03-18 06:34:29 | lighthouse | 5 | 173545 | 369 | 42.096 | 4122.6 |
192 | 2024-03-16 08:15:00 | lighthouse | 5 | 173545 | 369 | 62.490 | 2777.2 |
191 | 2024-03-15 16:30:00 | lighthouse | 4 | 161450 | 68 | 14.050 | 11491.1 |
190 | 2024-03-15 13:15:19 | lighthouse | 5 | 173545 | 369 | 44.270 | 3920.1 |
189 | 2024-03-15 01:14:54 | lighthouse | 4 | 161450 | 68 | 26.173 | 6168.6 |
188 | 2024-03-13 14:18:11 | lighthouse | 4 | 161450 | 68 | 14.203 | 11367.3 |
187 | 2024-03-12 18:30:17 | lighthouse | 5 | 173545 | 369 | 45.363 | 3825.7 |
186 | 2024-03-12 18:30:20 | lighthouse | 4 | 161450 | 68 | 35.453 | 4553.9 |
185 | 2024-03-12 18:30:23 | lighthouse | 3 | 140603 | 5 | 15.656 | 8980.8 |
184 | 2024-03-12 18:30:24 | lighthouse | 2 | 108824 | 2 | 3.436 | 31671.7 |
183 | 2024-03-12 18:28:58 | lighthouse | 1 | 67641 | 2 | 1.190 | 56841.2 |
182 | 2024-03-11 20:19:31 | lighthouse | 3 | 140603 | 5 | 21.140 | 6651.0 |
181 | 2024-03-11 20:19:31 | lighthouse | 2 | 108824 | 2 | 10.406 | 10457.8 |
180 | 2024-03-11 18:36:16 | lighthouse | 1 | 67641 | 2 | 1.640 | 41244.5 |
179 | 2024-02-21 03:45:21 | lighthouse | 3 | 140603 | 5 | 11.923 | 11792.6 |
178 | 2024-02-21 03:45:20 | lighthouse | 4 | 161450 | 68 | 12.610 | 12803.3 |
177 | 2024-02-21 03:45:20 | lighthouse | 2 | 108824 | 2 | 6.873 | 15833.6 |
176 | 2024-02-21 00:38:46 | lighthouse | 1 | 67641 | 2 | 1.123 | 60232.4 |
175 | 2024-02-16 13:47:03 | lighthouse | 5 | 173545 | 369 | 48.126 | 3606.1 |
174 | 2024-02-15 11:42:54 | lighthouse | 3 | 140603 | 5 | 12.360 | 11375.6 |
173 | 2024-02-15 11:42:51 | lighthouse | 2 | 108824 | 2 | 3.436 | 31671.7 |
172 | 2024-02-15 11:36:19 | lighthouse | 1 | 67641 | 2 | 1.153 | 58665.2 |
171 | 2024-02-14 07:22:58 | lighthouse | 3 | 140603 | 5 | 12.423 | 11318.0 |
170 | 2024-02-14 07:22:58 | lighthouse | 2 | 108824 | 2 | 3.563 | 30542.8 |
169 | 2024-02-14 07:20:39 | lighthouse | 1 | 67641 | 2 | 2.456 | 27541.1 |
168 | 2024-02-14 07:18:50 | lighthouse | 4 | 161450 | 68 | 25.190 | 6409.3 |
167 | 2024-02-14 07:05:06 | lighthouse | 5 | 173545 | 369 | 47.113 | 3683.6 |
166 | 2024-02-14 02:35:08 | lighthouse | 5 | 173545 | 369 | 38.783 | 4474.8 |
165 | 2024-02-14 02:34:12 | lighthouse | 4 | 161450 | 68 | 15.423 | 10468.1 |
164 | 2024-02-11 09:14:51 | lighthouse | 4 | 161450 | 68 | 41.753 | 3866.8 |
163 | 2024-02-11 09:14:51 | lighthouse | 5 | 173545 | 369 | 37.453 | 4633.7 |
162 | 2024-02-11 09:15:08 | lighthouse | 3 | 140603 | 5 | 8.046 | 17474.9 |
161 | 2024-02-11 09:15:03 | lighthouse | 2 | 108824 | 2 | 6.780 | 16050.7 |
160 | 2024-02-11 07:15:33 | lighthouse | 5 | 173545 | 369 | 46.533 | 3729.5 |
159 | 2024-02-11 07:15:27 | lighthouse | 3 | 140603 | 5 | 17.033 | 8254.7 |
158 | 2024-02-11 07:15:30 | lighthouse | 4 | 161450 | 68 | 13.203 | 12228.3 |
157 | 2024-02-11 07:15:26 | lighthouse | 2 | 108824 | 2 | 3.423 | 31792.0 |
156 | 2024-02-11 05:22:06 | lighthouse | 1 | 67641 | 2 | 1.796 | 37662.0 |
155 | 2024-02-11 03:20:33 | lighthouse | 1 | 67641 | 2 | 0.983 | 68810.8 |
154 | 2024-01-13 14:13:12 | lighthouse | 1 | 67641 | 2 | 1.016 | 66575.8 |
153 | 2024-01-12 21:07:56 | lighthouse | 1 | 67641 | 2 | 1.063 | 63632.2 |
152 | 2023-12-05 10:08:15 | lighthouse | 1 | 67641 | 2 | 1.076 | 62863.4 |
151 | 2023-12-03 06:59:32 | lighthouse | 1 | 67641 | 2 | 0.970 | 69733.0 |
150 | 2023-11-06 21:58:19 | lighthouse | 1 | 67641 | 2 | 1.093 | 61885.6 |
149 | 2023-08-28 20:54:14 | lighthouse | 1 | 67641 | 2 | 0.970 | 69733.0 |
148 | 2023-05-30 23:59:33 | lighthouse | 1 | 67641 | 2 | 1.000 | 67641.0 |
147 | 2023-03-24 14:23:33 | lighthouse | 1 | 67641 | 2 | 0.970 | 69733.0 |
146 | 2023-01-08 21:37:39 | lighthouse | 1 | 67641 | 2 | 1.063 | 63632.2 |
145 | 2022-10-17 00:21:22 | lighthouse | 1 | 67641 | 2 | 0.970 | 69733.0 |
144 | 2022-06-07 18:43:02 | lighthouse | 1 | 67641 | 2 | 0.983 | 68810.8 |
143 | 2022-02-17 14:40:06 | lighthouse | 1 | 67641 | 2 | 1.123 | 60232.4 |
142 | 2022-02-15 09:52:02 | lighthouse | 1 | 67641 | 2 | 1.013 | 66773.0 |
141 | 2021-12-21 13:00:30 | lighthouse | 1 | 67641 | 2 | 1.093 | 61885.6 |
140 | 2020-04-03 03:16:59 | lighthouse | 1 | 67641 | 2 | 1.046 | 64666.3 |
139 | 2020-03-26 02:53:15 | lighthouse | 1 | 67641 | 2 | 1.326 | 51011.3 |
138 | 2020-02-29 04:01:06 | lighthouse | 1 | 67641 | 2 | 1.360 | 49736.0 |
137 | 2020-02-29 03:00:22 | lighthouse | 1 | 67641 | 2 | 1.140 | 59334.2 |
136 | 2020-02-28 04:36:20 | lighthouse | 1 | 67641 | 2 | 2.233 | 30291.5 |
135 | 2020-02-13 08:30:25 | lighthouse | 1 | 67641 | 2 | 1.173 | 57665.0 |
134 | 2020-02-09 17:33:22 | lighthouse | 1 | 67641 | 2 | 1.126 | 60071.9 |
133 | 2020-02-09 03:27:25 | lighthouse | 1 | 67641 | 2 | 1.266 | 53428.9 |
132 | 2020-02-08 20:58:09 | lighthouse | 1 | 67641 | 2 | 1.953 | 34634.4 |
131 | 2020-01-18 09:58:36 | lighthouse | 1 | 67641 | 2 | 2.046 | 33060.1 |
130 | 2020-01-11 00:39:40 | lighthouse | 1 | 67641 | 2 | 2.423 | 27916.2 |
129 | 2020-01-07 13:20:11 | lighthouse | 1 | 67641 | 2 | 3.140 | 21541.7 |
128 | 2019-12-17 08:22:45 | lighthouse | 1 | 67641 | 2 | 1.126 | 60071.9 |
127 | 2019-09-15 22:46:31 | lighthouse | 1 | 67641 | 2 | 0.930 | 72732.3 |
126 | 2019-09-09 18:40:57 | lighthouse | 1 | 67641 | 2 | 0.950 | 71201.1 |
125 | 2019-05-28 17:43:52 | lighthouse | 1 | 67641 | 2 | 1.216 | 55625.8 |
124 | 2019-01-28 08:25:58 | lighthouse | 1 | 67641 | 2 | 0.943 | 71729.6 |
123 | 2018-09-19 08:12:57 | lighthouse | 1 | 67641 | 2 | 1.153 | 58665.2 |
122 | 2018-06-24 11:59:02 | lighthouse | 1 | 67641 | 2 | 0.943 | 71729.6 |
121 | 2018-06-17 11:23:20 | lighthouse | 1 | 67641 | 2 | 1.093 | 61885.6 |
120 | 2018-06-15 19:13:34 | lighthouse | 1 | 67641 | 2 | 1.153 | 58665.2 |
119 | 2017-12-28 11:57:51 | lighthouse | 1 | 67641 | 2 | 1.390 | 48662.6 |
118 | 2017-12-19 14:02:58 | lighthouse | 1 | 67641 | 2 | 2.413 | 28031.9 |
117 | 2017-12-19 13:33:13 | lighthouse | 1 | 67641 | 2 | 1.573 | 43001.3 |
116 | 2017-11-26 10:38:46 | lighthouse | 1 | 67641 | 2 | 1.826 | 37043.3 |
115 | 2017-11-24 19:49:31 | lighthouse | 1 | 67641 | 2 | 1.726 | 39189.5 |
114 | 2017-11-12 09:51:45 | lighthouse | 1 | 67641 | 2 | 2.200 | 30745.9 |
113 | 2017-10-13 09:57:03 | lighthouse | 1 | 67641 | 2 | 1.410 | 47972.3 |
112 | 2017-06-30 08:07:38 | lighthouse | 5 | 173545 | 369 | 20.790 | 8347.5 |
111 | 2017-06-16 11:36:47 | lighthouse | 5 | 173545 | 369 | 36.203 | 4793.7 |
110 | 2017-06-14 10:40:46 | lighthouse | 5 | 173545 | 369 | 26.586 | 6527.7 |
109 | 2017-06-05 15:03:27 | lighthouse | 5 | 173545 | 369 | 25.353 | 6845.1 |
108 | 2017-06-05 14:59:16 | lighthouse | 5 | 173545 | 369 | 19.726 | 8797.8 |
107 | 2017-05-25 10:00:16 | lighthouse | 5 | 173545 | 369 | 39.460 | 4398.0 |
106 | 2017-05-23 08:20:51 | lighthouse | 5 | 173545 | 369 | 23.110 | 7509.5 |
105 | 2017-05-22 07:43:59 | lighthouse | 5 | 173545 | 369 | 20.796 | 8345.1 |
104 | 2017-05-05 01:37:04 | lighthouse | 5 | 173545 | 369 | 18.700 | 9280.5 |
103 | 2017-04-28 07:06:21 | lighthouse | 5 | 173545 | 369 | 20.996 | 8265.6 |
102 | 2017-04-22 23:19:00 | lighthouse | 1 | 67641 | 2 | 1.230 | 54992.7 |
101 | 2017-04-16 14:27:51 | lighthouse | 5 | 173545 | 369 | 29.656 | 5851.9 |
100 | 2017-04-10 00:23:28 | lighthouse | 5 | 173545 | 369 | 18.946 | 9160.0 |
99 | 2017-04-07 16:12:08 | lighthouse | 5 | 173545 | 369 | 22.010 | 7884.8 |
98 | 2017-03-08 02:14:18 | lighthouse | 5 | 173545 | 369 | 26.246 | 6612.2 |
97 | 2017-03-04 14:45:33 | lighthouse | 5 | 173545 | 369 | 21.576 | 8043.4 |
96 | 2017-02-27 19:43:37 | lighthouse | 5 | 173545 | 369 | 26.086 | 6652.8 |
95 | 2017-02-24 22:51:39 | lighthouse | 5 | 173545 | 369 | 29.200 | 5943.3 |