History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"combat"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1107 | 2024-12-29 08:05:14 | combat | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 1106 | 2024-12-29 01:19:27 | combat | 1 | 48755 | 3 | 4.563 | 10684.9 |
| 1105 | 2024-12-17 08:44:16 | combat | 3 | 112716 | 398 | 27.860 | 4045.8 |
| 1104 | 2024-12-15 19:37:55 | combat | 3 | 112716 | 398 | 28.783 | 3916.1 |
| 1103 | 2024-12-15 17:38:04 | combat | 3 | 112716 | 398 | 28.376 | 3972.2 |
| 1102 | 2024-12-15 15:44:44 | combat | 3 | 112716 | 398 | 38.990 | 2890.9 |
| 1101 | 2024-12-15 15:44:46 | combat | 2 | 82551 | 42 | 14.516 | 5686.9 |
| 1100 | 2024-12-15 15:44:40 | combat | 1 | 48755 | 3 | 6.173 | 7898.1 |
| 1099 | 2024-12-08 13:40:26 | combat | 1 | 48755 | 3 | 6.063 | 8041.4 |
| 1098 | 2024-12-02 02:10:04 | combat | 1 | 48755 | 3 | 6.343 | 7686.4 |
| 1097 | 2024-11-28 02:11:02 | combat | 1 | 48755 | 3 | 4.063 | 11999.8 |
| 1096 | 2024-11-27 19:41:29 | combat | 1 | 48755 | 3 | 3.343 | 14584.2 |
| 1095 | 2024-11-21 20:58:13 | combat | 2 | 82551 | 42 | 11.110 | 7430.3 |
| 1094 | 2024-11-13 17:47:38 | combat | 1 | 48755 | 3 | 2.250 | 21668.9 |
| 1093 | 2024-11-08 03:37:29 | combat | 2 | 82551 | 42 | 12.890 | 6404.3 |
| 1092 | 2024-11-07 10:23:21 | combat | 2 | 82551 | 42 | 3.310 | 24939.9 |
| 1091 | 2024-11-05 19:45:35 | combat | 2 | 82551 | 42 | 3.940 | 20952.0 |
| 1090 | 2024-11-05 19:45:34 | combat | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 1089 | 2024-10-28 21:45:19 | combat | 3 | 112716 | 398 | 25.580 | 4406.4 |
| 1088 | 2024-10-28 08:13:27 | combat | 1 | 48755 | 3 | 3.956 | 12324.3 |
| 1087 | 2024-10-21 13:18:53 | combat | 1 | 48755 | 3 | 6.390 | 7629.9 |
| 1086 | 2024-10-15 19:11:17 | combat | 3 | 112716 | 398 | 12.750 | 8840.5 |
| 1085 | 2024-10-14 09:57:23 | combat | 3 | 112716 | 398 | 28.330 | 3978.7 |
| 1084 | 2024-10-14 02:38:09 | combat | 3 | 112716 | 398 | 23.913 | 4713.6 |
| 1083 | 2024-10-14 02:38:10 | combat | 2 | 82551 | 42 | 13.003 | 6348.6 |
| 1082 | 2024-10-14 02:37:49 | combat | 1 | 48755 | 3 | 6.203 | 7859.9 |
| 1081 | 2024-10-06 08:02:37 | combat | 1 | 48755 | 3 | 2.970 | 16415.8 |
| 1080 | 2024-09-28 12:13:48 | combat | 1 | 48755 | 3 | 6.186 | 7881.5 |
| 1079 | 2024-09-27 19:11:33 | combat | 1 | 48755 | 3 | 4.833 | 10087.9 |
| 1078 | 2024-09-11 04:03:07 | combat | 2 | 82551 | 42 | 19.733 | 4183.4 |
| 1077 | 2024-09-10 14:48:26 | combat | 2 | 82551 | 42 | 29.883 | 2762.5 |
| 1076 | 2024-09-09 21:06:54 | combat | 3 | 112716 | 398 | 56.020 | 2012.1 |
| 1075 | 2024-09-09 10:09:58 | combat | 3 | 112716 | 398 | 22.550 | 4998.5 |
| 1074 | 2024-09-09 09:26:11 | combat | 3 | 112716 | 398 | 47.596 | 2368.2 |
| 1073 | 2024-09-09 09:26:01 | combat | 2 | 82551 | 42 | 14.923 | 5531.8 |
| 1072 | 2024-09-09 09:25:51 | combat | 1 | 48755 | 3 | 6.550 | 7443.5 |
| 1071 | 2024-09-05 14:49:10 | combat | 1 | 48755 | 3 | 2.906 | 16777.4 |
| 1070 | 2024-09-05 00:51:57 | combat | 1 | 48755 | 3 | 3.576 | 13633.9 |
| 1069 | 2024-09-03 20:00:59 | combat | 1 | 48755 | 3 | 9.940 | 4904.9 |
| 1068 | 2024-08-26 22:44:56 | combat | 1 | 48755 | 3 | 4.140 | 11776.6 |
| 1067 | 2024-08-19 03:18:32 | combat | 1 | 48755 | 3 | 6.406 | 7610.8 |
| 1066 | 2024-08-12 20:31:00 | combat | 1 | 48755 | 3 | 2.890 | 16870.2 |
| 1065 | 2024-08-01 04:14:28 | combat | 3 | 112716 | 398 | 13.686 | 8235.9 |
| 1064 | 2024-08-01 00:52:08 | combat | 3 | 112716 | 398 | 24.750 | 4554.2 |
| 1063 | 2024-07-31 11:30:43 | combat | 3 | 112716 | 398 | 31.113 | 3622.8 |
| 1062 | 2024-07-31 09:42:06 | combat | 3 | 112716 | 398 | 28.533 | 3950.4 |
| 1061 | 2024-07-31 09:42:06 | combat | 2 | 82551 | 42 | 11.986 | 6887.3 |
| 1060 | 2024-07-31 09:41:57 | combat | 1 | 48755 | 3 | 5.373 | 9074.1 |
| 1059 | 2024-07-31 01:13:04 | combat | 1 | 48755 | 3 | 3.300 | 14774.2 |
| 1058 | 2024-07-29 09:02:14 | combat | 1 | 48755 | 3 | 4.516 | 10796.1 |
| 1057 | 2024-07-27 05:27:10 | combat | 1 | 48755 | 3 | 3.063 | 15917.4 |
| 1056 | 2024-07-14 04:12:09 | combat | 1 | 48755 | 3 | 2.686 | 18151.5 |
| 1055 | 2024-07-06 10:44:22 | combat | 1 | 48755 | 3 | 2.153 | 22645.1 |
| 1054 | 2024-07-01 01:30:16 | combat | 1 | 48755 | 3 | 2.220 | 21961.7 |
| 1053 | 2024-06-30 23:51:46 | combat | 1 | 48755 | 3 | 1.516 | 32160.3 |
| 1052 | 2024-06-29 01:47:14 | combat | 1 | 48755 | 3 | 1.750 | 27860.0 |
| 1051 | 2024-06-27 05:28:57 | combat | 1 | 48755 | 3 | 3.780 | 12898.1 |
| 1050 | 2024-06-24 02:01:27 | combat | 1 | 48755 | 3 | 4.173 | 11683.4 |
| 1049 | 2024-06-18 21:17:02 | combat | 1 | 48755 | 3 | 1.500 | 32503.3 |
| 1048 | 2024-06-13 07:44:08 | combat | 1 | 48755 | 3 | 4.190 | 11636.0 |
| 1047 | 2024-05-29 15:09:46 | combat | 1 | 48755 | 3 | 3.110 | 15676.8 |
| 1046 | 2024-05-28 04:23:53 | combat | 1 | 48755 | 3 | 3.970 | 12280.9 |
| 1045 | 2024-05-15 00:22:25 | combat | 1 | 48755 | 3 | 2.576 | 18926.6 |
| 1044 | 2024-05-08 15:02:10 | combat | 2 | 82551 | 42 | 7.376 | 11191.8 |
| 1043 | 2024-05-08 14:52:52 | combat | 3 | 112716 | 398 | 6.670 | 16899.0 |
| 1042 | 2024-05-07 05:19:36 | combat | 2 | 82551 | 42 | 5.453 | 15138.6 |
| 1041 | 2024-05-07 05:18:17 | combat | 3 | 112716 | 398 | 5.923 | 19030.2 |
| 1040 | 2024-05-06 21:05:53 | combat | 2 | 82551 | 42 | 5.376 | 15355.5 |
| 1039 | 2024-05-06 07:40:33 | combat | 3 | 112716 | 398 | 12.813 | 8797.0 |
| 1038 | 2024-05-06 02:21:32 | combat | 2 | 82551 | 42 | 5.860 | 14087.2 |
| 1037 | 2024-05-06 02:21:28 | combat | 3 | 112716 | 398 | 8.813 | 12789.7 |
| 1036 | 2024-05-06 02:21:20 | combat | 3 | 112716 | 398 | 11.750 | 9592.9 |
| 1035 | 2024-05-06 02:21:24 | combat | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 1034 | 2024-05-06 02:21:15 | combat | 2 | 82551 | 42 | 3.610 | 22867.3 |
| 1033 | 2024-05-02 00:44:02 | combat | 1 | 48755 | 3 | 1.813 | 26891.9 |
| 1032 | 2024-04-13 16:47:13 | combat | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 1031 | 2024-04-07 17:42:59 | combat | 3 | 112716 | 398 | 16.220 | 6949.2 |
| 1030 | 2024-04-06 02:53:39 | combat | 3 | 112716 | 398 | 11.343 | 9937.1 |
| 1029 | 2024-04-06 01:31:04 | combat | 2 | 82551 | 42 | 8.376 | 9855.7 |
| 1028 | 2024-04-06 01:25:38 | combat | 1 | 48755 | 3 | 3.080 | 15829.5 |
| 1027 | 2024-04-05 18:55:51 | combat | 3 | 112716 | 398 | 6.530 | 17261.3 |
| 1026 | 2024-04-05 04:11:41 | combat | 3 | 112716 | 398 | 7.516 | 14996.8 |
| 1025 | 2024-04-05 04:11:42 | combat | 2 | 82551 | 42 | 3.360 | 24568.8 |
| 1024 | 2024-04-05 04:11:30 | combat | 3 | 112716 | 398 | 8.690 | 12970.8 |
| 1023 | 2024-04-05 04:11:36 | combat | 1 | 48755 | 3 | 1.863 | 26170.2 |
| 1022 | 2024-04-05 04:11:31 | combat | 2 | 82551 | 42 | 2.673 | 30883.3 |
| 1021 | 2024-04-05 04:11:29 | combat | 1 | 48755 | 3 | 1.063 | 45865.5 |
| 1020 | 2024-03-06 23:18:30 | combat | 1 | 48755 | 3 | 2.080 | 23439.9 |
| 1019 | 2024-03-01 04:16:16 | combat | 2 | 82551 | 42 | 2.643 | 31233.8 |
| 1018 | 2024-03-01 04:15:57 | combat | 3 | 112716 | 398 | 6.966 | 16180.9 |
| 1017 | 2024-02-28 11:49:02 | combat | 3 | 112716 | 398 | 6.736 | 16733.4 |
| 1016 | 2024-02-28 11:49:02 | combat | 2 | 82551 | 42 | 4.280 | 19287.6 |
| 1015 | 2024-02-27 09:11:50 | combat | 2 | 82551 | 42 | 2.606 | 31677.3 |
| 1014 | 2024-02-27 08:28:12 | combat | 3 | 112716 | 398 | 9.826 | 11471.2 |
| 1013 | 2024-02-26 20:14:14 | combat | 3 | 112716 | 398 | 5.250 | 21469.7 |
| 1012 | 2024-02-26 20:14:13 | combat | 2 | 82551 | 42 | 2.686 | 30733.8 |
| 1011 | 2024-02-26 20:14:12 | combat | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 1010 | 2023-12-28 06:15:36 | combat | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 1009 | 2023-12-24 22:40:03 | combat | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 1008 | 2023-12-14 14:21:39 | combat | 3 | 112716 | 398 | 4.843 | 23274.0 |