History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lampoonery"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
191 | 2024-06-01 20:20:32 | lampoonery | 1 | 67641 | 3 | 1.126 | 60071.9 |
190 | 2024-05-31 05:52:15 | lampoonery | 1 | 67641 | 3 | 1.186 | 57032.9 |
189 | 2024-05-30 19:25:03 | lampoonery | 4 | 161450 | 44 | 18.513 | 8720.9 |
188 | 2024-05-30 19:24:05 | lampoonery | 4 | 161450 | 44 | 10.093 | 15996.2 |
187 | 2024-05-19 09:55:24 | lampoonery | 2 | 108824 | 4 | 9.580 | 11359.5 |
186 | 2024-05-19 09:50:49 | lampoonery | 1 | 67641 | 3 | 3.813 | 17739.6 |
185 | 2024-05-14 17:16:35 | lampoonery | 3 | 140603 | 11 | 19.733 | 7125.3 |
184 | 2024-05-12 04:34:04 | lampoonery | 4 | 161450 | 44 | 31.566 | 5114.7 |
183 | 2024-05-12 04:34:03 | lampoonery | 4 | 161450 | 44 | 17.423 | 9266.5 |
182 | 2024-05-12 04:34:00 | lampoonery | 3 | 140603 | 11 | 15.690 | 8961.3 |
181 | 2024-05-12 04:33:57 | lampoonery | 2 | 108824 | 4 | 7.143 | 15235.1 |
180 | 2024-05-12 04:29:52 | lampoonery | 1 | 67641 | 3 | 1.126 | 60071.9 |
179 | 2024-05-12 04:29:41 | lampoonery | 1 | 67641 | 3 | 2.076 | 32582.4 |
178 | 2024-05-09 08:09:12 | lampoonery | 4 | 161450 | 44 | 35.643 | 4529.6 |
177 | 2024-05-09 08:08:35 | lampoonery | 1 | 67641 | 3 | 3.890 | 17388.4 |
176 | 2024-05-01 14:32:06 | lampoonery | 1 | 67641 | 3 | 1.220 | 55443.4 |
175 | 2024-05-01 03:19:29 | lampoonery | 1 | 67641 | 3 | 1.060 | 63812.3 |
174 | 2024-05-01 02:54:53 | lampoonery | 4 | 161450 | 44 | 11.143 | 14488.9 |
173 | 2024-04-11 22:17:43 | lampoonery | 5 | 173545 | 455 | 61.880 | 2804.5 |
172 | 2024-04-09 23:54:49 | lampoonery | 1 | 67641 | 3 | 3.906 | 17317.2 |
171 | 2024-04-08 18:08:25 | lampoonery | 5 | 173545 | 455 | 51.596 | 3363.5 |
170 | 2024-04-08 18:08:32 | lampoonery | 3 | 140603 | 11 | 20.953 | 6710.4 |
169 | 2024-04-08 18:08:24 | lampoonery | 4 | 161450 | 44 | 23.796 | 6784.8 |
168 | 2024-04-08 18:08:27 | lampoonery | 2 | 108824 | 4 | 8.546 | 12733.9 |
167 | 2024-04-08 18:07:55 | lampoonery | 1 | 67641 | 3 | 6.923 | 9770.5 |
166 | 2024-04-08 18:07:48 | lampoonery | 1 | 67641 | 3 | 1.283 | 52721.0 |
165 | 2024-03-19 22:47:18 | lampoonery | 1 | 67641 | 3 | 1.076 | 62863.4 |
164 | 2024-03-11 19:15:33 | lampoonery | 1 | 67641 | 3 | 3.080 | 21961.4 |
163 | 2024-03-07 17:53:16 | lampoonery | 1 | 67641 | 3 | 2.423 | 27916.2 |
162 | 2024-03-02 12:14:38 | lampoonery | 1 | 67641 | 3 | 1.203 | 56226.9 |
161 | 2024-03-01 16:23:37 | lampoonery | 1 | 67641 | 3 | 1.216 | 55625.8 |
160 | 2024-02-09 20:31:54 | lampoonery | 1 | 67641 | 3 | 1.156 | 58513.0 |
159 | 2024-02-06 09:59:06 | lampoonery | 1 | 67641 | 3 | 1.110 | 60937.8 |
158 | 2024-02-06 09:59:02 | lampoonery | 1 | 67641 | 3 | 1.000 | 67641.0 |
157 | 2024-01-31 14:30:07 | lampoonery | 1 | 67641 | 3 | 1.140 | 59334.2 |
156 | 2024-01-31 10:22:54 | lampoonery | 1 | 67641 | 3 | 1.170 | 57812.8 |
155 | 2024-01-20 06:08:27 | lampoonery | 3 | 140603 | 11 | 5.236 | 26853.1 |
154 | 2024-01-14 14:20:50 | lampoonery | 5 | 173545 | 455 | 16.393 | 10586.5 |
153 | 2024-01-07 09:22:18 | lampoonery | 1 | 67641 | 3 | 1.123 | 60232.4 |
152 | 2023-12-23 14:15:30 | lampoonery | 1 | 67641 | 3 | 1.016 | 66575.8 |
151 | 2023-12-20 11:44:15 | lampoonery | 4 | 161450 | 44 | 9.486 | 17019.8 |
150 | 2023-12-08 03:15:22 | lampoonery | 1 | 67641 | 3 | 1.110 | 60937.8 |
149 | 2023-11-23 15:44:14 | lampoonery | 1 | 67641 | 3 | 1.203 | 56226.9 |
148 | 2023-11-23 14:43:28 | lampoonery | 5 | 173545 | 455 | 19.533 | 8884.7 |
147 | 2023-11-23 14:43:26 | lampoonery | 3 | 140603 | 11 | 6.140 | 22899.5 |
146 | 2023-11-16 01:10:06 | lampoonery | 5 | 173545 | 455 | 41.956 | 4136.4 |
145 | 2023-11-15 05:47:40 | lampoonery | 1 | 67641 | 3 | 1.000 | 67641.0 |
144 | 2023-11-01 00:37:24 | lampoonery | 3 | 140603 | 11 | 6.423 | 21890.5 |
143 | 2023-10-26 21:04:41 | lampoonery | 5 | 173545 | 455 | 40.470 | 4288.2 |
142 | 2023-10-23 01:40:36 | lampoonery | 5 | 173545 | 455 | 15.110 | 11485.4 |
141 | 2023-09-27 10:06:48 | lampoonery | 1 | 67641 | 3 | 1.123 | 60232.4 |
140 | 2023-09-21 18:02:34 | lampoonery | 1 | 67641 | 3 | 1.013 | 66773.0 |
139 | 2023-09-20 06:46:04 | lampoonery | 4 | 161450 | 44 | 10.096 | 15991.5 |
138 | 2023-08-07 05:35:07 | lampoonery | 3 | 140603 | 11 | 5.313 | 26464.0 |
137 | 2023-08-01 08:30:53 | lampoonery | 5 | 173545 | 455 | 16.316 | 10636.5 |
136 | 2023-07-16 00:38:59 | lampoonery | 1 | 67641 | 3 | 1.170 | 57812.8 |
135 | 2023-07-07 16:01:16 | lampoonery | 1 | 67641 | 3 | 2.110 | 32057.3 |
134 | 2023-06-26 03:53:56 | lampoonery | 4 | 161450 | 44 | 12.000 | 13454.2 |
133 | 2023-04-22 12:13:02 | lampoonery | 1 | 67641 | 3 | 1.110 | 60937.8 |
132 | 2023-04-19 23:10:00 | lampoonery | 3 | 140603 | 11 | 5.310 | 26478.9 |
131 | 2023-04-11 23:49:36 | lampoonery | 5 | 173545 | 455 | 14.376 | 12071.9 |
130 | 2023-03-19 16:02:59 | lampoonery | 4 | 161450 | 44 | 9.470 | 17048.6 |
129 | 2023-02-11 06:32:24 | lampoonery | 1 | 67641 | 3 | 2.186 | 30942.8 |
128 | 2023-01-28 10:56:04 | lampoonery | 1 | 67641 | 3 | 0.966 | 70021.7 |
127 | 2023-01-22 05:15:16 | lampoonery | 3 | 140603 | 11 | 5.206 | 27007.9 |
126 | 2023-01-16 19:26:36 | lampoonery | 5 | 173545 | 455 | 21.313 | 8142.7 |
125 | 2022-12-20 01:10:19 | lampoonery | 4 | 161450 | 44 | 9.283 | 17392.0 |
124 | 2022-12-08 16:43:31 | lampoonery | 1 | 67641 | 3 | 0.970 | 69733.0 |
123 | 2022-11-03 06:48:49 | lampoonery | 3 | 140603 | 11 | 5.343 | 26315.4 |
122 | 2022-10-27 16:51:32 | lampoonery | 5 | 173545 | 455 | 14.296 | 12139.4 |
121 | 2022-08-15 08:25:53 | lampoonery | 1 | 67641 | 3 | 1.110 | 60937.8 |
120 | 2022-08-13 04:36:29 | lampoonery | 4 | 161450 | 44 | 9.220 | 17510.8 |
119 | 2022-08-10 06:35:15 | lampoonery | 1 | 67641 | 3 | 1.000 | 67641.0 |
118 | 2022-07-03 05:11:48 | lampoonery | 2 | 108824 | 4 | 2.813 | 38686.1 |
117 | 2022-06-03 23:46:59 | lampoonery | 3 | 140603 | 11 | 5.393 | 26071.4 |
116 | 2022-05-23 16:34:21 | lampoonery | 5 | 173545 | 455 | 14.986 | 11580.5 |
115 | 2022-04-01 17:51:02 | lampoonery | 1 | 67641 | 3 | 1.126 | 60071.9 |
114 | 2022-03-30 15:02:38 | lampoonery | 1 | 67641 | 3 | 1.500 | 45094.0 |
113 | 2022-02-25 13:47:17 | lampoonery | 1 | 67641 | 3 | 1.330 | 50857.9 |
112 | 2021-09-16 10:51:06 | lampoonery | 1 | 67641 | 3 | 1.063 | 63632.2 |
111 | 2021-05-23 19:14:18 | lampoonery | 1 | 67641 | 3 | 1.000 | 67641.0 |
110 | 2021-05-03 14:55:48 | lampoonery | 1 | 67641 | 3 | 1.140 | 59334.2 |
109 | 2021-01-30 23:13:16 | lampoonery | 1 | 67641 | 3 | 1.013 | 66773.0 |
108 | 2021-01-18 00:43:23 | lampoonery | 1 | 67641 | 3 | 1.733 | 39031.2 |
107 | 2021-01-16 22:08:15 | lampoonery | 1 | 67641 | 3 | 1.000 | 67641.0 |
106 | 2020-11-22 04:49:13 | lampoonery | 1 | 67641 | 3 | 1.093 | 61885.6 |
105 | 2020-10-29 04:04:42 | lampoonery | 3 | 140603 | 11 | 6.140 | 22899.5 |
104 | 2020-10-28 11:53:12 | lampoonery | 4 | 161450 | 44 | 9.986 | 16167.6 |
103 | 2020-10-27 09:08:55 | lampoonery | 1 | 67641 | 3 | 1.733 | 39031.2 |
102 | 2020-10-22 19:41:46 | lampoonery | 1 | 67641 | 3 | 1.076 | 62863.4 |
101 | 2020-10-06 11:28:17 | lampoonery | 1 | 67641 | 3 | 1.093 | 61885.6 |
100 | 2020-09-25 11:15:48 | lampoonery | 1 | 67641 | 3 | 2.000 | 33820.5 |
99 | 2020-05-14 09:42:35 | lampoonery | 1 | 67641 | 3 | 1.033 | 65480.2 |
98 | 2020-03-28 20:40:00 | lampoonery | 1 | 67641 | 3 | 1.296 | 52192.1 |
97 | 2020-02-17 02:08:34 | lampoonery | 1 | 67641 | 3 | 2.623 | 25787.6 |
96 | 2020-02-12 00:45:00 | lampoonery | 1 | 67641 | 3 | 2.610 | 25916.1 |
95 | 2020-02-11 05:56:15 | lampoonery | 1 | 67641 | 3 | 2.423 | 27916.2 |
94 | 2020-01-18 19:34:23 | lampoonery | 1 | 67641 | 3 | 3.016 | 22427.4 |
93 | 2020-01-16 00:39:16 | lampoonery | 1 | 67641 | 3 | 2.440 | 27721.7 |
92 | 2020-01-14 12:50:06 | lampoonery | 1 | 67641 | 3 | 1.250 | 54112.8 |