History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"transfects"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 177 | 2024-05-02 12:22:46 | transfects | 3 | 140603 | 38 | 25.596 | 5493.2 |
| 176 | 2024-05-02 12:22:42 | transfects | 4 | 161450 | 141 | 25.110 | 6429.7 |
| 175 | 2024-05-02 12:22:45 | transfects | 2 | 108824 | 9 | 8.283 | 13138.2 |
| 174 | 2024-05-02 11:49:04 | transfects | 1 | 67641 | 3 | 1.860 | 36366.1 |
| 173 | 2024-05-02 10:24:36 | transfects | 1 | 67641 | 3 | 2.373 | 28504.4 |
| 172 | 2024-04-28 17:44:51 | transfects | 1 | 67641 | 3 | 2.000 | 33820.5 |
| 171 | 2024-04-28 16:41:27 | transfects | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 170 | 2024-04-10 09:45:45 | transfects | 3 | 140603 | 38 | 11.140 | 12621.5 |
| 169 | 2024-04-10 09:45:45 | transfects | 2 | 108824 | 9 | 11.673 | 9322.7 |
| 168 | 2024-04-10 09:44:49 | transfects | 1 | 67641 | 3 | 1.500 | 45094.0 |
| 167 | 2024-04-08 00:32:11 | transfects | 4 | 161450 | 141 | 28.720 | 5621.5 |
| 166 | 2024-03-27 02:28:34 | transfects | 3 | 140603 | 38 | 20.906 | 6725.5 |
| 165 | 2024-03-27 02:28:29 | transfects | 2 | 108824 | 9 | 4.126 | 26375.2 |
| 164 | 2024-03-27 02:05:25 | transfects | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 163 | 2024-03-26 16:01:25 | transfects | 1 | 67641 | 3 | 1.050 | 64420.0 |
| 162 | 2024-03-24 18:08:51 | transfects | 4 | 161450 | 141 | 31.220 | 5171.4 |
| 161 | 2024-03-24 18:08:53 | transfects | 3 | 140603 | 38 | 13.750 | 10225.7 |
| 160 | 2024-03-24 18:08:51 | transfects | 2 | 108824 | 9 | 11.280 | 9647.5 |
| 159 | 2024-03-24 17:47:44 | transfects | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 158 | 2024-03-19 23:57:04 | transfects | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 157 | 2024-03-01 13:53:12 | transfects | 1 | 67641 | 3 | 1.780 | 38000.6 |
| 156 | 2024-02-26 05:16:55 | transfects | 2 | 108824 | 9 | 3.686 | 29523.6 |
| 155 | 2024-02-25 09:34:25 | transfects | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 154 | 2024-02-20 13:35:46 | transfects | 1 | 67641 | 3 | 2.326 | 29080.4 |
| 153 | 2024-02-07 13:21:52 | transfects | 3 | 140603 | 38 | 7.080 | 19859.2 |
| 152 | 2024-02-01 04:04:44 | transfects | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 151 | 2024-01-27 11:33:58 | transfects | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 150 | 2024-01-25 22:15:35 | transfects | 1 | 67641 | 3 | 2.373 | 28504.4 |
| 149 | 2024-01-25 22:15:27 | transfects | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 148 | 2024-01-18 09:27:17 | transfects | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 147 | 2024-01-15 13:45:38 | transfects | 3 | 140603 | 38 | 7.266 | 19350.8 |
| 146 | 2023-12-06 03:52:42 | transfects | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 145 | 2023-11-21 23:29:35 | transfects | 2 | 108824 | 9 | 2.720 | 40008.8 |
| 144 | 2023-11-15 10:31:33 | transfects | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 143 | 2023-11-12 18:57:48 | transfects | 3 | 140603 | 38 | 6.626 | 21219.9 |
| 142 | 2023-09-21 04:35:25 | transfects | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 141 | 2023-09-06 00:48:00 | transfects | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 140 | 2023-08-22 16:58:59 | transfects | 2 | 108824 | 9 | 2.720 | 40008.8 |
| 139 | 2023-08-14 17:27:43 | transfects | 3 | 140603 | 38 | 6.140 | 22899.5 |
| 138 | 2023-07-17 07:30:39 | transfects | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 137 | 2023-05-08 17:43:13 | transfects | 2 | 108824 | 9 | 2.593 | 41968.4 |
| 136 | 2023-05-02 08:58:39 | transfects | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 135 | 2023-04-26 19:05:39 | transfects | 3 | 140603 | 38 | 6.033 | 23305.7 |
| 134 | 2023-04-20 02:03:38 | transfects | 1 | 67641 | 3 | 0.986 | 68601.4 |
| 133 | 2023-02-10 13:09:20 | transfects | 2 | 108824 | 9 | 3.156 | 34481.6 |
| 132 | 2023-02-09 04:13:45 | transfects | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 131 | 2023-01-30 21:51:11 | transfects | 3 | 140603 | 38 | 5.390 | 26085.9 |
| 130 | 2023-01-27 10:30:23 | transfects | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 129 | 2022-12-07 03:36:31 | transfects | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 128 | 2022-11-21 23:03:17 | transfects | 2 | 108824 | 9 | 2.610 | 41695.0 |
| 127 | 2022-11-12 22:44:35 | transfects | 3 | 140603 | 38 | 5.436 | 25865.2 |
| 126 | 2022-09-10 17:03:03 | transfects | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 125 | 2022-08-09 10:21:43 | transfects | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 124 | 2022-08-07 02:29:15 | transfects | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 123 | 2022-06-27 05:07:46 | transfects | 2 | 108824 | 9 | 2.686 | 40515.3 |
| 122 | 2022-05-25 17:31:51 | transfects | 3 | 140603 | 38 | 5.923 | 23738.5 |
| 121 | 2022-05-12 15:58:17 | transfects | 1 | 67641 | 3 | 1.610 | 42013.0 |
| 120 | 2022-04-17 04:40:02 | transfects | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 119 | 2022-03-25 13:05:01 | transfects | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 118 | 2022-03-23 11:32:50 | transfects | 1 | 67641 | 3 | 1.283 | 52721.0 |
| 117 | 2022-03-21 05:34:01 | transfects | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 116 | 2021-12-27 04:40:15 | transfects | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 115 | 2021-12-21 21:52:51 | transfects | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 114 | 2021-12-18 16:09:40 | transfects | 2 | 108824 | 9 | 3.393 | 32073.1 |
| 113 | 2021-12-09 22:19:43 | transfects | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 112 | 2021-12-06 15:59:15 | transfects | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 111 | 2021-11-13 07:39:35 | transfects | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 110 | 2021-10-20 04:28:01 | transfects | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 109 | 2021-09-17 06:13:51 | transfects | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 108 | 2021-09-16 00:33:38 | transfects | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 107 | 2021-09-15 07:11:51 | transfects | 1 | 67641 | 3 | 1.106 | 61158.2 |
| 106 | 2021-09-14 13:56:27 | transfects | 2 | 108824 | 9 | 3.076 | 35378.4 |
| 105 | 2021-09-14 13:54:28 | transfects | 1 | 67641 | 3 | 2.266 | 29850.4 |
| 104 | 2021-09-09 10:31:03 | transfects | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 103 | 2021-08-28 11:43:05 | transfects | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 102 | 2021-08-16 23:20:05 | transfects | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 101 | 2021-07-27 08:54:04 | transfects | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 100 | 2021-06-11 16:30:31 | transfects | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 99 | 2021-06-10 23:29:03 | transfects | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 98 | 2021-05-14 11:37:07 | transfects | 4 | 161450 | 141 | 10.390 | 15539.0 |
| 97 | 2021-05-06 01:09:16 | transfects | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 96 | 2021-04-23 11:25:20 | transfects | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 95 | 2021-04-06 14:58:01 | transfects | 4 | 161450 | 141 | 11.296 | 14292.7 |
| 94 | 2021-04-01 15:36:51 | transfects | 2 | 108824 | 9 | 3.390 | 32101.5 |
| 93 | 2021-01-16 23:11:08 | transfects | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 92 | 2020-10-24 08:32:03 | transfects | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 91 | 2020-10-15 05:32:14 | transfects | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 90 | 2020-10-12 13:13:21 | transfects | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 89 | 2020-07-26 11:10:11 | transfects | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 88 | 2020-06-19 01:46:37 | transfects | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 87 | 2020-06-17 04:21:50 | transfects | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 86 | 2020-03-27 20:35:40 | transfects | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 85 | 2020-03-23 23:41:37 | transfects | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 84 | 2020-03-11 08:33:07 | transfects | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 83 | 2020-02-27 05:52:42 | transfects | 1 | 67641 | 3 | 2.610 | 25916.1 |
| 82 | 2020-02-14 22:03:31 | transfects | 1 | 67641 | 3 | 2.593 | 26086.0 |
| 81 | 2020-02-06 12:03:33 | transfects | 4 | 161450 | 141 | 18.893 | 8545.5 |
| 80 | 2020-02-06 11:59:56 | transfects | 3 | 140603 | 38 | 7.313 | 19226.4 |
| 79 | 2020-02-06 11:59:25 | transfects | 2 | 108824 | 9 | 3.643 | 29872.1 |
| 78 | 2020-02-06 08:00:54 | transfects | 1 | 67641 | 3 | 1.203 | 56226.9 |