History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"unmapped"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 178 | 2024-04-06 14:05:29 | unmapped | 2 | 121059 | 24 | 4.843 | 24996.7 |
| 177 | 2024-04-06 00:48:33 | unmapped | 3 | 146162 | 195 | 23.580 | 6198.6 |
| 176 | 2024-04-05 03:02:14 | unmapped | 3 | 146162 | 195 | 14.030 | 10417.8 |
| 175 | 2024-04-05 03:02:15 | unmapped | 2 | 121059 | 24 | 9.250 | 13087.5 |
| 174 | 2024-04-05 03:02:14 | unmapped | 1 | 82945 | 3 | 1.830 | 45325.1 |
| 173 | 2024-03-29 12:26:39 | unmapped | 1 | 82945 | 3 | 3.050 | 27195.1 |
| 172 | 2024-03-29 10:19:02 | unmapped | 2 | 121059 | 24 | 4.250 | 28484.5 |
| 171 | 2024-03-29 05:15:36 | unmapped | 3 | 146162 | 195 | 16.890 | 8653.8 |
| 170 | 2024-03-27 10:05:53 | unmapped | 3 | 146162 | 195 | 11.720 | 12471.2 |
| 169 | 2024-03-27 10:06:03 | unmapped | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 168 | 2024-03-27 10:05:59 | unmapped | 1 | 82945 | 3 | 3.206 | 25871.8 |
| 167 | 2024-03-27 10:05:49 | unmapped | 2 | 121059 | 24 | 4.046 | 29920.7 |
| 166 | 2024-03-01 15:32:26 | unmapped | 3 | 146162 | 195 | 15.376 | 9505.9 |
| 165 | 2024-02-28 09:37:07 | unmapped | 3 | 146162 | 195 | 17.736 | 8241.0 |
| 164 | 2024-02-28 09:37:08 | unmapped | 2 | 121059 | 24 | 10.890 | 11116.5 |
| 163 | 2024-02-28 07:51:58 | unmapped | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 162 | 2024-02-28 04:33:27 | unmapped | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 161 | 2024-02-26 04:14:22 | unmapped | 2 | 121059 | 24 | 4.060 | 29817.5 |
| 160 | 2024-02-25 21:43:35 | unmapped | 3 | 146162 | 195 | 13.453 | 10864.6 |
| 159 | 2024-02-24 19:10:27 | unmapped | 3 | 146162 | 195 | 11.550 | 12654.7 |
| 158 | 2024-02-24 19:10:26 | unmapped | 2 | 121059 | 24 | 3.656 | 33112.4 |
| 157 | 2024-02-24 19:10:20 | unmapped | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 156 | 2024-01-09 11:19:17 | unmapped | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 155 | 2023-11-30 12:38:04 | unmapped | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 154 | 2023-11-03 02:47:19 | unmapped | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 153 | 2023-10-18 21:40:19 | unmapped | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 152 | 2023-10-14 01:52:50 | unmapped | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 151 | 2023-09-29 15:42:49 | unmapped | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 150 | 2023-09-23 16:34:57 | unmapped | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 149 | 2023-08-25 08:04:57 | unmapped | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 148 | 2023-05-29 02:26:55 | unmapped | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 147 | 2023-01-09 03:13:18 | unmapped | 1 | 82945 | 3 | 1.206 | 68776.9 |
| 146 | 2022-10-16 23:28:56 | unmapped | 1 | 82945 | 3 | 1.220 | 67987.7 |
| 145 | 2022-06-07 07:34:49 | unmapped | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 144 | 2022-02-17 03:42:41 | unmapped | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 143 | 2022-02-12 19:51:42 | unmapped | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 142 | 2021-05-07 10:51:49 | unmapped | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 141 | 2021-04-05 19:44:08 | unmapped | 1 | 82945 | 3 | 1.450 | 57203.4 |
| 140 | 2021-03-10 04:03:56 | unmapped | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 139 | 2021-02-13 21:13:00 | unmapped | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 138 | 2020-11-13 18:05:38 | unmapped | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 137 | 2020-10-25 17:28:55 | unmapped | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 136 | 2020-03-26 02:01:59 | unmapped | 1 | 82945 | 3 | 2.673 | 31030.7 |
| 135 | 2020-03-11 12:25:53 | unmapped | 1 | 82945 | 3 | 1.293 | 64149.3 |
| 134 | 2020-02-28 19:07:33 | unmapped | 3 | 146162 | 195 | 18.330 | 7973.9 |
| 133 | 2020-02-27 13:50:30 | unmapped | 3 | 146162 | 195 | 16.626 | 8791.2 |
| 132 | 2020-02-27 11:52:18 | unmapped | 3 | 146162 | 195 | 7.860 | 18595.7 |
| 131 | 2020-02-23 20:23:25 | unmapped | 1 | 82945 | 3 | 1.670 | 49667.7 |
| 130 | 2020-02-23 17:22:47 | unmapped | 3 | 146162 | 195 | 9.483 | 15413.1 |
| 129 | 2020-02-23 16:54:00 | unmapped | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 128 | 2020-02-23 15:11:31 | unmapped | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 127 | 2020-02-22 12:56:49 | unmapped | 3 | 146162 | 195 | 15.143 | 9652.1 |
| 126 | 2020-02-19 11:32:42 | unmapped | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 125 | 2020-02-11 01:46:34 | unmapped | 3 | 146162 | 195 | 12.483 | 11708.9 |
| 124 | 2020-02-09 00:43:05 | unmapped | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 123 | 2020-02-08 20:31:20 | unmapped | 1 | 82945 | 3 | 4.170 | 19890.9 |
| 122 | 2020-02-04 19:22:20 | unmapped | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 121 | 2020-01-26 15:35:53 | unmapped | 1 | 82945 | 3 | 4.170 | 19890.9 |
| 120 | 2020-01-25 16:45:10 | unmapped | 1 | 82945 | 3 | 2.156 | 38471.7 |
| 119 | 2020-01-24 19:00:52 | unmapped | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 118 | 2020-01-22 06:55:40 | unmapped | 3 | 146162 | 195 | 24.533 | 5957.8 |
| 117 | 2020-01-21 04:10:56 | unmapped | 3 | 146162 | 195 | 16.970 | 8613.0 |
| 116 | 2020-01-20 06:16:23 | unmapped | 3 | 146162 | 195 | 7.986 | 18302.3 |
| 115 | 2020-01-20 05:48:32 | unmapped | 3 | 146162 | 195 | 13.953 | 10475.3 |
| 114 | 2020-01-20 04:34:41 | unmapped | 3 | 146162 | 195 | 7.470 | 19566.5 |
| 113 | 2020-01-19 22:04:19 | unmapped | 2 | 121059 | 24 | 3.936 | 30756.9 |
| 112 | 2020-01-19 22:04:08 | unmapped | 3 | 146162 | 195 | 7.530 | 19410.6 |
| 111 | 2020-01-19 19:47:12 | unmapped | 1 | 82945 | 3 | 2.483 | 33405.2 |
| 110 | 2020-01-15 22:27:38 | unmapped | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 109 | 2020-01-03 20:59:07 | unmapped | 1 | 82945 | 3 | 2.500 | 33178.0 |
| 108 | 2020-01-02 00:56:46 | unmapped | 1 | 82945 | 3 | 2.390 | 34705.0 |
| 107 | 2019-11-26 23:26:49 | unmapped | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 106 | 2019-08-25 06:01:49 | unmapped | 1 | 82945 | 3 | 1.210 | 68549.6 |
| 105 | 2019-05-16 03:57:02 | unmapped | 1 | 82945 | 3 | 1.380 | 60105.1 |
| 104 | 2019-02-20 08:13:21 | unmapped | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 103 | 2019-02-13 15:12:55 | unmapped | 1 | 82945 | 3 | 1.203 | 68948.5 |
| 102 | 2019-01-21 21:23:12 | unmapped | 1 | 82945 | 3 | 1.366 | 60721.1 |
| 101 | 2019-01-11 22:57:04 | unmapped | 1 | 82945 | 3 | 1.350 | 61440.7 |
| 100 | 2019-01-11 22:50:40 | unmapped | 1 | 82945 | 3 | 1.246 | 66569.0 |
| 99 | 2018-09-19 06:47:11 | unmapped | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 98 | 2018-07-14 10:45:46 | unmapped | 1 | 82945 | 3 | 1.230 | 67435.0 |
| 97 | 2018-06-17 10:32:10 | unmapped | 1 | 82945 | 3 | 1.430 | 58003.5 |
| 96 | 2018-06-15 18:24:01 | unmapped | 1 | 82945 | 3 | 1.450 | 57203.4 |
| 95 | 2017-12-18 03:54:54 | unmapped | 1 | 82945 | 3 | 1.770 | 46861.6 |
| 94 | 2017-08-23 05:17:25 | unmapped | 1 | 82945 | 3 | 1.700 | 48791.2 |
| 93 | 2017-08-23 04:21:07 | unmapped | 1 | 82945 | 3 | 1.643 | 50483.9 |
| 92 | 2017-06-05 07:52:51 | unmapped | 1 | 82945 | 3 | 1.693 | 48992.9 |
| 91 | 2017-05-21 12:14:56 | unmapped | 1 | 82945 | 3 | 2.390 | 34705.0 |
| 90 | 2017-05-21 12:12:45 | unmapped | 1 | 82945 | 3 | 1.690 | 49079.9 |
| 89 | 2017-05-05 08:15:58 | unmapped | 1 | 82945 | 3 | 1.696 | 48906.3 |
| 88 | 2017-03-14 21:37:24 | unmapped | 1 | 82945 | 3 | 1.636 | 50699.9 |
| 87 | 2017-03-06 20:01:00 | unmapped | 1 | 82945 | 3 | 1.723 | 48139.9 |
| 86 | 2017-03-02 11:09:39 | unmapped | 1 | 82945 | 3 | 1.990 | 41680.9 |
| 85 | 2017-02-20 17:54:59 | unmapped | 1 | 82945 | 3 | 1.820 | 45574.2 |
| 84 | 2017-01-18 16:47:28 | unmapped | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 83 | 2017-01-18 16:39:27 | unmapped | 1 | 82945 | 3 | 1.736 | 47779.4 |
| 82 | 2016-11-27 14:03:46 | unmapped | 1 | 82945 | 3 | 3.996 | 20757.0 |
| 81 | 2016-11-19 13:48:19 | unmapped | 1 | 82945 | 3 | 2.103 | 39441.3 |
| 80 | 2016-10-28 00:03:18 | unmapped | 1 | 82945 | 3 | 1.773 | 46782.3 |
| 79 | 2016-10-26 10:10:34 | unmapped | 1 | 82945 | 3 | 1.710 | 48505.8 |