History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"phytogeny"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
155 | 2024-04-29 08:37:46 | phytogeny | 4 | 165329 | 113 | 36.050 | 4586.1 |
154 | 2024-04-29 08:37:49 | phytogeny | 2 | 121436 | 4 | 10.093 | 12031.7 |
153 | 2024-04-29 08:31:45 | phytogeny | 1 | 81242 | 2 | 2.280 | 35632.5 |
152 | 2024-04-26 08:20:40 | phytogeny | 1 | 81242 | 2 | 2.300 | 35322.6 |
151 | 2024-04-09 21:43:11 | phytogeny | 1 | 81242 | 2 | 2.390 | 33992.5 |
150 | 2024-04-09 05:44:45 | phytogeny | 3 | 148641 | 23 | 25.596 | 5807.2 |
149 | 2024-04-09 05:44:47 | phytogeny | 2 | 121436 | 4 | 8.893 | 13655.2 |
148 | 2024-04-09 05:15:11 | phytogeny | 1 | 81242 | 2 | 1.513 | 53696.0 |
147 | 2024-04-06 06:12:08 | phytogeny | 1 | 81242 | 2 | 3.093 | 26266.4 |
146 | 2024-03-27 20:19:52 | phytogeny | 4 | 165329 | 113 | 24.236 | 6821.6 |
145 | 2024-03-27 03:08:28 | phytogeny | 4 | 165329 | 113 | 30.143 | 5484.8 |
144 | 2024-03-27 03:08:31 | phytogeny | 3 | 148641 | 23 | 19.800 | 7507.1 |
143 | 2024-03-27 03:08:41 | phytogeny | 2 | 121436 | 4 | 4.250 | 28573.2 |
142 | 2024-03-27 02:02:53 | phytogeny | 1 | 81242 | 2 | 1.390 | 58447.5 |
141 | 2024-03-25 18:05:25 | phytogeny | 1 | 81242 | 2 | 3.186 | 25499.7 |
140 | 2024-03-05 09:15:31 | phytogeny | 1 | 81242 | 2 | 1.406 | 57782.4 |
139 | 2024-03-04 23:55:54 | phytogeny | 1 | 81242 | 2 | 2.890 | 28111.4 |
138 | 2024-03-02 21:17:37 | phytogeny | 3 | 148641 | 23 | 18.640 | 7974.3 |
137 | 2024-03-02 21:17:38 | phytogeny | 2 | 121436 | 4 | 4.470 | 27166.9 |
136 | 2024-03-02 21:05:43 | phytogeny | 1 | 81242 | 2 | 1.313 | 61875.1 |
135 | 2024-02-29 11:29:52 | phytogeny | 4 | 165329 | 113 | 12.656 | 13063.3 |
134 | 2024-02-25 11:20:04 | phytogeny | 4 | 165329 | 113 | 23.576 | 7012.6 |
133 | 2024-02-25 11:20:10 | phytogeny | 2 | 121436 | 4 | 10.550 | 11510.5 |
132 | 2024-02-25 11:20:02 | phytogeny | 3 | 148641 | 23 | 16.186 | 9183.3 |
131 | 2024-02-25 08:42:58 | phytogeny | 1 | 81242 | 2 | 1.673 | 48560.7 |
130 | 2024-02-20 22:23:46 | phytogeny | 2 | 121436 | 4 | 3.656 | 33215.5 |
129 | 2024-02-10 17:03:01 | phytogeny | 1 | 81242 | 2 | 1.563 | 51978.2 |
128 | 2024-02-07 12:48:22 | phytogeny | 1 | 81242 | 2 | 1.500 | 54161.3 |
127 | 2024-02-01 06:53:16 | phytogeny | 1 | 81242 | 2 | 1.390 | 58447.5 |
126 | 2024-01-30 11:51:15 | phytogeny | 1 | 81242 | 2 | 1.373 | 59171.2 |
125 | 2024-01-29 20:14:34 | phytogeny | 1 | 81242 | 2 | 1.436 | 56575.2 |
124 | 2023-12-26 04:14:35 | phytogeny | 1 | 81242 | 2 | 1.423 | 57092.1 |
123 | 2023-12-22 15:56:55 | phytogeny | 1 | 81242 | 2 | 1.236 | 65729.8 |
122 | 2023-12-01 11:49:23 | phytogeny | 1 | 81242 | 2 | 1.280 | 63470.3 |
121 | 2023-11-28 04:13:59 | phytogeny | 1 | 81242 | 2 | 1.233 | 65889.7 |
120 | 2023-11-18 05:58:56 | phytogeny | 2 | 121436 | 4 | 2.936 | 41361.0 |
119 | 2023-09-13 11:04:50 | phytogeny | 1 | 81242 | 2 | 1.236 | 65729.8 |
118 | 2023-08-19 23:40:23 | phytogeny | 2 | 121436 | 4 | 2.920 | 41587.7 |
117 | 2023-07-25 16:09:58 | phytogeny | 1 | 81242 | 2 | 1.406 | 57782.4 |
116 | 2023-06-28 14:01:40 | phytogeny | 1 | 81242 | 2 | 1.423 | 57092.1 |
115 | 2023-05-04 07:44:24 | phytogeny | 2 | 121436 | 4 | 3.736 | 32504.3 |
114 | 2023-04-05 07:14:46 | phytogeny | 1 | 81242 | 2 | 1.330 | 61084.2 |
113 | 2023-03-03 02:50:28 | phytogeny | 1 | 81242 | 2 | 1.186 | 68500.8 |
112 | 2023-02-08 16:22:16 | phytogeny | 2 | 121436 | 4 | 2.953 | 41122.9 |
111 | 2023-01-20 12:39:30 | phytogeny | 1 | 81242 | 2 | 1.186 | 68500.8 |
110 | 2022-11-22 17:22:21 | phytogeny | 2 | 121436 | 4 | 3.046 | 39867.4 |
109 | 2022-11-17 19:56:59 | phytogeny | 1 | 81242 | 2 | 1.266 | 64172.2 |
108 | 2022-10-13 01:15:28 | phytogeny | 1 | 81242 | 2 | 1.280 | 63470.3 |
107 | 2022-07-09 18:42:08 | phytogeny | 1 | 81242 | 2 | 1.203 | 67532.8 |
106 | 2022-06-27 03:22:45 | phytogeny | 2 | 121436 | 4 | 3.186 | 38115.5 |
105 | 2022-05-11 23:59:28 | phytogeny | 1 | 81242 | 2 | 1.766 | 46003.4 |
104 | 2022-03-29 13:04:56 | phytogeny | 1 | 81242 | 2 | 1.796 | 45235.0 |
103 | 2021-12-19 12:11:44 | phytogeny | 1 | 81242 | 2 | 1.236 | 65729.8 |
102 | 2021-08-13 13:24:58 | phytogeny | 1 | 81242 | 2 | 1.296 | 62686.7 |
101 | 2021-04-25 10:25:27 | phytogeny | 1 | 81242 | 2 | 2.750 | 29542.5 |
100 | 2021-02-22 13:52:41 | phytogeny | 1 | 81242 | 2 | 1.516 | 53589.7 |
99 | 2020-12-27 20:47:02 | phytogeny | 1 | 81242 | 2 | 1.250 | 64993.6 |
98 | 2020-11-07 11:50:24 | phytogeny | 1 | 81242 | 2 | 1.250 | 64993.6 |
97 | 2020-09-16 13:41:25 | phytogeny | 1 | 81242 | 2 | 1.233 | 65889.7 |
96 | 2020-05-19 18:00:18 | phytogeny | 1 | 81242 | 2 | 1.203 | 67532.8 |
95 | 2020-03-29 02:20:21 | phytogeny | 1 | 81242 | 2 | 1.233 | 65889.7 |
94 | 2020-03-23 00:51:47 | phytogeny | 1 | 81242 | 2 | 1.436 | 56575.2 |
93 | 2020-02-13 00:50:43 | phytogeny | 1 | 81242 | 2 | 1.593 | 50999.4 |
92 | 2020-02-05 07:33:01 | phytogeny | 1 | 81242 | 2 | 2.920 | 27822.6 |
91 | 2020-02-04 16:13:18 | phytogeny | 1 | 81242 | 2 | 1.483 | 54782.2 |
90 | 2020-01-31 13:37:52 | phytogeny | 1 | 81242 | 2 | 3.173 | 25604.2 |
89 | 2020-01-31 09:35:40 | phytogeny | 1 | 81242 | 2 | 4.670 | 17396.6 |
88 | 2020-01-24 03:48:19 | phytogeny | 1 | 81242 | 2 | 4.126 | 19690.3 |
87 | 2020-01-19 06:54:09 | phytogeny | 1 | 81242 | 2 | 1.373 | 59171.2 |
86 | 2020-01-15 21:42:17 | phytogeny | 1 | 81242 | 2 | 3.046 | 26671.7 |
85 | 2020-01-07 00:05:48 | phytogeny | 1 | 81242 | 2 | 3.313 | 24522.2 |
84 | 2019-12-31 14:16:47 | phytogeny | 1 | 81242 | 2 | 1.250 | 64993.6 |
83 | 2019-10-22 11:07:57 | phytogeny | 1 | 81242 | 2 | 1.376 | 59042.2 |
82 | 2019-07-02 04:01:28 | phytogeny | 1 | 81242 | 2 | 1.416 | 57374.3 |
81 | 2019-02-28 11:22:25 | phytogeny | 1 | 81242 | 2 | 1.320 | 61547.0 |
80 | 2019-02-20 15:27:34 | phytogeny | 1 | 81242 | 2 | 1.190 | 68270.6 |
79 | 2019-02-17 06:38:24 | phytogeny | 1 | 81242 | 2 | 1.343 | 60492.9 |
78 | 2018-11-19 01:15:47 | phytogeny | 1 | 81242 | 2 | 1.200 | 67701.7 |
77 | 2018-11-02 12:00:02 | phytogeny | 1 | 81242 | 2 | 1.380 | 58871.0 |
76 | 2018-07-23 09:59:13 | phytogeny | 1 | 81242 | 2 | 1.340 | 60628.4 |
75 | 2018-06-24 19:32:33 | phytogeny | 1 | 81242 | 2 | 1.406 | 57782.4 |
74 | 2018-06-20 20:46:26 | phytogeny | 1 | 81242 | 2 | 1.643 | 49447.4 |
73 | 2018-05-30 03:03:55 | phytogeny | 1 | 81242 | 2 | 1.230 | 66050.4 |
72 | 2018-05-14 03:50:25 | phytogeny | 1 | 81242 | 2 | 1.423 | 57092.1 |
71 | 2018-03-23 06:54:06 | phytogeny | 1 | 81242 | 2 | 2.213 | 36711.3 |
70 | 2018-01-03 16:20:32 | phytogeny | 1 | 81242 | 2 | 2.213 | 36711.3 |
69 | 2017-11-11 04:52:00 | phytogeny | 1 | 81242 | 2 | 2.253 | 36059.5 |
68 | 2017-06-14 07:21:51 | phytogeny | 1 | 81242 | 2 | 1.626 | 49964.3 |
67 | 2017-06-14 07:15:06 | phytogeny | 1 | 81242 | 2 | 1.616 | 50273.5 |
66 | 2017-06-03 10:55:51 | phytogeny | 1 | 81242 | 2 | 2.156 | 37681.8 |
65 | 2017-05-30 10:12:22 | phytogeny | 1 | 81242 | 2 | 1.716 | 47343.8 |
64 | 2017-03-09 23:55:28 | phytogeny | 1 | 81242 | 2 | 1.720 | 47233.7 |
63 | 2017-01-08 01:47:42 | phytogeny | 1 | 81242 | 2 | 1.523 | 53343.4 |
62 | 2016-12-30 12:15:46 | phytogeny | 1 | 81242 | 2 | 1.500 | 54161.3 |
61 | 2016-09-05 16:04:25 | phytogeny | 1 | 81242 | 2 | 1.633 | 49750.2 |
60 | 2016-08-24 12:03:46 | phytogeny | 1 | 81242 | 2 | 1.690 | 48072.2 |
59 | 2016-08-20 01:19:04 | phytogeny | 1 | 81242 | 2 | 2.120 | 38321.7 |
58 | 2016-07-14 10:18:44 | phytogeny | 4 | 165329 | 113 | 41.480 | 3985.8 |
57 | 2016-07-14 10:13:35 | phytogeny | 2 | 121436 | 4 | 8.556 | 14193.1 |
56 | 2016-07-13 08:03:50 | phytogeny | 3 | 148641 | 23 | 13.820 | 10755.5 |