History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"defendants"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 209 | 2024-04-26 09:31:03 | defendants | 1 | 67641 | 3 | 2.220 | 30468.9 |
| 208 | 2024-04-23 09:45:17 | defendants | 4 | 161450 | 130 | 36.720 | 4396.8 |
| 207 | 2024-04-22 00:16:39 | defendants | 4 | 161450 | 130 | 31.190 | 5176.3 |
| 206 | 2024-04-17 15:13:35 | defendants | 4 | 161450 | 130 | 24.080 | 6704.7 |
| 205 | 2024-04-17 15:13:33 | defendants | 3 | 140603 | 32 | 9.016 | 15594.8 |
| 204 | 2024-04-17 15:13:31 | defendants | 2 | 108824 | 8 | 5.703 | 19081.9 |
| 203 | 2024-04-17 13:14:14 | defendants | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 202 | 2024-04-13 10:03:57 | defendants | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 201 | 2024-04-08 06:14:24 | defendants | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 200 | 2024-04-01 07:44:19 | defendants | 4 | 161450 | 130 | 24.156 | 6683.6 |
| 199 | 2024-04-01 07:44:17 | defendants | 3 | 140603 | 32 | 19.563 | 7187.2 |
| 198 | 2024-04-01 07:44:12 | defendants | 2 | 108824 | 8 | 8.890 | 12241.2 |
| 197 | 2024-04-01 05:46:33 | defendants | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 196 | 2024-03-18 21:05:15 | defendants | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 195 | 2024-03-17 21:21:23 | defendants | 4 | 161450 | 130 | 21.563 | 7487.4 |
| 194 | 2024-03-17 21:21:27 | defendants | 3 | 140603 | 32 | 8.766 | 16039.6 |
| 193 | 2024-03-17 21:21:28 | defendants | 2 | 108824 | 8 | 4.860 | 22391.8 |
| 192 | 2024-03-17 21:19:49 | defendants | 1 | 67641 | 3 | 1.360 | 49736.0 |
| 191 | 2024-03-16 19:48:40 | defendants | 4 | 161450 | 130 | 39.580 | 4079.1 |
| 190 | 2024-03-16 18:27:33 | defendants | 4 | 161450 | 130 | 44.816 | 3602.5 |
| 189 | 2024-03-16 18:27:36 | defendants | 3 | 140603 | 32 | 17.796 | 7900.8 |
| 188 | 2024-03-16 18:27:34 | defendants | 2 | 108824 | 8 | 11.203 | 9713.8 |
| 187 | 2024-03-16 18:24:23 | defendants | 1 | 67641 | 3 | 1.326 | 51011.3 |
| 186 | 2024-03-07 20:19:09 | defendants | 1 | 67641 | 3 | 2.483 | 27241.6 |
| 185 | 2024-03-05 17:02:50 | defendants | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 184 | 2024-03-01 00:42:28 | defendants | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 183 | 2024-02-09 08:36:51 | defendants | 3 | 140603 | 32 | 7.360 | 19103.7 |
| 182 | 2024-02-08 07:56:05 | defendants | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 181 | 2024-02-06 03:32:30 | defendants | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 180 | 2024-01-31 20:18:16 | defendants | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 179 | 2024-01-30 16:18:35 | defendants | 1 | 67641 | 3 | 2.500 | 27056.4 |
| 178 | 2024-01-29 04:44:34 | defendants | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 177 | 2024-01-29 04:43:11 | defendants | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 176 | 2024-01-27 03:52:26 | defendants | 2 | 108824 | 8 | 3.110 | 34991.6 |
| 175 | 2024-01-13 03:37:38 | defendants | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 174 | 2024-01-08 00:24:21 | defendants | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 173 | 2023-12-26 02:26:36 | defendants | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 172 | 2023-12-05 04:32:55 | defendants | 1 | 67641 | 3 | 2.593 | 26086.0 |
| 171 | 2023-11-25 03:22:39 | defendants | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 170 | 2023-11-13 03:05:10 | defendants | 3 | 140603 | 32 | 5.813 | 24187.7 |
| 169 | 2023-11-06 15:01:49 | defendants | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 168 | 2023-11-02 08:13:12 | defendants | 2 | 108824 | 8 | 3.780 | 28789.4 |
| 167 | 2023-10-15 06:24:33 | defendants | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 166 | 2023-08-29 01:13:46 | defendants | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 165 | 2023-08-22 16:20:24 | defendants | 1 | 67641 | 3 | 1.106 | 61158.2 |
| 164 | 2023-08-15 19:27:55 | defendants | 3 | 140603 | 32 | 5.313 | 26464.0 |
| 163 | 2023-08-07 19:00:49 | defendants | 2 | 108824 | 8 | 2.640 | 41221.2 |
| 162 | 2023-05-28 23:22:42 | defendants | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 161 | 2023-04-30 16:40:03 | defendants | 3 | 140603 | 32 | 6.156 | 22840.0 |
| 160 | 2023-04-20 11:50:11 | defendants | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 159 | 2023-04-18 13:49:30 | defendants | 2 | 108824 | 8 | 2.580 | 42179.8 |
| 158 | 2023-03-25 17:36:08 | defendants | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 157 | 2023-02-07 23:20:07 | defendants | 3 | 140603 | 32 | 5.266 | 26700.2 |
| 156 | 2023-01-25 00:08:54 | defendants | 2 | 108824 | 8 | 2.563 | 42459.6 |
| 155 | 2023-01-09 17:39:45 | defendants | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 154 | 2022-12-17 04:10:39 | defendants | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 153 | 2022-11-19 17:09:48 | defendants | 3 | 140603 | 32 | 5.313 | 26464.0 |
| 152 | 2022-11-06 23:55:55 | defendants | 2 | 108824 | 8 | 2.593 | 41968.4 |
| 151 | 2022-10-12 02:06:12 | defendants | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 150 | 2022-09-05 23:34:04 | defendants | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 149 | 2022-07-24 13:01:03 | defendants | 1 | 67641 | 3 | 1.513 | 44706.5 |
| 148 | 2022-07-14 08:25:06 | defendants | 4 | 161450 | 130 | 9.470 | 17048.6 |
| 147 | 2022-06-22 20:02:41 | defendants | 3 | 140603 | 32 | 6.110 | 23011.9 |
| 146 | 2022-06-08 15:24:32 | defendants | 2 | 108824 | 8 | 2.906 | 37448.0 |
| 145 | 2022-05-30 14:01:38 | defendants | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 144 | 2022-03-02 18:26:32 | defendants | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 143 | 2022-02-16 01:45:15 | defendants | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 142 | 2021-12-03 07:55:48 | defendants | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 141 | 2021-10-31 04:03:06 | defendants | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 140 | 2021-10-26 15:48:15 | defendants | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 139 | 2021-07-16 04:04:41 | defendants | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 138 | 2021-06-04 20:14:52 | defendants | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 137 | 2021-05-05 00:09:14 | defendants | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 136 | 2021-04-13 09:03:22 | defendants | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 135 | 2021-04-03 03:08:51 | defendants | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 134 | 2021-03-07 14:36:29 | defendants | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 133 | 2021-01-18 01:26:12 | defendants | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 132 | 2021-01-03 14:31:25 | defendants | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 131 | 2020-11-23 15:25:16 | defendants | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 130 | 2020-11-05 22:54:21 | defendants | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 129 | 2020-10-29 08:00:00 | defendants | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 128 | 2020-10-25 04:27:33 | defendants | 1 | 67641 | 3 | 1.876 | 36056.0 |
| 127 | 2020-10-01 19:34:28 | defendants | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 126 | 2020-06-21 16:11:44 | defendants | 1 | 67641 | 3 | 1.296 | 52192.1 |
| 125 | 2020-03-25 06:09:35 | defendants | 1 | 67641 | 3 | 1.283 | 52721.0 |
| 124 | 2020-03-02 02:01:25 | defendants | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 123 | 2020-02-24 10:51:53 | defendants | 4 | 161450 | 130 | 11.440 | 14112.8 |
| 122 | 2020-02-23 21:46:36 | defendants | 4 | 161450 | 130 | 16.063 | 10051.0 |
| 121 | 2020-02-18 13:21:39 | defendants | 1 | 67641 | 3 | 3.186 | 21230.7 |
| 120 | 2020-02-17 17:00:46 | defendants | 4 | 161450 | 130 | 27.486 | 5873.9 |
| 119 | 2020-02-16 19:15:19 | defendants | 4 | 161450 | 130 | 14.140 | 11418.0 |
| 118 | 2020-02-04 10:28:08 | defendants | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 117 | 2020-02-03 23:38:52 | defendants | 1 | 67641 | 3 | 2.593 | 26086.0 |
| 116 | 2020-01-31 07:41:54 | defendants | 1 | 67641 | 3 | 1.390 | 48662.6 |
| 115 | 2020-01-29 02:40:26 | defendants | 1 | 67641 | 3 | 1.593 | 42461.4 |
| 114 | 2020-01-23 12:51:24 | defendants | 1 | 67641 | 3 | 1.296 | 52192.1 |
| 113 | 2020-01-19 20:03:30 | defendants | 4 | 161450 | 130 | 20.330 | 7941.5 |
| 112 | 2020-01-19 10:48:26 | defendants | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 111 | 2020-01-03 17:29:46 | defendants | 1 | 67641 | 3 | 1.313 | 51516.4 |
| 110 | 2020-01-02 13:19:47 | defendants | 1 | 67641 | 3 | 1.486 | 45518.8 |