History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prefabbed"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
165 | 2024-05-03 12:39:27 | prefabbed | 1 | 81242 | 1 | 1.393 | 58321.6 |
164 | 2024-05-01 03:57:45 | prefabbed | 1 | 81242 | 1 | 1.733 | 46879.4 |
163 | 2024-04-30 08:09:33 | prefabbed | 1 | 81242 | 1 | 4.826 | 16834.2 |
162 | 2024-03-30 21:43:25 | prefabbed | 1 | 81242 | 1 | 1.656 | 49059.2 |
161 | 2024-03-26 04:15:43 | prefabbed | 2 | 121436 | 4 | 11.576 | 10490.3 |
160 | 2024-03-26 03:49:42 | prefabbed | 1 | 81242 | 1 | 1.593 | 50999.4 |
159 | 2024-03-18 20:19:36 | prefabbed | 1 | 81242 | 1 | 2.610 | 31127.2 |
158 | 2024-02-28 23:19:13 | prefabbed | 1 | 81242 | 1 | 1.266 | 64172.2 |
157 | 2024-02-28 10:04:40 | prefabbed | 2 | 121436 | 4 | 9.813 | 12375.0 |
156 | 2024-02-28 10:04:40 | prefabbed | 3 | 148641 | 47 | 8.953 | 16602.4 |
155 | 2024-02-28 06:27:36 | prefabbed | 1 | 81242 | 1 | 1.500 | 54161.3 |
154 | 2024-02-27 01:48:07 | prefabbed | 4 | 165329 | 435 | 27.813 | 5944.3 |
153 | 2024-02-27 01:48:06 | prefabbed | 3 | 148641 | 47 | 22.470 | 6615.1 |
152 | 2024-02-27 01:48:08 | prefabbed | 2 | 121436 | 4 | 4.843 | 25074.5 |
151 | 2024-02-13 13:17:16 | prefabbed | 1 | 81242 | 1 | 1.810 | 44885.1 |
150 | 2024-01-30 04:01:46 | prefabbed | 1 | 81242 | 1 | 1.456 | 55798.1 |
149 | 2024-01-28 21:13:40 | prefabbed | 1 | 81242 | 1 | 1.390 | 58447.5 |
148 | 2024-01-24 14:11:36 | prefabbed | 1 | 81242 | 1 | 1.466 | 55417.5 |
147 | 2024-01-10 15:51:53 | prefabbed | 1 | 81242 | 1 | 1.390 | 58447.5 |
146 | 2023-12-06 18:13:09 | prefabbed | 1 | 81242 | 1 | 1.466 | 55417.5 |
145 | 2023-12-03 20:49:54 | prefabbed | 1 | 81242 | 1 | 1.436 | 56575.2 |
144 | 2023-11-20 04:32:02 | prefabbed | 1 | 81242 | 1 | 1.373 | 59171.2 |
143 | 2023-09-06 19:09:07 | prefabbed | 1 | 81242 | 1 | 1.266 | 64172.2 |
142 | 2023-06-11 12:09:54 | prefabbed | 1 | 81242 | 1 | 1.406 | 57782.4 |
141 | 2023-03-30 18:54:36 | prefabbed | 1 | 81242 | 1 | 1.280 | 63470.3 |
140 | 2021-05-05 10:32:52 | prefabbed | 1 | 81242 | 1 | 1.486 | 54671.6 |
139 | 2021-03-24 13:13:51 | prefabbed | 4 | 165329 | 435 | 10.766 | 15356.6 |
138 | 2021-02-26 20:37:06 | prefabbed | 4 | 165329 | 435 | 10.906 | 15159.5 |
137 | 2021-02-03 10:52:23 | prefabbed | 2 | 121436 | 4 | 3.516 | 34538.1 |
136 | 2021-01-18 15:34:30 | prefabbed | 1 | 81242 | 1 | 1.296 | 62686.7 |
135 | 2020-11-24 02:46:25 | prefabbed | 1 | 81242 | 1 | 1.233 | 65889.7 |
134 | 2020-11-10 05:30:42 | prefabbed | 1 | 81242 | 1 | 1.466 | 55417.5 |
133 | 2020-11-06 20:31:17 | prefabbed | 1 | 81242 | 1 | 1.360 | 59736.8 |
132 | 2020-09-13 02:09:26 | prefabbed | 1 | 81242 | 1 | 1.390 | 58447.5 |
131 | 2020-03-29 17:43:03 | prefabbed | 1 | 81242 | 1 | 1.516 | 53589.7 |
130 | 2020-03-12 00:49:07 | prefabbed | 1 | 81242 | 1 | 1.326 | 61268.5 |
129 | 2020-02-20 14:36:48 | prefabbed | 1 | 81242 | 1 | 1.516 | 53589.7 |
128 | 2020-02-11 10:48:58 | prefabbed | 1 | 81242 | 1 | 1.923 | 42247.5 |
127 | 2020-02-08 05:51:58 | prefabbed | 1 | 81242 | 1 | 3.296 | 24648.7 |
126 | 2020-02-06 09:49:33 | prefabbed | 1 | 81242 | 1 | 3.203 | 25364.3 |
125 | 2020-02-05 23:01:54 | prefabbed | 1 | 81242 | 1 | 3.126 | 25989.1 |
124 | 2020-02-05 22:02:55 | prefabbed | 2 | 121436 | 4 | 4.813 | 25230.8 |
123 | 2020-02-05 17:00:41 | prefabbed | 1 | 81242 | 1 | 1.483 | 54782.2 |
122 | 2020-02-04 20:01:33 | prefabbed | 1 | 81242 | 1 | 3.236 | 25105.7 |
121 | 2020-01-20 05:37:50 | prefabbed | 1 | 81242 | 1 | 1.576 | 51549.5 |
120 | 2020-01-20 04:19:25 | prefabbed | 1 | 81242 | 1 | 2.563 | 31698.0 |
119 | 2020-01-11 01:12:29 | prefabbed | 1 | 81242 | 1 | 1.563 | 51978.2 |
118 | 2020-01-06 21:24:08 | prefabbed | 1 | 81242 | 1 | 1.530 | 53099.3 |
117 | 2019-12-06 04:47:22 | prefabbed | 1 | 81242 | 1 | 1.360 | 59736.8 |
116 | 2019-09-04 02:11:53 | prefabbed | 1 | 81242 | 1 | 1.463 | 55531.1 |
115 | 2019-07-23 18:25:25 | prefabbed | 1 | 81242 | 1 | 1.373 | 59171.2 |
114 | 2019-05-26 02:54:36 | prefabbed | 1 | 81242 | 1 | 1.400 | 58030.0 |
113 | 2019-04-04 12:50:46 | prefabbed | 4 | 165329 | 435 | 10.730 | 15408.1 |
112 | 2019-03-15 03:13:14 | prefabbed | 4 | 165329 | 435 | 12.350 | 13387.0 |
111 | 2019-03-01 17:25:39 | prefabbed | 1 | 81242 | 1 | 1.426 | 56971.9 |
110 | 2019-02-02 05:23:25 | prefabbed | 1 | 81242 | 1 | 1.356 | 59913.0 |
109 | 2019-01-28 20:34:21 | prefabbed | 1 | 81242 | 1 | 2.923 | 27794.0 |
108 | 2018-11-10 08:47:23 | prefabbed | 1 | 81242 | 1 | 1.290 | 62978.3 |
107 | 2018-09-25 16:45:33 | prefabbed | 1 | 81242 | 1 | 1.353 | 60045.8 |
106 | 2018-06-25 20:18:10 | prefabbed | 1 | 81242 | 1 | 1.536 | 52891.9 |
105 | 2018-03-31 04:21:59 | prefabbed | 1 | 81242 | 1 | 3.190 | 25467.7 |
104 | 2018-03-02 00:38:15 | prefabbed | 1 | 81242 | 1 | 1.906 | 42624.3 |
103 | 2018-02-12 08:32:41 | prefabbed | 4 | 165329 | 435 | 16.023 | 10318.2 |
102 | 2018-02-08 21:41:10 | prefabbed | 4 | 165329 | 435 | 17.630 | 9377.7 |
101 | 2018-02-08 14:12:53 | prefabbed | 4 | 165329 | 435 | 23.126 | 7149.1 |
100 | 2018-02-08 02:51:17 | prefabbed | 1 | 81242 | 1 | 2.166 | 37507.8 |
99 | 2018-01-04 06:34:38 | prefabbed | 1 | 81242 | 1 | 2.296 | 35384.1 |
98 | 2017-12-30 00:18:01 | prefabbed | 1 | 81242 | 1 | 2.393 | 33949.9 |
97 | 2017-11-11 16:08:42 | prefabbed | 1 | 81242 | 1 | 1.786 | 45488.2 |
96 | 2017-07-18 09:48:15 | prefabbed | 1 | 81242 | 1 | 1.946 | 41748.2 |
95 | 2017-06-01 13:14:23 | prefabbed | 4 | 165329 | 435 | 19.170 | 8624.4 |
94 | 2017-05-24 16:49:26 | prefabbed | 4 | 165329 | 435 | 14.463 | 11431.2 |
93 | 2017-01-20 02:19:10 | prefabbed | 4 | 165329 | 435 | 14.590 | 11331.7 |
92 | 2017-01-20 01:56:24 | prefabbed | 4 | 165329 | 435 | 14.240 | 11610.2 |
91 | 2017-01-18 12:14:11 | prefabbed | 4 | 165329 | 435 | 14.280 | 11577.7 |
90 | 2017-01-17 08:27:53 | prefabbed | 4 | 165329 | 435 | 14.796 | 11173.9 |
89 | 2016-11-05 23:57:38 | prefabbed | 1 | 81242 | 1 | 2.096 | 38760.5 |
88 | 2016-11-04 08:00:05 | prefabbed | 1 | 81242 | 1 | 1.883 | 43145.0 |
87 | 2016-10-21 03:07:57 | prefabbed | 1 | 81242 | 1 | 2.106 | 38576.4 |
86 | 2016-09-19 14:50:40 | prefabbed | 1 | 81242 | 1 | 2.086 | 38946.3 |
85 | 2016-09-11 12:45:06 | prefabbed | 2 | 121436 | 4 | 5.560 | 21841.0 |
84 | 2016-09-06 01:22:58 | prefabbed | 4 | 165329 | 435 | 16.926 | 9767.8 |
83 | 2016-09-06 00:09:45 | prefabbed | 4 | 165329 | 435 | 14.426 | 11460.5 |
82 | 2016-09-05 21:42:08 | prefabbed | 4 | 165329 | 435 | 22.513 | 7343.7 |
81 | 2016-08-30 22:56:21 | prefabbed | 3 | 148641 | 47 | 9.770 | 15214.0 |
80 | 2016-08-22 13:22:04 | prefabbed | 1 | 81242 | 1 | 4.186 | 19408.0 |
79 | 2016-08-12 02:22:30 | prefabbed | 1 | 81242 | 1 | 2.080 | 39058.7 |
78 | 2016-08-04 11:21:39 | prefabbed | 1 | 81242 | 1 | 1.680 | 48358.3 |
77 | 2016-08-02 05:32:12 | prefabbed | 1 | 81242 | 1 | 1.700 | 47789.4 |
76 | 2016-07-03 10:22:59 | prefabbed | 1 | 81242 | 1 | 2.220 | 36595.5 |
75 | 2016-07-01 12:00:07 | prefabbed | 1 | 81242 | 1 | 2.213 | 36711.3 |
74 | 2016-06-24 21:50:50 | prefabbed | 1 | 81242 | 1 | 1.986 | 40907.4 |
73 | 2016-06-06 00:46:44 | prefabbed | 1 | 81242 | 1 | 2.266 | 35852.6 |
72 | 2016-04-24 09:40:45 | prefabbed | 1 | 81242 | 1 | 8.193 | 9916.0 |
71 | 2016-03-02 19:44:59 | prefabbed | 1 | 81242 | 1 | 1.393 | 58321.6 |
70 | 2015-12-27 16:33:53 | prefabbed | 1 | 81242 | 1 | 2.023 | 40159.2 |
69 | 2015-12-15 19:00:05 | prefabbed | 1 | 81242 | 1 | 1.386 | 58616.2 |
68 | 2015-11-24 21:10:54 | prefabbed | 1 | 81242 | 1 | 1.450 | 56029.0 |
67 | 2015-11-05 11:11:25 | prefabbed | 1 | 81242 | 1 | 1.486 | 54671.6 |
66 | 2015-10-25 13:34:24 | prefabbed | 1 | 81242 | 1 | 1.463 | 55531.1 |