History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1139 | 2025-07-15 13:45:03 | pier | 1 | 13983 | 17 | 0.970 | 14415.5 |
1138 | 2025-07-13 09:26:26 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
1137 | 2025-07-12 00:40:23 | pier | 1 | 13983 | 17 | 0.263 | 53167.3 |
1136 | 2025-07-11 01:03:45 | pier | 2 | 29872 | 380 | 6.423 | 4650.8 |
1135 | 2025-07-09 18:30:18 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
1134 | 2025-07-09 06:35:21 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
1133 | 2025-07-08 04:33:27 | pier | 1 | 13983 | 17 | 0.983 | 14224.8 |
1132 | 2025-07-08 01:53:42 | pier | 1 | 13983 | 17 | 0.690 | 20265.2 |
1131 | 2025-07-03 08:52:08 | pier | 2 | 29872 | 380 | 0.783 | 38150.7 |
1130 | 2025-07-02 18:35:15 | pier | 1 | 13983 | 17 | 0.580 | 24108.6 |
1129 | 2025-07-02 15:55:22 | pier | 1 | 13983 | 17 | 1.826 | 7657.7 |
1128 | 2025-07-01 16:22:05 | pier | 2 | 29872 | 380 | 0.970 | 30795.9 |
1127 | 2025-07-01 04:20:29 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
1126 | 2025-06-30 14:16:44 | pier | 1 | 13983 | 17 | 1.173 | 11920.7 |
1125 | 2025-06-29 12:59:01 | pier | 2 | 29872 | 380 | 2.046 | 14600.2 |
1124 | 2025-06-28 23:15:05 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
1123 | 2025-06-28 22:59:31 | pier | 1 | 13983 | 17 | 1.530 | 9139.2 |
1122 | 2025-06-19 14:31:33 | pier | 2 | 29872 | 380 | 0.766 | 38997.4 |
1121 | 2025-06-17 19:14:36 | pier | 1 | 13983 | 17 | 2.126 | 6577.1 |
1120 | 2025-06-15 18:50:37 | pier | 2 | 29872 | 380 | 3.140 | 9513.4 |
1119 | 2025-06-15 12:46:54 | pier | 1 | 13983 | 17 | 0.236 | 59250.0 |
1118 | 2025-06-12 05:41:30 | pier | 1 | 13983 | 17 | 0.670 | 20870.1 |
1117 | 2025-06-11 01:02:28 | pier | 1 | 13983 | 17 | 1.156 | 12096.0 |
1116 | 2025-06-10 08:26:35 | pier | 2 | 29872 | 380 | 5.843 | 5112.4 |
1115 | 2025-06-04 14:26:39 | pier | 1 | 13983 | 17 | 0.970 | 14415.5 |
1114 | 2025-06-01 15:00:39 | pier | 2 | 29872 | 380 | 3.640 | 8206.6 |
1113 | 2025-06-01 14:57:41 | pier | 1 | 13983 | 17 | 1.326 | 10545.2 |
1112 | 2025-06-01 07:29:52 | pier | 2 | 29872 | 380 | 4.470 | 6682.8 |
1111 | 2025-05-31 20:19:55 | pier | 1 | 13983 | 17 | 1.626 | 8599.6 |
1110 | 2025-05-31 06:41:16 | pier | 1 | 13983 | 17 | 1.610 | 8685.1 |
1109 | 2025-05-30 11:57:13 | pier | 2 | 29872 | 380 | 5.390 | 5542.1 |
1108 | 2025-05-28 22:24:20 | pier | 1 | 13983 | 17 | 0.813 | 17199.3 |
1107 | 2025-05-27 16:53:30 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
1106 | 2025-05-15 14:04:30 | pier | 1 | 13983 | 17 | 0.783 | 17858.2 |
1105 | 2025-05-15 13:13:35 | pier | 1 | 13983 | 17 | 0.703 | 19890.5 |
1104 | 2025-05-14 09:59:33 | pier | 1 | 13983 | 17 | 0.296 | 47239.9 |
1103 | 2025-05-11 23:09:47 | pier | 1 | 13983 | 17 | 1.670 | 8373.1 |
1102 | 2025-05-11 16:18:58 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
1101 | 2025-05-11 02:10:22 | pier | 1 | 13983 | 17 | 0.483 | 28950.3 |
1100 | 2025-05-09 18:02:22 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
1099 | 2025-05-08 13:01:15 | pier | 1 | 13983 | 17 | 1.530 | 9139.2 |
1098 | 2025-05-01 15:01:14 | pier | 1 | 13983 | 17 | 0.280 | 49939.3 |
1097 | 2025-04-29 00:11:39 | pier | 1 | 13983 | 17 | 0.670 | 20870.1 |
1096 | 2025-04-28 01:42:00 | pier | 1 | 13983 | 17 | 0.686 | 20383.4 |
1095 | 2025-04-27 22:27:24 | pier | 1 | 13983 | 17 | 0.970 | 14415.5 |
1094 | 2025-04-19 16:43:54 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
1093 | 2025-04-18 19:53:36 | pier | 1 | 13983 | 17 | 1.936 | 7222.6 |
1092 | 2025-04-14 12:22:33 | pier | 1 | 13983 | 17 | 2.250 | 6214.7 |
1091 | 2025-04-11 01:35:29 | pier | 1 | 13983 | 17 | 1.046 | 13368.1 |
1090 | 2025-04-08 19:14:23 | pier | 2 | 29872 | 380 | 5.343 | 5590.9 |
1089 | 2025-04-08 09:10:58 | pier | 2 | 29872 | 380 | 4.046 | 7383.1 |
1088 | 2025-04-07 00:44:58 | pier | 1 | 13983 | 17 | 1.080 | 12947.2 |
1087 | 2025-04-06 21:14:59 | pier | 2 | 29872 | 380 | 4.360 | 6851.4 |
1086 | 2025-04-05 15:17:08 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
1085 | 2025-03-31 17:47:08 | pier | 1 | 13983 | 17 | 0.423 | 33056.7 |
1084 | 2025-03-30 13:34:50 | pier | 1 | 13983 | 17 | 0.203 | 68881.8 |
1083 | 2025-03-27 22:45:49 | pier | 1 | 13983 | 17 | 0.203 | 68881.8 |
1082 | 2025-03-15 16:57:01 | pier | 2 | 29872 | 380 | 4.156 | 7187.7 |
1081 | 2025-03-15 16:25:27 | pier | 2 | 29872 | 380 | 0.906 | 32971.3 |
1080 | 2025-03-14 21:16:28 | pier | 1 | 13983 | 17 | 1.720 | 8129.7 |
1079 | 2025-03-12 08:41:46 | pier | 1 | 13983 | 17 | 2.530 | 5526.9 |
1078 | 2025-03-11 07:35:56 | pier | 1 | 13983 | 17 | 0.890 | 15711.2 |
1077 | 2025-03-10 09:11:38 | pier | 2 | 29872 | 380 | 1.860 | 16060.2 |
1076 | 2025-03-10 08:23:32 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
1075 | 2025-03-07 03:06:24 | pier | 2 | 29872 | 380 | 2.436 | 12262.7 |
1074 | 2025-03-07 02:44:12 | pier | 1 | 13983 | 17 | 1.266 | 11045.0 |
1073 | 2025-02-26 01:02:32 | pier | 1 | 13983 | 17 | 1.030 | 13575.7 |
1072 | 2025-02-25 20:20:46 | pier | 2 | 29872 | 380 | 2.533 | 11793.1 |
1071 | 2025-02-25 09:01:31 | pier | 1 | 13983 | 17 | 1.796 | 7785.6 |
1070 | 2025-02-25 03:10:05 | pier | 2 | 29872 | 380 | 2.643 | 11302.3 |
1069 | 2025-02-25 01:43:47 | pier | 2 | 29872 | 380 | 2.423 | 12328.5 |
1068 | 2025-02-21 05:41:17 | pier | 1 | 13983 | 17 | 0.330 | 42372.7 |
1067 | 2025-02-18 01:44:30 | pier | 1 | 13983 | 17 | 0.580 | 24108.6 |
1066 | 2025-02-06 03:05:12 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
1065 | 2025-02-04 18:26:09 | pier | 1 | 13983 | 17 | 2.453 | 5700.4 |
1064 | 2025-01-26 20:56:14 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
1063 | 2025-01-26 07:06:59 | pier | 2 | 29872 | 380 | 7.780 | 3839.6 |
1062 | 2025-01-26 00:34:05 | pier | 1 | 13983 | 17 | 0.203 | 68881.8 |
1061 | 2025-01-25 19:42:53 | pier | 2 | 29872 | 380 | 4.220 | 7078.7 |
1060 | 2025-01-25 17:16:10 | pier | 2 | 29872 | 380 | 2.236 | 13359.6 |
1059 | 2025-01-25 09:09:38 | pier | 1 | 13983 | 17 | 0.843 | 16587.2 |
1058 | 2025-01-06 16:08:28 | pier | 1 | 13983 | 17 | 1.250 | 11186.4 |
1057 | 2025-01-05 11:31:39 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
1056 | 2024-12-27 15:03:13 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
1055 | 2024-12-27 13:42:14 | pier | 1 | 13983 | 17 | 1.326 | 10545.2 |
1054 | 2024-12-26 23:01:57 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
1053 | 2024-12-06 13:27:33 | pier | 2 | 29872 | 380 | 4.216 | 7085.4 |
1052 | 2024-12-06 10:45:33 | pier | 1 | 13983 | 17 | 1.110 | 12597.3 |
1051 | 2024-12-06 06:00:31 | pier | 2 | 29872 | 380 | 4.813 | 6206.5 |
1050 | 2024-12-04 17:47:24 | pier | 2 | 29872 | 380 | 1.846 | 16182.0 |
1049 | 2024-12-04 01:17:35 | pier | 2 | 29872 | 380 | 0.920 | 32469.6 |
1048 | 2024-11-27 08:40:17 | pier | 1 | 13983 | 17 | 1.076 | 12995.4 |
1047 | 2024-11-26 16:44:19 | pier | 1 | 13983 | 17 | 0.673 | 20777.1 |
1046 | 2024-11-26 13:51:48 | pier | 2 | 29872 | 380 | 3.970 | 7524.4 |
1045 | 2024-11-26 05:41:31 | pier | 1 | 13983 | 17 | 0.296 | 47239.9 |
1044 | 2024-11-25 15:47:53 | pier | 2 | 29872 | 380 | 2.670 | 11188.0 |
1043 | 2024-11-12 11:00:10 | pier | 1 | 13983 | 17 | 0.406 | 34440.9 |
1042 | 2024-11-06 09:14:07 | pier | 2 | 29872 | 380 | 4.046 | 7383.1 |
1041 | 2024-11-06 07:57:00 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
1040 | 2024-10-28 09:06:03 | pier | 2 | 29872 | 380 | 4.550 | 6565.3 |