History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"zyzzyva"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
7150 | 2023-05-27 14:44:32 | zyzzyva | 1 | 69583 | 2 | 1.126 | 61796.6 |
7149 | 2023-05-22 07:18:49 | zyzzyva | 5 | 162725 | 426 | 13.343 | 12195.5 |
7148 | 2023-05-19 10:35:46 | zyzzyva | 1 | 69583 | 2 | 1.156 | 60192.9 |
7147 | 2023-05-14 04:34:38 | zyzzyva | 1 | 69583 | 2 | 1.046 | 66522.9 |
7146 | 2023-05-07 17:27:36 | zyzzyva | 2 | 107671 | 2 | 2.563 | 42009.8 |
7145 | 2023-05-06 11:33:32 | zyzzyva | 5 | 162725 | 426 | 13.360 | 12180.0 |
7144 | 2023-05-06 11:33:29 | zyzzyva | 1 | 69583 | 2 | 0.970 | 71735.1 |
7143 | 2023-04-28 23:04:59 | zyzzyva | 1 | 69583 | 2 | 1.653 | 42095.0 |
7142 | 2023-04-22 13:36:00 | zyzzyva | 1 | 69583 | 2 | 0.983 | 70786.4 |
7141 | 2023-04-19 21:29:35 | zyzzyva | 1 | 69583 | 2 | 1.000 | 69583.0 |
7140 | 2023-04-18 17:40:10 | zyzzyva | 4 | 151207 | 25 | 8.470 | 17852.1 |
7139 | 2023-03-30 21:45:24 | zyzzyva | 5 | 162725 | 426 | 12.673 | 12840.3 |
7138 | 2023-03-29 04:14:42 | zyzzyva | 5 | 162725 | 426 | 15.173 | 10724.6 |
7137 | 2023-03-27 13:28:39 | zyzzyva | 5 | 162725 | 426 | 15.640 | 10404.4 |
7136 | 2023-03-27 13:28:28 | zyzzyva | 4 | 151207 | 25 | 10.970 | 13783.7 |
7135 | 2023-03-27 13:28:22 | zyzzyva | 3 | 134027 | 2 | 6.313 | 21230.3 |
7134 | 2023-03-27 13:28:19 | zyzzyva | 2 | 107671 | 2 | 2.890 | 37256.4 |
7133 | 2023-03-27 13:06:14 | zyzzyva | 1 | 69583 | 2 | 0.983 | 70786.4 |
7132 | 2023-03-17 12:51:40 | zyzzyva | 1 | 69583 | 2 | 1.110 | 62687.4 |
7131 | 2023-03-15 00:29:51 | zyzzyva | 1 | 69583 | 2 | 1.153 | 60349.5 |
7130 | 2023-03-14 16:26:56 | zyzzyva | 5 | 162725 | 426 | 13.156 | 12368.9 |
7129 | 2023-03-14 16:26:47 | zyzzyva | 4 | 151207 | 25 | 9.470 | 15966.9 |
7128 | 2023-03-14 16:26:42 | zyzzyva | 3 | 134027 | 2 | 5.046 | 26561.0 |
7127 | 2023-03-14 16:26:39 | zyzzyva | 2 | 107671 | 2 | 2.563 | 42009.8 |
7126 | 2023-03-14 16:03:15 | zyzzyva | 1 | 69583 | 2 | 1.126 | 61796.6 |
7125 | 2023-03-12 11:50:01 | zyzzyva | 5 | 162725 | 426 | 15.673 | 10382.5 |
7124 | 2023-03-12 11:50:01 | zyzzyva | 4 | 151207 | 25 | 10.953 | 13805.1 |
7123 | 2023-03-12 11:50:01 | zyzzyva | 3 | 134027 | 2 | 6.643 | 20175.7 |
7122 | 2023-03-12 11:50:01 | zyzzyva | 2 | 107671 | 2 | 3.110 | 34620.9 |
7121 | 2023-03-12 11:40:53 | zyzzyva | 1 | 69583 | 2 | 1.170 | 59472.6 |
7120 | 2023-03-10 07:11:29 | zyzzyva | 5 | 162725 | 426 | 14.436 | 11272.2 |
7119 | 2023-03-10 07:11:19 | zyzzyva | 4 | 151207 | 25 | 9.610 | 15734.3 |
7118 | 2023-03-10 07:11:14 | zyzzyva | 3 | 134027 | 2 | 5.436 | 24655.4 |
7117 | 2023-03-10 07:11:11 | zyzzyva | 2 | 107671 | 2 | 2.576 | 41797.7 |
7116 | 2023-03-10 06:44:20 | zyzzyva | 1 | 69583 | 2 | 1.076 | 64668.2 |
7115 | 2023-03-07 15:34:01 | zyzzyva | 5 | 162725 | 426 | 12.673 | 12840.3 |
7114 | 2023-03-06 05:15:48 | zyzzyva | 1 | 69583 | 2 | 1.173 | 59320.5 |
7113 | 2023-03-02 21:25:24 | zyzzyva | 5 | 162725 | 426 | 12.876 | 12637.9 |
7112 | 2023-02-28 18:44:25 | zyzzyva | 5 | 162725 | 426 | 12.436 | 13085.0 |
7111 | 2023-02-18 04:38:31 | zyzzyva | 1 | 69583 | 2 | 1.063 | 65459.1 |
7110 | 2023-02-13 17:32:45 | zyzzyva | 2 | 107671 | 2 | 2.813 | 38276.2 |
7109 | 2023-02-13 15:04:24 | zyzzyva | 1 | 69583 | 2 | 0.986 | 70571.0 |
7108 | 2023-02-07 16:57:24 | zyzzyva | 1 | 69583 | 2 | 0.986 | 70571.0 |
7107 | 2023-01-30 06:46:00 | zyzzyva | 5 | 162725 | 426 | 13.670 | 11903.8 |
7106 | 2023-01-30 06:45:50 | zyzzyva | 4 | 151207 | 25 | 10.016 | 15096.5 |
7105 | 2023-01-30 06:45:44 | zyzzyva | 3 | 134027 | 2 | 5.470 | 24502.2 |
7104 | 2023-01-30 06:45:41 | zyzzyva | 2 | 107671 | 2 | 2.513 | 42845.6 |
7103 | 2023-01-30 06:15:47 | zyzzyva | 1 | 69583 | 2 | 1.016 | 68487.2 |
7102 | 2023-01-29 19:13:48 | zyzzyva | 1 | 69583 | 2 | 1.000 | 69583.0 |
7101 | 2023-01-27 09:17:32 | zyzzyva | 1 | 69583 | 2 | 1.123 | 61961.7 |
7100 | 2023-01-26 17:27:52 | zyzzyva | 5 | 162725 | 426 | 14.780 | 11009.8 |
7099 | 2023-01-26 17:27:43 | zyzzyva | 4 | 151207 | 25 | 8.516 | 17755.6 |
7098 | 2023-01-26 17:27:38 | zyzzyva | 3 | 134027 | 2 | 4.983 | 26896.8 |
7097 | 2023-01-26 17:27:35 | zyzzyva | 2 | 107671 | 2 | 2.563 | 42009.8 |
7096 | 2023-01-26 16:58:50 | zyzzyva | 1 | 69583 | 2 | 1.076 | 64668.2 |
7095 | 2023-01-26 10:21:09 | zyzzyva | 4 | 151207 | 25 | 8.466 | 17860.5 |
7094 | 2023-01-23 21:55:29 | zyzzyva | 1 | 69583 | 2 | 1.093 | 63662.4 |
7093 | 2023-01-20 18:32:18 | zyzzyva | 1 | 69583 | 2 | 0.970 | 71735.1 |
7092 | 2023-01-19 04:11:36 | zyzzyva | 5 | 162725 | 426 | 13.046 | 12473.2 |
7091 | 2023-01-17 08:23:14 | zyzzyva | 5 | 162725 | 426 | 17.266 | 9424.6 |
7090 | 2023-01-17 08:23:12 | zyzzyva | 4 | 151207 | 25 | 11.360 | 13310.5 |
7089 | 2023-01-17 08:23:11 | zyzzyva | 3 | 134027 | 2 | 6.796 | 19721.5 |
7088 | 2023-01-17 08:23:10 | zyzzyva | 2 | 107671 | 2 | 3.250 | 33129.5 |
7087 | 2023-01-17 08:14:04 | zyzzyva | 1 | 69583 | 2 | 1.190 | 58473.1 |
7086 | 2023-01-15 22:17:44 | zyzzyva | 4 | 151207 | 25 | 8.690 | 17400.1 |
7085 | 2023-01-10 00:27:09 | zyzzyva | 1 | 69583 | 2 | 1.016 | 68487.2 |
7084 | 2023-01-06 17:06:10 | zyzzyva | 1 | 69583 | 2 | 1.030 | 67556.3 |
7083 | 2023-01-03 00:22:13 | zyzzyva | 1 | 69583 | 2 | 1.093 | 63662.4 |
7082 | 2023-01-02 13:20:18 | zyzzyva | 1 | 69583 | 2 | 1.016 | 68487.2 |
7081 | 2023-01-02 05:37:03 | zyzzyva | 1 | 69583 | 2 | 0.970 | 71735.1 |
7080 | 2022-12-31 02:18:58 | zyzzyva | 1 | 69583 | 2 | 1.000 | 69583.0 |
7079 | 2022-12-29 16:48:53 | zyzzyva | 5 | 162725 | 426 | 13.140 | 12383.9 |
7078 | 2022-12-29 16:48:43 | zyzzyva | 4 | 151207 | 25 | 9.220 | 16399.9 |
7077 | 2022-12-29 16:48:37 | zyzzyva | 3 | 134027 | 2 | 5.720 | 23431.3 |
7076 | 2022-12-29 16:48:34 | zyzzyva | 2 | 107671 | 2 | 2.796 | 38508.9 |
7075 | 2022-12-29 16:26:29 | zyzzyva | 1 | 69583 | 2 | 1.123 | 61961.7 |
7074 | 2022-12-29 10:40:58 | zyzzyva | 1 | 69583 | 2 | 1.093 | 63662.4 |
7073 | 2022-12-28 12:53:45 | zyzzyva | 1 | 69583 | 2 | 1.126 | 61796.6 |
7072 | 2022-12-24 06:34:10 | zyzzyva | 1 | 69583 | 2 | 1.053 | 66080.7 |
7071 | 2022-12-22 07:30:53 | zyzzyva | 1 | 69583 | 2 | 0.983 | 70786.4 |
7070 | 2022-12-21 00:31:13 | zyzzyva | 1 | 69583 | 2 | 0.983 | 70786.4 |
7069 | 2022-12-18 05:34:18 | zyzzyva | 5 | 162725 | 426 | 13.436 | 12111.1 |
7068 | 2022-12-16 18:14:19 | zyzzyva | 1 | 69583 | 2 | 0.983 | 70786.4 |
7067 | 2022-12-15 04:27:34 | zyzzyva | 1 | 69583 | 2 | 1.170 | 59472.6 |
7066 | 2022-12-14 08:10:48 | zyzzyva | 5 | 162725 | 426 | 15.893 | 10238.8 |
7065 | 2022-12-14 08:10:37 | zyzzyva | 4 | 151207 | 25 | 10.720 | 14105.1 |
7064 | 2022-12-14 08:10:31 | zyzzyva | 3 | 134027 | 2 | 6.203 | 21606.8 |
7063 | 2022-12-14 08:10:27 | zyzzyva | 2 | 107671 | 2 | 3.030 | 35535.0 |
7062 | 2022-12-14 07:37:19 | zyzzyva | 1 | 69583 | 2 | 0.986 | 70571.0 |
7061 | 2022-12-09 22:26:21 | zyzzyva | 5 | 162725 | 426 | 26.470 | 6147.5 |
7060 | 2022-11-26 08:34:33 | zyzzyva | 1 | 69583 | 2 | 1.000 | 69583.0 |
7059 | 2022-11-24 06:58:56 | zyzzyva | 5 | 162725 | 426 | 13.423 | 12122.8 |
7058 | 2022-11-24 06:58:36 | zyzzyva | 5 | 162725 | 426 | 12.686 | 12827.1 |
7057 | 2022-11-24 06:58:16 | zyzzyva | 5 | 162725 | 426 | 13.220 | 12309.0 |
7056 | 2022-11-24 06:58:03 | zyzzyva | 4 | 151207 | 25 | 8.610 | 17561.8 |
7055 | 2022-11-24 06:57:43 | zyzzyva | 4 | 151207 | 25 | 17.983 | 8408.3 |
7054 | 2022-11-24 06:57:22 | zyzzyva | 4 | 151207 | 25 | 14.093 | 10729.2 |
7053 | 2022-11-24 06:57:13 | zyzzyva | 3 | 134027 | 2 | 5.810 | 23068.3 |
7052 | 2022-11-24 06:57:03 | zyzzyva | 2 | 107671 | 2 | 5.826 | 18481.1 |
7051 | 2022-11-24 01:24:24 | zyzzyva | 2 | 107671 | 2 | 2.563 | 42009.8 |