History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prudential"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 181 | 2024-05-10 13:49:49 | prudential | 2 | 108824 | 3 | 2.796 | 38921.3 |
| 180 | 2024-05-09 13:36:17 | prudential | 5 | 173545 | 581 | 42.240 | 4108.5 |
| 179 | 2024-05-09 12:55:40 | prudential | 5 | 173545 | 581 | 57.660 | 3009.8 |
| 178 | 2024-05-09 12:53:38 | prudential | 1 | 67641 | 1 | 1.216 | 55625.8 |
| 177 | 2024-05-09 11:55:54 | prudential | 4 | 161450 | 83 | 23.453 | 6884.0 |
| 176 | 2024-05-08 12:42:02 | prudential | 4 | 161450 | 83 | 27.376 | 5897.5 |
| 175 | 2024-05-08 12:42:01 | prudential | 1 | 67641 | 1 | 1.783 | 37936.6 |
| 174 | 2024-05-08 12:41:25 | prudential | 2 | 108824 | 3 | 8.220 | 13238.9 |
| 173 | 2024-05-07 17:15:40 | prudential | 2 | 108824 | 3 | 11.046 | 9851.9 |
| 172 | 2024-05-06 14:43:52 | prudential | 1 | 67641 | 1 | 2.500 | 27056.4 |
| 171 | 2024-05-05 03:27:55 | prudential | 1 | 67641 | 1 | 1.110 | 60937.8 |
| 170 | 2024-05-01 21:00:38 | prudential | 2 | 108824 | 3 | 4.890 | 22254.4 |
| 169 | 2024-05-01 21:00:33 | prudential | 3 | 140603 | 14 | 6.940 | 20259.8 |
| 168 | 2024-05-01 21:00:30 | prudential | 3 | 140603 | 14 | 7.750 | 18142.3 |
| 167 | 2024-05-01 21:00:30 | prudential | 1 | 67641 | 1 | 2.483 | 27241.6 |
| 166 | 2024-05-01 21:00:25 | prudential | 1 | 67641 | 1 | 2.563 | 26391.3 |
| 165 | 2024-04-16 05:56:39 | prudential | 3 | 140603 | 14 | 35.830 | 3924.2 |
| 164 | 2024-04-13 19:06:52 | prudential | 3 | 140603 | 14 | 25.516 | 5510.4 |
| 163 | 2024-04-09 16:52:51 | prudential | 3 | 140603 | 14 | 5.670 | 24797.7 |
| 162 | 2024-04-03 19:49:44 | prudential | 2 | 108824 | 3 | 11.203 | 9713.8 |
| 161 | 2024-04-03 19:47:46 | prudential | 1 | 67641 | 1 | 2.106 | 32118.2 |
| 160 | 2024-03-28 22:07:15 | prudential | 4 | 161450 | 83 | 31.283 | 5161.0 |
| 159 | 2024-03-27 17:17:08 | prudential | 3 | 140603 | 14 | 23.046 | 6101.0 |
| 158 | 2024-03-27 17:16:49 | prudential | 2 | 108824 | 3 | 11.283 | 9645.0 |
| 157 | 2024-03-27 16:57:13 | prudential | 1 | 67641 | 1 | 1.250 | 54112.8 |
| 156 | 2024-03-25 20:15:25 | prudential | 3 | 140603 | 14 | 19.143 | 7344.9 |
| 155 | 2024-03-25 20:15:20 | prudential | 2 | 108824 | 3 | 4.843 | 22470.4 |
| 154 | 2024-03-25 20:01:54 | prudential | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 153 | 2024-03-25 20:01:48 | prudential | 1 | 67641 | 1 | 2.360 | 28661.4 |
| 152 | 2024-03-16 08:22:07 | prudential | 5 | 173545 | 581 | 57.516 | 3017.3 |
| 151 | 2024-03-16 01:15:58 | prudential | 4 | 161450 | 83 | 28.780 | 5609.8 |
| 150 | 2024-03-15 13:08:16 | prudential | 4 | 161450 | 83 | 31.766 | 5082.5 |
| 149 | 2024-03-13 07:45:31 | prudential | 4 | 161450 | 83 | 37.516 | 4303.5 |
| 148 | 2024-03-13 07:45:31 | prudential | 3 | 140603 | 14 | 23.110 | 6084.1 |
| 147 | 2024-03-13 07:27:23 | prudential | 5 | 173545 | 581 | 44.066 | 3938.3 |
| 146 | 2024-03-12 11:14:20 | prudential | 5 | 173545 | 581 | 47.313 | 3668.0 |
| 145 | 2024-03-12 10:48:45 | prudential | 5 | 173545 | 581 | 51.236 | 3387.2 |
| 144 | 2024-03-12 10:48:52 | prudential | 2 | 108824 | 3 | 11.186 | 9728.6 |
| 143 | 2024-03-12 10:48:41 | prudential | 4 | 161450 | 83 | 13.936 | 11585.1 |
| 142 | 2024-03-12 10:48:39 | prudential | 3 | 140603 | 14 | 8.343 | 16852.8 |
| 141 | 2024-02-20 09:17:37 | prudential | 2 | 108824 | 3 | 4.563 | 23849.2 |
| 140 | 2024-02-19 21:50:39 | prudential | 1 | 67641 | 1 | 1.406 | 48108.8 |
| 139 | 2024-02-19 06:32:19 | prudential | 1 | 67641 | 1 | 2.546 | 26567.6 |
| 138 | 2024-02-18 18:58:18 | prudential | 1 | 67641 | 1 | 3.780 | 17894.4 |
| 137 | 2024-02-14 23:51:09 | prudential | 2 | 108824 | 3 | 9.580 | 11359.5 |
| 136 | 2024-02-14 22:31:39 | prudential | 1 | 67641 | 1 | 2.343 | 28869.4 |
| 135 | 2024-02-14 17:34:14 | prudential | 5 | 173545 | 581 | 82.113 | 2113.5 |
| 134 | 2024-02-14 08:33:39 | prudential | 4 | 161450 | 83 | 26.266 | 6146.7 |
| 133 | 2024-02-13 21:01:08 | prudential | 3 | 140603 | 14 | 15.296 | 9192.1 |
| 132 | 2024-02-11 06:45:55 | prudential | 4 | 161450 | 83 | 40.783 | 3958.8 |
| 131 | 2024-02-08 22:20:17 | prudential | 4 | 161450 | 83 | 31.596 | 5109.8 |
| 130 | 2024-02-08 22:20:20 | prudential | 4 | 161450 | 83 | 22.923 | 7043.1 |
| 129 | 2024-02-08 12:07:16 | prudential | 5 | 173545 | 581 | 48.690 | 3564.3 |
| 128 | 2024-02-08 12:07:14 | prudential | 4 | 161450 | 83 | 30.580 | 5279.6 |
| 127 | 2024-02-08 12:07:15 | prudential | 3 | 140603 | 14 | 21.940 | 6408.5 |
| 126 | 2024-02-08 12:07:14 | prudential | 2 | 108824 | 3 | 10.670 | 10199.1 |
| 125 | 2024-02-08 09:07:43 | prudential | 1 | 67641 | 1 | 1.203 | 56226.9 |
| 124 | 2024-02-03 12:07:33 | prudential | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 123 | 2024-01-18 14:45:59 | prudential | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 122 | 2024-01-05 12:23:49 | prudential | 2 | 108824 | 3 | 3.076 | 35378.4 |
| 121 | 2023-12-11 08:35:18 | prudential | 3 | 140603 | 14 | 7.156 | 19648.3 |
| 120 | 2023-12-03 15:01:32 | prudential | 4 | 161450 | 83 | 13.156 | 12272.0 |
| 119 | 2023-12-02 22:17:38 | prudential | 1 | 67641 | 1 | 1.013 | 66773.0 |
| 118 | 2023-10-12 15:53:34 | prudential | 2 | 108824 | 3 | 2.923 | 37230.2 |
| 117 | 2023-09-18 08:18:55 | prudential | 1 | 67641 | 1 | 1.016 | 66575.8 |
| 116 | 2023-09-10 05:12:09 | prudential | 3 | 140603 | 14 | 5.576 | 25215.7 |
| 115 | 2023-09-01 00:40:52 | prudential | 4 | 161450 | 83 | 11.203 | 14411.3 |
| 114 | 2023-07-22 20:26:49 | prudential | 2 | 108824 | 3 | 2.940 | 37015.0 |
| 113 | 2023-07-11 09:44:56 | prudential | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 112 | 2023-06-01 20:50:34 | prudential | 3 | 140603 | 14 | 5.733 | 24525.2 |
| 111 | 2023-05-18 22:18:13 | prudential | 4 | 161450 | 83 | 9.296 | 17367.7 |
| 110 | 2023-04-17 08:53:41 | prudential | 1 | 67641 | 1 | 2.233 | 30291.5 |
| 109 | 2023-04-03 23:51:34 | prudential | 2 | 108824 | 3 | 2.593 | 41968.4 |
| 108 | 2023-03-09 22:17:17 | prudential | 3 | 140603 | 14 | 5.326 | 26399.4 |
| 107 | 2023-02-26 05:21:29 | prudential | 4 | 161450 | 83 | 10.093 | 15996.2 |
| 106 | 2023-02-09 01:38:21 | prudential | 1 | 67641 | 1 | 2.296 | 29460.4 |
| 105 | 2022-12-30 19:56:13 | prudential | 2 | 108824 | 3 | 2.576 | 42245.3 |
| 104 | 2022-12-15 14:17:41 | prudential | 3 | 140603 | 14 | 5.906 | 23806.8 |
| 103 | 2022-12-08 13:21:05 | prudential | 4 | 161450 | 83 | 9.576 | 16859.9 |
| 102 | 2022-12-06 22:57:31 | prudential | 1 | 67641 | 1 | 1.013 | 66773.0 |
| 101 | 2022-09-03 04:36:06 | prudential | 2 | 108824 | 3 | 3.310 | 32877.3 |
| 100 | 2022-08-07 21:18:30 | prudential | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 99 | 2022-08-04 00:49:07 | prudential | 3 | 140603 | 14 | 5.516 | 25490.0 |
| 98 | 2022-07-22 15:13:46 | prudential | 4 | 161450 | 83 | 9.450 | 17084.7 |
| 97 | 2022-07-01 23:31:11 | prudential | 1 | 67641 | 1 | 1.016 | 66575.8 |
| 96 | 2021-04-12 22:08:52 | prudential | 1 | 67641 | 1 | 1.313 | 51516.4 |
| 95 | 2021-03-16 18:21:53 | prudential | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 94 | 2021-02-19 17:36:52 | prudential | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 93 | 2020-11-15 13:59:25 | prudential | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 92 | 2020-11-04 21:23:01 | prudential | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 91 | 2020-10-16 21:39:47 | prudential | 1 | 67641 | 1 | 1.063 | 63632.2 |
| 90 | 2020-03-23 12:59:38 | prudential | 1 | 67641 | 1 | 1.250 | 54112.8 |
| 89 | 2020-03-07 20:36:29 | prudential | 1 | 67641 | 1 | 1.016 | 66575.8 |
| 88 | 2020-02-18 11:34:46 | prudential | 1 | 67641 | 1 | 1.736 | 38963.7 |
| 87 | 2020-02-08 13:34:39 | prudential | 5 | 173545 | 581 | 47.193 | 3677.3 |
| 86 | 2020-02-07 09:09:38 | prudential | 5 | 173545 | 581 | 36.283 | 4783.1 |
| 85 | 2020-02-07 07:01:14 | prudential | 5 | 173545 | 581 | 26.783 | 6479.7 |
| 84 | 2020-02-07 04:45:03 | prudential | 5 | 173545 | 581 | 35.346 | 4909.9 |
| 83 | 2020-02-07 01:05:58 | prudential | 5 | 173545 | 581 | 31.283 | 5547.6 |
| 82 | 2020-02-06 09:58:23 | prudential | 4 | 161450 | 83 | 13.780 | 11716.3 |