History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"firefights"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 173 | 2024-04-28 06:02:29 | firefights | 4 | 161450 | 103 | 37.956 | 4253.6 |
| 172 | 2024-04-28 05:48:17 | firefights | 2 | 108824 | 10 | 7.173 | 15171.3 |
| 171 | 2024-04-26 21:52:47 | firefights | 4 | 161450 | 103 | 33.376 | 4837.3 |
| 170 | 2024-04-26 21:52:49 | firefights | 2 | 108824 | 10 | 10.576 | 10289.7 |
| 169 | 2024-04-26 20:10:01 | firefights | 1 | 67641 | 3 | 2.046 | 33060.1 |
| 168 | 2024-04-11 23:04:21 | firefights | 1 | 67641 | 3 | 2.203 | 30704.0 |
| 167 | 2024-04-05 21:39:36 | firefights | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 166 | 2024-03-25 17:15:48 | firefights | 3 | 140603 | 25 | 7.110 | 19775.4 |
| 165 | 2024-03-25 17:15:43 | firefights | 2 | 108824 | 10 | 6.563 | 16581.4 |
| 164 | 2024-03-25 17:15:40 | firefights | 1 | 67641 | 3 | 1.153 | 58665.2 |
| 163 | 2024-03-09 16:04:02 | firefights | 4 | 161450 | 103 | 34.190 | 4722.1 |
| 162 | 2024-03-08 14:04:53 | firefights | 4 | 161450 | 103 | 38.783 | 4162.9 |
| 161 | 2024-03-08 03:42:06 | firefights | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 160 | 2024-03-07 00:02:26 | firefights | 1 | 67641 | 3 | 2.546 | 26567.6 |
| 159 | 2024-03-06 21:09:47 | firefights | 4 | 161450 | 103 | 15.030 | 10741.8 |
| 158 | 2024-03-06 21:09:49 | firefights | 3 | 140603 | 25 | 10.033 | 14014.1 |
| 157 | 2024-03-06 21:09:50 | firefights | 2 | 108824 | 10 | 6.220 | 17495.8 |
| 156 | 2024-03-06 18:36:10 | firefights | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 155 | 2024-03-06 16:42:16 | firefights | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 154 | 2024-03-02 06:44:08 | firefights | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 153 | 2024-02-20 19:20:36 | firefights | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 152 | 2024-02-09 15:11:47 | firefights | 3 | 140603 | 25 | 12.753 | 11025.1 |
| 151 | 2024-02-09 15:11:35 | firefights | 2 | 108824 | 10 | 5.736 | 18972.1 |
| 150 | 2024-02-07 10:27:06 | firefights | 1 | 67641 | 3 | 2.376 | 28468.4 |
| 149 | 2024-02-05 03:17:26 | firefights | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 148 | 2024-02-01 03:06:35 | firefights | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 147 | 2024-01-30 09:03:56 | firefights | 1 | 67641 | 3 | 1.153 | 58665.2 |
| 146 | 2024-01-28 22:07:07 | firefights | 2 | 108824 | 10 | 2.670 | 40758.1 |
| 145 | 2024-01-16 04:58:19 | firefights | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 144 | 2024-01-04 00:34:50 | firefights | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 143 | 2024-01-02 12:45:46 | firefights | 2 | 108824 | 10 | 3.033 | 35880.0 |
| 142 | 2023-12-25 22:53:03 | firefights | 4 | 161450 | 103 | 9.923 | 16270.3 |
| 141 | 2023-12-21 20:57:19 | firefights | 3 | 140603 | 25 | 6.983 | 20135.0 |
| 140 | 2023-12-11 21:58:52 | firefights | 1 | 67641 | 3 | 2.200 | 30745.9 |
| 139 | 2023-12-06 02:28:23 | firefights | 1 | 67641 | 3 | 0.986 | 68601.4 |
| 138 | 2023-12-02 17:59:41 | firefights | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 137 | 2023-11-26 02:56:31 | firefights | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 136 | 2023-11-07 18:20:39 | firefights | 2 | 108824 | 10 | 2.890 | 37655.4 |
| 135 | 2023-09-25 20:12:33 | firefights | 4 | 161450 | 103 | 10.766 | 14996.3 |
| 134 | 2023-09-22 15:21:10 | firefights | 3 | 140603 | 25 | 5.983 | 23500.4 |
| 133 | 2023-09-11 09:24:46 | firefights | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 132 | 2023-08-11 07:26:20 | firefights | 2 | 108824 | 10 | 2.953 | 36852.0 |
| 131 | 2023-07-10 18:16:58 | firefights | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 130 | 2023-07-06 13:38:44 | firefights | 4 | 161450 | 103 | 10.283 | 15700.7 |
| 129 | 2023-06-30 19:18:46 | firefights | 3 | 140603 | 25 | 6.733 | 20882.7 |
| 128 | 2023-06-24 04:12:44 | firefights | 1 | 67641 | 3 | 1.206 | 56087.1 |
| 127 | 2023-04-21 15:16:02 | firefights | 2 | 108824 | 10 | 2.906 | 37448.0 |
| 126 | 2023-04-07 19:22:00 | firefights | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 125 | 2023-03-27 01:06:55 | firefights | 4 | 161450 | 103 | 10.376 | 15559.9 |
| 124 | 2023-03-20 21:38:59 | firefights | 3 | 140603 | 25 | 5.376 | 26153.8 |
| 123 | 2023-02-27 23:57:34 | firefights | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 122 | 2023-01-27 19:07:11 | firefights | 1 | 67641 | 3 | 0.986 | 68601.4 |
| 121 | 2023-01-27 08:44:38 | firefights | 2 | 108824 | 10 | 3.080 | 35332.5 |
| 120 | 2022-12-25 03:34:00 | firefights | 4 | 161450 | 103 | 11.436 | 14117.7 |
| 119 | 2022-12-20 22:52:57 | firefights | 3 | 140603 | 25 | 5.796 | 24258.6 |
| 118 | 2022-11-26 02:33:48 | firefights | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 117 | 2022-11-08 14:21:50 | firefights | 2 | 108824 | 10 | 2.673 | 40712.3 |
| 116 | 2022-10-06 05:12:30 | firefights | 1 | 67641 | 3 | 0.970 | 69733.0 |
| 115 | 2022-08-25 05:42:57 | firefights | 4 | 161450 | 103 | 10.470 | 15420.2 |
| 114 | 2022-08-15 03:57:29 | firefights | 3 | 140603 | 25 | 5.466 | 25723.2 |
| 113 | 2022-07-21 04:52:13 | firefights | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 112 | 2022-06-10 10:31:55 | firefights | 2 | 108824 | 10 | 3.190 | 34114.1 |
| 111 | 2022-06-08 05:27:23 | firefights | 2 | 108824 | 10 | 2.953 | 36852.0 |
| 110 | 2022-06-05 22:01:05 | firefights | 1 | 67641 | 3 | 0.970 | 69733.0 |
| 109 | 2022-05-22 18:54:08 | firefights | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 108 | 2022-05-19 09:19:15 | firefights | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 107 | 2022-04-23 09:00:57 | firefights | 1 | 67641 | 3 | 0.986 | 68601.4 |
| 106 | 2022-04-01 20:59:30 | firefights | 3 | 140603 | 25 | 5.656 | 24859.1 |
| 105 | 2022-03-18 11:37:21 | firefights | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 104 | 2022-02-11 13:25:29 | firefights | 2 | 108824 | 10 | 2.580 | 42179.8 |
| 103 | 2022-02-03 13:41:05 | firefights | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 102 | 2022-01-10 11:50:16 | firefights | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 101 | 2022-01-08 00:37:36 | firefights | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 100 | 2021-12-24 18:19:31 | firefights | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 99 | 2021-09-12 16:15:22 | firefights | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 98 | 2021-07-30 17:46:05 | firefights | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 97 | 2021-06-15 10:34:24 | firefights | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 96 | 2021-06-14 22:00:28 | firefights | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 95 | 2021-05-29 21:42:47 | firefights | 1 | 67641 | 3 | 1.143 | 59178.5 |
| 94 | 2021-05-13 18:21:09 | firefights | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 93 | 2021-03-25 07:08:35 | firefights | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 92 | 2021-02-27 05:43:36 | firefights | 1 | 67641 | 3 | 0.966 | 70021.7 |
| 91 | 2021-01-08 07:42:45 | firefights | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 90 | 2020-12-10 02:09:00 | firefights | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 89 | 2020-11-07 19:37:24 | firefights | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 88 | 2020-10-26 00:21:48 | firefights | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 87 | 2020-10-15 00:54:07 | firefights | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 86 | 2020-07-17 12:52:22 | firefights | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 85 | 2020-04-12 19:18:21 | firefights | 1 | 67641 | 3 | 1.060 | 63812.3 |
| 84 | 2020-03-25 06:24:46 | firefights | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 83 | 2020-02-19 05:50:34 | firefights | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 82 | 2020-02-14 21:34:32 | firefights | 1 | 67641 | 3 | 1.280 | 52844.5 |
| 81 | 2020-02-07 12:57:48 | firefights | 1 | 67641 | 3 | 1.236 | 54725.7 |
| 80 | 2020-02-06 08:32:51 | firefights | 1 | 67641 | 3 | 1.813 | 37308.9 |
| 79 | 2020-02-03 16:21:37 | firefights | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 78 | 2020-01-30 22:13:50 | firefights | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 77 | 2020-01-29 02:59:58 | firefights | 1 | 67641 | 3 | 1.670 | 40503.6 |
| 76 | 2020-01-18 20:10:35 | firefights | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 75 | 2020-01-04 18:23:44 | firefights | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 74 | 2020-01-02 16:00:36 | firefights | 1 | 67641 | 3 | 1.156 | 58513.0 |